busub.asp

来自「国内第一数字点卡销售程序。功能强大。 完整无错!数据文件经MD5加密!经严格测」· ASP 代码 · 共 66 行

ASP
66
字号
<!--#include file="conn.asp"-->
<%
if session("admin_rank")<>1 and session("admin_rank")<>3 then
response.write("<script>alert('您无权查看本页,SORRY!');window.location=('login.asp')</script>")
response.end
end if
%>
<body style="background-color: #F0FBF1">
<%
set rs=server.createobject("adodb.recordset")
set rs1=server.createobject("adodb.recordset")
%>
<link rel="stylesheet" type="text/css" href="css.css">
<%
if request("action")="save" then
   sub_number=srequest(trim(request("sub_number")),0)
   sql="select * from sub where sub_number='"&sub_number&"' and sub_payok=false and sub_check=false"
   rs.open sql,conn,3,3
   if rs.eof then
      response.write("<script>alert('没有此订单或此订单已处理了!');window.location=('busub.asp')</script>")
      response.end
   end if
   if request("sub_check")="是" then
           sql1="select top "&rs("hw_count")&" * from tingcardnum where hw_name='"&rs("hw_name")& "'and hw_ok=true order by id"
           rs1.open sql1,conn,3,3
           if rs1.recordcount<int(rs("hw_count")) then
              response.write("<script>alert('库存内该订购产品不足以发货,请核实,谢谢!');window.location=('busub.asp')</script>")
              response.end
           else
              rs("sub_check")=true
              rs("sub_payok")=true
              rs("sub_yuka")="0"
              rs.update
              do while not rs1.eof
                 rs1("hw_ok")=false
                 rs1("sub_number")=rs("sub_number")
                 rs1("sub_tel")=rs("sub_tel")
                 rs1("number_ip")="管理员补单"
                 rs1.update
                 rs1.movenext
              loop
                 response.write("<script>alert('补单成功!');window.location=('busub.asp')</script>")
                 response.end
            end if
 
    end if
    rs.close
end if%>


  <form method="POST" action="busub.asp?action=save">
        <div align="center">
        <table border="1" width="780" cellspacing="0" height="91" bordercolorlight="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0" bordercolor="#FFFFFF">
          <tr> 
            <td width="100%" style="padding-left: 10px">输入订单号:<input type="text" name="sub_number" size="20" class=input>&nbsp;&nbsp; </td>
          </tr>
          <tr> 
            <td width="100%" style="padding-left: 10px">设置是否补发:&nbsp; <select size="1" name="sub_check">
                <option value="是" selected >是</option>
                <option value="否">否</option>
              </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input type="submit" value="提交" name="B1" class=input>
            </td>
          </tr>
</table>
</form>
<p style="line-height: 150%"> </p>

⌨️ 快捷键说明

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