📄 g_member.asp
字号:
<!--#include file="../function/connect.asp"-->
<%
Group_ID=request("Group_ID")
if Group_ID="" then
response.end
end if
strsql="select * from clients c,GroupMembers g where c.client_id=g.client_ID "
strsql=strsql & " and g.Group_ID=" & Group_ID & " and (c.IsPublic=1 or c.client_owner='" & session("loginuser") & "')"
Set objRs = Server.CreateObject("adodb.recordset")
objRs.Open strsql,objConn,1,1
%>
<html>
<head>
<title>国家</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../cssD.css" rel=stylesheet>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="103%" border="1" cellspacing="0" cellpadding="2" bordercolorlight='#000000' bordercolordark='#FFFFFF'>
<form name="form1" method="post" action="clientlist.asp">
<tr class="tablehead">
<td width="20%" nowrap>
<div align="center">客户名称</div>
</td>
<td width="19%" nowrap>
<div align="center">客户编号</div>
</td>
<td width="19%" nowrap>
<div align="center">Email</div>
</td>
<td width="19%" nowrap>
<div align="center">电话</div>
</td>
<td width="19%" nowrap>
<div align="center">地址</div>
</td>
<td width="19%" nowrap>
<div align="center">添加日期</div>
</td>
</tr>
<%if not objrs.eof then
do while not objrs.eof
%>
<tr align="center">
<td width="20%" nowrap> <a href="editclient.asp?IID=<%=objrs.fields("client_id")%>" target="right"><%=objrs.fields("client_name")%></a></td>
<td width="19%" nowrap> <%=objrs.fields("client_code")%></td>
<td width="19%" nowrap> <%=objrs.fields("client_email")%></td>
<td width="19%" nowrap> <%=objrs.fields("client_tel")%></td>
<td width="19%" nowrap> <%=objrs.fields("client_address")%></td>
<td width="19%" nowrap> <%=objrs.fields("client_date")%></td>
</tr>
<%
objrs.movenext
loop
else%>
<tr align="center">
<td colspan="7">
没有客户
</td>
</tr>
<%end if%>
<input type="hidden" name="meth" value="del">
<tr align="center">
<td colspan="7">
<input type="button" value=" 修改组成员 " class="button" onclick="location.href='groupMember.asp?Group_ID=<%=request("Group_ID")%>';">
</td>
</tr>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -