📄 admin_gongzitongji.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="chkuser.asp"-->
<% if not poweruser then
Response.Write("您不是管理员或无此权限，请不要进入管理中心，3秒后系统将自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='4; URL=admin.asp'>")
Response.end()
end if %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>月度工资统计</title>
<link href="main.css" rel="stylesheet" type="text/css">
</head>
<body>
<% call main() %>
</body>
</html>
<%sub main()%>
<table cellpadding=0 cellspacing=0 border=0 width=450 align=center>
<tr>
<td>
<table cellpadding=3 cellspacing=1 border=0 width=100%>
<tr >
<td><font color="#000000">欢迎<b>您</b>进入管理页面</font>
</td>
</tr>
<tr bgcolor="#e0e0e0">
<td width="100%" valign=top><font color="#000000">
<%
if request("action") = "del" then
call del()
elseif request("action")="edit" then
call edit()
elseif request("action")="savedit" then
call savedit()
elseif request("action")="add" then
call add()
elseif request("action")="save" then
call save()
else
call list()
end if
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%end sub%>
<% sub del()
sql = " delete from 月度工资统计 where 员工编号='"&request("id")&"' "
conn.execute(sql)
Response.Write("删除成功，2秒后系统将自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_gongzitongji.asp'>")
end sub%>
<% sub edit()
sql = "select * from 月度工资统计,员工信息 where 月度工资统计.员工编号=员工信息.员工编号 and 月度工资统计.员工编号='"&request("id")&"' "
set rs= Server.CreateObject("adodb.recordset")
rs.open sql,conn,0,1
%>
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form name="main" method="post" action="admin_gongzitongji.asp?action=savedit">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="427" height="25" align="left" > 姓名 </td>
<td width="23" height="25" >
<%= rs("姓名") %></td>
</tr>
<tr>
<td height="25" align="left" valign="top">
<input name="id" type="hidden" value="<%=rs("月度工资统计.员工编号")%>">
基本工资 </td>
<td height="25" align="center" valign="top"><input name="jibengongzi" type="text" id="depart2" size="50" maxlength="50" value="<%= rs("基本工资") %>"></td>
</tr>
<tr>
<td height="25" align="left" valign="top"> 奖金 </td>
<td height="25" valign="top"><input name="jiangjin" type="text" id="job2" size="50" maxlength="50" value="<%= rs("奖金") %>"></td>
</tr>
<tr>
<td height="25" align="left" valign="top"> 其他应发总额 </td>
<td height="25" valign="top"><input name="zonge" type="text" id="pic2" size="50" maxlength="50" value="<%= rs("其他应发总额") %>"></td>
</tr>
<tr>
<td height="25" align="left" valign="top">时间 </td>
<td height="25" valign="top"><input name="shijian" type="text" id="pic2" size="50" maxlength="50" value="<%= rs("时间") %>"></td>
</tr>
<tr>
</td>
</tr>
<tr>
<td height="25" colspan="2" align="center"> <input type="submit" name="Submit" value="提交">
<input name="reset" type="reset" id="reset" value="重置">
</td>
</tr>
</table>
</form></td>
</tr>
</table>
<% rs.close
set rs = nothing
end sub %>
<% sub savedit()
sql = " select * from 月度工资统计 where 员工编号='"&request.form("id")&"' "
set rs = Server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof and rs.bof then
Response.Write("参数错误,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_gongzitongji.asp'>")
else
rs("基本工资")=Trim(Request.Form("jibengongzi"))
rs("奖金")=Trim(Request.Form("jiangjin"))
rs("其他应发总额")=Trim(Request.form("zonge"))
rs("时间")=Trim(Request.form("shijian"))
rs.update
rs.close
set rs = nothing
Response.Write("更新成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_gongzitongji.asp'>")
end if
end sub
%>
<% sub list()%>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td>
<a href="admin_gongzitongji.asp?action=add">添加工资统计</a>
</td>
</tr>
<tr>
<td><font color="#000000" size="2">注意事项： <br>
在下面，您将看到目前所有的员工的工资统计。您可以编辑或删除目前存在的资料。</font>
</td>
</tr>
</table>
<%
dim pgsz,total,pageno,ScrollAction
dim pagebegin,pagend,position,rowcount
PgSz=5
dim totalPut
dim CurrentPage, TotalPages
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
set rs= server.createobject ("adodb.recordset")
sql = " select * from 月度工资统计 order by 员工编号"
rs.open sql,conn,1,3
if rs.eof and rs.bof then
Response.Write("目前数据库为空。")
else
RS.PageSize = Cint(PgSz)
Total=INT(RS.recordcount / PgSz * -1)*-1 ''计算可显示页面的总数
PageNo=Request("pageno")
if PageNo="" Then
PageNo=1
else
PageNo=PageNo+1
PageNo=PageNo-1
end if
ScrollAction=Request("ScrollAction")
if ScrollAction="上一页" Then
PageNo=PageNo-1
end if
if ScrollAction="下一页" Then
PageNo=PageNo+1
end if
if PageNo<1 Then
PageNo=1
end if
RS.AbsolutePage=PageNo
position=RS.PageSize*PageNo
pagebegin=position-RS.PageSize+1
if position < RS.RecordCount then
pagend=position
else
pagend= RS.RecordCount
end if
Response.Write "<font color=ffffff>共有["&RS.RecordCount&"]位员工,显示["&pagebegin&"-"&pagend&"]位</font>"
RowCount = RS.PageSize
Do While Not RS.EOF and rowcount > 0
%>
<hr width=60% align=left color=black height=1>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td height="20"><font size="2">员工编号：<b><font color=red><%=rs("员工编号")%></font></b></font></td>
</tr>
<tr>
<td height="20"><font color="#000000" size="2">基本工资：<%=rs("基本工资")%></font></td>
</tr>
<tr>
<td height="20"><font color="#000000" size="2">奖金：<%=rs("奖金")%></font></td>
</tr>
<tr>
</tr>
<tr>
<td height="20"><font color="#000000" size="2">其他应发总额：<%=rs("其他应发总额")%></font></td>
</tr>
<tr>
<td height="20"><font color="#000000" size="2">时间：<%=rs("时间")%></font></td>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr align="left" valign="bottom">
<td height="20"><font color="#000000" size="2"><a href="admin_gongzitongji.asp?action=edit&id=<%=rs("员工编号")%>">编辑</a>
| <a href="admin_gongzitongji.asp?action=del&id=<%=rs("员工编号")%>">删除</a></font></td>
</tr>
</table>
<%
RowCount =RowCount -1
RS.MoveNext
Loop
rs.close
set rs=nothing
%>
<form method="post">
<input type="HIDDEN" name="pageno" value="<%=PageNo %>">
<%
if PageNo > 1 Then
response.write "<input type=submit name=ScrollAction value=上一页 style=background-color:e0e0e0;color:000000;border: 1 double>"
end if
if RowCount = 0 and PageNo <>Total then
response.write "<input type=submit name=ScrollAction value=下一页 style=background-color:e0e0e0;color:000000;border: 1 double>"
end if
%>
</FORM>
<%
end if
end sub%>
<% sub add()
%>
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><form name="main" method="post" action="admin_gongzishezhi.asp?action=save">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" valign="top"> 员工编号 </td>
<td height="25" valign="top"><input name="yuangongbianhao" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td width="399" height="25">基本工资 </td>
<td width="51" height="25">
<input name="jibengongzi" type="text" ></td>
</tr>
<tr>
<td height="25" valign="top"> 奖金 </td>
<td height="25" valign="top"><input name="jiangjin" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 其他应发总额</td>
<td height="25" valign="top"><input name="qitayingfazonge" type="text" id="pic3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 时间</td>
<td height="25" valign="top"><input name="shijian" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" colspan="2" align="center"> <input type="submit" name="Submit" value="提交">
<input name="reset" type="reset" id="reset" value="重置">
</td>
</tr>
</table>
</form></td>
</tr>
</table><% end sub %>
<% sub save()
sql = " insert into 月度工资统计(员工编号,基本工资 ,奖金, 其他应发总额,时间) values ('"&request("yuangongbianhao")&"','"&request("jibengongzi")&"','"&request("jiangjin")&"','"&request("qitayingfazonge")&"','"&request("shijian")&"') "
conn.execute(sql)
Response.Write("添加成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_gongzitongji.asp'>")
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -