当前位置:文档之家› 仓库管理系统代码大全

仓库管理系统代码大全

系统主函数(program.cs)using System;using System.Collections.Generic;using System.Windows.Forms;namespace warehouse{static class Program{/// <summary>/// 应用程序的主入口点。

/// </summary>[STAThread]static void Main(){Application.EnableVisualStyles();Application.SetCompatibleTextRenderingDefault(false);Application.Run(new frmLogin());//运行一个登陆对象}}}集的常规信息using System.Reflection;using pilerServices;using System.Runtime.InteropServices;// 有关程序集的常规信息通过下列属性集// 控制。

更改这些属性值可修改// 与程序集关联的信息。

[assembly: AssemblyTitle("warehouse")][assembly: AssemblyDescription("")][assembly: AssemblyConfiguration("")][assembly: AssemblyCompany("")][assembly: AssemblyProduct("warehouse")][assembly: AssemblyCopyright("所有2009")][assembly: AssemblyTrademark("")][assembly: AssemblyCulture("")]// 将ComVisible 设置为false 使此程序集中的类型// 对COM 组件不可见。

如果需要从COM 访问此程序集中的类型,// 则将该类型上的ComVisible 属性设置为true。

[assembly: ComVisible(false)]// 如果此项目向COM 公开,则下列GUID 用于类型库的ID [assembly: Guid("063bd674-c4cc-4dc9-81ee-3791409e9189")] // 程序集的版本信息由下面个值组成:// 主版本// 次版本// 部版本号// 修订号//[assembly: AssemblyVersion("1.0.0.0")][assembly: AssemblyFileVersion("1.0.0.0")]数据库连接类(DataCon.cs):using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;namespace warehouse.BaseClass{class DataCon{#region 建立数据库连接/// <summary>/// 建立数据库连接./// </summary>/// <returns>返回SqlConnection对象</returns>public SqlConnection getcon(){string M_str_sqlcon = "DataSource=(local);Database=db_warehouse;user id=sa;pwd= ";SqlConnection myCon = new SqlConnection(M_str_sqlcon);return myCon;}#endregion#region 执行SqlCommand命令/// <summary>/// 执行SqlCommand/// </summary>/// <param name="M_str_sqlstr">SQL语句</param>public void getcom(string M_str_sqlstr){SqlConnection sqlcon = this.getcon();sqlcon.Open();SqlCommand sqlcom = new SqlCommand(M_str_sqlstr,sqlcon);sqlcom.ExecuteNonQuery();//返回受影响的行数sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}#endregion#region 创建DataSet对象读取数据/// <summary>/// 创建一个DataSet对象/// </summary>/// <param name="M_str_sqlstr">SQL语句</param>/// <param name="M_str_table">表名</param>/// <returns>返回DataSet对象</returns>public DataSet getds(string M_str_sqlstr, string M_str_table){SqlConnection sqlcon = this.getcon();sqlcon.Open();SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);DataSet myds = new DataSet();sqlda.Fill(myds, M_str_table);return myds;}#endregion#region 创建SqlDataReader对象读取数据/// <summary>/// 创建一个SqlDataReader对象/// </summary>/// <param name="M_str_sqlstr">SQL语句</param>/// <returns>返回SqlDataReader对象</returns>public SqlDataReader getread(string M_str_sqlstr){SqlConnection sqlcon = this.getcon();SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);sqlcon.Open();SqlDataReader sqlread =sqlcom.ExecuteReader(CommandBehavior.CloseConnection);//方法的参数表示如果关闭关联的对象sqlread则关联的连接sqlcon也关闭了return sqlread;}#endregion}}数据库操作类(DataOperate.cs):using System;using System.Collections.Generic;//命名空间包含定义泛型集合的接口和类,泛型集合允许用户创建强类型集合,它能提供比非泛型强类型集合21的类型安全性和性能using System.Text;//System.Text 命名空间包含表示ASCII、Unicode、UTF-7 和UTF-8 字符编码的类;用于将字符块转换为字节块和将字节块转换为字符块的抽象基类;以及操作和格式化String 对象而不创建String 的中间实例的Helper 类.using System.Windows.Forms;using System.Data;using System.Data.SqlClient;using System.Collections;//using System.Drawing;//命名空间提供了对GDI+ 基本图形功能的访问.using System.IO;//提供用于创建、复制、删除、移动和打开文件的静态方法,并协助创建FileStream 对象using pression;//里面包括两个类GzipStream和DeflaterStream,它们都可以用于解压缩,但是不支持ZIP、RAR等常用的压缩文件,using System.Drawing.Text;//using System.Drawing.Drawing2D;//命名空间提供高级的二维和矢量图形功能.using System.Drawing.Imaging;//为源自Bitmap 和Metafile 的类提供功能的抽象基类。

using System.Text.RegularExpressions;//命名空间包含一些类,这些类提供对.NET Framework 正则表达式引擎的访问。

该命名空间提供正则表达式功能namespace warehouse.BaseClass{class DataOperate{DataCon datacon = new DataCon();//声明DataCon类的一个对象,以调用其方法#region 绑定ComboBox控件/// <summary>/// 对ComboBox控件进行数据绑定/// </summary>/// <param name="M_str_sqlstr">SQL语句</param>/// <param name="M_str_table">表名</param>/// <param name="M_str_tbMember">数据表中字段名</param>/// <param name="cbox">ComboBox控件ID</param>public void cboxBind(string M_str_sqlstr, string M_str_table, string M_str_tbMember, ComboBox cbox){DataSet myds = datacon.getds(M_str_sqlstr, M_str_table);cbox.DataSource = myds.Tables[M_str_table];cbox.DisplayMember = M_str_tbMember;//显示username字段}#endregion#region 验证文本框输入为数字/// <summary>/// 验证文本框输入为数字/// </summary>/// <param name="M_str_num">输入字符</param>/// <returns>返回一个bool类型的值</returns>public bool validateNum(string M_str_num){return Regex.IsMatch(M_str_num, "^[0-9]*$");}#endregion#region 验证文本框输入为/// <summary>/// 验证文本框输入为/// </summary>/// <param name="M_str_phone">输入字符串</param>/// <returns>返回一个bool类型的值</returns>public bool validatePhone(string M_str_phone){return Regex.IsMatch(M_str_phone, "\d{3,4}-\d{7,8}");}#endregion#region 验证文本框输入为传真/// <summary>/// 验证文本框输入为传真/// </summary>/// <param name="M_str_fax">输入字符串</param>/// <returns>返回一个bool类型的值</returns>public bool validateFax(string M_str_fax){return Regex.IsMatch(M_str_fax, "86-\d{2,3}-\d{7,8}");}#endregion#region 用户登录/// <summary>/// 用户登录/// </summary>/// <param name="P_str_UserName">用户名</param>/// <param name="P_str_UserPwd">用户密码</param>/// <returns>返回一个int类型的值</returns>public int UserLogin(string P_str_UserName, string P_str_UserPwd) {SqlConnection sqlcon = datacon.getcon();SqlCommand sqlcom = new SqlCommand("proc_Login", sqlcon);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("UserName", SqlDbType.VarChar, 20).Value = P_str_UserName;sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;SqlParameter returnValue =sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);returnValue.Direction = ParameterDirection.ReturnValue;//返回值??sqlcon.Open();try{sqlcom.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);}finally{sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}int P_int_returnValue = (int)returnValue.Value;return P_int_returnValue;}#endregion#region 货物入库/// <summary>/// 货物入库/// </summary>/// <param name="P_int_GoodsID">货物编号</param>/// <param name="P_str_GoodsName">货物名称</param>/// <param name="P_str_PrName">供应商名称</param>/// <param name="P_str_StoreName">仓库名称</param>/// <param name="P_str_GoodsSpec">货物规格</param>/// <param name="P_str_GoodsUnit">计量单位</param>/// <param name="P_int_GoodsNum">进货数量</param>/// <param name="P_dml_GoodsPrice">货物单价</param>/// <param name="P_str_HPeople">经手</param>/// <param name="P_str_Remark">备注</param>/// <returns>返回一个int类型的值</returns>public int InsertGoods(int P_int_GoodsID,stringP_str_GoodsName,string P_str_PrName,string P_str_StoreName,string P_str_GoodsSpec,string P_str_GoodsUnit,intP_int_GoodsNum,decimal P_dml_GoodsPrice,string P_str_HPeople,stringP_str_Remark){SqlConnection sqlcon = datacon.getcon();SqlCommand sqlcom = new SqlCommand("proc_insertInStore", sqlcon);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("GoodsID", SqlDbType.BigInt).Value = P_int_GoodsID;sqlcom.Parameters.Add("GoodsName", SqlDbType.VarChar, 50).Value = P_str_GoodsName;sqlcom.Parameters.Add("PrName", SqlDbType.VarChar, 100).Value = P_str_PrName;sqlcom.Parameters.Add("StoreName", SqlDbType.VarChar, 100).Value = P_str_StoreName;sqlcom.Parameters.Add("GoodsSpec", SqlDbType.VarChar, 50).Value = P_str_GoodsSpec;sqlcom.Parameters.Add("GoodsUnit", SqlDbType.Char, 8).Value = P_str_GoodsUnit;sqlcom.Parameters.Add("GoodsNum", SqlDbType.BigInt).Value = P_int_GoodsNum;sqlcom.Parameters.Add("GoodsPrice", SqlDbType.Money).Value = P_dml_GoodsPrice;sqlcom.Parameters.Add("HandlePeople", SqlDbType.VarChar, 20).Value = P_str_HPeople;sqlcom.Parameters.Add("ISRemark", SqlDbType.VarChar, 1000).Value = P_str_Remark;SqlParameter returnValue =sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);returnValue.Direction = ParameterDirection.ReturnValue;sqlcon.Open();try{sqlcom.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);}finally{sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}int P_int_returnValue = (int)returnValue.Value;return P_int_returnValue;}#endregion#region 添加供应商信息/// <summary>/// 添加供应商信息/// </summary>/// <param name="P_str_PrName">供应商名称</param>/// <param name="P_str_PrPeople">负责</param>/// <param name="P_str_PrPhone">供应商联系</param>/// <param name="P_str_PrFax">供应商传真</param>/// <param name="P_int_PrRemark">备注</param>/// <returns>返回一个int类型的值</returns>public int InsertProvider(string P_str_PrName, string P_str_PrPeople, string P_str_PrPhone, string P_str_PrFax, string P_int_PrRemark){SqlConnection sqlcon = datacon.getcon();SqlCommand sqlcom = new SqlCommand("proc_insertProvider", sqlcon);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("PrName", SqlDbType.VarChar, 100).Value = P_str_PrName;sqlcom.Parameters.Add("PrPeople", SqlDbType.VarChar, 20).Value = P_str_PrPeople;sqlcom.Parameters.Add("PrPhone", SqlDbType.VarChar, 20).Value = P_str_PrPhone;sqlcom.Parameters.Add("PrFax", SqlDbType.VarChar, 20).Value = P_str_PrFax;sqlcom.Parameters.Add("PrRemark", SqlDbType.VarChar, 1000).Value = P_int_PrRemark;SqlParameter returnValue =sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);returnValue.Direction = ParameterDirection.ReturnValue;sqlcon.Open();try{sqlcom.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);}finally{sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}int P_int_returnValue = (int)returnValue.Value;return P_int_returnValue;}#endregion#region 添加仓库信息/// <summary>/// 添加仓库信息/// </summary>/// <param name="P_str_StoreName">仓库名称</param>/// <param name="P_str_StorePeople">仓库负责</param>/// <param name="P_str_StorePhone">仓库</param>/// <param name="P_str_StoreUnit">仓库所属单位</param>/// <param name="P_int_StoreRemark">备注</param>/// <returns>返回一个int类型的值</returns>public int InsertStorage(string P_str_StoreName, stringP_str_StorePeople, string P_str_StorePhone, string P_str_StoreUnit, stringP_int_StoreRemark){SqlConnection sqlcon = datacon.getcon();SqlCommand sqlcom = new SqlCommand("proc_insertStorage", sqlcon);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("StoreName", SqlDbType.VarChar, 100).Value = P_str_StoreName;sqlcom.Parameters.Add("StorePeople", SqlDbType.VarChar, 20).Value = P_str_StorePeople;sqlcom.Parameters.Add("StorePhone", SqlDbType.VarChar, 20).Value = P_str_StorePhone;sqlcom.Parameters.Add("StoreUnit", SqlDbType.VarChar, 100).Value = P_str_StoreUnit;sqlcom.Parameters.Add("StoreRemark", SqlDbType.VarChar, 1000).Value = P_int_StoreRemark;SqlParameter returnValue =sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);returnValue.Direction = ParameterDirection.ReturnValue;sqlcon.Open();try{sqlcom.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);}finally{sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}int P_int_returnValue = (int)returnValue.Value;return P_int_returnValue;}#endregion#region 添加新用户/// <summary>/// 添加新用户/// </summary>/// <param name="P_str_UserName">用户名</param>/// <param name="P_str_UserPwd">用户密码</param>/// <param name="P_str_UserRight">用户权限</param>/// <returns>返回一个int类型的值</returns>public int InsertUser(string P_str_UserName, string P_str_UserPwd, string P_str_UserRight){SqlConnection sqlcon = datacon.getcon();SqlCommand sqlcom = newSqlCommand("proc_insertUser",sqlcon);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("UserName", SqlDbType.VarChar, 20).Value = P_str_UserName;sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;sqlcom.Parameters.Add("UserRight", SqlDbType.Char, 10).Value = P_str_UserRight;SqlParameter returnValue =sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4);returnValue.Direction = ParameterDirection.ReturnValue;sqlcon.Open();try{sqlcom.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);}finallysqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}int P_int_returnValue = (int)returnValue.Value;return P_int_returnValue;}#endregion#region 修改用户信息/// <summary>/// 修改用户信息/// </summary>/// <param name="P_int_UID">用户编号</param>/// <param name="P_str_UserPwd">用户密码</param>/// <param name="P_str_UserRight">用户权限</param>/// <returns>返回一个int类型的值</returns>public void updateUser(int P_int_UID,string P_str_UserPwd, string P_str_UserRight){SqlConnection sqlcon = datacon.getcon();SqlCommand sqlcom = new SqlCommand("proc_updateUser", sqlcon);mandType = CommandType.StoredProcedure;sqlcom.Parameters.Add("UserID", SqlDbType.BigInt).Value =P_int_UID;sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd;sqlcom.Parameters.Add("UserRight", SqlDbType.Char, 10).Value = P_str_UserRight;sqlcon.Open();try{sqlcom.ExecuteNonQuery();}catch (Exception ex){MessageBox.Show(ex.Message);finally{sqlcom.Dispose();sqlcon.Close();sqlcon.Dispose();}}#endregion}}登陆界面(frmLogin.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{public partial class frmLogin : Form{public static string M_str_name;//记录登录用户名字public static string M_str_pwd;//记录登录用户密码public static string M_str_right;//记录登录用户的权限BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();BaseClass.DataOperate doperate = newwarehouse.BaseClass.DataOperate();public frmLogin(){InitializeComponent();}private void frmLogin_Load(object sender, EventArgs e)//窗口打开就加载的信息{doperate.cboxBind("select UserName from tb_User", "tb_User","UserName", cboxUName);doperate.tewupwd("select UserPwd from tb_User where UserName='" + cboxUName.Text + "'", txtPwd);}private void btnLogin_Click(object sender, EventArgs e){int P_int_returnValue =erLogin(cboxUName.Text.Trim(), txtPwd.Text.Trim());if (P_int_returnValue == 100){M_str_name = cboxUName.Text.Trim();M_str_pwd = txtPwd.Text.Trim();frmMain fmain = new frmMain();this.Hide();//this就是frmloginfmainfmain.Show();}if (P_int_returnValue == -100){MessageBox.Show("用户名或密码错误!", "提示", MessageBoxButtons.OK, rmation);txtPwd.Text = "";cboxUName.Focus();}}private void btnExit_Click(object sender, EventArgs e){Application.Exit();}private void cboxUName_SelectedIndexChanged(object sender, EventArgs e){SqlDataReader sqlread = datacon.getread("select UserName,UserRight from tb_User where UserName='" + cboxUName.Text + "'");if (sqlread.Read()){labURight.Text = sqlread["UserRight"].ToString();M_str_right = labURight.Text;doperate.tewupwd("select UserPwd from tb_User where UserName='" + cboxUName.Text + "'", txtPwd);}sqlread.Close();}private void frmLogin_FormClosing(object sender, FormClosingEventArgs e){Application.Exit();}}}系统主界面(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 = newwarehouse.GoodsManage.frmISManage();//GMfism.Show();GMfism.ShowDialog();//这两个函数就看谁获得焦点,前者父窗口也可获得焦点,后者只有新创建的窗体}private void btnOS_Click(object sender, EventArgs e)//出库管理{GoodsManage.frmOSManage GMfosm = newwarehouse.GoodsManage.frmOSManage();GMfosm.ShowDialog();}private void btnBR_Click(object sender, EventArgs e)//借货还货管理{GoodsManage.frmBGManage GMfbgm = newwarehouse.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 = newwarehouse.BasicInfo.frmGoodsInfo();BIfgi.ShowDialog();}private void btnSI_Click(object sender, EventArgs e)//仓库设置{BasicInfo.frmStoreInfo BIfsi = newwarehouse.BasicInfo.frmStoreInfo();BIfsi.ShowDialog();}private void btnISL_Click(object sender, EventArgs e)//入库查询{LookandSum.frmISLook LSfisl = newwarehouse.LookandSum.frmISLook();LSfisl.ShowDialog();}private void btnSL_Click(object sender, EventArgs e)//库存查询{LookandSum.frmGILook LSfgil = newwarehouse.LookandSum.frmGILook();LSfgil.ShowDialog();}private void btnGOL_Click(object sender, EventArgs e)//货物借出查询{LookandSum.frmBGLook LSfbgl = newwarehouse.LookandSum.frmBGLook();LSfbgl.ShowDialog();}private void btnGIL_Click(object sender, EventArgs e)//货物归还查询{LookandSum.frmRGLook LSfrgl = newwarehouse.LookandSum.frmRGLook();LSfrgl.ShowDialog();}private void btnOSL_Click(object sender, EventArgs e)//出库查询{LookandSum.frmOSLook LSfosl = newwarehouse.LookandSum.frmOSLook();LSfosl.ShowDialog();}private void btnEP_Click(object sender, EventArgs e)//更改密码{SystemSet.frmEditPwd HPfep = newwarehouse.SystemSet.frmEditPwd();HPfep.ShowDialog();}private void btnRI_Click(object sender, EventArgs e)//权限管理{SystemSet.frmRightManage HPfrm = newwarehouse.SystemSet.frmRightManage();HPfrm.ShowDialog();}private void btnUM_Click(object sender, EventArgs e)//用户管理{SystemSet.frmUserManage HPfum = newwarehouse.SystemSet.frmUserManage();HPfum.ShowDialog();}private void btnAU_Click(object sender, EventArgs e)//关于本系统{SystemSet.frmAboutUs HPfau = newwarehouse.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){}}}货物档案管理(入库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 = newwarehouse.BaseClass.DataCon();warehouse.BaseClass.DataOperate doperate = newwarehouse.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。

相关主题