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