get_schedulesign.jsp
2.33 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
<%@ 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 {
RecordSet rs = new RecordSet();
ResourceComInfo ResourceComInfo = new ResourceComInfo();
String resourceid = Util.null2String(request.getParameter("resourceid"));
String kqdate = Util.null2String(request.getParameter("kqdate"));
String kqdateto = Util.null2String(request.getParameter("kqdateto"));
if(resourceid.length() == 0){
out.println("param resourceid is null:<br/>");
return ;
}
if(kqdate.length() == 0){
out.println("param kqdate is null:<br/>");
return ;
}
if(kqdateto.length() == 0){
out.println("param kqdateto is null:<br/>");
return ;
}
String msg = "";
String sql = "select * from hrmschedulesign where isincom='1' and userid = ? and signdate between ? and ? order by signdate,signtime ";
rs.executeQuery(sql, resourceid,kqdate,kqdateto);
while (rs.next()){
String id = Util.null2String(rs.getString("id"));
String userid = Util.null2String(rs.getString("userid"));
String signdate = Util.null2String(rs.getString("signdate"));
String signtime = Util.null2String(rs.getString("signtime"));
String signfrom = Util.null2String(rs.getString("signfrom"));
String isincom = Util.null2String(rs.getString("isincom"));
String longitude = Util.null2String(rs.getString("longitude"));
String latitude = Util.null2String(rs.getString("latitude"));
String addr = Util.null2String(rs.getString("addr"));
String timezone = Util.null2String(rs.getString("timezone"));
String tmpmsg = ResourceComInfo.getLastname(userid)+">> id:"+id+" , isincom:"+isincom+" , signdate:"+signdate
+" , signtime:"+signtime+" , signfrom:"+signfrom+" , longitude:"+longitude+" , latitude:"+latitude
+" , addr:"+addr+" , timezone:"+timezone;
msg += tmpmsg+"<br/>";
}
out.println(msg);
}catch (Exception e){
out.print("Exception:"+e.getMessage());
e.printStackTrace();;
}
%>