?? xx_addgoodsunit.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 width=100% class=inputb><tr><td align=center>貨單入庫</td></tr></table>
<%if request("id")<>"" then
set rsm=server.CreateObject("adodb.recordset")
rsm.open "select * from XX_GoodsUnit where id="&request("id")&"",conn,1,1
listnum=rsm("listnum")
listuser=rsm("listuser")
listmeno=rsm("listmeno")
end if%>
<%set rs2=server.CreateObject("adodb.recordset")
rs2.open"select * from xx_config where start=0 and ones=1",conn,1,1
if not rs2.eof then
listnums=rs2("Deliverynum")+rs2("usernums")
lennums=rs2("Deliverylen")
else
Response.Write "<script language=javascript>alert('請設置編號開始數字!');"
Response.Write "window.document.location.href='xx_PrintConfig.asp';</script>"
end if
rs2.close
set rs2=nothing
%>
<center><form name=addform action="XX_Save.asp" method="post" >
<input name="action" type="hidden" value="GoodsUnit">
<table border="0" cellpadding="0" cellspacing="0" width="70%">
<%if request("id")="" then
set rs3=server.CreateObject("adodb.recordset")
rs3.open"select * from xx_config where start=0 and ones=1",conn,1,1
if not rs3.eof then
listnums=rs3("Deliverynum")+rs3("usernums")%>
<tr><input name="id" type="hidden" value=0><input name="id2" type="hidden" value=<%=rs3("id")%>><td>貨單批號：<input name="listnum" type="text" value="<%=gen(listnums,lennums)%>" >
</td></tr><%else
rs3.close
set rs3=nothing
end if
%><tr><input name="id" type="hidden" value=<%=request("id")%>>
</tr><%end if%>
<tr><td>送貨對象：<input name="listuser" type="text" value="<%=listuser%>" >
</td></tr>
<tr>
<td> 備 注 ：
<textarea name="listmeno" rows="5"><%=listmeno%></textarea></td></tr>
<tr><td><input name="mm" type="submit" class="inputb" value="確定添加" onclick='return check();'>
<input name="submit2" type="reset" value="放棄添加" class="inputb"></td></tr>
</table>
</form></center>
<center><%
'Cxyf=Request.QueryString("yuefen")
Set Rs=Server.Createobject("adodb.recordset")
'if Cxyf="" then
Sql="Select * from XX_GoodsUnit order by id desc"
'else
'Sql="Select * from XX_GoodsUnit where month(Jkrq)="&Cxyf&" order by id desc"
'end if
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>ID編號</td><td align=center>貨單編號</td><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("ID")&"</td>"
response.write"<td align=center><a href=xx_LookGoodsUnit.asp?listnum="&rs("listnum")&">"&gen(rs("listnum"),lennums)&"</a></td>"
response.write"<td align=center>"&rs("listuser")&"</td>"
response.write"<td align=center>"&rs("shopnum")&"件</td>"
response.write"<td align=center>"&rs("summoney")&"</td>"
response.write"<td align=center>"&rs("username")&"</td>"
response.write"<td align=center>"&rs("addtime")&"</td>"
response.write"<td align=center><a href=XX_AddIndenture.asp?listnum="&rs("listnum")&">填單</a> <a href=XX_AddGoodsUnit.asp?id="&rs("id")&">修改</a> <a href=XX_save.asp?action=DelGoods&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_AddGoodsUnit.asp>首頁 </a>"
response.write"<a href=XX_AddGoodsUnit.asp?page="&page-1&">上一頁 </a>"
end if
if Allpage-page<>0 then
response.write"<a href=XX_AddGoodsUnit.asp?page="&page+1&">下一頁 </a>"
response.write"<a href=XX_AddGoodsUnit.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 + -