complainsave.asp

来自「A Design and Implementation of The Onli」· ASP 代码 · 共 33 行

ASP
33
字号
<!--#include file="../conndb.asp"-->
<!--#include file="isUser.asp"-->
<html>
<head>
<title>客户投诉保存</title>
</head>
<body>
<%
 '取得投诉订单号、内容和提交人用户名
 ordernumber = Trim(Request("ordernumber")) 
 content = Trim(Request("content"))
 userid = Session("user_id")
'判断是否存在此订单
 sql = "Select * From Basket Where OrderNumber='" & ordernumber & "' And UserId='" & userid & "'"
 Set Rs = Conn.Execute(sql)
 If Not Rs.EOF Then
   '在数据库表Complain中插入新投诉信息
   sql = "Insert Into Complain(UserId,PostTime,Content,OrderNumber) Values('"&userid&"','"&now()&"','"&content&"','"&ordernumber&"')" 
   '执行数据库操作
   Conn.Execute(sql) 
   Response.Write "<h3>投诉保存成功</h3>"
 Else
   Response.Write "<h3>不存在此订单信息!</h3>"
 End If
%>
</body>
<script language="javascript">
  // 刷新父级窗口,延迟此关闭
  opener.location.reload();
  setTimeout("window.close()",800);
</script>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?