📄 xinyongoffsave.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../../Connections/jxc.asp" -->
<%
Set ObjReference = Server.CreateObject("jxc1.check")
ObjReference.myfilee()
%>
<%
dim fukuanfangshi
fukuanfangshi = request("fukuanfangshi")
%>
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = "1"
If (Request.Form("xidcode") <> "") Then
Recordset1__MMColParam = Request.Form("xidcode")
End If
%>
<%
Dim Recordset1__MMColParam1
Recordset1__MMColParam1 = "有效"
If (Request("MM_EmptyValue") <> "") Then
Recordset1__MMColParam1 = Request("MM_EmptyValue")
End If
%>
<%
Dim Recordset1__MMColParam2
Recordset1__MMColParam2 = "信用"
If (Request("MM_EmptyValue") <> "") Then
Recordset1__MMColParam2 = Request("MM_EmptyValue")
End If
%>
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_jxc_STRING
Recordset1.Source = "SELECT * FROM xiao WHERE xidcode = '" + Replace(Recordset1__MMColParam, "'", "''") + "' and zhuangtai ='" + Replace(Recordset1__MMColParam1, "'", "''") + "' and fukuanfangshi = '" + Replace(Recordset1__MMColParam2, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open Recordset1.Source,Recordset1.ActiveConnection,1,3
dim zongjia
zongjia = recordset1("zongjia")
Recordset1_numRows = 0
%>
<%
Dim Recordset2__MMColParam
Recordset2__MMColParam = "1"
If (Request.Form("gidcode") <> "") Then
Recordset2__MMColParam = Request.Form("gidcode")
End If
%>
<%
Dim Recordset2
Dim Recordset2_numRows
Set Recordset2 = Server.CreateObject("ADODB.Recordset")
Recordset2.ActiveConnection = MM_jxc_STRING
Recordset2.Source = "SELECT * FROM guest WHERE gidcode = '" + Replace(Recordset2__MMColParam, "'", "''") + "'"
Recordset2.CursorType = 0
Recordset2.CursorLocation = 2
Recordset2.LockType = 1
Recordset2.Open Recordset2.Source,Recordset2.ActiveConnection,1,3
Recordset2_numRows = 0
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>www.71base.com</title>
</head>
<body>
<%
recordset1("fukuanfangshi") = fukuanfangshi
recordset1("date") = now()
recordset1("man") = session("jxcman")
recordset1.update
dim xinyongover
xinyongover = recordset2("xinyongover")
xinyongover = xinyongover - zongjia
recordset2("xinyongover") = xinyongover
recordset2.update
%>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<%= (Recordset2.Fields.Item("gname").Value) %>
<%
Recordset2.Close()
Set Recordset2 = Nothing
response.Redirect("xinyong.asp")
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -