AccountBrowser.jsp 8.07 KB
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>

<%@ page language="java" contentType="text/html; charset=UTF-8" %> 
<%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ taglib uri="/WEB-INF/weaver.tld" prefix="wea"%>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="xssUtil" class="weaver.filter.XssUtil" scope="page" />
<%
    String name = Util.null2String(request.getParameter("name"));
    String codeName = Util.null2String(request.getParameter("codeName"));
    String accountId = Util.null2String(request.getParameter("accountId"));
    String tableName = Util.null2String(request.getParameter("tableName"));
    
    StringBuffer sqlBuffer = new StringBuffer();
    sqlBuffer.append(" select * from FnaAccountInfo ");
    sqlBuffer.append(" where 1=1 ");
    sqlBuffer.append(" and accountName like ? ");
    sqlBuffer.append(" and codeName like ? ");
    sqlBuffer.append(" and id <> ? ");
    
    String imagefilename = "/images/hdSystem_wev8.gif";
    String titlename = SystemEnv.getHtmlLabelName(388084,user.getLanguage());
    String needfav ="1";
    String needhelp ="";
%>
<HTML>
    <HEAD>
        <LINK REL=stylesheet type=text/css HREF=/css/Weaver_wev8.css>
		<script language="javascript" src="/fna/js/e8Common_wev8.js?r=3"></script>
        <script type="text/javascript">
            <%-- try{
                parent.setTabObjName("<%=SystemEnv.getHtmlLabelName(388084,user.getLanguage())%>");
            }catch(e){
                if(window.console)console.log(e+"-->AccountBrowser.jsp");
            } --%>
          var parentWin = null;
          var dialog = null;
          try{
        	  var parentWin = parent.getParentWindow(window);
          }catch(e){}
        </script>
    </HEAD>
    <BODY>
<div class="zDialog_div_content" style="width:100%;height:100%">
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<FORM name="SearchForm" id="SearchForm" STYLE="margin-bottom:0" action="AccountBrowser.jsp" method="post">
<input type="hidden" id="accountId" name="accountId" value="<%=accountId%>" />
<input type="hidden" id="tableName" name="tableName" value="<%=tableName%>" />
<DIV align=right style="display:none">
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(197,user.getLanguage())+",javascript:document.SearchForm.submit(),_self} " ;
RCMenuHeight += RCMenuHeightStep ;
%>
<BUTTON class=btnSearch accessKey=S type=submit><U>S</U>-<%=SystemEnv.getHtmlLabelName(197,user.getLanguage())%></BUTTON>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(199,user.getLanguage())+",javascript:document.SearchForm.reset(),_self} " ;
RCMenuHeight += RCMenuHeightStep ;
%>
<BUTTON class=btnReset accessKey=T type=reset><U>T</U>-<%=SystemEnv.getHtmlLabelName(199,user.getLanguage())%></BUTTON>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(201,user.getLanguage())+",javascript:btncancel_onclick(),_self} " ;
RCMenuHeight += RCMenuHeightStep ;
%>
<BUTTON class=btn accessKey=1 onclick="window.parent.close()"><U>1</U>-<%=SystemEnv.getHtmlLabelName(201,user.getLanguage())%></BUTTON>
</DIV>

    <table id="topTitle" cellpadding="0" cellspacing="0">
        <tr>
            <td>
            </td>
            <td class="rightSearchSpan" style="text-align:right;">
                <input type=button class="e8_btn_top" onclick="javascript:document.SearchForm.submit();" value="<%=SystemEnv.getHtmlLabelName(197,user.getLanguage())%>"></input>
                <span title="<%=SystemEnv.getHtmlLabelName(826,user.getLanguage()) %>" class="cornerMenu"></span>
            </td>
        </tr>
    </table>
    <wea:layout type="4col">
        <wea:group context='<%=SystemEnv.getHtmlLabelName(15774,user.getLanguage())%>'>
            <wea:item><%=SystemEnv.getHtmlLabelName(387252,user.getLanguage())%></wea:item>
            <wea:item> 
              <input class=inputstyle name=name value="<%=name%>">
            </wea:item>
            <wea:item><%=SystemEnv.getHtmlLabelName(387254,user.getLanguage())%></wea:item>
            <wea:item> 
              <input class=inputstyle name=codeName value="<%=codeName%>">
            </wea:item>
        </wea:group>
    </wea:layout>
    <input class=inputstyle type="hidden" name="sqlwhere" value='<%=xssUtil.put(Util.null2String(request.getParameter("sqlwhere")))%>'>

