ReportConfirmOperation.jsp
6.27 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<%@ page language="java" contentType="text/html; charset=GBK" %> <%@ include file="/systeminfo/init.jsp" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="rs2" class="weaver.conn.RecordSet" scope="page" />
<%
String operation = Util.null2String(request.getParameter("operation"));
String confirmid = Util.null2String(request.getParameter("confirmid"));
String thetable = Util.null2String(request.getParameter("thetable"));
String inputid = Util.null2String(request.getParameter("inputid"));
String inputmodid = Util.null2String(request.getParameter("inputmodid"));
String inprepid = Util.null2String(request.getParameter("inprepid"));
String thedate = Util.null2String(request.getParameter("thedate"));
String usertitle = "" + Util.getIntValue(user.getTitle(), 0) ;
String inprepbudget = Util.null2String(request.getParameter("inprepbudget"));
if(operation.equals("edit")){
Hashtable ht = new Hashtable() ;
Hashtable ht_mod = new Hashtable() ; // 修正中的数据
Enumeration eu = request.getParameterNames() ;
while(eu.hasMoreElements() ) {
String keyname = (String)eu.nextElement() ;
String keyvalue = Util.null2String(request.getParameter(keyname)) ;
double keyvaluedouble = Util.getDoubleValue(keyvalue , 0) ;
if(keyname.indexOf("_mod") < 0) ht.put(keyname , ""+keyvaluedouble) ; // 非修正中的数据
else ht_mod.put(keyname.substring(0,keyname.length()-4) , ""+keyvaluedouble) ; // 修正中的数据
}
String sql = "" ;
String sqlmod = "" ;
RecordSet.executeProc("T_IRItem_SelectByInprepid",inprepid);
while (RecordSet.next()) {
String itemfieldname = Util.null2String(RecordSet.getString("itemfieldname")) ;
String itemfieldtype = Util.null2String(RecordSet.getString("itemfieldtype")) ;
String itemgongsi = Util.null2String(RecordSet.getString("itemgongsi")) ;
String inputablefact = Util.null2String(RecordSet.getString("inputablefact")) ; // 实际是否可输入
String inputablebudg = Util.null2String(RecordSet.getString("inputablebudg")) ; // 预算是否可输入
String inputablefore = Util.null2String(RecordSet.getString("inputablefore")) ; // 预测是否可输入
String inputable = inputablefact ;
if(inprepbudget.equals("1")) inputable = inputablebudg ;
else if(inprepbudget.equals("2")) inputable = inputablefore ;
if(sql.equals("")) {
sql = " update " + thetable + " set "+ itemfieldname +" = " ;
}
else {
sql += ","+itemfieldname+"=" ;
}
String itemvalue = "" ;
if(itemfieldtype.equals("2")) itemvalue = "" + Util.getIntValue(request.getParameter(itemfieldname),0);
else if(itemfieldtype.equals("3") || (itemfieldtype.equals("5") && inputable.equals("1")) ) itemvalue = "" + Util.getDoubleValue(request.getParameter(itemfieldname),0);
else if(itemfieldtype.equals("5") && !inputable.equals("1") ) {
String thesql = Util.fillValuesToString(itemgongsi, ht) ;
rs2.executeSql(" select " + thesql +" as result ") ;
if(rs2.next()) itemvalue = ""+Util.getDoubleValue(rs2.getString(1),0) ;
else itemvalue = "0" ;
}
else itemvalue = Util.null2String(request.getParameter(itemfieldname));
if(itemfieldtype.equals("2") || itemfieldtype.equals("3") || itemfieldtype.equals("5") ) {
sql += itemvalue ;
}
else {
sql += "'" + Util.fromScreen2(itemvalue,user.getLanguage()) + "'" ;
}
if(itemfieldtype.equals("2") || itemfieldtype.equals("3") || itemfieldtype.equals("5") ) {
if(sqlmod.equals("")) {
sqlmod = " update " + thetable + " set "+ itemfieldname +" = " ;
}
else {
sqlmod += ","+itemfieldname+"=" ;
}
itemvalue = Util.null2String(request.getParameter(itemfieldname+"_mod"));
if(itemfieldtype.equals("2")) {
sqlmod += Util.getIntValue(itemvalue,0) ;
}
else if(itemfieldtype.equals("3") || (itemfieldtype.equals("5") && inputable.equals("1")) ) {
sqlmod += Util.getDoubleValue(itemvalue,0) ;
}
else if(itemfieldtype.equals("5") && !inputable.equals("1") ) {
String thesql = Util.fillValuesToString(itemgongsi, ht_mod) ;
rs2.executeSql(" select " + thesql +" as result ") ;
if(rs2.next()) itemvalue = ""+Util.getDoubleValue(rs2.getString(1),0) ;
sqlmod += Util.getDoubleValue(itemvalue,0) ;
}
}
}
sql += " where inputid = " + inputid ;
sqlmod += " where inputid = " + inputmodid ;
RecordSet.executeSql(sql);
// out.print("sql 2 is " + sql) ;
RecordSet.executeSql(sqlmod);
// out.print("sql 3 is " + sqlmod) ;
if(confirmid.equals("0"))
response.sendRedirect("ReportConfirmDetail.jsp?thetable="+thetable+"&inputid="+inputid+"&inprepid="+inprepid+"&inprepbudget="+inprepbudget);
else
response.sendRedirect("ReportConfirmDetail.jsp?confirmid="+confirmid);
}
else if(operation.equals("confirm")){
String sql = " update " + thetable + " set inputstatus='1' , confirmuserid = "+ usertitle+ " where inputid = " + inputid ;
RecordSet.executeSql(sql);
sql = " update " + thetable + " set inputstatus='1' , confirmuserid = "+ usertitle+ " where inputid = " + inputmodid ;
RecordSet.executeSql(sql);
RecordSet.executeProc("T_InputReportConfirm_Delete", confirmid );
response.sendRedirect("ReportConfirm.jsp");
}
else if(operation.equals("check")){
String sql = " update " + thetable + " set inputstatus='2' where reportdate = '" + thedate + "' ";
RecordSet.executeSql(sql);
response.sendRedirect("ReportDetailStatus.jsp?inprepid="+inprepid);
}
else if(operation.equals("reject")){
String sql = " update " + thetable + " set inputstatus='0' where inputid = " + inputid ;
RecordSet.executeSql(sql);
sql = " update " + thetable + " set inputstatus='0' where inputid = " + inputmodid ;
RecordSet.executeSql(sql);
response.sendRedirect("ReportDetailStatus.jsp?inprepid="+inprepid);
}
%>