xinyb
2024-03-27 f87909326c2ff2c58da027163f64d9d8f9424b17
提交 | 用户 | age
a6a76f 1 <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
F 2 <%@page import="com.yc.factory.FactoryBean"%>
3 <%@page import="com.yc.service.commons.GfieldIfc"%>
4 <%@page import="java.util.List"%>
5 <%@page import="java.util.Map"%>
6 <%@page import="com.google.gson.Gson"%>
7 <%@page import="com.google.gson.reflect.TypeToken"%>
8 <%@page import="com.yc.service.build.top.BuildTopIfc"%>
9 <%@page import="org.springframework.web.context.WebApplicationContext"%>
10 <%@page import="org.springframework.web.context.support.WebApplicationContextUtils"%>  
11 <% 
12   //跟据功能号查询,查询DIV页面须要的字段
13   GfieldIfc gfieldIfc = (GfieldIfc)FactoryBean.getBean("GfieldImpl");
14   StringBuilder sb = new StringBuilder();
15   List<Map<String,Object>> list =null;
16   try{
17        com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
18        list=gfieldIfc.getAllowQueryFields(formId);
19   }catch(Exception e){
20        throw e;
21      //out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"')</script>");
22      //return;
23   }finally{
24        com.yc.multiData.SpObserver.setDBtoInstance();
25   }    
26   Gson gson = new Gson();
27   String t = gson.toJson(list,new TypeToken<List<Map<String,Object>>>(){}.getType());
28   sb.append(t);
29   sb.insert(0,"{rows:");
30   sb.append("}");
31   StringBuilder printLink = new StringBuilder();//打印下来按钮
32   StringBuilder printButton = new StringBuilder();//打印button按钮
33   StringBuilder funcLink = new StringBuilder();//链接下拉按钮
34   StringBuilder funcLinkButton = new StringBuilder();//链接button按钮
35   String _1 = "1".intern(); //标识1
36   boolean printHasExpression = [?printHasExpression];//是否有表达式
37   //boolean linkHasExpression = [?linkHasExpression];//是否有表达式
38   if(printHasExpression){//有表达式拼装sql
39         String reportSql = "[?getReportSQL]";
40         reportSql = com.yc.utils.RequestParameterUtils.replaceRequestExpression(reportSql,request,session);
41           List<Map<String,Object>> reportInfo =null;
42           try{
43                com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
44                reportInfo=sqlQueryIfc.queryForList(reportSql,null);//打印链接信息
45                com.yc.service.build.top.PrintLinkSpellUtils.spellPrintLink(reportInfo,formId,formType,printLink,printButton);
46           }catch(Exception e){
47                throw new Exception(e.getMessage().replace("'","\\'")+"-打印设置表达式有错误!");
48             //out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"-打印设置表达式有错误!')</script>");
49             //return;
50         }finally{
51               com.yc.multiData.SpObserver.setDBtoInstance();
52         }
53   }
54   String notExpressionFuncLink="[?notExpressionFuncLink]";
55   String notExpressionFuncLinkButton="[?notExpressionFuncLinkButton]";
56   WebApplicationContext wac = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
57   BuildTopIfc buildTopIfc = (BuildTopIfc)wac.getBean("BuildTopImpl");
58   Map<String,Object> map =null;
59   try{
60         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
61         map=buildTopIfc.buildFuncLinkExpression(formId,formType,doccode,request,session,notExpressionFuncLink,notExpressionFuncLinkButton);
62   }catch(Exception e){
63         throw new Exception(e.getMessage().replace("'","\\'")+"-功能链接设置表达式有错误!");
64      // out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"-功能链接设置表达式有错误!')</script>");
65       //return;
66   }finally{
67         com.yc.multiData.SpObserver.setDBtoInstance();
68   }
69 %>
70 <script type="text/javascript">
71 var data = <%=sb.toString() %>;
72 var reportprompts="[?reportprompts]";
73 </script>
74 <div id="func">
75     <%if(map.size()>0){ %>
76     <%=map.get("funcLink").toString() %>
77     <%} %>
78 </div>
79 <div id="print">
80     <%if(printHasExpression){ %>
81         <%=printLink %>
82       <%}else{ %>
83         [?printLink]
84     <%}if(_1==isSuperUser){ %>
85     <div id="otherFormats" >其他格式</div>
86     <%} %>
87 </div>
88 [?TopBigTitle]
89 <div id="tool">
90         <%if((profile&FormOpUtil.openQuery)>0){%>
91         <a id="selectinfo" onmousedown="select();" class="easyui-linkbutton"
92     plain="true" iconCls="icon-search">搜索</a>
93         <%}%>
94         <img height="29px" src="/images/space.jpg" align="top"/>
95         <% if((profile&FormOpUtil.saveRecord)>0){%>
96         <a id="tpSave" class="easyui-linkbutton" plain="true" iconCls="icon-save" onclick="save();">保存</a>
97         <%}%>
98
99         <a id="tpselect"  class="easyui-linkbutton"  plain="true" iconCls="icon-select">选择</a>
100         <img height="29px" src="/images/space.jpg" align="top"/>
101
102         <a class="easyui-linkbutton" id="showRestmenuDiv"  onclick="moreSelect();"  iconCls="icon-down" onblur="restmenuclose();" 
103     plain="true">更多</a> 
104     
105     <a id="bhelp" href="javascript:openHelpPage('[?title]');"  class="easyui-linkbutton"  plain="true" iconCls="icon-help">帮助</a>
106     
107
108         <%
109         ////打印链接
110         if((profile&FormOpUtil.printButton)>0){
111         if(printHasExpression){ %>
112             <%=printButton %>
113           <%}else{ %>
114             [?printButton]
115         <%}
116         }
117         ////////功能链接
118         %>
119             <%if(map.get("funcLinkButton").toString().length()>0){  %>
120           <%=map.get("funcLinkButton") %>
121           <%} %>
122           <div id="tpUpDownDoc">
f87909 123               <a href="javascript:editCustomControl();" class="easyui-linkbutton first" plain="true" title='自定义控件布局' iconCls="icon-scok">布局</a>
34fadb 124          <a href="javascript:refresh();"  class="easyui-linkbutton" plain="true" title='刷新(Alt+R)' iconCls="icon-reload">刷新</a>
a6a76f 125          </div>
F 126 </div>
127
128 <div id="selectDiv" style="width:520px;height:490px;left: 1px;top:30px;" class="easyui-window" collapsible="false" minimizable="false" maximizable="false" title="搜索" closed="true">
129     <div class="easyui-tabs" border="true" style="width:500px;height:450px;">
130         <div id="generalQuery" title="简单查询" fit="true" border="true" style="padding:0px;">
131         <div style="margin-left:20px;width: 450px;height: 150px;float: left;">
132                     <div>&nbsp;</div>
133                         输入查询内容:<input id="queryValue" type="text" style="border: 1px solid #cccccc;width: 300px;"/><br><br><br><br>
134                         <div align="center"><a iconCls="icon-ok" class="easyui-linkbutton" onclick="selectSimpConfirm();">确 定</a>&nbsp;
135                         <a iconCls="icon-cancel" class="easyui-linkbutton" onclick="windowClose();">关 闭</a></div>
136                     </div>
137                     <div style="margin-left:20px;margin-top:10px;width:450px;font-weight: bold;color: #666666;float: left;">
138                         可查询字段:<br></br>
139                         <%
140                         Map<String,Object> temp = null;
141                         for(int i=0;i<list.size();i++){ 
142                             temp = list.get(i);
143                         %>
144                             <div class="queryField" field="<%=temp.get("fieldid") %>"><%=temp.get("fieldname") %></div>
145                         <%} %>
146                     </div>                    
147         </div>
148         <div id="advancedQuery" title="高级查询" style="padding:0px;">
149              <div id="query">
150                 <table id="tt" style="width:495px;height:380px;border-bottom: 1px solid;" border="false" singleSelect="true" >
151                     <thead>
152                         <tr>
153                             <th field="fieldid" width="80" hidde="true">ID</th>
154                             <th field="cont" width="60" formatter="contFormatter" align=center editor="{type:'combobox',options:{valueField:'contid',textField:'text',data:cont,editable:false}}" >连接符</th>
155                             <th field="fieldname" width="100" >字段名</th>
156                             <th field="opt" formatter="opttFormatter"  editor="{type:'combobox',options:{valueField:'opid',textField:'text',data:opts,editable:false,onChange:optSelect}}" width="80" >比较符</th>
157                             <th field="opt2" formatter="opt2Formatter" width="10" align="center" ></th>
158                             <th field="fieldvalue1"  width="95" editor="{type:'text'}">字段值</th>
159                             <th field="fieldvalue2" width="95" editor="{type:'text'}">字段值2</th>
160                         </tr>
161                    </thead>
162                </table>
163                <div    style="100%;margin-left:20px;">
164                        <br /><label for="more">更多选项</label><input id="more" type="checkbox" />
165                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a iconCls="icon-ok" class="easyui-linkbutton" onclick="selectSimpConfirm2();">确 定</a>&nbsp;
166                     <a iconCls="icon-cancel" class="easyui-linkbutton" onclick="windowClose();">关 闭</a>
167                </div>
168             </div>
169         </div>
170     </div>
171 </div>
172 <div class="easyui-window" style="width:auto;height:auto;background-color:#DEEDF7;" id="restmenuDiv"
173 collapsible="false" draggable="false" minimizable="false" maximizable="false" title="更多" closed="true" >
174 <table width="520px">
175 <%if(map.get("funcLink").toString().length()>0){  %>
176 <tr >
177     <td width="80px;" style="font-size: 13px;"><strong>功能链接:</strong></td>
178     <td style="font-size: 13px;">
179     <%=map.get("funcLink") %>
180     </td>
181     
182 </tr>
183 <%} %>
184
185 <% if(((profile&FormOpUtil.printButton)>0&&[?printLinkLength]>0)||printLink.length()>0||_1==isSuperUser){%>
186 <tr>
187     <td width="80px" style="font-size: 13px;"><strong>打印格式:</strong></td>
188     <td style="font-size: 13px;">
189         <%if(printHasExpression){ %>
190                 <%=printLink %>
191           <%}else{ %>
192             [?printLink]
193         <%}if(_1==isSuperUser){%>
194             <div style="width:80px;display:inline;cursor:pointer" id="otherFormat">其他格式</div>
195         <%} %>
196     </td>
197 </tr>
198
199 <%}
200   List<Map<String, Object>> exportList =null;
201   StringBuilder sb1 = new StringBuilder();
202   try{
203         com.yc.multiData.SpObserver.setDBtoInstance("_"+session.getAttribute(SessionKey.DATA_BASE_ID));
204         exportList=gfieldIfc.getExportInfo(formId);        
205         com.yc.service.build.top.ExportSpellUtils.spellLink(exportList, sb1,profile);
206   }catch(Exception e){
207         throw e;
208     //out.println("<script>alert('"+e.getMessage().replace("'","\\'")+"')</script>");
209  }finally{
210         com.yc.multiData.SpObserver.setDBtoInstance();
211  }        
212  if(sb1.length()>0){ %>
213 <tr>
c81e3f 214     <td width="80px" style="font-size: 13px;"><strong>导入导出:<strong></td>
a6a76f 215     <td><%out.print(sb1.toString());%></td>
F 216 </tr>
217 <%} %>
218 </table>
219 </div>
220 <%_1 = null;
221 printLink=null;
222 printButton=null;
223 funcLink=null;
224 funcLinkButton=null;
225 %>
226