仓库管理系统数据库课程设计8218891536

报告课题：仓库管理系统姓名：王昊齐指导教师：王强学院：信息工程学院 的和意义药品，因此仓库的管理成了一项十分重要的工作。快速，高效，便捷的管理仓库受到了高度的关注。能进行入库和出库操作等。通过仓库管理系统的设计与实现，使我们巩固和加的能力。有：●用户登录。实现根据不同用户的权限进行登录，并转到相应权限的操作。、修改、删除用户；一般用户修改信息等功能。●货物管理。实现管理人员对货物进库、退库的添加、修改、删除等功能。员对货物进行入库、出库操作，并可查询相理员最高储备和最低储备字段，对仓库中的产品实现监控和报警。计图EmpInfo)表存系统中用户的帐号、密码等信息Goods表放货物的相关信息(Company)表售商的角色)信息JhGoodsInfo)表放入库货物的相关信息llGoods表放出库货物的相关信息息表(ThGoodsInfo)表放退货的相关信息设计dameginNameex2ithdayept门osthonehoneMdress地址emarkDodsNameumptName库it位ime间RemarkName公司名称irect公司负责人Phone公司电话Fax公司传真ddress公司地址markDDmricesNeedPriceTimetName仓库markDDs模块panyInfocs改添加删除销售商信息ataBackcs份ataReolecs原Infocs改添加删除员工信息indGoodcs物信息onYingShangcs信息oodIDcs称hGoodsInfocscGoodFindcs件cGoodscs存信息及设置警报数量incsaincs界面ellGoodInfocs息ellGoodscs修改添加删除商品销售信息hGoodsInfocs改添加删除商品销售信息Programcs主入口点细设计添加入库信息的实现添加入库信息设计：进入主界面后，点击【进货管理】----【商品进货信息】即可打开添加入库界面。下面给出完成添加功能的关键代码：publicpartialclassfrmJhGoodsInfo:Form{publicfrmJhGoodsInfo(){tializeComponent}publicfrmJhGoodsInfo(intintCdo){tializeComponent}tbJhGoodsInfojhGoodnewtb_JhGoodsInfo();tb_JhGoodsInfoMenthodjhMenthod=newtb_JhGoodsInfoMenthod();publicstaticintintFalg=0;privatevoidControlStatus(){thistoolSaveEnabled=!this.toolSave.Enabled;thistoolAddEnabled=!this.toolAdd.Enabled;thistoolCancelEnabled=!this.toolCancel.Enabled;thistoolAmendEnabled=!this.toolAmend.Enabled;thistollDeleteEnabled=!this.tollDelete.Enabled;}存查询类的实现库存查询界面：界面。的空白区域。完成库存查询功能的核心代码：namespaceCHEXC{publicpartialclassfrmKcGoodFind:Form{publicfrmKcGoodFind(){tializeComponent}tbKcGoodsMenthodtbGoodMenthd=newtb_KcGoodsMenthod();tbKcGoodskcgood=newtb_KcGoods();privatevoidbutton1_Click(objectsender,EventArgse){ifcomboBox.Text==""){eturn}iftxtkeyText==""){MessageBoxShow输入查询信息");eturn}omboBoxText{case/"商品编号":kcgoodstrGoodsID=txtkey.Text;tbGoodMenthdtbThGoodsFind(dataGridView1,1,kcgood);break;case/商品名称"kcgoodstrKcGoodsName=txtkey.Text;tbGoodMenthdtbThGoodsFind(dataGridView1,kcgoodbreak;}}privatevoidfrmKcGoodFind_Load(objectsender,EventArgse){}}}设计主界面：菜单栏、工作区、状态栏等。功能界面：全部为主界面的子界面，并完成相互独立的功能。及功能概述2.1登陆界面：程面；如果账号或密码错误则会弹出错误提示，要求用户重新输入。2.2用户主界面：2.3添加用户界面：2.4商品退货界面：2.5商品销售信息界面：2.6商品库存界面：2.7供应商信息界面：业开始应用计算机来增强管理，提高效益。计算机软件作为计算机系统的两大组成部分之一，看起来更接近普通用户；户，人们总是更倾向于使用一个操作方便的软件系统。求，再设计一个相对方便操作的用户界面。在这两个方面集成开发环境(IDE)的作用显得十分突出，MicrosoftVisualStudio2005是一套非常强大的开发套件，利用它可以快速的开发出界面友好，功能强大的软件系统。户查询等操作，且系统运行比较稳定。个过程中我也学到了很多东西，对C#，数据库都有了更深入的理解，可以较熟练地使用VS2005开发软件，也增强了分析问题、解决问题的能力，总的来说这次毕业设计使我受益颇多。谢辞在论文完成之际，向我的老师王强老师表示深深的敬意！好多知识，学会了能够透彻的分析问题解决问题的能力。决问题和处理问题的能力，为我在今后的工作和生活中打下了基础。附录usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingCHEXC.ClassInfo;usingCHEXC.GoodMenhod;usingSystem.Data.SqlClient;namespaceCHEXC{publicpartialclassfrmJhGoodsInfo:Form{publicfrmJhGoodsInfo(){tializeComponent}publicfrmJhGoodsInfo(intintCdo){tializeComponent}tbJhGoodsInfojhGoodnewtb_JhGoodsInfo();tb_JhGoodsInfoMenthodjhMenthod=newtb_JhGoodsInfoMenthod();publicstaticintintFalg=0;privatevoidControlStatus(){thistoolSaveEnabled=!this.toolSave.Enabled;thistoolAddEnabled=!this.toolAdd.Enabled;thistoolCancelEnabled=!this.toolCancel.Enabled;thistoolAmendEnabled=!this.toolAmend.Enabled;thistollDeleteEnabled=!this.tollDelete.Enabled;}publicvoidClearContorl(){txtGoodsNumText"";txtGoodsRemark.Text="";txtGoodsSellPrice.Text="";txtJhCompName.Text="";txtGoodsNoPriceText"";txtGoodsNeedPrice.Text="";txtGoodsNameText"";txtGoodsJhPriceText"";txtGoodsID.Text="";txtEmpId.Text="";cmbDepotNameText";}publicintgetIntCount(){intintReslut0;if(intFalg==1){iftxtGoodsIDText""){returnintReslut}iftxtGoodsNameText==""){returnintReslut}iftxtJhCompNameText==""){returnintReslut}iftxtEmpIdText==""){returnintReslut}iftxtGoodsNumText""){returnintReslut}iftxtGoodsNameText==""){returnintReslut}}ifintFalg2){iftxtGoodsIDText""){MessageBox.Show("商品编号不能为空！,选择要修改记;returnintReslut}}ifintFalg=3){iftxtGoodsIDText""){MessageBox.Show("商品编号不能为空！,选择要删除记);returnintReslut}}jhGood.strGoodsID=txtGoodsID.Text;jhGood.strEmpId=txtEmpId.Text;jhGood.strJhCompName=txtGoodsName.Text;jhGood.strDepotName=cmbDepotName.Text;jhGood.strGoodsNum=Convert.ToInt32(txtGoodsNum.Text);jhGood.strGoodsName=txtGoodsName.Text;jhGood.strGoodsUnit=cmbGoodsUnit.Text;jhGood.deGoodsJhPrice=txtGoodsJhPrice.Text;jhGood.deGoodsNeedPrice=txtGoodsNeedPrice.Text;jhGood.deGoodsNoPrice=txtGoodsNoPrice.Text;jhGood.deGoodsSellPrice=txtGoodsSellPrice.Text;jhGood.strGoodsRemark=txtGoodsRemark.Text;jhGood.DaGoodTime=dateTimePicker1.Value;if(intFalg!=3){jhGood.Falg=0;}{jhGood.Falg=1;}intReslut=1;returnintReslut}privatevoidfrmJhGoodsInfo_Load(objectsender,EventArgse){jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);}privatevoidFillControls(){y{SqlDataReadersqldr=jhMenthod.tb_JhGoodsInfoFind(this.dataGridView1[0,thisdataGridViewCurrentCell.RowIndex].Value.ToString(),1);dldrHasRows{txtEmpIdTextsqldr1].ToString();txtGoodsNameTextsqldr4].ToString();cmbDepotNameTextsqldr[3].ToString();txtGoodsNumTextsqldr5].ToString();cmbGoodsUnitTextsqldr6].ToString();txtGoodsJhPriceTextsqldr7].ToString();txtGoodsNeedPriceTextsqldr9].ToString();txtGoodsNoPriceTextsqldr10].ToString();txtGoodsSellPriceTextsqldr8].ToString();txtGoodsRemarkTextsqldr11].ToString();txtJhCompNameTextsqldr[2].ToString();txtGoodsIDTextsqldr[0].ToString();txtGoodsIDEnabledfalse;}}tchExceptionee{MessageBoxShoweeToString));}}privatevoidcomboBox1_SelectedIndexChanged(objectsender,EventArgs{}privatevoidtoolAdd_Click(objectsender,EventArgse){lStatusontorlintFalg添加标记txtGoodsIDTextjhMenthod.JhGoodsID();txtGoodsIDEnabledfalse;}privatevoidtoolAmend_Click(objectsender,EventArgse){lStatusontorlintFalg添加标记}privatevoidtoolrefulsh_Click(objectsender,EventArgse){lStatusontorl}privatevoidtoolExit_Click(objectsender,EventArgse){thisClose);}privatevoidtoolCancel_Click(objectsender,EventArgse){lStatusontorl}privatevoidtoolSave_Click(objectsender,EventArgse){if(getIntCount()==1){if(intFalg==1){ifjhMenthodtbJhGoodsInfoMenthodAddjhGood=2){MessageBoxShow成功","提示");intFalg;jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);lStatusontorl}{MessageBoxShow失败","提示");intFalg;jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);lStatusontorl}}ifintFalg2){ifjhMenthodtbJhGoodsInfoMenthodUpdatejhGood1){MessageBoxShow成功","提示");intFalg;jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);lStatusontorl}{MessageBoxShow失败","提示");intFalg;jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);lStatusontorl}}ifintFalg=3){ifjhMenthodtbJhGoodsInfoMenthodDeletejhGood=1){MessageBoxShow成功","提示");intFalg;jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);lStatusontorl}{MessageBoxShow失败","提示");intFalg;jhMenthod.tb_JhGoodsInfoFind("",5,dataGridView1);lStatusontorl}}}}privatevoiddataGridView1_CellClick(objectsender,DataGridViewCellEventArgse){ifintFalg=2||intFalg==3){illControls}}privatevoidtxtGoodsJhPrice_TextChanged(objectsender,EventArgse){iftxtGoodsNumText""){txtGoodsNeedPrice.Text=ConvertToStringConvertToInttxtGoodsJhPriceTextConvert.ToInt32(txtGoodsNum.Text));}}privatevoidtxtGoodsSellPrice_KeyPress(objectsender,KeyPressEventArgse){ifeKeyChar8&&!char.IsDigit(e.KeyChar)&&e.KeyChar!='.'){MessageBoxShow输入数字");dledtrue}}privatevoidtxtGoodsNum_KeyPress(objectsender,KeyPressEventArgse){ifeKeyChar8&&!char.IsDigit(e.KeyChar)){MessageBoxShow输入数字");dledtrue}}privatevoidtxtGoodsJhPrice_KeyPress(objectsender,KeyPressEventArgs{ifeKeyChar8&&!char.IsDigit(e.KeyChar)&&e.KeyChar!='.'){MessageBoxShow输入数字");dledtrue}}privatevoidtxtGoodsNoPrice_KeyPress(objectsender,KeyPressEventArgs{ifeKeyChar8&&!char.IsDigit(e.KeyChar)&&e.KeyChar!='.'){MessageBoxShow输入数字");dledtrue}}/供应商信息privatevoidbutton1_Click(objectsender,EventArgse){mGonYingShangfrmgo