📄 inoutok.asp
字号:
<!--#include file="../conndb.asp"-->
<%
'0-采购入库;1-销售退货入库;2-销售出库;3-采购退货出库
Dim rs,strType,strName,strTitle,sql,id
strType = Request.QueryString("type")
If strType="0" Then
strName = "采购"
strTitle = "入库"
ElseIf strType="1" Then
strName = "销售"
strTitle = "入库"
ElseIf strType="2" Then
strName = "销售"
strTitle = "出库"
Else
strName = "采购"
strTitle = "出库"
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
%>
<html>
<head>
<title>保存出入库单信息</title>
</head>
<body>
<%
Dim StrAction
'得到动作参数,如果为add则表示添加操作,如果为edit则表示更改操作
StrAction = Request.QueryString("action")
'在数据库表StoreInOut中更新信息
sql="Select * From StoreInOut Where IOId='" & Request.QueryString("id") & "'"
rs.Open sql,Conn,1,3
rs("LotNo")= Request("lot") '批次号
rs("ProSum") = Request("psum") '出入库商品总金额
rs("Poster") = Request("poster")
rs("CreateDate") = Date()'创建日期
rs.Update
Set rs = Nothing
Response.Write strName & strTitle & "成功保存"
%>
</body>
<script language="javascript">
// 刷新父级窗口,延迟此关闭
opener.location.reload();
setTimeout("window.close()",600);
</script>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -