仓库管理系统代码

《仓库管理系统代码》由会员分享，可在线阅读，更多相关《仓库管理系统代码（29页珍藏版）》请在装配图网上搜索。

1、wordfrmMain.csusing System;using System.Collections.Generic;using System.ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Diagnostics;namespace warehousepublic partial class frmMain : Formpublic frmMain()Initializeponent();private void frmM

2、ain_Load(object sender, EventArgs e)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

3、= 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;

4、btnGI.Enabled = false;btnSI.Enabled = false;btnRI.Enabled = false;btnUM.Enabled = false;private void btnIS_Click(object sender, EventArgs e)/GoodsManage.frmISManage GMfism = new warehouse.GoodsManage.frmISManage();/GMfism.Show();GMfism.ShowDialog();/private void btnOS_Click(object sender, EventArgs

5、e)/GoodsManage.frmOSManage GMfosm = new warehouse.GoodsManage.frmOSManage();GMfosm.ShowDialog();private void btnBR_Click(object sender, EventArgs e)/GoodsManage.frmBGManage GMfbgm = new warehouse.GoodsManage.frmBGManage();GMfbgm.ShowDialog();private void btnPI_Click(object sender, EventArgs e)/Basic

6、Info.frmPrInfo BIfpi = new warehouse.BasicInfo.frmPrInfo();BIfpi.ShowDialog();private void btnGI_Click(object sender, EventArgs e)/BasicInfo.frmGoodsInfo BIfgi = new warehouse.BasicInfo.frmGoodsInfo();BIfgi.ShowDialog();private void btnSI_Click(object sender, EventArgs e)/BasicInfo.frmStoreInfo BIfs

7、i = new warehouse.BasicInfo.frmStoreInfo();BIfsi.ShowDialog();private void btnISL_Click(object sender, EventArgs e)/LookandSum.frmISLook LSfisl = new warehouse.LookandSum.frmISLook();LSfisl.ShowDialog();private void btnSL_Click(object sender, EventArgs e)/LookandSum.frmGILook LSfgil = new warehouse.

8、LookandSum.frmGILook();LSfgil.ShowDialog();private void btnGOL_Click(object sender, EventArgs e)/LookandSum.frmBGLook LSfbgl = new warehouse.LookandSum.frmBGLook();LSfbgl.ShowDialog();private void btnGIL_Click(object sender, EventArgs e)/LookandSum.frmRGLook LSfrgl = new warehouse.LookandSum.frmRGLo

9、ok();LSfrgl.ShowDialog();private void btnOSL_Click(object sender, EventArgs e)/LookandSum.frmOSLook LSfosl = new warehouse.LookandSum.frmOSLook();LSfosl.ShowDialog();private void btnEP_Click(object sender, EventArgs e)/SystemSet.frmEditPwd HPfep = new warehouse.SystemSet.frmEditPwd();HPfep.ShowDialo

10、g();private void btnRI_Click(object sender, EventArgs e)/SystemSet.frmRightManage HPfrm = new warehouse.SystemSet.frmRightManage();HPfrm.ShowDialog();private void btnUM_Click(object sender, EventArgs e)/SystemSet.frmUserManage HPfum = new warehouse.SystemSet.frmUserManage();HPfum.ShowDialog();privat

11、e void btnAU_Click(object sender, EventArgs e)/SystemSet.frmAboutUs HPfau = new warehouse.SystemSet.frmAboutUs();HPfau.ShowDialog();private void btnCH_Click(object sender, EventArgs e)if (MessageBox.Show(, , MessageBoxButtons.OKCancel, MessageBoxIcon.Information) = DialogResult.OK)warehouse.frmLogin

12、 frmlogin = new frmLogin();this.Hide();frmlogin.Show();private void btnExit_Click(object sender, EventArgs e)/this.Close();/Application.Exit();private void frmMain_FormClosed(object sender, FormClosedEventArgs e)if (MessageBox.Show(, , MessageBoxButtons.OKCancel, MessageBoxIcon.Information) = Dialog

13、Result.OK)Application.Exit();elsefrmMain fmain = new frmMain();fmain.Show();private void ToolStripMenuItem_Click(object sender, EventArgs e)btnIS_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnOS_Click(sender,e);private void ToolStripMenuItem_Click(object sender,

14、 EventArgs e)btnBR_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnPI_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnGI_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnSI_Click(sender, e);pri

