-.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>窗體發(fā)生代碼：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="系統(tǒng)管理"Value="系統(tǒng)管理"><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/>院內(nèi)通知<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*">為進一步完善危重孕產(chǎn)婦的救治工作，保護母嬰安康，維護社會與家庭的和諧，我局特制定了"市危重孕產(chǎn)婦會診、轉(zhuǎn)診工作原則與處置流程"，現(xiàn)下發(fā)給你們，并就進一步做好有關工作提出如下要求：加強組織管理，進一步聚焦"一高一低〞各級衛(wèi)生行政部門和各有關醫(yī)療衛(wèi)生單位要充分認識聚焦"一高一低〞工作…</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="歡送進入ＸＸＸ醫(yī)院"></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/>藥品數(shù)量：<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>窗體發(fā)生代碼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/>藥品數(shù)量：<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>窗體發(fā)生代碼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>窗體發(fā)生代碼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>窗體發(fā)生代碼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;