CptRpCapitalFlowData.jsp
5 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
request.setCharacterEncoding("UTF-8");
%>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.ArrayList,weaver.hrm.*" %>
<%@ page import="weaver.systeminfo.SystemEnv" %>
<%@ page import="java.text.NumberFormat" %>
<jsp:useBean id="rs" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="CapitalComInfo" class="weaver.cpt.capital.CapitalComInfo" scope="page"/>
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page" />
<jsp:useBean id="DepartmentComInfo" class="weaver.hrm.company.DepartmentComInfo" scope="page"/>
<jsp:useBean id="CapitalStateComInfo" class="weaver.cpt.maintenance.CapitalStateComInfo" scope="page"/>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
<%
User user = HrmUserVarify.getUser (request , response) ;
if(user == null) return ;
String showString = "";
String datasql = Util.null2String(request.getParameter("datasql"));
int Language= Util.getIntValue(request.getParameter("Language"),7);
int rowcolorindex = 0;
NumberFormat nf = NumberFormat.getInstance();
nf.setGroupingUsed(false);
%>
<table class=ListStyle cellspacing="1">
<COLGROUP>
<COL width="11%">
<COL width="13%">
<COL width="10%">
<COL width="10%">
<COL width="11%">
<COL width="11%">
<COL width="11%">
<COL width="11%">
<COL width="12%">
<TR class=header>
<TD><%=SystemEnv.getHtmlLabelName(714,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(195,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(1394,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(1434,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(1435,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(1436,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(1380,Language)%><%=SystemEnv.getHtmlLabelName(602,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(22562,Language)%></TD>
<TD><%=SystemEnv.getHtmlLabelName(1380,Language)%><%=SystemEnv.getHtmlLabelName(534,Language)%></TD>
</TR>
<%
double usecountall = 0;
double feeall = 0;
rs.executeSql(datasql);
while(rs.next()){
String tempcapitalid=Util.toScreen(rs.getString("capitalid"),Language);
String usedate=Util.toScreen(rs.getString("usedate"),Language);
String olddeptid=rs.getString("olddeptid");
String usedeptid=rs.getString("usedeptid");
String useresourceid = rs.getString("useresourceid");
String usestatus = rs.getString("usestatus");
String usecount = Util.toScreen(rs.getString("usecount"),Language);
String useaddress = Util.toScreen(rs.getString("useaddress"),Language);
String fee = Util.toScreen(rs.getString("fee"),Language);
String mark = rs.getString("mark");
String sptcount=rs.getString("sptcount");
double startprice=Util.getDoubleValue( rs.getString("startprice"),0);
if(!"1".equals(sptcount)){
if( "2".equals(usestatus)||"3".equals(usestatus)||"-4".equals(usestatus)){
fee=""+(startprice*Util.getDoubleValue( usecount,0));
}
}
usecountall += Util.getDoubleValue(usecount,0);
feeall += Util.getDoubleValue(fee,0);
if(rowcolorindex==0){
rowcolorindex = 1;
%>
<TR class="DataLight">
<%}else if(rowcolorindex==1){
rowcolorindex = 0;
%>
<TR class="DataDark">
<%}
showString += "<TR><TD>"+mark+"</TD>"+
"<TD><A HREF='/cpt/capital/CptCapital.jsp?id="+tempcapitalid+"' target='_blank'>"+Util.toScreen(CapitalComInfo.getCapitalname(tempcapitalid),Language)+"</A></TD>"+
"<TD>"+usedate+"</TD>"+
"<TD>"+Util.toScreen(DepartmentComInfo.getDepartmentname(olddeptid),Language)+"</TD>"+
"<TD>"+Util.toScreen(DepartmentComInfo.getDepartmentname(usedeptid),Language)+"</TD>"+
"<TD>"+Util.toScreen(ResourceComInfo.getResourcename(useresourceid),Language)+"</TD>"+
"<TD>"+Util.toScreen(CapitalStateComInfo.getCapitalStatename(usestatus),Language)+"</TD>"+
"<TD>"+usecount+"</TD>"+
"<TD>"+nf.format(Util.getDoubleValue(fee,0))+"</TD></TR>";
%>
<TD><%=mark%></TD>
<TD><A HREF="/cpt/capital/CptCapital.jsp?id=<%=""+tempcapitalid%>" target='_blank'><%=Util.toScreen(CapitalComInfo.getCapitalname(tempcapitalid),Language)%></A></TD>
<TD><%=usedate%></TD>
<TD><%=Util.toScreen(DepartmentComInfo.getDepartmentname(olddeptid),Language)%> </TD>
<TD><%=Util.toScreen(DepartmentComInfo.getDepartmentname(usedeptid),Language)%> </TD>
<TD><%=Util.toScreen(ResourceComInfo.getResourcename(useresourceid),Language)%></TD>
<TD><%=Util.toScreen(CapitalStateComInfo.getCapitalStatename(usestatus),Language)%></TD>
<TD><%=usecount%></TD>
<TD><%=nf.format(Util.getDoubleValue(fee,0)) %></TD>
</TR>
<%
}
%>
<TR class=DataDark>
<TD></TD>
<TD></TD>
<TD></TD>
<TD></TD>
<TD></TD>
<TD></TD>
<TD><font color=red><%=SystemEnv.getHtmlLabelName(523,Language)%></font></TD>
<TD><font color=red><%=nf.format(usecountall)%></font></TD>
<TD><font color=red><%=nf.format(feeall)%></font></TD>
</TR>
</table>