📄 editdelivery.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "order","read"
set objcheck=nothing
dim conn
dim rs
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
conn.Open connstring
rs.Open "select * from v_delivery where deliveryid="&request("deliveryid"),conn,1,1
if rs.EOF then
Response.Write "记录不存在"
Response.end
end if
dim conndeliveryline
dim rsdeliveryline
set conndeliveryline=server.CreateObject("adodb.connection")
set rsdeliveryline=server.CreateObject("adodb.recordset")
conndeliveryline.Open connstring
rsdeliveryline.Open "select * from v_deliveryline where deliveryid="&request("deliveryid"),conndeliveryline,1,1
%>
<html>
<head>
<LINK href="../global.css" rel=STYLESHEET type=text/css>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=rs("ordernum")%></title>
<script language=javascript>
function create(){
var actualqty;
var maxavailable;
var lineqty;
for(i=1;i<form1.linecount.value;i++){
actualqty='actualqty'+i;
maxavailable='maxavailable'+i
lineqty='lineqty'+i
if(form1.item(actualqty).value==''){
alert('请输入实发数量，取消细目行请输入0');
form1.item(actualqty).focus();
return false;
}
if(isNaN(form1.item(actualqty).value)){
alert('请输入实发数量，取消细目行请输入0');
form1.item(actualqty).focus();
return false;
}
if(parseInt(form1.item(actualqty).value)>parseInt(form1.item(lineqty).value)){
alert('发货数量不能大于合同数量');
form1.item(actualqty).focus();
return false;
}
if(parseInt(form1.item(actualqty).value)>parseInt(form1.item(maxavailable).value)){
alert('提示:在库可用量不足');
//form1.item(actualqty).focus();
//return false;
}
}
form1.submit();
}
function calculateamount(i){
var actualqty="actualqty"+i;
var discountprice="discountprice"+i;
var amount="amount"+i;
form1.item(amount).value=form1.item(discountprice).value*form1.item(actualqty).value;
}
</script>
<%
if Request.Form("print")<>"" then
'dim c:c=0
'for i=1 to request.Form("linecount")
' if Request.Form("actualqty"&i)<>0 and Request.Form("actualqty"&i)<>"" then
' c=c+1
' end if
'next
'if c=0 then
' Response.Write "没有发货细目"
' response.end
'else
' '取参数
' set rspara=conn.Execute("select * from parameter where type='delivery'")
' set rsd=conn.Execute("select * from delivery order by deliveryid desc")
' x=1
' for l=1 to rspara("len")
' x=x*10
' next
' if not rs.EOF then
' x=x+rsd("deliveryid")+1
' else
' x=x+1
' end if
' deliveryNo=rspara("prefix")&right(x,len(x)-1)
' sql="insert into delivery(deliveryNo,OrderId,Status,Owner,Creator,CreateDate,LastModUser,LastModDate,TotalAmount)values('"&deliveryNo&"',"&request("orderid")&",'初始','"&rs("userid")&"','"&session("loginid")&"','"&date()&"','"&session("loginid")&"','"&date()&"',0)"
' response.write sql
' response.end
' set rsd=conn.execute(sql)
' sql="select * from delivery order by deliveryid desc"
' set rsd=conn.execute(sql)
' deliveryid=rsd("deliveryid")
'end if
sql="delete from deliveryline where deliveryid="&request("deliveryid")
set rsd=conn.execute(sql)
sql="update delivery set invoice="&request("invoice")&" where deliveryid="&request("deliveryid")
set rsd=conn.execute(sql)
dim totalamount
totalamount=0
for i=1 to request.Form("linecount")
if Request.Form("actualqty"&i)<>0 and Request.Form("actualqty"&i)<>"" then
sql="insert into deliveryline(deliveryid,OrderLineid,Productid,model,productcode,Qty,Price,Discount,discountprice,Amount,shipdate,Creator,CreateDate,LastModUser,LastModDate) values("&request("deliveryid")&","&request("orderlineid"&i)&","&request("productid"&i)&",'"&request("model"&i)&"','"&request("productcode"&i)&"',"&request("actualqty"&i)&","&request("price"&i)&","&request("discount"&i)&","&request("discountprice"&i)&","&request("amount"&i)&",'"&request("shipdate"&i)&"','"&session("loginid")&"','"&date()&"','"&session("loginid")&"','"&date()&"')"
'response.write sql
'response.end
set rsc=conn.Execute(sql)
c=c+1
end if
totalamount=totalamount+request("amount"&i)
next
sql="update delivery set totalamount="&totalamount&" where deliveryid="&request("deliveryid")
set rsd=conn.execute(sql)
%>
<script language=javascript>
window.opener.location.reload();window.close()
</script>
<%
else%>
<form name=form1 method=post>
<input name=print type=hidden value="yes">
<table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="25"><strong><font class=title>编辑发货单</font></strong> </td>
</tr>
<tr >
<td height="16" colspan="3" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#333333">
<tr bgcolor="#FFFFFF">
<td height="20" align=center><font color="#000000">序号</font></td>
<td align=center><font color="#000000">型号</font></td>
<td align=center><font color="#000000">在库可用量</font></td>
<td align=center><font color="#000000">应发数量</font></td>
<td align=center><font color="#000000">实发数量</font></td>
<td align=center><font color="#000000">单价</font></td>
<td align=center><font color="#000000">金额</font></td>
</tr>
<%i=1
do while not rsdeliveryline.EOF
dim maxavailable
maxavailable=getmaxavailable(rsdeliveryline("productid"))+getreserveqty(rsdeliveryline("lineid"))
%>
<tr bgcolor="#FFFFFF">
<td height="18" align=center><font color="#000000"><%=i%></font></td>
<td align=center><font color="#000000"><%=rsdeliveryline("model")%><input type=hidden name=productid<%=i%> value="<%=rsdeliveryline("productid")%>"><input type=hidden name=model<%=i%> value="<%=rsdeliveryline("model")%>"><input type=hidden name=productcode<%=i%> value="<%=rsdeliveryline("productcode")%>"><input type=hidden name=discount<%=i%> value="<%=rsdeliveryline("discount")%>"></font></td>
<td align=center><font color="#000000"><font color=red><%=maxavailable%><input type=hidden name=maxavailable<%=i%> value=<%=maxavailable%>><input type=hidden name=orderlineid<%=i%> value=<%=rsdeliveryline("orderlineid")%>></font></td>
<td align=center><font color="#000000"><%=rsdeliveryline("orderqty")-rsdeliveryline("issuedqty")%><input type=hidden name=qty<%=i%> size=10 value=<%=rsdeliveryline("qty")%>></font></td>
<td align=center><font color="#000000"><input type=text name=actualqty<%=i%> size=10 value=<%=rsdeliveryline("qty")%> onBlur="calculateamount(<%=i%>);"><input type=hidden name=lineqty<%=i%> size=10 value=<%=rsdeliveryline("qty")%>></font></td>
<td align=center><font color="#000000"><%=rsdeliveryline("discountprice")%><input type=hidden name=discountprice<%=i%> value=<%=rsdeliveryline("discountprice")%>><input type=hidden name=price<%=i%> value=<%=rsdeliveryline("price")%>><input type=hidden name=shipdate<%=i%> value=<%=rsdeliveryline("shipdate")%>></font></td>
<td align=center><font color="#000000"><input type=text name=amount<%=i%> size=10 value=<%=rsdeliveryline("amount")%> readonly></font></td>
</tr>
<%
rsdeliveryline.MoveNext
i=i+1
loop
%>
</table>
<input type=hidden name=linecount value=<%=i%>>
<table width=100%>
<tr>
<td align=center><div align="left">开票：
<select name="invoice">
<option value="1">是</option>
<option value="0" <%if not rs("invoice") then response.Write "selected"%>>否</option>
</select>
</div></td>
</tr>
<tr>
<td align=center><input type=image name=images src="../images/button_save.gif" onclick="javascript:return create();"></td>
</tr>
</table>
</form>
<%end if
rsdeliveryline.Close
set rsdeliveryline=nothing
conndeliveryline.Close
set conndeliveryline=nothing
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -