語(yǔ)言程序設(shè)計(jì)庫(kù)存管理系統(tǒng)

目錄緒 課題背 目錄緒 課題背 需求分 需求陳 業(yè)務(wù)流 系統(tǒng)設(shè) 系統(tǒng)實(shí) 系統(tǒng)首 系統(tǒng)功 用戶(hù)登 出入庫(kù)模 入庫(kù)功 出庫(kù)功 4.5公用類(lèi) 234結(jié) 1隨著我國(guó)經(jīng)濟(jì)的飛速發(fā)展，各種類(lèi)型規(guī)模的公司企業(yè)迅速崛起，許多從事生產(chǎn)和經(jīng)營(yíng)管理的企業(yè)都有自己生產(chǎn)的銷(xiāo)售的產(chǎn)品，而這些產(chǎn)品都要儲(chǔ)存在倉(cāng)庫(kù)中，對(duì)于每個(gè)企業(yè)來(lái)現(xiàn)在國(guó)內(nèi)外對(duì)于此類(lèi)系統(tǒng)的開(kāi)發(fā)與研究也是很有實(shí)用性的，基本上能滿足各企業(yè)自身特點(diǎn)，來(lái)進(jìn)行倉(cāng)庫(kù)方面的管理。同時(shí)，該類(lèi)系統(tǒng)又都在不斷地深入與發(fā)展，來(lái)適用更多的1隨著我國(guó)經(jīng)濟(jì)的飛速發(fā)展，各種類(lèi)型規(guī)模的公司企業(yè)迅速崛起，許多從事生產(chǎn)和經(jīng)營(yíng)管理的企業(yè)都有自己生產(chǎn)的銷(xiāo)售的產(chǎn)品，而這些產(chǎn)品都要儲(chǔ)存在倉(cāng)庫(kù)中，對(duì)于每個(gè)企業(yè)來(lái)現(xiàn)在國(guó)內(nèi)外對(duì)于此類(lèi)系統(tǒng)的開(kāi)發(fā)與研究也是很有實(shí)用性的，基本上能滿足各企業(yè)自身特點(diǎn)，來(lái)進(jìn)行倉(cāng)庫(kù)方面的管理。同時(shí)，該類(lèi)系統(tǒng)又都在不斷地深入與發(fā)展，來(lái)適用更多的圖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("確認(rèn)入庫(kù)？",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編號(hào),GoodsNameas+"StoreNameas倉(cāng)庫(kù)名稱(chēng),PrNameas供應(yīng)商名稱(chēng),GoodsSpec+"GoodsUnitas計(jì)量單位,GoodsNumas入庫(kù)數(shù)量,GoodsPrice+進(jìn)貨總金額 期,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{}}}擊出庫(kù)，將會(huì)自動(dòng)生成出庫(kù)記錄。出庫(kù)的信息會(huì)影響到倉(cāng)庫(kù)內(nèi)貨物的信擊出庫(kù)，將會(huì)自動(dòng)生成出庫(kù)記錄。出庫(kù)的信息會(huì)影響到倉(cāng)庫(kù)內(nèi)貨物的信usingnamespace庫(kù)存管理系統(tǒng){publicpartialclassfrmOutStorageManage:{{intGoodsID;now=}usingnamespace庫(kù)存管理系統(tǒng){publicpartialclassfrmOutStorageManage:{{intGoodsID;now=}EventArgsprivatevoidbtnReturn_Click(object{frmMainfMain=newfrmMain();}privatevoidfrmOutStorageManage_Load(objectsender,{SqlConnectionconn=newconn.ConnectionStringSqlDataAdapterda=newSqlDataAdapter("selectOSIDas編號(hào),GoodsIDas貨物編號(hào),StoreName倉(cāng)庫(kù)名稱(chēng),"+"GoodsNameas貨物名稱(chēng),GoodsSpec,GoodsPrice期,PGProvider,GoodsUnitas計(jì)量單位,"+"GoodsNumas出庫(kù)數(shù)價(jià)格,GoodsAPriceas總金額,"+"OSDateas出庫(kù)日提貨單位,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+規(guī)格,GoodsUnitas進(jìn)貨價(jià)+"GoodsNumasSqlDataAdapterda=newas,StoreNameas+規(guī)格,GoodsUnitas進(jìn)貨價(jià)+"GoodsNumas出庫(kù)數(shù)量,GoodsInprice格,GoodsOutPriceas+"fromtb_GoodsInfowhereGoodsIDliketxtQueryString.Text.Trim()+"%'",conn);DataSetds=newda.Fill(ds,"tb_GoodsInfo");dataGridView1.DataSource=}if(cboxQueryTerm.Text.Trim(){SqlConnectionconn=newSqlConnection();'%"=SqlDataAdapterda=as,StoreNameas+規(guī)格,GoodsUnitas進(jìn)貨價(jià)+"GoodsNumas出庫(kù)數(shù)量,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+貨物名稱(chēng) 規(guī)格,GoodsUnitas進(jìn)貨價(jià)+"GoodsNumas出庫(kù)數(shù)量,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編號(hào),StoreNameas倉(cāng)庫(kù)名稱(chēng),"+"GoodsNameas貨