还剩70页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
仓库管理系统代码大全系统主函数programcsusingSystem;usingSystem.Collections.Generic;usingSystem.Windows.Forms;namespacewarehouse{staticclassProgram{///summary///应用程序的主入口点////summary[STAThreadlstaticvoidMain{Application.EnableVisualStyles;Application.SctCompatiblcTcxtRcndcnngDcfaultfalse;Application.RunnewfrmLogin;//运行一个登陆对象集的常规信息usingSystem.Reflection;usingSystem.Runtime.InteropServices;//有关程序集的常规信息通过下列属性集//操纵更换这些属性值可修改//与程序集关联的信息[assembly:AsscniblyTitlcwarchouseu][assembly:AssemblyDescription][assembly:AssemblyConfiguration][assembly:AssemblyCoinpanyJMessageBox.Showex.Message;finally{sqlcom.DisposeO;sqlcon.Close;sqlcon.Dispose;}inP_int_rcturnValue=intrcturnValue.Value;returnP_int_returnValue;}#endregion#region添加仓库信息///sumniary///添加仓库信息////summary///paramname=P_str_StoreName仓库名称/param///paramnanie=P_str_StorePeople仓库负责/param///paramname=P_str_SlorePhone仓库电话/param///paramname=P_str_StoreUnit仓库所属单位/param///paramnamc=P_int_StorcRcmark备注v/param///reurns返回一个in类型的值/relurnspublicintInsertStoragestringP_sti_StoreNamestringP_str_StorePeoplestringP_str_StorePhonestringP_str_StoreUnitstringP_int_StoreRemarkSqlConnectionsqlcon=datacon.getcon;SqlCommandsqlcom=newSqlCommandproc_insertStoragesqlcon;sqlcom.Parameters.Add@StoreName\SqlDbType.VarChar
100.Value=P_str_StoreName;sqlcom.Parameters.AddCcaJStorePeopleSqlDbType.VarChar
20.Value=P_str_StorePeople;sqlcom.Parameters.Add@StorePhone”SqlDbType.VarChar
20.Value=P_str_StorePhone;sqlcom.Parameters.Add@StoreUnitSqlDbType.VarChar
100.Value=P_str_StoreUnit;sqlcom.Parameters.Add@StoreRemarkSqlDbType.VarChar1X
0.Value=P_int_StoreRemark;SqlParameterreturnValue=sqlcom.Parameters.AddreturnValueSqlDbType.ini4;returnValue.Direction=ParameteiDirection.ReturnValue;sqlcon.Opcn;try{sqlcom.ExccutcNonQucryO;}catchExceptionexMessageBox.Showex.Message;1finallysqlcom.Dispose;sqlcon.Close;sqlcon.Dispose;}intP_int_returnValue=intreturnValue.Value;returnP_inl_returnValue;}#cndrcgion#region添加新用户///summary///添加新用户////summary///vparaninanie=P_str_UserNanie用户名/param///paramname=P_str_UscrPwd用户密码v/param///paramname=P_str_UserRight用户权限/param///returns返回一个int类型的值〈/returns〉publicintInsertUserstringP_str_UserNamesiringP_str_UserPwdstringP_str_UserRight{SqlConnectionsqlcon=datacon.getcon;SqlCommandsqlcom=newSqlCommandproc_insertUsersqlcon;sqlcom.Parameters.AddCC^UserNameSqlDbType.VarChar
20.ValueP_str_UserName;sqlcom.Parameters.Add@UserPwdSq1DbType.VarChar
20.Value=P_str_UserPwd;sqIcom.Parameters.Add@UserRightSqlDbType.Char
10.Value=P_str_UscrRight;SqIParameterreturnValue=sqlcom.Parameters.AddretumValueSqlDbType.Int4;returnValue.Direction=ParamctcrDircction.ReturnValue;sqlcon.Open;trysqlcom.ExeculeNonQueryO;1catchExceptionexMessageBox.Showex.Message;}finallysqlcom.Dispose;sqlcon.Close;sqlcon.Dispose;}inP_int_returnValue=intretumValue.Value;returnP_int_returnValue;}#endregion#region修改用户信息///〈summary〉///修改用户信息////sumniary///paramnanie=P_int_UID用户编号/param///paramname=P_str_UserPwd用户密码/param///paramname=P_str_UserRight用户权限/param///returns返回一个int类型的值/returnspublicvoidupdateUserintP_int_UIDstringP_str_UserPwd.stringP_str_UserRightSqlConnectionsqlcon=datacon.getcon;SqlCommandsqlcom=newSqlCommandproc_updateUsersqlcon;sqlcom.Parameters.AddC@UserIDSqlDbType.Biglnt.Value=P_int_UID;sqIcom.Parameters.Add@UserPwdSqlDbType.VarChar
20.Value=P_str_UscrPwd;sqlcom.Parameters.Add@UserRight”SqlDbType.Char
10.Value=P_str_UserRight;sqlcon.Opcn;trysqlcom.ExccutcNonQucryO;IcatchExceptionex{MessageBox.Showex.Message;}finallysqlcom.Dispose;sqlcon.Close;sqlcon.Dispose;}}#endregion}1登陆界面frmLogin.esusingSystem;usingSystem.Collections.Gencric;usingSystem.Data;usingSystem.Drawing;usingSystcm.Tcxt;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarehouse{publicpartialclassfrmLogin:FormpublicstaticstringM_str_name;〃记录登录用户名字publicstaticstringM_str_pwd;〃记录登录用户密码publicstaticstringM_str_right;〃记录登录用户的权限BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;BascClass.DataOpcratcdopcratc=newwarehouse.BascClass.DataOpcratc;publicfrmLogin{InitializeComponentO;}privatevoidfrmLogin_LoadobjectsenderEventArgse〃窗口打开就加载的信息doperate.cboxBindCselectUserNamefromtb_Usertb_User”UserNamecboxUName;doperate.tewupwdselectUserPwdfromtb_UserwhereUserName=+cboxUName.Text+txtPwd;}privatevoidbtnLogin_ClickobjectsenderEventArgse{intP_int_returnValue=doperate.UserLogincboxUName.Text.TriinxlPwd.Text.TrimO;ifP_int_returnValue==100{M_slr_name=cboxUName.Texl.Trim;M_str_pwd=txtPwd.Text.Trim;fnnMainfrnain=newfrmMain;this.Hide;//this就是frmloginfmainfrnain.Show;}ifP_int_returnValue==-100MessageBox.ShowH用户名或者密码错误!提示”MessageBoxButtons.OKMessageBoxIcon.Information;txtPwd.Text=cboxUName.FocusO;privatevoidbtnExit_ClickobjectsenderEventArgseApplication.Exit;privatevoidcboxUNamc_SclcctcdIndcxChangcdobjcctsenderEventArgsc{SqlDataReadersqlread=datacon.getreadselectUserNameUserRightfromtb_UserwhereUserNamc-+cboxlIName.Text+ifsqlread.ReadO{labURight.Tcxt=sqlread[UserRight].ToString;M_str_right=labURight.Text;doperate.tewupwdselectUserPvvdfromtb_UserwhereUserName=+cboxUName.Text+txtPwd;}sqlread.Close;}privatevoidfnnLogin_FormClosingobjeclsenderFonnClosingEventArgse{Application.Exit;系统主界面frmMain.csusingSystem;usingSystcm.Collcctions.Gcncric;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Diagnostics;namespacewarehouse{publicpartialclassfrmMain:Form{publicfrmMainInitializeComponentO;privatevoidfrmMain_LoadobjectsenderEventArgse{tsslUser.Text=”操作用户权限+frmLogin.M_str_right.ToString.Trim;tsslDatc.Tcxt=DatcTimc.Today.ToLongDatcStringO;tsslTime.Texi=”登录系统时间+DateTime.Now.ToShortTimeStringO;iffrmLogin.M_str_right.ToString.Trim==普通用户”{入库管理ToolStripMenuItem.Enabled=false;出库管理ToolStripMenuItem.Enabled=false;借货还货ToolStripMenuItem.Enabled=false;供货商设置ToolStripMenuItem.Enabled=false;货物档案设置ToolStripMenuItem.Enabled=false;仓库设置ToolStripMenuItem.Enabled=false;权限设置ToolStripMenuItem.Enabled=false;用户管理ToolStripMenuItem.Enabled=false;btnIS.Enabled=false;btnOS.Enabled=false;btnBR.Enabled=false;btnPLEnabled=false;btnGI.Enabled=false;btnSI.Enabled=false;btnRLEnabled=false;btnUM.Enabled=false;}}privatevoidbtnIS_ClickobjeclsenderEventArgse//入库管理{GoodsManage.fnnISManageGMfism=newwarehouse.GoodsManage.frmISManage;〃GMfism.Show;GMfism.ShowDialogO;//这两个函数就看谁获得焦点,前者父窗口也可获得焦点,后者只有新创建的窗体}privatevoidbtnOS_ClickobjectsenderEventArgse〃出库管理{GoodsManagc.fnnOSManagcGMfosm=newwarehouse.GoodsManage.frmOSManage;GMfosm.ShowDialogO;privatevoidbtnBR_ClickobjecsenderEventArgse〃借货还货管理{GoodsManagc.frniBGManagcGMfbgm=newwarehouse.GoodsManage.frmBGManageO;GMfbgm.ShowDialogO;}privatevoidbtnPI_ClickobjeclsenderEventArgse//供应商设置{BasicInfo.frmPrlnfoBlfpi=newwarehouse.BasicInfo.frmPrInfo;Blfpi.ShowDialogO;}privatevoidbtnGl_ClickobjcctsenderEventArgsc〃货物档案设置{BasicInfo.frmGoodsInfoBlfgi=newwarehouse.BasicInfo.frmGoodsInfo;Blfgi.ShowDialogO;}privatevoidbtnSI_ClickobjectsenderEventArgse〃仓库设置{BasicInfo.frmStoreInfoBIfsi=newwarehouse.BasicInfo.frmStorelnfoO;BIfsi.ShowDialogO;}privatevoidbtnISL_ClickobjectsenderEventArgse〃入库查询LookandSum.fnnlSLookLSfisl=newwarchouse.LookandSum.fnnISLook;LSfisLShowDialogO;}privatevoidbtnSL_ClickobjectsenderEventArgse〃库存查询{LookandSum.frmGILookLSfgil=newwarehouse.LookandSum.fnnGILook;LSfgiLShowDialogO;}privatevoidbtnGOL_ClickobjectsenderEventArgse〃货物借出查询{LookandSum.frmBGLookLSfbgl=newwaiehouse.LookandSuni.frmBGLook;LSfbgLShowDialogO;privatevoidbtnGIL_ClickobjectsenderEventArgse〃货物归还查询LookandSum.frmRGLookLSfrgl=newwarehouse.LookandSum.frmRGLook;LSfrgl.ShowDialogO;}privatevoidbnOSL_ClickobjecsenderEvenlArgse〃出库查询{LookandSum.frmOSLookLSfosl=newwarchouse.LookandSiim.frmOSLook;LSfosl.ShowDialogO;}privatevoidbtnEP_ClickobjcctsenderEvcntArgsc〃更换密码{SystemSet.frmEditPwdHPfep=newwarehouse.SystemSet.frmEditPwd;HPfcp.ShowDialogO;}privatevoidbtnRI_ClickobjectsenderEventArgse〃权限管理{SystemSet.fnnRightManageHPfrm=newwarehouse.SystemSel.frniRighlManage;HPfrm.ShowDialogO;}privatevoidbtnUM_ClickobjectsenderEventArgse〃用户管理{SystemSet.fnnUserManageHPfum=newwarehouse.SystemSet.frmUserManageO;HPfum.ShowDialogO;}privatevoidbtnAU_ClickobjectsenderEventArgse〃关于本系统{SystemSet.fnnAboutUsHPfau=newwarehouse.SystemSet.frmAboutUsO;HPfau.ShowDialogO;privatevoidbtnCH_ClickobjectsenderEventArgse{ifMessageBox.Show”你确实要注销当前用户”,”提示MessagcBoxButtons.OKCancelMessageBoxIcon.Information==DialogResult.OKwarehouse.frmLoginfrmlogin=newfrniLogin;this.Hide;frmlogin.Show;privatevoidbtnExit_Clickobjectsender.EventArgse〃退出系统{lhis.Close;//=Applicalion.Exit;}privatevoidfrmMain_FormClosedobjectsenderFormClosedEventArgse{ifMessageBox.Show您确实要退出本系统吗”提示”,MessagcBoxButtons.OKCancclMcssagcBoxIcon.Information==DialogResult.OK{Application.Exit;}elsefrmMainfmain=newfrniMain;fmain.Sho\v;}}privatevoid入库管理ToolStripMenuItem_ClickobjectsenderEventArgse{btnIS_Clicksendere;}privatevoid出库管理ToolStripMenuItem_ClickobjectsenderEventArgse{btnOS_CIicksendere;}privatevoid借货还货ToolStripMenuItem_ClickobjectsenderEventArgse{btnBR_Clicksendere;}privatevoid供货商设置ToolStripMenuItem_ClickobjectsenderEventArgse{btnPI_Clicksendere;}privatevoid货物档案设置ToolStripMenuItem_ClickobjectsenderEventArgscbtnGI_Clicksendere;Iassembly:AsscmblyProduct\varchouseH][assembly:AssemblyCopyright版权所有2009][assembly:AssemblyTrademark][assembly:AssemblyCultureM]//将ComVisible设置为false使此程序集中的类型//对COM组件不可见假如需要从COM访问此程序集中的类型,//则将该类型上的ComVisible属性设置为true[assembly:ComVisiblefalse]//假如此项目向COM公开,则下列GUID用于类型库的ID[assembly:Guid063bd674-c4cc-4dc9-8lee-3791409e9189”]//程序集的版本信息由下面个值构成//主版本//次版本//内部版本号//修订号//[assembly:AssemblyVersion
1.
0.
0.0][assembly:Assemblyl.
0.
0.0]数据库连接类DataCon.es:usingSystem;usingSystem.Collections.Geneiic;usingSystcm.Tcxt;usingSystem.Data;usingSystem.Data.SqlClient;namespacewarehouse.BascClass{classDataCon{#region建立数据库连接///summary///建B数据库连接.////summary///returns返回SqlConnection对象/returnspublicSqlConnectiongetcon{stringM_str_sqlcon=DataSource=local:Database=db_warehouse;userid=sa:pwd=SqlConnectionmyCon=newSqlConnectionM_str_sqlcon;privatevoid仓库设置ToolStripMenuItem_ClickobjectsenderEvenlArgsebtnSI_Clickscndcrc;}privatevoid库存查询ToolStripMenuItem_ClickobjectsenderEventArgsebtnSL_Clicksendere;}privatevoid入库查询ToolStripMcnuItcni_ClickobjcctsenderEventArgse{btnISL_Clicksendere;}privatevoid出库查询ToolStripMenuItem_ClickobjectsenderEventArgsebtnOSL_Clicksendere;}privatevoid货物借出查i6ToolStripMenuItem_ClickobjectsenderEventArgsebtnGOL_CIicksendere;}privatevoid货物归还查询ToolStripMenuItem_ClickobjectsenderEventArgse{btnGIL_Clicksendere;}privatevoid更换密码ToolSlripMenuItem_ClickobjectsenderEvenlArgsebtnEP_Clicksendere;}privatevoid权限设置ToolStripMenuItem_ClickobjectsenderEventArgsebtnRI_Clicksendere;}privatevoid用户管理ToolStripMenuItem_ClickobjectsenderEventArgse{btnUM_Clickscndcre;privatevoid关于本系统ToolStripMenuItem_ClickobjectsenderEventArgsebtnAU_Clicksendere;privatevoid货物管理ToolStripMenuItem_ClickobjectsenderEvcntArgsc{tabControl
1.Selectedlndex=0;}privatevoid基本档案ToolSlripMenuItem_ClickobjectsenderEvenlArgsetabControlI.Sclcctcdlndcx=1;}privatevoid查询统计ToolStripMenuItem_ClickobjectsenderEventArgsetabControli.Selectedlndex=2;privatevoid系统设置ToolStripMenuItem_ClickobjectsenderEventArgsetabControl
1.Selectedlndex=3;privatevoid注销ToolStripMenuIteni_ClickobjectsenderEventArgsebtnCH_Clicksendere;privatevoid退出系统ToolStripMenuItem_ClickobjectsenderEventArgsebtnExit_Clicksendere;privatevoidtoolSripStatusLabe!6_ClickobjectsenderEventArgse货物档案管理入库frmlnManage.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarchousc.GoodsManagc{publicpartialclassfrmlSManage:Form{warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DataOperateO;publicfnnISManagc{InitializeComponent;}privatevoidfrmISManage_LoadobjectsenderEventArgse{dgvISManage.Controls.AddhScrollBarl;//数据源控件中添加了一个水平滚动条doperate.cboxBindselectStoreNamefromtb_Storagetb_StorageStoreNamecboxSName;//仓库名字显示出来dopcratc.cboxBindCselectPrNamefromtb_Providertb_ProviderPrNaniccboxPName;//计最单位显示出来DataSetmyds=datacon.getdsselectISIDas入库编号GoodsIDas货物编号GoodsNamcas货物名称PrNameas供应商名称”+StoreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计量单位GoodsNunias入库数量”+GoodsPriceas货物单价GoodsAPriceas总金额JSDateas入库口期HandlePeopleas经手”+ISRemarkas备注fromtb_InStoretb_InStore;dgvISManagc.DataSourcc=myds.Tables[O];〃datasct中的第一个datatablc0=lb_InSore}privatevoidbtnAdd_ClickobjcctsenderEventArgse{iftxtISGID.Text==MessageBox.ShowC1货物编号不能为空!”信息二MessageBoxButtons.OKMessageBoxIcon.Information;倍哥“i山耳烈荡日合妣弈溟“Moqs・xos弱0SS内001==sniPAiunpj-jurdJjiXOiupj/WgiuaSiix】uiHLXQj;0idgdHlx】XOuiuiixsiaoiJdioixOiBiuioaaoiyoAUOj叫JLlX0j/iunN£SI】xii£】uioLU0AuoiU!Uix0j/i!UQDXoq4unjiix0j/3ods9ixjYiU!.ij;】xoL°iin2NSXoqoOiuNJJxoj/oiueNdxoq^OiuiJiixsioiuBMgsnxui!』l]X0lqidsIx】乙£uiOL】J9AUOOspooD】J0Sur2iegdop=oniUAiunjoj-jui-dmi9Sp{iUOinUIJOJUIUO3IXOg0nESS3J^XCTSuonnaxoa弱ess内“曾引“蓦实勇太圭耘》、\板乂89如^内}....==lx/Q[dmdHWJ!{XuonuuuojuiuooixoqooEsssj^、XO・sucnngxoH福拓s内,“首昌“蓦区剃V描昨附孤,Moqsx跆Hess内}....==lxQj/gdsDxj!uo!Hnujoju[uoQ[xo日oEcss内^OSuojjnaxogo3BSS9jAI“首哥““书华弗虫害源型丫“血叩$任弱昭5内}....==】x叽iunNDSI】x】j!{^uoiwiuiojuiuooixogsSvsso^方Osuoiin砂护丽ssog“首哥“i点华咨g虫奶审咐算“\临3日Bessog}心==lx0E8!」dID】x】J!{iuoijuuiJojuiuo3ixoqa§ussapM^OSUonngxogaSussQiAi,曾哥“隼辨业晦却阚;勇“moqs、护我ssopj....==[X0J/°weNDSPXJ!MessageBoxButtons.OKMcssageBoxIcon.Information;elseifP_int_retumValue==200{MessageBox.Show”这类货物己经存在惟一编号!”信息”MessageBoxButtons.OKMcssageBoxIcon.Information;}elseMessagcBox.ShowC货物入库成功!”,信息”,MessageBoxButtons.OKMcssageBoxIcon.Information;frmISManage_Loadsendere;privatevoidbtnDel_ClickobjectsenderEventArgse{//try//{〃删除下面数据源控件中的,指示的数据项datacon.getcomdeletefromtb_InStorewhereISID=+Convert.ToStringdgv!SManage|0dgvISManage.CuirentCell.RowIndexl.Value.Trim+//Convert.ToStringdataGridView1[1dataGridViewl.CurrentCell.Rowindex].Value.Trim;//来取得所选中的那行数据某列的值...MessageBox.Show货物删除成功!,信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmISManage_Loadsendere;//}//catchExceptionex//{//McssagcBox.Showex.Message警告”,MessageBoxButtons.OKMessageBoxIcon.Warning;〃}privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;privatevoiddgvISManage_CellClickobjectsenderDataGridViewCelIEventArgse/*datagridvicw控件有—*个CcllClick事件是当单击datagridvicw控件的任意部分是发生.然后再用Convert.ToStringdataGridViewl[ldataGridViewl.CurrentCell.Rowindex].Value.Trim;来取得所选中的那行数据某列的值*/{txtISGID.Text=Convcrt.ToStringdgvISManagc|ldgvISManagc.CurrcntCcll.Rowindex].Valuc.Trim;txtISGName.Text=Converl.ToSringdgvISManage[2dgvISManage.CurrentCell.RowIndex].Value.Trim;cboxSName.Text=Convert.ToStringdgvISManage[4dgvISManage.CurrentCe]l.RowInclexl.Value.Trim;cboxPName.Text=Convert.ToStringdgvISManage[3dgvISManage.CurrentCell.Rowindex].Value.Trim;txtGSpec.Text=Convert.ToStringdgvISManage[5dgvISManage.CurrentCell.Rowindex].Value.Trim:cboxGUnit.Text=Convert.ToStringdgvISManagel6dgvISManage.CurrentCell.Rowindex].Value.TriiTi;txtlSGNum.Text=Convert.ToStringdgvISManage[7dgvISManage.CurrentCell.RowindexJ.Value.Trim;txtGIPrice.Text=Convert.ToStringdgvISManage[8dgvISManage.CurrentCell.RowIndcxJ.Valuc.Trim;txtGSPrice.Text=Conver.ToStringdgvISManage[9dgvISManage.CurrentCell.Rowindex].Value.Trim;txtHPeople.Text=Convert.ToStringdgvISManage[l1dgvISManage.CurrentCell.Rowindex].Value.Trim;txtISReniark.Text=Convert.ToStringdgvISManage[12dgvISManage.CurrentCell.RowIndcx].Valuc.Trini;}privatevoidtxtGIPrice_TextChangedobjectsenderEventArgse{try{txtGSPrice.Text=Convert.ToStringConvert.ToDecirnaltxtGIPrice.Text.Trini*Convert.ToInt32txtISGNum.Text.Trim.Trim;//Convert.ToDecimaltxtGIPrice.Text.TrimO将文本值转为Decimal数值〃将数字的指定Siring表示形式转换为等效的Decimal数字}catchExceptionex{MessageBox.Showex.Message警告,MessageBoxButtons.OKMcssagcBoxIcon.Warning;}}privatevoidfrm!SManage_FormClosedobjectsenderFormCloscdEvcntArgsc{this.Close;}privatevoidbuttonl_ClickobjectsenderEventArgse{this.txtGIPrice.Text=this.txtGSpec.Text=this.txtHPeople.Text=this.txtISGID.Text=this.txtISGName.Text=this.txtISGNum.Texl=this.txtISRemark.Text=this.txtGIPrice.Text=this.txtGSPrice.Text=}I}出库管理frmOsManage.esusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystcni.Data.SqlClicnt;namespacewarehouse.GoodsManagepublicpartialclassfrmOSManage:Formwarehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BascClass.DataOpcratcdopcratc=newwarchouse.BascClass.DataOpcratc;publicfrmOSManage{InitiaiizcComponentO;}privatevoidfrmOSManage_LoadobjectsenderEventArgse{dgvOSManage.Controls.AddhScrollBarl;doperate.cboxBindselectdistinctStoreNamefromtb_InStoretb_InStoreStoreNainecboxSName;DataSetmyds=datacon.getdsselectOSIDas出库编号.StoreNameas仓库名称GoodsNameas货物名称”+GoodsSpecas规格GoodsUnitas计吊:单位GoodsNumas出库数量GoodsPriceas价格.GoodsAPriceas总金额”+OSDateas出库Fl期PGProvideras提货单位PGPeopleas提货”+HandlcPcoplcas经手OSRcmarkas备注fromtb_OutStoretb.OutStore;dgvOSManage.DataSourcc=myds.Tables[tb_OutStorc];}privatevoidbtnAdd_Clickobjectsender.EventArgse{try{SqlDataRcadcrsqlrcad=datacon.gctrcadCsclcctGoodsNumfromtb_GoodsInfo*+whereStoreName=+cboxSName.Texi.Trim+*andGoodsNaine=+cboxGName.Text.TrimO+*andGoodsSpec=+cboxGSpec.Text.Trim+ifsqhead.ReadO{ifConvert.ToInt32txOSGNum.Text.TrimConvert.ToInt32sqlread[GoodsNum].ToString.Trim{MessageBox.Shown仓库中没有足够的货物!提示MessageBoxButtons.OKMcssagcBoxIcon.Information;elsedalacon.getcominsertintotb_OutStoreStoreNameGoodsNameGoodsSpec.GoodsUnit+GoodsNumGoodsPricePGProviderPGPeopleHandlepeopleOSRemark+valuesC+cboxSName.Text.TrimO++cboxGName.Text.Trim++cboxGSpec.Text.Trim+V+cboxGUnit.Text.Trini++txtOSGNum.Text.Trim++txtGOPrice.Text.TrimO++txtOSUnit.Text.Trim++txtOSPcople.Text.Trim+二”+txtHPeople.Text.TnmO+\H+txtOSRemark.Text.Trim+MessageBox.Show货物出库成功!”信息”,MessageBoxButtons.OK.MessageBoxIcon.Information;frmOSManagc_Loadscndcrc;11sqlread.Close;}catchExceptionex{MessageBox.Showex.Message警告,MessageBoxButtons.OKMessageBoxIcon.Warning;}}privatevoidbtnDel_ClickobjcctsenderEvcntArgse{trydatacon.getcomndeletefromtb_OutStorewhereOSID=+Convert.ToStringdgvOSManage[0dgvOSManage.CurrentCell.RowIndex].VaIue.Trim+MessageBox.Show货物删除成功!”,”信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmOSManage_Loadsendere;}catchExceptionexMessageBox.Showex.Message警告,MessageBoxBuuons.OKMessageBoxIcon.Warning;privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;privatevoiddgvOSManagc_CcllClickobjcctsenderDataGridVicwCcllEvcntArgsc{cboxSName.Text=Convert.ToStringdgvOSManage[1dgvOSManage.CurrentCell.RowIndex].VaIue.Trim;cboxGName.Text=Converl.ToSringJgvOSManage[2dgvOSManage.CurrentCell.Rowindex].Value.Trim;cboxGSpcc.Tcxt=Convert.ToStringdgvOSManagc[3dgvOSManage.CurrentCell.Rowindex].Value.Trim;cboxGUnit.Text=Conveil.ToStringdgvOSManage[4dgvOSManage.CurrentCell.Rowindex].Value.Trim;txlOSGNum.Text=Convert.ToSringdgvOSManage[5dgvOSManage.CurrentCell.Rowindex].Value.Trim;txtGOPrice.Text=Convert.ToStringdgvOSManage[6dgvOSManage.CurrentCell.Rowindex].Value.Trim;txtGSPrice.Text=Convert.ToStringdgvOSManage[7dgvOSManage.CurrentCell.Rowindex].Valuc.Trim;txtOSUnit.Text=Convert.ToStringdgvOSManage[9dgvOSManage.CurrentCell.Rowindex].Valuc.Trim;txtOSPeople.Text=Convert.ToStringdgvOSManage[10dgvOSManage.CurrentCell.RowIndex].Value.Trim;txtHPeople.Text=Conven.ToStringdgvOSManage[11dgvOSManage.CurrentCell.Rowindex].Value.Trim;txtOSRemark.Text=Convert.ToStringdgvOSManage[12dgvOSManage.CurrentCell.Rowindex].Valuc.Trim;}privatevoidcboxSName_SelectedIndexChangedobjectsenderEventArgse{doperate.cboxBindselectdistinctGoodsNamefromtb_InStorewhereStoreName-+cboxSName.Text.TrimO+tb_InStoreGoodsNamecboxGName;privatevoidcboxGName_SelectedIndexChangedobjectsenderEventArgse{doperate.cboxBindselecldistinctGoodsSpecfromtb_InStorewhereStoreName=returnmyCon;#endregion#rcgion执行SqlCommand命令///summary///执行SqlCommand〃/〈/summary〉///paramname=M_str_sqIstrSQL语句/parampublicvoidgetcomstringM_str_sqlstr{SqlConnectionsqlcon=this.getcon;sqlcon.Open;SqlCommandsqlcom=newSqlCommandM_str_sqlstr»sqlcon;sqlcom.ExecuteNonQueryO;//返回受影响的行数sqlcom.DisposeO;sqlcon.Close;sqlcon.DisposeO;}#endrcgion#region创建DataSet对象读取数据///summary///创建一个DataSet对象////summary///paramname=M_str_sqlstrSQL语句/param///vparaniname=M_str_table表名v/param///returns返【可DataSet对象/reiumspublicDataSetgetdsstringM_str_sqlstrstringM_str_table{SqlConnectionsqlcon=this.getcon;sqlcon.Opcn;SqlDataAdaptersqlda=newSqlDataAdapterM_str_sqlstrsqlcon;DataSetmyds=newDataSet;sqlda.Fi!IniydsM_str_table;returnmyds;}#endregion#region创建SqlDataReader对象读取数据///summary+cboxSName.Text.TrimO+andGoodsName=u+cboxGName.Text.Trim+thJoStoreGoodsSpeccboxGSpec;SqlDataReadcrsqlread=datacon.gctreadselcctGoodsUnilGoodsOuiPriceGoodsNumfromtb_GoodsInfo+whereStoreName=+cboxSName.Text.TrimO+*andGoodsNamc=H+cboxGName.Text.Trim+ifsqlread.Readthis.cboxGUnit.Tcxt=sqlread[GoodsUnit].ToString.Trim;this.txtGOPrice.Text=qlread[GoodsOutPricel.ToString.Trim;this.tbxshenxia.Text=sqlread[GoodsNuni].ToStnng.Trim;}sqlread.CIose;}privatevoidtxtOSGNum_TextChangedobjectsenderEventArgse{trytxtGSPrice.Text=Convcrt.ToStringCConvcrt.ToDcciniaKtxtGOPncc.Tcxt.TrimO*Convert.ToInt32txtOSGNum.Text.Trim.Trim;}catchExceptionexMessageBox.Showex.Message警告,MessageBoxButtons.OK.McssagcBoxlcon.Warning;}}privatevoidfrmOSManage_FormClosedobjectsenderForniClosedEventArgse{this.Close;}}I借货管理frmBGManage.csusingSystem;usingSystcm.Collcctions.Gcncric;usingSystem.Data;usingSystem.Drawing;usingSystcm.Tcxt;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarchouse.GoodsManagepublicpartialclassfrmBGManage:Form{warehouse.BaseClass.DalaCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwareliouse.BaseClass.DataOperate;publicfrmBGManage{InitializeComponentO;}privatevoidfrmBGManage_LoadobjectsenderEventArgse{dgvBGManage.Controls.AddhScrollBarl;doperate.cboxBindselectStoreNamefromtb_Storagetb_StorageStorcNamccboxSNamc;DataSetmyds=datacon.getdsselectBGIDas借货编号GoodsNaineas货物名称StoreNameas仓库名称”+GoodsSpecas货物规格GoodsNumas借出数量BGDateas借货日期HandlePeopleas经手”+BGPeopleas借货.BGUnitas借货单位BGRemarkas备注fromtb_BorrowGoodstb_BorrowGoods;dgvBGManage.DalaSource=myds.Tables[O];}privatevoidbtnAdd_ClickobjcctsenderEventArgsc{tryif!doperate.validateNumtxtBGNum.Text.TrimcrrorPrBGNum.SctErrortxtBGNum”输入务必为数字!”;elseerrorPrBGNum.Clear;SqlDataReadersqlread=datacon.getreadCselectGoodsNameStorcNamcGoodsNunifromtb_Goods!nfo+whereStoreName=+cboxSName.Text.Trim+andGoodsName=+cboxGName.Text.Trim+andGoodsSpec=+cboxGSpec.Text.Trim+ifsqlread.Rcad{ifConvert.ToInt32sqlread[GoodsNuni].ToString.Trim=1{MessageBox.Show该货物库存己经不足!”警告”,MessageBoxButtons.OKMessageBoxIcon.Warning;}else{ifConvert.Tolnt32txtBGNum.Text.Trim=Convert.ToInt32this.tbxshenxia.Text.Trim{MessageBox.Show”没有足够的货物供您借取!二警告,MessagcBoxButtons.OKMessageBoxIcon.Warning;txtBGNum.Tcxt=txlBGNum.FocusO;}else{datacon.getcominsertintotb_BorrowGoodsStoreNanieGoodsNameGoodsSpec/+GoodsNuniHandlePeopleBGPeopleBGUnit.BGRen】ark”+values+cboxSNamc.Tcxt.TrimO++cboxGName.Texl.Trim++cboxGSpec.Text.Trim++txtBGNum.Text.Trim++txlHPeople.Text.Trim++txtBGPeople.Text.Trim++txtBGDcpart.Tcxt.TrimO++txBGRemark.Text.Trim+MessageBox.ShowM借货成功!”信息McssagcBoxButtons.OKMessagcBoxIcon.Information;frmBGManage_Loadsendere;sqlread.Close;}}catchExceptionexMessageBox.Showex.Message警告,MessageBoxBultons.OKMessageBoxIcon.Warning;}}privatevoidbtnDel_ClickobjectsenderEventArgse{trydatacon.getcomndeletefromtb_BorrowGoodswhereBGID=+Convert.ToSringdgvBGManage[0dgvBGManagc.CurrentCcll.RowIndcx].Vaiuc.Trim+MessageBox.Show”借货资料删除成功!二”信息”,MessageBoxBullons.OKMessageBoxIcon.Information;frmBGManage_Loadsendere;IcatchExceptionex{MessageBox.Showex.Message警告,MessageBoxBultons.OKMessageBoxIcon.Warning;}}privatevoidbtnRGManage_ClickobjectsenderEventArgse{GoodsManage.frmRGManageGMfrgm=newfrmRGManage;this.Hide;GMfrgm.ShowDialogO;privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;privatevoidcboxSNamc_SclcctcdIndcxChangcdobjcctsenderEventArgsc{doperate.cboxBindCselectdistinctGoodsNamefromtb_GoodsInfowhereStoreName=+cboxSName.Text.TrimO+lb_GoodsInfo\GoodsNamecboxGName;}privatevoidcboxGName_SelectedIndexChangedobjeclsender.EventArgse{dopcrate.cboxBindselectdistinctGoodsSpecfromtb_GoodsInfowhereStoreName=+cboxSName.Text.Triin+andGoodsName-+cboxGName.Text.Trim+tb_GoodsInfoGoodsSpeccboxGSpec;SqlDataReadcrsqlreader=datacon.getreadselectGoodsNameStoreNameGoodsNumfromtb_Goods!nfowhereStoreName=+cboxSName.Text.TrimO+andGoodsName=*+cboxGName.Text.Trim+;ifsqlreader.Rcad{this.tbxshcnxia.Text=sqlrcadcr[GoodsNum].ToString.Trim;}sqlreader.Close;}privatevoiddgvBGManage_CellClickobjectsenderataGridViewCellEventArgse{cboxSName.Text=Convert.ToStringdgvBGManage[2dgvBGManage.CurrenlCell.Rowindex].Value.Trim;cboxGName.Text=Convert.ToStringdgvBGManage[1dgvBGManagc.CurrcntCcll.Rowindex].Valuc.Triin;cboxGSpec.Text=Convert.ToStringdgvBGManage[3dgvBGManage.CurrentCell.RowIndex].Value.Trim;txtBGNum.Tcxt=Convcrt.ToStringdgvBGManagcl4dgvBGManage.CurrenlCell.Rowindex].Value.Trim;txtHPeople.Text=Convert.ToStringdgvBGManage[6dgvBGManagc.CurrcntCcll.Rowindex].Valuc.Trim;txtBGPeople.Texi=Convert.ToStringdgvBGManage[
7.dgvBGManage.CuirentCeH.RowIndex].Value.Trim;txtBGDcpart.Tcxt=Convcrt.ToStringdgvBGManagcl8dgvBGManage.CurrentCell.RowIndex].Value.Trim;txtBGRemark.Text=Convert.ToStringdgvBGManage[9dgvBGManage.CurrentCell.RowIndex].Value.Trim;}privatevoidfrmBGManage_FormClosedobjectsenderFormClosedEventArgse{this.Close;}}I货物归还frmRGManage.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystcm.Data.SqlClicnt;namespacewarehouse.GoodsManage{publicpartialclassfrmRGManage:Form{warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DataOpcrate;publicIrniRGManageO{InitializcComponcntO;}privatevoidfrniRGManage_LoadobjectsenderEventArgse{dgvRGManage.Controls.AddhScrollBarl;doperate.cboxBindselectBGIDfromtb_BorrovvGoodstb_BorrowGoods”BGIDcboxBGID;DataSetmyds=datacon.getdsselectRGIDas还货编号BGIDas借货编号StoreNanieas仓库名称GoodsNameas货物名称”+GoodsSpecas货物规格,RGNumas归还数吊:NRGNumas未归还数量RGDateas还货日期HandlePeopleas经手”+RGPeopleas还货RGRcmarkas备注Editoras修改EditDateas修改日期fromtb_RetumGoodstb.RetumGoods1;dgvRGManage.DataSource=myds.Tables[tb_ReturnGoods];}privatevoidblnAdd_Clickobjectsender.EvenArgse{try{SqlDataReadersqlread=datacon.getreadselectGoodsNumfromtb_BorrowGoods+whereBGID=+Convert.ToInl32cboxBGID.Text.Trim+ifsqlread.ReadifConvert.ToInt32txiRGNum.Text.TrimConvert.ToInt32sqlread[GoodsNum].ToStnng.Trim{MessageBox.Show”您借的货物数目为”+Convert.ToInt32sqlread[GoodsNuni].ToStnng.Trim+请重新填写还货的数量!”,提示”,MessageBoxBultons.OKMessageBoxIcon.Information;txtRGNum.Text=txtRGNuin.Focus;}else{datacon.getcominsertintotb_RetumGoodsBGIDStoreNameGoodsNameGoodsSpecRGNum+NRGNumHandlcPcoplcRGPcopleRGRcmarkvalues+cboxBGID.Tcxt.Trim++txtSName.Text.TrimO++txtGName.Text.Trim+V+txtGSpec.Text.Trim++txtRGNum.Text.Trim+II,,+txtNRGNum.Text.TrimO++txtHPeople.Text.Trim++txtRGPeople.Text.TrimO++txtRGRemaik.Text.Trim+MessagcBox.Show还货成功!”,”提示二MessagcBoxButtons.OKMessageBoxIcon.Information;frmRGManage_Loadsendere;sqlrcad.Close:catchExceptionexMessageBox.Showex.Message警告,MessageBoxButtons.OKMessageBoxIcon.Warning;}}privatevoidbtnEdit_ClickobjectsenderEventArgse{try{datacon.gctcomnupdatctb_RcturnGoodssetHandlcPcopic-+txtHPeople.Text.TrimO+RGPeople=+txtRGPeople.Text.Triin+RGRemark=+txtRGReniark.Text.Trim+.Editer=4-warehouse.frmLogin.M_str_name+.EditDate-+DateTime.Now.ToShortDateStringO+whereRGID=+Converl.ToStringdgvRGManage[0dgvRGManage.CurrentCell.Rowindex].Value.Trim+McssageBox.Show还货档案资料修改成功!,”信息”,MessageBoxBultons.OKMessageBoxIcon.Information;frmRGManage_Loadsendere;}catchExceptionexMcssagcBox.Showex.Message警告,MessageBoxButtons.OKMessageBoxIcon.Warning;}}privatevoidbtnDel_Clickobjectsender.EventArgse{trydatacon.getcomdeletefromtb_ReturnGoodswhereRGID=+Convert.ToStringdgvRGManage|0dgvRGManage.CurrentCell.Rowindex].Value.Trim+;MessageBox.Show”还货档案资料删除成功!”,”信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmRGManage_Loadsendere;ca【chExcepuonexMcssagcBox.showcx・Mcssagc\喉群=McssagcBoxBu二ons.oKMessageBox一con.warning;privatevo一db-nEXrc一ickcbjec-senderEven-Argse-h一s.coscopr-vaovo一dcboxBGIDISe-ecod=dexchangedobjec-senderEven-ArgseMcboxBGID.Tex【nH--sys_em.Da【a・Da-aROWV-ew=elsesq-Da-aRcadcrsercadandMacon.gc-rcadcscoc-GoodsNumfrom亍—BorrowGoods--+=whereBGIDH--+convert.TOIn-32cboxBGID.TexLTrim+==ifsq一reada.Reads-h一s.-beja-huo.Texlnsq一reada「GoodsNum--】.TOS-r-ng.Trimo」一sq-DapReadersereadNumndascon.ge_read=se一ec-sumRGNUmasNumfrom亍—ReEmGoods--+-whereBGIDH--+conver-.TO3-32cboxBGID.TexLTr-m+----;-fsq一readNum.Rgdoifsq_readNum「Numw.TOS_ring.TrimonnJfMessageBox.showc-^薄^苫母定潍莲--;一e-sefMessageBox.show--rus-烤w7y=+sqlreadNumrzumw.TOS-ringo.Trimo+o=--〕sqlreadNum.Close;SqlDataReadersqlread=datacon.getreadselectStoreNameGoodsNameGoodsSpecfromtb_BorrowGoods+whereBGID=+Convcrt.ToInt32cboxBGID.Tcxt.Trim+ifsqlread.Read{txtSNamc.Tcxt=sqlread[StoreName].ToString.Trim;xtGName.Text=sqlread[GoodsName].ToString.Trim;txtGSpec.Text=sqlread[GoodsSpec].ToString.Trim;}sqlread.Close;}}privatevoiddgvRGManage_CellClickobjectsenderDataGridViewCellEvenlArgse{cboxBGID.Text=Convert.ToStringdgvRGManage[1dgvRGManage.CurrentCell.RowIndex].Value.Trim;txtSName.Text=Convert.ToStringdgvRGManage[2dgvRGManage.CurrentCell.Rowindex].Value.Trim;txtGName.Text=Convert.ToStringdgvRGManage[3dgvRGManage.CurrentCell.Rowindex].Value.Trini;txtRGNum.Tcxt=Convert.ToStringdgvRGManage[5dgvRGManage.CurrentCell.Rowindex].Value.Trim;txtNRGNum.Text=Convert.ToStringdgvRGManage[6dgvRGManage.CurrentCell.Rowindex].Value.Trim;txiRGPeople.Text=Conver.ToStringdgvRGManage[
9.dgvRGManage.CurrentCell.Rowindex].Value.Tiim;txtHPcople.Tcxt=Convcrt.ToStringdgvRGManagc[8dgvRGManage.CurrentCell.Rowindex].Value.Trim;txtRGRemark.Text=Convert.ToStringdgvRGManage[10dgvRGManage.CurrentCell.Rowindex].Value.Trim;}privatevoidtxtRGNum_TextChangedobiectsenderEventArgse{trySqlDataReadersqlread=datacon.getreadselectGoodsNumfromtb_BorrowGoods///创建J个SqlDataRcadcr对象////summary///paramname=M_str_sqlstrSQL语句v/param///rcturns返回SqlDataRcadcr对象/rcturnspublicSqlDataReadergetreadslringM_str_sqlstr{SqlConnectionsqlcon=this.getcon;SqlCommandsqlcom=newSqlCommandM_str_sqlstrsqlcon;sqlcon.Open;SqlDataReadersqlread=sqlcom.ExecuteReaderCommandBehavior.CloseConnection;//方法的参数表示假如关闭关联的对象sqlread则关联的连接sqlcon也关闭了returnsqlread;}#endregion}}数据库操作类DataOperate.cs:usingSystem;usingSystem.Collections.Generic;//命名空间包含定义泛型集合的接口与类,泛型集合同意用户创建强类型集合,它能提供比非泛型强类型集合21的类型安全性与性能usingSystem.Text;//System.Text命名空间包含表示ASCIRUnicode、LJTF-7与UTF-8字符编码的类;用于将字符块转换为字节块与将字节块转换为字符块的抽象基类;与操作与格式化String对象而不创建String的中间实例的Helper类.usingSystem.Windows.Fornis;usingSystem.Data;usingSystem.Data.SqlClient;usingSysteni.Collections;//usingSystem.Drawing;//命名空间提供了对GDI+基本图形功能的访问.usingSystem.IO;//提供用于创建、复制、删除、移动与打开文件的静态方法,并协助创建对象usingSystem.Drawing.Text;//usingSystem.Drawing.Drawing2D;//命名空间提供高级的二维与矢量图形功能.usingSystem.Drawing.Imaging;〃为源自Bitmap与Metafile的类提供功能的抽象基类usingSystem.Text.RegularExpressions;//命名空间包含一些类,这些类提供对.NETFramework正则表达式引擎的访问该命名空间提供正则表达式功能namespacewarehouse.BascClass+whereBGID=+Convert.ToInt32cboxBGID.Text.Trim+ifsqlread.ReadOtxtNRGNum.Tcxt=ConverLToStringConvert.ToInt32sqlread[GoodsNum].ToSlring.Trim-Convert.ToInt32txtRGNum.Text.Trim.Trim;}sqlread.Close;}catchExceptionex{MessageBox.Showex.Message警告,MessageBoxButtons.OK.McssagcBoxIcon.Warning;}privatevoidfrmRGManage_FormClosedobjectsenderFormClosedEventArgse{this.Close;}}}档案设置管理仓库设置frmStorelnfo.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarehouse.BasicInfo{publicpartialclassfrmStorelnfo:Form{warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DataOperate;publicfrmStorelnfoInitializeComponentO;privatevoidfrmSoreInfo_LoadobjectsenderEventArgsedgvSInfo.Controls.AddhScronBarl;DataSetmyds=datacon.getdsselectSlorelDas仓库编号SloreNameas仓库名称StorePeopleas负责”+StorcPhoneas电话StorcUnitas所属单位StoreDateas建库口期StoreRemarkas备注”+Editeras修改EditDateas修改日期fromtb_Storagetb_Storage;dgvSInfo.DataSource=myds.Tables[tb_Storagc];}privatevoidbtnAdd_ClickobjectsenderEventArgse{tryif!doperate.validatePhonetxtSPhone.Text.TrimerrorPrPhone.SetErrortxtSPhone电话格式不对”;Ielse{errorPrPhone.Clear;iflxSName.Text=={MessageBox.Show”仓库名称不能为空!”,信息”,MessageBoxBultons.OKMessageBoxIcon.Information;Ielse{intP_int_returnValue=dopcrate.InsertStoragetxtSName.Text.TrinitxtSLeader.Text.TrimtxtSPhone.Text.TrimixtSDepart.Text.TrimOtxtSRemark.Text.Trim;ifP_int_returnValue==100{MessageBox.Show”该仓库已经存在!”,信息”,McssagcBoxButtons.OKMcssagcBoxIcon.Information;elseMessageBox.Show”仓库信息添加成功!”信息MessageBoxButtons.OK.MessageBoxIcon.Information;fnnStorcInfo_Loadscndcrc;}}}}catchExceptionexMessageBox.Showex.Message警告,MessageBoxBultons.OKMessageBoxIcon.Warning;}}privatevoidbtnEdit_ClickobjectsenderEventArgse{tryif!dopcratc.validatcPhonetxtSPhonc.Tcxt.TrimcrrorPrPhonc.SctErrortxtSPhonc电话号码输入格式不正确,}elsecrrorPrPhonc.Clcar;datacon.gelcomupdatelb_StoragesetSloreName=+txtSName.Text.Trim+StorePeople=+txtSLeader.Text.Trim+StorePhone=+txtSPhone.Text.Trim+StQreUnit=‘+txtSDepart.Text.Trim+StoreRemark=”‘+txtSRemark.Texl.TrimO+Ediler=‘+warehouse.frmLogin.M_slr_name+EdilDate=‘+DateTime.Now.ToShortDateStringO+whereStoreID=+Convert.ToStringdgvSInfo[dgvSInfb.CurrentCell.Rowindex].Vaiue.Trim+MessageBox.Show仓库档案修改成功!,信息二MessageBoxButtons.OK.MessageBoxIcon.Information;frmStoreInfb_Loadscncicrc;catchExceptionexMessageBox.Showex.Message警告,MessageBoxButtons.OK.McssagcBoxlcon.Warning;}}privatevoidbtnDcl_ClickobjcctsenderEventArgse{trydatacon.getcomdeletefromb_StoragewhereSloreID=+Convert.ToStringdgvSInfo[0dgvSInfb.CurrentCell.RowIndexJ.Value.Trim+MessageBox.Show成功删除仓库!信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmStorelnfo_Loadsendere;}catchExceptionexMessageBox.Showex.Message警告,MessageBoxButtons.OK.McssagcBoxlcon.Warning;}}privatevoidbtnExit_ClickobjectsenderEventArgse{lhis.Close;}privatevoiddgvSInfo_CellClickobjectsenderDataGridViewCelIEventArgse{txtSName.Text=Convert.ToStringdgvSInfo[1dgvSInfb.CurrentCell.RowIndex].Value.Trim;txtSLeader.Text=Convert.ToSlringdgvSInfo[2dgvSInfo.CurrentCell.RowIndex].Value.Trim;txtSPhone.Text=Convert.ToStringdgvSInfo[3dgvSInfb.CurrentCell.RowIndex].Value.Trim;txtSDcpart.Tcxt=Convert.ToStringdgvSInfo[4dgvSInfo.CurrenlCell.RowIndex].Value.Trim;txtSRemark.Text=Convert.ToStringdgvSInfo[6dgvSInfo.CurrentCell.RowIndex].Value.Trim;privatevoidfrmSoreInfo_FormClosedobjectsenderFormCIosedEventArgse{lhis.Close;}1}供应商设置frmPrlnfo.csusingSystem;usingSystem.Colleclions.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystcm.Data.SqlClicnt;namespacewarehouse.BasicInfbpublicpartialclassfrmPrlnfo:Formwarehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.Dataperate;publicfrmPrlnfoOInitializcComponcntO;}privatevoidfrmPrInfo_LoadobjectsenderEventArgse{dgvPInfo.Controls.AddhScrollBarl;DataSetmyds=datacon.getdsselectPrlDas供应商编号PrNameas供应商名称PrPeopleas负责”+PrPhoneas电话PrFaxas传真PrRemarkas备注Editeras修改EditDateas修改日期fromtb_Providertb_Provider;dgvPInfo.DataSource=myds.Tables[tb_ProviderJ;}privatevoidbtnAdd_ClickobjectsenderEventArgsctryifdoperate.validatePhonetxtPPhone.Tex.TrimcrrorPrPhonc.SctErrortxtPPhonc”电话号码格式不正确”;}elseif!doperate.validateFaxtxtPFax.Text.TrinierrorPrFax.SetErrortxlPFax”传真号码输入格式不正确,}else{errorPrFax.Clear;crrorPrPhonc.Clear;iflxtPName.Text=={MessageBox.Show”供应商名称不能为空!”,”信息”MessageBoxBultons.OKMessageBoxIcon.Information;Ielse{intP_int_ieturnValue=doperate.InsertProvidertxtPName.Text.TrimtxtPLeader.Text.TnmdxtPPhone.Text.TrimtxtPFax.Text.TiimtxtPRemark.Text.Trim;ifP_int_rcturnValuc==100{MessageBox.Show该供应商已经存在!“信息”MessageBoxButtons.OKMessageBoxIcon.Information;}else{MessageBox.Show”供应商信息添加成功!”,信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmPrInfo_Loadsendere;catchExceptionexMessageBox.Showex.Message警告,MessageBoxButtons.OKMcssagcBoxlcon.Warning;}}privatevoidbtnEdit_ClickobjectsenderEventArgseif!doperate.validatePhonetxtPPhone.Text.TrimcrrorPrPhonc.SctErrortxtPPhonc电话号码格式不正确”;}elseif!doperate.validateFaxtxtPFax.Text.TrimerrorPrFax.SetErrortxtPFax”传真号码输入格式不正确”;}else{errorPrFax.Clear;errorPrPhone.Clear;datacon.getcomupdatelb_ProviderseiPrPeople=+txtPLeader.Text.TrimO+\PrPhone=+txtPPhonc.Tcxt.Trim+PrFax=+txtPFax.Tcxt.Trim+PrRemark=H+txlPRemark.Text.Trim+mEdiler=n+warehouse.fnnLogin.M_str_name+EditDate=+DateTime.Now.ToShortDateString+wherePrID=+Convert.ToStringdgvPInfo[0dgvPInfo.CurrentCeil.RowIndex].VaIue.Trim+MessageBox.Show*供应商档案修改成功!二”信息,MessageBoxBuons.OKMessageBoxIcon.Information;frmPrInfb_Loadsendere;I}catchExceptionexMessageBox.Showex.Message警告,MessageBoxButtons.OKMcssagcBoxIcon.Warning;privatevoidbtnDcl_ClickobjcctsenderEventArgsc{trydaacon.getcomudeletefromtb_ProviderwherePrID=+Convert.ToStringdgvPInfo[0dgvPInfo.CuiTentCell.Rowindex].Value.Trim+MessagcBox.ShowC成功删除供应商!”信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmPrInfb_Loadsendere;}catchExceptionex{McssagcBox.Showcx.Message警告,McssagcBoxButtons.OKMessageBoxIcon.Warning;}}privatevoidbtnExil_ClickobjectsenderEventArgse{this.Close;}privatevoiddgvPInfo_CellClickobjectsenderDataGridViewCellEventArgse{xtPName.Texl=Convert.ToSlringdgvPInfo[IdgvPInfo.CurrentCell.RowIndex].Value.Trim;txtPLeader.Text=Convert.ToStringdgvPInfol2dgvPInfb.CurrentCell.RowIndex].Value.Trim;txtPPhone.Text=Convert.ToStringdgvPInfo[3dgvPInfb.CurrentCell.RowIndex].Value.Trim;txtPFax.Text=Convert.ToSlringdgvPInfo[4dgvPInfo.CurrentCeIl.RowIndex].VaIue.Trim;txtPRemark.Text=Convert.ToStringdgvPInfd[5dgvPInfb.CurrentCell.RowIndex].Value.Trim;privatevoidfnnPrInfb_FormC1osedobjectsenderFonnClosedEvencArgsethis.Closc;I1库存货物管理fnnGoodsInfo.esusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Fonns;namespacewarehouse.BasicInfopublicpartialclassfrmGoodsInfb:Form{warchouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DalaOperateO;publicfrmGoodsInfo{InitializeComponentO;}privatevoidfrmGoodsInfo_LoadobjcctsenderEvcntArgsc{dgvGInfo.Controls.AddhScrollBail;DataSetmyds=datacon.getdsselectGoodsIDas货物编号GoodsNameas货物名称+StoreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计量单位”+GoodsNumas货物数量GoodsInPriceas进货价格GoodsOutPriceas出货价格”+Editcras修改EditDatcas修改日期fromtb_GoodsInfotb_Goodslnfou;dgvGInfo.DataSource=myds.Tables[b_GoodsInfo];privatevoidbtnEdit_ClickobjectsenderEventArgse{try{if!doperate.validateNumtxtGOPrice.Text.TrimerrorPrMoney.SetErrortxtGOPrice输入务必为数字;elseerrorPrMoney.ClearO;datacon.gctcomupdatctb_GoodsInfosetGoodsOutPricc=+txtGOPrice.Tex.Trim+’Ediier=+warehouse.frmLogin.M_str_name+EdilDate=”‘+DateTime.Now.ToShortDateStringO+whereGoodsID=H+Convert.ToStringdgvGInfo[0dgvGInfo.CuircntCell.Rowindex].Value.Trim+MessageBox.Show货物档案修改成功!“”信息”MessageBoxButtons.OKMessageBoxIcon.Information;frmGoodsInfo_Loadscndere;}}catchExccptionex{MessageBox.Showex.Message警告,MessageBoxButtons.OKMessageBoxIcon.Warning;}}privatevoidbtnDcl_ClickobjcctsenderEvcntArgsctrydaacon.getcomudeletefromb_GoodsInfowhereGoodsID=+Convert.ToStringdgvGInfo[0dgvGInfo.CurrentCell.RowIndex].Value.Trim+andStoreName=+Convert.ToStringdgvGInfol2dgvGInfb.CurrentCell.RowIndex].Value.Trim+MessageBox.Shown货物删除成功!,信息”,MessageBoxButtons.OKMessageBoxIcon.Information;frmGoodsInfo_Loadsendere;}catchExceptionexMessageBox.Showex.Message”警告二MessagcBoxButtons.OKMessageBoxIcon.Warning;privatevoidbtnExit_ClickobjectsenderEventArgseclassDataOpcrateDataCondatacon=newDataCon;//声明DataCon类的一个对象以调用其方法#rcgion绑定ComboBox控件///summary///对ComboBox控件进行数据绑定///〈/summary〉///paramname=M_str_sqlstrSQL语句/param///paramname=M_str_table表名/param///paramname=M_str_tbMcmbcr数据表中字段名/param///paramname=cboxComboBox控件ID/parampublicvoidcboxBindstringM_str_sqlstrstringM_str_tablestringM_str_tbMemberComboBoxcbox{DataSetmyds=datacon.getdsM_str_sqlstnM_str_table;cbox.DataSource=myds.Tables[M_slr_tablel;cbox.DisplayMember=M_str_tbMember;//显示username字段I#endregionRegion验证文本框输入为数字///summary///验证文本框输入为数字///〈/summary〉IIIparamname=M_str_num输入字符/param///returns返回一个bool类型的值/returnspublicboolvalidatcNumstringM_str_numreturnRegex.IsMatchM_str_num,A[0-9]*$;}#endregion#region验证文本框输入为电话号码///〈summary〉///验证文本框输入为电话号码////summary///paramname=M_str_phone输入字符串v/param///returns返回一个bool类型的值/retumsthis.Close;privatevoiddgvGInfo_CellClickobjectsenderDataGridViewCelIEventArgse{IxtGName.Text=Conver.ToStringdgvGInfo|
1.dgvGInfo.CurrentCell.Rowindex].Value.Trim;txtGSpcc.Text=Convert.ToStringdgvGInfo[3dgvGInfo.CurrentCell.Rowindex].Value.Trim;cboxGUnit.Texl=Convert.ToStringdgvGInfo[4dgvGInfo.CurrentCell.Rowindex].Value.Trim;txtGNum.Texl=Convert.ToStringdgvGInfo[5dgvGInfo.CurrentCell.RowIndex].Value.Trim;txtGIPricc.Tcxt=Convcrt.ToStringdgvGInfo[6dgvGInfo.CurrentCell.Rowindex].Value.Trim;txtGOPrice.Text=Convert.ToStringdgvGInfo[7dgvGInfo.CurrentCell.Rowindex].Value.Trim;}privatevoidfrmGoodsInfo_FormClosedobjectsenderFomiClosedEventArgse{lhis.Close;查询管理借出货物frmBGLook.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarehouse.LookandSumpublicpartialclassfrmBGLook:FormpublicfrinBGLookInitializeComponentO;warehouse.BaseClass.DalaCondatacon=newwarehouse.BaseClass.DataCon;privatevoidfrmBGLook_LoadobjectsenderEventArgsedgvBGInfo.Conlrols.AddhScrollBarl;DataSetmyds=datacon.getdsselectBGIDas借货编号.GoodsNameas货物名称StorcNameas仓库名称”+GoodsSpecas货物规格GoodsNumas借出数量BGDateas借货日期HandlePeopleas经手”+BGPcopleas借货BGUnitas借货单位BGRcmarkas备注fromlb_BorrowGoodslb_BorrowGoods;dgvBGInfo.DataSource=niyds.Tables[O];}privatevoidbtnLook_ClickobjectsenderEventArgse{try{iftxtLKWord.Text.Trim=={frmBGLook_Loadsendere;}elseifcboxLCondition.Text.Trim==借货编号”{DataSetmyds=datacon.getdsCseleclBGIDas借货编号GoodsNameas货物名称StoreNameas仓库名称+GoodsSpecas货物规格GoodsNumas借出数量BGDatcas借货日期HandlcPcoplcas经手+BGPcopleas借货BGUnitas借货单•位BGRemarkas备注fromtb_BorrowGoodswhereBGID=+txtLKWord.Text.Trini+tb_BorrowGoods;dgvBGInfo.DataSource=myds.Tables[O];1ifcboxLCondition.Text.TrimO==借货日期”stringP_str_dtime=txtLKWord.Text.Trim;DataSetmyds=datacon.getdsselectBGIDas借货编号GoodsNameas货物名称StoreNameas仓库名称”+GoodsSpecas货物规格GoodsNumas借出数量BGDateas借货口期HandlcPeoplcas经手”+BGPeopleas借货BGUnicas借货单位BGRemarkas备注fromtb_BoiTowGoods+whereycarBGDatc=n+P_str_dtimc.SubstringO4+andmonthBGDate=+P_str_dtime.Substring5P_str_dtime.Length-6+tb_BorrowGoods;dgvBGInfo.DalaSource=myds.Tables[O];}ifcboxLCondition.Tcxt.Trim==仓库名称”{DataSetmyds=datacon.getdsselectBGIDas借货编号GoodsNameas货物名称StoreNameas仓库名称”+GoodsSpecas货物规格GoodsNumas借出数量BGDateas借货日期HandlePeopleas经手+BGPeopleas借货BGUnitas借货单位BGRcniarkas备注fromtb_BorrowGoodswhereStoreNamelike%+txtLKWord.Text.Trim+”tb_BorrowGoods”;dgvBGInfo.DalaSource=niyds.Tables[j;1ifcboxLCondition.Tcxt.Trim==货物名称”{DataSetmyds=datacon.getdsHselectBGIDas借货编号GoodsNameas货物名称StoreNameas仓库名称,+GoodsSpecas货物规格GoodsNumas借出数量BGDatcas借货日期HandlcPcoplcas经手+BGPeopleas借货BGUnitas借货单位BGRemarkas备注fromb_BorrowGoodswhereGoodsNamelike*%+txtLKWord.Text.TrimO+tb_BorrowGoodst;dgvBGInfo.DalaSource=myds.TableslO];11}catchExceptionexMessageBox.Showex.Message提示MessageBoxButtons.OKMessageBoxIcon.Information;privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;privatevoidcboxLCondition_SclcctcdIndcxChangcdobjcctsenderEventArgsc{ifcboxLCondition.Text.Trim==借货日期”labe!
2.Text=”查询年月份”;}else{labe!
2.Text=查询关键字”;}}privatevoidfrmBGLook_FormClosedobjectsenderFormClosedEventArgse{this.Close;I}1库存查询frmGILook.esusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespacewarchouse.LookandSumpublicpartialclassfrmGILook:Form{warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;publicfrmGILookInitializeComponentO;privatevoidfnnGILook_LoadobjectsenderEventArgsedgvGInfo.Controls.AddhScrollBarl;DataSetmyds=datacon.getdsselectGoodsIDas货物编号GoodsNameas货物名称+StoreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计量单位+GoodsNumas货物数量GoodsInPriccas进货价格GoodsOutPriccas出货价格”+Editeras修改EdiDaceas修改日期fromb_GoodsInfo\tb_GoodsInfo;dgvGInfo.DataSource=myds.Tables[O];}privatevoidbtnLook_ClickobjeclsenderEventArgse{try{iftxtLKWord.Text.Trim=={frmGILook_Loadsendere;}elseifcboxLCondition.Text.TrimO==货物编号”{DataSetmyds=datacon.getdsselectGoodsIDas货物编号GoodsNameas货物名称”+StoreNameas仓库名称GoodsSpccas货物规格GoodsUnitas计量单位”+GoodsNumas货物数量GoodsInPriceas进货价格GoodsOutPriccas出货价格+GoodsLcastas最低存储GoodsMostas最高存储Editeras修改.EdilDateas修改日期”+fromb_GoodsInfowhereGoodsID=+txtLKWord.Text.Trim+tb_GoodsInfo;dgvGInfo.DataSource=myds.Tables[O];}ifcboxLCondition.Text.TrimO==”货物名称”DataSetmyds=datacon.getdsselectGoodsIDas货物编号GoodsNameas货物名称+StoreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计量单位+GoodsNumas货物数量.GoodsInPriceas进货价格GoodsOutPriceas出货价格+GoodsLeastas最低存储GoodsMostas最高存储Editeras修改EditDateas修改日期”+fromtb_Goods!nfowhereGoodsNamelike%”+txtLKWord.Tcxt.TrimO+tb_GoodsInfo;dgvGInfo.DataSource=myds.Tables[O];ifcboxLCondition.Text.Trim==仓库名称”DataSetmyds=datacon.getdsCselectGoodsIDas货物编号GoodsNamcas货物名称+StorcNamcas仓库名称GoodsSpccas货物规格GoodsUnitas计量单位+GoodsNumas货物数量GoodsInPriceas进货价格GoodsOutPriceas出货价格+GoodsLeastas最低存储GoodsMostas最高存储Editeras修改EditDateas修改口期”+fromtb_GoodslnfowhereStoreNamclike%+txlLKWord.Text.TrimO+tb_GoodsInfo;dgvGInfo.DataSource=myds.Tables[O];catchExceptionex{MessageBox.Showex.Message”提示,MessageBoxButtons.OKMessagcBoxIcon.Information;}}privatevoidbtnExit_ClickobjectsenderEventArgse{this.Close;}privatevoidfrmGILook_FormCIosedobjecsenderFormClosedEventArgsethis.Closc;}}入库查询frsISLook.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespacewarehouse.LookandSumpublicpartialclassfrmlSLook:FormpublicfnnISLookOInitializcComponcntO;}warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;privatevoidfrmISLook_LoadobjectsenderEvcntArgse{dgvISInfo.Controis.AddhScrollBarl;DataSetmyds=datacon.gctdssclcctISIDas入库编玷GoodsIDas货物编号GoodsNameas货物名称+PrNameas供应商名称SloreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计量单位+GoodsNunias入库数量GoodsPriceas进货价格GoodsAPriceas总金额JSDateas入库日期+HandlePeopleas经手ISRemarkas备注fromlb_InStoretb_InStore;dgvISInfo.DataSource=myds.Tables[O];}privatevoidbtnLook_ClickobjectsenderEventArgse{try{iftxtLKWord.Text.Trim=={frmISLook_Loadsendere;}elseifcboxLCondition.Tcxt.Trim==入库编号”{DataSetmyds=datacon.getdsCselectISIDas入库编号.GoodsIDas货物编号GoodsNameas货物名称.PrNameas供应商名称”+StoreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计吊:单位GoodsNunias入库数量+GoodsPriceas进货价格GoodsAPriceas总金额ISDateas入库日期HandlePeopleas经手+ISRemarkas备注fromtb_InStorewhereISID=+txtLKWord.Text.TrimO+tb_InStoreu;dgvISInfo.DataSource=myds.Tables[O];1ifcboxLCondition.Text.TrimO==货物编号”DataSetmyds=datacon.getdsselcctIS1Das入库编号GoodsIDas货物编号GoodsNameas货物名称PrNameas供应商名称”+StoreNameas仓库名称GoodsSpecas货物规格GoodsUnitas计量单位GoolsNumas入库数量+GoodsPriccas进货价格GoodsAPriccas总金额JSDatcas入库口期HandlcPcoplcas经手+ISRemarkas备注fromlb_InStorewhereGoodsID=+txlLKWord.Tex.Trim+“tb_InStore”;dgvISInfo.DataSourcc=myds.Tables[OJ;1ifcboxLCondition.Text.Trim==入库日期{stringP_slr_dtime=lxtLKWord.Tex.Trim;try{Convert.ToDateTimeP_str_dtime;}catch{MessageBox.Show时间格式不正确,应为XXXX年-XX月-XX日,}DataSetmyds=datacon.gctdsusclcctISIDas入库编号GoodsIDas货物编号GoodsNameas货物名称PrNameas供应商名称”+StoreNameas仓库名称.GoodsSpecas货物规格GoodsUnitas计量单位tGoodsNumas入库数量+GoodsPriceas进货价格GoodsAPriceas总金额JSDateas入库日期HandlePeopleas经手+ISRemarkas备注fromtb_InStorewhereyearISDate=+P_str_dtime.Substring04+andmonthISDate=+P_str_dtime.Substring5P_str_dtime.Length-6+tb_InStorc;dgvISInfo.DataSource=myds.Tables[O];IifcboxLCondition.Text.TrimO==仓库名称{DataSetmyds=datacon.getdsCselectISIDas入库编号GoodsIDas货物编号GoodsNameas货物名称.PrNameas供应商名称”+StoreNameas仓库名称GoodsSpecas货物规格GoodsUniias计量单位GoodsNumas入库数量+GoodsPriceas进货价GoodsAPriceas总金额ISDateas入库日期HandlcPcoplcas经手+ISRemarkas备注fromtb_InStorcwhereStoreNamelike%+txtLKWord.Text.TrimO+tbJnStore;dgvISInfo.DataSource=myds.Tables[01;ifcboxLCondilion.Text.TrimO==”货物名称DataSetmyds=datacon.gctdsnsclcctISIDas入库编号GoodslDas货物编号GoodsNameas货物名称PrNameas供应商名称”+StoreNameas仓库名称GoodsSpecas货物规格.GoodsUnitas计量单位GoodsNunias入库数黄+GoodsPriceas进货价格GoodsAPriceas总金额JSDateas入库口期HandlePeopleas经手+ISRemarkas备注fromtb_InStorewhereGoodsNamelike%+txtLKWord.Text.TrimO+%”,tbJnStore;dgvISInfo.DataSourcc=myds.Tables[O];catchExceptionexMessagcBox.Showex.Message”提示”,MessageBoxButtons.OKMessageBoxIcon.Information;}}privatevoidbtnExit_ClickobjectsenderEventArgse{this.Close;}privatevoidcboxLCondition_SelectcdIndexChangedobjectsenderEventArgseIifcboxLCondition.Text.Trim==入库日期”labe!
2.Text=”查询年月份;}else{labe!
2.Text=S询关键字”;}}privatevoidfrmISLook_FormClosedobjectsenderFormClosedEventArgsethis.Close;货物出库查询fnnOSLook.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSysiem.Text;usingSystem.Windows.Forms;namespacewarehouse.LookandSum{publicpartialclassfrmOSLook:FormpublicfrmOSLookInitializcComponcntO;}warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;privatevoidfrmOSLook_LoadobjcctsenderEvcntArgsc{dgvOSInfo.Controls.AddhScrollBarl;DataSetmyds=datacon.getdsselectOSIDas出库编号StoreNameas仓库名称GoodsNameas货物名称+GoodsSpecas规格GoodsUnitas计量单位GoodsNumas出库数量.GoodsPriceas价格GoodsAPriceas总金额+OSDateas出库日期PGProvideras提货单位PGPeopleas提货+HandlcPeopleas经手OSRemarkas备注fromtb_OutStore\tb_OutStore;dgvOSInfo.DataSource=myds.Tables[O];}privatevoidbtnLook_ClickobjectsenderEventArgse{tryiftxtLKWord.Text.TrimO==*frmOSLook_Loadsendere;}elsepublicboolvalidatePhonestringM_str_phonereturnRegex.IsMatchM_str_phone@\d{34}-\d{78};}#endregion#region验证文本框输入为传真号码〃/〈summary〉///验证文本框输入为传真号码///v/sumniary///vparaniname=M_str_fax输入字符串v/param///returns返I口I一个bool类型的值/retumspublicboolvalidateFaxstringM_str_fax{returnRegex.IsMatchM_str_fax@”86-\d{23}-\d{78};}#cndrcgion#region用户登录///summary///用户登录////summary///paramname=P_str_UserName用户名/param///paramnamc=P_str_UscrPwdffl户密码/param///reurns返回一个in类型的值/relurnspublicintUserLoginstringP_str_UserNamestringP_str_UserPwd{SqlConnectionsqlcon=datacon.getcon;SqlCommandsqlcom=newSqlComniandproc_Loginsqlcon;sqlcom.Parameters.Addn@UserNameSq1DbTypc.VarChar
20.ValueP_sr_UserName;sqlcom.Parameters.Add@UserPwd\SqlDbType.VarChan
20.Value=P_sir_UserPwd;SqlParameterretuniValue=sqlcom.Parameters.AddreturnValueSqlDbType.Int4;returnValue.Direction=ParameterDirection.ReturnValue;//j^回彳苴??sqlcon.Open;trysqlcom.ExecuteNonQueryO;ifcboxLCondition.Text.Trim==出库编号DataSetmyds=datacon.getdsCselectOSIDas出库编号StoreNameas仓库名称GoodsNameas货物名称+GoodsSpecas规格GoodsUnitas计危单位GoodsNumas出库数^GoodsPriceas价格GoodsAPriceas总金额+OSDateas出库日期PGProvideras提货单位.PGPeopleas提货”+HandlePcopleas经手.OSRemarkas备注fromtb_OutStorewhereOSID=+txtLKWord.Text.TrimO+也tb_OutStore;dgvOSInfo.DataSource=myds.TablesfO];1ifcboxLCondition.Text.Trim==出库日期“{stringP_str_dtimc=txtLKWord.Text.TrimO;DataSetmyds=datacon.getdsCseleclOSIDas出库编号StoreNameas仓库名称GoodsNameas货物名称+GoodsSpecas规格GoodsUnitas计量单位GoodsNumas出库数量GoodsPriceas价格GoodsAPriceas总金额+OSDateas出库日期PGProvideras提货单位PGPeopleas提货+HandlePeopleas经手0SRemarkas备注fromtb_OutStorewhereyearOSDate=+P_str_dtimc.Substring04+andmonthOSDatc=+P_str_dtimc.Substring5P_str_dtime.Lenglh-6+二tb_OutSlore;dgvOSInfo.DataSource=myds.Tables[O];}ifcboxLCondiion.Text.Trim==仓库名称”{DataSetmyds=datacon.getdsselectOSIDas出库编号StoreNameas仓库名称GoodsNameas货物名称+GoodsSpecas规格GoodsUnitas计量单位GoodsNumas出库数量GoodsPriceas价格GoodsAPriceas总金额:+OSDateas出库日期PGProvideras提货单位PGPeopleas提货+HandlePeopleas经手OSRemarkas备注fromtb_OutStorewhereStoreNamelike*%+txtLKWord.Text.TrimO+”tb_OutStore”;dgvOSInfo.DataSource=myds.Tables[OJ;1ifcboxLCondition.Text.TrimO==货物名称”DataSetmyds=datacon.getdsselectOSIDas出库编号StoreNameas仓库名称GoodsNamcas货物名称+GoodsSpecas规格GoodsUnitas计量单位GoodsNuinas出库数量GoodsPriceas价格GoodsAPriceas总金额”+OSDateas出库日期PGProvideras提货单位PGPeopleas提货”+HandlcPcoplcas经手OSRemarkas备注fromtb_OutStorcwhereGoodsNamclike%”+txtLKWord.Text.TrimO+Tb_OulStore”;dgvOSInfo.DataSouice=myds.Tables[O];catchExceptionexMessageBox.Showex.Message.”提示,MessageBoxButtons.OKMessagcBoxIcon.Information;I}privatevoidbtnExit_ClickobjcctsenderEvcntArgsc{this.Close;}privatevoidcboxLCondition_SelectedIndexChangedobjeclsenderEventArgse{ifcboxLCondition.Tcxt.Trim==出库日期label
2.Text=查询年月份”;}else{labcl
2.Tcxt=”查询关键字”;}}privatevoidfrmSLook_FormClosedobjectsenderFormClosedEventArgse{this.Close;}}}货物归还查询frmRGLook.esusingSystem;usingSystcm.Collcctions.Gcncric;usingSystem.Data;usingSystem.Drawing;usingSystcm.Text;usingSystem.Windows.Fonns;namespacewarehouse.LookandSumpublicpartialclassfrmRGLook:FormpublicfnnRGLook{InitializeComponent;}warehouse.BaseClass.DalaCondatacon=newwarehouse.BaseClass.DataCon;privatevoidfrmRGLook_LoadobjectsenderEventArgse{dgvRGInfo.Controls.AddhScrollBarl;DataSetmyds=datacon.getdsselectRGIDas还货编号BGIDas借货编,r}StoreNameas仓库名称GoodsNameas货物名称+RGNumas归还数昂:NRGNumas未归还数量RGDateas还货日期HandlePeopleas经手RGPeopleas还货RGRemarkas备注+Editeras修改EditDateas修改日期fromtb_ReturnGoodslb_RetumGoods;dgvRGInfo.DataSource=myds.Tables[O];}privatevoidbtnLook_ClickobjectsenderEventArgse{try{iftxtLKWord.Text.Trim=={frmRGLook_Loadsendere;}elseifcboxLCondition.Text.Trim==还货编号”{DataSetmyds=datacon.geldsCseleclRGIDas还货编号BGIDas借货编号StoreNameas仓库名称GoodsNameas货物名称”+•RGNumas归还数量NRGNumas未归还数量RGDatcas还货日期HandlePeopleas经手RGPeopleas还货RGRemarkas备注”+Editeras修改EdilDateas修改日期fromtb_RetumGoodswhereRGID=+txtLKWord.Text.Trim+M”tb_RcturnGoods”;dgvRGInfo.DataSource=myds.Tables[O];IifcboxLCondition.Tcxt.Trim==借货编号“{DataSetmyds=datacon.getdsselectRGIDas还货编号.BGIDas借货编号StoreNameas仓库名称GoodsNamcas货物名称+RGNumas归还数量NRGNumas未归还数量RGDaleas还货日期HandlePeopleas经手RGPeopleas还货RGRemarkas备注+Editeras修改EditDateas修改日期fromtb_ReturnGoodswhereBGID=+txtLKWord.Text.Trim+ntb_RctumGoods;dgvRGInfo.DataSource=myds.TablesfOl;IifcboxLCondition.Text.Trim==还货口期”{stringP_str_dtime=txtLKWord.Text.Trim;DataSetmyds=datacon.getdsuselectRGIDas还货编号BGIDas借货编号SoreNameas仓库名称GoodsNameas货物名称+RGNumas归还数量NRGNumas未归还数量RGDateas还货日期HandlePeopleas经手RGPeopleas还货RGRcmarkas备注+Editeras修改EditDateas修改日期fromtb_ReturnGoodswhereyearRGDate=+P_str_dtime.SubstringO.4+andmonthRGDale=+P_str_dtime.Substring5P_str_dtime.Length-6+tb_ReturnGoods;dgvRGInfo.DataSource=myds.Tables[OJ;1ifcboxLCondition.Text.Trim==仓库名称{DataSetmyds=datacon.getdsC1selectRGIDas还货编号BGIDas借货编y.StoreNameas仓库名称GoodsNameas货物名称+RGNumas归还数量NRGNumas未归还数量RGDateas还货日期HandlePeopleas经手RGPeopleas还货RGRemarkas备注+Editeras修改EditDateas修改日期fromtb_ReturnGoodswhereStoreNamclike%+txtLKWord.Tcxt.Trim+tb_ReturnGoods”;dgvRGInfo.DataSource=myds.Tables[O|;}ifcboxLCondition.Tcxt.Trim==货物名称”{DataSetmyds=datacoii.getdsuselectRGIDas还货编号BGIDas借货编号StoreNamcas仓库名称GoodsNamcas货物名称+RGNumas归还数最NRGNumas未归还数量RGDateas还货日期HandlePeopleas经手RGPeopleas还货RGRemarkas备注+Editeras修改EditDateas修改日期fromtb_RetumGoodswhereGoodsNamelike%+txtLKWord.Text.Trim+tb_RcturnGoods;dgvRGInfo.DalaSource=myds.Tables[OJ;I}IcatchExceptionexMessageBox.Showex.Message”提示,MessageBoxBultons.OKMessageBoxIcon.Information;}}privatevoidbtnExit_ClickobjectsenderEventArgse{this.Close;}privatevoidcboxLCondition_SelectedIndexChangedobjectsenderEventArgse{ifcboxLCondition.Text.Trim==还货日期”{label
2.Text=”查询年月份;}elselabel
2.Text=°查询关键字”;}}privatevoidfrmRGLook_FormClosedobjectsenderFonnClosedEventArgsethis.Close;}}}系统设置关于本系统frmAboutUs.csusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.IO;//文件流的头文件namespacewarehouse.SystemSet{publicpartialclassfrmAboutUs:Form{publicfnnAboutUs{InitializeComponentO;}privatevoidfrmAboutUs_LoadobjectsenderEvenlArgse{stringpath=Application.StartupPath+WAboutUs.txt;//获取可执行文件的地址System.IO.StreamReaderreader=newSystem.IO.StreamReaderpath.System.Text.Encoding.Default;this.txtAboutUs.Text=reader.RcadToEnd;reader.Close;}privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;}privatevoidfrmAboutUs_FormClosedobjectsenderFormClosedEventArgsethis.Close;密码修改frmEditPwd.esusingSystem;usingSystem.Collections.Gcneric;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespacewarchousc.SystcmSctpublicpartialclassfrmEditPwd:FormpublicfrmEditPwdInitializcComponcntO;}waiehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;privatevoidfrmEditPwd_LoadobjectsenderEvcntArgse{txtUName.Text=warehouse.frmLogin.M_str_name;}privatevoidblnSure_ClickobjectsenderEventArgse{iftxtFUNPwd.Text.Trim!=txtUNPwd.Text.Trim{eiTorPrPwd.SetEirortxtFUNPwd两次输入密码不-致!;}elseiftxtUOPwd.Text.TrimO!=warehouse.frmLogin.M_str_pwdMcssagcBox.Show°用户旧密码输入错误,请重新输入!”,错误提示MessageBoxButtons.OKMessageBoxIcon.Error;}elsedatacon.getcomupdatetb_UsersetUscrPwd-+txtUNPwd.Tcxt.Trini+whcrcUserNamc=+txtUNamc.Tcxt.Trirn+;MessageBox.Show密码修改成功!,信息”,MessageBoxButtons.OKMessageBoxIcon.Information;privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;privatevoidfnnEdiIPwd_ForniC1osedobjecIsenderFormClosedEventArgsethis.Closc;II权限管理frmRightManage.esusingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Fonns;usingSystem.Data.SqlClient;namespacewarchousc.SystcmSct{publicpartialclassfrmRightManage:FormpublicfrmRightManageO{InitializcComponcntO;}warehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon;warehouse.BascClass.DataOpcratcdopcratc=newwarehouse.BascClass.DataOpcratc;privatevoidfrmRighManage_LoadobjeclsenderEvenlArgse{doperate.cboxBindselectUserNainefromtb_User\tb_User*\UserNamecboxUName;}privatevoidbtnSurc_ClickobjcctsenderEvcntArgse{datacon.getcomCupdatetb_UsersetUserRight=+cboxURight.Text.Triin+whereUserName=+cboxUNanie.Text.Triin+;MessageBox.Show”权限修改成功!信息.MessageBoxButtons.OK.MessageBoxIcon.Information;}privatevoidbtnExit_ClickobjectsenderEventArgsethis.Close;privatevoidcboxUName_SelectedIndexChangedobjectsender.EvenArgse〃选择不一致的用户时显示不一致的权限{SqlDalaReadersqlread=datacon.getreadselectUserNameUserRightfromtb.User+whereUserName=+cboxUName.Text+;ifsqlread.ReadcboxURight.Text=sqlread[UserRightM].ToString.Trim;Isqlread.CIose;}privatevoidfrmRightManage_FormClosedobjectsenderFormClosedEventArgse{this.Close;用户管理fnnUserManage.esusingSystem;usingSystcm.Collcctions.Gcncric;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarchouse.SystcmSctpublicpartialclassfrmUserManage:Form{publicfrniUserManage{InitializeComponent;warehouse.BascClass.DataCondatacon=newwarehouse.BascClass.DataCon;warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DataOperate;privatevoidfrinUserManage_LoadobjectsenderEventArgseDataSetmyds=datacon.getdsselectUserIDas用户编号UserNameas用户名UserPwdas用户密码+UserRightas用户权限fromtb_Usertb_User;dgvUInfb.DataSource=myds.Tables[ntb_UserH];doperale.cboxBindseleclUserNamefromb_User\b_UseruUserNamecboxUName;dopcratc.cboxBindselcctUserRightfromtb_Usertb_Uscr\UscrRighCcboxURight;}privatevoidbtnAdd_ClickobjcctsenderEvcntArgsc{try{intP_inl_returnValue=doperate.InsertUsercboxUName.Text.TrimtxtUPwd.Text.TrimcboxURight.Text.Trim;ifP_int_returnVaiue==100MessageBox.ShowC*该用户己经存在,”警告”,MessagcBoxButtons.OKMcssageBoxIcon.Warning;}else{MessageBox.Show用户信息添加成功!”,”信息”,MessageBoxButtons.OKMcssageBoxIcon.Information;fnnUserManage_Loadsendere;}}catchExceptionex{MessageBox.Showex.Message警告,MessageBoxButtons.OKMessagcBoxIcon.Warning;}}privatevoidbtnEdit_ClickobjectsenderEventArgsetrydoperate.叩daleUserConvert.ToInl32dgvUInfo[0catchExceptionexMcssagcBox.Showcx.Message;}finallysqlcoin.Dispose;sqlcon.Close;sqlcon.Dispose;IintP_int_returnValue=intreturnValue.Value;returnP_int_returnValue;}#endregion#rcgion货物入库///summary///货物入库///〈/summary〉///paramname=P_int_GoodsID货物编号/param///paramname=P_str_GoodsName货物名称/param///paramnamc=P_str_PrName供应商名称/param///paramname=P_slr_SloreName仓库名称/param///paramname=P_str_GoodsSpec货物规格/param///paramnanie=P_str_GoodsUnit计吊:单位/param///paramname=P_int_GoodsNum进货数量/param///paramname=P_dml_GoodsPrice货物单价/param///paramname=P_str_HPeople”〉经手v/param///paramname=P_str_Remarku备注/param///returns返回一个int类型的值〈/returns〉publicintInsertGoodsintP_ini_GoodsIDsringP_str_GoodsNamestringP_str_PrNamestringP_str_StoreNamestringP_str_GoodsSpecstringP_str_GoodsUnitintP_int_GoodsNumdecimalP_dml_GoodsPricestringP_str_HPeoplestringP_str_RemarkSqlConnectionsqlcon=datacon.getcon;SqlCommandsqlcom=newSqlComniandproc_insertInStoresqlcon;dgvUInfo.CurrentCell.RowIndex].ValuetxtUPwd.Text.TrimcboxURight.Text.Trim;//MessageBox.ShowcboxUName.Items[ll.asdf.MessageBoxButtons.OK;//datacon.getcomupdatetb_UscrsetUscrPwd=+txtUPwd.Text.Trim+nUserRight=+cboxURight.Items.ToStringO+whereUserID=+cboxUName.Items.ToStringO+〃Convert.ToStringdgvUlnfo[0dgvUInfo.CurrenlCell.Rowindex].Value.Trim+MessageBox.Show用户信息修改成功!信息二MessageBoxButtons.OKMessagcBoxlcon.Information;frmUserManage_Loadsendere;}catchExceptionex{MessageBox.Showex.Message信息,MessageBoxButtons.OKMessagcBoxlcon.Information;}IprivatevoidbtnDel_ClickobjectsenderEventArgse{trydaacon.getcomdeletefromb_UserwhereUserID=+Convert.ToStringdgvUInfo[0dgvUInfo.CurrentCell.Rowindex].Value.Trim+MessageBox.Show”删除用户信息成功!”信息”MessageBoxButtons.OK.MessageBoxIcon.Information;fnnUscrManagc_Loadsendcre;}catchExceptionex{MessageBox.Showex.Message警告,MessageBoxButtons.OK.MessagcBoxlcon.Warning;}}privatevoiddgvJInfo_CcllClickobjcctsenderDataGridViewCcllEvcntArgsccboxUName.Text=Convert.ToStringdgvUInfo[1dgvUInfo.CurrcntCell.RowIndex].Valuc.Trim;txtUPwd.Text=Convert.ToStringdgvUInfo[2dgvUInfo.CurrentCell.RowIndex].Value.Trim;cboxURight.Tcxt=Convcrt.ToStringdgvUInfo[3dgvUInfb.CurrentCell.Rowindex].Value.Trim;}privatevoidfrmUscrManage_FonnCloscdobjcctsenderFonnClosedEventArgse{this.Close;}privatevoidblnexit_ClickobjeclsenderEventArgsethis.Close;sqlcom.Parameters.Add@GoodsIDSqlDbType.Biglnt.Value=P_int_GoodsID;sqlcom.Parameters.Add@GoodsNameSqlDbType.VarChar.
50.Value=P_str_GoodsNanic;sqlcom.Parameters.Add@PrName”SqlDbType.VarChar
100.Value=P_str_PrName;sqlcom.Parameters.Add@StoreName”Sq1DbTypc.VarChar1X.Value=P_str_StoreName;sqlcom.Parameters.Add@GoodsSpecSqlDbType.VarChar
50.Value=P_str_GoodsSpcc;sqlcom.Parameters.Add@GoodsUniSqlDbType.Char
8.Value=P_str_GoodsUnit;sqlccni.Parameters.Add@GoodsNum”SqlDbType.Biglnt.Value=P_int_GoodsNum;sqlcom.Parameters.Add@GoodsPriceSqlDbType.Money.Value=P_dml_GoodsPrice;sqlcom.Parameters.Add@HandlePeopleSqlDbType.VarChar
20.Value=P_str_HPeople;sqlcom.Parameters.Add°@ISRemarkHSqlDbType.VarCharlX.Value=P_sir_Remark;SqIParameterreturnValue=sqlcom.Parameters.AddretumValueSqlDhTypc.lnt4;returnValue.Direction=ParameierDirection.ReturnValue;sqlcon.Open;trysqlcom.ExecuteNonQueryO;IcatchExceptionex{MessageBox.Showex.Message;}finallysqlcom.Dispose;sqlcon.Close;sqlcon.Dispose;intP_int_returnValue=intreturnValue.Value;returnP_inl_returnValue;#endrcgion#region添加供应商信息///summary///添加供应商信息////summary///paramname=P_str_PrName供应商名称/param///vparaniname=P_str_PrPcoplc负责v/param///paramnanie=P_str_PrPhone供应商联系电话/param///vparan】name=P_str_PrFax供应商传真号码/3危111///vparan】name=P_int_PrRemark”备注/param///returns返回一个int类型的值/returnspublicintInsertProviderstringP_str_PrNamestringP_str_PrPeoplestringP_str_PrPhoncstringP_str_PrFaxstringP_int_PrRcmarkSqlConnectionsqlcon=datacon.getcon;SqlCommandsqlcom=newSqlCommandproc_insertProvider\sqlcon;sqlcom.Parameters.Add@PrNanie”SqlDbType.VarChar
100.Value=P_str_PrName;sqlcom.Parameters.AddCCSPrPcoplcSqlDbTypc.VarChar
20.Value=P_str_PrPeople;sqlcom.Parameters.Add@PrPhoneSqlDbType.VarChar
20.Value=P一str_PrPhone;sqlcom.Parameters.Add@PrFaxSqlDbType.VarChar
20.Value=P_str_PrFax;sqlcom.Parameters.Addn@PrRemarkHSqlDbTypc.VarChar1X.ValueP_int_PrRemark;SqlParameterreturnValue=sqlcom.Parameters.AddretuinValueSqlDbType.Int4;returnValue.Direction=ParameterDirection.ReturnValue;sqlcon.Open;trysqlcom.ExecuteNonQueryO;catchExceptionex。