ERP系统
查看 | 历史 | 提交 | 提交对比
xinyb
2024-03-27 f87909326c2ff2c58da027163f64d9d8f9424b17
提交 | 用户 | age
a6a76f 1 <%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> 
F 2 <%@page import="java.text.SimpleDateFormat"%>
3 <%@page import="com.yc.service.impl.EnvHelper"%>
4 <%@page import="com.yc.service.impl.DBHelper"%>
5 <%@page import="com.yc.service.build.BuildFuncIfc"%>
6 <%@page import="org.springframework.jdbc.support.rowset.SqlRowSet"%>
7 <%@page import="com.yc.factory.FactoryBean"%>
8 <%@page import="com.yc.service.panel.TypeControlDao"%>
9 <%@page import="com.yc.service.panel.time.PanelTimeDao"%>
10 <%@page import="com.yc.service.panel.PanelManageDao"%>
11 <%@page import="com.yc.service.panel.GfieldApprovedButtonIfc"%>
12 <%@page import="com.yc.service.panel.SqlDBHelperIfc"%>
13 <%@page import="com.yc.service.upload.AttachmentIfc"%>
14 <%@page import="com.yc.entity.attachment.AttachmentEntity"%>
15 <%@page import="com.yc.utils.DefaultSet" %>
16 <%@page import="net.sf.json.JSONObject"%>
17 <%@page import="com.yc.sdk.shopping.util.SettingKey"%>
f87909 18 <%@ include file="dataHead.jsp" %>
a6a76f 19 <%
F 20    SqlDBHelperIfc  sqlDBHelperIfc=(SqlDBHelperIfc)FactoryBean.getBean("SqlDBHelper");
21    GfieldApprovedButtonIfc gButtonIfc=(GfieldApprovedButtonIfc)FactoryBean.getBean("GfieldApprovedButton");
22    PanelTimeDao PanelTimeBo=(PanelTimeDao)FactoryBean.getBean("PanelTime");
23    PanelManageDao PanelManageBo=(PanelManageDao)FactoryBean.getBean("PanelManage");
24    TypeControlDao TypeControlBo=(TypeControlDao)FactoryBean.getBean("TypeControl");
25    //pengbei
26    request.setCharacterEncoding("UTF-8");
27    response.setCharacterEncoding("UTF-8");
28    String sql = "";
29    String path = request.getContextPath();
30    String basePath = SettingKey.getHostUrl(request) + path + "/";
31    Date now=new Date();
32    SimpleDateFormat formatDate=new SimpleDateFormat("yyyy-MM-dd");
33    String date=String.valueOf(now.getDate());
34    int isNewOpen=1;
35    int docstatePan=0;
36    String tableIs="@zhu@";
37    String tableIs2="@minxi@";
38    Map<String,Object> docMap=new HashMap<String,Object>();
39    List<Map<String, Object>> listInfo=null;
40    String addUrl="";//添加传给grid的条件，需要分离
41    if((wherePan!=null&&!wherePan.equals(""))||grid!=null){
42              if(wherePan.indexOf("@G@")!=-1){
43                    int inds=wherePan.indexOf("@G@");
44                    String temp1=wherePan;
45                     wherePan=temp1.substring(0,inds);
46                     addUrl = " and "+temp1.substring(inds+3);
47              }                  
48              try{
49                    sql="select top 1 @selectColAll@ from ";//只能查一条
50                    if(doccode!=null && sql.contains("&doccode&")){//by danaus 2011-1-25
51                           sql=sql.replaceAll("&doccode&",doccode.replaceAll("'",""));
52                    }
53                    listInfo=PanelManageBo.getFromEnd(sql,tableIs,(wherePan==null?wherePan:wherePan.replaceAll("_ycid_","id")),@formType@,request);      
54              }catch(Exception e){
55                    listInfo=PanelManageBo.getFromEnd(sql,tableIs2,wherePan,@formType@,request);
56                       try{
57                           if(doccode!=null && sql.contains("&doccode&")){//by danaus 2011-1-25
58                             sql=sql.replaceAll("&doccode&",doccode.replaceAll("'",""));
59                        }
60                           listInfo=sqlDBHelperIfc.getHashMapObj(sql.replaceAll("_ycid_","id"));
61                       }catch(Exception ex){
62                           listInfo=new ArrayList<Map<String, Object>>();
63                           //数据库乱设置时不显示页面，直接清空信息，或者不是乱设置，却不能用来查询，也清空信息
64                       }
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")){
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    String openDoc="@openDoc@";
82    sqlDBHelperIfc.execSql(DBHelper.getProcessAll(openDoc,session,docMap,true));
83 %>  
84 @linkscript@
85 <style type="text/css">
86 .posPan {
87     border: 0px solid #000000;
88     position: absolute;
89     height: @rowHei@px;
90     width: @kongJian@px;
91     font-size: 13px;
92     z-index:0;
93 }
94 .miaoshu_pan {    
95     height: auto;
96     @maoshuF@
97     padding-top:5px;
98     width: @miaoShuo@px;    
99     white-space:nowrap;
100     overflow:hidden;
101     text-overflow:ellipsis;
102 }
103 .control_div{
104    float: left;
105 }
106 .bilu{
107   color: #FF0000;
108 }
109 .mustThree_show {
110     border:1px solid #ffcf5a;
111     background: #fff url(/images/ppp.gif) no-repeat right;
112 }
113 .Three_show {
114     border:1px solid #a5a6ad;    
115 } 
116 .input35{
117    height:14px;
118 } 
119 table {
120     font-family: Verdana, Arial, Vrinda, Tahoma;
121     line-height: 24px;
122     font-size: 12px;
123     color: #666;
124 }
125 .text {
126     border:1px solid #a5a6ad;    
127 }
128 </style>