📄 admin_doctor.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_login.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 doctor where id="&request("id")
conn.execute(sql)
Response.Write("删除成功，2秒后系统将自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_doctor.asp'>")
end sub%>
<% sub edit()
sql = "select * from doctor where id="&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_doctor.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("name") %>"></td>
</tr>
<tr>
<td height="25" align="left" valign="top">
<input name="id" type="hidden" value="<%=rs("id")%>">
科室 </td>
<td height="25" align="center" valign="top"><input name="depart" type="text" id="depart2" size="50" maxlength="50" value="<%= rs("depart") %>"></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("job") %>"></td>
</tr>
<tr>
<td height="25" align="left" valign="top"> 性别 </td>
<td height="25" valign="top"><select name="sex">
<option value="男" <% if rs("sex")="男" then %> selected <% end if %>>男</option>
<option value="女" <% if rs("sex")="女" then %> selected <% end if %>>女</option>
</select></td>
</tr>
<tr>
<td height="25" align="left" valign="top"> 照片 </td>
<td height="25" valign="top"><input name="pic" type="text" id="pic2" size="50" maxlength="50" value="<%= rs("pic") %>"></td>
</tr>
<tr>
<td align="left" >详细介绍 </td>
<td ><textarea name="comment" cols="48" rows="15" id="textarea"><%= rs("comment") %></textarea></td>
</tr>
<tr>
<td height="25" align="left" valign="top"> 诊断有效时间(如有多项请用,隔开，如8点-11点，2点-4点)<br>
</td>
<td height="25" valign="top"><input name="avalible" type="text" id="avalible" size="50" maxlength="50" value="<%= rs("avalible") %>"></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 doctor where id="&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_doctor.asp'>")
else
rs("name")=Trim(Request.Form("name"))
rs("comment")=Trim(Request.Form("comment"))
rs("sex")=Trim(Request.form("sex"))
rs("depart")=Trim(Request.form("depart"))
rs("job")=Trim(Request.form("job"))
rs("pic")=Trim(Request.form("pic"))
rs("avalible")=Trim(Request.Form("avalible"))
rs.update
rs.close
set rs = nothing
Response.Write("更新成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_doctor.asp'>")
end if
end sub
%>
<% sub list()%>
<table width="100%" border="0" cellspacing="3" cellpadding="0">
<tr>
<td>
<a href="admin_doctor.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 doctor order by id"
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("id")%></font></b></font></td>
</tr>
<tr>
<td height="20"><font color="#000000" size="2">姓名：<%=rs("name")%></font></td>
</tr>
<tr align="left" valign="bottom">
<td height="20"><font color="#000000" size="2"><a href="admin_doctor.asp?action=edit&id=<%=rs("id")%>">编辑</a>
| <a href="admin_doctor.asp?action=del&id=<%=rs("id")%>">删除</a></font></td>
</tr>
</table>
<%
RowCount =RowCount -1
RS.MoveNext
Loop
rs.close
set rs=nothing
%>
<form method="post" action="admin_doctor.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_doctor.asp?action=save">
<table width="450" border="0" cellspacing="0" cellpadding="0">
<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="pic" type="text" id="pic3" 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" valign="top"> 诊断有效时间(如有多项请用,隔开，如8点-11点，2点-4点) </td>
<td height="25" valign="top"><input name="avalible" type="text" 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 doctor (name,sex,depart,job,comment,pic,avalible) values ('"&request("name")&"','"&request("sex")&"','"&request("depart")&"','"&request("job")&"','"&request("comment")&"','"&request("pic")&"','"&request("avalible")&"') "
conn.execute(sql)
Response.Write("添加成功,2秒后系统自动返回。")
Response.write("<meta HTTP-EQUIV=REFRESH CONTENT='2; URL=admin_doctor.asp'>")
end sub%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -