ERP系统
查看 | 历史 | 提交 | 提交对比
xinyb
2024-07-17 b18bafa57176ae38541587a97dde3b3da25a1034
提交 | 用户 | 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="net.sf.json.JSONObject"%>
18 <%@page import="com.yc.multiData.SpObserver"%>
19 <%@page import="com.yc.utils.SessionKey"%>
20 <%@page import="com.google.gson.JsonArray"%>
21 <%@page import="com.google.gson.JsonObject"%>
bc82b6 22 <%@page import="com.yc.sdk.shopping.util.SettingKey"%>
X 23 <%@ include file="dataHead.jsp" %>
a6a76f 24 <%
F 25   SqlDBHelperIfc  sqlDBHelperIfc=(SqlDBHelperIfc)FactoryBean.getBean("SqlDBHelper");
26   GfieldApprovedButtonIfc gButtonIfc=(GfieldApprovedButtonIfc)FactoryBean.getBean("GfieldApprovedButton");
27   PanelTimeDao PanelTimeBo=(PanelTimeDao)FactoryBean.getBean("PanelTime");
28   PanelManageDao PanelManageBo=(PanelManageDao)FactoryBean.getBean("PanelManage");
29   TypeControlDao TypeControlBo=(TypeControlDao)FactoryBean.getBean("TypeControl");
30   //pengbei
31   request.setCharacterEncoding("UTF-8");
32   response.setCharacterEncoding("UTF-8");
33   String sql = "";
34   String path = request.getContextPath();
35   String basePath = SettingKey.getHostUrl(request) + path + "/";
36   Date now=new Date();
37   SimpleDateFormat formatDate=new SimpleDateFormat("yyyy-MM-dd");
38   String date=String.valueOf(now.getDate());
39   int isNewOpen=1;
40   int docstatePan=0;
41   String tableIs="@zhu@";
42   String tableIs2="@minxi@";
43   Map<String,Object> docMap=new HashMap<String,Object>();
44   List<Map<String, Object>> listInfo=new ArrayList<Map<String, Object>>();
45   String addUrl="";//添加传给grid的条件，需要分离
46   if((wherePan!=null&&!wherePan.equals(""))||grid!=null){
47         if(wherePan.indexOf("@G@")!=-1){
48               int inds=wherePan.indexOf("@G@");
49               String temp1=wherePan;
50                wherePan=temp1.substring(0,inds);
51                addUrl = " and "+temp1.substring(inds+3);
52         }                  
53         try{
54               sql="select top 1 @selectColAll@ from ";//只能查一条
55               if(doccode!=null && sql.contains("&doccode&")){//by danaus 2011-1-25
56                       sql=sql.replaceAll("&doccode&",doccode.replaceAll("'",""));
57               }
58               SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
b18baf 59 //              listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request);//注释原因：调用下面的方法进行排序处理 xin 2024-7-17 15:12:33
X 60             listInfo=PanelManageBo.getFromEndOrder(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formId@,@formType@,request,response);
a6a76f 61         }catch(Exception e){
F 62            throw e;
63         }finally{
64            SpObserver.setDBtoInstance();
65         }
66         if(listInfo.size()>0){
67               docMap=listInfo.get(0);
68         }
69         if((doccode==null||"".equals(doccode))&&listInfo.size()>0){
70                  doccode=DBHelper.getValue(docMap,"doccode");
71         }        
72   }
73   if((isNew!=null&&isNew.equals("0"))||listInfo.size()>0){
74         isNewOpen=0;//不为新开单      
75         docstatePan=DBHelper.getValueInt(docMap,"docstatus");
76   }    
77   JSONObject jsonOldPanel = JSONObject.fromObject(docMap);
78   SqlRowSet SRS =null;
79   String outStr=""; 
80   BuildFuncIfc  build=(BuildFuncIfc)FactoryBean.getBean("Build"); 
81   try{
82         String openDoc="@openDoc@";
83         SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
84         sqlDBHelperIfc.execSql(DBHelper.getProcessAll(openDoc,session,docMap,true));
85   }catch(Exception e){
86         throw e;
87   }finally{
88         SpObserver.setDBtoInstance();
89   }
90 %>  
91 @linkscript@
92 <style type="text/css">
93 .posPan {
94     border: 0px solid #000000;
95     position: absolute;
96     height: @rowHei@px;
97     width: @kongJian@px;
98     font-size: 13px;
99     z-index:0;
100 }
101 .miaoshu_pan {    
102     height: auto;
103     @maoshuF@
104     padding-top:5px;
8a95b3 105     width: 120px;
X 106     /*width: @miaoShuo@px;*/
a6a76f 107     white-space:nowrap;
F 108     overflow:hidden;
109     text-overflow:ellipsis;
110     padding-right:6px;
111     margin-top: -3px;
112 }
113 .control_div{
114    float: left;
115 }
116 .mustThree_show {
117     border:1px solid #ffcf5a;
118     background: #fff url(/images/ppp.gif) no-repeat right;
119 }
120 .Three_show {
121     border:1px solid #a5a6ad;    
122 } 
123 .input35{
124    height:14px;
125 } 
126 .main_talbe {
127     font-family: Verdana, Arial, Vrinda, Tahoma;
128     line-height: 24px;
129     font-size: 12px;
130     color: #666;
131 }
132 .text {
133     border:1px solid #a5a6ad;    
134 }
135 </style>
136 <span onclick="panIndex='@index@'" id="panIndex@index@">
137 <script type="text/javascript">
138   var docstatuPan=<%=docstatePan%>;
139   panIndex="@index@";//需要替换
140   maxCols[panIndex]="@maxCols@";//面板跨列数
141   panMain[panIndex]=clone(panPar);
142   @uploadEditStatusMap@
143   @panInfo@
144   @panelScript@
145   panMain[panIndex].controlUrl="panelControl@formId@.jsp";
146   panMain[panIndex].isNew=null;//是否是新单
147 </script>
148 <%@ include file="/public/template/0/showPan.txt" %>
176200 149 <div class="panelControlDiv">
a6a76f 150     @panelHtml@
F 151 </div>
176200 152 <div class="panelControlDiv">
a6a76f 153     @panelDownHtml@
F 154 </div>
155
156 <script type="text/javascript">
157   @pansetInv@
158   panMain[panIndex].loadSet(<%=docstatePan%>);
159   panMain[panIndex].keyDown('123','null');
160 </script>
161 </span>