📄 editporeceive.asp
字号:
<!--#include file="../config.ini" -->
<!--#include file="../commfunction.inc" -->
<%
Dim objcheck
Set objcheck=Server.CreateObject("SmartSales.CheckFunction")
objcheck.CheckUserFunction "po","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_poreceive where poreceiveid="&request("id"),conn,1,1
if rs.EOF then
Response.Write "记录不存在"
Response.end
end if
dim connpoline
dim rspoline
set connpoline=server.CreateObject("adodb.connection")
set rspoline=server.CreateObject("adodb.recordset")
connpoline.Open connstring
rspoline.Open "select * from v_poreceiveline where poreceiveid="&request("id"),connpoline,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("pono")%></title>
<script language=javascript>
function create(){
var actualqty;
var lineqty;
for(i=1;i<form1.linecount.value;i++){
actualqty='actualqty'+i;
maxavailable='maxavailable'+i
qty='qty'+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(qty).value)){
alert('收货数量不能大于采购数量');
form1.item(actualqty).focus();
return false;
}
}
form1.submit();
}
function calculateamount(i){
var actualqty="actualqty"+i;
var price="price"+i;
var amount="amount"+i;
form1.item(amount).value=form1.item(price).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='poreceive'")
'set rsd=conn.Execute("select * from poreceive order by poreceiveid desc")
'x=1
'for l=1 to rspara("len")
' x=x*10
'next
'if not rsd.EOF then
' x=x+rsd("poreceiveid")+1
'else
' x=x+1
'end if
'receiveNo=rspara("prefix")&right(x,len(x)-1)
'sql="insert into poreceive(poreceiveNo,invoice,poId,Status,Owner,Creator,CreateDate,LastModUser,LastModDate,TotalAmount)values('"&receiveNo&"',"&request("invoice")&","&request("poid")&",'初始','"&rs("owner")&"','"&session("loginid")&"','"&date()&"','"&session("loginid")&"','"&date()&"',0)"
'response.write sql
'set rsd=conn.execute(sql)
'sql="select * from poreceive order by poreceiveid desc"
'set rsd=conn.execute(sql)
'receiveid=rsd("poreceiveid")
sql="delete from poreceiveline where poreceiveid="&request("id")
set rsd=conn.execute(sql)
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 poreceiveline(poreceiveid,poLineid,Productid,model,productcode,Qty,Price,Amount,slipno,specialpriceno,Creator,CreateDate,LastModUser,LastModDate) values("&request("id")&","&request("polineid"&i)&","&request("productid"&i)&",'"&request("model"&i)&"','"&request("productcode"&i)&"',"&request("actualqty"&i)&","&request("price"&i)&","&request("amount"&i)&",'"&request("slipno"&i)&"','"&request("specialpriceno"&i)&"','"&session("loginid")&"','"&date()&"','"&session("loginid")&"','"&date()&"')"
'response.write sql
set rsc=conn.Execute(sql)
c=c+1
end if
totalamount=totalamount+request("amount"&i)
next
sql="update poreceive set totalamount="&totalamount&" where poreceiveid="&request("id")
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" bpo="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%" bpo="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 rspoline.EOF
dim maxavailable
maxavailable=getmaxavailable(rspoline("productid"))+getreserveqty(rspoline("lineid"))
%>
<tr bgcolor="#FFFFFF">
<td height="18" align=center><font color="#000000"><%=i%></font></td>
<td align=center><font color="#000000"><%=rspoline("model")%><input type=hidden name=productid<%=i%> value="<%=rspoline("productid")%>"><input type=hidden name=model<%=i%> value="<%=rspoline("model")%>"><input type=hidden name=productcode<%=i%> value="<%=rspoline("productcode")%>"><input type=hidden name=polineid<%=i%> value="<%=rspoline("polineid")%>"></font></td>
<td align=center><font color="#000000"><%=rspoline("poqty")%><input type=hidden name=qty<%=i%> size=10 value=<%=rspoline("poqty")%>></font></td>
<td align=center><font color="#000000"><%=rspoline("issuedqty")%><input type=hidden name=specialpriceno<%=i%> size=10 value=<%=rspoline("specialpriceno")%>></font></td>
<td align=center><font color="#000000"><input type=text name=actualqty<%=i%> size=10 onchange="calculateamount(<%=i%>);" value=<%=rspoline("qty")%>><input type=hidden name=lineqty<%=i%> size=10 value=<%=rspoline("qty")%>></font></td>
<td align=center><font color="#000000"><input type=text name=price<%=i%> size=10 value=<%=rspoline("price")%> readonly></font></td>
<td align=center><font color="#000000"><input type=text name=amount<%=i%> size=10 value=<%=rspoline("amount")%> readonly></font></td>
</tr>
<%
rspoline.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:return create();"></td>
</tr>
</table>
</form>
<%end if
rspoline.Close
set rspoline=nothing
connpoline.Close
set connpoline=nothing
rs.Close
set rs=nothing
conn.Close
set conn=nothing
%>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -