仓库信息管理系统课程设计报告

1 需求分析仓库信息管理系统，对进出货物进行管理，货物由货物号作为主键，货物名称，货物价格，货物库存以及货物商等标识，以及仓库管理人员的添加，修改，删除，以及对密码的管理。

需要对货物的添加，修改，删除，对货物的入库，出库，货物数量，经手人，以及进出时间进行记录，当货物进行入库出库操作时，则在数据库中会有相应改变，以达到仓库货物的管理。

2 概要设计登陆界面要求输入用户名和密码，现在数据库中建立一个User表，包含用户名和密码，登录时需要连接数据库，验证密码。

主页面有四个功能按钮，分别是货物维护，人员维护，进出记录，和密码修改。

货物维护中包含货物添加，修改，删除，以及查询，绑定数据库，同步显示。

人员维护中包含人员的添加，删除，修改，和密码的添加，连接数据库中建立的表，同步显示。

进出记录中建立的是Record表，包含入库和出库的的管理，当入库时，会显示货物的入库数量，会和建立的Goods表中的数量进行加减，相应的改变表中的GoodQuantity中的值，当出库时仓库中某货物数量不足，则会提示数量不足，禁止做错误的操作。

进出记录相当于日志的形式，记录货物往来情况，是仓库管理必不可少的一部分，包括经手人员，日期，数量。

密码修改部分实现对仓库管理人员的密码修改，实现安全性的管理。

