📄 yaopinghuajia2db.aspx

📁 医院进行药品进货,划价,派单等功能的系统

💻 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 sStr=Request.QueryString["value"];  // 药品val = AutoId+"è"+Name+"è"+Unit+"è"+Type+"è"+Price+"è"+数量+"é"  ...
	String sTableId=Request.QueryString["tableid"];
	String sExpenditureValueStr=Request.QueryString["expenditurevaluestr"];
	

	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="";
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);	
	OCmd.Connection.Open();
	
	sStr=sStr.Trim();

	if(sStr!="")
	{
		String []sStrSplit;
		sStrSplit=sStr.Split('é');
		
		for(int i=0;i<sStrSplit.Length-1;i++)
		{
			String sSubStr=sStrSplit[i];
			String []sSubStrSplit=sSubStr.Split('è');

			sSql="insert into tb_DrugUse values('"+sSubStrSplit[0]+"','"+sSubStrSplit[6]+"','"+sTableId+"',default)";
			OCmd=new SqlCommand(sSql,OCon);	
			
			OCmd.ExecuteNonQuery();
		}
	}
	//
	sSql="insert into tb_ExpenditureReg values("+sExpenditureValueStr+")";
	OCmd=new SqlCommand(sSql,OCon);	
	
	OCmd.ExecuteNonQuery();


	OCon.Close();

	//
}
</script>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initDrugItem2Db()
{
	parent.idDrugTableMsgStr.value="";
	parent.idDrugTable.innerHTML="";

	parent._onPatientMsgHide();

	alert("划价登记成功!");

	parent.idHuajiaTableCode.innerText=Number(parent.idHuajiaTableCode.innerText)+1;

	parent._clearTableMsg();

}
//-->
</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="_initDrugItem2Db()">
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -