📄 singleaskgetpatientmsg.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 sPatientId;
	sPatientId=Request.QueryString["id"].ToString();
	String sConditionStr;
	sConditionStr="where PatientId='"+sPatientId+"' and PayFlag='y'";

	
	//
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="";
	sSql="select * from tb_Patient  where AutoId="+sPatientId;
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();
	if(dr.Read())
	{
		idPatientMsg.Value=("【 姓名："+dr["Name"].ToString()+"性别："+dr["Sex"].ToString()+"年龄："+dr["Age"].ToString().Trim()+" 】                                  操作说明：点击查看祥情");
	}

	dr.Close();

	//

	sSql="select * from tb_ExpenditureReg  "+sConditionStr;
	OCmd=new SqlCommand(sSql,OCon);
	dr=OCmd.ExecuteReader();

	int nRow=0;

	String sPatientConsumerMsgStr="";
	while(dr.Read())
	{
		sPatientConsumerMsgStr+=(dr["AutoId"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["WMedicine"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["CWMedicine"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["CMedicine"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Material"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Diagnosis"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Examine"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Inspection"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["BWaveExamine"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Cardiogram"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["XRay"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Treatment"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Nurse"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Bed"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Surgery"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Register"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Others"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Deposit"].ToString()+"è");
		sPatientConsumerMsgStr+=(dr["Total"].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")
	{
		parent.idPatientMsgText.innerText="";
		parent.idTable.innerHTML="";
		alert("没有该患者费用信息!");
		return;
	}

	parent.idPatientMsgText.innerText=idPatientMsg.value;

	var patientConsumerMsg=idPatientConsumerMsgStr.value;
	parent._showPatientConsumerTable(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"/>
<INPUT TYPE="text" id="idPatientMsg" style="display:none;" runat="server"/>

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

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