药品进销存系统C#.net-课程设计-说明书-源码

.net程序设计大作业学生姓名:学 号：学 院:电子与计算机科学技术学院专 业:网络工程题 目:医院药品进销存系统成 绩:指导教师： 2011 年 12月 10 日241.设计目的以药品信息为主体，通过对各种出库、入库的管理操作，实现以下目标：一、实现新药品的入库管理二、实现过期药品的出库登记，处理记录三、实现药品哭残的检索四、实现供货商信息的检索五、实现药品采购记录的管理六、实现药品用药说明信息的管理。2.设计内容基本全部工程3.1用例图说明 （图1） 用例图医药进销存系统(管理员)（图2）用例图用例图医药进销存系统(员工)3.2 数据库表的设计及说明药品信息表（表1）字段类型约束药品IDNchar(10)主码药品名Nchar(10)Not null供应商Nchar(10)Not null规格Nchar(10)Not null生产日期datetimeNot null有效期DatetimeNot null价格FloatNot null库存量IntNot null入库表（表2）字段类型约束药品IDNchar(10)主码经手人Nchar(10)Not null入库数量Int可以为null入库时间Nvarchar(50)Not null出库表（表3）字段类型约束药品ID主码单价Not null生产日期Not null出库日期Not null数量Not null供应商表（表4）字段类型约束供应商IDNchar(10)主码供应商名称Nchar(10)Not null联系地址Nchar(20)Not null联系电话Nchar(15)Not nullUser（表5）字段类型约束用户名adminNot null密码adminNot null客户表（表6）字段类型约束客户IDNvarchar(50)主码客户名称Nvarchar(50)Not null联系电话Nchar(15)Not null联系地址Nchar(20)Not null销售表（表7）字段类型约束订单号Int主码药品IDNchar(10)可以为null销售量Int可以为null销售时间Nvarchar(50)可以为null客户IDNchar(10)可以为null经手人Nchar(10)Not null员工表（表8）字段类型约束员工IDNchar(10)主码员工姓名Nchar(10)可以为null员工性别Nchar(10)可以为null年龄Nchar(10)可以为null联系电话Nchar(15)可以为null密码Varchar(MAX)可以为null员工权限Nchar(10)可以为null4.系统详细分析设计 4.1开发工具及系统运行环境（1）开发工具：Microsoft Visual Studio 2008 （2）运行环境：CPU奔腾 1.4G或以上内存512M或以上硬盘80GB或以上服务器端OSWindows 2000/NT/Server客户端OSWindows 2000/XP网络配置局域网4.2系统实现（1）登录界面using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class login : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void btnSubmit_Click1(object sender, EventArgs e) SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStringsyyxsstring.ToString(); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = select * from yuangong where 员工ID= + textUserName.Text + and 密码= + textUserPwd.Text + ; cmd.Connection = conn; SqlDataReader sr = cmd.ExecuteReader(); if (sr.Read() Sessionuser = this.textUserName.Text; Sessionpassword = this.textUserPwd.Text; Sessionus = sr.GetString(1).Trim(); Sessionpower = sr.GetString(6).Trim(); string power = Sessionpower.ToString(); if (power.Equals(admin) Response.Redirect(mlogin.aspx); else if (power.Equals(saler) Response.Redirect(slogin.aspx); else Response.Redirect(alogin.aspx); else Response.Write(alert(用户名或密码不正确！); protected void btnCancel_Click1(object sender, EventArgs e) textUserName.Text = ; textUserPwd.Text = ; （2）主界面using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class alogin : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (Sessionuser = null) Response.Redirect(login.aspx); else if (Sessionpower.ToString() != addinfo) Response.Redirect(login.aspx); using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partial class aselect : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) （3）药品信息using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class ypim : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) GridView1.Visible = true; GridView2.Visible = false; protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) GridView2.Visible = true; GridView1.Visible = false; protected void Button1_Click(object sender, EventArgs e) GridView1.DataSourceID = SqlDataSource1; GridView1.Visible = true; GridView2.Visible = false; /SqlConnection conn = new SqlConnection(Data Source=THINKPAD-PC;Initial Catalog=yiyao;Integrated Security=True); /string sql = select 药品ID,药品名,价格,库存量,供应商,单位,规格 from yaopin; /SqlDataAdapter adpater = new SqlDataAdapter(sql, conn); /DataSet ds = new DataSet(); /adpater.Fill(ds); /GridView1.DataSource = ds.Tables0.DefaultView; /GridView1.DataBind(); protected void Button2_Click(object sender, EventArgs e) /SqlConnection conn = new SqlConnection(Data Source=THINKPAD-PC;Initial Catalog=yiyao;Integrated Security=True); /string sql = select 药品ID,药品名,价格,库存量,供应商,单位,规格 from yaopin where 有效期 + DateTime.Now.ToString() + ; /SqlDataAdapter adpater = new SqlDataAdapter(sql, conn); /DataSet ds = new DataSet(); /adpater.Fill(ds); /GridView1.DataSource = ds.Tables0.DefaultView; /GridView1.DataBind(); GridView1.Visible = false; GridView2.Visible = false; protected void SqlDataSource6_Selecting(object sender, SqlDataSourceSelectingEventArgs e) （4）客户信息（5）供应商信息（6）增加药品信息using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class AddYaoPinInfo : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection(); conn.ConnectionString=ConfigurationManager.ConnectionStringsyyxsstring.ToString(); conn.Open(); SqlCommand smd = new SqlCommand(); smd.Connection = conn; smd.CommandText = select * from yaopin where 药品ID= + TextBox1.Text.Trim() + ; SqlDataReader sd = smd.ExecuteReader(); if (!sd.HasRows) sd.Close(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = insert into yaopin(药品ID,药品名,价格,供应商,单位,规格,生产日期,有效期)values( + TextBox1.Text.Trim() + , + TextBox2.Text.Trim() + , + float.Parse(TextBox3.Text) + , + TextBox4.Text.Trim() + , + TextBox5.Text.Trim() + , + TextBox6.Text.Trim() + , + TextBox7.Text.Trim() + , + TextBox8.Text.Trim() + ); cmd.ExecuteNonQuery(); Response.Write (alert(操作成功！); TextBox1.Text = ; TextBox2.Text = ; TextBox3.Text = ; TextBox4.Text = ; TextBox5.Text = ; TextBox6.Text = ; TextBox7.Text = ; TextBox8.Text = ; else Response.Write(alert(药品ID已存在); conn.Close(); sd.Close(); （7）增加客户信息using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class addkehu : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStringsyyxsstring.ToString(); conn.Open(); SqlCommand smd = new SqlCommand(); smd.Connection = conn; smd.CommandText = select * from kehu where 客户ID= + TextBox1.Text.Trim() + ; SqlDataReader sd = smd.ExecuteReader(); if (!sd.HasRows) sd.Close(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = insert into kehu(客户ID,客户名称,联系电话,联系地址) values( + TextBox1.Text.Trim() + , + TextBox2.Text.Trim() + , + TextBox3.Text.Trim() + , + TextBox4.Text.Trim() + ,); cmd.ExecuteNonQuery(); Response.Write(alert(操作成功！); TextBox1.Text = ; TextBox2.Text = ; TextBox3.Text = ; TextBox4.Text = ; else Response.Write(alert(客户ID已存在); conn.Close(); sd.Close(); （7）员工信息增加员工信息using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class adduser : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Button1_Click(object sender, EventArgs e) SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStringsyyxsstring.ToString(); conn.Open(); SqlCommand smd = new SqlCommand(); smd.Connection = conn; smd.CommandText = select * from yuangong where 员工ID= + TextBox1.Text.Trim() + ; SqlDataReader sd = smd.ExecuteReader(); if (!sd.HasRows) sd.Close(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = insert into yuangong(员工ID,员工姓名,员工性别,年龄,联系电话,密码,员工权限) values( + TextBox1.Text.Trim() + , + TextBox2.Text.Trim() + , + TextBox3.Text.Trim() + , + TextBox4.Text.Trim() + , + TextBox5.Text.Trim() + , + TextBox6.Text.Trim() + , + TextBox7.Text.Trim() + ); cmd.ExecuteNonQuery(); Response.Write(alert(操作成功！); TextBox1.Text = ; TextBox2.Text = ; TextBox3.Text = ; TextBox4.Text = ; TextBox5.Text = ; TextBox6.Text = ; TextBox7.Text = ; else Response.Write(alert(员工ID已存在); conn.Close(); sd.Close(); 修改员工信息删除员工信息（8）数据恢复4.3 心得体会在这次的编程实训中，我对于一些编程思想有了新的认识，例如，以前并不看重模块化编程，但是，此次让我了解到模块化编程的好处和重要性。更重要的是，此次编程，我认识到了规范编程的重要性，在该系统中，我所使用的类名、变量和方法的命名都按 照了一定的规范。提高了自己的动手能力和独立完成作业的能力。在此次练习中，我有很多想实 现的功能，但因能力有限，不知如何下手。但是，