ERP系统
查看 | 历史 | 提交 | 提交对比
xinyb
2024-03-27 f87909326c2ff2c58da027163f64d9d8f9424b17
提交 | 用户 | age
a6a76f 1 <%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"
F 2     pageEncoding="UTF-8"%> 
3 <%@page import="java.text.SimpleDateFormat"%>
4 <%@page import="com.yc.service.impl.EnvHelper"%>
5 <%@page import="com.yc.service.impl.DBHelper"%>
6 <%@page import="com.yc.service.build.BuildFuncIfc"%>
7 <%@page import="org.springframework.jdbc.support.rowset.SqlRowSet"%>
8 <%@page import="com.yc.factory.FactoryBean"%>
9 <%@page import="com.yc.service.panel.TypeControlDao"%>
10 <%@page import="com.yc.service.panel.time.PanelTimeDao"%>
11 <%@page import="com.yc.service.panel.PanelManageDao"%>
12 <%@page import="com.yc.service.panel.GfieldApprovedButtonIfc"%>
13 <%@page import="com.yc.service.panel.SqlDBHelperIfc"%>
14 <%@page import="com.yc.service.upload.AttachmentIfc"%>
15 <%@page import="com.yc.entity.attachment.AttachmentEntity"%>
16 <%@page import="com.yc.utils.DefaultSet" %>
17 <%@page import="java.sql.SQLException"%>
18 <%@page import="net.sf.json.JSONObject"%>
19 <%@page import="org.springframework.jdbc.BadSqlGrammarException"%>
20 <%@page import="com.yc.multiData.SpObserver"%>
21 <%@page import="com.yc.utils.SessionKey"%>
22 <%@page import="com.google.gson.JsonArray"%>
23 <%@page import="com.google.gson.JsonObject"%>
24 <%@page import="com.yc.sdk.shopping.util.SettingKey"%>
f87909 25 <%@ include file="dataHead.jsp" %>
a6a76f 26 <%
F 27 //
28 SqlDBHelperIfc  sqlDBHelperIfc=(SqlDBHelperIfc)FactoryBean.getBean("SqlDBHelper");
29 //
30 GfieldApprovedButtonIfc gButtonIfc=(GfieldApprovedButtonIfc)FactoryBean.getBean("GfieldApprovedButton");
31 //
32 PanelTimeDao PanelTimeBo=(PanelTimeDao)FactoryBean.getBean("PanelTime");
33 //
34 PanelManageDao PanelManageBo=(PanelManageDao)FactoryBean.getBean("PanelManage");
35 //
36 TypeControlDao TypeControlBo=(TypeControlDao)FactoryBean.getBean("TypeControl");
37 //pengbei
38 request.setCharacterEncoding("UTF-8");
39 response.setCharacterEncoding("UTF-8");
40 String sql = "";
41 String path = request.getContextPath();
42 String basePath = SettingKey.getHostUrl(request)
43             + path + "/";
44 Date now=new Date();
45 SimpleDateFormat formatDate=new SimpleDateFormat("yyyy-MM-dd");
46     String date=String.valueOf(now.getDate());
47   int isNewOpen=1;
48    int docstatePan=0;
49    String tableIs="@zhu@";
50    String tableIs2="@minxi@";
51       Map<String,Object> docMap=new HashMap<String,Object>();
52       List<Map<String, Object>> listInfo=new ArrayList<Map<String, Object>>();
53        String addUrl="";//添加传给grid的条件，需要分离
54        if((wherePan!=null&&!wherePan.equals(""))||grid!=null){
55        //wherePan=java.net.URLDecoder.decode(wherePan,"utf-8");
56         if(wherePan.indexOf("@G@")!=-1){
57        int inds=wherePan.indexOf("@G@");
58        String temp1=wherePan;
59         wherePan=temp1.substring(0,inds);
60         addUrl = " and "+temp1.substring(inds+3);
61         }                  
62       try{
63          sql="select top 1 @selectColAll@ from ";//只能查一条
64          if(sql.contains("&doccode&")){//by danaus 2011-1-25
65          if(doccode!=null)
66          sql=sql.replaceAll("&doccode&",doccode.replaceAll("'",""));
67          }
68          SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
69         listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request);      
70       }catch(Exception e){
71           throw e;
72    //    sql="select top 1 @selectColAll@ from "+tableIs2+" where "+wherePan; 
73  //       try{
74    //       if(sql.contains("&doccode&")){//by danaus 2011-1-25
75     //     if(doccode!=null)
76     //     sql=sql.replaceAll("&doccode&",doccode.replaceAll("'",""));
77     //     }
78    //     listInfo=sqlDBHelperIfc.getHashMapObj(sql.replaceAll("_ycid_","id"));
79           //}catch(Exception ex){
80    //        listInfo=new ArrayList<Map<String, Object>>();
81   //         //数据库乱设置时不显示页面，直接清空信息，或者不是乱设置，却不能用来查询，也清空信息
82    //        }
83        }finally{
84            SpObserver.setDBtoInstance();
85        }
86        if(listInfo.size()>0){
87        docMap=listInfo.get(0);}
88        if((doccode==null||"".equals(doccode))&&listInfo.size()>0){
89          doccode=DBHelper.getValue(docMap,"doccode");
90        }
91        
92     }
93 if((isNew!=null&&isNew.equals("0"))||listInfo.size()>0){
94   isNewOpen=0;//不为新开单      
95   docstatePan=DBHelper.getValueInt(docMap,"docstatus");
96 }    
97 JSONObject jsonOldPanel = JSONObject.fromObject(docMap);
98
99     SqlRowSet SRS =null;
100     String outStr=""; 
101     BuildFuncIfc  build=(BuildFuncIfc)FactoryBean.getBean("Build"); 
102     try{
103     String openDoc="@openDoc@";
104     SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
105     sqlDBHelperIfc.execSql(DBHelper.getProcessAll(openDoc,session,docMap,true));
106 }catch(Exception e){
107     throw e;
108 }finally{
109      SpObserver.setDBtoInstance();
110 }
111 %>  
112 @linkscript@
113 <style type="text/css">
114 .posPan {
115     border: 0px solid #000000;
116     position: absolute;
117     height: @rowHei@px;
118     width: @kongJian@px;
119     font-size: 13px;
120     z-index:0;
121 }
122 .miaoshu_pan {    
123     height: auto;
124     @maoshuF@
125     padding-top:5px;
126     width: @miaoShuo@px;    
127     white-space:nowrap;
128     overflow:hidden;
129     text-overflow:ellipsis;
130     padding-right:6px;
131     margin-top: -3px;
132 }
133 .control_div{
134    float: left;
135 }
136 .mustThree_show {
137     border:1px solid #ffcf5a;
138     background: #fff url(/images/ppp.gif) no-repeat right;
139 }
140 .Three_show {
141     border:1px solid #a5a6ad;    
142 } 
143 .input35{
144    height:14px;
145 } 
146 .main_talbe {
147     font-family: Verdana, Arial, Vrinda, Tahoma;
148     line-height: 24px;
149     font-size: 12px;
150     color: #666;
151 }
152 .text {
153     border:1px solid #a5a6ad;    
154 }
155 .panel_table{
156     width:96%;
157     table-layout: fixed;
158     margin-left: 10px;
159 }
160 .panel_table_td{
161     word-break: break-word;
162     font-size: 13px;
163     padding:3px;
164     border-right-style:none;
165     border-left-style:none;
166     border-top-style:none;
167     border-bottom-style:none;
168 }
169 </style>
170 <span onclick="panIndex='@index@'" id="panIndex@index@">
171 <script type="text/javascript">
172 var docstatuPan=<%=docstatePan%>;
173 panIndex="@index@";//需要替换
174 maxCols[panIndex]="@maxCols@";//面板跨列数
175 panMain[panIndex]=clone(panPar);
176 @uploadEditStatusMap@
177 @panInfo@
178 @panelScript@
179 panMain[panIndex].controlUrl="panelControl@formId@.jsp";
180 panMain[panIndex].isNew=<%=isNew%>;//是否是新单
181 </script>
182 <%@ include file="/public/template/0/showPan.txt" %>
176200 183 <div class="panelControlDiv">
a6a76f 184     @panelHtml@
F 185 </div>
176200 186 <div class="panelControlDiv">
a6a76f 187     @panelDownHtml@
F 188 </div>
189 <script type="text/javascript">
190 @pansetInv@
191 panMain[panIndex].loadSet(<%=docstatePan%>);
192 panMain[panIndex].keyDown('123','null');
193 </script>
194 </span>