📄 as_delete_user.asp
字号:
<!-- #include file="conn.asp" -->
<body bgcolor="">
<SCRIPT LANGUAGE="vbScript">
<!--
Sub del(userID)
If MsgBox("您要删除该用户？",vbyesno,"警告!!!")=vbyes Then
f1.hid_userID.value=userID
f1.action="as_delete_user.asp"
f1.submit
End If
End Sub
//-->
</SCRIPT>
<style>
table tr{text-align:center}
</style>
<FORM METHOD=POST ACTION="" name="f1">
<INPUT TYPE="hidden" name="hid_userID">
<TABLE border="1" bordercolor="#0000000">
<TR>
<TD width="80" height="35">用户编号</TD>
<TD width="160">用户名</TD>
<TD width="200">用户单位</TD>
<TD width="150">借书数量</TD>
<TD width="150">备注</TD>
<TD width="80">操作</TD>
</TR>
<%
Dim userID,str1
userID=request("hid_userID")
If userID<>"" Then
str1="delete from [user] where user_id='" & userID & "'"
'response.redirect str1
conn.execute(str1)
End If
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim str,State
str="select * from [User]"
Set rec=conn.execute(str)
Do While Not rec.eof
If rec(3)<>0 Then
temp=rec(3) & "本"
Else
temp="<FONT COLOR=""#FF0066"">没有借书</FONT>"
End If
If rec(4)<>"" Then
State=rec(4)
else
State="<FONT COLOR=""#FF0066"">暂时无备注</FONT>"
End If
%>
<TR>
<TD height="35"><%=rec(0)%></TD>
<Td><%=rec(1)%></TD>
<TD><%=rec(2)%></TD>
<TD><%=temp%></TD>
<TD><%=State%></TD>
<%
Dim str2
str2="select user_number from [user] where user_id='" & rec(0) & "'"
Set recmy=conn.execute(str2)
If recmy(0)=0 then
%>
<td><A href="#" onclick="del(<%=rec(0)%>)">删除</a></td>
<%
Else
%>
<td><FONT COLOR="red">不可操作</FONT></a></td>
<%
End if
%>
</TR>
<%
rec.movenext
Loop
%>
</TABLE>
</FORM>
</body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -