📄 yaopinghuajiacheckpatientid.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=Request.QueryString["patientid"].ToString();
//
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();
idPatientMsg.Value="";
if(dr.Read())
{
idPatientMsg.Value=(dr["Name"].ToString()+"è"+dr["Sex"].ToString()+"è"+dr["Age"].ToString()+"è"+dr["AutoDate"].ToString());
}
dr.Close();
OCon.Close();
///
}
</script>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initPatientCheck()
{
parent._onPatientMsgShow(idPatientMsg.value);
}
//-->
</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="_initPatientCheck()">
<INPUT TYPE="text" id="idPatientMsg" style="display:none" runat="server"/>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -