📄 yaopingrukugetdrugmsg.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 sValue;
	sValue=Request.QueryString["value"].ToString();
	String []sValueSplit;
	sValueSplit=sValue.Split('è');

	String sConditionStr="";
	int i=0;

	for(i=0;i<sValueSplit.Length;i++)
	{
		if(sValueSplit[i]!="")
			break;
	}
	switch(i)
	{
		case 0:sConditionStr=("AutoId="+sValueSplit[i]);break;
		case 1:sConditionStr=("PYName='"+sValueSplit[i]+"'");break;
		case 2:sConditionStr=("Name='"+sValueSplit[i]+"'");break;

	}
	idFocusInputIndex.Value=i.ToString();
	//
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="";
	sSql="select * from tb_DrugStore where "+sConditionStr;

	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();
	
	int nRow=0;
	String sDrugMsgStr="";
	while(dr.Read())
	{
		sDrugMsgStr+=(dr["AutoId"].ToString()+"è");
		sDrugMsgStr+=(dr["Name"].ToString()+"è");
		sDrugMsgStr+=(dr["PYName"].ToString()+"è");
		sDrugMsgStr+=(dr["Type"].ToString()+"è");
		sDrugMsgStr+=(dr["BatchCode"].ToString()+"è");
		sDrugMsgStr+=(dr["ToDate"].ToString()+"è");
		sDrugMsgStr+=(dr["Unit"].ToString()+"è");
		sDrugMsgStr+=(dr["Price"].ToString()+"è");
		sDrugMsgStr+=(dr["BatchPrice"].ToString()+"è");
		sDrugMsgStr+=(dr["ProductAddress"].ToString()+"è");

		sDrugMsgStr+=(dr["StoreCount"].ToString()+"è");
		sDrugMsgStr+=(dr["ABType"].ToString()+"é");

		nRow++;
	}
	dr.Close();
	OCon.Close();
	//
	idDrugMsgStr.Value=sDrugMsgStr;
	idAskedItemCount.Value=nRow.ToString();
	//
}
</script>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _init()
{
	var drugMsgStr=idDrugMsgStr.value;

	if(idAskedItemCount.value=="0")
	{
		alert("没有该药品!");
		_focus(idFocusInputIndex.value);
		return;
	}
	if(idAskedItemCount.value=="1")
	{
		var drugMsgStrSplit=drugMsgStr.split('é');
		parent._callShowDrugMsg(drugMsgStrSplit[0]);
	}
	else
	{
		parent._callSameDrugMsgTable(drugMsgStr);
	}

}
function _focus(theObjIndex)
{
	switch(theObjIndex)
	{
		case "0":parent.idFm.idDrugId.focus();break;
		case "1":parent.idFm.idDrugPyCode.focus();break;
		case "2":parent.idFm.idDrugName.focus();break;
	}

}
//-->
</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="_init()">
<INPUT TYPE="text" id="idStoreCount" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idFocusInputIndex" style="display:none;" runat="server"/>

<INPUT TYPE="text" id="idDrugMsgStr" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idAskedItemCount" style="display:none;" runat="server"/>

</body>
</html>
⌨️ 快捷键说明

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