15、vate void ToolStripMenuItem_Click(object sender, EventArgs e)btnSL_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnISL_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnOSL_Click(sender, e);private void ToolStripMenuItem_Click(obj

16、ect sender, EventArgs e)btnGOL_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnGIL_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnEP_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnRI_Click(s

17、ender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnUM_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnAU_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 0;private void ToolStrip

18、MenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 1;private void ToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 2;private void ToolStripMenuItem_Click(object sender, EventArgs e)tabControl1.SelectedIndex = 3;private void ToolStripMenuItem_Click(obj

19、ect sender, EventArgs e)btnCH_Click(sender, e);private void ToolStripMenuItem_Click(object sender, EventArgs e)btnExit_Click(sender, e);private void toolStripStatusLabel6_Click(object sender, EventArgs e)System.Diagnostics.Process.Start(.renrenle.); frmInManage.csusing System;using System.Collection

20、s.Generic;using System.ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;public partial class frmISManage : Formwarehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate =

21、 new warehouse.BaseClass.DataOperate();public frmISManage()Initializeponent();private void frmISManage_Load(object sender, EventArgs e)dgvISManage.Controls.Add(hScrollBar1);/doperate.cboxBind(select StoreName from tb_Storage, tb_Storage, StoreName, cboxSName);/doperate.cboxBind(select PrName from tb

22、_Provider, tb_Provider, PrName, cboxPName);/DataSet myds = datacon.getds(select ISID as ,GoodsID as ,GoodsName as ,PrName as ,+ StoreName as ,GoodsSpec as ,GoodsUnit as ,GoodsNum as ,+ GoodsPrice as ,GoodsAPrice as ,ISDate as ,HandlePeople as ,+ ISRemark as from tb_InStore, tb_InStore);dgvISManage.D

23、ataSource = myds.Tables0;/datasetdatatable 0tb_InStoreprivate void btnAdd_Click(object sender, EventArgs e)if (txtISGID.Text = )MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtISGName.Text = )MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtGI

24、Price.Text = )MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtISGNum.Text = )MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtGSpec.Text = )MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);if (txtHPeople.Text = )MessageBox

25、.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);elseint P_int_returnValue = doperate.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(), C

26、onvert.ToDecimal(txtGIPrice.Text.Trim(), txtHPeople.Text.Trim(), txtISRemark.Text.Trim();if (P_int_returnValue = 100)MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);else if (P_int_returnValue = 200)MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);elseMessag

27、eBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);frmISManage_Load(sender, e);private void btnDel_Click(object sender, EventArgs e)/ try/ /datacon.get(delete from tb_InStore where ISID=+ Convert.ToString(dgvISManage0, dgvISManage.CurrentCell.RowIndex.Value).Trim() + );/Convert.ToString

