📄 cardcase_index.asp
字号:
<%
'功能：查看所有名片夹
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'response.buffer=false
'------------------------------------------------设置参数
LoginID=trim(session("LoginID")) : if LoginID="" then LoginID=0 '当前用户ID
'------------------------------------------------
'------------------------------------------------取记录
'取名片夹记录 （返回rs对象）
'
where="where UserID="&LoginID '查寻条件
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from tbioaCardcase "&where&" order by ID"
rs.open sql,oConn,1,1
'------------------------------------------------
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>main</title>
<base target="FrmMain">
</head>
<body topmargin="10" leftmargin="10">
<!--#include file="cardcase_menu.html"-->
<hr width="100%" size=1 color="#000000">
<%
if rs.RecordCount=0 then
response.write "<BR><BR>暂时为空！"
else
%>
<table border="0" width="100%" cellspacing="10" cellpadding="0"><tr>
<%dim i: i=0
while not rs.EOF '循环
if (i mod 2 = 0) then response.write ("</tr><tr>")
i=i+1
set rs1=server.createobject("adodb.recordset")
sql="SELECT COUNT(*) FROM tbioaNamecard where CaseID="&rs("ID")
rs1.open sql,oconn,1,1
%>
<td width="50%" align="center" valign="top">
<table width="100%" cellspacing="1" cellpadding="2" class="tab">
<tr>
<td width="100%" class="tdTop">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="tdTop">
<p align="left"><img border="0" src="../images/icon_title.gif" align="left"><%=HtmlOut(rs("Title"))%></p>
</td>
<td width="60" class="tdTop">
<p align="left"><img border="0" src="../images/icon_edit.gif" align="left">
<a href="cardcase_edit.asp?id=<%=rs("ID")%>" class="linkTop">编辑</a></p>
</td>
<td width="60" class="tdTop">
<p align="left"><img border="0" src="../images/icon_dele.gif" align="left">
<a href="cardcase_dele.asp?id=<%=rs("ID")%>" onClick="return confirm('删除名片夹后，该名片夹中的名片也将被删除！\n建议将该名片移到其他名片夹后再删除。\n\n确定要删除该名片夹吗？\n该操作不可恢复！')" class="linkTop">删除</a></p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="25%" class="td1">
<table width="100%" cellspacing="3" cellpadding="2">
<tr>
<td width="200" class="td1">名片张数:<%=rs1(0)%> (张)</td>
<td>
<table width="180" border=0 cellspacing="0" cellpadding="0">
<tr>
<td><img border="0" src="../images/icon_show.gif" align="left"><a href="namecard_index.asp?caseid=<%=rs("ID")%>">查看</a></td>
<td><img border="0" src="../images/icon_close.gif" align="left"><a href="namecard_add.asp?caseid=<%=rs("ID")%>">添加名片</a></td>
</tr>
</table>
</td>
</tr>
<tr><td class="tdBottom" colspan="2"></td></tr>
<tr>
<td class="td1" colspan="2"><%=HtmlOut(rs("Body"))%></td>
</tr>
<tr><td class="tdBottom" colspan="2"></td></tr>
</table>
</td>
</tr>
<tr>
<td width="25%" class="tdBottom">
</td>
</tr>
</table>
</td>
<%rs1.close: rs.MoveNext: wend%>
</tr></table>
<%
end if
rs.close
%>
</body>
</html>
<%'释放对象变量
oConn.close
%> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -