get_split_flow.jsp
3.04 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
<%@ page import="com.engine.kq.enums.KqSplitFlowTypeEnum" %>
<%@ page import="weaver.conn.RecordSet" %>
<%@ page import="weaver.general.Util" %>
<%@ page import="weaver.hrm.resource.ResourceComInfo" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" %>
<%
try {
int kqtype = Util.getIntValue(Util.null2String(request.getParameter("kqtype")));
if(kqtype < 0){
out.println("param kqtype is null##<br/>");
return ;
}
int requestid = Util.getIntValue(Util.null2String(request.getParameter("requestid")));
String tablename = "";
if(kqtype == KqSplitFlowTypeEnum.LEAVE.getFlowtype()){
tablename = KqSplitFlowTypeEnum.LEAVE.getTablename();
}else if(kqtype == KqSplitFlowTypeEnum.EVECTION.getFlowtype()){
tablename = KqSplitFlowTypeEnum.EVECTION.getTablename();
}else if(kqtype == KqSplitFlowTypeEnum.OUT.getFlowtype()){
tablename = KqSplitFlowTypeEnum.OUT.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.OVERTIME.getFlowtype()){
tablename = KqSplitFlowTypeEnum.OVERTIME.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.SHIFT.getFlowtype()){
tablename = KqSplitFlowTypeEnum.SHIFT.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.OTHER.getFlowtype()){
tablename = KqSplitFlowTypeEnum.OTHER.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.CARD.getFlowtype()){
tablename = KqSplitFlowTypeEnum.CARD.getTablename();;
}else if(kqtype == KqSplitFlowTypeEnum.LEAVEBACK.getFlowtype()){
tablename = KqSplitFlowTypeEnum.LEAVEBACK.getTablename();;
}else{
out.print("考勤流程没有找到对应类型##kqtype##"+kqtype);
return;
}
ResourceComInfo rci = new ResourceComInfo();
RecordSet rs = new RecordSet();
String sql = "select * from "+tablename+" a ";
if(requestid > 0){
sql += " where requestid in("+requestid+")";
}
rs.executeQuery(sql);
while (rs.next()){
String requestid_1= rs.getString("requestid");
String resourceid= rs.getString("resourceid");
String fromdate= rs.getString("fromdate");
String fromtime= rs.getString("fromtime");
String todate= rs.getString("todate");
String totime= rs.getString("totime");
String newleavetype= rs.getString("newleavetype");
String duration= rs.getString("duration");
String leavebackrequestid= rs.getString("leavebackrequestid");
//添加列值
String msg = "";
msg += requestid_1+"##"+rci.getLastname(resourceid)+"##fromdate##"+fromdate
+"##fromtime##"+fromtime+"##todate##"+
todate+"##totime##"+totime+"##newleavetype##"+newleavetype+
"##duration##"+duration+"##leavebackrequestid##"+leavebackrequestid+"---";
out.print(msg+"<br/><br/>");
}
}catch (Exception e){
e.printStackTrace();;
}
%>