(仓库管理)仓库管理系统代码

系统主界面(frmMain.cs)usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Diagnostics;namespacewarehousepublicpartialclassfrmMain:FormpublicfrmMain()InitializeComponent();privatevoidfrmMain_Load(objectsender,EventArgse)tsslUser.Text=操作用户权限：+frmLogin.M_str_right.ToString().Trim();tsslDate.Text=DateTime.Today.ToLongDateString();tsslTime.Text=登录系统时间：+DateTime.Now.ToShortTimeString();if(frmLogin.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;btnPI.Enabled=false;btnGI.Enabled=false;btnSI.Enabled=false;btnRI.Enabled=false;btnUM.Enabled=false;privatevoidbtnIS_Click(objectsender,EventArgse)/入库管理newnewnewGoodsManage.frmISManageGMfism=warehouse.GoodsManage.frmISManage();/GMfism.Show();GMfism.ShowDialog();/这两个函数就看谁获得焦点，前者父窗口也可获得焦点，后者只有新创建的窗体privatevoidbtnOS_Click(objectsender,EventArgse)/出库管理GoodsManage.frmOSManageGMfosm=warehouse.GoodsManage.frmOSManage();GMfosm.ShowDialog();privatevoidbtnBR_Click(objectsender,EventArgse)/借货还货管理GoodsManage.frmBGManageGMfbgm=warehouse.GoodsManage.frmBGManage();GMfbgm.ShowDialog();privatevoidbtnPI_Click(objectsender,EventArgse)/供应商设置BasicInfo.frmPrInfoBIfpi=newwarehouse.BasicInfo.frmPrInfo();BIfpi.ShowDialog();privatevoidbtnGI_Click(objectsender,EventArgse)/货物档案设置BasicInfo.frmGoodsInfoBIfgi=newwarehouse.BasicInfo.frmGoodsInfo();BIfgi.ShowDialog();privatevoidbtnSI_Click(objectsender,EventArgse)/仓库设置BasicInfo.frmStoreInfoBIfsi=newwarehouse.BasicInfo.frmStoreInfo();BIfsi.ShowDialog();privatevoidbtnISL_Click(objectsender,EventArgse)/入库查询LookandSum.frmISLookLSfisl=newwarehouse.LookandSum.frmISLook();LSfisl.ShowDialog();privatevoidbtnSL_Click(objectsender,EventArgse)/库存查询LookandSum.frmGILookLSfgil=newwarehouse.LookandSum.frmGILook();LSfgil.ShowDialog();LookandSum.frmBGLookLSfbgl=newwarehouse.LookandSum.frmBGLook();LSfbgl.ShowDialog();privatevoidbtnGIL_Click(objectsender,EventArgse)/货物归还查询LookandSum.frmRGLookLSfrgl=newwarehouse.LookandSum.frmRGLook();LSfrgl.ShowDialog();privatevoidbtnOSL_Click(objectsender,EventArgse)/出库查询LookandSum.frmOSLookLSfosl=newwarehouse.LookandSum.frmOSLook();LSfosl.ShowDialog();privatevoidbtnEP_Click(objectsender,EventArgse)/更改密码SystemSet.frmEditPwdHPfep=newwarehouse.SystemSet.frmEditPwd();HPfep.ShowDialog();privatevoidbtnRI_Click(objectsender,EventArgse)/权限管理SystemSet.frmRightManageHPfrm=newwarehouse.SystemSet.frmRightManage();HPfrm.ShowDialog();privatevoidbtnUM_Click(objectsender,EventArgse)/用户管理SystemSet.frmUserManageHPfum=newwarehouse.SystemSet.frmUserManage();HPfum.ShowDialog();privatevoidbtnAU_Click(objectsender,EventArgse)/关于本系统SystemSet.frmAboutUsHPfau=newwarehouse.SystemSet.frmAboutUs();HPfau.ShowDialog();privatevoidbtnCH_Click(objectsender,EventArgse)if(MessageBox.Show(你真的要注销当前用户,提示,MessageBoxButtons.OKCancel,MessageBoxIcon.Information)=DialogResult.OK)warehouse.frmLoginfrmlogin=newfrmLogin();this.Hide();frmlogin.Show();privatevoidbtnExit_Click(objectsender,EventArgse)/退出系统this.Close();/Application.Exit();privatevoidfrmMain_FormClosed(objectsender,FormClosedEventArgse)if(MessageBox.Show(您真的要退出本系统吗？,提示,MessageBoxButtons.OKCancel,MessageBoxIcon.Information)=DialogResult.OK)Application.Exit();elsefrmMainfmain=newfrmMain();fmain.Show();privatevoid入库管理ToolStripMenuItem_Click(objectsender,EventArgse)btnIS_Click(sender,e);privatevoid出库管理ToolStripMenuItem_Click(objectsender,EventArgse)btnOS_Click(sender,e);privatevoid借货还货ToolStripMenuItem_Click(objectsender,EventArgse)btnBR_Click(sender,e);privatevoid供货商设置ToolStripMenuItem_Click(objectsender,EventArgse)btnPI_Click(sender,e);privatevoid货物档案设置ToolStripMenuItem_Click(objectsender,EventArgse)btnGI_Click(sender,e);privatevoid仓库设置ToolStripMenuItem_Click(objectsender,EventArgse)btnSI_Click(sender,e);privatevoid库存查询ToolStripMenuItem_Click(objectsender,EventArgse)btnSL_Click(sender,e);privatevoid入库查询ToolStripMenuItem_Click(objectsender,EventArgse)btnISL_Click(sender,e);privatevoid出库查询ToolStripMenuItem_Click(objectsender,EventArgse)btnOSL_Click(sender,e);privatevoid货物借出查询ToolStripMenuItem_Click(objectsender,EventArgse)btnGOL_Click(sender,e);privatevoid货物归还查询ToolStripMenuItem_Click(objectsender,EventArgse)btnGIL_Click(sender,e);privatevoid更改密码ToolStripMenuItem_Click(objectsender,EventArgse)btnEP_Click(sender,e);privatevoid权限设置ToolStripMenuItem_Click(objectsender,EventArgse)btnRI_Click(sender,e);privatevoid用户管理ToolStripMenuItem_Click(objectsender,EventArgse)btnUM_Click(sender,e);privatevoid关于本系统ToolStripMenuItem_Click(objectsender,EventArgse)btnAU_Click(sender,e);privatevoid货物管理ToolStripMenuItem_Click(objectsender,EventArgse)tabControl1.SelectedIndex=0;sender,newprivatevoid基本档案ToolStripMenuItem_Click(objectsender,EventArgse)tabControl1.SelectedIndex=1;privatevoid查询统计ToolStripMenuItem_Click(objectsender,EventArgse)tabControl1.SelectedIndex=2;privatevoid系统设置ToolStripMenuItem_Click(objectEventArgse)tabControl1.SelectedIndex=3;privatevoid注销ToolStripMenuItem_Click(objectsender,EventArgse)btnCH_Click(sender,e);privatevoid退出系统ToolStripMenuItem_Click(objectsender,EventArgse)btnExit_Click(sender,e);privatevoidtoolStripStatusLabel6_Click(objectsender,EventArgse)System.Diagnostics.Process.Start();货物档案管理(入库frmInManage.cs)usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarehouse.GoodsManagepublicpartialclassfrmISManage:Formwarehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperatedoperate=warehouse.BaseClass.DataOperate();publicfrmISManage()InitializeComponent();privatevoidfrmISManage_Load(objectsender,EventArgse)dgvISManage.Controls.Add(hScrollBar1);/数据源控件中添加了一个水平滚动条doperate.cboxBind(selectStoreNamefromtb_Storage,tb_Storage,StoreName,cboxSName);/仓库名字显示出来doperate.cboxBind(selectPrNamefromtb_Provider,tb_Provider,PrName,cboxPName);/计量单位显示出来DataSetmyds=datacon.getds(selectISIDas入库编号,GoodsIDas货物编号,GoodsNameas货物名称,PrNameas供应商名称,+StoreNameas单位,GoodsNumas入库数量,+GoodsPriceas仓库名称,GoodsSpecas货物规格,GoodsUnitas计量货物单价,GoodsAPriceas总金额,ISDateas入库日期,HandlePeopleas经手,+ISRemarkasdgvISManage.DataSource备注fromtb_InStore,tb_InStore);=myds.Tables0;/dataset中的第一个datatable0tb_InStoreprivatevoidbtnAdd_Click(objectsender,EventArgse)if(txtISGID.Text=)MessageBox.Show(MessageBoxIcon.Information);货物编号不能为空！,信息,MessageBoxButtons.OK,if(txtISGName.Text=)MessageBox.Show(货物名称不能为空,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);if(txtGIPrice.Text=)MessageBox.Show(货物单价不能为空！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);if(txtISGNum.Text=)MessageBox.Show(入库数量不能为空,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);if(txtGSpec.Text=)MessageBox.Show(MessageBoxIcon.Information);if(txtHPeople.Text=)MessageBox.Show(MessageBoxIcon.Information);elseint货物规格不能为空,信息,MessageBoxButtons.OK,经手不能为空,信息,MessageBoxButtons.OK,P_int_returnValuedoperate.InsertGoods(Convert.ToInt32(txtISGID.Text.Trim(),txtISGName.Text.Trim(),cboxPName.Text.Trim(),cboxSName.Text.Trim(),txtGSpec.Text.Trim(),cboxGUnit.Text.Trim(),Convert.ToInt32(txtISGNum.Text.Trim(),Convert.ToDecimal(txtGIPrice.Text.Trim(),txtHPeople.Text.Trim(),txtISRemark.Text.Trim();if(P_int_returnValue=100)MessageBox.Show(该货物号已经被占用！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);elseif(P_int_returnValue=200)MessageBox.Show(这类货物已经存在惟一编号！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);elseMessageBox.Show(货物入库成功！,信息MessageBoxButtons.OK,MessageBoxIcon.Information);frmISManage_Load(sender,e);privatevoidbtnDel_Click(objectsender,EventArgse)/try/删除下面数据源控件中的，指示的数据项datacon.getcom(deletefromtb_InStorewhereISID=+Convert.ToString(dgvISManage0,dgvISManage.CurrentCell.RowIndex.Value).Trim()+);/Convert.ToString(dataGridView11,dataGridView1.CurrentCell.RowIndex.Value).Trim();/来取得所选中的那行数据某列的值.MessageBox.Show(货物删除成功！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);frmISManage_Load(sender,e);/catch(Exceptionex)/MessageBox.Show(ex.Message,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);/privatevoidbtnExit_Click(objectsender,EventArgse)this.Close();privatevoiddgvISManage_CellClick(objectsender,DataGridViewCellEventArgse)/*datagridview控件有一个CellClick事件是当单击datagridview控件的任意部分是发生.然后再用Convert.ToString(dataGridView11,dataGridView1.CurrentCell.RowIndex.Value).Trim();来取得所选中的那行数据某列的值*/txtISGID.Text=Convert.ToString(dgvISManage1,dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISGName.Text=Convert.ToString(dgvISManage2,dgvISManage.CurrentCell.RowIndex.Value).Trim();cboxSName.Text=Convert.ToString(dgvISManage4,dgvISManage.CurrentCell.RowIndex.Value).Trim();cboxPName.Text=Convert.ToString(dgvISManage3,dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGSpec.Text=Convert.ToString(dgvISManage5,dgvISManage.CurrentCell.RowIndex.Value).Trim();cboxGUnit.Text=Convert.ToString(dgvISManage6,dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISGNum.Text=dgvISManage.CurrentCell.RowIndex.Value).Trim();Convert.ToString(dgvISManage7,txtGIPrice.Text=Convert.ToString(dgvISManage8,dgvISManage.CurrentCell.RowIndex.Value).Trim();Convert.ToString(dgvISManage9,Convert.ToString(dgvISManage11,Convert.ToString(dgvISManage12,txtGSPrice.Text=dgvISManage.CurrentCell.RowIndex.Value).Trim();txtHPeople.Text=dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISRemark.Text=dgvISManage.CurrentCell.RowIndex.Value).Trim();privatevoidtxtGIPrice_TextChanged(objectsender,EventArgse)trytxtGSPrice.TextConvert.ToString(Convert.ToDecimal(txtGIPrice.Text.Trim()Convert.ToInt32(txtISGNum.Text.Trim().Trim();将文本值转为DecimalDecimal数字。MessageBoxButtons.OK,/Convert.ToDecimal(txtGIPrice.Text.Trim()数值/将数字的指定String表示形式转换为等效的catch(Exceptionex)MessageBox.Show(ex.Message,警告MessageBoxIcon.Warning);privatevoidfrmISManage_FormClosed(objectsender,FormClosedEventArgse)this.Close();privatevoidbutton1_Click(objectsender,EventArgse)this.txtGIPrice.Text=;this.txtGSpec.Text=;this.txtHPeople.Text=;this.txtISGID.Text=;this.txtISGName.Text=;this.txtISGNum.Text=;this.txtISRemark.Text=;this.txtGIPrice.Text=;this.txtGSPrice.Text=;出库管理(frmOsManage.cs)usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarehouse.GoodsManagepublicpartialclassfrmOSManage:Formwarehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DataOperate();publicfrmOSManage()InitializeComponent();privatevoidfrmOSManage_Load(objectsender,EventArgse)dgvOSManage.Controls.Add(hScrollBar1);StoreNamefromtb_InStore,出库编号,StoreNameas仓计量单位,GoodsNumas出库数提货单位,PGPeopleas提货,doperate.cboxBind(selectdistincttb_InStore,StoreName,cboxSName);DataSetmyds=datacon.getds(selectOSIDas库名称,GoodsNameas货物名称,+GoodsSpecas规格,GoodsUnitas量,GoodsPriceas价格,GoodsAPriceas总金额,+OSDateas出库日期,PGProvideras+HandlePeopleas经手,OSRemarkas备注fromtb_OutStore,tb_OutStore);dgvOSManage.DataSource=myds.Tablestb_OutStore;privatevoidbtnAdd_Click(objectsender,EventArgse)trySqlDataReadersqlread=datacon.getread(selectGoodsNumfromtb_GoodsInfo+whereStoreName=+cboxSName.Text.Trim()+andGoodsName=+cboxGName.Text.Trim()+andGoodsSpec=+cboxGSpec.Text.Trim()+if(sqlread.Read()if(Convert.ToInt32(txtOSGNum.Text.Trim()Convert.ToInt32(sqlreadGoodsNum.ToString().Trim()MessageBox.Show(仓库中没有足够的货物！,提示,MessageBoxButtons.OK,MessageBoxIcon.Information);elsedatacon.getcom(insertintotb_OutStore(StoreName,GoodsName,GoodsSpec,GoodsUnit,+GoodsNum,GoodsPrice,PGProvider,PGPeople,HandlePeople,OSRemark)+values(+cboxSName.Text.Trim()+,+cboxGName.Text.Trim()+,+cboxGSpec.Text.Trim()+,+cboxGUnit.Text.Trim()+,+txtOSGNum.Text.Trim()+,+txtGOPrice.Text.Trim()+,+txtOSUnit.Text.Trim()+,+txtOSPeople.Text.Trim()+,+txtHPeople.Text.Trim()+,+txtOSRemark.Text.Trim()+);MessageBox.Show(货物出库成功！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);frmOSManage_Load(sender,e);sqlread.Close();catch(Exceptionex)MessageBox.Show(ex.Message,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);privatevoidbtnDel_Click(objectsender,EventArgse)trydatacon.getcom(deletefromtb_OutStorewhereOSID=+Convert.ToString(dgvOSManage0,dgvOSManage.CurrentCell.RowIndex.Value).Trim()+);MessageBox.Show(货物删除成功！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);frmOSManage_Load(sender,e);catch(Exceptionex)MessageBox.Show(ex.Message,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);privatevoidbtnExit_Click(objectsender,EventArgse)this.Close();privatevoidDataGridViewCellEventArgse)cboxSName.TextdgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGName.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGSpec.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGUnit.Text=dgvOSManage_CellClick(objectsender,Convert.ToString(dgvOSManage1,Convert.ToString(dgvOSManage2,Convert.ToString(dgvOSManage3,Convert.ToString(dgvOSManage4,dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSGNum.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtGOPrice.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtGSPrice.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSUnit.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSPeople.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtHPeople.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSRemark.Text=dgvOSManage.CurrentCell.RowIndex.Value).Trim();privatevoidcboxSName_SelectedIndexChanged(objectsender,EventArgse)doperate.cboxBind(selectStoreName=Convert.ToString(dgvOSManage5,Convert.ToString(dgvOSManage6,Convert.ToString(dgvOSManage7,Convert.ToString(dgvOSManage9,Convert.ToString(dgvOSManage10,Convert.ToString(dgvOSManage11,Convert.ToString(dgvOSManage12,distinctGoodsNamefromtb_InStorewherecboxSName.Text.Trim()+tb_InStore,GoodsName,cboxGName);privatevoidcboxGName_SelectedIndexChanged(objectsender,EventArgse)doperate.cboxBind(selectStoreName=distinctGoodsSpecfromtb_InStorewherecboxSName.Text.Trim()+andGoodsName=+cboxGName.Text.Trim()+,tb_InStore,GoodsSpec,cboxGSpec);SqlDataReadersqlread=datacon.getread(selectGoodsUnit,GoodsOutPrice,GoodsNumfromtb_GoodsInfo+whereStoreName=+cboxSName.Text.Trim()+andGoodsName=+cboxGName.Text.Trim()+);if(sqlread.Read()this.cboxGUnit.Text=sqlreadGoodsUnit.ToString().Trim();this.txtGOPrice.Text=qlreadGoodsOutPrice.ToString().Trim();this.tbxshenxia.Text=sqlreadGoodsNum.ToString().Trim();sqlread.Close();privatevoidtxtOSGNum_TextChanged(objectsender,EventArgse)trytxtGSPrice.TextConvert.ToString(Convert.ToDecimal(txtGOPrice.Text.Trim()*Convert.ToInt32(txtOSGNum.Text.Trim().Trim();catch(Exceptionex)MessageBox.Show(ex.Message,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);privatevoidfrmOSManage_FormClosed(objectsender,FormClosedEventArgse)this.Close();借货管理(frmBGManage.cs)usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespacewarehouse.GoodsManagepublicpartialclassfrmBGManage:Formwarehouse.BaseClass.DataCondatacon=newwarehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperatedoperate=newwarehouse.BaseClass.DataOperate();publicfrmBGManage()InitializeComponent();privatevoidfrmBGManage_Load(objectsender,EventArgse)dgvBGManage.Controls.Add(hScrollBar1);doperate.cboxBind(selectStoreNamefromtb_Storage,tb_Storage,StoreName,cboxSName);DataSetmyds=datacon.getds(selectBGIDas借货编号,GoodsNameas货物名称,StoreNameas仓库名称,+GoodsSpecas货物规格,GoodsNumas借出数量,BGDateas借货日期,HandlePeopleas经手,+BGPeopleas借货，BGUnitas借货单位，BGRemarkas备注fromtb_BorrowGoods,tb_BorrowGoods);dgvBGManage.DataSource=myds.Tables0;privatevoidbtnAdd_Click(objectsender,EventArgse)tryif(!doperate.validateNum(txtBGNum.Text.Trim()errorPrBGNum.SetError(txtBGNum,输入必须为数字！);elseerrorPrBGNum.Clear();SqlDataReadersqlread=datacon.getread(selectGoodsNameStoreName,GoodsNumfromtb_GoodsInfo+whereStoreName=+cboxSName.Text.Trim()+andGoodsName=+cboxGName.Text.Trim()+andGoodsSpec=+cboxGSpec.Text.Trim()+);if(sqlread.Read()if(Convert.ToInt32(sqlreadGoodsNum.ToString().Trim()=Convert.ToInt32(this.tbxshenxia.Text.Trim()MessageBox.Show(没有足够的货物供您借取！,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);txtBGNum.Text=;txtBGNum.Focus();elsedatacon.getcom(insertintotb_BorrowGoods(StoreName,GoodsName,GoodsSpec,+GoodsNum,HandlePeople,BGPeople,BGUnit,BGRemark)+values(+cboxSName.Text.Trim()+,+cboxGName.Text.Trim()+,+cboxGSpec.Text.Trim()+,+txtBGNum.Text.Trim()+,+txtHPeople.Text.Trim()+,+JtxtBGPeople.Text.Trim()+,+txtBGDepart.Text.Trim()+,+JtxtBGRemark.Text.Trim()+);MessageBox.Show(借货成功！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);frmBGManage_Load(sender,e);sqlread.Close();catch(Exceptionex)MessageBox.Show(ex.Message,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);privatevoidbtnDel_Click(objectsender,EventArgse)trydatacon.getcom(deletefromtb_BorrowGoodswhereBGID=+Convert.ToString(dgvBGManage0,dgvBGManage.CurrentCell.RowIndex.Value).Trim()+);MessageBox.Show(借货资料删除成功！,信息,MessageBoxButtons.OK,MessageBoxIcon.Information);frmBGManage_Load(sender,e);catch(Exceptionex)MessageBox.Show(ex.Message,警告,MessageBoxButtons.OK,MessageBoxIcon.Warning);privatevoidbtnRGManage_Click(objectsender,EventArgse)GoodsManage.frmRGManageGMfrgm=newfrmRGManage();this.Hide();GMfrgm.ShowDialog();privatevoidbtnExit_Click(objectsender,EventArgse)this.Close();privatevoidcboxSName_SelectedIndexChanged(objectsender,EventArgse)doperate.cboxBind(selectdistinctGoodsNamefromtb_GoodsInfowhereStoreName=+cboxSName.Text.Trim()+,tb_GoodsInfo,GoodsName,cboxGName);privatevoidcboxGName_SelectedIndexChanged(objectsender,EventArgse)doperate.cboxBind(selectdistinctGoodsSpecfromtb_GoodsInfowhereStoreName=+cboxSName.Text.Trim()+andGoodsName=+cboxGName.Text.Trim()+,tb_GoodsInfo,GoodsSpec,cboxGSpec);SqlDataReadersqlreader=datacon.getread(selectGoodsName,StoreName,GoodsNumfromtb_GoodsInfowhereStoreName=+cboxSName.Text.Trim()+andGoodsName=+cboxGName.Text.Trim()+);if(sqlreader.Read()this.tbxshenxia.Text=sqlreaderGoodsNum.ToString().Trim();sqlreader.Close();privatee)cboxSName.TextvoiddgvBGManage_CellClick(objectsender,ataGridViewCellEventArgsConvert.ToString(dgvBGManage2,dgvBGManage.CurrentCell.RowIndex.Va