医院管理系统源代码

-.z.源代码登陆界面源代码：<%PageLanguage="C#"MasterPageFile="~/MasterPage.master"AutoEventWireup="true"CodeFile="login.asp*.cs"Inherits="logn"Title="UntitledPage"%><asp:ContentID="Content1"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server"><asp:ImageID="Image1"runat="server"Height="360p*"ImageUrl="~/7.jpg"Width="298p*"/></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="254p*"><strong>登录</strong><br/>用户名:<asp:Te*tBo*ID="Te*tBo*5"runat="server"></asp:Te*tBo*><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="Te*tBo*5"Display="Dynamic"ErrorMessage="用户名不能为空"ForeColor="Red"></asp:RequiredFieldValidator><br/>密码:<asp:Te*tBo*ID="Te*tBo*6"runat="server"Te*tMOde="Password"></asp:Te*tBo*><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator2"runat="server"ErrorMessage="密码不能为空"ForeColor="Red"ConTrolToValidate="Te*tBo*6"Display="Dynamic"></asp:RequiredFieldValidator><br/><asp:ButtonID="Button3"runat="server"Te*t="登录"onclick="Button1_Click"PostBackUrl="~/main.asp*"/><asp:LabelID="Label1"runat="server"Te*t=""></asp:Label></asp:Panel><asp:PanelID="Panel2"runat="server"><strong>新用户请注册</strong>                 用户名:<asp:Te*tBo*ID="Te*tBo*7"runat="server"></asp:Te*tBo*><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator3"runat="server"ControlToValidate="Te*tBo*7"Display="Dynamic"ErrorMessage="用户名不能为空"ForeColor="Red"></asp:RequiredFieldValidator><br/>密码:<asp:Te*tBo*ID="Te*tBo*8"runat="server"Te*tMOde="Password"></asp:Te*tBo*><br/><asp:RequiredFieldValidatorID="RequiredFieldValidator4"runat="server"ErrorMessage="密码不能为空"ForeColor="Red"ConTrolToValidate="Te*tBo*8"Display="Dynamic"></asp:RequiredFieldValidator><br/><asp:ButtonID="Button2"runat="server"Te*t="注册"onclick="Button2_Click"/><asp:LabelID="Label2"runat="server"Te*t=""></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(Te*tBo*5.Te*t==""&&Te*tBo*6.Te*t==""){Label1.Te*t="欢送你，登录成功";}else{Label1.Te*t="你输入的用户名错误或密码错误，请重新输入";}}protectedvoidButton2_Click(objectsender,EventArgse){if(Te*tBo*7.Te*t==""&&Te*tBo*8.Te*t==""){Label2.Te*t="欢送你，注册成功";}else{Label2.Te*t="请输入用户名和密码";}}}主界面源代码：<%PageLanguage="C#"MasterPageFile="~/MasterPage2.master"AutoEventWireup="true"CodeFile="main.asp*.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="10p*"Height="132p*"Width="161p*"Font-Underline="True"><StaticSelectedStyleBackColor="#FFCC66"/><StaticMenuItemStyleHorizontalPadding="5p*"VerticalPadding="2p*"/><DynamicHoverStyleBackColor="#990000"ForeColor="White"/><DynamicMenuStyleBackColor="#FFFBD6"/><DynamicSelectedStyleBackColor="#FFCC66"/><DynamicMenuItemStyleHorizontalPadding="5p*"VerticalPadding="2p*"/><StaticHoverStyleBackColor="#990000"ForeColor="White"/><Items><asp:MenuItemTe*t="首页"Value="首页"></asp:MenuItem><asp:MenuItemTe*t="系统管理"Value="系统管理"><asp:MenuItemNavigateUrl="~/ChangePassword.asp*"Te*t="用户修改密码"Value="用户修改密码"></asp:MenuItem><asp:MenuItemNavigateUrl="~/UserManage.asp*"Te*t="用户权限设置"Value="用户权限设置"></asp:MenuItem></asp:MenuItem><asp:MenuItemTe*t="挂号信息管理"Value="挂号信息管理"><asp:MenuItemNavigateUrl="~/RegisteredQuery.asp*"Te*t="挂号信息查询"Value="挂号信息登记"></asp:MenuItem><asp:MenuItemNavigateUrl="~/RegisteredAdd.asp*"Te*t="登记挂号信息"Value="登记挂号信息"></asp:MenuItem></asp:MenuItem><asp:MenuItemTe*t="药品信息管理"Value="药品信息管理"><asp:MenuItemNavigateUrl="~/MedicineManage.asp*"Te*t="药品查询信息"Value="药品查询信息"></asp:MenuItem><asp:MenuItemNavigateUrl="~/MedicineAdd.asp*"Te*t="添加药品信息"Value="添加药品信息"></asp:MenuItem></asp:MenuItem><asp:MenuItemTe*t="住院信息管理"Value="住院信息管理"><asp:MenuItemNavigateUrl="~/PatientQuery.asp*"Te*t="查询住院信息"Value="查询住院信息"></asp:MenuItem><asp:MenuItemNavigateUrl="~/PatientAdd.asp*"Te*t="住院信息登记"Value="住院信息登记"></asp:MenuItem></asp:MenuItem><asp:MenuItemNavigateUrl="~/Login.asp*"Te*t="退出"Value="退出"></asp:MenuItem></Items></asp:Menu><br/>院内通知<br/><spanstyle="display:inline!important;float:none;word-spacing:0p*;font:14p*/25p*宋体,Arial,Helvetica,sans-serif;te*t-transform:none;color:rgb(0,0,0);te*t-indent:28p*;white-space:normal;letter-spacing:normal;background-color:rgb(247,252,255);te*t-align:left;orphans:auto;widows:auto;webkit-te*t-stroke-width:0p*">为进一步完善危重孕产妇的救治工作，保护母婴安康，维护社会与家庭的和谐，我局特制定了"市危重孕产妇会诊、转诊工作原则与处置流程"，现下发给你们，并就进一步做好有关工作提出如下要求：加强组织管理，进一步聚焦"一高一低〞各级卫生行政部门和各有关医疗卫生单位要充分认识聚焦"一高一低〞工作…</span></asp:Content><asp:ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder2"Runat="Server"><br/><br/><br/><br/><asp:LabelID="Label1"runat="server"Font-Size="**-Large"ForeColor="#804000"Te*t="欢送进入ＸＸＸ医院"></asp:Label></asp:Content>出院信息登记页面源代码<%PageLanguage="C#"AutoEventWireup="true"CodeFile="InhospitalInfoUpdate.asp*.cs"Inherits="InhospitalInfoUpdate"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style7{height:24p*;font-size:large;font-weight:bold;te*t-align:center;color:#FFFFFF;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server"><br/><asp:ImageID="Image1"runat="server"Height="111p*"ImageUrl="~/10.jpg"Width="810p*"/><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"Te*t="Label"></asp:Label><br/><br/>性别： <asp:LabelID="Se*"runat="server"Te*t="Label"></asp:Label><br/><br/>年龄：<asp:LabelID="Age"runat="server"Te*t="Label"></asp:Label><br/><br/>病房：<asp:LabelID="RoomNo"runat="server"Te*t="Label"></asp:Label><br/><br/>入院日期：<asp:LabelID="ArrivelTime"runat="server"Te*t="Label"></asp:Label><br/><br/>住院费：<asp:Te*tBo*ID="Money"runat="server"Width="105p*"></asp:Te*tBo*>元<br/><br/>      <asp:ButtonID="Button1"runat="server"ForeColor="Red"Te*t="登记"/><asp:ButtonID="Button2"runat="server"ForeColor="Red"PostBackUrl="~/main.asp*"Te*t="返回"/></tr></table>  </form></body></html>修改密码页面源代码<%PageLanguage="C#"AutoEventWireup="true"CodeFile="ChangePassword.asp*.cs"Inherits="ChangePassword"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style1{font-weight:bold;font-size:large;te*t-align:center;color:#FFFFFF;}.style2{te*t-align:center;}</style></head><bodybackground="11.jpg"><formid="Form1"name="form1"method="post"runat=server><asp:ImageMapID="ImageMap1"runat="server"Height="135p*"ImageUrl="~/10.jpg"Width="812p*"></asp:ImageMap><br/><tablewidth="55%"border="1"cellpadding="0"cellspacing="2"align="center"style="height:31p*"><trbgcolor="#33b7f9"><tdclass="style1"style="width:387p*">修改密码</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:44p*">输入修改的密码</td><tdclass="style2"style="height:44p*"><asp:Te*tBo*ID="NewPassword"runat="server"Te*tMode="Password"Width="144p*"></asp:Te*tBo*><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="NewPassword"ErrorMessage="密码输入不能为空！"></asp:RequiredFieldValidator>   </td></tr><tr><tdclass="style2">确认修改的密码:</td><tdclass="style2"><asp:Te*tBo*ID="NewPasswordAgain"runat="server"Te*tMode="Password"Width="145p*"></asp:Te*tBo*><asp:pareValidatorID="pareValidator1"runat="server"ControlTopare="NewPassword"ControlToValidate="NewPasswordAgain"ErrorMessage="两次密码输入不一致！"></asp:pareValidator></td></tr><tr><tdheight="30"colspan="4"class="style2"><asp:ButtonID="Button1"runat="server"Te*t="提交"/>       <asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="main.asp*">返回首页</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.asp*.cs"Inherits="MedicineAdd"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style7{height:20p*;font-size:large;font-weight:bold;color:#FFFFFF;te*t-align:center;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server"><br/><asp:ImageID="Image1"runat="server"Height="106p*"ImageUrl="~/10.jpg"Width="811p*"/><br/><tablewidth=600border=0cellpadding=0cellspacing=0align="center"><trbgcolor="#33b7f9"><tdclass="style7">添加药品信息</td></tr><tr><tdstyle="height:42p*;background-color:gray"><br/>药品名称：<asp:Te*tBo*ID="MedicineName"runat="server"Width="81p*"></asp:Te*tBo*><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="MedicineName"ErrorMessage="药品名称必填！"></asp:RequiredFieldValidator><br/><br/>药品数量：<asp:Te*tBo*ID="Count"runat="server"Width="81p*"></asp:Te*tBo*><br/><br/>药品单价：<asp:Te*tBo*ID="Price"runat="server"Width="81p*"></asp:Te*tBo*>元<br/><br/>药品单位：<asp:Te*tBo*ID="Unit"runat="server"Width="81p*"></asp:Te*tBo*><br/><br/>批文编号：<asp:Te*tBo*ID="ApprovalNumber"runat="server"Width="81p*"></asp:Te*tBo*><br/><br/>药品成效：<asp:Te*tBo*ID="Efficacy"runat="server"Height="54p*"Te*tMode="MultiLine"Width="185p*"></asp:Te*tBo*><br/><br/>药品成份：<asp:Te*tBo*ID="Ingredient"runat="server"Height="54p*"Te*tMode="MultiLine"Width="185p*"></asp:Te*tBo*><br/><br/>服用方法：<asp:Te*tBo*ID="Usage"runat="server"Height="54p*"Te*tMode="MultiLine"Width="185p*"></asp:Te*tBo*><br/><br/>     <asp:ButtonID="Button1"runat="server"Te*t="添加"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.asp*">返回首页</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\\SQLE*PRESS;Database=hospital;IntegratedSecurity=True";stringtime=Convert.ToString(DateTime.Now.ToLongTimeString());SqlConnectionmyConnection=newSqlConnection(str);myConnection.Open();stringsqlstr="insertintomedicinevalues('"+this.MedicineName.Te*t+"','"+this.Count.Te*t+"','"+this.Price.Te*t+"','"+this.Unit.Te*t+"','"+this.ApprovalNumber.Te*t+"','"+this.Efficacy.Te*t+"','"+this.Ingredient.Te*t+"','"+this.Usage.Te*t+"''')";Sqlmand=newSqlmand(sqlstr,myConnection);.E*ecuteNonQuery();Response.Write("<script>alert('恭喜您，添加药品信息已成功！')</script>");}}修改药品信息页面源代码<%PageLanguage="C#"AutoEventWireup="true"CodeFile="MedicineDetails.asp*.cs"Inherits="MedicineDetails"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style7{height:20p*;font-size:large;font-weight:bold;te*t-align:center;color:#FFFFFF;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server"><br/><asp:ImageID="Image1"runat="server"Height="93p*"ImageUrl="~/10.jpg"Width="810p*"/><br/><tablewidth=600border=0cellpadding=0cellspacing=0align="center"><trbgcolor="#33b7f9"><tdclass="style7">修改药品信息</td></tr><trbgcolor="#f6fdfd"><tdstyle="height:42p*;background-color:gray;"><br/>药品名称：<asp:Te*tBo*ID="MedicineName"runat="server"ReadOnly="True"Width="81p*"></asp:Te*tBo*><br/><br/>药品数量：<asp:Te*tBo*ID="Count"runat="server"Width="81p*"></asp:Te*tBo*><br/><br/>药品单价：<asp:Te*tBo*ID="Price"runat="server"Width="81p*"></asp:Te*tBo*>元<br/><br/>药品单位：<asp:Te*tBo*ID="Unit"runat="server"Width="81p*"ReadOnly="true"></asp:Te*tBo*><br/><br/>批文编号：<asp:Te*tBo*ID="ApprovalNumber"runat="server"ReadOnly="True"Width="81p*"></asp:Te*tBo*><br/><br/>药品成效：<asp:Te*tBo*ID="Efficacy"runat="server"Height="54p*"Te*tMode="MultiLine"Width="185p*"></asp:Te*tBo*><br/><br/>药品成份：<asp:Te*tBo*ID="Ingredient"runat="server"Height="54p*"Te*tMode="MultiLine"Width="185p*"></asp:Te*tBo*><br/><br/>服用方法：<asp:Te*tBo*ID="Usage"runat="server"Height="54p*"Te*tMode="MultiLine"Width="185p*"ReadOnly="false"></asp:Te*tBo*><br/><br/> <asp:ButtonID="Button1"runat="server"Te*t="修改"/><asp:HyperLinkID="HyperLink2"runat="server"NavigateUrl="~/main.asp*">返回首页</asp:HyperLink></td></tr></table>   </form></body></html>查询药品信息页面源代码<%PageLanguage="C#"AutoEventWireup="true"CodeFile="MedicineManage.asp*.cs"Inherits="MedicineManage"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style7{height:22p*;font-weight:bold;font-size:large;te*t-align:center;color:#FFFFFF;}.style8{te*t-align:center;}</style><scriptlanguage="javascript"type="te*t/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:Te*tBo*ID="MedicineName"runat="server"Width="141p*"></asp:Te*tBo*>   <asp:ButtonID="Button1"runat="server"Te*t="查询"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.asp*">返回首页</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\\SQLE*PRESS;Database=hospital;IntegratedSecurity=True";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();Sqlmandmymand=newSqlmand("select*frommedicine",myConnection);SqlDataAdapterAdapter=newSqlDataAdapter();Adapter.Selectmand=mymand;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\\SQLE*PRESS;Database=hospital;IntegratedSecurity=True";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();stringstr="select*frommedicinewhere药品名称='"+MedicineName.Te*t+"'";Sqlmandmymand=newSqlmand(str,myConnection);SqlDataAdapterAdapter=newSqlDataAdapter();Adapter.Selectmand=mymand;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.asp*.cs"Inherits="PatientAdd"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style7{height:24p*;font-size:large;font-weight:bold;te*t-align:center;color:#FFFFFF;}</style></head><bodybackground="11.jpg"><formid="Form1"method="post"runat="server">  <br/><br/><asp:ImageID="Image1"runat="server"Height="80p*"ImageUrl="~/10.jpg"Width="812p*"/><br/><tablewidth=600border=0cellpadding=0cellspacing=0align="center"style="height:213p*"><trbgcolor="#33b7f9"><tdclass="style7">住院信息登记</td></tr><tr><tdstyle="height:56p*;background-color:gray"><br/>：<asp:Te*tBo*ID="Name"runat="server"Width="81p*"></asp:Te*tBo*><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="Name"ErrorMessage="**必填！"></asp:RequiredFieldValidator><br/><br/>性别： <asp:DropDownListID="Se*"runat="server"Width="81p*"Height="16p*"><asp:ListItem>男</asp:ListItem><asp:ListItem>女</asp:ListItem></asp:DropDownList><br/><br/>年龄：<asp:Te*tBo*ID="Age"runat="server"Width="81p*"></asp:Te*tBo*><br/><br/>病房：<asp:Te*tBo*ID="RoomNo"runat="server"Width="81p*"></asp:Te*tBo*><br/><br/>入院日期：<asp:Te*tBo*ID="Te*tBo*1"runat="server"></asp:Te*tBo*><br/><br/>出院日期：<asp:Te*tBo*ID="Te*tBo*2"runat="server"></asp:Te*tBo*><br/><br/>住院费：<asp:Te*tBo*ID="Te*tBo*3"runat="server"></asp:Te*tBo*><br/><br/><br/>操作：<asp:Te*tBo*ID="Te*tBo*4"runat="server"></asp:Te*tBo*><br/><asp:ButtonID="Button1"runat="server"Te*t="登记"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.asp*">返回首页</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\\SQLE*PRESS;Database=hospital;IntegratedSecurity=True";stringtime=Convert.ToString(DateTime.Now.ToLongTimeString());SqlConnectionmyConnection=newSqlConnection(str);myConnection.Open();stringsqlstr="insertintoinhospitalvalues('"+this.Name.Te*t+"','"+this.Se*.Te*t+"','"+this.Age.Te*t+"','"+this.RoomNo.Te*t+"','"+this.Te*tBo*1.Te*t+"','"+this.Te*tBo*2.Te*t+"','"+this.Te*tBo*3.Te*t+"','"+this.Te*tBo*4.Te*t+"''')";Sqlmand=newSqlmand(sqlstr,myConnection);.E*ecuteNonQuery();Response.Write("<script>alert('恭喜您，登记已成功！')</script>");}}查询住院页面源代码<%PageLanguage="C#"AutoEventWireup="true"CodeFile="PatientQuery.asp*.cs"Inherits="PatientQuery"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTD*HTML1.0Transitional//EN""./TR/*html1/DTD/*html1-transitional.dtd"><html*mlns="./1999/*html"><headid="Head1"runat="server"><title></title><styletype="te*t/css">.STYLE1{color:#FF0000}body,td,th{font-size:9pt;}body{margin-left:0p*;margin-right:0p*;margin-bottom:0p*;margin-top:0p*;}.style7{height:23p*;font-size:large;font-weight:bold;te*t-align:center;color:#FFFFFF;}.style8{te*t-align:center;}</style></head><bodybackground="back_012.gif"><formmethod="post"id="form"runat="server"><br/><br/><br/><br/><br/><br/> <tablewidth="100%"border=0cellpadding=0cellspacing=0align="center"><trbgcolor="#33b7f9"><tdclass="style7"style="width:697p*">查询住院信息</td></tr><tr><tdstyle="width:697p*;"valign=topclass="style8"><divclass="style8"style="background-color:maroon">：<asp:Te*tBo*ID="Name"runat="server"Width="70p*"></asp:Te*tBo*>   <asp:ButtonID="Button1"runat="server"ForeColor="Red"Te*t="查询"OnClick="Button1_Click"/><asp:HyperLinkID="HyperLink1"runat="server"NavigateUrl="~/main.asp*"ForeColor="Red"Width="50p*">返回首页</asp:HyperLink> <br/>病房：<asp:Te*tBo*ID="Te*tBo*1"runat="server"Width="73p*"></asp:Te*tBo*><asp:ButtonID="Button2"runat="server"ForeColor="Red"OnClick="Button2_Click"Te*t="查询"/><asp:HyperLinkID="HyperLink2"runat="server"ForeColor="Red"NavigateUrl="~/main.asp*"Width="56p*">返回首页</asp:HyperLink></div>                    </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;publicpartialclassPatientQuery:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){Stringsqlconn="DataSource=LENOVO-PC\\SQLE*PRESS;Database=hospital;IntegratedSecurity=True";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();Sqlmandmymand=newSqlmand("select*frominhospital",myConnection);SqlDataAdapterAdapter=newSqlDataAdapter();Adapter.Selectmand=mymand;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\\SQLE*PRESS;Database=hospital;IntegratedSecurity=True";SqlConnectionmyConnection=newSqlConnection(sqlconn);myConnection.Open();stringstr="select*frominhospitalwhere='"+Name.Te*t+"'";Sqlmandmymand=newSqlmand(str,myConnection);SqlDataAdapterAdapter=newSqlDataAdapter();Adapter.Selectmand=mymand;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();}protectedvoidButton2_Click(objectsender,EventArgse){Stringsqlconn="DataSource=LENOVO-PC\\SQLE*PRESS;