还剩32页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
源代码登陆界面源代码%@PageLanguage=C#MasterPageFile=~/MasterPage.masterAutoEventWireup=trueCodeFile=login.aspx.csInherits=lognTitle=UntitledPage%asp:ContentID=Content1ContentPlaceHolderID=ContentPlaceHolder1Runat=Serverasp:ImageID=Image1runat=serverHeight=360pxImageUrl=~/
7.jpgWidth=298px//asp:Contentasp:ContentID=Content2ContentPlaceHolderID=ContentPlaceHolder2Runat=Serverasp:LinkButtonID=LinkButton2runat=serveronclick=LinkButton2_Click用户请登录/asp:LinkButtonbr/asp:LinkButtonID=LinkButton1runat=serveronclick=LinkButton1_Click注册用户/asp:LinkButtonasp:PanelID=Panel1runat=serverWidth=254pxstrong登录/strongbr/用户名:asp:TextBoxID=TextBox5runat=server/asp:TextBoxbr/asp:RequiredFieldValidatorID=RequiredFieldValidator1runat=serverControlToValidate=TextBox5Display=DynamicErrorMessage=用户名不能为空ForeColor=Red/asp:RequiredFieldValidatorbr/密码:asp:TextBoxID=TextBox6runat=serverTextMOde=Password/asp:TextBoxbr/asp:RequiredFieldValidatorID=RequiredFieldValidator2runat=serverErrorMessage=密码不能为空ForeColor=RedConTrolToValidate=TextBox6Display=Dynamic/asp:RequiredFieldValidatorbr/asp:ButtonID=Button3runat=serverText=登录onclick=Button1_ClickPostBackUrl=~/main.aspx/asp:LabelID=Label1runat=serverText=/asp:Label/asp:Panelasp:PanelID=Panel2runat=serverstrong新用户请注册/strongnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;用户名:asp:TextBoxID=TextBox7runat=server/asp:TextBoxbr/asp:RequiredFieldValidatorID=RequiredFieldValidator3runat=serverControlToValidate=TextBox7Display=DynamicErrorMessage=用户名不能为空ForeColor=Red/asp:RequiredFieldValidatorbr/密码:asp:TextBoxID=TextBox8runat=serverTextMOde=Password/asp:TextBoxbr/asp:RequiredFieldValidatorID=RequiredFieldValidator4runat=serverErrorMessage=密码不能为空ForeColor=RedConTrolToValidate=TextBox8Display=Dynamic/asp:RequiredFieldValidatorbr/asp:ButtonID=Button2runat=serverText=注册onclick=Button2_Click/asp:LabelID=Label2runat=serverText=/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_LoadobjectsenderEventArgse{if!IsPostBack{Panel
1.Visible=false;Panel
2.Visible=false;}}protectedvoidLinkButton2_ClickobjectsenderEventArgse{Panel
1.Visible=true;Panel
2.Visible=false;}protectedvoidLinkButton1_ClickobjectsenderEventArgse{Panel
1.Visible=false;Panel
2.Visible=true;}protectedvoidButton1_ClickobjectsenderEventArgse{ifTextBox
5.Text==TextBox
6.Text=={Label
1.Text=欢迎你,登录成功;}else{Label
1.Text=你输入的用户名错误或密码错误,请重新输入;}}protectedvoidButton2_ClickobjectsenderEventArgse{ifTextBox
7.Text==TextBox
8.Text=={Label
2.Text=欢迎你,注册成功;}else{Label
2.Text=请输入用户名和密码;}}}主界面源代码%@PageLanguage=C#MasterPageFile=~/MasterPage
2.masterAutoEventWireup=trueCodeFile=main.aspx.csInherits=Default2Title=UntitledPage%asp:ContentID=Content1ContentPlaceHolderID=ContentPlaceHolder1Runat=Servernbsp;asp:MenuID=Menu1runat=serverBackColor=#FFFBD6DynamicHorizontalOffset=2Font-Names=VerdanaFont-Size=LargerForeColor=#990000StaticSubMenuIndent=10pxHeight=132pxWidth=161pxFont-Underline=TrueStaticSelectedStyleBackColor=#FFCC66/StaticMenuItemStyleHorizontalPadding=5pxVerticalPadding=2px/DynamicHoverStyleBackColor=#990000ForeColor=White/DynamicMenuStyleBackColor=#FFFBD6/DynamicSelectedStyleBackColor=#FFCC66/DynamicMenuItemStyleHorizontalPadding=5pxVerticalPadding=2px/StaticHoverStyleBackColor=#990000ForeColor=White/Itemsasp:MenuItemText=首页Value=首页/asp:MenuItemasp:MenuItemText=系统管理Value=系统管理asp:MenuItemNavigateUrl=~/ChangePassword.aspxText=用户修改密码Value=用户修改密码/asp:MenuItemasp:MenuItemNavigateUrl=~/UserManage.aspxText=用户权限设置Value=用户权限设置/asp:MenuItem/asp:MenuItemasp:MenuItemText=挂号信息管理Value=挂号信息管理asp:MenuItemNavigateUrl=~/RegisteredQuery.aspxText=挂号信息查询Value=挂号信息登记/asp:MenuItemasp:MenuItemNavigateUrl=~/RegisteredAdd.aspxText=登记挂号信息Value=登记挂号信息/asp:MenuItem/asp:MenuItemasp:MenuItemText=药品信息管理Value=药品信息管理asp:MenuItemNavigateUrl=~/MedicineManage.aspxText=药品查询信息Value=药品查询信息/asp:MenuItemasp:MenuItemNavigateUrl=~/MedicineAdd.aspxText=添加药品信息Value=添加药品信息/asp:MenuItem/asp:MenuItemasp:MenuItemText=住院信息管理Value=住院信息管理asp:MenuItemNavigateUrl=~/PatientQuery.aspxText=查询住院信息Value=查询住院信息/asp:MenuItemasp:MenuItemNavigateUrl=~/PatientAdd.aspxText=住院信息登记Value=住院信息登记/asp:MenuItem/asp:MenuItemasp:MenuItemNavigateUrl=~/Login.aspxText=退出Value=退出/asp:MenuItem/Items/asp:Menubr/院内通知br/spanstyle=display:inline!important;float:none;word-spacing:0px;font:14px/25px宋体ArialHelveticasans-serif;text-transform:none;color:rgb000;text-indent:28px;white-space:normal;letter-spacing:normal;background-color:rgb247252255;text-align:left;orphans:auto;widows:auto;webkit-text-stroke-width:0px为进一步完善危重孕产妇的救治工作,保护母婴健康,维护社会与家庭的和谐,我局特制定了《市危重孕产妇会诊、转诊工作原则与处置流程》,现下发给你们,并就进一步做好有关工作提出如下要求加强组织管理,进一步聚焦“一高一低”各级卫生行政部门和各有关医疗卫生单位要充分认识聚焦“一高一低”工作…/span/asp:Contentasp:ContentID=Content2ContentPlaceHolderID=ContentPlaceHolder2Runat=Serverbr/br/br/br/asp:LabelID=Label1runat=serverFont-Size=XX-LargeForeColor=#804000Text=欢迎进入XXX医院/asp:Label/asp:Content出院信息登记页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=InhospitalInfoUpdate.aspx.csInherits=InhospitalInfoUpdate%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{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/headbodybackground=
11.jpgformid=Form1method=postrunat=serverbr/asp:ImageID=Image1runat=serverHeight=111pxImageUrl=~/
10.jpgWidth=810px/br/tablewidth=600border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style7出院信息登记/td/trtrtdstyle=background-color:limenbsp;br/姓名nbsp;asp:LabelID=Namerunat=serverText=Label/asp:Labelbr/br/性别nbsp;asp:LabelID=Sexrunat=serverText=Label/asp:Labelbr/br/年龄asp:LabelID=Agerunat=serverText=Label/asp:Labelbr/br/病房asp:LabelID=RoomNorunat=serverText=Label/asp:Labelbr/br/入院日期asp:LabelID=ArrivelTimerunat=serverText=Label/asp:Labelbr/br/住院费asp:TextBoxID=Moneyrunat=serverWidth=105px/asp:TextBox元br/br/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:ButtonID=Button1runat=serverForeColor=RedText=登记/asp:ButtonID=Button2runat=serverForeColor=RedPostBackUrl=~/main.aspxText=返回//tr/tablenbsp;nbsp;/form/body/html修改密码页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=ChangePassword.aspx.csInherits=ChangePassword%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{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/headbodybackground=
11.jpgformid=Form1name=form1method=postrunat=serverasp:ImageMapID=ImageMap1runat=serverHeight=135pxImageUrl=~/
10.jpgWidth=812px/asp:ImageMapbr/tablewidth=55%border=1cellpadding=0cellspacing=2align=centerstyle=height:31pxtrbgcolor=#33b7f9tdclass=style1style=width:387px修改密码/td/tr/tabletablewidth=55%border=1cellspacing=0cellpadding=0align=centerstyle=background-color:#f6fdfdtrtdtablewidth=100%border=1cellspacing=1cellpadding=2align=centertrtdclass=style2style=height:44px输入修改的密码/tdtdclass=style2style=height:44pxasp:TextBoxID=NewPasswordrunat=serverTextMode=PasswordWidth=144px/asp:TextBoxasp:RequiredFieldValidatorID=RequiredFieldValidator1runat=serverControlToValidate=NewPasswordErrorMessage=密码输入不能为空!/asp:RequiredFieldValidatornbsp;nbsp;nbsp;/td/trtrtdclass=style2确认修改的密码:/tdtdclass=style2asp:TextBoxID=NewPasswordAgainrunat=serverTextMode=PasswordWidth=145px/asp:TextBoxasp:CompareValidatorID=CompareValidator1runat=serverControlToCompare=NewPasswordControlToValidate=NewPasswordAgainErrorMessage=两次密码输入不一致!/asp:CompareValidator/td/trtrtdheight=30colspan=4class=style2asp:ButtonID=Button1runat=serverText=提交/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=main.aspx返回首页/asp:HyperLinkbr/asp:LiteralID=ErrMessagerunat=server/asp:Literal/td/tr/table/td/tr/table/form/body/html添加药品页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=MedicineAdd.aspx.csInherits=MedicineAdd%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{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/headbodybackground=
11.jpgformid=Form1method=postrunat=serverbr/asp:ImageID=Image1runat=serverHeight=106pxImageUrl=~/
10.jpgWidth=811px/br/tablewidth=600border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style7添加药品信息/td/trtrtdstyle=height:42px;background-color:graybr/药品名称asp:TextBoxID=MedicineNamerunat=serverWidth=81px/asp:TextBoxasp:RequiredFieldValidatorID=RequiredFieldValidator1runat=serverControlToValidate=MedicineNameErrorMessage=药品名称必填!/asp:RequiredFieldValidatorbr/br/药品数量asp:TextBoxID=Countrunat=serverWidth=81px/asp:TextBoxbr/br/药品单价asp:TextBoxID=Pricerunat=serverWidth=81px/asp:TextBox元br/br/药品单位asp:TextBoxID=Unitrunat=serverWidth=81px/asp:TextBoxbr/br/批文编号asp:TextBoxID=ApprovalNumberrunat=serverWidth=81px/asp:TextBoxbr/br/药品功效asp:TextBoxID=Efficacyrunat=serverHeight=54pxTextMode=MultiLineWidth=185px/asp:TextBoxbr/br/药品成份asp:TextBoxID=Ingredientrunat=serverHeight=54pxTextMode=MultiLineWidth=185px/asp:TextBoxbr/br/服用方法asp:TextBoxID=Usagerunat=serverHeight=54pxTextMode=MultiLineWidth=185px/asp:TextBoxbr/br/nbsp;nbsp;nbsp;nbsp;nbsp;asp:ButtonID=Button1runat=serverText=添加OnClick=Button1_Click/asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLink/td/tr/tablenbsp;nbsp;/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_LoadobjectsenderEventArgse{}protectedvoidButton1_ClickobjectsenderEventArgse{stringstr=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;stringtime=Convert.ToStringDateTime.Now.ToLongTimeString;SqlConnectionmyConnection=newSqlConnectionstr;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=newSqlCommandsqlstrmyConnection;com.ExecuteNonQuery;Response.Writescriptalert恭喜您,添加药品信息已成功!/script;}}修改药品信息页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=MedicineDetails.aspx.csInherits=MedicineDetails%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{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/headbodybackground=
11.jpgformid=Form1method=postrunat=serverbr/asp:ImageID=Image1runat=serverHeight=93pxImageUrl=~/
10.jpgWidth=810px/br/tablewidth=600border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style7修改药品信息/td/trtrbgcolor=#f6fdfdtdstyle=height:42px;background-color:gray;br/药品名称asp:TextBoxID=MedicineNamerunat=serverReadOnly=TrueWidth=81px/asp:TextBoxbr/br/药品数量asp:TextBoxID=Countrunat=serverWidth=81px/asp:TextBoxbr/br/药品单价asp:TextBoxID=Pricerunat=serverWidth=81px/asp:TextBox元br/br/药品单位asp:TextBoxID=Unitrunat=serverWidth=81pxReadOnly=true/asp:TextBoxbr/br/批文编号asp:TextBoxID=ApprovalNumberrunat=serverReadOnly=TrueWidth=81px/asp:TextBoxbr/br/药品功效asp:TextBoxID=Efficacyrunat=serverHeight=54pxTextMode=MultiLineWidth=185px/asp:TextBoxbr/br/药品成份asp:TextBoxID=Ingredientrunat=serverHeight=54pxTextMode=MultiLineWidth=185px/asp:TextBoxbr/br/服用方法asp:TextBoxID=Usagerunat=serverHeight=54pxTextMode=MultiLineWidth=185pxReadOnly=false/asp:TextBoxbr/br/nbsp;asp:ButtonID=Button1runat=serverText=修改/asp:HyperLinkID=HyperLink2runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLink/td/tr/tablenbsp;nbsp;nbsp;/form/body/html查询药品信息页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=MedicineManage.aspx.csInherits=MedicineManage%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{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;}/stylescriptlanguage=javascripttype=text/javascript//!CDATA[functionTABLE1_onclick{}//]]/script/headbodybackground=back_
012.gifformmethod=postid=form1runat=serverbr/br/br/br/br/br/br/nbsp;tablewidth=100%border=0cellpadding=0cellspacing=0align=centerid=TABLE1onclick=returnTABLE1_onclicktrbgcolor=#33b7f9tdclass=style7查询药品信息/td/trtrtdstyle=width:100%;background-color:maroon; valign=topclass=style8divclass=style8药品名称asp:TextBoxID=MedicineNamerunat=serverWidth=141px/asp:TextBoxnbsp;nbsp;nbsp;asp:ButtonID=Button1runat=serverText=查询OnClick=Button1_Click/asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLinkbr//divnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/tr/tablebr/br/br/nbsp;/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_LoadobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;SqlCommandmyCommand=newSqlCommandselect*frommedicinemyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3药品信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}protectedvoidButton1_ClickobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;stringstr=select*frommedicinewhere药品名称=+MedicineName.Text+;SqlCommandmyCommand=newSqlCommandstrmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3查询获得的信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}}住院登记页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=PatientAdd.aspx.csInherits=PatientAdd%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{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/headbodybackground=
11.jpgformid=Form1method=postrunat=servernbsp;nbsp;br/br/asp:ImageID=Image1runat=serverHeight=80pxImageUrl=~/
10.jpgWidth=812px/br/tablewidth=600border=0cellpadding=0cellspacing=0align=centerstyle=height:213pxtrbgcolor=#33b7f9tdclass=style7住院信息登记/td/trtrtdstyle=height:56px;background-color:graybr/姓名asp:TextBoxID=Namerunat=serverWidth=81px/asp:TextBoxasp:RequiredFieldValidatorID=RequiredFieldValidator1runat=serverControlToValidate=NameErrorMessage=姓名必填!/asp:RequiredFieldValidatorbr/br/性别nbsp;asp:DropDownListID=Sexrunat=serverWidth=81pxHeight=16pxasp:ListItem男/asp:ListItemasp:ListItem女/asp:ListItem/asp:DropDownListbr/br/年龄asp:TextBoxID=Agerunat=serverWidth=81px/asp:TextBoxbr/br/病房asp:TextBoxID=RoomNorunat=serverWidth=81px/asp:TextBoxbr/br/入院日期asp:TextBoxID=TextBox1runat=server/asp:TextBoxbr/br/出院日期asp:TextBoxID=TextBox2runat=server/asp:TextBoxbr/br/住院费asp:TextBoxID=TextBox3runat=server/asp:TextBoxbr/br/br/操作asp:TextBoxID=TextBox4runat=server/asp:TextBoxbr/asp:ButtonID=Button1runat=serverText=登记OnClick=Button1_Click/asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLinkbr//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_LoadobjectsenderEventArgse{}protectedvoidButton1_ClickobjectsenderEventArgse{stringstr=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;stringtime=Convert.ToStringDateTime.Now.ToLongTimeString;SqlConnectionmyConnection=newSqlConnectionstr;myConnection.Open;stringsqlstr=insertintoinhospitalvalues+this.Name.Text++this.Sex.Text++this.Age.Text++this.RoomNo.Text++this.TextBox
1.Text++this.TextBox
2.Text++this.TextBox
3.Text++this.TextBox
4.Text+;SqlCommandcom=newSqlCommandsqlstrmyConnection;com.ExecuteNonQuery;Response.Writescriptalert恭喜您,登记已成功!/script;}}查询住院页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=PatientQuery.aspx.csInherits=PatientQuery%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{font-size:9pt;}body{margin-left:0px;margin-right:0px;margin-bottom:0px;margin-top:0px;}.style7{height:23px;font-size:large;font-weight:bold;text-align:center;color:#FFFFFF;}.style8{text-align:center;}/style/headbodybackground=back_
012.gifformmethod=postid=formrunat=serverbr/br/br/br/br/br/nbsp;tablewidth=100%border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style7style=width:697px查询住院信息/td/trtrtdstyle=width:697px; valign=topclass=style8divclass=style8style=background-color:maroon姓名asp:TextBoxID=Namerunat=serverWidth=70px/asp:TextBoxnbsp;nbsp;nbsp;asp:ButtonID=Button1runat=serverForeColor=RedText=查询OnClick=Button1_Click/asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspxForeColor=RedWidth=50px返回首页/asp:HyperLinknbsp;br/病房asp:TextBoxID=TextBox1runat=serverWidth=73px/asp:TextBoxasp:ButtonID=Button2runat=serverForeColor=RedOnClick=Button2_ClickText=查询/asp:HyperLinkID=HyperLink2runat=serverForeColor=RedNavigateUrl=~/main.aspxWidth=56px返回首页/asp:HyperLink/divnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/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_LoadobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;SqlCommandmyCommand=newSqlCommandselect*frominhospitalmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3住院信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}protectedvoidButton1_ClickobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;stringstr=select*frominhospitalwhere姓名=+Name.Text+;SqlCommandmyCommand=newSqlCommandstrmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3查询获得的信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}protectedvoidButton2_ClickobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;stringstr=select*frominhospitalwhere病房=+Name.Text+;SqlCommandmyCommand=newSqlCommandstrmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3查询获得的信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}}挂号信息登记页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=RegisteredAdd.aspx.csInherits=RegisteredAdd%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{font-size:9pt;}body{margin-left:0px;margin-right:0px;margin-bottom:0px;margin-top:0px;}.style3{height:24px;font-weight:bold;font-size:large;color:#FFFFFF;text-align:center;}.style4{text-align:center;}/style/headbodybackground=
11.jpgformmethod=postrunat=serverid=form1br/br/asp:ImageID=Image2runat=serverHeight=98pxImageUrl=~/
10.jpgWidth=806px/br/br/br/br/br/br/nbsp;tablewidth=600border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style3挂号信息登记/td/trtrtdstyle=height:42px;background-color:graybr/姓名asp:TextBoxID=Namerunat=serverWidth=80px/asp:TextBoxasp:RequiredFieldValidatorID=RequiredFieldValidator1runat=serverControlToValidate=NameErrorMessage=姓名必填!/asp:RequiredFieldValidatorbr/br/性别asp:DropDownListID=Sexrunat=serverHeight=16pxWidth=80pxasp:ListItem男/asp:ListItemasp:ListItem女/asp:ListItem/asp:DropDownListbr/br/年龄asp:TextBoxID=Agerunat=serverWidth=80px/asp:TextBoxbr/br/nbsp;挂号科asp:TextBoxID=TextBox2runat=serverWidth=113px/asp:TextBoxnbsp;br/br/挂号日期asp:TextBoxID=TextBox1runat=serverOnTextChanged=TextBox1_TextChangedWidth=124px/asp:TextBoxbr/br/nbsp;挂号费asp:TextBoxID=TextBox3runat=serverWidth=68px/asp:TextBox元br/br/nbsp;asp:ButtonID=BtnGuaHaorunat=serverText=挂号OnClick=BtnGuaHao_Click/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLink/td/tr/tabledivclass=style4nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;br//div/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;publicpartialclassRegisteredAdd:System.Web.UI.Page{protectedvoidPage_LoadobjectsenderEventArgse{}protectedvoidTextBox1_TextChangedobjectsenderEventArgse{}protectedvoidBtnGuaHao_ClickobjectsenderEventArgse{stringstr=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;stringtime=Convert.ToStringDateTime.Now.ToLongTimeString;SqlConnectionmyConnection=newSqlConnectionstr;myConnection.Open;stringsqlstr=insertintoregisteredvalues+this.Name.Text++this.Sex.Text++this.Age.Text++this.TextBox
2.Text++this.TextBox
1.Text++this.TextBox
3.Text+;SqlCommandcom=newSqlCommandsqlstrmyConnection;com.ExecuteNonQuery;Response.Writescriptalert恭喜您,挂号已成功!/script;}}挂号信息查询页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=RegisteredQuery.aspx.csInherits=RegisteredQuery%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{font-size:9pt;}body{margin-left:0px;margin-right:0px;margin-bottom:0px;margin-top:0px;}.style3{height:18px;font-size:large;font-weight:bold;text-align:center;color:#FFFFFF;}.style4{text-align:center;}/style/headbodybackground=back_
012.gifformmethod=postid=form1runat=serverbr/br/br/br/br/tablewidth=100%border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style3挂号信息查询/td/trtrtdstyle=width:100%;background-color:maroon; valign=topclass=style4divclass=style4姓名:asp:TextBoxID=Namerunat=serverWidth=62px/asp:TextBoxnbsp;asp:ButtonID=Button2runat=serveronclick=Button2_ClickText=查询ForeColor=Red/br/nbsp;nbsp;nbsp;nbsp;nbsp;挂号日期:asp:TextBoxID=StartTimerunat=serverWidth=65px/asp:TextBoxnbsp;nbsp;nbsp;asp:ButtonID=BtnQueryrunat=serverOnClick=BtnQuery_ClickText=查询ForeColor=Red/nbsp;asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspxForeColor=Red返回首页/asp:HyperLinkbr//divnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/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;publicpartialclassRegisteredQuery:System.Web.UI.Page{protectedvoidPage_LoadobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;SqlCommandmyCommand=newSqlCommandselect*fromregisteredmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3住院信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}protectedvoidButton2_ClickobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;stringstr=select*fromregisteredwhere姓名=+Name.Text+;SqlCommandmyCommand=newSqlCommandstrmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3查询获得的信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}protectedvoidBtnQuery_ClickobjectsenderEventArgse{Stringsqlconn=DataSource=LENOVO-PC\\SQLEXPRESS;Database=hospital;IntegratedSecurity=True;SqlConnectionmyConnection=newSqlConnectionsqlconn;myConnection.Open;stringstr=select*fromregisteredwhere挂号日期=+StartTime.Text+;SqlCommandmyCommand=newSqlCommandstrmyConnection;SqlDataAdapterAdapter=newSqlDataAdapter;Adapter.SelectCommand=myCommand;DataSetmyDs=newDataSet;Adapter.FillmyDs;Response.Writeh3查询获得的信息/h3;Response.Writetableborder=1cellspacing=0cellpadding=2;DataTablemyTable=myDs.Tables
[0];Response.Writetrbgcolor=green;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myColumn.ColumnName+/td;}Response.Write/tr;foreachDataRowmyRowinmyTable.Rows{Response.Writetr;foreachDataColumnmyColumninmyTable.Columns{Response.Writetd+myRow[myColumn]+/td;}Response.Write/tr;}Response.Write/table;myConnection.Close;}}用户权限设置页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=UserDetails.aspx.csInherits=UserDetails%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlestyletype=text/css.STYLE1{color:#FF0000}bodytdth{font-size:9pt;}body{margin-left:0px;margin-right:0px;margin-bottom:0px;margin-top:0px;}.style3{height:21px;font-size:large;font-weight:bold;text-align:center;color:#FFFFFF;}.style4{text-align:center;}/style/headbodybackground=
11.jpgformid=Form1method=postrunat=serverbr/br/asp:ImageID=Image1runat=serverHeight=100pxImageUrl=~/
10.jpgWidth=809px/br/tablewidth=600border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style3用户权限设置/td/trtrtdstyle=height:42px;background-color:maroon;class=style4br/nbsp;asp:CheckBoxID=RegisteredAddrunat=serverText=挂号信息登记/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:CheckBoxID=RegisteredQueryrunat=serverText=挂号信息查询/br/br/nbsp;asp:CheckBoxID=PatientAddrunat=serverText=住院信息登记/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:CheckBoxID=PatientManagerunat=serverText=住院信息查询/br/br/nbsp;asp:CheckBoxID=MedicineAddrunat=serverText=药品信息登记/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:CheckBoxID=MedicineManagerunat=serverText=查询药品信息/br/br/nbsp;asp:CheckBoxID=UserManagerunat=serverText=用户权限管理/nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;br/br/nbsp;asp:ButtonID=Button1runat=serverText=修改/asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLink/td/tr/tablenbsp;nbsp;/form/body/html用户列表页面源代码%@PageLanguage=C#AutoEventWireup=trueCodeFile=UserManage.aspx.csInherits=UserManage%!DOCTYPEhtmlPUBLIC-//W3C//DTDXHTML
1.0Transitional//ENhttp://www.w
3.org/TR/xhtml1/DTD/xhtml1-transitional.dtdhtmlxmlns=http://www.w
3.org/1999/xhtmlheadid=Head1runat=servertitle/titlelinkhref=css/style.cssrel=stylesheettype=text/css/styletype=text/css.STYLE1{color:#FF0000}bodytdth{font-size:9pt;}body{margin-left:0px;margin-right:0px;margin-bottom:0px;margin-top:0px;}.style3{font-size:large;font-weight:bold;text-align:center;color:white;height:20px;}/style/headbodybackground=
11.jpgformmethod=postid=FORM1runat=serverbr/br/asp:ImageID=Image1runat=serverHeight=106pxImageUrl=~/
10.jpgWidth=811px/br/tablewidth=100%border=0cellpadding=0cellspacing=0align=centertrbgcolor=#33b7f9tdclass=style3style=width:808px用户列表/td/trtrtdstyle=width:808px; valign=topasp:GridViewID=GridView1runat=serverAutoGenerateColumns=FalseBackColor=WhiteBorderColor=#CCCCCCBorderStyle=NoneBorderWidth=1pxCellPadding=3Width=100%DataSourceID=UserDataSourceFooterStyleBackColor=WhiteForeColor=#000066/RowStyleForeColor=#000066/SelectedRowStyleBackColor=#669999Font-Bold=TrueForeColor=White/PagerStyleForeColor=#000066HorizontalAlign=LeftBackColor=White/HeaderStyleBackColor=#33B7F9Font-Bold=TrueForeColor=White/Columnsasp:BoundFieldDataField=用户姓名HeaderText=用户姓名SortExpression=用户姓名/asp:BoundFieldDataField=操作HeaderText=操作SortExpression=操作//Columns/asp:GridViewnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;asp:HyperLinkID=HyperLink1runat=serverNavigateUrl=~/main.aspx返回首页/asp:HyperLinkbr/asp:SqlDataSourceID=UserDataSourcerunat=serverConnectionString=%$ConnectionStrings:hospitalConnectionString%SelectCommand=SELECT*FROM[admin]/asp:SqlDataSourcenbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/tr/table/form/body/html。