</FORM>
<TABLE ID=BrowseTable class="BroswerStyle"  cellspacing="1" STYLE="margin-top:0" width="100%">
<TR class=DataHeader>
      <TH width=0% style="display:none"><%=SystemEnv.getHtmlLabelName(388084,user.getLanguage())%></TH>      
      <TH width=40%><%=SystemEnv.getHtmlLabelName(387252,user.getLanguage())%></TH>      
      <TH width=65%><%=SystemEnv.getHtmlLabelName(387254,user.getLanguage())%></TH>
      </tr>
      <TR class=Line><TH colspan="4" ></TH></TR>
<%
int i = 0;
rs.executeQuery(sqlBuffer.toString(), "%" + name + "%", "%" + codeName + "%",accountId);
while(rs.next()){
    String id = Util.null2String(rs.getString("id"));
    String _name = Util.toScreen(rs.getString("accountName"),user.getLanguage());
    String _codeName = Util.null2String(rs.getString("codeName"));
    if(i==0){
        i=1;
%>
<TR class=DataLight>
<%
    }else{
        i=0;
%>
<TR class=DataDark>
<%
}
%>
    <TD style="display:none"><A HREF=#><%=id%></A></TD>
    <TD style="padding:0px 5px 0px 12px"><%=_name%></TD>
    <TD style="padding:0px 5px 0px 12px"><%=_codeName%></TD>
</TR>
<%}
%>

</TABLE>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
</div>
<div id="zDialog_div_bottom" class="zDialog_div_bottom">
    <wea:layout needImportDefaultJsAndCss="false">
        <wea:group context=""  attributes="{'groupDisplay':'none'}">
            <wea:item type="toolbar">
                <input type="button" accessKey=T  id=btncancel value="<%="T-"+SystemEnv.getHtmlLabelName(201,user.getLanguage())%>" id="zd_btn_cancle"  class="zd_btn_cancle" onclick="btncancel_onclick();">
            </wea:item>
        </wea:group>
    </wea:layout>
    <script type="text/javascript">
        jQuery(document).ready(function(){
            resizeDialog(document);
        });
    </script>
</div>

<script type="text/javascript">
var _Label33574 = "<%=SystemEnv.getHtmlLabelName(33574,user.getLanguage()) %>";//正在处理数据,请不要离开该页面,请稍等...
var accountId = "<%=accountId%>";
var tableName = "<%=tableName%>";
jQuery(document).ready(function(){
    jQuery("#BrowseTable").find("tr[class^='Data'][class!='DataHeader']").bind("click",function(){
            var returnjson = {id:$(this).find("td:first").text(),name:$(this).find("td:eq(1)").text()};
            var expAccountId = returnjson.id;
            top.Dialog.confirm("<%=SystemEnv.getHtmlLabelNames("826,388524",user.getLanguage())%>?",
       	        function(){
       				try{
       					openNewDiv_FnaBudgetViewInner1(_Label33574);
       					var _data = "op=imp&accountId="+accountId+"&expAccountId="+expAccountId+"&tableName="+tableName;
       					jQuery.ajax({
       						url:"/fna/mulDimensions/subjectSetting/SubjectSettingOp.jsp", 
       						type:"post", cache:false, processData:false, data:_data, dataType:"json", 
       						success: function do4Success(_json){
       							try{closeNewDiv_FnaBudgetViewInner1();}catch(ex1){}
       							top.Dialog.alert(_json.msg);
       							if(_json.status==1){
       								var parentWin = parent.getParentWindow(window);
   									parentWin.parent.parent.leftframe.do_reAsyncChildNodes(null);
       								parentWin.parent.parent.leftframe.__e8InitTreeSearch();
       								parentWin.closeDialog();
       							}
       						}
       					});
       				}catch(ex0){
       					alert(ex0.message);
       					try{closeNewDiv_FnaBudgetViewInner1();}catch(ex1){}
       				}
       	        }, function(){}
       	    );
        })
    jQuery("#BrowseTable").find("tr[class^='Data'][class!='DataHeader']").bind("mouseover",function(){
            $(this).addClass("Selected")
        })
        jQuery("#BrowseTable").find("tr[class^='Data'][class!='DataHeader']").bind("mouseout",function(){
            $(this).removeClass("Selected")
        })

})


function btncancel_onclick(){
	parentWin.closeDialog();
}
</script>
</BODY></HTML>