HIS醫(yī)院管理系統(tǒng)實訓(xùn)指導(dǎo)書

項目實訓(xùn)指導(dǎo)書

版本歷史版本/狀態(tài)修訂人修改日期備注1.0.0鄧繼林2014-08-26創(chuàng)建文檔

開發(fā)背景HIS醫(yī)院管理系統(tǒng)是我國醫(yī)療衛(wèi)生事業(yè)改革中的重要一環(huán)，它對我國的醫(yī)療改革起著至關(guān)重要的作用，它的使用提高了醫(yī)療行業(yè)的工作效率，使患者的信息得到有效的共享。隨著我國醫(yī)療衛(wèi)生事業(yè)的改革的推進，建設(shè)一套高效、易用的HIS醫(yī)院管理系統(tǒng)是醫(yī)院信息化的必經(jīng)之路。醫(yī)院信息管理系統(tǒng)（HospitalInformationSystem，HIS）是一個復(fù)雜的管理信息系統(tǒng)（ManagementInformationSystems，MIS），HIS系統(tǒng)的核心是病人和病歷，系統(tǒng)需要記錄和管理伴隨人流、物流、財流所產(chǎn)生的各種信息，從而提高整個醫(yī)院的運行效率。項目目的ASP.NET基本原理的掌握ASP.NET基本控件的運用ASP.NET三層架構(gòu)開發(fā)的基本運用知識點準備ASP.NET基本原理：系統(tǒng)搭建系統(tǒng)框架組成ASP.NET頁面服務(wù)器控件的運用：GridView控件的綜合運用GridView模板列的運用GridView分頁驗證碼：驗證碼圖片的生成頁面輸入的驗證鞏固的知識點ASP.NET的基本原理ASP.NET中GridView控件的基本運用三層架構(gòu)的基本思想

需求分析系統(tǒng)流程功能結(jié)構(gòu)系統(tǒng)用例

