📄 xx_prolist.asp
字号:
<!--#include file=conn.asp-->
<!--#include file=cookies.asp-->
<!--#include file=function.asp-->
<html>
<head><link href="css.css" rel="stylesheet" type="text/css">
<title>祥星送货单打印系统--增加送货单</title>
</head>
<body>
<table border=1 width=100% cellpadding=0 cellspacing=0 bordercolorlight=#cccccc bordercolordark=#ffffff>
<tr bgcolor=#efefef><td align=center>商品编号</td><td align=center>商品名称</td><td align=center>商品规格</td><td align=center>商品类别</td><td align=center>商品单位</td><td align=center>操作</td></tr>
<%if request("id")<>"" then
Dim pro,pro1,pro2,pro3,pro4,pro5,pro6
Set pro=Conn.Execute("Select ID,Product_id,ShopName,ShopUnit,types,GuiGe From [XX_Products] where ID="&request("id")&"")
pro1=pro(0)
pro2=pro(1)
pro3=pro(2)
pro4=pro(3)
pro5=pro(4)
pro6=pro(5)
end if%>
<form action="XX_Save.asp?Action=ManPro" method=post id=form1 name=form1 onSubmit="return chk(this)">
<tr bgcolor=#efefef><td align=center><input name="product_id" type="text" id="product_id" value="<%=pro2%>" size="15" maxlength="20" readonly></td>
<td align=center><input name="pname" type="text" id="pname" size="25" maxlength="30" value="<%=pro3%>"></td>
<td align=center><input name="spgg" type="text" id="spgg" size="10" maxlength="30" value="<%=pro6%>"></td>
<td align=center><select name="type" id="type">
<option value="" >请选择商品类别</option>
<%
Dim ty
Set ty=Conn.Execute("Select ID,Class From [Product_Class] Order By ID desc")
Do While Not ty.Eof
if ty(0)=pro5 then
Response.Write "<option value='"& ty(0) &"' selected>" & ty(1) & "</option>"
else
Response.Write "<option value='"& ty(0) &"'>" & ty(1) & "</option>"
end if
ty.MoveNext
Loop
ty.Close
Set ty=Nothing
%>
</select></td>
<td align=center> <select name="SUnit" id="SUnit"> <option value="" >请选择商品单位</option>
<%
Set ty=Conn.Execute("Select ShopUnit From [XX_ShopUnit] Order By ID desc")
Do While Not ty.Eof
if ty(0)=pro4 then
Response.Write "<option value='"& ty(0) &"' selected>" & ty(0) & "</option>"
else
Response.Write "<option value='"& ty(0) &"'>" & ty(0) & "</option>"
end if
ty.MoveNext
Loop
ty.Close
Set ty=Nothing
%>
</select></td>
<td align=center>
<input name="ID" type="hidden" id="ID" size="25" maxlength="30" value="<%=pro1%>">
<input type="submit" name="Submit" value="修 改"></td>
</tr>
</form>
</table>
<br><br>
<%
Set Rs=Server.Createobject("adodb.recordset")
Sql="Select * from XX_Products order by id desc"
Rs.Open Sql,Conn,1,1
response.write"<table border=1 width=100% cellpadding=0 cellspacing=0 bordercolorlight=#cccccc bordercolordark=#ffffff>"
response.write"<tr bgcolor=#efefef><td align=center>商品编号</td><td align=center>商品名称</td><td align=center>商品规格</td><td align=center>商品类别</td><td align=center>商品单位</td><td align=center>操作</td></tr>"
if rs.bof and rs.eof then
response.write"<tr bgcolor=#efefef><td align=center>对不起没有找到记录！</td></tr>"
else
page=request("page")
rs.pagesize=20'每页显示记录数
j=rs.pagesize
Allrecord=rs.Recordcount '得到记录总数
Allpage=rs.pagecount '得到页总数
if not isnumeric(page) or page="" then
page=1
else page=clng(page)
end if
if page<1 then
page=1
elseif page>Allpage then
page=allpage
end if
rs.absolutepage=page
for i=1 to j
response.write"<tr bgcolor=#efefef><td align=center>"&rs("Product_ID")&"</td>"
response.write"<td align=center>"&rs("ShopName")&"</td>"
response.write"<td align=center>"&rs("GuiGe")&" </td>"
response.write"<td align=center>"&conn.execute("select top 1 Class from Product_Class where id="&rs("types")&"")(0)&"</td>"
response.write"<td align=center>"&rs("ShopUnit")&"</td>"
response.write"<td align=center><a href=XX_ProList.asp?id="&rs("id")&">修改</a> <a href=XX_save.asp?action=DelPros&id="&rs("id")&">删除</a></td>"
response.write"</tr>"
rs.movenext
if rs.eof then exit for
next
end if
rs.close
response.write"</table>"
response.write"<table border=0 width=100% ><tr>"
response.write"<td align=center>"
if page<2 then
response.write"首页 "
response.write"上一页 "
else
response.write"<a href=XX_ProList.asp>首页 </a>"
response.write"<a href=XX_ProList.asp?page="&page-1&">上一页 </a>"
end if
if Allpage-page<>0 then
response.write"<a href=XX_ProList.asp?page="&page+1&">下一页 </a>"
response.write"<a href=XX_ProList.asp?page="&Allpage&">尾页 </a>"
else
response.write"下一页 "
response.write"尾页 "
End if
response.write"</td></tr></table>"
'打开入库记录游标，取得数据以便修改
%></center>
</body></html>
<script javascript=javascript>
function check(){
if (document.addform.listnum.value=="")
{
alert ("请输入货单号。");
document.addform.listnum.value='';
document.addform.listnum.focus();
return false;
}
if (document.addform.listuser.value=="")
{
alert ("请输入送货对象。");
document.addform.listuser.value='';
document.addform.listuser.focus();
return false;
}
var istrue;
istrue=confirm('您确定无误要入库是吗？');
if(istrue) {
return true;
}
else {
return false;
}
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -