📄 employee_info.asp
字号:
<!--#include file="../INC/Conn.asp"-->
<!--#include file="../inc/md5.asp"-->
<!--#include file="inc/Check.asp"-->
<!--#include file="inc/public.asp"-->
<%
dim Makking,UserNumberID,day1
Makking = Trim(Request.QueryString("Makking"))
ID = Trim(Request.QueryString("ID"))
'---------------------------------
select case Makking
case "Del"
Conn.Execute("Delete From Employee Where Employee_ID = "& ID &"")
Save_Title = "·删除成功"
Call Save_ok()
case "save"
IF ID <> "" Then
sql="select * from Employee where Employee_ID = '"& ID &"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if rs.bof and rs.eof then
Save_title="·对不起，调用用户数据出错"
call Save_err()
else
if Request.Form("Employee_Password")<> "" Then
Rs("Employee_Password") = md5(Request.Form("Employee_Password"))
End if
Rs("Employee_Purview") = Request.Form("City")
Rs("Employee_Flag") = Request.Form("Flag")
Rs("Employee_State") = Request.Form("Employee_State")
end if
rs.update
rs.close
set rs=nothing
Save_title="·修改成功"
call Save_ok()
Else
Set Rs = Conn.Execute("Select Employee_ID From Employee where Employee_ID = '"& ID &"'")
IF Not(Rs.BOF AND Rs.eof) Then
Save_Title = "对不起，用户编号重复"
Call Save_Err()
End IF
Rs.Close
Set Rs = Nothing
if Trim(Request.Form("Employee_ID"))="" or Trim(Request.Form("Employee_Password"))="" then
Save_title="·对不起，请填写用户ID与密码"
call Save_err()
end if
Employee_ID = Request.Form("Employee_ID")
Employee_Password = md5(Request.Form("Employee_Password"))
Employee_Purview = Request.Form("City")
Employee_Flag = Request.Form("Flag")
Employee_State = Request.Form("Employee_State")
Conn.Execute("Insert Into Employee (Employee_ID,Employee_Password,Employee_Purview,Employee_Flag,Employee_State) values ('"& Employee_ID &"','"& Employee_Password &"','"& Employee_Purview &"','"& Employee_Flag &"','"& Employee_State &"')")
Save_title="·添加成功"
call Save_ok()
End IF
case ""
sql="select * from Employee where Employee_ID = '"& ID &"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if Not(rs.eof and rs.bof) then
Employee_ID = Rs("Employee_ID")
Employee_Password = Rs("Employee_Password")
City = Rs("Employee_Purview")
Flag = Rs("Employee_Flag")
Employee_State = Rs("Employee_State")
END IF
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>亿博尔</title>
</head>
<link href="Images/Admin.css" rel="stylesheet" type="text/css">
<body>
<table width="98%" height="40" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td height="30" align="left" bgcolor="ffffff"><table width="100%" height="100%" border="0" cellpadding="3" cellspacing="0">
<tr bgcolor="eeeeee">
<td width="5%" align="center"><img src="Images/1.gif" width="13" height="12"></td>
<td width="85%"><span class="style2">管理中心 >>> 用户信息</span></td>
<td width="10%" align="right"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" height="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#D8D8D8">
<tr>
<td valign="top" bgcolor="ffffff"><table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="320" align="center" valign="top" bgcolor="ffffff">
<form method='POST' name="form" action="Employee_info.asp?Makking=save&ID=<%=ID%>">
<input name="City" type="hidden" value="">
<table width=70% border=0 align='center' cellpadding=3
cellspacing=1 bordercolordark=#ffffff bgcolor="#EBEBEB" class='size09'>
<tr align="left" bgcolor="ffffff">
<td height="25" colspan="2"> </td>
</tr>
<tr>
<td height="22" align="right" bgcolor="FFFFFF">用户编号：</td>
<td height="22" bgcolor="ffffff">
<input name="Employee_ID" type="text" class="box1" id="Employee_ID" value="<%=Employee_ID%>" size="30" <%IF Employee_ID <> "" Then%>disabled<%End IF%>>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><font color="#999999">按一定规律填写，比如是001、002、003</font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="22" align="right" bgcolor="FFFFFF">密 码：</td>
<td height="22" bgcolor="ffffff">
<input name="Employee_Password" type="password" class="box1" id="Employee_Password" size="30">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><font color="#999999">修改信息时，不更改请留空</font></td>
</tr>
</table></td>
</tr>
<tr>
<td height="22" align="right" bgcolor="FFFFFF">职 位：</td>
<td height="22" bgcolor="ffffff">
<%Call Falg_A%>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><font color="#999999">不选择为管理全部地区</font></td>
</tr>
</table> </td>
</tr>
<tr>
<td height="22" align="right" bgcolor="FFFFFF">管理地区：</td>
<td height="22" bgcolor="ffffff">
<IFRAME frameBorder=0 id=FrmRight name=right src="../inc/City.asp?NumberID=<%=City%>" style="HEIGHT: 100%; VISIBILITY: inherit; WIDTH: 100%; Z-INDEX: 1"></IFRAME>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td><font color="#999999">不选择为管理全部地区</font></td>
</tr>
</table> </td>
</tr>
<tr>
<td height="22" align="right" bgcolor="FFFFFF">状态：</td>
<td height="22" bgcolor="ffffff">
<select name="Employee_State">
<option value="在职" <%IF Employee_State="在职" Then%> selected<%End IF%>>在职</option>
<option value="离职" <%IF Employee_State="离职" Then%> selected<%End IF%>>离职</option>
</select></td>
</tr>
</table>
<p>
<input name="B1" type="image" src="Images/refer.gif" width="36" height="21" border="0" >
<a href="javascript:history.go(-1)"><img src="Images/back.gif" width="36" height="21" border="0"></a></p>
</form></td>
</tr>
</table> </td>
</tr>
</table>
<%end select
Conn.Close
Set Conn = Nothing
%>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="6"></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -