ProcessDspDoc.jsp
3.87 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
<%@ page language="java" contentType="text/html; charset=UTF-8" %> <%@ include file="/systeminfo/init_wev8.jsp" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="RecordSet" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="RecordSet2" class="weaver.conn.RecordSet" scope="page" />
<jsp:useBean id="ResourceComInfo" class="weaver.hrm.resource.ResourceComInfo" scope="page"/>
<jsp:useBean id="WorkflowComInfo" class="weaver.workflow.workflow.WorkflowComInfo" scope="page" />
<jsp:useBean id="CustomerInfoComInfo" class="weaver.crm.Maint.CustomerInfoComInfo" scope="page" />
<HTML><HEAD>
<LINK href="/css/Weaver_wev8.css" type=text/css rel=STYLESHEET>
</HEAD>
<%
char flag = 2;
String ProcPara = "";
String ProjID = Util.null2String(request.getParameter("ProjID"));
String log = Util.null2String(request.getParameter("log"));
String Version = Util.null2String(request.getParameter("version"));
int MaxVersion = 0 ;
int CurrentVersion = 0 ;
String isActived = "" ;
String isCurrentActived = "" ;
int MinLenWbscoding = 0 ;
RecordSet.executeProc("Prj_TaskInfo_SelectMaxVersion",ProjID);
if(RecordSet.next()){
MaxVersion = RecordSet.getInt("version");
isActived = RecordSet.getString("isactived");
}
if(MaxVersion==0){
MaxVersion = 1;
}
if(Version.equals("")){
Version = ""+MaxVersion ;
}
RecordSet.executeProc("Prj_ProjectInfo_SelectByID",ProjID);
if(RecordSet.getCounts()<=0)
response.sendRedirect("/base/error/DBError.jsp?type=FindData");
RecordSet.first();
String imagefilename = "/images/hdMaintenance_wev8.gif";
String titlename = SystemEnv.getHtmlLabelName(1338,user.getLanguage())+"-"+"<a href='/proj/data/ViewProject.jsp?log="+log+"&ProjID="+RecordSet.getString("id")+"'>"+Util.toScreen(RecordSet.getString("name"),user.getLanguage())+"</a>";
String needfav ="1";
String needhelp ="";
%>
<BODY>
<%@ include file="/systeminfo/TopTitle_wev8.jsp" %>
<%@ include file="/systeminfo/RightClickMenuConent_wev8.jsp" %>
<%
RCMenu += "{"+SystemEnv.getHtmlLabelName(1290,user.getLanguage())+",/proj/plan/ViewProcess.jsp?ProjID="+ProjID+",_self} " ;
RCMenuHeight += RCMenuHeightStep;
%>
<%@ include file="/systeminfo/RightClickMenu_wev8.jsp" %>
<TABLE class=liststyle cellspacing=1 >
<TBODY>
<TR class=Header>
<th><%=SystemEnv.getHtmlLabelName(1339,user.getLanguage())%></th>
<th><%=SystemEnv.getHtmlLabelName(1340,user.getLanguage())%></th>
<th><%=SystemEnv.getHtmlLabelName(1341,user.getLanguage())%></th>
</TR><TR class=Line><Th colspan="3" ></Th></TR>
<%
String CurrentUser = ""+user.getUID();
String logintype = ""+user.getLogintype();
int usertype = 0;
if(logintype.equals("2"))
usertype= 1;
String sql="SELECT t1.id, t1.docsubject, t1.ownerid, t1.doccreatedate, t1.doccreatetime FROM DocDetail t1, docuserview t2, Prj_Doc t3 ";
String sqlwhere=" where t1.id = t2.docid and t2.userid = "+CurrentUser + " and t1.id = t3.docid and t3.type = '1' and t3.prjid = " + ProjID + " and t3.version <= 1000" ;
String orderby=" ORDER BY t1.id DESC ";
sql=sql+sqlwhere+orderby;
RecordSet.executeSql(sql);
while(RecordSet.next())
{
String id=RecordSet.getString("id");
String createdate=RecordSet.getString("doccreatedate");
String createtime=RecordSet.getString("doccreatetime");
String ownerid=RecordSet.getString("ownerid");
String docsubject=RecordSet.getString("docsubject");
%>
<tr class=datadark>
<td><%=Util.toScreen(createdate,user.getLanguage())%> <%=Util.toScreen(createtime,user.getLanguage())%></td>
<td>
<a href="/hrm/resource/HrmResource.jsp?id=<%=ownerid%>"><%=Util.toScreen(ResourceComInfo.getResourcename(ownerid),user.getLanguage())%></a>
</td>
<td><a href="/docs/docs/DocDsp.jsp?id=<%=id%>"><%=Util.toScreen(docsubject,user.getLanguage())%></a></td>
</tr>
<%}%>
</TBODY>
</TABLE>
</td>
</tr>
</TABLE>
</td>
<td></td>
</tr>
<tr>
<td height="10" colspan="3"></td>
</tr>
</table>
</BODY>
</HTML>