數(shù)據(jù)庫設(shè)計邏輯設(shè)計系統(tǒng)的E-R圖如下：數(shù)據(jù)表設(shè)計表名：admin序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1usernamevarchar200是否2passwordvarchar320是3qx_GuaHaoAddint40是掛號的權(quán)限4qx_GuaHaoQueryint40是5qx_HuaJiaAddint40是6qx_HuaJiaQueryint40是7qx_PatientSignInint40是8qx_PatientManageint40是9qx_MedicineAddint40是10qx_MedicineManageint40是11qx_UserManageint40是表名：t_fayao序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1idint40是是否2huajia_serial_nochar100是3operateTimedatetime83是4operatorvarchar200是表名：t_guahao序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1idint40是是否2namenvarchar100是3sexnchar10是4ageint40是5subjectIdint40是6operateTimedatetime83是7operatorvarchar200是表名：t_huajia序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1idint40是是否2huajia_serial_novarchar500是3medicineIdint40是4pricefloat80是5countint40是6totalPricefloat80是7operateTimedatetime83是8operatorvarchar200是表名：t_huajia_cart序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1idint40是是否2usernamevarchar200是3medicineIdint40是4pricefloat80否5countint40是6totalPricefloat80是表名：t_medicine序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1medicineIdint40是是否2medicineNamenvarchar300是3pricefloat80是4stockCountint40是5unitnvarchar50是6pzwhnvarchar500是7ingredientnvarchar500是8efficacynvarchar1000是9usagenvarchar500是表名：t_subject序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1subjectIdint40是是否2subjectNamenvarchar500是3guahaoMoneyfloat80是表名：t_zhuyuan序號列名數(shù)據(jù)類型長度小數(shù)位標識主鍵外鍵允許空默認值說明1t_zhuyuan_idint40是是否2namevarchar500是3sexvarchar50是4ageint40是5roomNovarchar500是6arriveTimedatetime83是7isLeaveint40是8leaveTimedatetime83是9moneyfloat80是10checkinOperatorvarchar500是11checkoutOperatorvarchar500是數(shù)據(jù)庫相關(guān)數(shù)據(jù)表腳本創(chuàng)建數(shù)據(jù)表ifexists(select*fromsysobjectswhereid=OBJECT_ID('[admin]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[admin]CREATETABLE[admin]([username][varchar](20)NOTNULL,[password][varchar](32)NULL,[qx_GuaHaoAdd][int]NULL,[qx_GuaHaoQuery][int]NULL,[qx_HuaJiaAdd][int]NULL,[qx_HuaJiaQuery][int]NULL,[qx_PatientSignIn][int]NULL,[qx_PatientManage][int]NULL,[qx_MedicineAdd][int]NULL,[qx_MedicineManage][int]NULL,[qx_UserManage][int]NULL)ALTERTABLE[admin]WITHNOCHECKADDCONSTRAINT[PK_admin]PRIMARYKEYNONCLUSTERED([username])INSERT[admin]([username],[password],[qx_GuaHaoAdd],[qx_GuaHaoQuery],[qx_HuaJiaAdd],[qx_HuaJiaQuery],[qx_PatientSignIn],[qx_PatientManage],[qx_MedicineAdd],[qx_MedicineManage],[qx_UserManage])VALUES(N'admin',N'21232F297A57A5A743894A0E4A801FC3',1,1,1,1,1,1,1,1,1)INSERT[admin]([username],[password],[qx_GuaHaoAdd],[qx_GuaHaoQuery],[qx_HuaJiaAdd],[qx_HuaJiaQuery],[qx_PatientSignIn],[qx_PatientManage],[qx_MedicineAdd],[qx_MedicineManage],[qx_UserManage])VALUES(N'test',N'FE7F5E50999B2ACF3E86F288AEE2B3E9',1,1,1,1,1,1,1,1,0)ifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_fayao]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_fayao]CREATETABLE[t_fayao]([id][int]IDENTITY(1,1)NOTNULL,[huajia_serial_no][char](10)NULL,[operateTime][datetime]NULL,[operator][varchar](20)NULL)ALTERTABLE[t_fayao]WITHNOCHECKADDCONSTRAINT[PK_t_fayao]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[t_fayao]ONSETIDENTITY_INSERT[t_fayao]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_guahao]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_guahao]CREATETABLE[t_guahao]([id][int]IDENTITY(1,1)NOTNULL,[name][nvarchar](10)NULL,[sex][nchar](1)NULL,[age][int]NULL,[subjectId][int]NULL,[operateTime][datetime]NULL,[operator][varchar](20)NULL)ALTERTABLE[t_guahao]WITHNOCHECKADDCONSTRAINT[PK_t_guahao]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[t_guahao]ONINSERT[t_guahao]([id],[name],[sex],[age],[subjectId],[operateTime],[operator])VALUES(1,N'管理員',N'男',24,1,N'2009/9/1222:12:03',N'admin')INSERT[t_guahao]([id],[name],[sex],[age],[subjectId],[operateTime],[operator])VALUES(2,N'aa',N'男',22,1,N'2014/8/2621:34:47',N'admin')INSERT[t_guahao]([id],[name],[sex],[age],[subjectId],[operateTime],[operator])VALUES(3,N'張三',N'男',20,1,N'2014/8/2620:51:02',N'admin')SETIDENTITY_INSERT[t_guahao]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_huajia]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_huajia]CREATETABLE[t_huajia]([id][int]IDENTITY(1,1)NOTNULL,[huajia_serial_no][varchar](50)NULL,[medicineId][int]NULL,[price][float]NULL,[count][int]NULL,[totalPrice][float]NULL,[operateTime][datetime]NULL,[operator][varchar](20)NULL)ALTERTABLE[t_huajia]WITHNOCHECKADDCONSTRAINT[PK_t_huajia]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[t_huajia]ONINSERT[t_huajia]([id],[huajia_serial_no],[medicineId],[price],[count],[totalPrice],[operateTime],[operator])VALUES(1,N'admin20140815111945',1,1.2,7,8.4,N'2014/8/1511:19:45',N'admin')INSERT[t_huajia]([id],[huajia_serial_no],[medicineId],[price],[count],[totalPrice],[operateTime],[operator])VALUES(2,N'admin20140815111945',2,3.5,4,14,N'2014/8/1511:19:45',N'admin')INSERT[t_huajia]([id],[huajia_serial_no],[medicineId],[price],[count],[totalPrice],[operateTime],[operator])VALUES(10,N'admin20140902202941875',1,1.2,5,6,N'2014/9/220:29:41',N'admin')INSERT[t_huajia]([id],[huajia_serial_no],[medicineId],[price],[count],[totalPrice],[operateTime],[operator])VALUES(11,N'admin20140902202941924',2,3.5,4,14,N'2014/9/220:29:41',N'admin')INSERT[t_huajia]([id],[huajia_serial_no],[medicineId],[price],[count],[totalPrice],[operateTime],[operator])VALUES(12,N'admin20140902202941952',3,12,2,24,N'2014/9/220:29:41',N'admin')SETIDENTITY_INSERT[t_huajia]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_huajia_cart]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_huajia_cart]CREATETABLE[t_huajia_cart]([id][int]IDENTITY(1,1)NOTNULL,[username][varchar](20)NULL,[medicineId][int]NULL,[price][float]NOTNULL,[count][int]NULL,[totalPrice][float]NULL)ALTERTABLE[t_huajia_cart]WITHNOCHECKADDCONSTRAINT[PK_t_huajia_cart]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[t_huajia_cart]ONINSERT[t_huajia_cart]([id],[username],[medicineId],[price],[count],[totalPrice])VALUES(5,N'admin',1,1.2,5,6)INSERT[t_huajia_cart]([id],[username],[medicineId],[price],[count],[totalPrice])VALUES(6,N'admin',2,3.5,4,14)INSERT[t_huajia_cart]([id],[username],[medicineId],[price],[count],[totalPrice])VALUES(10,N'admin',3,12,2,24)SETIDENTITY_INSERT[t_huajia_cart]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_medicine]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_medicine]CREATETABLE[t_medicine]([medicineId][int]IDENTITY(1,1)NOTNULL,[medicineName][nvarchar](30)NULL,[price][float]NULL,[stockCount][int]NULL,[unit][nvarchar](5)NULL,[pzwh][nvarchar](50)NULL,[ingredient][nvarchar](50)NULL,[efficacy][nvarchar](100)NULL,[usage][nvarchar](50)NULL)ALTERTABLE[t_medicine]WITHNOCHECKADDCONSTRAINT[PK_t_medicine]PRIMARYKEYNONCLUSTERED([medicineId])SETIDENTITY_INSERT[t_medicine]ONINSERT[t_medicine]([medicineId],[medicineName],[price],[stockCount],[unit],[pzwh],[ingredient],[efficacy],[usage])VALUES(1,N'阿莫西林',1.2,88,N'粒',N'PZWH001',N'地黃,柴胡',N'消毒',N'一次一粒，一日三次')INSERT[t_medicine]([medicineId],[medicineName],[price],[stockCount],[unit],[pzwh],[ingredient],[efficacy],[usage])VALUES(2,N'板藍根',3.5,42,N'包',N'PZWH002',N'大青葉',N'清熱',N'一次一包，一日2次')INSERT[t_medicine]([medicineId],[medicineName],[price],[stockCount],[unit],[pzwh],[ingredient],[efficacy],[usage])VALUES(3,N'金銀花沖劑',12,48,N'袋',N'PZWH0003',N'金銀花，蔗糖',N'清熱解毒',N'一日2次，一次1包')INSERT[t_medicine]([medicineId],[medicineName],[price],[stockCount],[unit],[pzwh])VALUES(4,N'康泰克',10,100,N'1',N'1')SETIDENTITY_INSERT[t_medicine]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_subject]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_subject]CREATETABLE[t_subject]([subjectId][int]IDENTITY(1,1)NOTNULL,[subjectName][nvarchar](50)NULL,[guahaoMoney][float]NULL)ALTERTABLE[t_subject]WITHNOCHECKADDCONSTRAINT[PK_t_subject]PRIMARYKEYNONCLUSTERED([subjectId])SETIDENTITY_INSERT[t_subject]ONINSERT[t_subject]([subjectId],[subjectName],[guahaoMoney])VALUES(1,N'內(nèi)科',5)INSERT[t_subject]([subjectId],[subjectName],[guahaoMoney])VALUES(2,N'口腔科',3)INSERT[t_subject]([subjectId],[subjectName],[guahaoMoney])VALUES(3,N'外科',4)SETIDENTITY_INSERT[t_subject]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[t_zhuyuan]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[t_zhuyuan]CREATETABLE[t_zhuyuan]([t_zhuyuan_id][int]IDENTITY(1,1)NOTNULL,[name][varchar](50)NULL,[sex][varchar](5)NULL,[age][int]NULL,[roomNo][varchar](50)NULL,[arriveTime][datetime]NULL,[isLeave][int]NULL,[leaveTime][datetime]NULL,[money][float]NULL,[checkinOperator][varchar](50)NULL,[checkoutOperator][varchar](50)NULL)ALTERTABLE[t_zhuyuan]WITHNOCHECKADDCONSTRAINT[PK_t_zhuyuan]PRIMARYKEYNONCLUSTERED([t_zhuyuan_id])SETIDENTITY_INSERT[t_zhuyuan]ONINSERT[t_zhuyuan]([t_zhuyuan_id],[name],[sex],[age],[roomNo],[arriveTime],[isLeave],[leaveTime],[money],[checkinOperator])VALUES(1,N'小三',N'男',17,N'208',N'2009/9/189:32:17',1,N'2009/9/198:46:46',100,N'admin')INSERT[t_zhuyuan]([t_zhuyuan_id],[name],[sex],[age],[roomNo],[arriveTime],[isLeave],[leaveTime],[money],[checkinOperator])VALUES(2,N'c',N'男',21,N'a01',N'2014/8/2621:42:35',1,N'2014/8/2621:42:50',200,N'admin')INSERT[t_zhuyuan]([t_zhuyuan_id],[name],[sex],[age],[roomNo],[arriveTime],[isLeave],[leaveTime],[money],[checkinOperator])VALUES(3,N'張三',N'男',30,N'001',N'2014/8/2620:54:13',1,N'2014/8/2620:54:29',200,N'admin')INSERT[t_zhuyuan]([t_zhuyuan_id],[name],[sex],[age],[roomNo],[arriveTime],[isLeave],[leaveTime],[money],[checkinOperator])VALUES(4,N'A',N'男',20,N'006',N'2014/9/220:31:05',0,N'2014/9/220:31:05',0,N'admin')SETIDENTITY_INSERT[t_zhuyuan]OFF系統(tǒng)設(shè)計類圖實體層類圖數(shù)據(jù)訪問層類圖系統(tǒng)功能設(shè)計系統(tǒng)登錄界面設(shè)計：html代碼：<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="login.aspx.cs"Inherits="Hospital.login"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><head><metahttp-equiv="Content-Type"content="text/html;charset=gb2312"><styletype="text/css">A:visited{text-decoration:none;color:000000;}A:link{text-decoration:none;color:000000;}A:hover{text-decoration:none;color:04266D;}</style><scripttype="text/javascript">functioncheckParent(){if(window.parent.location!=window.location){window.parent.location.href='Login.aspx';//window.parent.location.reload();}}</script><title>系統(tǒng)登錄醫(yī)院信息管理系統(tǒng)</title></head><bodyonload="checkParent();"style="background-color:#FFFFFF;background-image:url('images/bg.gif')"><formid="form1"runat="server"><br><br><br><tablewidth="598"height="359"border="0"align="center"cellpadding="0"cellspacing="0"background="images/backpic.jpg"><tr><tdwidth="242"></td><tdstyle="width:120px"></td><tdwidth="247"height="129"></td></tr><tr><tdwidth="242"></td><tdalign="right"style="width:120px"><fontface="黑體"size="3">用戶名：</font></td><tdwidth="247"height="37"valign="middle"><asp:TextBoxID="adminUserName"runat="server"Width="122px"></asp:TextBox><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="adminUserName"ErrorMessage="帳號不能為空!"></asp:RequiredFieldValidator></td></tr><tr><tdwidth="242"></td><tdalign="right"style="width:120px"><fontface="黑體"size="3">密碼：</font></td><tdwidth="247"height="35"valign="middle"><asp:TextBoxID="adminPassword"runat="server"TextMode="Password"Width="123px"></asp:TextBox><asp:RequiredFieldValidatorID="RequiredFieldValidator2"runat="server"ControlToValidate="adminPassword"ErrorMessage="密碼不能為空!"></asp:RequiredFieldValidator></td></tr><tr><tdwidth="242"height="39"></td><tdheight="39"align="right"style="width:120px"><fontface="黑體"size="3">驗證碼:</font></td><tdwidth="247"height="39"valign="middle"><tablecellpadding="0"cellspacing="0"border="0"><tr><td><asp:TextBoxID="Validator"runat="server"Width="62px"></asp:TextBox></td><td><asp:ImageButtonID="ChangeCode"runat="server"CausesValidation="False"Height="20px"ImageUrl="Validate.aspx"OnClick="ChangeCode_Click"ToolTip="看不清楚？點擊圖片換一個驗證碼"Width="55px"/></td></tr></table></td></tr><tr><tdwidth="242"height="60"><palign="right">   </td><tdheight="60"style="width:367px"colspan="2"><palign="center"> <asp:ButtonID="Btn_Login"runat="server"OnClick="Btn_Login_Click"Text="登錄"/> <asp:ButtonID="Btn_Cancle"runat="server"OnClick="Btn_Cancle_Click"Text="取消"/></td></tr><tr><tdwidth="242"></td><tdstyle="width:120px"></td><tdwidth="247"></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;usingHospital.Model;usingHospital.Logic;namespaceHospital{publicpartialclasslogin:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(!IsPostBack){if(!Object.Equals(Request.Cookies["username"],null)){/*讀取保存用戶名的cookie信息,此信息保存在客戶端,方便管理員減少信息輸入*/HttpCookieadminUserNameCookie=Request.Cookies["username"];this.adminUserName.Text=adminUserNameCookie.Value;}/*當(dāng)驗證碼輸入完成后按回車鍵提交表單*/this.Validator.Attributes.Add("onkeypress","if(event.keyCode==13){document.all.Btn_Login.click();returnfalse;}");}}/*使用驗證碼可以防止網(wǎng)頁被暴力破解*/protectedvoidChangeCode_Click(objectsender,ImageClickEventArgse){/*重新載入驗證碼的圖片*/this.ChangeCode.ImageUrl="Validate.aspx";}protectedvoidBtn_Login_Click(objectsender,EventArgse){/*首先進行驗證碼的比對,正確的驗證碼在Validate.aspx的代碼文件中使用Session變量已經(jīng)保存*/if(String.Compare(Session["Code"].ToString(),this.Validator.Text,true)!=0){Response.Write("<script>alert('對不起,你輸入的驗證碼不正確!');</script>");return;/*返回，不執(zhí)行此后的代碼*/}/*密碼經(jīng)過md5哈希加密后再傳給業(yè)務(wù)層進行和數(shù)據(jù)庫中的登錄信息比對*/AdminModeladmin=newAdminModel();admin.setUsername(this.adminUserName.Text);admin.setPassword(System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(this.adminPassword.Text.Trim(),"MD5").ToString());AdminLogicadminLogic=newAdminLogic();if(adminLogic.checkAdmin(admin))/*如果密碼比對成功*/{/*將管理員帳號保存到cookie變量和session變量中然后轉(zhuǎn)到操作首頁main.aspx*/CreateCookie();Session["username"]=admin.getUsername();Session.Timeout=10;Response.Redirect("main.aspx");}else/*否則錯誤信息保存在admin對象的ErrMessage屬性中*/{Response.Write("<script>alert('"+adminLogic.getErrMessage()+"');</script>");}}protectedvoidBtn_Cancle_Click(objectsender,EventArgse){this.adminUserName.Text="";this.adminPassword.Text="";this.Validator.Text="";this.ChangeCode.ImageUrl="Validate.aspx";}/*如果帳號密碼都正確，則調(diào)用本函數(shù)將帳號信息加入的客戶端cookie中*/privatevoidCreateCookie(){HttpCookieadminUserNameCookie=newHttpCookie("username");adminUserNameCookie.Value=this.adminUserName.Text;adminUserNameCookie.Expires=DateTime.MaxValue;Response.AppendCookie(adminUserNameCookie);}}}管理首頁界面設(shè)計：html代碼：<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="main.aspx.cs"Inherits="main"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="/1999/xhtml"><headid="Head1"runat="server"><styletype="text/css">A:visited{text-decoration:none;color:000000;}A:link{text-decoration:none;color:000000;}A:hover{text-decoration:none;color:04266D;}</style><title>系統(tǒng)管理醫(yī)院信息管理系統(tǒng)</title></head><bodybgcolor="#FFFFFF"leftmargin="0"topmargin="0"background="images/bg.gif"><formid="form1"runat="server"><div><tablewidth="770"border="0"cellpadding="0"cellspacing="0"align="center"><tr><tdcolspan="2"style="background-color:#2aa3dd;font-size:12px;color:white;height:32px;"><tablecellspacing="0"><tr><tdstyle="width:806px;height:18px;">  操作員：<asp:LabelID="Operator"runat="server"Text="Label"></asp:Label></td><tdalign="right"style="width:650px;height:18px;">登錄時間：<asp:LabelID="LoginTime"runat="server"Text="Label"></asp:Label>  </td></tr></table></td></tr><tr><tdvalign="top"background="images/default_6.gif"align="center"><iframestyle="height:600px;width:158px;"frameborder="0"name="menu"scrolling="no"src="menu.aspx"width="158"></iframe></td><tdvalign="top"style="width:477px;background-image:url(images/default_5.gif);"><iframestyle="height:600px;width:624px;"frameborder="0"name="mainFrame"scrolling="no"src="desk.aspx"width="586"></iframe></td></tr></table></div></form></body></html>藥品庫房管理添加新藥品界面設(shè)計：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><linkhref="css/style.css"rel="stylesheet"type="text/css"/><scriptlanguage="javascript">functionseltime(inputName){window.open('seltime.aspx?InputName='+inputName+'','','width=250,height=220,left=360,top=250,scrollbars=yes');}</script></head><body><formid="Form1"method="post"runat="server"><tablewidth="600"border="0"cellpadding="0"cellspacing="0"align="center"><trstyle="color:blue;font-size:14px;"><tdstyle="height:13px;width:502px;"><imgsrc="images/ADD.gif"width="14px"height="14px">藥品庫房管理-->添加藥品信息</td></tr><tr><tdstyle="height:42px"><table><tr><td>藥品名稱：</td><td><asp:TextBoxID="MedicineName"runat="server"Style="width:280px"></asp:TextBox></td><td><asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ControlToValidate="MedicineName"ErrorMessage="請輸入藥品名稱！"></asp:RequiredFieldValidator></td></tr><tr><td>藥品單價：</td><td><asp:TextBoxID="Price"runat="server"Style="width:280px"></asp:TextBox>元</td></tr><tr><td>藥品數(shù)量：</td><td><asp:TextBoxID="StockCount"runat="server"Style="width:280px"></asp:TextBox></td></tr><tr><td>藥品單位：</td><td><asp:TextBoxID="Unit"runat="server"Style="width:280px"></asp:TextBox></td><td></td></tr><tr><td>批準文號：</td><td><asp:TextBoxID="Pzwh"runat="server"Style="width:280px"></asp:TextBox></td></tr><tr><td>藥物成分：</td><td><asp:TextBoxID="Ingredient"runat="server"Height="54px"TextMode="MultiLine"Style="width:280px"></asp:TextBox></td></tr><tr><td>藥品功效：</td><td><asp:TextBoxID="Efficacy"runat="server"Height="54px"TextMode="MultiLine"Style="width:280px"></asp:TextBox></td></tr><tr><td>使用方法：</td><td><asp:TextBoxID="Usage"runat="server"Height="54px"TextMode="MultiLine"Style="width:280px"></asp:TextBox></td></tr><tr><td><asp:ButtonID="Btn_Add"runat="server"Text="添加"OnClick="Btn_GuaHao_Click"/></td></tr></table></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;usingHospital.Model;usingHospital.Logic;publicpartialclassMedicineAdd:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){if(Session["username"]==null){Response.Redirect("login.aspx");}if(!IsPostBack){AdminModeladminModel=(newAdminLogic()).getAdminInfo(Session["username"].ToString());if(adminModel.getQx_MedicineAdd()!=1){Response.Write("<script>alert('對不起，你沒有此權(quán)限！"+adminModel.getQx_MedicineAdd()+"');location.href='desk.aspx';</script>");return;}}}protectedvoidBtn_GuaHao_Click(objectsender,EventArgse){stringmedicineName=this.MedicineName.Text;floatprice=Convert.ToSingle(this.Price.Text);intstockCount=Int32.Parse(this.StockCount.Text);stringunit=this.Unit.Text;stringpzwh=this.Pzwh.Text;stringingredient=this.Ingredient.Text;stringefficacy=this.Efficacy.Text;stringusage=this.Usage.Text;MedicineModelmedicineModel=newMedicineModel();medicineModel.setMedicineName(medicineName);medicineModel.setPrice(price);medicineModel.setStockCount(stockCount);medicineModel.setUnit(unit);medicineModel.setPzwh(pzwh);medicineModel.setIngredient(ingredient);medicineModel.setEfficacy(efficacy);medicineModel.setUsage(usage);MedicineLogicmedicineLogic=newMedicineLogic();if(medicineLogic.AddMedicineInfo(medicineModel))Response.Write("<script>alert('藥品信息添加成功!');location.href='MedicineAdd.aspx';</script>");elseResponse.Write("<script>alert('"+medicineLogic.getErrMessage()+"');<script>");}}藥品信息調(diào)整界面設(shè)計：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><linkhref="css/style.css"rel="stylesheet"type="text/css"/></head><body><formmethod="post"id="frmAnnounce"runat="server"><tablewidth="600"border="0"cellpadding="0"cellspacing="0"align="center"><trstyle="color:blue;font-size:14px;"><tdstyle="height:14px;width:600px;"><imgsrc="images/list.gif"width="14px"height="14px">藥品庫房管理-->藥品信息管理</td>