📄 singleaskgetpatientmsgbyname.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 sPatientName;
	sPatientName=Request.QueryString["name"].ToString();
	String sConditionStr;
	sConditionStr="where Name='"+sPatientName+"'";

	
	//
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="";
	sSql="select * from tb_Patient  "+sConditionStr;
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();
	
	int nRow=0;

	String sPatientConsumerMsgStr="";
	while(dr.Read())
	{
		sPatientConsumerMsgStr+=(dr["AutoId"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Name"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Sex"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Age"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["AutoDate"].ToString()+"é");

		nRow++;
	}
	dr.Close();
	OCon.Close();
	//
	idPatientConsumerMsgStr.Value=sPatientConsumerMsgStr;
	//
	idAskedItemCount.Value=nRow.ToString();
	//
	//

}
</script>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _init()
{
	if(idAskedItemCount.value=="0")
	{
		alert("没有该患者信息!");
		return;
	}

	var patientConsumerMsg=idPatientConsumerMsgStr.value;

	if(idAskedItemCount.value=="1")
	{
		//
		var patientConsumerMsgSplit=patientConsumerMsg.split('é');
		var subSplit=patientConsumerMsgSplit[0].split('è');
		location="SingleAskGetPatientMsg.aspx?id="+subSplit[0];
	}
	else
	{
		parent._callSamePatientConsumerMsgTable(patientConsumerMsg);
	}

}
//-->
</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="idPatientConsumerMsgStr" 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 + -