doctorreg.aspx
来自「医院进行药品进货,划价,派单等功能的系统」· ASPX 代码 · 共 73 行
ASPX
73 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?