proc_update.asp

来自「一个软件工程的软件质量web跟踪管理系统」· ASP 代码 · 共 82 行

ASP
82
字号
<%@ Language=VBScript %>
<%Response.Expires=0
Response.Buffer = False
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<Script Language=Javascript>
<!--
	returnValue = "Cancel";
-->
</Script>
<%
On Error Resume Next

cTaxRatio = Trim(Request.QueryString("TaxRatio"))
cPosition = Trim(Request.QueryString("Position"))
cDateStay = Trim(Request.QueryString("DateStay"))
cMaxStockAmount = Trim(Request.QueryString("MaxStockAmount"))
cMinStockAmount = Trim(Request.QueryString("MinStockAmount"))
cSysReady = Trim(Request.QueryString("SysReady"))
cPlanProcreate = Trim(Request.QueryString("PlanProcreate"))

Set Conn = session("AdoConnectObj")

Conn.BeginTrans

	MySql = "Update zd_SysParameter Set Value = '"+cTaxRatio+"' Where ParameterID = 'TaxRatio'"
	Conn.Execute(MySql)
	MySql = "Update zd_SysParameter Set Value = '"+cPosition+"' Where ParameterID = 'Position'"
	Conn.Execute(MySql)
	MySql = "Update zd_SysParameter Set Value = '"+cDateStay+"' Where ParameterID = 'DateStay'"
	Conn.Execute(MySql)
	MySql = "Update zd_SysParameter Set Value = '"+cMaxStockAmount+"' Where ParameterID = 'MaxStockAmount'"
	Conn.Execute(MySql)
	MySql = "Update zd_SysParameter Set Value = '"+cMinStockAmount+"' Where ParameterID = 'MinStockAmount'"
	Conn.Execute(MySql)
	MySql = "Update zd_SysParameter Set Value = '"+cSysReady+"' Where ParameterID = 'SysReady'"
	Conn.Execute(MySql)
	MySql = "Update zd_SysParameter Set Value = '"+cPlanProcreate+"' Where ParameterID = 'PlanProcreate'"
	Conn.Execute(MySql)
	
If Err.description = "" Then
	Conn.CommitTrans
	If Trim(cSysReady) = "1" Then
		Application("SysReady") = True
	Else
		Application("SysReady") = False
	End If
%>
<Script Language=Javascript>
<!--
	returnValue = "Success";
-->
</Script>
<%
Else
	Conn.RollbackTrans
	cTemp = Replace(Err.description,chr(13),"\n")
%>
<Script Language=Javascript>
<!--
	alert("操作失败,原因为:"+"<%=cTemp%>"+" 请联系系统管理员");
-->
</Script>
<%

End If

%>

<Script Language=Javascript>
<!--
	window.close()
-->
</Script>

</BODY>
</HTML>

⌨️ 快捷键说明

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