ERP系统
查看 | 历史 | 提交 | 提交对比
xinyb
2024-04-22 bc82b6b46b695c41a42ff569c33d30800a6aec98
提交 | 用户 | 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));
59               listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request);      
60         }catch(Exception e){
61            throw e;
62         }finally{
63            SpObserver.setDBtoInstance();
64         }
65         if(listInfo.size()>0){
66               docMap=listInfo.get(0);
67         }
68         if((doccode==null||"".equals(doccode))&&listInfo.size()>0){
69                  doccode=DBHelper.getValue(docMap,"doccode");
70         }        
71   }
72   if((isNew!=null&&isNew.equals("0"))||listInfo.size()>0){
73         isNewOpen=0;//不为新开单      
74         docstatePan=DBHelper.getValueInt(docMap,"docstatus");
75   }    
76   JSONObject jsonOldPanel = JSONObject.fromObject(docMap);
77   SqlRowSet SRS =null;
78   String outStr=""; 
79   BuildFuncIfc  build=(BuildFuncIfc)FactoryBean.getBean("Build"); 
80   try{
81         String openDoc="@openDoc@";
82         SpObserver.setDBtoInstance("_"+request.getSession().getAttribute(SessionKey.DATA_BASE_ID));
83         sqlDBHelperIfc.execSql(DBHelper.getProcessAll(openDoc,session,docMap,true));
84   }catch(Exception e){
85         throw e;
86   }finally{
87         SpObserver.setDBtoInstance();
88   }
89 %>  
90 @linkscript@
91 <style type="text/css">
92 .posPan {
93     border: 0px solid #000000;
94     position: absolute;
95     height: @rowHei@px;
96     width: @kongJian@px;
97     font-size: 13px;
98     z-index:0;
99 }
100 .miaoshu_pan {    
101     height: auto;
102     @maoshuF@
103     padding-top:5px;
8a95b3 104     width: 120px;
X 105     /*width: @miaoShuo@px;*/
a6a76f 106     white-space:nowrap;
F 107     overflow:hidden;
108     text-overflow:ellipsis;
109     padding-right:6px;
110     margin-top: -3px;
111 }
112 .control_div{
113    float: left;
114 }
115 .mustThree_show {
116     border:1px solid #ffcf5a;
117     background: #fff url(/images/ppp.gif) no-repeat right;
118 }
119 .Three_show {
120     border:1px solid #a5a6ad;    
121 } 
122 .input35{
123    height:14px;
124 } 
125 .main_talbe {
126     font-family: Verdana, Arial, Vrinda, Tahoma;
127     line-height: 24px;
128     font-size: 12px;
129     color: #666;
130 }
131 .text {
132     border:1px solid #a5a6ad;    
133 }
134 </style>
135 <span onclick="panIndex='@index@'" id="panIndex@index@">
136 <script type="text/javascript">
137   var docstatuPan=<%=docstatePan%>;
138   panIndex="@index@";//需要替换
139   maxCols[panIndex]="@maxCols@";//面板跨列数
140   panMain[panIndex]=clone(panPar);
141   @uploadEditStatusMap@
142   @panInfo@
143   @panelScript@
144   panMain[panIndex].controlUrl="panelControl@formId@.jsp";
145   panMain[panIndex].isNew=null;//是否是新单
146 </script>
147 <%@ include file="/public/template/0/showPan.txt" %>
176200 148 <div class="panelControlDiv">
a6a76f 149     @panelHtml@
F 150 </div>
176200 151 <div class="panelControlDiv">
a6a76f 152     @panelDownHtml@
F 153 </div>
154
155 <script type="text/javascript">
156   @pansetInv@
157   panMain[panIndex].loadSet(<%=docstatePan%>);
158   panMain[panIndex].keyDown('123','null');
159 </script>
160 </span>