提交 | 用户 | 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> |