3 运行环境（软、硬件环境）WindowsXP 系统下4 开发工具和编程语言开发工具 Microsoft Visual C#2008 Express EditionSQL Server2000编程语言 C#5 详细设计1.系统登录页面，包含用户名和密码，连接数据库相应代码(1)添加头using System.Data.SqlClient;连接数据库用(2)连接数据库代码:private void Form1_Load(object sender, EventArgs e){this.CenterToParent();SqlConnection conn = new SqlConnection("DataSource=.;Initial Catalog=CangKu;User ID=sa;Password=sa;connect Timeout=30");String sql = "select * from [User]";SqlCommand comm = new SqlCommand(sql, conn);SqlDataAdapter da = new SqlDataAdapter(comm);DataSet ds = new DataSet();da.Fill(ds);conn.Close();comboBox1.DataSource = ds.Tables[0];comboBox1.ValueMember = "UserName";}private void label2_Click(object sender, EventArgs e){}(3). 登录按钮代码：private void button1_Click(object sender, EventArgs e){int n = 0;String str1 = comboBox1.SelectedValue.ToString().Trim();String str2 = textBox2.Text.ToString().Trim();SqlConnection conn = new SqlConnection("DataSource=.;Initial Catalog=CangKu;User ID=sa;Password=sa;connect Timeout=30");String sql = "select * from [User]";if (ConnectionState.Closed == conn.State){conn .Open();}SqlCommand comm = new SqlCommand(sql, conn);SqlDataReader read = comm.ExecuteReader();while (read.Read()){if ((read[0].ToString().Trim() == str1) &&(read[1].ToString().Trim() == str2))//Trim()函数是将字符串开头和结尾的空格去除{//DialogResult = DialogResult.OK;//this.Close();主界面 frm2 = new主界面();frm2.ShowDialog();n = 1;break;}}if (n==0){MessageBox.Show("对不起，您的用户名/密码不正确，请重新输入");}}(4). 退出按钮代码：Application.Exit();//退出系统2.主页面功能及其代码(1).添加头using System.Data.SqlClient;(2).货物维护按钮代码GoodsAdd ga= new GoodsAdd();ga.Show();(3)进出记录按钮代码GoodsModify gm = new GoodsModify();gm.Show();(4).人员维护按钮代码Users Users = new Users();Users.Show();(5).密码修改按钮代码ChangePassword cpd = new ChangePassword();cpd.Show();3.货物维护主页面的功能代码添加货物按钮的代码：if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "")MessageBox.Show("请输入数据，进行添加");else{String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}SqlDataAdapter d = new SqlDataAdapter();d.InsertCommand = new SqlCommand("INSERT INTO Goods(GoodID,GoodName,GoodPrice,GoodProvider,GoodQuantity)Values('" + textBox1.Text + "',+'" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')", conn);d.InsertCommand.ExecuteNonQuery();conn.Close();textBox1.Clear(); ;textBox2.Clear(); ;textBox3.Clear();textBox4.Clear();textBox5.Clear();MessageBox.Show("添加成功");}RefreshList();}(2)更新数据库代码构造一个refreshlist函数private void Good_Load(object sender, EventArgs e){RefreshList();}private void RefreshList(){String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}String myselect = "select * from Goods";SqlDataAdapter adap = new SqlDataAdapter(myselect, conn);DataSet dts = new DataSet();adap.Fill(dts);dataGridView1.DataSource = dts.Tables[0];conn.Close();}//退出private void button2_Click(object sender, EventArgs e){Close();}(3)修改按钮代码：String str = "Data Source=.;Initial Catalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}SqlDataAdapter d = new SqlDataAdapter();String s = "UPDATE Goods SET GoodID='"+ textBox1.Text + "',GoodName='" + textBox2.Text + "',GoodPrice='" + textBox3.Text + "',GoodProvider='" + textBox4.Text +"',GoodQuantity='"+textBox5+"'where GoodID='"+textBox1.Text+"'";d.UpdateCommand = new SqlCommand(s, conn);d.UpdateCommand.ExecuteNonQuery();conn.Close();textBox1.Text = "";textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";textBox5.Text = "";RefreshList();(4).删除按钮代码：if (MessageBox.Show("是否要删除这条数据！", "删除信息", MessageBoxButtons.OKCancel) == DialogResult.OK){String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}SqlDataAdapter d = new SqlDataAdapter();d.DeleteCommand = new SqlCommand("DELETE from Goods where GoodID='" + textBox1.Text + "'", conn);d.DeleteCommand.ExecuteNonQuery();conn.Close();RefreshList();}(5).查询代码：String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}String myselect = "select * from Goods where GoodID='" + textBox6.Text + "'";SqlCommand comm=new SqlCommand (myselect,conn);SqlDataReader reader = comm.ExecuteReader();while (reader.Read()){textBox1.Text = reader[0].ToString();textBox2.Text = reader[1].ToString();textBox3.Text = reader[2].ToString();textBox4.Text = reader[3].ToString();textBox5.Text = reader[4].ToString();(6).显示表格框代码创建一个dataGridView组件try{textBox1.Text =dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[0].Value.ToS tring();textBox2.Text =dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[1].Value.ToS tring();textBox3.Text =dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[2].Value.ToS tring();textBox4.Text =dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[3].Value.ToS tring();textBox5.Text =dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells[4].Value.ToS tring();}catch (Exception es){Console.Write(es.ToString());}}(7).清除textBox里的内容代码textBox1.Text = "";textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";textBox5.Text = "";4．人员维护页面功能代码人员维护中的功能和货物维护中的功能类似，包含添加，删除，修改，代码基本相似，在这就不在赘述，1.添加功能代码if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "")MessageBox.Show("请输入数据，进行添加");else{String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}SqlDataAdapter d = new SqlDataAdapter();d.InsertCommand = new SqlCommand("INSERT INTOUsers(UID,Upassword,Usex,UName,UAddress,UTel)Values('"+ textBox1.Text + "',+'"+ textBox2.Text + "','"+ textBox3.Text + "','"+ textBox4.Text + "',+'" + textBox5.Text + "',+'" + textBox6.Text + "')", conn);d.InsertCommand.ExecuteNonQuery();conn.Close();textBox1.Text = "";textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";textBox5.Text = "";textBox6.Text = "";MessageBox.Show("添加成功");2.修改功能代码String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}SqlDataAdapter d = new SqlDataAdapter();String s = "UPDATE Users SET UID='" + textBox1.Text +"',Upassword='" + textBox2.Text + "',USex='" + textBox3.Text + "',UName='"+ textBox4.Text + "',UAddress='"+ textBox5.Text + "',UTel='" + textBox6.Text + "'where UID='" + textBox1.Text + "'";d.UpdateCommand = new SqlCommand(s, conn);d.UpdateCommand.ExecuteNonQuery();conn.Close();textBox1.Text = "";textBox2.Text = "";textBox3.Text = "";textBox4.Text = "";textBox5.Text = "";textBox6.Text = "";3.删除功能代码if (MessageBox.Show("是否要删除这条数据！", "删除信息", MessageBoxButtons.OKCancel) == DialogResult.OK){String str = "Data Source=.;InitialCatalog=cangku;Integrated Security=True";SqlConnection conn = new SqlConnection(str);if (ConnectionState.Closed == conn.State){conn.Open();}SqlDataAdapter d = new SqlDataAdapter();d.DeleteCommand = new SqlCommand("DELETE from Users where UID='" + textBox1.Text + "'", conn);d.DeleteCommand.ExecuteNonQuery();conn.Close();//RefreshList();}}4.进出记录功能代码此部分是仓库管理里的主要部分，主要用于仓库货物流动的记录，是仓库管理系统的核心部分。