28、(dataGridView11,dataGridView1.CurrentCell.RowIndex.Value).Trim();/ .MessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);frmISManage_Load(sender, e);/catch (Exception ex)/ MessageBox.Show(ex.Message, , MessageBoxButtons.OK, MessageBoxIcon.Warning);/private void btnExit_Click(object

29、sender, EventArgs e)this.Close();private void dgvISManage_CellClick(object sender, DataGridViewCellEventArgs e)/*datagridviewCellClickdatagridview. Convert.ToString(dataGridView11,dataGridView1.CurrentCell.RowIndex.Value).Trim(); */txtISGID.Text = Convert.ToString(dgvISManage1,dgvISManage.CurrentCel

30、l.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.Val

31、ue).Trim();txtGSpec.Text = Convert.ToString(dgvISManage5, dgvISManage.CurrentCell.RowIndex.Value).Trim();cboxGUnit.Text = Convert.ToString(dgvISManage6, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISGNum.Text = Convert.ToString(dgvISManage7, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGI

32、Price.Text = Convert.ToString(dgvISManage8, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGSPrice.Text = Convert.ToString(dgvISManage9, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtHPeople.Text = Convert.ToString(dgvISManage11, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtISRemark.Text

33、 = Convert.ToString(dgvISManage12, dgvISManage.CurrentCell.RowIndex.Value).Trim();private void txtGIPrice_TextChanged(object sender, EventArgs e)trytxtGSPrice.Text = Convert.ToString(Convert.ToDecimal(txtGIPrice.Text.Trim() * Convert.ToInt32(txtISGNum.Text.Trim().Trim();/Convert.ToDecimal(txtGIPrice

34、.Text.Trim()Decimal/String Decimal catch (Exception ex)MessageBox.Show(ex.Message, , MessageBoxButtons.OK, MessageBoxIcon.Warning);private void frmISManage_FormClosed(object sender, FormClosedEventArgs e)this.Close();private void button1_Click(object sender, EventArgs e)this.txtGIPrice.Text = ;this.

35、txtGSpec.Text = ;this.txtHPeople.Text = ;this.txtISGID.Text = ;this.txtISGName.Text = ;this.txtISGNum.Text = ;this.txtISRemark.Text = ;this.txtGIPrice.Text = ;this.txtGSPrice.Text = ;frmOsManage.csusing System;using System.Collections.Generic;using System.ponentModel;using System.Data;using System.D

36、rawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;public partial class frmOSManage : Formwarehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate();public frmOSManage()Initiali

37、zeponent();private void frmOSManage_Load(object sender, EventArgs e)dgvOSManage.Controls.Add(hScrollBar1);doperate.cboxBind(select distinct StoreName from tb_InStore, tb_InStore, StoreName, cboxSName);DataSet myds = datacon.getds(select OSID as ,StoreName as ,GoodsName as ,+ GoodsSpec as ,GoodsUnit

38、as ,GoodsNum as ,GoodsPrice as ,GoodsAPrice as ,+ OSDate as ,PGProvider as ,PGPeople as ,+ HandlePeople as ,OSRemark as from tb_OutStore, tb_OutStore);dgvOSManage.DataSource = myds.Tablestb_OutStore;private void btnAdd_Click(object sender, EventArgs e)trySqlDataReader sqlread = datacon.getread(selec

39、t GoodsNum from tb_GoodsInfo+ where StoreName= + cboxSName.Text.Trim() + and GoodsName=+ cboxGName.Text.Trim() + and GoodsSpec= + cboxGSpec.Text.Trim() + );if (sqlread.Read()if (Convert.ToInt32(txtOSGNum.Text.Trim() Convert.ToInt32(sqlreadGoodsNum.ToString().Trim()MessageBox.Show(, , MessageBoxButto

40、ns.OK, MessageBoxIcon.Information);elsedatacon.get(insert into tb_OutStore(StoreName,GoodsName,GoodsSpec,GoodsUnit, + GoodsNum,GoodsPrice,PGProvider,PGPeople,HandlePeople,OSRemark)+ values( + cboxSName.Text.Trim() + , + cboxGName.Text.Trim() + , + cboxGSpec.Text.Trim() + , + cboxGUnit.Text.Trim() +

41、,+ 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 (Exce

42、ption ex)MessageBox.Show(ex.Message, , MessageBoxButtons.OK, MessageBoxIcon.Warning);private void btnDel_Click(object sender, EventArgs e)trydatacon.get(delete from tb_OutStore where OSID=+ Convert.ToString(dgvOSManage0, dgvOSManage.CurrentCell.RowIndex.Value).Trim() + );MessageBox.Show(, , MessageB

43、oxButtons.OK, MessageBoxIcon.Information);frmOSManage_Load(sender, e);catch (Exception ex)MessageBox.Show(ex.Message, , MessageBoxButtons.OK, MessageBoxIcon.Warning);private void btnExit_Click(object sender, EventArgs e)this.Close();private void dgvOSManage_CellClick(object sender, DataGridViewCellE

44、ventArgs e)cboxSName.Text = Convert.ToString(dgvOSManage1, dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGName.Text = Convert.ToString(dgvOSManage2, dgvOSManage.CurrentCell.RowIndex.Value).Trim();cboxGSpec.Text = Convert.ToString(dgvOSManage3, dgvOSManage.CurrentCell.RowIndex.Value).Trim();cbox

45、GUnit.Text = Convert.ToString(dgvOSManage4, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSGNum.Text = Convert.ToString(dgvOSManage5, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtGOPrice.Text = Convert.ToString(dgvOSManage6, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtGSPrice.Text =

46、Convert.ToString(dgvOSManage7, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSUnit.Text = Convert.ToString(dgvOSManage9, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSPeople.Text = Convert.ToString(dgvOSManage10, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtHPeople.Text = Convert.ToS

47、tring(dgvOSManage11, dgvOSManage.CurrentCell.RowIndex.Value).Trim();txtOSRemark.Text = Convert.ToString(dgvOSManage12, dgvOSManage.CurrentCell.RowIndex.Value).Trim();private void cboxSName_SelectedIndexChanged(object sender, EventArgs e)doperate.cboxBind(select distinct GoodsName from tb_InStore whe

48、re StoreName=+ cboxSName.Text.Trim() + , tb_InStore, GoodsName, cboxGName);private void cboxGName_SelectedIndexChanged(object sender, EventArgs e)doperate.cboxBind(select distinct GoodsSpec from tb_InStore where StoreName=+ cboxSName.Text.Trim() + and GoodsName= + cboxGName.Text.Trim()+ , tb_InStore

49、, GoodsSpec, cboxGSpec);SqlDataReader sqlread = datacon.getread(select GoodsUnit,GoodsOutPrice,GoodsNum from tb_GoodsInfo+ where StoreName= + cboxSName.Text.Trim()+ and GoodsName= + cboxGName.Text.Trim() + );if (sqlread.Read()this.cboxGUnit.Text = sqlreadGoodsUnit.ToString().Trim();this.txtGOPrice.T

50、ext = qlreadGoodsOutPrice.ToString().Trim();this.tbxshenxia.Text = sqlreadGoodsNum.ToString().Trim();sqlread.Close();private void txtOSGNum_TextChanged(object sender, EventArgs e)trytxtGSPrice.Text = Convert.ToString(Convert.ToDecimal(txtGOPrice.Text.Trim()* Convert.ToInt32(txtOSGNum.Text.Trim().Tri

51、m();catch (Exception ex)MessageBox.Show(ex.Message, , MessageBoxButtons.OK, MessageBoxIcon.Warning);private void frmOSManage_FormClosed(object sender, FormClosedEventArgs e)this.Close();(frmBGManage.cs)using System;using System.Collections.Generic;using System.ponentModel;using System.Data;using Sys

52、tem.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;public partial class frmBGManage : Formwarehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate();public frmBGManage()Ini

53、tializeponent();private void frmBGManage_Load(object sender, EventArgs e)dgvBGManage.Controls.Add(hScrollBar1);doperate.cboxBind(select StoreName from tb_Storage, tb_Storage, StoreName, cboxSName);DataSet myds = datacon.getds(select BGID as ,GoodsName as ,StoreName as ,+ GoodsSpec as ,GoodsNum as ,B

54、GDate as ,HandlePeople as ,+ BGPeople as ,BGUnit as ,BGRemark as from tb_BorrowGoods, tb_BorrowGoods);dgvBGManage.DataSource = myds.Tables0;private void btnAdd_Click(object sender, EventArgs e)tryif (!doperate.validateNum(txtBGNum.Text.Trim()errorPrBGNum.SetError(txtBGNum, );elseerrorPrBGNum.Clear()

55、;SqlDataReader sqlread = datacon.getread(select GoodsName StoreName,GoodsNum from tb_GoodsInfo+ where StoreName= + cboxSName.Text.Trim() + and GoodsName=+ cboxGName.Text.Trim() + and GoodsSpec= + cboxGSpec.Text.Trim() + );if (sqlread.Read()if (Convert.ToInt32(sqlreadGoodsNum.ToString().Trim() = Convert.ToInt32(this.tbxshenxia.Text.Trim()MessageBox.Show(, , MessageBoxBut