C#商品管理系统(非完整版)

某鞋柜专卖店需要一个系统方便管理，其主体功能是，实现入库和定单的管理操作，请依据需求设计数据库，并完成系统制作.一.系统需要登陆才能访问.二.用户可以修改自己的用户名和密码.二、用户可以添加删除和修改入库信息（编号，货物名，进货价，销售价，颜色、号码、样式（男、女）、图片）三、货物统计查询（依据颜色、号码，样式查询，并能统计库存数量）四、添加销售记录（定单号、定单日期，定单明细（定单号、编号）五、修改定单记录主界面用尸期亲益营理订单管理账F管理登陆后的界面茶装主窠单用户登陆系筑管理箱吉管理订单管受8k户曾立|登间1 5:39中订于整a 33圜国尚曲画画宜曲1J 望P一二卜 2v卜 - Liffi: E IsM=r !: -r :.s: s.: s.!.r:is:蒯明华登阮|系统晡间：2009-9-19:35:10rroperties.引用ch孙静F”工即cnrdctCistwt.5tp5M亚.CECsil.CMGlobilLIiifci.c工inEhop.cscsMlnfronvIrocramcsXi崎专ifhop.亡苫数据设计用到了4个数据库:日UJ5Itop国Q数据库关系图臼Jl表1一i系统表田口此口.diRgdan一；此。.dingdaiuiingxi国1d,boimhop可_i-ibo.userinfo订单表:-珈S|数据类型允i百IIDnvairchdn(5a)二timedahAkneP1rJ订单明细表:列名数据类型允许空!idingdsnlDnvarh3r(5Q)FbhnhaoFi小初(10)*countint17r入库表:列名数据类型|_允许五idnvanchar(50)namenv3rchar(50)inpricfistutprit日Floatcolornvarch-ir(SO)sizeirdtyangsinvarchar(SO)ifnaqenYarchar(50)COUTitirit用户表:-l列名数席类型允讦至userIDmtrusernamen7arctiar(50)r(MssiAcrdnarchar(50)rr公共的方法和属性:publlcvoldiMcnTrueCJithis,系统量味ToolStripMsniiltwiii.Enabled二Ithie.练登陆TblStripM色null自e.Eniblei：thH.而疝订货单ToolStripM电milt也hlEnabled=!ihis.JOuTMTcolStripMtnuIten.Intbled：thiE悔改讨贷章TMlftripM电miTtaiLEnL虱=!this.修改仃货章【力白1总3昨眼讪1丘小口吐1哂thi三.露加鞘售记录TonlStjripHmuTtm_的1曲1=!thj三一添加揩售记录7口015七1忤2011：01S1.扈113112击thi三.查岩产brTocltripMemillam.En.ablal=!this.香告产品T&m，MwuItE.Eitabled.;thi三，修改tT单记录1。15次1训wnultw.Enabled=!thim.哆板订单记录TooLEtripM栏unit也Enabled：this,修改密向IglStripM6miltarn.Enabled=!*hiz.修改变码ToclStripMemiltsri.Enabled;this.AoclStripMemiltem.Enabled=!thiI植售管理TaolStripMenuI-ten.Enabled;this,订单管理ToolStrrpMmilteni.Enabled=!thiI订单管理TooLStripM亡nullem.Enabled;this,账户君理ToolStripMemilt&m.Enabled=!this,/ToolStripMwnuLtEi.Enablgd;this,注销系妩T。工StripMermltirrEnable(1=!thi耳在窄耳系统ToGS七门pMwmiltavEnitled：this,素统管拽ToelStripM0mliEnable4二Ithie.MJtToolStripMsnuIl.&fii.EnableA;，/JEujnmairy/改变“下一条”“上一条”/K/sujimaryprivate701dCkaieslateI.J/bindiBLgif(this,binding.Position=this.binding.Count_1)/最后-条1this.btiJilewt-Eik&ll&d-0=白：IelsethisBbtnBfextHEiiEbled=true;if(thie.binding.F&sition=0)i_thiw.btrFri.Enabled=tIthii.btiiFriEnabled=truw:；illhi,bindin$.Pofition=-1)I“his,bt逆片器，En4tL，I二近二片，thie.binPriEnal-led=/swm诃/in实现“下一条”上一条/Q55小arf/parainRame-sender/如aramname=e1Tparantprib&tavoidbtrffeitClick(bjctsender.,EvintArgTe,this.binding.NovellwitQ;thin.Chinestatw0;this.pivtitreE。薜1.IagfiLoGsticii=tsitupiutlujingText;privateidbtuFridickOlje?tsnderjEt=山,s)(this.binding.MoveFreviqusQ:thi三-Ce0；this,pictureBoilImajeLccaticr-tKttupimLujir.Test:namespace鞋子仃单pubJLieclassCpanAuan.pTivatestaticbooCLchQ皿:publicstatic“。1ChiK4ngetfretiarnchakan;E事七chakw二y电lu电：Etfing：System;u工in否Systm.Coilacticm.Gaiiaric;usinsSyst*m.T电xt;ILVDfrEp4C鞋子订单taS被写G1EUL工nf中(priTtswtaticMtrlnfNwernamg:BputliieSHsHri时心*内加个gettretiumusrnane;Jsetqcrn的e-value;|用尸登陆|系统管理销一邕陵退出系统注销系统代码：吧Cisture.csusingSystem,ColLections.C-eneric;usingSystenii.Telit;3sjacepriva.teaticboolistrue;piiblicstaticbcglIStruegetreturnistriie;i5tru=了号1口宅!privat息中ai&btiJ3K_Click(obj-actseivdsTE蟹巨ntkre)ifCtKtUsernajne.Tejct.Trim0=*)用尸名不能为空！“);ls&if(txtpsssworiText.Trim()-Ml.Bciji-hdw电码不能为空1elweCi；查询数据库的*日应记录的语句pristringHQleom:Fwl女eouikt(*)fromu.ssrinfojvhersussrTsms=ns*J5)-an4pa.5sxord6pfcEord，v：ury?.7/判断登陆的方法/Vsunifnarjr?/Qarunn*JB*=uNrnwn2用户名Qft5/5aramnail电二pa用尸垂蚂Jpaiem)/returnsX/returns?publicbolLcin(stringUE*rnani%stringpswitryf二QCq皿wuti匚ncon=ne*BqlCGimeuti匚。)；二Q匚。，mandumm=nvrS4lComand(sqlcotn,con);uEgrnimO w)，ccm.P#ramit&rs.Add(newSqlfi)蓟et.*i回口区电rnim巨二cflmPuramte-ri.AddticwSql?wan.et.*!(1pxwordmiOfsnO：inti=tint)com,El(cntSciJarf);if(d0)Ireturntru;Jelsereturnfalse;ccn.C1oe01ctick(Ekceptiont)returnfalse;ft!C二MeE1*giTcStrinsO：finallyL1二.添加商品信息系崭管理1|4精管理订!添加入库|修改入库中1参看商品|诺蓬处犍人|.一E国inshop.csstringimageuirl;privatevoid!btnTu?ian._CLick(dbJiectGender,EventArgs电)一.口i：alc咤匕曰5ultresult-this.QperJilSialQgl.-ilogO;iGt&eii1L-=lialcgfilesult_OK)stringfilename二openFileBielogl.FileNanie;this.pictureBcsl.ImageLocation=filename;imageurl-Filmvig;privatevoidbtnDE_Click(flbjectsv*-ntkrg启Iif(tKtlSTixt.Trim0=-】tFie：zigfeBr.x.ShoutpriceScoloFjsiie.jrangsiimage.Gcount);/tiinnsryff/1产W入JE方法pvllicdclIstEkcp(siirin：工工,strziii百nsnfloatinprice14atDTitpricftstrlh51eoli.n.t.5iztf5ti-isir1命k后七inicwn.tjtrySLCoaziectiducan.-fiewSlConzLec-tioctt$ojnn：SdlTsrameter工机哗二&e)i;SglTtraileter扈inpric：生.inrice).SIT-bi-uetei(*电.必皿1rLyu。1,14U七j);Slliurwtt4rCQclrclr).tu-aTiiifir0fi才cizfillI：5iZLIsrarigterCgkSTiszL=gangsi);S二】HWIeLtiC*01fliag-ii咤七):二卜TuarI;u(e中UiiL，LuUcil)J,i与KtVITi(ccn.Closeminifulw?JSK&hex二e.llssst*To5tlioff。:EiZip三.查看商品信息/傕布铜号建闰r依据的包查恂r侬捐样式查询而品工D商品卖价:商品样式；耀式二商品讲忙：商品大小:商星1图片ELK赵明，查看所有商品上1条1下_茨_谒定嬲|瞬|Idn&r*inpriceoutpriicesolariizyugsi加岗手机手机1L2412M3123红1Z男式JAE代码:旦1中闭王邮的西privatestriitgs-1ectALLshop=sel&ct术frominshap灯；“偏普r产总他诞凄号查词privatestringsslactb/ID-v5elecI*frominstepwhere；id二0id/根据颜色查询.“privatatringelectbyCclQr=Fl&et*fromiEishopwhrcolar=color：“根据样式查询privitaEtrinfEfilactbyluisi-f*frominshepwharaikfii=0pnEi*;修改密码.privatestringUpadaltFassword=updatauserinfostpasswox-d?9p15swordvh3rUEsrnaj*a=tiusffrn*ffl;(rnnirr八、+r+i内的q/(sumfuary/1/根据口查闻商品/C/suirimary/JwiiTi1刈修”DX7par的/CretumE)(/rcturttspublicD-iL-iS&tSslectbylD(stringIE)trv(SqlCtnn*ctioricoil=ntwSqComactlonCSqUCon);qlCo4nlMmdend=imwSLComihuidcoxj;eon.OtsflO:JqlDitiAdiptsrda.=il#wSqlDitlAiiipt&r0：end.Paramtri.Ad.4tnsw二1ITaam坦t&ridIDj)da.StltetCemmuid=匕md：DataSetis=newDataSet0；daFjll(dirreturiid雪：con.dose0：calch(Exception电)(r(lurnnull;stringx=qMeesage.loString0r1finally/Cswmaryz/赧据颜色覆询/Summary/paramnamt=vcolorWpartin)/eturnsturns)public;DataSetSeiectbyColorttiLngcolor)trySijlCornksetionccn-ruewSiCoiuiection(SQlCftn3：BqJ匚。mmand.0m-newJq_U:mrar.d(salectbyC?1qqti)com.Paranetirs.Add.Cnewq_F:arsun曰七&rcolor11/colorcon.Open0:SqlDataAdaptarda=newSqlDataAdpter()ida.belectCommand-com;DataSet二newDataSet0;dFill(ds,*all，；return,ds;陋,CloseO；catck(Exceptiong)(frail;然玷a-e-Wessa.ToStranO;IEixially/根据群式查询/UfT局纪产)/paramn,也二“yanaiX/param/&士七uriwJfitiirTiwApublicSilsctEylirigsi(string甲皿三1.)SqlConneclioncan=newS4LCaimeciiik(Eq.UC&n).Sql.CMTiftand电口中=n皆SiilCcmnidiidCseleetbyYngci,oon)：coih.farvntrs.A.dd(.ewSlFu4nettrC*Gyusiyuigsi);con.Op&r0：qLDatakdpterd.a=newSnilD4tAA.dflptrC：da5elevtCmmand=com;BaLaSetis-newHalaSet0,da.Fill(ds,all!xeturnds;COfk.Cl&St(),JcaLcli小堂七上ptimna,Ieturnnull.。=e-Htssa.ToStringC,finally/“得到全部前品的方法/&*turn工X/r.turns;publicDtaSttGitALLihp0try3aLec160cti.oncm=nn5qXonMction(S$LCg;SQConimuidc(nd=zhmonmvid(eilcAILshopsmn);C4n.OpanfJ;5U*tMd如twrdi-nvwSqJDa.tAiaptr;1.Son=umd;Idf-naw七出七()；da.Filltds,nil):jidatCT4D.CIoea0.1catch(EceptioTLkxfreturntluIL;反好咬具、=fK.NesKage.TaStringO;priwilevoid.btnAll_ClickeelEendaFjEventArgseJ点击查着所百商品tKtID.Datbindings.Clear0;Ix-tName.DalafiiTidLiLgs.Clear0:tstlikpriee.DataBind31n告，Clr0!txtOouTrice_DataBindLiLgs.Clear0：Datiudings.Clax0；txtSEie.DataBiudiiLgs.Clear0；tMtCount.Datafiindings.Clear0：tsttupianlujing.DataBindLLiLgs.Clear0:coriyansi.Ilataliinlings.Ciear0DhowAllskop0.this.ChongeEtats0;privatevoidhtnChaXunClicktobjectsenderEventArfs0(/btnUext.Enabled二false;/btnFri.Enabled=false;tx七D,D4t4Bindin耳后.Cl5ar();t/tH咖&DwtaEiMngMCleei0;t？itlnprice.UatafiindinE：,Clear();txtOoiPriceCl金Q;tytcolor.VatiBindings.Clear;口导三号.gt卸Mi腱宝Ch=0;txtCount,DaLaSindi口笛e.CLe朝口;tttupi-uJujingDatmindingCleu-0;，中二省口、tmindin爸国Cleir();ifC+Ti,5,ralbylDChcl;ed)if(tbis,Tst.Trim()=)IRe二ajfwi,Show（查询条件不能为空？）istringii=tsct爸工hon1.1号不1.Trim0;Csq-1-navr川Q;Mt心Mmilt=1.S*lscttylD(id);bindi工痘=口部finding：-na();bindingDfctaourci=3rsult.TE七。，IhtaBihdinq3,Addt：bindiid);tliix.txtN&in&indings.Add?bindingnan.c)：ttiis.tstlnprice.BaI.aFindiums.AddCtxbinding.inpriuE”)；tilli.txtOouPricsAdibindingnautprictn);tliis.tKta&l&r,Es.EslictbyColtr(coloi1);bindin看二ne*Eindin巨Sbirv0口.bLndin.JaLsSourcs=rsiultT*blssill，：dattridViwl.DaLaS:u,c=ticiding;+tiis.tjetID.DataBindinE.AinEiiChecked)strirtfyinjsi:comboBosl.Ssl&ctsdlttr*.ToStrin0：V=n电*Csql0;DitiSttresult=b.(yMigsi.)：bind!二mEindinSoru-ci0;binding.D&taSource=result.Ttblt,it+iGridyieiwl.DatASeurce二binding;thi5.IxtID.DitsBindirLjskddCt*Kt,bindingid):this.ixtN&mt.DitiBiniings.liinJinnanicr);this.(.Htlnprice.DataEindins.AddCt*xbinding;inprice);this.IxtOouFrice.D*tiiniings.AdiTtext.,binding,1Volitprii：g);this.1.Ktcolor.TataTindingsAddbinding，仁力*#)：thix.IxtSii*.Djsetsender15vantArg5e)D；：i1q期3tresrult二this,openileDislQgl.ShowDislog();if(resulit=DialogKesult.0Kstringfilnaire=openFileIial&glFileH耐e;this,picturToxl工ea酬Loc&tion=filsnajna：imaqeurlW-filgnang.isOK=true;删除商品:privatevoiibtiJUelecl_Click(objectsender,E寸电ntAr区ee)t工tilDnt据indih卓.口电m()stir+W&ir.fiU&hEiuWi充CliraqrQ-itluprlce工attBidiiL炉CLaar(4tltODtiPriceDaiaBcnding-E.Clear：titesl*5r.口/时0,t工0】*D*t由1di郭匚】W1)；txtC中皿匕.D刍1电B到尹，Cleor0；tzttapiarlajing.DatainiingE.Cl知ar0;csmyiTigEiinJinECl*ar();it01l肯(lliikJ魂定要册像这条商品，%，Nkc&tDuxDmME假自dhxl二3Ltf叮naLiuu)*=工iJucu1LTe*)Ctql0.-nFCsq：0：30。1rezutl-&delacteSeLect.tstlD.Test);itra)一片心迎51geii除成功？叩；this.ELcwAlL卷卜内IJ:filsIpubLie仙URdH电shgGr：3nMiitrinenun&firdtl*itcutjirtct.strtiic Chh Ptrwsii.er? (力力Ew&rgt竹1 con Fwr5 2t：4y写 c on. f trariet.er enn 1函电cn* F*r*irptk工 enn户丫不力总产 r 1Fi-(rm And Oip i d.F flj, 即)：iMdijev以1不工呼 HQ” AldG” A.ldi-ev AW工绅 AliiCncoi. Ljen 口 ：1 - r&ft rx*cnf HlOjfiUMTn： jf i m5QF：arflmmtm，Cd i, idl J;ScltarsTrita-?- tWinne, riiameJ J:5qjrsrm*t*rtQjrice* iniei)5rF rFiTit NT Cflfilllfl有* Qif pn C*1 J ；5 c 1F ,邓二十 arF Dr* color J) , 3clirar即孑上三 trW3 ie： size Jji，5WLTEL).3匚肝 “Fat 二TifMgaj )5 c 1F：=ir邓二 t ；LU r run， coont I) ,return鼠弓总t:httyceftion)UTiisfe二安背片二二工8TflSrririm;retUTTfslsip：/删除商品/零皿仙贯/XparamTtame=id/i)aran)/returnturnspublictfl&lc+(etrtrkgid)SijlComtecticgh二nerSLCoruxection(S11Con)：JulComnandcor-nevrSiilCizmmand(delectselectshop,con);con.Open0；com.Parametsirs.Add.GiwSqlP：ajrameter(11；iA)D;com.EmecutqNotiQucry0:Eeturntxue;F烟Do0吧0：芋七由仁乂匚寺t二ILretiirnfalse;五修改密码:口 XI确定修改|取消 |privatevoidbtnOKGlick(objectsender,EventArgs日)(if(txtOld.Textrlrim0=-iN品5合率吕。3,511网1百输入旧客码！J：J毋片ifHitt耳餐Tat,Trim0=)M盯二宝eH”，5h。我C谓输入新密码！w);Lsif(tKtK*.TskI.Trim()!=txtAgzin.TaxiTri制口igeBox.Slow许两次输入的变码不-1致t);54stringold-tKtCldTxtTrim0.stringNttft=Txt,Trim(),匚MqJ.c-tx&ffCstjl0：boolresult=c.ChanFiss*ord(Globilllnfo.Umrlffuhold,Ke).i,(restilt-true)M-eeageBok.SlowC修改峦码成功?1：金电（Mem5a空B因一ShwC修改密码不成功？谏乳旧密鹤是否正确？”）：/ /； / HJ/7 HJ J/J金ummajry)假现密蚂qsummaryGaramname=Uameparpirainname=01(3FasEirordVparaniVp*ramnajne=UewFassurorcTM/par的CreturnsOreturiuspublicboolChangzePassword(stringUame,string01dTassword,s：triRgNevrFazswordif(.!Login(Name,01如”口工-修，J如果没有登砧成功则返回诺,设的returntalse;且(EqlCCiiiiijctioilconn=n电阳SqLEotiTlcticinGilCon.):SijlCommaiidcmd=newSqlCommami(UpadatePissword,conn);cmd.Fairameters.Aid(newSqlFar：imeter(1password.1fM咱1fclpassword)emd.Faramct白ri.Aid(newSq_lFarCMEarnam6B1ITame)!tryCfiMl.OpSTL0：cmd.ExecutanQuery():COIUTL.Close0；returntm：catcK(SiilEsceptionei:)wwwreturnfilse;finallyif(conn.State-=ConnectionSta.te.Open)conn.Close()；登陆成功以后工具栏上的功能才能用：privatevoid系统登陆Olick(ot415例1述1131七皿_口1。1(。打“十一才毡鼠*E,grdAru巨)(CpaniiuiiLChaKm=lru;KinGaishep-n也用SinGiiskop0:sNdiPflrerit=this;s.Shew0;privatev&iitinnjri_Tick_lGtjsctEvndor1桩*)tvolStripSlftiasLabfel.Ti=系统时间:+DiTira*.Nw.ToSirinO;