📄 stockpile_product.asp

📁 ASP数据库系统开发案例精选(光盘）中的客户关系管理系统用户名/密码：admin/admin
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file=DataBase/conn.asp-->
<!--#include file=config.asp-->
<%
set rsr=server.CreateObject("adodb.recordset")
sqlr="select * from tb_User where username='"&session("admin_name")&"'"
rsr.open sqlr,conn,1,1

if request("post")<>"" then
	if request("tiao")="模糊查询" then
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from tb_Product where "&request("sel")&" like '%"&request("search")&"%' order by id desc"
	rs.open sql,conn,1,1
	else
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from tb_Product where "&request("sel")&"='"&request("search")&"' order by id desc"
	rs.open sql,conn,1,1
	end if
else
set rs=server.CreateObject("adodb.recordset")
sql="select * from tb_Product order by id desc"
rs.open sql,conn,1,1
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="css/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
body {
	background-color: #DFEEFF;
}
.style3 {color: #FFFFFF}
-->
</style></head>
<script language="javascript">
function HLItem(obj){
	obj.oldClassName=obj.className;
	obj.className="List";
}
function Re(obj){
 obj.className=obj.oldClassName
}
</script>

<body>
<table width="100%"  border="0" >
  <tr>
    <td valign="top">	<fieldset class="fiedset">
  <legend>
  <input name="radiobutton" type="radio" onClick="location='Stockpile.asp'" value="radiobutton">
  库存管理
  <input name="radiobutton" type="radio" value="radiobutton" checked> 
  产品管理
  </legend>
  <form name="form1" method="post" action="">
    <table width="90%" height="27"  border="0" align="center" cellspacing="0" class="table">
      <tr align="center">
        <td width="14%" height="27">快速查询：
          <input name="post" type="hidden" id="post" value="true"></td>
        <td width="16%"><span class="style3">
          <select name="tiao" id="tiao">
            <option value="模糊查询" <%if request("tiao")="模糊查询" then%>selected<%end if%>>模糊查询</option>
            <option value="精确查询" <%if request("tiao")="精确查询" then%>selected<%end if%>>精确查询</option>
          </select>
        </span></td>
        <td width="7%">字段：</td>
        <td width="17%"><span class="style3">
          <select name="sel" id="sel">
            <option value="ProductNumber">产品编号</option>
            <option value="ProductName">产品名称</option>
            <option value="ProductProvider">供 应 商</option>
          </select>
        </span></td>
        <td width="7%" >关键字：</td>
        <td width="23%"><input name="search" type="text" id="search" value="<%=request("search")%>"></td>
        <td width="16%"><input name="Submit" type="submit" class="input" value="　查　询　" #invalidattr_id="1px groove"></td>
      </tr>
    </table>
  </form>  
  <form name="form2" method="post" action="Stockpile_Product_del.asp?p=<%=request("p")%>">
    <table width="90%"  border="0" align="center" cellspacing="0">
      <tr>
        <td width="6%"><table width="100%"  border="0" cellspacing="0" class="table">
          <tr>
            <td bgcolor="#000099" class="listTitle">&nbsp;</td>
          </tr>
		  		  <%
		  if not rs.eof then
		  tol=rs.recordcount
		  rs.pagesize=15
		  maxpage=rs.pagecount
		  requestpage=clng(request("p"))
		  if requestpage="" or requestpage=0 then
		  requestpage=1
		  end if
		  if requestpage>maxpage then
		  requestpage=maxpage
		  end if
		  if requestpage<>1 then
		  rs.move (requestpage-1)*rs.pagesize
		  end if
		  for i=1 to rs.pagesize and not rs.eof 
		  if i mod 2=1 then
		  bg="#FFFFFF"
		  else
		  bg="#efefef"
		  end if
		  %>
          <tr>
            <td align="center" bgcolor=<%=bg%>><input name="del" type="checkbox" id="del" value="<%=rs("id")%>"></td>
          </tr>
		  		  <%
		  	rs.movenext
			if rs.eof then exit for
			next
			else
			response.Write("&nbsp;")
			end if
		  %>
        </table></td>
        <td width="94%"><table width="100%"  border="0" align="center" cellspacing="0" bordercolor="#FFFFFF" class="table">
          <tr bordercolor="#ffffff" cellpadding="0">
            <td width="19%" align="center"  class="listTitle">产品编号</td>
            <td width="19%" align="center"  class="listTitle">产品名称</td>
            <td width="19%" align="center"  class="listTitle">产品单位</td>
            <td width="19%" align="center"  class="listTitle">供应商</td>

          </tr>
<%
if request("post")<>"" then
	if request("tiao")="模糊查询" then
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from tb_Product where "&request("sel")&" like '%"&request("search")&"%' order by id desc"
	rs.open sql,conn,1,1
	else
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from tb_Product where "&request("sel")&"='"&request("search")&"' order by id desc"
	rs.open sql,conn,1,1
	end if
else
	set rs=server.CreateObject("adodb.recordset")
	sql="select * from tb_Product order by id desc"
	rs.open sql,conn,1,1
end if
if not rs.eof then
	tol=rs.recordcount
	rs.pagesize=15
	maxpage=rs.pagecount
	requestpage=clng(request("p"))
	if requestpage="" or requestpage=0 then
		requestpage=1
	end if
	if requestpage>maxpage then
		requestpage=maxpage
	end if
	if requestpage<>1 then
		rs.move (requestpage-1)*rs.pagesize
	end if
	for i=1 to rs.pagesize and not rs.eof 
	if i mod 2=1 then
		bg="#FFFFFF"
	else
		bg="#efefef"
	end if
%>
          <tr align="center" bgcolor=<%=bg%> style="cursor:hand" onClick="window.parent.frames('bo').window.location = 'Stockpile_Product_ed.asp?id=<%=rs("id")%>'" onMouseOver="HLItem(this)" onMouseOut="Re(this)">
            <td height="22"><%=rs("ProductNumber")%></td>
            <td><%=rs("ProductName")%></td>
            <td><%=rs("ProductUnit")%></td>
            <td>
			<%
			'显示供应商
			set rsp=server.CreateObject("adodb.recordset")
			sqlp="select * from tb_Client where id="&rs("ProductProvider")
			rsp.open sqlp,conn,1,1
			response.Write(rsp("ClientName"))
			%></td>
          </tr>
<%
	rs.movenext
	if rs.eof then exit for
	next
else
	response.Write("没有客户信息，请<a href='Stockpile_Product_add.asp' target='bo'>添加</a>")
end if
%>
        </table></td>
      </tr>
    </table>
    <table width="90%"  border="0" align="center">
      <tr>
        <td width="37%"><%if rsr("Product")="可写" or rsr("chaoji")="是" then%><input name="Submit2" type="button" class="input" value=" 添 加 " onClick="window.parent.frames('bo').window.location = 'Stockpile_Product_add.asp'">
            <input name="Submit22" type="submit" class="input" value=" 删 除 " onClick="return confirm('确定删除吗？')"><%end if%>
            <input name="Submit23" type="button" class="input" value=" 返　回 " onClick="location='Stockpile_Product.asp'"></td>
        <td width="63%" align="right">
		<%if request("post")="" then%>
		<a href="Stockpile_Product.asp?p=1">首页</a> <a href="Stockpile_Product.asp?p=<%=requestpage-1%>">上一页</a> <a href="Stockpile_Product.asp?p=<%=requestpage+1%>">下一页</a> <a href="Stockpile_Product.asp?p=<%=maxpage%>">最后一页</a> 当前页：<%=requestpage%> 总页数：<%=maxpage%> 总产品数：<%=tol%> 
		<%else%>
		<a href="Stockpile_Product.asp?p=1&tiao=<%=request("tiao")%>&sel=<%=request("sel")%>&search=<%=request("search")%>&post=true">首页</a> <a href="Stockpile_Product.asp?p=<%=requestpage-1%>&tiao=<%=request("tiao")%>&sel=<%=request("sel")%>&search=<%=request("search")%>&post=true">上一页</a> <a href="Stockpile_Product.asp?p=<%=requestpage+1%>&tiao=<%=request("tiao")%>&sel=<%=request("sel")%>&search=<%=request("search")%>&post=true">下一页</a> <a href="Stockpile_Product.asp?p=<%=maxpage%>&tiao=<%=request("tiao")%>&sel=<%=request("sel")%>&search=<%=request("search")%>&post=true">最后一页</a> 当前页：<%=requestpage%> 总页数：<%=maxpage%> 总产品数：<%=tol%> 
		<%end if%>		
		
		&nbsp;每页显示15条信息</td>
      </tr>
    </table>
  </form>
  <p><br>
      </p>
	 </fieldset></td>
  </tr>
</table>

</body>
</html>
💿 文件大小 382 K
👤 上传用户 zhou28
📂 所属分类软件测试
🏷️ 相关标签

#admin #ASP #数据库 #光盘
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -