📄 dx_product_list.asp
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>商品列表</title>
<!--#include file="Inc/Config.asp"-->
<!--#include file="inc/Dx_admin_check.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="Css/style.css" rel="stylesheet" type="text/css">
<style>
body {
background-color:#FFFFFF;
}
</style>
<script language="javascript">
function collapse(img, objName)
{
var obj;
obj = document.getElementById(objName);
if (img.src.indexOf('open') != -1)
{
img.src = img.src.replace('open', 'close');
obj.style.display = 'none';
}
else
{
img.src = img.src.replace('close', 'open');
obj.style.display = '';
}
}
function preview() {
bdhtml=window.document.body.innerHTML;
sprnstr="<!--startprint-->";
eprnstr="<!--endprint-->";
prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17);
prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));
window.document.body.innerHTML=prnhtml;
window.print();
window.document.body.innerHTML=bdhtml;
}
function SelectProduct(dx_product_model,dx_product_id){
window.opener.document.<%=request.Querystring("form")%>.<%=request.Querystring("field")%>.value=dx_product_model;
window.opener.document.<%=request.Querystring("form")%>.<%=request.Querystring("field2")%>.value=dx_product_id;
window.close();
return false;
}
</script>
</HEAD>
<BODY>
<%
'if session("Dx_Admin")="" then
%>
<!--<br><center><img src="Images/note.gif" align="absmiddle"> <font color="#FF0000">你不具备此权限，请与管理员联系！</font></center>-->
<%
' response.end
'end if
%>
<script>
function CheckAll(form) {
for (var i=0;i<form.elements.length;i++) {
var e = form.elements[i];
if (e.name != 'chkall') e.checked = form.chkall.checked;
}
}
</script>
<%
dx_product_depot = request.QueryString("dx_product_depot")
dx_product_class = request.QueryString("dx_product_class")
keyword = request.QueryString("keyword")
order1 = request.QueryString("order1")
%>
<table width="100%" border="0" cellpadding="0" cellspacing="2" align="center">
<form name="form2">
<tr>
<td width="5%" height="21"> <img src="Images/print.jpg" align="absmiddle" style="cursor:hand;" onClick="preview();window.close()"></td>
<td width="95%" align="right">
<select name="dx_product_depot" onchange="location.href='?page=<%=request.QueryString("page")%>&dx_product_class=<%=dx_product_class%>&keyword=<%=keyword%>&form=<%=request.Querystring("form")%>&field=<%=request.Querystring("field")%>&field2=<%=request.Querystring("field2")%>&dx_product_depot='+this.options[this.selectedIndex].value;">
<option value="">全部仓库</option>
<%
sql="select * from [dx_depot] order by dx_depot_id desc"
rs.open sql,conn,1,1
while not rs.eof
if request.QueryString("dx_product_depot")=rs("dx_depot_name") then
selected="selected='selected'"
else
selected=""
end if
response.Write("<option "&selected&" value='"&rs("dx_depot_name")&"'>"&rs("dx_depot_name")&"</option>")
rs.movenext
wend
rs.close
%>
</select>
<select name="dx_product_class" onchange="location.href='?page=<%=request.QueryString("page")%>&dx_product_depot=<%=dx_product_depot%>&keyword=<%=keyword%>&form=<%=request.Querystring("form")%>&field=<%=request.Querystring("field")%>&field2=<%=request.Querystring("field2")%>&dx_product_class='+this.options[this.selectedIndex].value;">
<option value="">全部类别</option>
<%
sql="select * from [dx_class] order by dx_class_id desc"
rs.open sql,conn,1,1
while not rs.eof
if request.QueryString("dx_product_class")=rs("dx_class_name") then
selected="selected='selected'"
else
selected=""
end if
response.Write("<option "&selected&" value='"&rs("dx_class_name")&"'>"&rs("dx_class_name")&"</option>")
rs.movenext
wend
rs.close
%>
</select>
<input type="text" name="keyword" size="20" value="">
<input type="submit" value=" 查询 " class="button">
</td>
</tr>
</form>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED">
<tr>
<td><img src="Images/r_1.gif" alt="" /></td>
<td width="100%" background="Images/r_0.gif">
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td> 商品列表</td>
<td align="right"> </td>
</tr>
</table>
</td>
<td><img src="Images/r_2.gif" alt="参品详细" /></td>
</tr>
<tr>
<td></td>
<td>
<!--startprint-->
<table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1">
<form name="form1" action="">
<tr align="center">
<td class="category" height="30"><a href="?order1=<%if request("order1")="dx_product_id asc" then%>dx_product_id desc<%else%>dx_product_id asc<%end if%>" class="title">编号<%if request("order1")="dx_product_id asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
<td class="category"><a href="?order1=<%if request("order1")="dx_product_model asc" then%>dx_product_id desc<%else%>dx_product_model asc<%end if%>" class="title">型号<%if request("order1")="dx_product_model asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
<td class="category"><a href="?order1=<%if request("order1")="dx_product_brand asc" then%>dx_product_brand desc<%else%>dx_product_brand asc<%end if%>" class="title">品牌<%if request("order1")="dx_product_brand asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
<td class="category"><a href="?order1=<%if request("order1")="dx_product_class asc" then%>dx_product_class desc<%else%>dx_product_class asc<%end if%>" class="title">分类<%if request("order1")="dx_product_class asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
<td class="category"><a href="?order1=<%if request("order1")="dx_product_depot asc" then%>dx_product_depot desc<%else%>dx_product_depot asc<%end if%>" class="title">仓库<%if request("order1")="dx_product_depot asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
<td class="category"><a href="?order1=<%if request("order1")="dx_product_time asc" then%>dx_product_time desc<%else%>dx_product_time asc<%end if%>" class="title">添加时间<%if request("order1")="dx_product_time asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
<td class="category"><a href="?order1=<%if request("order1")="dx_product_user asc" then%>dx_product_user desc<%else%>dx_product_user asc<%end if%>" class="title">经办人<%if request("order1")="dx_product_user asc" then%><img src="Images/up2.gif" border="0" hspace="2" align="absmiddle"><%else%><img src="Images/down2.gif" border="0" hspace="2" align="absmiddle"><%end if%></a></td>
</tr>
<%
keyword1 = split(keyword)
sql="select * from [ProductList] where "
if dx_product_depot<>"" then
sql=sql&"dx_depot_name='"&dx_product_depot&"' and "
end if
if dx_product_class<>"" then
sql=sql&"dx_class_name='"&dx_product_class&"' and "
end if
if request.QueryString("keyword")<>"" then
for k = 0 to Ubound(keyword)
sql=sql&"dx_product_model='"&keyword1(k)&"' and "
next
end if
sql=left(sql,len(sql)-4)
if order1<>"" then
sql=sql&" order by "&order1&""
else
sql=sql&" order by dx_product_id desc"
end if
rs.open sql,conn,1,1
if not rs.eof then
Dx_product_count=8
rs.pagesize=Dx_product_count
page_now=1
if trim(request.QueryString("page"))<>"" then
page_now=cint(trim(request.QueryString("page")))
end if
if page_now>rs.pagecount or page_now<0 then
page_now=1
end if
rs.absolutepage=page_now
i=1
while(not rs.eof) and i<Dx_product_count+1
%>
<tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''" onDblClick="SelectProduct('<%=rs("dx_product_model")%>',<%=rs("dx_product_id")%>);">
<td align="center" height="25"><%=rs("dx_product_id")%></td>
<td align="center"><%=rs("dx_product_model")%></td>
<td align="center"><%=rs("dx_brand_name")%></td>
<td align="center"><%=rs("dx_class_name")%></td>
<td align="center"><%=rs("dx_depot_name")%></td>
<td align="center"><%=DateValue(rs("dx_product_time"))%></td>
<td align="center"><%=rs("dx_product_user")%></td>
</tr>
<%
rs.movenext
i=i+1
wend
else
%>
<tr align="center" onMouseOver="this.className='highlight'" onMouseOut="this.className=''">
<td colspan="16" height="25" align="center" style="color:red"><b>没有找到记录</b></td>
</tr>
<%end if%>
<tr>
<td colspan="16" height="30" class="category">
<table cellpadding=0 cellspacing=0 width="100%">
<tr>
<td width="20%" align="left" style="color:#FF0000;"> 双击选择商品</td>
<td width="80%" align="right">
<select name="page" onChange="form1.action='?';form1.submit();">
<option value="">1</option>
</select>
<input name="chkall" type="checkbox" id="chkall" value="select" onClick="CheckAll(this.form)" style="border:0"> 全选
<input type="submit" value="删 除" onClick="return confirm('此操作无法恢复！！！请慎重！！！\n\n确定要删除所选择的退货记录吗？')" class="button"> </td>
</tr></table></td></tr>
</form>
</table>
<!--endprint-->
</td>
<td></td>
</tr>
<tr>
<td><img src="Images/r_4.gif" alt="" /></td>
<td></td>
<td><img src="Images/r_3.gif" alt="" /></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -