📄 group.asp
字号:
<!--#include file="top.asp"-->
<%
dim sort_id, sort_name, Nsort_id, Nsort_name
dim totalPut
dim CurrentPage, TotalPages
if request("sort_id")<>"" then
sort_id=request("sort_id")
else
sort_id=0
end if
if not isempty(request("page")) then
currentPage=cint(request("page"))
else
currentPage=1
end if
set rs = server.createobject("adodb.recordset")
'set rs1=server.createobject("adodb.recordset")
if trim(request("Nsort_id"))<>"" then
Nsort_id=trim(request("Nsort_id"))
sql="select * from Nsort where Nsort_id="&cstr(Nsort_id)
rs.open sql,conn,1,1
if not rs.eof then
Nsort_name=rs("Nsort_name")
end if
rs.close
else
Nsort_id=0
Nsort_name="分类"
end if
sql="select * from sort where sort_ID="&cstr(sort_id)
rs.open sql,conn,1,1
if not rs.eof then
sort_name=rs("sort_name")
end if
rs.close
%>
<!--#include file="css.asp"-->
<table width="765" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="5"></td>
</tr>
</table>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width=765 height="341">
<TBODY>
<TR>
<TD width=147 valign="top" bgcolor="eeeeee" height="409">
<TABLE border=0 cellPadding=0 cellSpacing=0 width=147 valign="top">
<TBODY>
<TR>
<TD bgColor=#efefef vAlign=top width=147> <TABLE cellPadding=0 cellSpacing=0 width=146>
<TBODY>
<TR>
<TD colSpan=2><IMG
src="images/pics2/wp_main_leftmenu_01.gif"></TD>
</TR>
<TR>
<TD height=18 width=5></TD>
<TD height=18 width=141> <table width="180" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td valign="top"> <table border="0" width="180" cellspacing="0" cellpadding="0" height="18">
<%if session("user_name")<>"" then%>
<tr>
<%sql="select * from member where user_name='"&session("user_name")&"'"
rs.open sql,conn,3,3
%>
</tr>
<tr>
<td width="100%" height="18"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"><table border="0" width="100%" cellspacing="0">
<tr>
<td height="25"> <img src="IMAGES/pics2/login_im1.gif" width="29" height="23" align="absmiddle">
用户名:</td>
<td height="25"><%=rs("user_name")%></td>
</tr>
<tr>
<td height="25"><img src="IMAGES/pics2/login_im3.gif" width="30" height="17" align="absmiddle">
地址:</td>
<td height="25"><%=rs("user_adds")%></td>
</tr>
<tr>
<td height="25"><img src="IMAGES/pics2/login_im2.gif" width="29" height="16" align="absmiddle">
E-mail:</td>
<td height="25"><%=rs("user_mail")%></td>
</tr>
<tr>
<td height="25"><img src="IMAGES/pics2/login_im4.gif" width="29" height="20" align="absmiddle">
电话:</td>
<td height="25"><%=rs("user_tel")%></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<%rs.close%>
<%else%>
<tr>
<td width="100%" height="18"> <table width="99%" border="0" cellspacing="1" cellpadding="0" >
<form method="POST" action="login.asp">
<tr>
<td width="100%" height="110"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td width="32%"> <div align="center">客户：</div></td>
<td width="68%"> <div align="center">
<input name="user_name" type="text" class=input id="user_name5" style="FONT-SIZE: 12px; WIDTH: 110px" size="10" maxlength="18">
</div></td>
</tr>
<tr>
<td> <div align="center">密码：</div></td>
<td> <div align="center">
<input name="user_pass" type="password" class=input id="user_pass" style="FONT-SIZE: 12px; WIDTH: 110px" size="10" maxlength="18">
</div></td>
</tr>
</table>
<div align="center"></div>
<table width="90%" border="0" cellspacing="5" cellpadding="0" align="center">
<tr>
<td width="80"><a href="reg.asp" target="_blank"><img src="images/pics2/reg.gif" width="81" height="25" border="0"></a></td>
<td> <div align="center">
<input
align=absMiddle alt=进入 cache name=submit22
src="images/pics2/login.gif" type=image tppabs="" width="56" height="25">
</div></td>
</tr>
</table></td>
</tr>
</form>
</table>
<%end if%>
</td>
</tr>
</table></td>
</tr>
</table></TD>
</TR>
<TR>
<TD colSpan=2><IMG
src="images/pics2/wp_main_leftmenu_02.gif"></TD>
</TR>
<TR>
<TD colSpan=2 height=7></TD>
</TR>
<TR>
<TD colSpan=2><IMG
src="images/pics2/wp_main_leftmenu_01_2.gif" width="190" height="35" border=0></TD>
</TR>
<TR>
<TD height=18> </TD>
<TD height=18>
<%
sql="select * from sort"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write "没有任何分类"
else
do while not rs.eof
%>
<div align="center"> <a href="sort.asp?sort_id=<%=rs("sort_id")%>"><br>
<font color="#000000"><b><%=rs("sort_name")%></b></font></a><br>
<% set rs1=server.createobject("adodb.recordset")
sql="select * from Nsort where sort_id="&rs("sort_id")
rs1.open sql,conn,1,1
i=0
do while not rs1.eof
i=i+1
%>
<a href="sort.asp?sort_id=<%=rs1("sort_id")%>&Nsort_id=<%=rs1("Nsort_id")%>"><u><%=rs1("Nsort_name")%></u></a>
<%
if (i mod 3<>0) then
%>
<font color="#6699FF"><img src="IMAGES/pics2/bg.gif" width="2" height="14"></font>
<%end if%>
<%
if (i mod 3=0) and i>=3 then
%>
<br>
<%
end if
rs1.movenext
loop
rs1.close
%>
<%
rs.movenext
loop
end if
rs.close
%>
<br>
<br>
</div></TD>
</TR>
<TR>
<TD colSpan=2><IMG
src="images/pics2/wp_main_leftmenu_02.gif" width="146" height="1" border=0></TD>
</TR>
<TR>
<TD colSpan=2 height=5></TD>
</TR>
</TBODY>
</TABLE></TD>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -