📄 jiaofeimodifydb.aspx
字号:
<%@ Page Language="C#" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient"%>
<script Language="c#" runat="server">
void Page_Load(Object Source, EventArgs E)
{
String sSheetId;
sSheetId=Request.QueryString["sheetid"].ToString();
String sPrinted;
sPrinted=Request.QueryString["printed"].ToString();
if(sPrinted=="y")
return;
String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
String sSql="";
sSql="Update tb_ExpenditureReg set PayFlag='y' where AutoId="+sSheetId;
SqlConnection OCon=new SqlConnection(sCon);
SqlCommand OCmd=new SqlCommand(sSql,OCon);
OCmd.Connection.Open();
OCmd.ExecuteNonQuery();
sSql="Update TBA Set TBA.StoreCount=TBA.StoreCount-TBB.DrugUseContent from tb_DrugStore TBA,tb_DrugUse TBB Where TBA.AutoId = TBB.DrugId AND TBB.ToExpenditureRegId = '"+sSheetId+"'";
OCmd=new SqlCommand(sSql,OCon);
OCmd.ExecuteNonQuery();
OCon.Close();
}
</script>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initModifyDB()
{
parent._onMoneyItemTableWndHide();
parent._changeItemFace();
alert("--- 缴费成功！---");
}
//-->
</SCRIPT>
</HEAD>
<body onContextMenu='return false' leftmargin=0 topmargin=0 ondragstart='return false' onselectstart ='return false' onselect='document.selection.empty()' oncopy='document.selection.empty()' onbeforecopy='return false' onLoad="_initModifyDB()">
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -