倉庫管理系統(tǒng)數(shù)據(jù)庫課程設(shè)計8218891536

報告課題：倉庫管理系統(tǒng)姓名：王昊齊指導(dǎo)教師：王強學(xué)院：信息工程學(xué)院 的和意義藥品，因此倉庫的管理成了一項十分重要的工作?？焖?，高效，便捷的管理倉庫受到了高度的關(guān)注。能進行入庫和出庫操作等。通過倉庫管理系統(tǒng)的設(shè)計與實現(xiàn)，使我們鞏固和加的能力。有：●用戶登錄。實現(xiàn)根據(jù)不同用戶的權(quán)限進行登錄，并轉(zhuǎn)到相應(yīng)權(quán)限的操作。、修改、刪除用戶；一般用戶修改信息等功能?！褙浳锕芾?。實現(xiàn)管理人員對貨物進庫、退庫的添加、修改、刪除等功能。員對貨物進行入庫、出庫操作，并可查詢相理員最高儲備和最低儲備字段，對倉庫中的產(chǎn)品實現(xiàn)監(jiān)控和報警。計圖EmpInfo)表存系統(tǒng)中用戶的帳號、密碼等信息Goods表放貨物的相關(guān)信息(Company)表售商的角色)信息JhGoodsInfo)表放入庫貨物的相關(guān)信息llGoods表放出庫貨物的相關(guān)信息息表(ThGoodsInfo)表放退貨的相關(guān)信息設(shè)計dameginNameex2ithdayept門osthonehoneMdress地址emarkDodsNameumptName庫it位ime間RemarkName公司名稱irect公司負責人Phone公司電話Fax公司傳真ddress公司地址markDDmricesNeedPriceTimetName倉庫markDDs模塊panyInfocs改添加刪除銷售商信息ataBackcs份ataReolecs原Infocs改添加刪除員工信息indGoodcs物信息onYingShangcs信息oodIDcs稱hGoodsInfocscGoodFindcs件cGoodscs存信息及設(shè)置警報數(shù)量incsaincs界面ellGoodInfocs息ellGoodscs修改添加刪除商品銷售信息hGoodsInfocs改添加刪除商品銷售信息Programcs主入口點細設(shè)計添加入庫信息的實現(xiàn)添加入庫信息設(shè)計：進入主界面后，點擊【進貨管理】----【商品進貨信息】即可打開添加入庫界面。下面給出完成添加功能的關(guān)鍵代碼：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;}存查詢類的實現(xiàn)庫存查詢界面：界面。的空白區(qū)域。完成庫存查詢功能的核心代碼：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){}}}設(shè)計主界面：菜單欄、工作區(qū)、狀態(tài)欄等。功能界面：全部為主界面的子界面，并完成相互獨立的功能。及功能概述2.1登陸界面：程面；如果賬號或密碼錯誤則會彈出錯誤提示，要求用戶重新輸入。2.2用戶主界面：2.3添加用戶界面：2.4商品退貨界面：2.5商品銷售信息界面：2.6商品庫存界面：2.7供應(yīng)商信息界面：業(yè)開始應(yīng)用計算機來增強管理，提高效益。計算機軟件作為計算機系統(tǒng)的兩大組成部分之一，看起來更接近普通用戶；戶，人們總是更傾向于使用一個操作方便的軟件系統(tǒng)。求，再設(shè)計一個相對方便操作的用戶界面。在這兩個方面集成開發(fā)環(huán)境(IDE)的作用顯得十分突出，MicrosoftVisualStudio2005是一套非常強大的開發(fā)套件，利用它可以快速的開發(fā)出界面友好，功能強大的軟件系統(tǒng)。戶查詢等操作，且系統(tǒng)運行比較穩(wěn)定。個過程中我也學(xué)到了很多東西，對C#，數(shù)據(jù)庫都有了更深入的理解，可以較熟練地使用VS2005開發(fā)軟件，也增強了分析問題、解決問題的能力，總的來說這次畢業(yè)設(shè)計使我受益頗多。謝辭在論文完成之際，向我的老師王強老師表示深深的敬意！好多知識，學(xué)會了能夠透徹的分析問題解決問題的能力。決問題和處理問題的能力，為我在今后的工作和生活中打下了基礎(chǔ)。附錄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輸入數(shù)字");dledtrue}}privatevoidtxtGoodsNum_KeyPress(objectsender,KeyPressEventArgse){ifeKeyChar8&&!char.IsDigit(e.KeyChar)){MessageBoxShow輸入數(shù)字");dledtrue}}privatevoidtxtGoodsJhPrice_KeyPress(objectsender,KeyPressEventArgs{ifeKeyChar8&&!char.IsDigit(e.KeyChar)&&e.KeyChar!='.'){MessageBoxShow輸入數(shù)字");dledtrue}}privatevoidtxtGoodsNoPrice_KeyPress(objectsender,KeyPressEventArgs{ifeKeyChar8&&!char.IsDigit(e.KeyChar)&&e.KeyChar!='.'){MessageBoxShow輸入數(shù)字");dledtrue}}/供應(yīng)商信息privatevoidbutton1_Click(objectsender,EventArgse){mGonYingShangfrmgo