📄 personallistpda.asp
字号:
<!--#INCLUDE FILE="../HXINCLUDE/HXINCLUDEHEAD.ASP"-->
<%ColumnName="":Tablename="HX_PersonalPDA":Orderby=" where WS_Userid="&LoginUid&" ORDER BY WS_PAID DESC":action=request("action")
if action="del" then
WS_PAID=request("WS_PAID")
if WS_PAID="" or isnull(WS_PAID) or (WS_PAID<>"" and not isnumeric(WS_PAID)) then HX_GoBack "非法操作",""
conn.execute("delete from "&Tablename&" where WS_PAID="&WS_PAID)
WS_S.HX_Redirect "PersonalListPDA.asp?page="&request("page")
end if
set rs=WS_S.HX_SetRSD(ColumnName,Tablename,Orderby)
response.write "<head><meta http-equiv='Content-Type' content='text/html; charset=gb2312'><title>个人通迅录</title><link rel=stylesheet type=text/css href='../HXinclude/HX_Style.css'><script src='../HXinclude/HX_Function.js'></script></head><body topmargin='20' leftmargin='0' bottommargin='0'><table width='596' border='0' cellspacing='1' cellpadding='0' align=center bgcolor='#115F8F'><tr><td colspan='2' bgcolor=ffffff><table width='100%' border='0' cellspacing='0' cellpadding='0'><tr><td height='25' background='../hximages/titleline.gif'><font class='fontmenu'>个人通迅录</font> <a href='javascript:' onClick=""openwin(550,300,'PersonalAddPDA.asp')""><font color='#FFFFFF'>添加个人通迅录</font></a></td></tr></table><table width='100%' border='0' cellspacing='1' cellpadding='3' bgcolor=f1f1f1><tr bgcolor='#A1BBE0' class='td4'><td width='7%' align='center'>序号</td><td width='13%' align='center'>姓名</td><td width='15%' align='center'>电话</td><td width='18%' align='center'>手机</td><td width='14%' align='center'> E-Mail </td><td width='15%' align='center'> 关系 </td><td align='center' colspan='2'>操作</td></tr>"
if rs.recordcount<=0 then
response.Write "<tr><td colspan=8 bgcolor=ffffff height=25 align=center>暂无记录！</td></tr>"
else
rs.PageSize =15 '每页记录条数
iCount=rs.RecordCount '记录总数
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
ii=0
do while not rs.EOF
response.write "<tr align='center' bgcolor='#FFFFFF' onmouseover=javascript:this.bgColor='#F9F8F2' onmouseout=javascript:this.bgColor='#ffffff'><td width='7%'>"&rs("WS_PAID")&"</td><td width='13%'><a href='javascript:' onClick=""openwin(550,300,'PersonalView.asp?WS_PAID="&rs("WS_PAID")&"');"">"&rs("WS_PersonalName")&"</td><td width='15%'>"&rs("WS_PersonalTel")&"</td><td width='18%'>"&rs("WS_PersonalMobile")&"</td><td width='14%'>"&rs("WS_PersonalEmail")&"</td><td width='15%'>"&rs("WS_PersonalRelation")&"</td><td width='9%'><input type='button' name='modify' value='修改' onClick=""openwin(550,300,'PersonalModify.asp?WS_PAID="&rs("WS_PAID")&"');""></td><td width='9%'><input type='button' name='deld' value='删除' onClick=""location.href='?action=del&WS_PAID="&rs("WS_PAID")&"&page="&Page&"';""></td></tr>"
ii=ii+1
if ii>=rs.PageSize then Exit Do
rs.movenext
loop
call WS_S.PageControl(iCount,maxpage,page,"border=0 align=right","<p align=right>",8)
end if
WS_S.HX_RSClose rs
response.Write "</table></td></tr></table>"%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -