医院管理系统源代码

医院管理系统源代码医院管理系统源代码医院管理系统源代码资料仅供参考文件编号：2022年4月医院管理系统源代码版本号：A修改号：1页次：1.0审核：批准:发布日期：源代码登陆界面源代码：<%@PageLanguage="C#"MasterPageFile="~/MasterPage.master"AutoEventWireup="true"CodeFile="login.aspx.cs"Inherits="logn"Title="UntitledPage"%><asp:ContentID="Content1"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server"><asp:ImageID="Image1"runat="server"Height="360px"ImageUrl="~/7.jpg"Width="298px"/></asp:Content><asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder2"Runat="Server"><asp:LinkButtonID="LinkButton2"runat="server"onclick="LinkButton2_Click">用户请登录</asp:LinkButton><br/><asp:LinkButtonID="LinkButton1"runat="server"onclick="LinkButton1_Click">注册用户</asp:LinkButton><asp:PanelID="Panel1"runat="server"Width="254px"><strong>登录</strong><br/>用户名:<asp:TextBoxID="TextBox5"runat="server"></asp:TextBox><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="TextBox5"Display="Dynamic"ErrorMessage="用户名不能为空"ForeColor="Red"></asp:RequiredFieldValidator><br/>密码:<asp:TextBoxID="TextBox6"runat="server"TextMOde="Password"></asp:TextBox><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator2"runat="server"ErrorMessage="密码不能为空"ForeColor="Red"ConTrolToValidate="TextBox6"Display="Dynamic"></asp:RequiredFieldValidator><br/><asp:ButtonID="Button3"runat="server"Text="登录"onclick="Button1_Click"PostBackUrl="~/main.aspx"/><asp:LabelID="Label1"runat="server"Text=""></asp:Label></asp:Panel><asp:PanelID="Panel2"runat="server"><strong>新用户请注册</strong>                 用户名:<asp:TextBoxID="TextBox7"runat="server"></asp:TextBox><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator3"runat="server"ControlToValidate="TextBox7"Display="Dynamic"ErrorMessage="用户名不能为空"ForeColor="Red"></asp:RequiredFieldValidator><br/>密码:<asp:TextBoxID="TextBox8"runat="server"TextMOde="Password"></asp:TextBox><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator4"runat="server"ErrorMessage="密码不能为空"ForeColor="Red"ConTrolToValidate="TextBox8"Display="Dynamic"></asp:RequiredFieldValidator><br/><asp:ButtonID="Button2"runat="server"Text="注册"onclick="Button2_Click"/><asp:LabelID="Label2"runat="server"Text=""></asp:Label></asp:Panel></asp:Content>窗体发生代码：usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;publicpartialclasslogn:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){Panel1.Visible=false;Panel2.Visible=false;}}protectedvoidLinkButton2_Click(objectsender,EventArgse){Panel1.Visible=true;Panel2.Visible=false;}protectedvoidLinkButton1_Click(objectsender,EventArgse){Panel1.Visible=false;Panel2.Visible=true;}protectedvoidButton1_Click(objectsender,EventArgse){if(TextBox5.Text==""&&TextBox6.Text==""){Label1.Text="欢迎你，登录成功";}else{Label1.Text="你输入的用户名错误或密码错误，请重新输入";}}protectedvoidButton2_Click(objectsender,EventArgse){if(TextBox7.Text==""&&TextBox8.Text==""){Label2.Text="欢迎你，注册成功";}else{Label2.Text="请输入用户名和密码";}}}主界面源代码：<%@PageLanguage="C#"MasterPageFile="~/MasterPage2.master"AutoEventWireup="true"CodeFile="main.aspx.cs"Inherits="Default2"Title="UntitledPage"%><asp:ContentID="Content1"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server"> <asp:MenuID="Menu1"runat="server"BackColor="#FFFBD6"DynamicHorizontalOffset="2"Font-Names="Verdana"Font-Size="Larger"ForeColor="#990000"StaticSubMenuIndent="10px"Height="132px"Width="161px"Font-Underline="True"><StaticSelectedStyleBackColor="#FFCC66"/><StaticMenuItemStyleHorizontalPadding="5px"VerticalPadding="2px"/><DynamicHoverStyleBackColor="#990000"ForeColor="White"/><DynamicMenuStyleBackColor="#FFFBD6"/><DynamicSelectedStyleBackColor="#FFCC66"/><DynamicMenuItemStyleHorizontalPadding="5px"VerticalPadding="2px"/><StaticHoverStyleBackColor="#990000"ForeColor="White"/><Items><asp:MenuItemText="首页"Value="首页"></asp:MenuItem><asp:MenuItemText="系统管理"Value="系统管理"><asp:MenuItemNavigateUrl="~/ChangePassword.aspx"Text="用户修改密码"Value="用户修改密码"></asp:MenuItem><asp:MenuItemNavigateUrl="~/UserManage.aspx"Text="用户权限设置"Value="用户权限设置"></asp:MenuItem></asp:MenuItem><asp:MenuItemText="挂号信息管理"Value="挂号信息管理"><asp:MenuItemNavigateUrl="~/RegisteredQuery.aspx"Text="挂号信息查询"Value="挂号信息登记"></asp:MenuItem><asp:MenuItemNavigateUrl="~/RegisteredAdd.aspx"Text="登记挂号信息"Value="登记挂号信息"></asp:MenuItem></asp:MenuItem><asp:MenuItemText="药品信息管理"Value="药品信息管理"><asp:MenuItemNavigateUrl="~/MedicineManage.aspx"Text="药品查询信息"Value="药品查询信息"></asp:MenuItem><asp:MenuItemNavigateUrl="~/MedicineAdd.aspx"Text="添加药品信息"Value="添加药品信息"></asp:MenuItem></asp:MenuItem><asp:MenuItemText="住院信息管理"Value="住院信息管理"><asp:MenuItemNavigateUrl="~/PatientQuery.aspx"Text="查询住院信息"Value="查询住院信息"></asp:MenuItem><asp:MenuItemNavigateUrl="~/PatientAdd.aspx"Text="住院信息登记"Value="住院信息登记"></asp:MenuItem></asp:MenuItem><asp:MenuItemNavigateUrl="~/Login.aspx"Text="退出"Value="退出"></asp:MenuItem></Items></asp:Menu><br/>院内通知<br/><spanstyle="display:inline!important;float:none;word-spacing:0px;font:14px/25px宋体,Arial,Helvetica,sans-serif;text-transform:none;color:rgb(0,0,0);text-indent:28px;white-space:normal;letter-spacing:normal;background-color:rgb(247,252,255);text-align:left;orphans:auto;widows:auto;webkit-text-stroke-width:0px">为进一步完善危重孕产妇的救治工作，保护母婴健康，维护社会与家庭的和谐，我局特制定了《市危重孕产妇会诊、转诊工作原则与处置流程》，现下发给你们，并就进一步做好有关工作提出如下要求：加强组织管理，进一步聚焦“一高一低”各级卫生行政部门和各有关医疗卫生单位要充分认识聚焦“一高一低”工作…</span></asp:Content><asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder2"Runat="Server"><br/><br/><br/><br/><asp:LabelID="Label1"runat="server"Font-Size="XX-Large"ForeColor="#804000"Text="欢迎进入ＸＸＸ医院"></asp:Label></asp:Content>出院信息登记页面源代码<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="InhospitalInfoUpdate.aspx.cs"Inherits="InhospitalInfoUpdate"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><title></title><styletype="text/css">.STYLE1{color:#FF0000}body,td,th{ font-size:9pt;}body{ margin-left:0px; margin-right:0px; margin-bottom:0px; margin-top:0px;}.style7{height:24px;font-size:large;font-weight:bold;text-align:center;color:#FFFFFF;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server"><br/><asp:ImageID="Image1"runat="server"Height="111px"ImageUrl="~/10.jpg"Width="810px"/><br/><tablewidth="600"border="0"cellpadding="0"cellspacing="0"align="center"><trbgcolor="#33b7f9"> <tdclass="style7">出院信息登记</td></tr><tr><tdstyle="background-color:lime"> <br/>姓名： <asp:LabelID="Name"runat="server"Text="Label"></asp:Label><br/><br/>性别： <asp:LabelID="Sex"runat="server"Text="Label"></asp:Label><br/><br/>年龄：<asp:LabelID="Age"runat="server"Text="Label"></asp:Label><br/><br/>病房：<asp:LabelID="RoomNo"runat="server"Text="Label"></asp:Label><br/><br/>入院日期：<asp:LabelID="ArrivelTime"runat="server"Text="Label"></asp:Label><br/><br/>住院费：<asp:TextBoxID="Money"runat="server"Width="105px"></asp:TextBox>元<br/><br/>      <asp:ButtonID="Button1"runat="server"ForeColor="Red"Text="登记"/><asp:ButtonID="Button2"runat="server"ForeColor="Red"PostBackUrl="~/main.aspx"Text="返回"/></tr></table>  </form></body></html>修改密码页面源代码<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="ChangePassword.aspx.cs"Inherits="ChangePassword"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><title></title><styletype="text/css">.STYLE1{color:#FF0000}body,td,th{ font-size:9pt;}body{ margin-left:0px; margin-right:0px; margin-bottom:0px; margin-top:0px;}.style1{font-weight:bold;font-size:large;text-align:center;color:#FFFFFF;}.style2{text-align:center;}</style></head><bodybackground="11.jpg"><formid="Form1"name="form1"method="post"runat=server><asp:ImageMapID="ImageMap1"runat="server"Height="135px"ImageUrl="~/10.jpg"Width="812px"></asp:ImageMap><br/><tablewidth="55%"border="1"cellpadding="0"cellspacing="2"align="center"style="height:31px"><trbgcolor="#33b7f9"><tdclass="style1"style="width:387px">修改密码</td></tr></table><tablewidth="55%"border="1"cellspacing="0"cellpadding="0"align="center"style="background-color:#f6fdfd"><tr><td> <tablewidth="100%"border="1"cellspacing="1"cellpadding="2"align="center"> <tr><tdclass="style2"style="height:44px">输入修改的密码</td> <tdclass="style2"style="height:44px"><asp:TextBoxID="NewPassword"runat="server"TextMode="Password"Width="144px"></asp:TextBox><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="NewPassword"ErrorMessage="密码输入不能为空！"></asp:RequiredFieldValidator>    </td></tr> <tr> <tdclass="style2">确认修改的密码:</td> <tdclass="style2"><asp:TextBoxID="NewPasswordAgain"runat="server"TextMode="Password"Width="145px"></asp:TextBox><asp:CompareValidatorID="CompareValidator1"runat="server"ControlToCompare="NewPassword"ControlToValidate="NewPasswordAgain"ErrorMessage="两次密码输入不一致！"></asp:CompareValidator></td> </tr><tr><tdheight="30"colspan="4"class="style2"><asp:ButtonID="Button1"runat="server"Text="提交"/>       <asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="main.aspx">返回首页</asp:HyperLink><br/><asp:LiteralID="ErrMessage"runat="server"></asp:Literal></td></tr> </table> </td></tr> </table></form></body></html>添加药品页面源代码<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="MedicineAdd.aspx.cs"Inherits="MedicineAdd"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><title></title><styletype="text/css">.STYLE1{color:#FF0000}body,td,th{ font-size:9pt;}body{ margin-left:0px; margin-right:0px; margin-bottom:0px; margin-top:0px;}.style7{height:20px;font-size:large;font-weight:bold;color:#FFFFFF;text-align:center;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server"><br/><asp:ImageID="Image1"runat="server"Height="106px"ImageUrl="~/10.jpg"Width="811px"/><br/><tablewidth=600border=0cellpadding=0cellspacing=0align="center"><trbgcolor="#33b7f9"> <tdclass="style7">添加药品信息</td></tr><tr><tdstyle="height:42px;background-color:gray"><br/>药品名称：<asp:TextBoxID="MedicineName"runat="server"Width="81px"></asp:TextBox><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="MedicineName"ErrorMessage="药品名称必填！"></asp:RequiredFieldValidator><br/><br/>药品数量：<asp:TextBoxID="Count"runat="server"Width="81px"></asp:TextBox><br/><br/>药品单价：<asp:TextBoxID="Price"runat="server"Width="81px"></asp:TextBox>元<br/><br/>药品单位：<asp:TextBoxID="Unit"runat="server"Width="81px"></asp:TextBox><br/><br/>批文编号：<asp:TextBoxID="ApprovalNumber"runat="server"Width="81px"></asp:TextBox><br/><br/>药品功效：<asp:TextBoxID="Efficacy"runat="server"Height="54px"TextMode="MultiLine"Width="185px"></asp:TextBox><br/><br/>药品成份：<asp:TextBoxID="Ingredient"runat="server"Height="54px"TextMode="MultiLine"Width="185px"></asp:TextBox><br/><br/>服用方法：<asp:TextBoxID="Usage"runat="server"Height="54px"TextMode="MultiLine"Width="185px"></asp:TextBox><br/><br/>     <asp:ButtonID="Button1"runat="server"Text="添加"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.aspx">返回首页</asp:HyperLink></td></tr></table>  </form></body></html>窗体发生代码usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassMedicineAdd:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){stringstr="DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True";stringtime=Convert.ToString(DateTime.Now.ToLongTimeString());SqlConnectionmyConnection=newSqlConnection(str);myConnection.Open();stringsqlstr="insertintomedicinevalues('"+this.MedicineName.Text+"','"+this.Count.Text+"','"+this.Price.Text+"','"+this.Unit.Text+"','"+this.ApprovalNumber.Text+"','"+this.Efficacy.Text+"','"+this.Ingredient.Text+"','"+this.Usage.Text+"''')";SqlCommandcom=newSqlCommand(sqlstr,myConnection);com.ExecuteNonQuery();Response.Write("<script>alert('恭喜您，添加药品信息已成功！')</script>");}}修改药品信息页面源代码<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="MedicineDetails.aspx.cs"Inherits="MedicineDetails"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><title></title><styletype="text/css">.STYLE1{color:#FF0000}body,td,th{ font-size:9pt;}body{ margin-left:0px; margin-right:0px; margin-bottom:0px; margin-top:0px;}.style7{height:20px;font-size:large;font-weight:bold;text-align:center;color:#FFFFFF;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server"><br/><asp:ImageID="Image1"runat="server"Height="93px"ImageUrl="~/10.jpg"Width="810px"/><br/><tablewidth=600border=0cellpadding=0cellspacing=0align="center"><trbgcolor="#33b7f9"> <tdclass="style7">修改药品信息</td></tr><trbgcolor="#f6fdfd"><tdstyle="height:42px;background-color:gray;"><br/>药品名称：<asp:TextBoxID="MedicineName"runat="server"ReadOnly="True"Width="81px"></asp:TextBox><br/><br/>药品数量：<asp:TextBoxID="Count"runat="server"Width="81px"></asp:TextBox><br/><br/>药品单价：<asp:TextBoxID="Price"runat="server"Width="81px"></asp:TextBox>元<br/><br/>药品单位：<asp:TextBoxID="Unit"runat="server"Width="81px"ReadOnly="true"></asp:TextBox><br/><br/>批文编号：<asp:TextBoxID="ApprovalNumber"runat="server"ReadOnly="True"Width="81px"></asp:TextBox><br/><br/>药品功效：<asp:TextBoxID="Efficacy"runat="server"Height="54px"TextMode="MultiLine"Width="185px"></asp:TextBox><br/><br/>药品成份：<asp:TextBoxID="Ingredient"runat="server"Height="54px"TextMode="MultiLine"Width="185px"></asp:TextBox><br/><br/>服用方法：<asp:TextBoxID="Usage"runat="server"Height="54px"TextMode="MultiLine"Width="185px"ReadOnly="false"></asp:TextBox><br/><br/> <asp:ButtonID="Button1"runat="server"Text="修改"/><asp:HyperLinkID="HyperLink2"runat="server"NavigateUrl="~/main.aspx">返回首页</asp:HyperLink></td></tr></table>   </form></body></html>查询药品信息页面源代码<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="MedicineManage.aspx.cs"Inherits="MedicineManage"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><title></title><styletype="text/css">.STYLE1{color:#FF0000}body,td,th{ font-size:9pt;}body{ margin-left:0px; margin-right:0px; margin-bottom:0px; margin-top:0px;}.style7{height:22px;font-weight:bold;font-size:large;text-align:center;color:#FFFFFF;}.style8{text-align:center;}</style><scriptlanguage="javascript"type="text/javascript">//<!CDATA[functionTABLE1_onclick(){}//]]></script></head><bodybackground="back_012.gif"><formmethod="post"id="form1"runat="server"><br/><br/><br/><br/><br/><br/><br/> <tablewidth=100%border=0cellpadding=0cellspacing=0align="center"id="TABLE1"onclick="returnTABLE1_onclick()"><trbgcolor="#33b7f9"> <tdclass="style7">查询药品信息</td></tr><tr><tdstyle="width:100%;background-color:maroon;"valign=topclass="style8"><divclass="style8">药品名称：<asp:TextBoxID="MedicineName"runat="server"Width="141px"></asp:TextBox>   <asp:ButtonID="Button1"runat="server"Text="查询"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.aspx">返回首页</asp:HyperLink><br/></div>                    </tr></table><br/><br/><br/> </form></body></html>窗体发生代码usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassMedicineManage:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){Stringsqlconn="DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();SqlCommandmyCommand=newSqlCommand("select*frommedicine",myConnection);SqlDataAdapterAdapter=newSqlDataAdapter();Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet();Adapter.Fill(myDs);Response.Write("<h3>药品信息</h3>");Response.Write("<tableborder=1cellspacing=0cellpadding=2>");DataTablemyTable=myDs.Tables[0];Response.Write("<trbgcolor=green>");foreach(DataColumnmyColumninmyTable.Columns){Response.Write("<td>"+myColumn.ColumnName+"</td>");}Response.Write("</tr>");foreach(DataRowmyRowinmyTable.Rows){Response.Write("<tr>");foreach(DataColumnmyColumninmyTable.Columns){Response.Write("<td>"+myRow[myColumn]+"</td>");}Response.Write("</tr>");}Response.Write("</table>");myConnection.Close();}protectedvoidButton1_Click(objectsender,EventArgse){Stringsqlconn="DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();stringstr="select*frommedicinewhere药品名称='"+MedicineName.Text+"'";SqlCommandmyCommand=newSqlCommand(str,myConnection);SqlDataAdapterAdapter=newSqlDataAdapter();Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet();Adapter.Fill(myDs);Response.Write("<h3>查询获得的信息</h3>");Response.Write("<tableborder=1cellspacing=0cellpadding=2>");DataTablemyTable=myDs.Tables[0];Response.Write("<trbgcolor=green>");foreach(DataColumnmyColumninmyTable.Columns){Response.Write("<td>"+myColumn.ColumnName+"</td>");}Response.Write("</tr>");foreach(DataRowmyRowinmyTable.Rows){Response.Write("<tr>");foreach(DataColumnmyColumninmyTable.Columns){Response.Write("<td>"+myRow[myColumn]+"</td>");}Response.Write("</tr>");}Response.Write("</table>");myConnection.Close();}}住院登记页面源代码<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="PatientAdd.aspx.cs"Inherits="PatientAdd"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><title></title><styletype="text/css">.STYLE1{color:#FF0000}body,td,th{ font-size:9pt;}body{ margin-left:0px; margin-right:0px; margin-bottom:0px; margin-top:0px;}.style7{height:24px;font-size:large;font-weight:bold;text-align:center;color:#FFFFFF;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server">  <br/><br/><asp:ImageID="Image1"runat="server"Height="80px"ImageUrl="~/10.jpg"Width="812px"/><br/><tablewidth=600border=0cellpadding=0cellspacing=0align="center"style="height:213px"><trbgcolor="#33b7f9"> <tdclass="style7">住院信息登记</td></tr><tr><tdstyle="height:56px;background-color:gray"><br/>姓名：<asp:TextBoxID="Name"runat="server"Width="81px"></asp:TextBox><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="Name"ErrorMessage="姓名必填！"></asp:RequiredFieldValidator><br/><br/>性别： <asp:DropDownListID="Sex"runat="server"Width="81px"Height="16px"><asp:ListItem>男</asp:ListItem><asp:ListItem>女</asp:ListItem></asp:DropDownList><br/><br/>年龄：<asp:TextBoxID="Age"runat="server"Width="81px"></asp:TextBox><br/><br/>病房：<asp:TextBoxID="RoomNo"runat="server"Width="81px"></asp:TextBox><br/><br/>入院日期：<asp:TextBoxID="TextBox1"runat="server"></asp:TextBox><br/><br/>出院日期：<asp:TextBoxID="TextBox2"runat="server"></asp:TextBox><br/><br/>住院费：<asp:TextBoxID="TextBox3"runat="server"></asp:TextBox><br/><br/><br/>操作：<asp:TextBoxID="TextBox4"runat="server"></asp:TextBox><br/><asp:ButtonID="Button1"runat="server"Text="登记"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.aspx">返回首页</asp:HyperLink><br/></td></tr></table></form></body></html>窗体发生代码usingSystem;usingSystem.Data;usingSystem.Configuration;usingSystem.Collections;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web.UI.HtmlControls;usingSystem.Data.SqlClient;publicpartialclassPatientAdd:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){stringstr="DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True";stringtime=Convert.ToString(DateTime.Now.ToLongTimeString());SqlConnectionmyConnection=newSqlConnection(str);myConnection.Open();stringsqlstr="insertintoinhospitalvalues('"+this.Name.Text+"','"+this.Sex.Text+"','"+this.Age.Text+"','"+this.RoomNo.Text+"','"+this.TextBox1.Text+"','"+this.TextBox2.Text+"','"+this.TextBox3.Text+"','"+this.TextBox4.Text+"''')";SqlCommandcom=newSqlCommand(sqlstr,myConnection);com.ExecuteNonQuery();Respo