📄 newdelivery.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
set rsq=conn.Execute("select * from V_order where orderid='"&Request("orderid")&"' and confirmed='未审核'")
if not rsq.EOF then
response.write "<SCRIPT language=javascript>window.resizeTo(300,200);window.focus()</SCRIPT>"
response.write "<title>生成发货单提醒!</title>"
response.write "<LINK href="&"../global.css"&" rel=stylesheet type=text/css>"
response.write "<br>"
response.write "<p align=center><font class=title><b>"&"<img src=../images/jg.gif> 未审核不能生成发货单，请先审核！"&"</b></font><br>"
response.write "<br>"
response.write "<p align=center><input type=button value="&"关闭窗口"&" onclick="&"javascript:window.close();"&" id=button1 name=button1></p>"
Response.End
end if
rs.Open "select * from v_order where orderid="&request("orderid"),conn,1,1
if rs.EOF then
Response.Write "记录不存在"
Response.end
end if
dim connorderline
dim rsorderline
set connorderline=server.CreateObject("adodb.connection")
set rsorderline=server.CreateObject("adodb.recordset")
connorderline.Open connstring
rsorderline.Open "select * from v_orderline where orderid="&request("orderid"),connorderline,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 qty;
var maxavailable;
var lineqty;
for(i=1;i<form1.linecount.value;i++){
actualqty='actualqty'+i;
qty='qty'+i;
maxavailable='maxavailable'+i;
lineqty='lineqty'+i;
model='model'+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(qty).value)){
alert('发货数量不能大于应发数量');
form1.item(actualqty).focus();
return false;
}
//if(parseInt(form1.item(actualqty).value)>parseInt(form1.item(maxavailable).value)){
// alert('提示：'+form1.item(model).value+'在库可用量不足');
// 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>
<form name=form1 method=post onsubmit="return create();">
<input name=print type=hidden value="">
<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>
<td align=center><font color="#000000">金额</font></td>
</tr>
<%i=1
do while not rsorderline.EOF
dim maxavailable
maxavailable=getmaxavailable(rsorderline("productid"))+getreserveqty(rsorderline("lineid"))
%>
<tr bgcolor="#FFFFFF">
<td height="18" align=center><font color="#000000"><%=i%></font></td>
<td align=center><font color="#000000"><%=rsorderline("model")%><input type=hidden name=productid<%=i%> value="<%=rsorderline("productid")%>"><input type=hidden name=model<%=i%> value="<%=rsorderline("model")%>"><input type=hidden name=productcode<%=i%> value="<%=rsorderline("productcode")%>"><input type=hidden name=orderlineid<%=i%> value="<%=rsorderline("lineid")%>"><input type=hidden name=discount<%=i%> value="<%=rsorderline("discount")%>"></font></td>
<td align=center><font color="#000000"><font color=red><%=maxavailable%></font><input type=hidden name=maxavailable<%=i%> value=<%=maxavailable%>></font></td>
<td align=center><font color="#000000"><%=rsorderline("qty")-rsorderline("issuedqty")%><input type=hidden name=qty<%=i%> size=10 value=<%=rsorderline("qty")-rsorderline("issuedqty")%>></font></td>
<td align=center><font color="#000000"><%=rsorderline("issuedqty")%></font></td>
<td align=center><font color="#000000"><input type=text name=actualqty<%=i%> size=10 value=<%=rsorderline("qty")-rsorderline("issuedqty")%> onBlur="calculateamount(<%=i%>);"><input type=hidden name=lineqty<%=i%> size=10 value=<%=rsorderline("qty")%>></font></td>
<td align=center><font color="#000000"><%=rsorderline("discountprice")%><input type=hidden name=discountprice<%=i%> value=<%=rsorderline("discountprice")%>><input type=hidden name=price<%=i%> value=<%=rsorderline("price")%>><input type=hidden name=shipdate<%=i%> value=<%=rsorderline("shipdate")%>></font></td>
<td align=center><font color="#000000"><input type=text name=amount<%=i%> size=10 value=<%=(csng(rsorderline("qty"))-csng(rsorderline("issuedqty")))*csng(rsorderline("discountprice"))%> readonly></font></td>
</tr>
<%
rsorderline.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">否</option>
</select>
</div></td>
</tr>
<tr>
<td align=center><input type=image name=images src="../images/button_next.gif" onclick="javascript:form1.print.value='yes';"></td>
</tr>
</table>
</form>
<%
if Request.Form("print")="yes" 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 rsd.EOF then
x=x+rsd("deliveryid")+1
else
x=x+1
end if
deliveryNo=rspara("prefix")&right(x,len(x)-1)
sysid=getsysaccount("sysaccountid")
sql="insert into delivery(sysaccountid,deliveryNo,invoice,OrderId,Status,Owner,Creator,CreateDate,LastModUser,LastModDate,TotalAmount)values("&sysid&",'"&deliveryNo&"',"&request("invoice")&","&request("orderid")&",'初始','"&rs("userid")&"','"&session("loginid")&"','"&date()&"','"&session("loginid")&"','"&date()&"',0)"
set rsd=conn.execute(sql)
sql="select * from delivery order by deliveryid desc"
set rsd=conn.execute(sql)
deliveryid=rsd("deliveryid")
end if
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("&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()&"')"
set rsc=conn.Execute(sql)
c=c+1
end if
totalamount=totalamount+request("amount"&i)
next
sql="update delivery set totalamount="&totalamount&" where deliveryid="&deliveryid
set rsd=conn.execute(sql)
%>
<script language=javascript>
window.opener.location='delivery.asp';window.close()
</script>
<%
end if
rsorderline.Close
set rsorderline=nothing
connorderline.Close
set connorderline=nothing
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -