?? nowkqinfo.asp
字號:
<!--#include file="../asp/sqlstr.asp"-->
<!--#include file="../asp/bgsub.asp"-->
<%
'session.abandon
'Server.ScriptTimeOut=500
function opendb(DBPath,sessionname,dbsort)
dim conn
'if not isobject(session(sessionname)) then
Set conn=Server.CreateObject("ADODB.Connection")
'if dbsort="accessdsn" then conn.Open "DSN=" & DBPath
'if dbsort="access" then conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
'if dbsort="sqlserver" then conn.Open "DSN=" & DBPath & ";uid=wsw;pwd=wsw"
DBPath1=server.mappath("../db/jzud-oa.asa")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set session(sessionname)=conn
'end if
set opendb=session(sessionname)
end function
%>
<!--#include file="../asp/checked.asp"-->
<!--#include file="conn.asp"-->
<!--#include file="publicsub.asp"-->
<%
'-----------------------------------------
oabusyname=request.cookies("oabusyname")
oabusyusername=request.cookies("oabusyusername")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
if oabusyusername="" then
response.write("<script language=""javascript"">")
response.write("window.top.location.href='../default.asp';")
response.write("</script>")
response.end
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/css.css">
<script language="javascript1.2" src="js/openwin.js"></script>
<script language="javascript">
function printsub()
{
window.open('printnowkqinfo.asp?dept='+document.deptform.userdept.value,'kqprintwindow','location=no,height=450, width=600, toolbar=no, menubar=no, scrollbars=yes, resizable=no, location=no, status=no');
}
</script>
<title>Crackgo辦公系統(tǒng)</title>
</head>
<body topmargin="5" leftmargin="5">
<center>
<table align="center">
<tr>
<%
allow_look_all_kq_info=lookkqpopedom()
if allow_look_all_kq_info="no" then
userdept=oabusyuserdept
%>
<td><b><font color="#ee0000" size="+1"><%=cstr(year(date()))&"年"&cstr(month(date()))&"月"&cstr(day(date()))&"日"%></font>考勤統(tǒng)計（<%=oabusyuserdept%>）</b></td>
<%
else
%>
<td><b><font color="#dd0000" size="+1"><%=cstr(year(date()))&"年"&cstr(month(date()))&"月"&cstr(day(date()))&"日"%></font>考勤統(tǒng)計</b> </td>
<%
'讀取部門和人員
set conn=opendb("oabusy","conn","accessdsn")
set rs=server.createobject("adodb.recordset")
sql="select DISTINCT userdept from userinf"
rs.open sql,conn,1
%>
<form method="post" action="nowkqinfo.asp" name="deptform">
<td>
<select size=1 name="userdept">
<%
if not rs.eof and not rs.bof then
userdept=rs("userdept")
end if
if request("userdept")<>"" then
userdept=request("userdept")
end if
while not rs.eof and not rs.bof
%>
<option value="<%=rs("userdept")%>"<%=selected(userdept,rs("userdept"))%>><%=rs("userdept")%></option>
<%
rs.movenext
wend
conn.close
set conn=nothing
set rs=nothing
%>
</select><input type="submit" value="查看"><input type="button" name="pintbtn" value="打印" onclick="printsub();">
</td>
</form>
<%
end if
%>
</tr>
</table>
</center>
<%
'讀取用戶表
set conn=opendb("oabusy","conn","accessdsn")
set kqconn=openconn("kq")
set rs=server.createobject("adodb.recordset")
sql="select name,username from userinf where userdept=" & sqlstr(userdept)
rs.open sql,conn,1
if rs.eof or rs.bof then
response.write("<p align=""center""><font color=""#ee0000"">該部門還沒有用戶！</font>")
else
%>
<br>
<center>
<table border="1" cellpadding="4" cellspacing="0" width="90%" bordercolorlight="#808080" bordercolordark="#D4D0C8">
<tr>
<td bgcolor="#D4D0C8" height="30" width="66" align="center">姓名</td>
<td bgcolor="#D4D0C8" height="30" width="104" align="center">部門</td>
<td bgcolor="#D4D0C8" height="30" width="70" align="center">上班時間</td>
<td bgcolor="#D4D0C8" height="30" width="70" align="center">下班時間</td>
<td bgcolor="#D4D0C8" height="30" width="228" align="center">說明</td>
</tr>
<%
'讀取上考勤時間信息
set kqconn=openconn("kq")
set rs3=server.createobject("adodb.recordset")
sql="select * from inittime"
rs3.open sql,kqconn,1
amcometime=rs3("amondutytime")
amgotime=rs3("amoffdutytime")
pmcometime=rs3("pmondutytime")
pmgotime=rs3("pmoffdutytime")
comedelaytime=rs3("ondutydelaytime")
goaheadtime=rs3("offdutyaheadtime")
kqtimephase=rs3("kqtimephase")
amgonokq=rs3("amgonokq")
pmcomenokq=rs3("pmcomenokq")
pmgonokq=rs3("pmgonokq")
set rs3=nothing
amcometimephase1=getnewtime(amcometime,-kqtimephase)
amcometimephase2=getnewtime(amcometime,kqtimephase)
amgotimephase1=getnewtime(amgotime,-kqtimephase)
amgotimephase2=getnewtime(amgotime,kqtimephase)
pmcometimephase1=getnewtime(pmcometime,-kqtimephase)
pmcometimephase2=getnewtime(pmcometime,kqtimephase)
pmgotimephase1=getnewtime(pmgotime,-kqtimephase)
pmgotimephase2=getnewtime(pmgotime,kqtimephase)
'返回上下午和上班時間還是下班時間
nowtime=time()
amorpmvalue=""
goorcomevalue=""
lookkqinfo=""
if nowtime<amcometimephase1 then
lookkqinfo="no"
elseif nowtime>=amcometimephase1 and nowtime<amgotimephase1 then
lookkqinfo="amandcome"
elseif nowtime>=amgotimephase1 and nowtime<pmcometimephase1 then
lookkqinfo="amall"
elseif nowtime>=pmcometimephase1 and nowtime<pmgotimephase1 then
lookkqinfo="amallandpmcome"
elseif nowtime>=pmgotimephase1 then
lookkqinfo="amandpm"
end if
public getamcometime,getamgotime,getamexplain,getpmcometime,getpmgotime,getpmexplain
i=0
do while not rs.eof
getamcometime=""
getamgotime=""
getamexplain=""
getpmcometime=""
getpmgotime=""
getpmexplain=""
sql1="select * from month"&cstr(month(date()))&" where day=#"&date()&"# and username='"&rs("username")&"' and dept='"&userdept&"' and amorpm='am'"
sql2="select * from month"&cstr(month(date()))&" where day=#"&date()&"# and username='"&rs("username")&"' and dept='"&userdept&"' and amorpm='pm'"
set rs1=server.createobject("adodb.recordset")
set rs2=server.createobject("adodb.recordset")
rs1.open sql1,kqconn,1
rs2.open sql2,kqconn,1
select case lookkqinfo
case "no"
getamcometime="00:00:00"
getamgotime="00:00:00"
getamexplain="<font color='#ee0000'>不能取得資料</font>"
getpmcometime="00:00:00"
getpmgotime="00:00:00"
getpmexplain="<font color='#ee0000'>不能取得資料</font>"
case "amandcome"
call disposeamcometime()'處理上午上班時間
getpmcometime="00:00:00"
getpmgotime="00:00:00"
getpmexplain="<font color='#ee0000'>不能取得資料</font>"
case "amall"
call disposeamcometime()'處理上午上班時間
if amgonokq=0 then
call disposeamgotime()'處理上午下班時間
end if
getpmcometime="00:00:00"
getpmgotime="00:00:00"
getpmexplain="<font color='#ee0000'>不能取得資料</font>"
case "amallandpmcome"
call disposeamcometime()'處理上午上班時間
if amgonokq=0 then
call disposeamgotime()'處理上午下班時間
end if
if pmcomenokq=0 then
call disposepmcometime()'處理下午上班時間
end if
getpmgotime="00:00:00"
case "amandpm"
call disposeamcometime()'處理上午上班時間
if amgonokq=0 then
call disposeamgotime()'處理上午下班時間
end if
if pmcomenokq=0 then
call disposepmcometime()'處理下午上班時間
end if
if pmgonokq=0 then
call disposepmgotime()'處理下午下班時間
end if
end select
if i mod 2=0 then
bgcolorvalue="#efefef"
else
bgcolorvalue="#ffffff"
end if
i=i+1
%>
<tr bgcolor="<%=bgcolorvalue%>" height="20">
<td width="66" align="center" rowspan="2" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF"><%=server.htmlencode(rs("name"))%></td>
<td width="104" align="center" rowspan="2" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF"><%=server.htmlencode(userdept)%></td>
<td width="70" align="center" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF"><%=getamcometime%></td>
<td width="70" align="center" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<%
if amgonokq=0 then
response.write(getamgotime)
else
response.write(" ")
end if
%>
</td>
<td width="228" align="center" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<%
if getamexplain="" then
getamexplain=" "
end if
response.write(getamexplain)
%>
</td>
</tr>
<tr bgcolor="<%=bgcolorvalue%>" height="20">
<td width="70" align="center" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<%
if pmcomenokq=0 then
response.write(getpmcometime)
else
response.write(" ")
end if
%>
</td>
<td width="70" align="center" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<%
if pmgonokq=0 then
response.write(getpmgotime)
else
response.write(" ")
end if
%>
</td>
<td width="228" align="center" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF">
<%
if getpmexplain="" then
getpmexplain=" "
end if
response.write(getpmexplain)
%>
</td>
</tr>
<%
rs.movenext
loop
%>
</table>
</center>
<br>
<%
end if
conn.close
set conn=nothing
set rs=nothing
%>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -