📄 jinmodifysave.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Set ObjReference = Server.CreateObject("jxc1.check")
ObjReference.myfileb()
%>
<!--#include file="../../Connections/jxc.asp" -->
<%
dim ku,jidcode,shu,kushu
ku = request.Form("ku")
jidcode = request.Form("jidcode")
shu = request.Form("shu")
%>
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.Form("hidcode") <> "") Then
Recordset1__MMColParam = Request.Form("hidcode")
End If
%>
<%
Dim Recordset1__MMColParam1
Recordset1__MMColParam1 = "1"
If (Request.Form("ku") <> "") Then
Recordset1__MMColParam1 = Request.Form("ku")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_jxc_STRING
Recordset1.Source = "SELECT * FROM cun WHERE hidcode = '" + Replace(Recordset1__MMColParam, "'", "''") + "' AND ku = '" + Replace(Recordset1__MMColParam1, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open Recordset1.Source,Recordset1.ActiveConnection,1,3
Recordset1_numRows = 0
%>
<%
Dim Recordset2__MMColParam
Recordset2__MMColParam = "1"
If (Request.Form("jidcode") <> "") Then
Recordset2__MMColParam = Request.Form("jidcode")
End If
%>
<%
Dim Recordset2
Dim Recordset2_numRows
Set Recordset2 = Server.CreateObject("ADODB.Recordset")
Recordset2.ActiveConnection = MM_jxc_STRING
Recordset2.Source = "SELECT * FROM jin WHERE jidcode = '" + Replace(Recordset2__MMColParam, "'", "''") + "'"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open Recordset2.Source,Recordset2.ActiveConnection,1,3
if recordset2("zhuangtai") <> "有效" then
response.Redirect("jinerr1.asp")
end if
Recordset2_numRows = 0
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>www.71base.com</title>
</head>
<body>
<%
kushu = Recordset1("shu")
if shu - kushu > 0 then
response.Redirect("jinerr.asp")
end if
kushu = kushu - shu
dim disable
disable = "作废"
recordset1("shu")=kushu
recordset1.update
recordset2("zhuangtai") = disable
recordset2.update
%>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<%
Recordset2.Close()
Set Recordset2 = Nothing
response.Redirect("ok.asp")
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -