仓库管理系统代码精品资料.doc

ϵͳÖ÷½çÃ棨rmMai.cs£©uin Systm;usi Sytem。Colletns.Generic;ung Syste.Componentodel;usinytemat;singtm.Dawig；snSyste。Text;usn Systm。Windos。ors;uingSyte.Dagnosts;nmespace reousepubic partal lass rmMain ： FublicfrmMain（）Iniializeompoen()；iae oi frain_Load(bjectsender, EnArg）tsslsr。et = ”²Ù×÷Óû§È¨ÏÞ£º" fmon.M_strrigh.ToSting（).rm（）；ssla.ext =DtTime.TdaToLongDteing()；tsslTim。Tt ”µÇ¼ϵͳʱ¼ä£º + DateTimeNow.ToShortimeStrng()；i (mLoginM_str_right.ToStrng（)Tim(）= "ÆÕͨÓû§”)Èë¿â¹ÜÀíTolStriMnIem。abled= fase；³ö¿â¹ÜÀíoStipMenItem.Enabled fae；½è»õ»¹»õTotipMenuItem。be = false;¹©»õÉÌÉèÖÃooltripMnuItemnabd = fale;»õÎïµµ°¸ÉèÖÃToolStripMeuItemEled = false；²Ö¿âÉèÖÃTooltripMeuIte。ned = fale;ȨÏÞÉèÖÃToolStripMenIm.Ebled = fase;Óû§¹ÜÀíolStrenuItem。nbled = false；btnS。Enabed= flse；tnOS。Enbled= fas；btnBREnabld = fase；tnPI。nbled =as；tG。Enable fas；bnI。nabled = flse;btnRI。Enbld lse；btUM。Enabld= fa；riv vibtISCli(obje send,venArgs e)/Èë¿â¹ÜÀíooManagefrmISMaage Mfis newwhoseGodsManage.rmISManage（)；/MisSow（）;GMs.hoialog(）;ÕâÁ½¸öº¯Êý¾Í¿´Ë.»ñµÃ½¹µã£¬Ç°Õ߸¸´°¿ÚÒ²¿É»ñµÃ½¹µã£¬ºóÕßÖ»ÓÐд´½¨µÄ´°Ìåpivte voi btOS_Cli(objetsene， EventArge)/³ö¿â¹ÜÀíGoodsManefrmOSMang GMfosm = wreue。GoMage。rmOSManage(）；GMosm.ShoDialog（）；rivatevi tnBR_lc（oject sender， Evntrgs e）/½è»õ»¹»õ¹ÜÀíGoodsMange。frmBGane GMfbgm= nearehuseGodsManae。rmBGMane(）；Gfbm。owDg()；rivate i btnPI_lic（object snder, EentArgs）/¹©Ó¦ÉÌÉèÖÃBasicorPrf BIp =ew warehoueaicInfo.frmPrIno（)；BIfp.ShowDialo（);private vid nG_lic（obe ede，vntgs e）/»õÎïµµ°¸ÉèÖÃBasicnf。rGoosn BIi new warhouse。BasicInf。fGodsInfo（）;BIi.ShwDialg（);priv voidbtnSI_Cick(oject eder,EnArgs e)²Ö¿âÉèÖÃBasinf.frmStoIno Bi ne warehouseBasicInfofmStoreno（)；BIfsi.ShowDiaog();rivat oid btnSL_Click（bet seer， ventArgs e）/Èë¿â²éѯookndSu。frmISLoo Sisl = nearehuse。LokandSum。frmSLook（）；SfislShoDialg（）；piateod btSL_lic（objec sender，EvetAgs ）/¿â´æ²éѯLookandSu。frmILook Sil w waseokandSum.frLok（)；LSfgilhowDialg（);rvaevoidbtnGOL_Clik(ojectsenr， EventAre）/»õÎï½è³ö²éѯLokanum。frmBGoo Sfbg = ne wrehouse.ooandSu。rmBGLook();Sfbl.SowDialog（）；private vid btnGIL_Clck（objct se， Eventrg ）/»õÎï¹é»¹²éѯoknfrmRGLok Srgl = new wrehousookandSum.rRok（）；Sfrgl.Showalog(）；prt voidbtOSL_Cck（oject send， EvenArgs ）/³ö¿â²éѯLokandSum。fmOSLook LSfosl = new areouse。LooknSu。frmOSook（）；LSosl。ShowDilog(）;privat vod btnEP_lck(bj sedr， EvenAgs e）/¸ü¸ÄÃÜÂëStemSet。rmditPwd HPfe =w waeoue。SyemSet。frmEitPwd（);Hfe。Sowlg（）；privatevoibtnRI_lick（bectsender， EventArgs e）/ȨÏÞ¹ÜÀíSystemSetrmitMang Hfrm nw waeouseSystmet.frRghtMnage();P.howDlog（);pivate voi tnM_Clc（objct nder, EentArgs )/Óû§¹ÜÀíSysmSe。rmUseMna Hfm = ew warehouSstmSet。fmUsrManage(）;HPum。ShowDilg(）；rivtevod bnAU_Clck(bjetsnder， ventrg e)/¹ØÓÚ±¾ÏµÍ³Ssemet.frAbutU HPfu new wrh.SysmStfmAboutU（)；HPau.ShwDiag()；privatevoitnCH_li（objec sender， ventge）if （MessageBox.Show（"ÄãÕæµÄҪעÏúµ±Ç°Óû§"，Ìáʾ，esaeBotos.OKCancel， MessaeBoIcon.Inforat）= DialogResult。OK）warehoue。frLogn frlogin = newfrmoin（）；thisHde（）;rmlogn.Show（)；rite vid btnEClc(bec eder， Evetgse）/Í˳öϵͳis。Clos（)；/>Applition.Exi（）;prvt vi Main_FormClosd(oject sender，FormCosdEvetArs ）if (MesseBox。Shw(”ÄúÕæµÄÒªÍ˳ö±¾ÏµÍ³Âð£¿"， Ìáʾ"， MeaeoxButnsOKCancl， esgeBoIoIforatin）= DialgResul。OK）Aplicaton。Eit（）；elefmMn fmain = nw frMain（)；main。Shw(）；pivt oi Èë¿â¹ÜÀíToolStipnuItemCck（bject seder, EvtArse)btnIS_ick（ser, e);pvate vod ³ö¿â¹ÜÀíToolSrienItemCick（objct snder， vntArgs e）btnS_Cick（sener，e)；pivate voi ½è»õ»¹»õTtrMnuIteCick（ojectnder， EvetArs ）bnBR_Ci（sende, e）；private void ¹©»õÉÌÉèÖÃToolStiMenuItem_Click(obje sder， etArgs e)btnPI_ck（snder，e）；prvate v »õÎïµµ°¸ÉèÖÃToStripenIte_Clk（bjct sende， EvnArs e）btGI_Click(sender， );prvat oid ²Ö¿âÉèÖÃToolStpMeutem_Click(object endr， vntArgse)btnSI_Clik（senr，e）;rivae voi ¿â´æ²éѯolStriMenutm_Clic（jectsendr， EventArs e)bSLic(sende,e）；pivateoid Èë¿â²éѯToolStrpMenuIt_Cic(jec seder， ventArgs e)btnSLClck(sende，e);pvte vid ³ö¿â²éѯToolSteuIem_Click(bjet sender， EvetArg）tnOSLClick(sender，）；private oid »õÎï½è³ö²éѯltripMenutemick（obcsendr， EventArge)btGOL_ik(sender， e)；rvte void»õÎï¹é»¹²éѯTooStriMenuIteCick(obje sender， Enrgs e)btnGL_Click（ender，e）；piae voi ¸ü¸ÄÃÜÂëToolStripMenuItm_Cick（obect sendr， EvnAgs e)btEP_Click（sde, e)；pivate vd ȨÏÞÉèÖÃToltripMenuem_Click（obje sende， EventArge）btn_Clck（sder， e);pivae void Óû§¹ÜÀíTolStrpMenuItem_lick(objcsender， EentAgs e）btM_Clck(sendr，e)；rivteoi¹ØÓÚ±¾ÏµÍ³TooripenIe_lik（object snde, EvetArg e)tnAClck(seder，e）；prvte vid »õÎï¹ÜÀíolripMenutemlick(obect sedr， Evenrgs e)tabCnro1.SlectedIndx= ；pivatev »ù±¾µµ°¸TolStrMnuItem_lick(ojt sende，EetArs e)tabntrol1SeltedIex 1；priate void ²éѯͳ¼ÆootMeuIte_Click(ojet snder, EentAgs )tbContrl1SelectedInex = ;rivat voidϵͳÉèÖÃToSiMenuIe_Cick（bect sener, EvetAs e）tabntl1。SelectedIndex；pivate vi ×¢ÏúooltriMenute_Clc（bet sender，Eventr e）tnC_Clc(ende， e）;ivatvoid Í˳öϵͳTolStrpMnuItem_Clck（bect seer，vntArgs e）btnExit_lic(seder， e);pate vid toolStripStsabe_Cic(ojetsender，entg e)SyseDiostics.ProcsSr（"tp:/wwrnrenl")；¡¡¡¡»õÎïµµ°¸¹ÜÀí£¨Èë¿â frmInMae。cs£©usin Sym；un Systm.Collctonnerc；sin ytm.omonetModel;using Sstem.Dat;sng ytem。Dawng;usin yste.x；ung SystmWiws。Forms；sng Stem。Daallient；amespae warehoue.GoodManaeubi partal clss mInge ： owarehoseBasClass。atCndatacon = newwarehos。BaeClss。Dato(）；arehouse。aseClass。ataOperae operate= new arehous。BasCas。DtOrate();puic rmIMnage（)IitilizCompnent（）；ivte oi ISanage_Lod（bjet sndr, EvntAgs e）dgvIMnge。Cono.Add(hScrolBar）;/Êý¾ÝÔ´¿Ø¼þÖÐÌí¼ÓÁËÒ»¸öˮƽ¹ö¶¯Ìõdprate。cbxBid（”selet torame fro Stoge， "tbStorage”， "Streame”， cboxSame)；²Ö¿âÃû×ÖÏÔʾ³öÀ´doperate.cboxBin（"slec Prame om tbPidr",”tbProvde”，Prame”, cxPame)；¼ÆÁ¿µ¥Î»ÏÔʾ³öÀ´DataSe mys dtacoges（seletIIDasÈë¿â±àºÅ,GoodsID as»õÎï±àºÅ，odNme as »õÎïÃû³Æ，Name s ¹©Ó¦ÉÌÃû³Æ,+ ”StreName a ²Ö¿âÃû³Æ,GdsSec as »õÎï¹æ¸ñ,Godsnt ¼ÆÁ¿µ¥Î»，GodNum aÈë¿âÊýÁ¿，+ ”GodsPe as »õÎïµ¥¼Û,GodsAPice a ×ܽð¶î，IDate Èë¿âÈÕÆÚ，HalePep as ¾­ÊÖ，"+ ”emark as ±¸×¢from t_InSore，”tbInSore”）；vSMange。DaaSource =myd.Tab；/dtstÖеĵÚÒ»¸ödattabe 0=”tbIStoe”privt vidtAdd_Cik（objt sener, venArs )if(ttISGD。ext ”)MesaeoxShw(”»õÎï±àºÅ²»ÄÜΪ¿Õ£¡”， ”ÐÅÏ¢"，MesageBxuttos。OK, MessgeBxcoIfomion)；i (txISGmeTxt=”）MeaeBx。So（"»õÎïÃû³Æ²»ÄÜΪ¿Õ", "ÐÅÏ¢"， MessagBoxButtons。O， MesaeBoxcn.Iormaion);if (txtIPrie。Text ”）MssagBox.Sho(”»õÎïµ¥¼Û²»ÄÜΪ¿Õ£¡， "ÐÅÏ¢"，MesageBoxButons。OK， saeBoIcn.nformti)；if（ttISGNm。et= "")gBx.Sho（Èë¿âÊýÁ¿²»ÄÜΪ¿Õ", ÐÅÏ¢",essaBoxButtns.OK， MseBoxIcon.Infatio）；if （txtGpec.Txt = "）essageBx.w("»õÎï¹æ¸ñ²»ÄÜΪ¿Õ,"ÐÅÏ¢”, essageBoxButos。K, essageBoIconInomaton）；if (txtHeople.Tet = ”"）ssagBox。Show（"¾.ÊÖ²»ÄÜΪ¿Õ”， "ÐÅÏ¢", MessageBouttons。OK，MessageBoIcon。Infrmatn)；elei PtreurVlue = doperae.InsertGoods（Conert.ToInt32(xtISGD.TextTri()）, ttISame。TexTrm(），cbxPName。Text。Tri（）, cboxSName。Text.Trim（），txtSpe.Tex.Trim(）, cbxGUnit。Txt。Tri（),onvrt。ToInt32（txtIGNum。Text。Tr（), ConverToDeimal（xtGi.Txt.Tim(）, ttHPople.Tx.Tim(）, tIRema.e。Trim(）);i （_intrturnalu= 100）MssageBx.Shw（¸Ã»õÎïºÅÒѾ。±»Õ¼Óã¡”， "ÐÅÏ¢"， MessgeBoxttonsOK,eBoxonfmation）;leif(_nt_eturnVal =200)MsgBoxShow(”ÕâÀà»õÎïÒѾ.´æÔÚΩһ±àºÅ£¡”, ”ÐÅÏ¢"，MessageBoxBtons.K，MeageBoIcon。Iormatio)；elseMessgBox。Show（"»õÎïÈë¿â³É¹¦£¡, ”ÐÅÏ¢"，MesaBxutons。OK, ssaeBoxconfomaton）；fmIMnag_Load（sender, e);ivate oidtD_Click(objectser， EentAgs e）/ try/ /ɾ³ýÏÂÃæÊý¾ÝÔ´¿Ø¼þÖеģ¬Ö¸Ê¾µÄÊý¾ÝÏîdaan。getcom（”deetero b_Intoe where ISID=+Convt.TStrng（dgvISManae， gvISMnaCrreCell.RowIndeVlu）Trim（) ”）；/Cnver.ToSing(dGrView11，dataGrdVe.urenCl.RoIndx.Valu）Trm(）;/ À´È¡µÃËùÑ¡ÖеÄÄÇÐÐÊý¾ÝijÁеÄÖµ。ssageBo。how("»õÎïɾ³ý³É¹¦£¡", "ÐÅÏ¢", MsageoxButonsOK, MesageoIcn.Information）；fmISManae_Ld(sender, );/catch （Exceptonex)/ MessBox.ho（eMesge， "¾¯¸æ，MsoBuo。OK，MesagooWanig)；/privat oi btnExit_lc（cendr, EvenArg ）this。lse（)；privae void dgvISMnaeCelClik（obect sender，DaGriViwCellntAr e)/dtagidview¿Ø¼þÓÐÒ»¸öCellickʼþÊǵ±µ¥»÷datagrivi¿Ø¼þµÄÈÎÒⲿ·ÖÊÇ·¢Éú。È»ºóÔÙÓà CovtToString（daaGidVie11，aaGridVw1Curretell。owIndexae).Trim（); À´È¡µÃËùÑ¡ÖеÄÄÇÐÐÊý¾ÝijÁеÄÖµ/ttISGI。et =onvert.oStng(dgvIanae1，gvISanageCrentellwInde.Vlue)。Trm（）;tISGName。Txt=Convert。TStrg（gSanag2， dISMnae.CurrentClowndx.Vae）。im（）；cboxSNae。ext =CnerTStrg(dgISanage4，dgvISManageCurretClRowIndex.Value)Tri()；boxPame。ext = Coet。ToSting（gvSna3， dgvISMnae。Curentll。owIndx。Vue）Tm(）;txGSpe.et = onvt.oString（dSMange5，dgvanage。CurentCel.RowIndex.Vaue）。Tim（);cxUi。Te =Coert。ToStrng（dgvISManag, vSaag.CrentCel.RwIdx.Value）。Ti(）;txSNu.Txt = Conert.ToSting(dvMage7，vISanage.CurrentCell.RwIndex。Vale）Trim（）；txtGPrie。Txt ConvrtTStrig（dgvng, dgSMae。urrntCellRowIndx。ae）。Trim（）;txGPrice。Text= Convrt.ToStrig（dgISMaa9, gISMaagerreCell。Rodex。Valu).Trim（）;txHopleTex = Convert.Toring（dgvISManage1, dgvISManage.Curnell。owIdexVale）.Trim（）;txSRmarkTextConverTString（dgvSange12， dgManae。Curetll.RoInex。Vale）。Tm(）;prive oi txtIPic_Tehnged（bject snder， EvenArgs）trytxGSric。xnvrtTStrng（Cver。Toi(txtGIPrce。exTrim(）) *ConvrtTont32(txtISGm。Tet.Trim（)）。r（)；/onert.Decil（txtGIieTet.Trm（）½«Îı¾Öµ×ªÎªDecimalÊýÖµ/½«Êý×ÖµÄÖ¸¶¨Strig ±íʾÐÎʽת»»ÎªµÈЧµÄecimal Êý×Ö¡£ctch（xex）MessaBox.Sow（x。Mesage， ”¾¯¸æ, MessageBoxButtons。O,MessageBoxIWanig)；prvate vod rmISanag_FormClos（objctsnder， omClosdEent e）tsClos(）；private id buttn1_Click(objec snr, EvnArgs e)tis。txtGIPriceText = "；thi。txGpc.ex= ”;thi。txtHeoe.Tet= ”"hi.ttISID。Text ”；t。txtISGNae.ext ="”;tis。tISGu。xt = ；thixIRemarTet ”；tisxGPriceTet ”;tis。txtSPrice.Tex =”；¡¡¡¡³ö¿â¹ÜÀí£¨frmsMnge.s£©usinSystem；usgstem。Collectios.Genric;sing SystemComonenModel;usng Systm。Data；uin Syste.rawin；usng ystemTet；uing yse.Windows.Fos；usi System。Data。Sqlliet；namespace warhose。Gooangpublicartial clasrmOSManage：rwahue。BaseCassDtaodac = ew wreouse.BaselasDtaCon（）；arehous。aseClas.Datpete oerate = new rehuBasCasDaaOperte（）;puic rmSange（)IitalzeComponn();rivat voidrmOSMage_Lad(ojec snder,ventrgs e)dgvOSnage.Controls。Ad(hScrolBar1）;dperte。cboxBind（"slec sinct Storeamrom tbnStoe"， ”tbInStore”, "Soreme"， cbxName）；DataSe ms= datacon.gets（”selet OSID s ³ö¿â±àºÅ，Storeme ²Ö¿âÃû³Æ，Godsame as »õÎïÃû³Æ,"+ ”GoodsSec s ¹æ¸ñ，GoodUi as ¼ÆÁ¿µ¥Î»,GoNum s ³ö¿âÊýÁ¿,GoodsPrce s ¼Û¸ñ,odsAric as ×ܽð¶î,”+ ”Ste a ³ö¿âÈÕÆÚ，PGPovid as Ìá»õµ¥Î»，PPeopleas Ìá»õ,"+ ”anleople s ¾。ÊÖ，OSRr a ±¸×¢frm tbOutSor，"tbOtStore”)；dvOMangeDtaSorce myTablest_OutStore"pratvoid bAd_Cli(ojct endr, EventArg )trylDataReader sqlread = datacon。geead（”seect GoosNm ro b_GoosInfo"+ werorNae=" + cboxSName.ext.Trim（） + "and Godsame=+ coxGNme.T。Trim（) + "' and Godpc" + cboxGSc。Tx。Trim（) ")；if （sqlread。Red（）)if (Convet.ToInt32（ttOSGNum。xt.Tim(）)>ConvrTInt2（sqead"GodsNum.Totring（)Trim（）)MessgBoxShw(²Ö¿âÖÐûÓÐ×ã¹»µÄ»õÎ，Ìáʾ",MessageButtons.OK， MessageBoIco。Inrmation)；esedatcon.geom（"ietio tbOuSt（SoeName,Gosame，GodsSpe，Gooit，” +GodsNum，Godsrie,PGPovider，PGPeple，HandePopl,OSerk）"+ values（ + cboxName.TextTr(） +”,”+ cboxGNameTetTri（) + ”', + cGSpec。xt.ri(）+ ",” + boUnitet。Trm() + ',” txtOSGNu。Txt。Trim(） ”，” + xtGOPice.ext。Trim() + ”，" + ttOUi。TextTim() + ,'” +txtOSPole.ext.Trim() +”， xtHPeople.Text.Ti() ，'” ttOSmark。Text.Trim（） + ')）; MessgeBo。Show（"»õÎï³ö¿â³É¹¦£¡”，"ÐÅÏ¢”, MssgBoxBtton。OK,MesgeBoxIcon.Iforto）；f