📄 savea.asp
字号:
<!--#include file="../includes/keepHouse.asp"-->
<%
call insureID()
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>WebOffice</title>
</head>
<body>
<%
if request("action")="Add" then
call saveAdd()
else
call trigErr()
end if
sub saveAdd()
dim CLIENT_ID
dim PRODUCT_ID
dim UNITPRICE
sql="SELECT UNIT_PRICE FROM Products " _
&"WHERE PRODUCT_ID= "&request("PRODUCT_ID")
call openDB()
rs.open sql,conn,1,1
CLIENT_ID = request("CLIENT_ID")
PRODUCT_ID = request("PRODUCT_ID")
UNIT_PRICE = rs("UNIT_PRICE")
PIECES = request("PIECES")
DUE_DATE_Year=request("DUE_DATE_Year")
DUE_DATE_Month=request("DUE_DATE_Month")
DUE_DATE_Day=request("DUE_DATE_Day")
DUE_DATE=DUE_DATE_Year&"-"&DUE_DATE_Month&"-"&DUE_DATE_Day
PERSONNEL_ID=session("PERSONNEL_ID")
sql="INSERT INTO Orders(CLIENT_ID, PRODUCT_ID, UNIT_PRICE, PIECES, MAKE_DATE, DUE_DATE, IMPLEMENTED, PERSONNEL_ID) " _
&"VALUES("&CLIENT_ID&","&PRODUCT_ID&",'"&UNIT_PRICE&"',"&PIECES&",GETDATE(),'"&DUE_DATE&"',0,"&PERSONNEL_ID&")"
conn.execute(sql)
call closeDB()
response.write "提交成功! <<<a href=""Browse.asp"">返回</a>"
end sub
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -