仓库基础管理系统代码.docx

frmMain.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Diagnostics;namespace warehousepublic partial class frmMain : Formpublic frmMain()InitializeComponent();private void frmMain_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 = 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;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 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)/BasicInfo.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 BIfsi = 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.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.frmRGLook();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.ShowDialog();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();private 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 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) = DialogResult.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, 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);private 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(object 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(sender, 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 ToolStripMenuItem_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(object 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(); frmInManage.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace warehouse.GoodsManagepublic partial class frmISManage : Formwarehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate();public frmISManage()InitializeComponent();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_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.DataSource = 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 (txtGIPrice.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.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(), Convert.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);elseMessageBox.Show(, , MessageBoxButtons.OK, MessageBoxIcon.Information);frmISManage_Load(sender, e);private void btnDel_Click(object sender, EventArgs e)/ try/ /datacon.getcom(delete from tb_InStore where ISID=+ 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 (Exception ex)/ MessageBox.Show(ex.Message, , MessageBoxButtons.OK, MessageBoxIcon.Warning);/private void btnExit_Click(object 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.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 = Convert.ToString(dgvISManage7, dgvISManage.CurrentCell.RowIndex.Value).Trim();txtGIPrice.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 = 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.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.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.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace warehouse.GoodsManagepublic partial class frmOSManage : Formwarehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate();public frmOSManage()InitializeComponent();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 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(select 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(, , MessageBoxButtons.OK, MessageBoxIcon.Information);elsedatacon.getcom(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() + ,+ 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_Loa