📄 doctorreg.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 sName;
	String sSex;
	String sIdCardCode;
	String sOfficePosition;
	String sOfficeDepartment;
	String sLoginName;
	String sLoginPwd;

//

	sName=Request.Form["idName"].ToString();
	sSex=Request.Form["idSex"].ToString();
	sIdCardCode=Request.Form["idIdCardCode"].ToString();
	sOfficePosition=Request.Form["idOfficePosition"].ToString();
	sOfficeDepartment=Request.Form["idOfficeDepartment"].ToString();
	sLoginName=Request.Form["idLoginName"].ToString();
	sLoginPwd=Request.Form["idLoginPwd"].ToString();

	//

	String sValueStr="";
	sValueStr="'"+sName+"','"+sSex+"','"+sIdCardCode+"','"+sOfficePosition+"','"+sOfficeDepartment+"','"+sLoginName+"','"+sLoginPwd+"',default,default";
//
	//
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="";
	sSql="Insert into tb_Doctor  values ("+sValueStr+")";
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	OCmd.ExecuteNonQuery();

	sSql="SELECT  @@IDENTITY  AS  'Identity'";
	SqlDataReader dr;
	OCmd=new SqlCommand(sSql,OCon);
	dr=OCmd.ExecuteReader();
	if(dr.Read())
	{
		Response.Write(dr["Identity"].ToString());
		dr.Close();
	}

	OCon.Close();

	//
}
</script>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initDoctorReg()
{
	alert("注册成功,请告示知相关管理给你开通权限后即可生效!");
	parent.idfrmClient.idFm.reset();
	parent.idIfmHid.location="ept.htm";

}
//-->
</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="_initDoctorReg();">

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -