HrmValidateTimecardOperation.jsp
2.17 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
<%@ page language="java" contentType="text/html;charset=UTF-8" %>
<%@ page import="java.util.* , java.io.* , weaver.general.Util,weaver.file.*" %>
<%@ page import="weaver.general.SendMail" %>
<%@ page import="weaver.conn.*" %>
<%@ include file="/systeminfo/init_wev8.jsp" %>
<jsp:useBean id="RecordSet" class = "weaver.conn.RecordSet" scope = "page"/>
<%
String operation = Util.null2String(request.getParameter("operation"));
String fromdate = Util.fromScreen(request.getParameter("fromdate") , user.getLanguage()) ; //排班日期从
String enddate = Util.fromScreen(request.getParameter("enddate") , user.getLanguage()) ; //排班日期到
char separator = Util.getSeparator() ;
if(operation.equals("recreate")) {
ArrayList resourceids = new ArrayList() ;
ArrayList usercodes = new ArrayList() ;
RecordSet.executeSql("select * from HrmTimecardUser ") ;
while ( RecordSet.next() ) {
String resourceid = Util.null2String(RecordSet.getString("resourceid")) ;
String usercode = Util.null2String(RecordSet.getString("usercode")) ;
resourceids.add( resourceid ) ;
usercodes.add( usercode ) ;
}
RecordSet.executeSql("select * from HrmValidateCardInfo ") ;
while ( RecordSet.next() ) {
String id = Util.null2String(RecordSet.getString("id")) ;
String Cardid = Util.null2String(RecordSet.getString("Cardid")) ;
String carddate = Util.null2String(RecordSet.getString("carddate")) ;
String cardtime = Util.null2String(RecordSet.getString("cardtime")) ;
String workshift = Util.null2String(RecordSet.getString("workshift")) ;
int usercodeindex = usercodes.indexOf(Cardid) ;
if( usercodeindex != -1 ) {
String resourceid = (String) resourceids.get( usercodeindex ) ;
String procedurepara = resourceid +separator+ carddate +separator+ cardtime +separator + "0" ;
RecordSet.executeProc("HrmRightCardInfo_Insert",procedurepara);
RecordSet.executeSql("delete HrmValidateCardInfo where id = " + id );
}
}
response.sendRedirect("/hrm/report/schedulediff/HrmRpValidateTimecard.jsp?fromdate="+fromdate+"&enddate="+enddate) ;
}
%>