语言程序设计库存管理系统

目录绪 课题背 目录绪 课题背 需求分 需求陈 业务流 系统设 系统实 系统首 系统功 用户登 出入库模 入库功 出库功 4.5公用类 234结 1随着我国经济的飞速发展，各种类型规模的公司企业迅速崛起，许多从事生产和经营管理的企业都有自己生产的销售的产品，而这些产品都要储存在仓库中，对于每个企业来现在国内外对于此类系统的开发与研究也是很有实用性的，基本上能满足各企业自身特点，来进行仓库方面的管理。同时，该类系统又都在不断地深入与发展，来适用更多的1随着我国经济的飞速发展，各种类型规模的公司企业迅速崛起，许多从事生产和经营管理的企业都有自己生产的销售的产品，而这些产品都要储存在仓库中，对于每个企业来现在国内外对于此类系统的开发与研究也是很有实用性的，基本上能满足各企业自身特点，来进行仓库方面的管理。同时，该类系统又都在不断地深入与发展，来适用更多的图123451234567891234123451234567891234123456781234567891234567812345678944usingnamespace{publicpartialclass{:publicusingnamespace{publicpartialclass{:public{}sender,EventArgsprivatevoid{}privatevoidbtnReturn_Click(objectsender,EventArgs{frmLoginfLogin=newfrmLogin();}privatevoidbtnUpdatePwd_Click(objectsender,{frmUpdatePwdfUpdatePwd=newfUpdatePwd.UserName=this.UserName;fUpdatePwd.UserPwd=this.UserPwd;}privatevoidbtnUpdateRight_Click(objectsender,EventArgs{frmUpdateRightfUpdatePwd.UserName=this.UserName;fUpdatePwd.UserPwd=this.UserPwd;}privatevoidbtnUpdateRight_Click(objectsender,EventArgs{frmUpdateRightfUpdateRight=new}privatevoidbtnInSM_Click(objectsender,EventArgs{frmInStorageManagefInStorageManage=newfrmInStorageManage();}privatevoidbtnAboutUs_Click(objectsender,EventArgs{frmAboutUsfAboutUs=newfrmAboutUs();}privatevoidbtnOutSM_Click(objectsender,EventArgs{frmOutStorageManagefOutStorageManage=newfrmOutStorageManage();}privatevoidbutton9_Click(objectsender,EventArgs{frmUserManagefUserManage=newfrmUserManage();}privatevoidbutton13_Click(objectsender,EventArgs{frmQueryGoodsInfoprivatevoidbutton9_Click(objectsender,EventArgs{frmUserManagefUserManage=newfrmUserManage();}privatevoidbutton13_Click(objectsender,EventArgs{frmQueryGoodsInfofQueryGoodsInfo=newfrmQueryGoodsInfo();}privatevoidbtnQueryIS_Click(objectsender,{=}privatevoidbtnQueryOS_Click(objectsender,{=}}}namespace{publicpartialclassfrmLogin:{publicnamespace{publicpartialclassfrmLogin:{public{}privatevoidbtnLogin_Click(object{if(txtUserName.Text.Trim()=={}if(txtUserPwd.Text.Trim()=={}DBConnectdb=newstringQuery="select*fromSMUser+"SMUserName='"+"+"'andSMUserPwd='"+txtUserPwd.Text+SqlDataReaderdr={MessageBox.ShowstringQuery1="selectSMUserRightfromSMUserwhere+"SMUserName='"+"'andSMUserPwd='"+txtUserPwd.Text+SqlDataReaderdr={MessageBox.ShowstringQuery1="selectSMUserRightfromSMUserwhere+"SMUserName='"+txtUserName.Text+"'";SqlDataReaderdr1=db.MyQuery(Query1);{if(dr1["SMUserRight"].ToString().Trim(){Main.frmMainfMain=newMain.frmMain();fMain.UserName=txtUserName.Text;fMain.UserPwd=txtUserPwd.Text;}{MessageBox.Show}}}{MessageBox.Show}}privatevoid{}}privatevoid{}}}4.3namespace{class:publicnamespace{class:public{intintdecimalGIPrice;decimalnow={}EventArgsprivatevoidbtnReturn_Click(object{frmMainfMain=newfrmMain();}privatevoidtxtGIPrice_TextChanged(object{{}privatevoidtxtGIPrice_TextChanged(object{{}catch(Exception{=*MessageBox.Show(ex.Message,"警告",MessageBoxButtons.OK,}}privatevoidbtnIn_Click(objectsender,{if(txtISGID.Text.Trim()=={}if(txtISGName.Text.Trim()=={}if(cboxSName.Text.Trim()=={if(txtPName.Text.Trim()==}{if(txtGSpec.Text.Trim()==}{MessageBox.Show(if(txtGUnit.Text.Trim()==if(txtPName.Text.Trim()==}{if(txtGSpec.Text.Trim()==}{MessageBox.Show(if(txtGUnit.Text.Trim()==}{MessageBox.Show(if(txtISGNum.Text.Trim()==}{if(txtGIPrice.Text.Trim()==}{if(txtHPeople.Text.Trim()==}{}GoodsID=GoodsNum=GIPrice=GSPricedb=newstringQuery="select*fromtb_InStorewhere+txtISGID.Text+"'";SqlDataReaderdr=}GoodsID=GoodsNum=GIPrice=GSPricedb=newstringQuery="select*fromtb_InStorewhere+txtISGID.Text+"'";SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){=++"values("+GoodsID+",'"+txtISGName.Text.Trim()++cboxSName.Text.Trim()+"','"+txtPName.Text.Trim()+"','"+txtGSpec.Text.Trim()+"','"+txtGUnit.Text.Trim()+"',"+GoodsNum+","+","+GSPrice++now"','"txtHPeople.Text.Trim()"+txtISRemark.Text.Trim()+DBConnectdb1=newDialogResultresultMessageBox.Show("确认入库？",if(result=={stringQuery1=*fromtb_GoodsInfoGoodsID="++"andGoodsName='"StoreName='"+cboxSName.Text.Trim()+"'andGoodsSpec='"andGoodsUnit='"+txtGUnit.Text.Trim()+"'";+txtISGName.TextstringQuery1=*fromtb_GoodsInfoGoodsID="++"andGoodsName='"StoreName='"+cboxSName.Text.Trim()+"'andGoodsSpec='"andGoodsUnit='"+txtGUnit.Text.Trim()+"'";+txtISGName.Text+"'+txtGSpec.Text.Trim()+SqlDataReaderdr1=if{=+values("+GoodsID+",'"+txtISGName.Text.Trim()+"+cboxSName.Text.Trim()+"','"++"','"+txtGUnit.Text.Trim()+"null++GoodsNum+","+GIPrice+",'"+}{=GoodsNum=GoodsNum+OldNum;stringUpdateGoodsNum=GoodsNum="++"whereGoodsID="++"andGoodsName='"+txtISGName.Text+"'StoreName='"+cboxSName.Text.Trim()+"'andGoodsSpec='"+txtGSpec.Text.Trim()+andGoodsUnit='"+txtGUnit.Text.Trim()+"'";}MessageBox.Show}{}}}privatevoidfrmInStorageManage_Load(objectsender,EventArgs{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBConnect.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectGoodsID}{}}}privatevoidfrmInStorageManage_Load(objectsender,EventArgs{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBConnect.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectGoodsIDas编号,GoodsNameas+"StoreNameas仓库名称,PrNameas供应商名称,GoodsSpec+"GoodsUnitas计量单位,GoodsNumas入库数量,GoodsPrice+进货总金额 期,HandlePeopleas"ISRemarkasfromtb_InStoreconn);DataSetds=newDataSet();da.Fill(ds,"tb_InStore");dgvISManage.DataSource=ds.Tables[0];}privatevoidbtnDel_Click(objectsender,EventArgs{DBConnectdb=newstringQuery="select*fromtb_InStorewhere+txtISGID.Text+SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){DialogResultresultMessageBox.Show("是否删除该条记录的信息？","提示",MessageBoxButtons.YesNo,==if{=+SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){DialogResultresultMessageBox.Show("是否删除该条记录的信息？","提示",MessageBoxButtons.YesNo,==if{=+dgvISManage.CurrentCell.RowIndex].Value).Trim()+frmInStorageManage_Load(sender,}{}}{MessageBox.Show}}DataGridViewCellEventArgs{===========}EventArgsprivatevoidgroupBox1_Enter(object=========}EventArgsprivatevoidgroupBox1_Enter(object{}}}击出库，将会自动生成出库记录。出库的信息会影响到仓库内货物的信击出库，将会自动生成出库记录。出库的信息会影响到仓库内货物的信usingnamespace库存管理系统{publicpartialclassfrmOutStorageManage:{{intGoodsID;now=}usingnamespace库存管理系统{publicpartialclassfrmOutStorageManage:{{intGoodsID;now=}EventArgsprivatevoidbtnReturn_Click(object{frmMainfMain=newfrmMain();}privatevoidfrmOutStorageManage_Load(objectsender,{SqlConnectionconn=newconn.ConnectionStringSqlDataAdapterda=newSqlDataAdapter("selectOSIDas编号,GoodsIDas货物编号,StoreName仓库名称,"+"GoodsNameas货物名称,GoodsSpec,GoodsPrice期,PGProvider,GoodsUnitas计量单位,"+"GoodsNumas出库数价格,GoodsAPriceas总金额,"+"OSDateas出库日提货单位,PGPeopleas提货人,"+"OSRemarkas备注tb_OutStore",DataSetds=newda.Fill(ds,dgvOSManage.DataSource=SqlCommandcmd=cmd.Connectionnew=tb_GoodsInfoSqlDataReaderdrwhile{=}}DataGridViewCellEventArgs{====da.Fill(ds,dgvOSManage.DataSource=SqlCommandcmd=cmd.Connectionnew=tb_GoodsInfoSqlDataReaderdrwhile{=}}DataGridViewCellEventArgs{===========}{DBConnectdb=new=}{DBConnectdb=newDBConnect();stringQuery="selectdistinctGoodsNamefrom"+"whereStoreName='"+cboxSName.Text.Trim()+"'";SqlDataReaderdr=db.MyQuery(Query);while{}}{combboxItemDBConnectdb=newstringQuery="selectdistinctGoodsSpec,GoodsUnit,GoodsIDfromtb_GoodsInfo"+"whereStoreName='"++"'andGoodsName='"+cboxGName.Text.Trim()+"'";SqlDataReaderdr=db.MyQuery(Query);while{}}privatevoidbtnDel_Click(objectsender,EventArgs{DBConnectdbnew"select*fromtb_OutStorewhere{}}privatevoidbtnDel_Click(objectsender,EventArgs{DBConnectdbnew"select*fromtb_OutStorewhere=string+dgvOSManage.CurrentCell.RowIndex].Value).Trim()+"'";SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){DialogResultresultMessageBox.Show("是否删除该条记录的信息？","提示",MessageBoxButtons.YesNo,==if{stringnonQuery="deletefromtb_OutStore+dgvOSManage.CurrentCell.RowIndex].Value).Trim()+}{}}{MessageBox.Show}}privatevoidbtnOut_Click(objectsender,{{(cboxSName.Text.Trim()==MessageBox.Show}{(cboxGName.Text.Trim()=={MessageBox.Show}}privatevoidbtnOut_Click(objectsender,{{(cboxSName.Text.Trim()==MessageBox.Show}{(cboxGName.Text.Trim()==MessageBox.Show}{(cboxGSpec.Text.Trim()==MessageBox.Show}{(cboxGUnit.Text.Trim()==MessageBox.Show}{(txtOSGNum.Text.Trim()==MessageBox.Show}(txtOSPeople.Text.Trim()=={MessageBox.Show}{(txtOSUnit.Text.Trim()==MessageBox.Show(}{(cboxOSGID.Text.Trim()==MessageBox.Show(}DBConnectdb=newstringQuery="selectGoodsNumfrom{MessageBox.Show}{(txtOSUnit.Text.Trim()==MessageBox.Show(}{(cboxOSGID.Text.Trim()==MessageBox.Show(}DBConnectdb=newstringQuery="selectGoodsNumfrom"+"whereStoreName='"+cboxSName.Text.Trim()+and+cboxGName.Text.Trim()+"'andGoodsSpec='"+"'andGoodsID="++SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){>{MessageBox.Show}{=++"values('"+++++++cboxGUnit.Text.Trim()++txtGOPrice.Text.Trim()++++++txtOSPeople.Text.Trim()++txtGSPrice.Text.Trim()++++now+"','"+txtOSRemark.Text.Trim()+"')";DBConnectdb1=new++"values('"+++++++cboxGUnit.Text.Trim()++txtGOPrice.Text.Trim()++++++txtOSPeople.Text.Trim()++txtGSPrice.Text.Trim()++++now+"','"+txtOSRemark.Text.Trim()+"')";DBConnectdb1=newstringQuery1="select*fromtb_GoodsInfo++++"'andGoodsSpec='"++++Convert.ToInt32(cboxOSGID.Text.Trim())+SqlDataReaderdr1=db1.MyQuery(Query1);if(dr1.Read()){==GoodsNum=-=GoodsOutPrice="+Convert.ToDecimal(txtGOPrice.Text.Trim())"whereGoodsName='"+cboxGName.Text.Trim()"'andStoreName='"+cboxSName.Text.Trim()+"'andGoodsSpec='"+"'andGoodsUnit='"+++++Convert.ToInt32(cboxOSGID.Text.Trim())+"whereGoodsName='"+cboxGName.Text.Trim()"'andStoreName='"+cboxSName.Text.Trim()+"'andGoodsSpec='"+"'andGoodsUnit='"+++++Convert.ToInt32(cboxOSGID.Text.Trim())+stringsetGoodsNum="updatetb_GoodsInfoGoodsNum="++"whereGoodsName='"+cboxGName.Text.Trim()+"'andGoodsSpec='"++"'andStoreName='"+"'andGoodsUnit='"++Convert.ToInt32(cboxOSGID.Text.Trim())+}{}}}}privatevoidtxtGOPrice_TextChanged(object{{}=catch(Exception{"警告}}}catch(Exception{"警告}}}}namespace{publicpartialclassnamespace{publicpartialclass{public{}:EventArgsprivatevoid{if{==frmQueryGoodsInfo_Load(sender,}{if(cboxQueryTerm.Text.Trim(){SqlConnectionconn=newSqlConnection();=SqlDataAdapterda=newas,StoreNameas+规格,GoodsUnitas进货价+"GoodsNumasSqlDataAdapterda=newas,StoreNameas+规格,GoodsUnitas进货价+"GoodsNumas出库数量,GoodsInprice格,GoodsOutPriceas+"fromtb_GoodsInfowhereGoodsIDliketxtQueryString.Text.Trim()+"%'",conn);DataSetds=newda.Fill(ds,"tb_GoodsInfo");dataGridView1.DataSource=}if(cboxQueryTerm.Text.Trim(){SqlConnectionconn=newSqlConnection();'%"=SqlDataAdapterda=as,StoreNameas+规格,GoodsUnitas进货价+"GoodsNumas出库数量,GoodsInprice格,GoodsOutPriceas+"fromtb_GoodsInfowhereGoodsNameliketxtQueryString.Text.Trim()+"%'",conn);DataSetds=newDataSet();da.Fill(ds,dataGridView1.DataSource=}if(cboxQueryTerm.Text.Trim(){SqlConnectionconn=newSqlConnection();'%"=SqlDataAdapterda=newas,StoreNameas+货物名SqlDataAdapterda=newas,StoreNameas+货物名称 规格,GoodsUnitas进货价+"GoodsNumas出库数量,GoodsInprice格,GoodsOutPriceas+"fromtb_GoodsInfowhereStoreNamelike'%"+txtQueryString.Text.Trim()+"%'",conn);DataSetds=newda.Fill(ds,"tb_GoodsInfo");dataGridView1.DataSource=ds.Tables[0];}}}privatevoidfrmQueryGoodsInfo_Load(objectsender,EventArgs{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBConnect.getConnectionString();SqlDataAdapterdanewSqlDataAdapter("selectGoodsIDas编号,StoreNameas仓库名称,"+"GoodsNameas货