仓库管理系统代码

系统主界面（frmMain.cs）using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Diagnostics;namespace warehouse{public partial class frmMain : Form{public 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, rmation) == 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, rmation) == DialogResult.OK){Application.Exit();}else{frmMain 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.cs）using System;using System.Collections.Generic;using ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace warehouse.GoodsManage{public partial class frmISManage : Form{warehouse.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.Tables[0];//dataset中的第一个datatable 0<=>"tb_InStore"}private void btnAdd_Click(object sender, EventArgs e){if (txtISGID.Text == ""){MessageBox.Show("货物编号不能为空！", "信息", MessageBoxButtons.OK, rmation);}if (txtISGName.Text == ""){MessageBox.Show("货物名称不能为空", "信息", MessageBoxButtons.OK, rmation);}if (txtGIPrice.Text == ""){MessageBox.Show("货物单价不能为空！", "信息", MessageBoxButtons.OK, rmation);}if (txtISGNum.Text == ""){MessageBox.Show("入库数量不能为空", "信息", MessageBoxButtons.OK,rmation);}if (txtGSpec.Text == ""){MessageBox.Show("货物规格不能为空", "信息", MessageBoxButtons.OK, rmation);}if (txtHPeople.Text == ""){MessageBox.Show("经手不能为空", "信息", MessageBoxButtons.OK, rmation);}else{int 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, rmation);}else if (P_int_returnValue == 200){MessageBox.Show("这类货物已经存在惟一编号！", "信息", MessageBoxButtons.OK, rmation);}else{MessageBox.Show("货物入库成功！", "信息", MessageBoxButtons.OK, rmation);frmISManage_Load(sender, e);}}}private void btnDel_Click(object sender, EventArgs e){// try// {//删除下面数据源控件中的，指示的数据项datacon.getcom("delete from tb_InStore where ISID="+ Convert.ToString(dgvISManage[0, dgvISManage.CurrentCell.RowIndex].Value).Trim() + "");//Convert.ToString(dataGridView1[1,dataGridView1.CurrentCell.RowIndex].Value).Tr im();// 来取得所选中的那行数据某列的值...MessageBox.Show("货物删除成功！", "信息", MessageBoxButtons.OK, rmation);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)/*datagridview控件有一个CellClick事件是当单击datagridview控件的任意部分是发生.然后再用Convert.ToString(dataGridView1[1,dataGridView1.CurrentCell.RowIndex].Value).Trim (); 来取得所选中的那行数据某列的值*/{txtISGID.Text = Convert.ToString(dgvISManage[1,dgvISManage.CurrentCell.RowIndex].Value).Trim(); txtISGName.Text = Convert.ToString(dgvISManage[2, dgvISManage.CurrentCell.RowIndex].Value).Trim();cboxSName.Text = Convert.ToString(dgvISManage[4, dgvISManage.CurrentCell.RowIndex].Value).Trim();cboxPName.Text = Convert.ToString(dgvISManage[3, dgvISManage.CurrentCell.RowIndex].Value).Trim();txtGSpec.Text = Convert.ToString(dgvISManage[5, dgvISManage.CurrentCell.RowIndex].Value).Trim();cboxGUnit.Text = Convert.ToString(dgvISManage[6, dgvISManage.CurrentCell.RowIndex].Value).Trim();txtISGNum.Text = Convert.ToString(dgvISManage[7, dgvISManage.CurrentCell.RowIndex].Value).Trim();txtGIPrice.Text = Convert.ToString(dgvISManage[8,dgvISManage.CurrentCell.RowIndex].Value).Trim();txtGSPrice.Text = Convert.ToString(dgvISManage[9, dgvISManage.CurrentCell.RowIndex].Value).Trim();txtHPeople.Text = Convert.ToString(dgvISManage[11, dgvISManage.CurrentCell.RowIndex].Value).Trim();txtISRemark.Text = Convert.ToString(dgvISManage[12, dgvISManage.CurrentCell.RowIndex].Value).Trim();}private void txtGIPrice_TextChanged(object sender, EventArgs e){try{txtGSPrice.Text = Convert.ToString(Convert.ToDecimal(txtGIPrice.Text.Trim()) * Convert.ToInt32(txtISGNum.Text.Trim())).Trim();//Convert.ToDecimal(txtGIPrice.Text.Trim())将文本值转为Decimal 数值//将数字的指定String 表示形式转换为等效的Decimal 数字。