📄 singleaskgetdoctorlist.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 sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
String sSql="";
sSql="select * from tb_Doctor where Authorized='y'";
SqlConnection OCon=new SqlConnection(sCon);
SqlCommand OCmd=new SqlCommand(sSql,OCon);
OCmd.Connection.Open();
SqlDataReader dr;
dr=OCmd.ExecuteReader();
int nRow=0;
String sStr="";
bool b=true;
while(dr.Read())
{
if(b)
{
sStr+=(dr["AutoId"].ToString());
b=false;
}
else
{
sStr+=("è"+dr["AutoId"].ToString());
}
sStr+=("è"+dr["Name"].ToString());
}
dr.Close();
idStr.Value=sStr;
}
</script>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initSAGDL()
{
var sVal=idStr.value;
var sValSplit=sVal.split('è');
doctorId=sValSplit[0];
//
parent.idDoctor.add(new Option("--选择门诊医生--","--选择门诊医生--"));
for(var i=0;i<sValSplit.length;i+=2)
{
parent.idDoctor.add(new Option(sValSplit[i+1],sValSplit[i]));
}
}
//-->
</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="_initSAGDL()">
<INPUT TYPE="text" id="idStr" runat="server"/>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -