📄 admin_yuangong.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_yuangong.asp'>")
end sub%>
<% sub edit()
sql = "select * from 员工信息 where 员工编号='"&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_yuangong.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" >
<input name="name" type="text" value="<%= 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="depart" 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="job" 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"><select name="sex">
<option value="男" <% if rs("性别")="男" then %> selected <% end if %>>男</option>
<option value="女" <% if rs("性别")="女" then %> selected <% end if %>>女</option>
</select></td>
</tr>
<tr>
<td height="25" align="left" valign="top"> 民族 </td>
<td height="25" valign="top"><input name="nation" 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="birthday" 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="address" 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="zhengzhi" 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="tel" 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="place" 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="time" type="text" id="pic2" size="50" maxlength="50" value="<%= rs("入部门日期") %>"></td>
</tr>
<tr>
<td align="left" >详细介绍 </td>
<td ><textarea name="comment" cols="48" rows="15" id="textarea"><%= rs("备注") %></textarea></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_yuangong.asp'>")
else
rs("姓名")=Trim(Request.Form("name"))
rs("备注")=Trim(Request.Form("comment"))
rs("性别")=Trim(Request.form("sex"))
rs("部门编号")=Trim(Request.form("depart"))
rs("职务")=Trim(Request.form("job"))
rs("入部门日期")=Trim(Request.form("time"))
rs("籍贯")=Trim(Request.Form("place"))
rs("电话号码")=Trim(Request.Form("tel"))
rs("政治面貌")=Trim(Request.Form("zhengzhi"))
rs("住址")=Trim(Request.Form("address"))
rs("出生年月")=Trim(Request.Form("birthday"))
rs("民族")=Trim(Request.Form("nation"))
rs.update
rs.close
set rs = nothing
Response.Write("更新成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_yuangong.asp'>")
end if
end sub
%>
<% sub list()%>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td>
<a href="admin_yuangong.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 align="left" valign="bottom">
<td height="20"><font color="#000000" size="2"><a href="admin_yuangong.asp?action=edit&id=<%=rs("员工编号")%>">编辑</a>
| <a href="admin_yuangong.asp?action=del&id=<%=rs("员工编号")%>">删除</a></font></td>
</tr>
</table>
<%
RowCount =RowCount -1
RS.MoveNext
Loop
rs.close
set rs=nothing
%>
<form method="post" action="admin_yuangong.asp">
<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_yuangong.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="name" type="text" ></td>
</tr>
<tr>
<td height="25" valign="top"> 部门编号 </td>
<td height="25" valign="top"><input name="depart" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 职务 </td>
<td height="25" valign="top"><input name="job" type="text" id="job3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 性别 </td>
<td height="25" valign="top"><select name="sex">
<option value="男" >男</option>
<option value="女" >女</option>
</select></td>
</tr>
<tr>
<td height="25" valign="top"> 民族 </td>
<td height="25" valign="top"><input name="nation" type="text" id="pic3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 出生年月 </td>
<td height="25" valign="top"><input name="birthday" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 住址 </td>
<td height="25" valign="top"><input name="address" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 政治面貌 </td>
<td height="25" valign="top"><input name="zhengzhi" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 电话号码 </td>
<td height="25" valign="top"><input name="tel" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 籍贯 </td>
<td height="25" valign="top"><input name="place" type="text" id="depart3" size="50" maxlength="50" ></td>
</tr>
<tr>
<td height="25" valign="top"> 入部门日期 </td>
<td height="25" valign="top"><input name="time" type="text" id="depart4" size="50" maxlength="50" ></td>
</tr>
<tr>
<td >密码 </td>
<td ><input name="password" type="text" id="depart5" size="50" maxlength="50" ></td>
</tr>
<tr>
<td >权限 </td>
<td ><input name="levles" type="text" id="depart6" size="50" maxlength="50" ></td>
</tr>
<tr>
<td >详细介绍 </td>
<td ><textarea name="comment" cols="48" rows="15" id="textarea2"></textarea></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("name")&"','"&request("depart")&"','"&request("job")&"','"&request("sex")&"','"&request("nation")&"','"&request("birthday")&"','"&request("address")&"','"&request("zhengzhi")&"','"&request("tel")&"','"&request("place")&"','"&request("time")&"','"&request("comment")&"','"&request("paddword")&"','"&request("levels")&"') "
conn.execute(sql)
Response.Write("添加成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_yuangong.asp'>")
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -