仓库管理系统代码

using System;

using System.Collections.Generic; using System.Windows.Forms; namespace warehouse {

static class Program {

///

Application.EnableVisualStyles();

Application.SetCompatibleTextRenderingDefault(false); Application.Run(new frmLogin());//运行一个登陆对象 } } }

程序集的常规信息 using System.Reflection;

using System.Runtime.CompilerServices; 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-3791409e91\")] // 程序集的版本信息由下面个值组成: // 主版本 // 次版本 // 内部版本号 // 修订号 //

[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 建立数据库连接 ///

/// 返回SqlConnection对象 public SqlConnection getcon() {

string M_str_sqlcon = \"Data Source=(local);Database=db_warehouse;user id=sa;pwd= \";

SqlConnection myCon = new SqlConnection(M_str_sqlcon); return myCon; }

#endregion

#region 执行SqlCommand命令 ///

/// SQL语句 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对象 读取数据 ///

/// SQL语句 /// 表名 /// 返回DataSet对象

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对象 读取数据 ///

/// SQL语句 /// 返回SqlDataReader对象 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;//命名空间包含定义泛型集合的接口和类，泛型集合允许用户创建强类型集合，它能提供比非泛型强类型集合２１的类型安全性和性能

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 System.IO.Compression;//里面包括两个类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控件 ///

/// SQL语句 /// 表名

/// 数据表中字段名 /// ComboBox控件ID

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 验证文本框输入为数字 ///

/// 输入字符 /// 返回一个bool类型的值 public bool validateNum(string M_str_num) {

return Regex.IsMatch(M_str_num, \"^[0-9]*$\"); } #endregion

#region 验证文本框输入为电话号码 ///

/// 输入字符串 /// 返回一个bool类型的值 public bool validatePhone(string M_str_phone) {

return Regex.IsMatch(M_str_phone, @\"\\d{3,4}-\\d{7,8}\"); }

#endregion

#region 验证文本框输入为传真号码 ///

/// 输入字符串 /// 返回一个bool类型的值 public bool validateFax(string M_str_fax) {

return Regex.IsMatch(M_str_fax, @\"86-\\d{2,3}-\\d{7,8}\"); } #endregion #region 用户登录 ///

/// 用户名 /// 用户密码 /// 返回一个int类型的值

public int UserLogin(string P_str_UserName, string P_str_UserPwd) {

SqlConnection sqlcon = datacon.getcon();

SqlCommand sqlcom = new SqlCommand(\"proc_Login\ sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add(\"@UserName\P_str_UserName;

sqlcom.Parameters.Add(\"@UserPwd\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 货物入库 ///

/// 货物编号 /// 货物名称 /// 供应商名称 /// 仓库名称 /// 货物规格 /// 计量单位 /// 进货数量 /// 货物单价 /// 经手 /// 备注 /// 返回一个int类型的值

public int InsertGoods(int P_int_GoodsID,string P_str_GoodsName,string P_str_PrName,string P_str_StoreName,

string P_str_GoodsSpec,string P_str_GoodsUnit,int

P_int_GoodsNum,decimal P_dml_GoodsPrice,string P_str_HPeople,string P_str_Remark)

{

SqlConnection sqlcon = datacon.getcon();

SqlCommand sqlcom = new SqlCommand(\"proc_insertInStore\ sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add(\"@GoodsID\P_int_GoodsID;

sqlcom.Parameters.Add(\"@GoodsName\P_str_GoodsName;

sqlcom.Parameters.Add(\"@PrName\P_str_PrName;

sqlcom.Parameters.Add(\"@StoreName\P_str_StoreName;

sqlcom.Parameters.Add(\"@GoodsSpec\P_str_GoodsSpec;

sqlcom.Parameters.Add(\"@GoodsUnit\P_str_GoodsUnit;

sqlcom.Parameters.Add(\"@GoodsNum\P_int_GoodsNum;

sqlcom.Parameters.Add(\"@GoodsPrice\P_dml_GoodsPrice;

sqlcom.Parameters.Add(\"@HandlePeople\alue = P_str_HPeople;

sqlcom.Parameters.Add(\"@ISRemark\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 添加供应商信息 ///

/// 供应商名称 /// 负责

/// 供应商联系电话 /// 供应商传真号码 /// 备注 /// 返回一个int类型的值

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\ sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add(\"@PrName\P_str_PrName;

sqlcom.Parameters.Add(\"@PrPeople\P_str_PrPeople;

sqlcom.Parameters.Add(\"@PrPhone\P_str_PrPhone;

sqlcom.Parameters.Add(\"@PrFax\P_str_PrFax;

sqlcom.Parameters.Add(\"@PrRemark\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 添加仓库信息 ///

/// 仓库名称 /// 仓库负责 /// 仓库电话 /// 仓库所属单位 /// 备注 /// 返回一个int类型的值

public int InsertStorage(string P_str_StoreName, string P_str_StorePeople, string P_str_StorePhone, string P_str_StoreUnit, string P_int_StoreRemark)

{

SqlConnection sqlcon = datacon.getcon();

SqlCommand sqlcom = new SqlCommand(\"proc_insertStorage\ sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add(\"@StoreName\P_str_StoreName;

sqlcom.Parameters.Add(\"@StorePeople\P_str_StorePeople;

sqlcom.Parameters.Add(\"@StorePhone\P_str_StorePhone;

sqlcom.Parameters.Add(\"@StoreUnit\P_str_StoreUnit;

sqlcom.Parameters.Add(\"@StoreRemark\= 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 添加新用户 ///

/// 用户名 /// 用户密码 /// 用户权限 /// 返回一个int类型的值

public int InsertUser(string P_str_UserName, string P_str_UserPwd, string P_str_UserRight)

{

SqlConnection sqlcon = datacon.getcon();

SqlCommand sqlcom = new SqlCommand(\"proc_insertUser\ sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add(\"@UserName\P_str_UserName;

sqlcom.Parameters.Add(\"@UserPwd\P_str_UserPwd;

sqlcom.Parameters.Add(\"@UserRight\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); } finally {

sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); }

int P_int_returnValue = (int)returnValue.Value; return P_int_returnValue; }

#endregion

#region 修改用户信息 ///

/// 用户编号 /// 用户密码 /// 用户权限 /// 返回一个int类型的值

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\ sqlcom.CommandType = CommandType.StoredProcedure;

sqlcom.Parameters.Add(\"@UserID\ sqlcom.Parameters.Add(\"@UserPwd\P_str_UserPwd;

sqlcom.Parameters.Add(\"@UserRight\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 System.ComponentModel; 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 = new warehouse.BaseClass.DataOperate(); public frmLogin() {

InitializeComponent(); }

private void frmLogin_Load(object sender, EventArgs e)//窗口打开就加载的信息

{

doperate.cboxBind(\"select UserName from tb_User\cboxUName);

doperate.tewupwd(\"select UserPwd from tb_User where UserName='\" + cboxUName.Text + \"'\

}

private void btnLogin_Click(object sender, EventArgs e) {

int P_int_returnValue = doperate.UserLogin(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就是frmloginfmain fmain.Show(); }

if (P_int_returnValue == -100) {

MessageBox.Show(\"用户名或密码错误！\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

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 + \"'\ }

sqlread.Close(); }

private void frmLogin_FormClosing(object sender, FormClosingEventArgs e) {

Application.Exit(); } }

}

系统主界面（frmMain.cs）

using 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 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, 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(); } 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(\"http://www.renrenle.cn\"); } }

}

货物档案管理（入库 frmInManage.cs）

using 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.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\\"StoreName\仓库名字显示出来

doperate.cboxBind(\"select PrName from tb_Provider\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\

dgvISManage.DataSource = myds.Tables[0];//dataset中的第一个datatable 0<=>\"tb_InStore\" }

private void btnAdd_Click(object sender, EventArgs e) {

if (txtISGID.Text == \"\")

{

MessageBox.Show(\"货物编号不能为空！\信息\MessageBoxIcon.Information); }

if (txtISGName.Text == \"\") {

MessageBox.Show(\"货物名称不能为空\信息\MessageBoxIcon.Information); }

if (txtGIPrice.Text == \"\") {

MessageBox.Show(\"货物单价不能为空！\信息\MessageBoxIcon.Information); }

if (txtISGNum.Text == \"\") {

MessageBox.Show(\"入库数量不能为空\信息\MessageBoxIcon.Information); }

if (txtGSpec.Text == \"\") {

MessageBox.Show(\"货物规格不能为空\信息\MessageBoxIcon.Information); }

if (txtHPeople.Text == \"\") {

MessageBox.Show(\"经手不能为空\信息\MessageBoxIcon.Information); } 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, MessageBoxIcon.Information); }

else if (P_int_returnValue == 200) {

MessageBox.Show(\"这类货物已经存在惟一编号！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); } else {

MessageBox.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(dgvISManage[0, dgvISManage.CurrentCell.RowIndex].Value).Trim() + \"\");

//Convert.ToString(dataGridView1[1,dataGridView1.CurrentCell.RowIndex].Value).Trim(); // 来取得所选中的那行数据某列的值...

MessageBox.Show(\"货物删除成功！\信息\MessageBoxIcon.Information);

frmISManage_Load(sender, e); //}

//catch (Exception ex) //{

// MessageBox.Show(ex.Message, \"警告\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 数字。 }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\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.cs）

using 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.GoodsManage {

public partial class frmOSManage : Form {

warehouse.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\\"StoreName\

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.Tables[\"tb_OutStore\"]; }

private void btnAdd_Click(object sender, EventArgs e) { try {

SqlDataReader 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(sqlread[\"GoodsNum\"].ToString().Trim())) {

MessageBox.Show(\"仓库中没有足够的货物！\提示\MessageBoxIcon.Information); } else {

datacon.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() + xtGOPrice.Text.Trim() + xtHPeople.Text.Trim() + \"','\" + txtOSRemark.Text.Trim() + \"')\"); MessageBox.Show(\"货物出库成功！\信息\ frmOSManage_Load(sender, e); } }

sqlread.Close(); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnDel_Click(object sender, EventArgs e) { try {

datacon.getcom(\"delete from tb_OutStore where OSID=\" + Convert.ToString(dgvOSManage[0, dgvOSManage.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"货物删除成功！\信息\MessageBoxIcon.Information);

frmOSManage_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\

MessageBoxIcon.Warning); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void dgvOSManage_CellClick(object sender, DataGridViewCellEventArgs e) {

cboxSName.Text = Convert.ToString(dgvOSManage[1, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

cboxGName.Text = Convert.ToString(dgvOSManage[2, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

cboxGSpec.Text = Convert.ToString(dgvOSManage[3, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

cboxGUnit.Text = Convert.ToString(dgvOSManage[4, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtOSGNum.Text = Convert.ToString(dgvOSManage[5, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtGOPrice.Text = Convert.ToString(dgvOSManage[6, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtGSPrice.Text = Convert.ToString(dgvOSManage[7, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtOSUnit.Text = Convert.ToString(dgvOSManage[9, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtOSPeople.Text = Convert.ToString(dgvOSManage[10, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtHPeople.Text = Convert.ToString(dgvOSManage[11, dgvOSManage.CurrentCell.RowIndex].Value).Trim();

txtOSRemark.Text = Convert.ToString(dgvOSManage[12, dgvOSManage.CurrentCell.RowIndex].Value).Trim(); }

private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) {

doperate.cboxBind(\"select distinct GoodsName from tb_InStore where StoreName='\"

+ cboxSName.Text.Trim() + \"'\ }

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()

+ \"'\ 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 = sqlread[\"GoodsUnit\"].ToString().Trim(); this.txtGOPrice.Text = qlread[\"GoodsOutPrice\"].ToString().Trim(); this.tbxshenxia.Text = sqlread[\"GoodsNum\"].ToString().Trim(); }

sqlread.Close(); }

private void txtOSGNum_TextChanged(object sender, EventArgs e) { try {

txtGSPrice.Text =

Convert.ToString(Convert.ToDecimal(txtGOPrice.Text.Trim())* Convert.ToInt32(txtOSGNum.Text.Trim())).Trim(); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void frmOSManage_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); }

}

}

借货管理(frmBGManage.cs)

using 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.GoodsManage {

public partial class frmBGManage : Form {

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); public frmBGManage() {

InitializeComponent(); }

private void frmBGManage_Load(object sender, EventArgs e) {

dgvBGManage.Controls.Add(hScrollBar1);

doperate.cboxBind(\"select StoreName from tb_Storage\\"StoreName\

DataSet myds = datacon.getds(\"select BGID as 借货编号,GoodsName as 货物名称,StoreName as 仓库名称,\"

+ \"GoodsSpec as 货物规格,GoodsNum as 借出数量,BGDate as 借货日期,HandlePeople as 经手,\"

+ \"BGPeople as 借货,BGUnit as 借货单位,BGRemark as 备注from tb_BorrowGoods\

dgvBGManage.DataSource = myds.Tables[0]; }

private void btnAdd_Click(object sender, EventArgs e) { try {

if (!doperate.validateNum(txtBGNum.Text.Trim())) {

errorPrBGNum.SetError(txtBGNum, \"输入必须为数字！\"); } else {

errorPrBGNum.Clear();

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(sqlread[\"GoodsNum\"].ToString().Trim()) <= 1) {

MessageBox.Show(\"该货物库存已经不足！\警告\MessageBoxButtons.OK, MessageBoxIcon.Warning); } else {

if (Convert.ToInt32(txtBGNum.Text.Trim()) >= Convert.ToInt32(this.tbxshenxia.Text.Trim())) {

MessageBox.Show(\"没有足够的货物供您借取！\警告\MessageBoxIcon.Warning);

txtBGNum.Text = \"\"; txtBGNum.Focus(); } else {

datacon.getcom(\"insert into tb_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() + \"','\" + txtBGPeople.Text.Trim() + \"','\"

+ txtBGDepart.Text.Trim() + \"','\" + txtBGRemark.Text.Trim() + \"')\");

MessageBox.Show(\"借货成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information);

frmBGManage_Load(sender, e); } } }

sqlread.Close(); } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnDel_Click(object sender, EventArgs e) { try {

datacon.getcom(\"delete from tb_BorrowGoods where BGID=\" + Convert.ToString(dgvBGManage[0, dgvBGManage.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"借货资料删除成功！\信息\MessageBoxIcon.Information);

frmBGManage_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnRGManage_Click(object sender, EventArgs e) {

GoodsManage.frmRGManage GMfrgm = new frmRGManage(); this.Hide();

GMfrgm.ShowDialog(); }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void cboxSName_SelectedIndexChanged(object sender, EventArgs e) {

doperate.cboxBind(\"select distinct GoodsName from tb_GoodsInfo where StoreName='\"

+ cboxSName.Text.Trim() + \"'\cboxGName); }

private void cboxGName_SelectedIndexChanged(object sender, EventArgs e) {

doperate.cboxBind(\"select distinct GoodsSpec from tb_GoodsInfo where

StoreName='\" + cboxSName.Text.Trim()+ \"' and GoodsName='\" + cboxGName.Text.Trim() + \"'\\"tb_GoodsInfo\

SqlDataReader sqlreader = datacon.getread(\"select

GoodsName,StoreName,GoodsNum from tb_GoodsInfo where StoreName='\" + cboxSName.Text.Trim() + \"'and GoodsName='\" + cboxGName.Text.Trim() + \"'\"); if (sqlreader.Read()) {

this.tbxshenxia.Text = sqlreader[\"GoodsNum\"].ToString().Trim(); }

sqlreader.Close(); }

private void dgvBGManage_CellClick(object sender, ataGridViewCellEventArgs e) {

cboxSName.Text = Convert.ToString(dgvBGManage[2, dgvBGManage.CurrentCell.RowIndex].Value).Trim();

cboxGName.Text = Convert.ToString(dgvBGManage[1, dgvBGManage.CurrentCell.RowIndex].Value).Trim();

cboxGSpec.Text = Convert.ToString(dgvBGManage[3, dgvBGManage.CurrentCell.RowIndex].Value).Trim();

txtBGNum.Text = Convert.ToString(dgvBGManage[4,

dgvBGManage.CurrentCell.RowIndex].Value).Trim();

txtHPeople.Text = Convert.ToString(dgvBGManage[6, dgvBGManage.CurrentCell.RowIndex].Value).Trim();

txtBGPeople.Text = Convert.ToString(dgvBGManage[7, dgvBGManage.CurrentCell.RowIndex].Value).Trim();

txtBGDepart.Text = Convert.ToString(dgvBGManage[8, dgvBGManage.CurrentCell.RowIndex].Value).Trim();

txtBGRemark.Text = Convert.ToString(dgvBGManage[9, dgvBGManage.CurrentCell.RowIndex].Value).Trim(); }

private void frmBGManage_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

货物归还(frmRGManage.cs)

using 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.GoodsManage {

public partial class frmRGManage : Form {

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); public frmRGManage() {

InitializeComponent(); }

private void frmRGManage_Load(object sender, EventArgs e) {

dgvRGManage.Controls.Add(hScrollBar1);

doperate.cboxBind(\"select BGID from tb_BorrowGoods\\"BGID\

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\"

+ \"GoodsSpec as 货物规格, RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,\"

+ \"RGPeople as 还货,RGRemark as 备注,Editer as 修改,EditDate as 修改日期from tb_ReturnGoods\

dgvRGManage.DataSource = myds.Tables[\"tb_ReturnGoods\"]; }

private void btnAdd_Click(object sender, EventArgs e) { try {

SqlDataReader sqlread = datacon.getread(\"select GoodsNum from tb_BorrowGoods\"

+ \" where BGID=\" + Convert.ToInt32(cboxBGID.Text.Trim()) + \"\"); if (sqlread.Read()) {

if (Convert.ToInt32(txtRGNum.Text.Trim()) > Convert.ToInt32(sqlread[\"GoodsNum\"].ToString().Trim())) {

MessageBox.Show(\"您借的货物数目为\" + Convert.ToInt32(sqlread[\"GoodsNum\"].ToString().Trim())

+ \"，请重新填写还货的数量！\提示\MessageBoxButtons.OK, MessageBoxIcon.Information); txtRGNum.Text = \"\"; txtRGNum.Focus(); } else {

datacon.getcom(\"insert into

tb_ReturnGoods(BGID,StoreName,GoodsName,GoodsSpec,RGNum,\"

+ \"NRGNum,HandlePeople,RGPeople,RGRemark) values(\" + cboxBGID.Text.Trim() + xtSName.Text.Trim()

+ \"','\" + txtGName.Text.Trim() + \"','\" + txtGSpec.Text.Trim() + \"',\" + txtRGNum.Text.Trim() + \

+ txtNRGNum.Text.Trim() + \

+ txtRGPeople.Text.Trim() + \"','\" + txtRGRemark.Text.Trim() + \"')\"); MessageBox.Show(\"还货成功！\提示\MessageBoxIcon.Information);

frmRGManage_Load(sender, e); } }

sqlread.Close(); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnEdit_Click(object sender, EventArgs e) { try {

datacon.getcom(\"update tb_ReturnGoods set HandlePeople='\" + txtHPeople.Text.Trim() + \"',RGPeople='\" + txtRGPeople.Text.Trim() + \"',RGRemark='\" + txtRGRemark.Text.Trim() + \"',Editer='\" + warehouse.frmLogin.M_str_name + \"',EditDate='\" + DateTime.Now.ToShortDateString() + \"'where RGID=\"

+ Convert.ToString(dgvRGManage[0, dgvRGManage.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"还货档案资料修改成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmRGManage_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnDel_Click(object sender, EventArgs e) { try {

datacon.getcom(\"delete from tb_ReturnGoods where RGID=\"

+ Convert.ToString(dgvRGManage[0, dgvRGManage.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"还货档案资料删除成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmRGManage_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void cboxBGID_SelectedIndexChanged(object sender, EventArgs e) {

if (cboxBGID.Text == \"System.Data.DataRowView\") { } else {

SqlDataReader sqlreada = datacon.getread(\"select GoodsNum from tb_BorrowGoods\" + \" where BGID=\" + Convert.ToInt32(cboxBGID.Text.Trim()) + \"\"); if (sqlreada.Read()) {

this.lbejiehuo.Text = sqlreada[\"GoodsNum\"].ToString().Trim(); }

SqlDataReader sqlreadNum = datacon.getread(\"select sum(RGNum) as Num from tb_ReturnGoods\" + \" where BGID=\" + Convert.ToInt32(cboxBGID.Text.Trim()) + \"\"); if (sqlreadNum.Read()) {

if (sqlreadNum[\"Num\"].ToString().Trim() == \"\") {

MessageBox.Show(\"您没有还过该货物。\"); }

else {

MessageBox.Show(\"已归还数量为\" + sqlreadNum[\"Num\"].ToString().Trim() + \"。\"); } }

sqlreadNum.Close();

SqlDataReader sqlread = datacon.getread(\"select

StoreName,GoodsName,GoodsSpec from tb_BorrowGoods\"+ \" where BGID=\" + Convert.ToInt32(cboxBGID.Text.Trim()) + \"\"); if (sqlread.Read()) {

txtSName.Text = sqlread[\"StoreName\"].ToString().Trim(); txtGName.Text = sqlread[\"GoodsName\"].ToString().Trim(); txtGSpec.Text = sqlread[\"GoodsSpec\"].ToString().Trim(); }

sqlread.Close(); } }

private void dgvRGManage_CellClick(object sender, DataGridViewCellEventArgs e) {

cboxBGID.Text = Convert.ToString(dgvRGManage[1, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtSName.Text = Convert.ToString(dgvRGManage[2, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtGName.Text = Convert.ToString(dgvRGManage[3, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtRGNum.Text = Convert.ToString(dgvRGManage[5, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtNRGNum.Text = Convert.ToString(dgvRGManage[6, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtRGPeople.Text = Convert.ToString(dgvRGManage[9, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtHPeople.Text = Convert.ToString(dgvRGManage[8, dgvRGManage.CurrentCell.RowIndex].Value).Trim();

txtRGRemark.Text = Convert.ToString(dgvRGManage[10, dgvRGManage.CurrentCell.RowIndex].Value).Trim(); }

private void txtRGNum_TextChanged(object sender, EventArgs e) { try {

SqlDataReader sqlread = datacon.getread(\"select GoodsNum from tb_BorrowGoods\"

+ \" where BGID=\" + Convert.ToInt32(cboxBGID.Text.Trim()) + \"\"); if (sqlread.Read()) {

txtNRGNum.Text =

Convert.ToString(Convert.ToInt32(sqlread[\"GoodsNum\"].ToString().Trim()) - Convert.ToInt32(txtRGNum.Text.Trim())).Trim(); }

sqlread.Close(); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void frmRGManage_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

档案设置管理（仓库设置frmStoreInfo.cs）

using 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.BasicInfo {

public partial class frmStoreInfo : Form {

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); public frmStoreInfo() {

InitializeComponent(); }

private void frmStoreInfo_Load(object sender, EventArgs e) {

dgvSInfo.Controls.Add(hScrollBar1);

DataSet myds = datacon.getds(\"select StoreID as 仓库编号,StoreName as 仓库名称,StorePeople as 负责,\"

+ \"StorePhone as 电话,StoreUnit as 所属单位,StoreDate as 建库日期,StoreRemark as 备注,\"

+ \"Editer as 修改,EditDate as 修改日期from tb_Storage\ dgvSInfo.DataSource=myds.Tables[\"tb_Storage\"]; }

private void btnAdd_Click(object sender, EventArgs e) { try {

if (!doperate.validatePhone(txtSPhone.Text.Trim())) {

errorPrPhone.SetError(txtSPhone, \"电话格式不对\"); } else {

errorPrPhone.Clear(); if (txtSName.Text == \"\") {

MessageBox.Show(\"仓库名称不能为空！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); } else {

int P_int_returnValue =

doperate.InsertStorage(txtSName.Text.Trim(),txtSLeader.Text.Trim(), txtSPhone.Text.Trim(),

txtSDepart.Text.Trim(), txtSRemark.Text.Trim());

if (P_int_returnValue == 100)

{

MessageBox.Show(\"该仓库已经存在！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); } else {

MessageBox.Show(\"仓库信息添加成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmStoreInfo_Load(sender, e); } } } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnEdit_Click(object sender, EventArgs e) { try {

if (!doperate.validatePhone(txtSPhone.Text.Trim())) {

errorPrPhone.SetError(txtSPhone, \"电话号码输入格式不正确\"); } else {

errorPrPhone.Clear();

datacon.getcom(\"update tb_Storage set StoreName='\" +txtSName.Text.Trim()+\"', StorePeople='\" + txtSLeader.Text.Trim() + ',StorePhone='\" + txtSPhone.Text.Trim() + \"',StoreUnit='\" + txtSDepart.Text.Trim()+ \"',StoreRemark='\" + txtSRemark.Text.Trim() + \"',Editer='\" + warehouse.frmLogin.M_str_name + \"',EditDate='\" + DateTime.Now.ToShortDateString()

+ \"'where StoreID=\" + Convert.ToString(dgvSInfo[0,

dgvSInfo.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"仓库档案修改成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmStoreInfo_Load(sender, e); } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnDel_Click(object sender, EventArgs e) { try {

datacon.getcom(\"delete from tb_Storage where StoreID=\" + Convert.ToString(dgvSInfo[0, dgvSInfo.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"成功删除仓库！\信息\MessageBoxIcon.Information);

frmStoreInfo_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void dgvSInfo_CellClick(object sender, DataGridViewCellEventArgs e) {

txtSName.Text = Convert.ToString(dgvSInfo[1, dgvSInfo.CurrentCell.RowIndex].Value).Trim();

txtSLeader.Text = Convert.ToString(dgvSInfo[2, dgvSInfo.CurrentCell.RowIndex].Value).Trim();

txtSPhone.Text = Convert.ToString(dgvSInfo[3, dgvSInfo.CurrentCell.RowIndex].Value).Trim();

txtSDepart.Text = Convert.ToString(dgvSInfo[4, dgvSInfo.CurrentCell.RowIndex].Value).Trim();

txtSRemark.Text = Convert.ToString(dgvSInfo[6, dgvSInfo.CurrentCell.RowIndex].Value).Trim(); }

private void frmStoreInfo_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

供应商设置(frmPrInfo.cs)

using 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.BasicInfo {

public partial class frmPrInfo : Form {

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); public frmPrInfo() {

InitializeComponent(); }

private void frmPrInfo_Load(object sender, EventArgs e) {

dgvPInfo.Controls.Add(hScrollBar1);

DataSet myds = datacon.getds(\"select PrID as 供应商编号,PrName as 供应商名

称,PrPeople as 负责,\"

+ \"PrPhone as 电话,PrFax as 传真,PrRemark as 备注,Editer as 修改,EditDate as 修改日期from tb_Provider\ dgvPInfo.DataSource=myds.Tables[\"tb_Provider\"]; }

private void btnAdd_Click(object sender, EventArgs e) { try {

if (!doperate.validatePhone(txtPPhone.Text.Trim())) {

errorPrPhone.SetError(txtPPhone, \"电话号码格式不正确\"); }

else if (!doperate.validateFax(txtPFax.Text.Trim())) {

errorPrFax.SetError(txtPFax, \"传真号码输入格式不正确\"); } else {

errorPrFax.Clear(); errorPrPhone.Clear(); if (txtPName.Text == \"\") {

MessageBox.Show(\"供应商名称不能为空！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); } else {

int P_int_returnValue = doperate.InsertProvider(txtPName.Text.Trim(),

txtPLeader.Text.Trim(),txtPPhone.Text.Trim(),txtPFax.Text.Trim(),txtPRemark.Text.Trim()); if (P_int_returnValue == 100) {

MessageBox.Show(\"该供应商已经存在！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); } else

{

MessageBox.Show(\"供应商信息添加成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmPrInfo_Load(sender, e); } } } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnEdit_Click(object sender, EventArgs e) { try {

if (!doperate.validatePhone(txtPPhone.Text.Trim())) {

errorPrPhone.SetError(txtPPhone, \"电话号码格式不正确\"); }

else if (!doperate.validateFax(txtPFax.Text.Trim())) {

errorPrFax.SetError(txtPFax, \"传真号码输入格式不正确\"); } else {

errorPrFax.Clear(); errorPrPhone.Clear();

datacon.getcom(\"update tb_Provider set PrPeople='\" + txtPLeader.Text.Trim() + \"',PrPhone='\"

+ txtPPhone.Text.Trim() + \"',PrFax='\" + txtPFax.Text.Trim() + \"',PrRemark='\" + txtPRemark.Text.Trim() + \"',Editer='\" + warehouse.frmLogin.M_str_name + \"',EditDate='\" + DateTime.Now.ToShortDateString()

+ \"'where PrID=\" + Convert.ToString(dgvPInfo[0, dgvPInfo.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"供应商档案修改成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmPrInfo_Load(sender, e); } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnDel_Click(object sender, EventArgs e) { try {

datacon.getcom(\"delete from tb_Provider where PrID=\"

+ Convert.ToString(dgvPInfo[0, dgvPInfo.CurrentCell.RowIndex].Value).Trim() + \"\"); MessageBox.Show(\"成功删除供应商！\信息\MessageBoxIcon.Information);

frmPrInfo_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void dgvPInfo_CellClick(object sender, DataGridViewCellEventArgs e) {

txtPName.Text = Convert.ToString(dgvPInfo[1,

dgvPInfo.CurrentCell.RowIndex].Value).Trim();

txtPLeader.Text = Convert.ToString(dgvPInfo[2, dgvPInfo.CurrentCell.RowIndex].Value).Trim();

txtPPhone.Text = Convert.ToString(dgvPInfo[3,

dgvPInfo.CurrentCell.RowIndex].Value).Trim();

txtPFax.Text = Convert.ToString(dgvPInfo[4, dgvPInfo.CurrentCell.RowIndex].Value).Trim();

txtPRemark.Text = Convert.ToString(dgvPInfo[5, dgvPInfo.CurrentCell.RowIndex].Value).Trim(); }

private void frmPrInfo_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

库存货物管理（frmGoodsInfo.cs）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; namespace warehouse.BasicInfo {

public partial class frmGoodsInfo : Form {

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); public frmGoodsInfo() {

InitializeComponent(); }

private void frmGoodsInfo_Load(object sender, EventArgs e) {

dgvGInfo.Controls.Add(hScrollBar1);

DataSet myds = datacon.getds(\"select GoodsID as 货物编号,GoodsName as 货物名称,\" + \"StoreName as 仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\" + \"GoodsNum as 货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\" + \"Editer as 修改,EditDate as 修改日期from tb_GoodsInfo\ dgvGInfo.DataSource = myds.Tables[\"tb_GoodsInfo\"];

}

private void btnEdit_Click(object sender, EventArgs e) { try {

if (!doperate.validateNum(txtGOPrice.Text.Trim())) {

errorPrMoney.SetError(txtGOPrice, \"输入必须为数字\"); } else {

errorPrMoney.Clear();

datacon.getcom(\"update tb_GoodsInfo set GoodsOutPrice=\" +

txtGOPrice.Text.Trim() + \"',Editer='\" + warehouse.frmLogin.M_str_name + \"',EditDate='\" + DateTime.Now.ToShortDateString() + \"'where GoodsID=\"

+ Convert.ToString(dgvGInfo[0, dgvGInfo.CurrentCell.RowIndex].Value).Trim() + \"\"); MessageBox.Show(\"货物档案修改成功！\信息\MessageBoxIcon.Information);

frmGoodsInfo_Load(sender, e); } }

catch(Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnDel_Click(object sender, EventArgs e) { try {

datacon.getcom(\"delete from tb_GoodsInfo where GoodsID=\" + Convert.ToString(dgvGInfo[0, dgvGInfo.CurrentCell.RowIndex].Value).Trim() + \" and StoreName='\" + Convert.ToString(dgvGInfo[2, dgvGInfo.CurrentCell.RowIndex].Value).Trim() + \"'\");

MessageBox.Show(\"货物删除成功！\信息\MessageBoxIcon.Information);

frmGoodsInfo_Load(sender, e);

}

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void dgvGInfo_CellClick(object sender, DataGridViewCellEventArgs e) {

txtGName.Text = Convert.ToString(dgvGInfo[1, dgvGInfo.CurrentCell.RowIndex].Value).Trim();

txtGSpec.Text = Convert.ToString(dgvGInfo[3, dgvGInfo.CurrentCell.RowIndex].Value).Trim();

cboxGUnit.Text = Convert.ToString(dgvGInfo[4, dgvGInfo.CurrentCell.RowIndex].Value).Trim();

txtGNum.Text = Convert.ToString(dgvGInfo[5, dgvGInfo.CurrentCell.RowIndex].Value).Trim();

txtGIPrice.Text = Convert.ToString(dgvGInfo[6, dgvGInfo.CurrentCell.RowIndex].Value).Trim();

txtGOPrice.Text = Convert.ToString(dgvGInfo[7, dgvGInfo.CurrentCell.RowIndex].Value).Trim(); }

private void frmGoodsInfo_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

查询管理（借出货物frmBGLook.cs）

using 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.LookandSum {

public partial class frmBGLook : Form {

public frmBGLook() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); private void frmBGLook_Load(object sender, EventArgs e) {

dgvBGInfo.Controls.Add(hScrollBar1);

DataSet myds = datacon.getds(\"select BGID as 借货编号,GoodsName as 货物名称,StoreName as 仓库名称,\"

+ \"GoodsSpec as 货物规格,GoodsNum as 借出数量,BGDate as 借货日期,HandlePeople as 经手,\"

+ \"BGPeople as 借货,BGUnit as 借货单位,BGRemark as 备注from tb_BorrowGoods\

dgvBGInfo.DataSource = myds.Tables[0]; }

private void btnLook_Click(object sender, EventArgs e) { try {

if (txtLKWord.Text.Trim() == \"\") {

frmBGLook_Load(sender, e); } else {

if (cboxLCondition.Text.Trim() == \"借货编号\") {

DataSet myds = datacon.getds(\"select BGID as 借货编

号,GoodsName as 货物名称,StoreName as 仓库名称,\" + \"GoodsSpec as 货物规格,GoodsNum as 借出数量,BGDate as 借货日期,HandlePeople as 经手,\" + \"BGPeople as 借

货,BGUnit as 借货单位,BGRemark as 备注from tb_BorrowGoods where BGID = \" + txtLKWord.Text.Trim() + \"\ dgvBGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"借货日期\") {

string P_str_dtime = txtLKWord.Text.Trim(); DataSet myds = datacon.getds(\"select BGID as 借货编号,GoodsName as 货物名称,StoreName as 仓库名称,\"

+ \"GoodsSpec as 货物规格,GoodsNum as 借出数量,BGDate as 借货日期,HandlePeople as 经手,\"

+ \"BGPeople as 借货,BGUnit as 借货单位,BGRemark as 备注from tb_BorrowGoods\"

+ \" where year(BGDate)=\" + P_str_dtime.Substring(0, 4) + \" and month(BGDate)=\"

+ P_str_dtime.Substring(5, P_str_dtime.Length - 6) + \"\\"tb_BorrowGoods\");

dgvBGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"仓库名称\") {

DataSet myds = datacon.getds(\"select BGID as 借货编号,GoodsName as 货物名称,StoreName as 仓库名称,\"

+ \"GoodsSpec as 货物规格,GoodsNum as 借出数量,BGDate as 借货日期,HandlePeople as 经手,\"

+ \"BGPeople as 借货,BGUnit as 借货单位,BGRemark as 备注from tb_BorrowGoods where StoreName like '%\"

+ txtLKWord.Text.Trim() + \"%'\ dgvBGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"货物名称\") {

DataSet myds = datacon.getds(\"select BGID as 借货编

号,GoodsName as 货物名称,StoreName as 仓库名称,\"+ \"GoodsSpec as 货物规格,GoodsNum as 借出数量,BGDate as 借货日期,HandlePeople as 经手,\" + \"BGPeople as 借货,BGUnit as 借货单位,BGRemark as 备注from tb_BorrowGoods where GoodsName like '%\" + txtLKWord.Text.Trim() + \"%'\

dgvBGInfo.DataSource = myds.Tables[0];

} } }

catch (Exception ex) {

MessageBox.Show(ex.Message,\"提示\ } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void cboxLCondition_SelectedIndexChanged(object sender, EventArgs e) {

if (cboxLCondition.Text.Trim() == \"借货日期\") {

label2.Text = \"查询年月份\"; } else {

label2.Text = \"查询关键字\"; } }

private void frmBGLook_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

库存查询（frmGILook.cs）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms;

namespace warehouse.LookandSum {

public partial class frmGILook : Form {

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); public frmGILook() {

InitializeComponent(); }

private void frmGILook_Load(object sender, EventArgs e) {

dgvGInfo.Controls.Add(hScrollBar1);

DataSet myds = datacon.getds(\"select GoodsID as 货物编号,GoodsName as 货物名称,\" + \"StoreName as 仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\" + \"GoodsNum as 货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\" + \"Editer as 修改,EditDate as 修改日期from tb_GoodsInfo\ dgvGInfo.DataSource = myds.Tables[0]; }

private void btnLook_Click(object sender, EventArgs e) { try {

if (txtLKWord.Text.Trim() == \"\") {

frmGILook_Load(sender, e); } else {

if (cboxLCondition.Text.Trim() == \"货物编号\") {

DataSet myds = datacon.getds(\"select GoodsID as 货物编号,GoodsName as 货物名称,\"

+ \"StoreName as 仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\"

+ \"GoodsNum as 货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\" + \"GoodsLeast as 最低存储,GoodsMost as 最高存储,Editer as 修改,EditDate as 修改日期\" + \" from tb_GoodsInfo where GoodsID = \" + txtLKWord.Text.Trim() + \"\ dgvGInfo.DataSource = myds.Tables[0];

}

if (cboxLCondition.Text.Trim() == \"货物名称\") {

DataSet myds = datacon.getds(\"select GoodsID as 货物编号,GoodsName as 货物名称,\" + \"StoreName as 仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\" +\"GoodsNum as 货物数量,GoodsInPrice as 进货价

格,GoodsOutPrice as 出货价格,\" + \"GoodsLeast as 最低存储,GoodsMost as 最高存储,Editer as 修改,EditDate as 修改日期\" + \" from tb_GoodsInfo where GoodsName like '%\" + txtLKWord.Text.Trim() + \"%'\

dgvGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"仓库名称\") {

DataSet myds = datacon.getds(\"select GoodsID as 货物编号,GoodsName as 货物名称,\" + \"StoreName as 仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\" + \"GoodsNum as 货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\" + \"GoodsLeast as 最低存储,GoodsMost as 最高存储,Editer as 修改,EditDate as 修改日期\" + \" from tb_GoodsInfo where StoreName like '%\" + txtLKWord.Text.Trim() + \"%'\

dgvGInfo.DataSource = myds.Tables[0]; } } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"提示\MessageBoxIcon.Information); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void frmGILook_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

入库查询（frmISLook.cs）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; namespace warehouse.LookandSum {

public partial class frmISLook : Form {

public frmISLook() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); private void frmISLook_Load(object sender, EventArgs e) {

dgvISInfo.Controls.Add(hScrollBar1);

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\ dgvISInfo.DataSource = myds.Tables[0]; }

private void btnLook_Click(object sender, EventArgs e) { try {

if (txtLKWord.Text.Trim() == \"\") {

frmISLook_Load(sender, e); } else {

if (cboxLCondition.Text.Trim() == \"入库编号\") {

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 where ISID = \" + txtLKWord.Text.Trim() + \"\

dgvISInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"货物编号\") {

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 where GoodsID = \" + txtLKWord.Text.Trim() + \"\

dgvISInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"入库日期\") {

string P_str_dtime = txtLKWord.Text.Trim(); try {

Convert.ToDateTime(P_str_dtime); } catch {

MessageBox.Show(\"时间格式不正确，应为XXXX年-XX月-XX日\"); }

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 where year(ISDate)=\" + P_str_dtime.Substring(0, 4) + \" and month(ISDate)=\" + P_str_dtime.Substring(5,

P_str_dtime.Length - 6) + \"\

dgvISInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"仓库名称\") {

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 where StoreName like '%\" + txtLKWord.Text.Trim() + \"%'\

dgvISInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"货物名称\") {

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 where GoodsName like '%\" + txtLKWord.Text.Trim() + \"%'\

dgvISInfo.DataSource = myds.Tables[0]; } } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"提示\MessageBoxIcon.Information); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void cboxLCondition_SelectedIndexChanged(object sender, EventArgs e) {

if (cboxLCondition.Text.Trim() == \"入库日期\")

{

label2.Text = \"查询年月份\"; } else {

label2.Text = \"查询关键字\"; } }

private void frmISLook_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } } }

货物出库查询（frmOSLook.cs）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; namespace warehouse.LookandSum {

public partial class frmOSLook : Form {

public frmOSLook() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); private void frmOSLook_Load(object sender, EventArgs e) {

dgvOSInfo.Controls.Add(hScrollBar1);

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\

dgvOSInfo.DataSource = myds.Tables[0]; }

private void btnLook_Click(object sender, EventArgs e) { try {

if (txtLKWord.Text.Trim() == \"\") {

frmOSLook_Load(sender, e); } else {

if (cboxLCondition.Text.Trim() == \"出库编号\") {

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 where OSID = \" + txtLKWord.Text.Trim() + \"\

dgvOSInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"出库日期\") {

string P_str_dtime = txtLKWord.Text.Trim(); 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 where year(OSDate)=\" + P_str_dtime.Substring(0, 4) + \" and month(OSDate)=\" + P_str_dtime.Substring(5, P_str_dtime.Length - 6) + \"\

dgvOSInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"仓库名称\") {

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 提货,\" + txtLKWord.Text.Trim() + \"%'\

dgvOSInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"货物名称\") {

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 where GoodsName like '%\" + txtLKWord.Text.Trim() + \"%'\

dgvOSInfo.DataSource = myds.Tables[0]; } } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"提示\MessageBoxIcon.Information); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void cboxLCondition_SelectedIndexChanged(object sender, EventArgs e) {

if (cboxLCondition.Text.Trim() == \"出库日期\") {

label2.Text = \"查询年月份\"; } else {

label2.Text = \"查询关键字\";

+ \"HandlePeople as 经手,OSRemark as 备注from tb_OutStore where StoreName like '%\"

} }

private void frmOSLook_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } } }

货物归还查询（frmRGLook.cs）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; namespace warehouse.LookandSum {

public partial class frmRGLook : Form {

public frmRGLook() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); private void frmRGLook_Load(object sender, EventArgs e) {

dgvRGInfo.Controls.Add(hScrollBar1);

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\" + \"RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,RGPeople as 还货,RGRemark as 备注,\" + \"Editer as 修改,EditDate as 修改日期from tb_ReturnGoods\\"tb_ReturnGoods\");

dgvRGInfo.DataSource = myds.Tables[0]; }

private void btnLook_Click(object sender, EventArgs e) { try

{

if (txtLKWord.Text.Trim() == \"\") {

frmRGLook_Load(sender, e); } else {

if (cboxLCondition.Text.Trim() == \"还货编号\") {

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\"

+ \"RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,RGPeople as 还货,RGRemark as 备注,\"

+ \"Editer as 修改,EditDate as 修改日期from tb_ReturnGoods where RGID = \" + txtLKWord.Text.Trim() + \"\ dgvRGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"借货编号\") {

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\" + \"RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,RGPeople as 还货,RGRemark as 备注,\" + \"Editer as 修改,EditDate as 修改日期from tb_ReturnGoods where BGID = \" + txtLKWord.Text.Trim() + \"\ dgvRGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"还货日期\") {

string P_str_dtime=txtLKWord.Text.Trim();

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\" + \"RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,RGPeople as 还货,RGRemark as 备注,\" + \"Editer as 修改,EditDate as 修改日期from tb_ReturnGoods where year(RGDate)=\" + P_str_dtime.Substring(0, 4) + \" and month(RGDate)=\" + P_str_dtime.Substring(5, P_str_dtime.Length - 6) + \"\ dgvRGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"仓库名称\")

{

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\" + \"RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,RGPeople as 还货,RGRemark as 备注,\" + \"Editer as 修改,EditDate as 修改日期from tb_ReturnGoods where StoreName like '%\" + txtLKWord.Text.Trim() + \"%'\ dgvRGInfo.DataSource = myds.Tables[0]; }

if (cboxLCondition.Text.Trim() == \"货物名称\") {

DataSet myds = datacon.getds(\"select RGID as 还货编号,BGID as 借货编号,StoreName as 仓库名称,GoodsName as 货物名称,\" + \"RGNum as 归还数量,NRGNum as 未归还数量,RGDate as 还货日期,HandlePeople as 经手,RGPeople as 还货,RGRemark as 备注,\" + \"Editer as 修改,EditDate as 修改日期from tb_ReturnGoods where GoodsName like '%\" + txtLKWord.Text.Trim() + \"%'\ dgvRGInfo.DataSource = myds.Tables[0]; } } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"提示\MessageBoxIcon.Information); } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void cboxLCondition_SelectedIndexChanged(object sender, EventArgs e) {

if (cboxLCondition.Text.Trim() == \"还货日期\") {

label2.Text = \"查询年月份\"; } else {

label2.Text = \"查询关键字\";

} }

private void frmRGLook_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } }

}

系统设置(关于本系统frmAboutUs.cs)

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; using System.IO;//文件流的头文件 namespace warehouse.SystemSet {

public partial class frmAboutUs : Form {

public frmAboutUs() {

InitializeComponent(); }

private void frmAboutUs_Load(object sender, EventArgs e) {

string path = Application.StartupPath + \"\\\\AboutUs.txt\";//获取可执行文件的地址 System.IO.StreamReader reader = new System.IO.StreamReader(path, System.Text.Encoding.Default);

this.txtAboutUs.Text = reader.ReadToEnd(); reader.Close(); }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void frmAboutUs_FormClosed(object sender, FormClosedEventArgs e)

{

this.Close(); } }

}

密码修改（frmEditPwd.cs）

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text;

using System.Windows.Forms; namespace warehouse.SystemSet {

public partial class frmEditPwd : Form {

public frmEditPwd() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); private void frmEditPwd_Load(object sender, EventArgs e) {

txtUName.Text = warehouse.frmLogin.M_str_name; }

private void btnSure_Click(object sender, EventArgs e) {

if (txtFUNPwd.Text.Trim() != txtUNPwd.Text.Trim()) {

errorPrPwd.SetError(txtFUNPwd, \"两次输入密码不一致！\"); } else {

if (txtUOPwd.Text.Trim() != warehouse.frmLogin.M_str_pwd) {

MessageBox.Show(\"用户旧密码输入错误，请重新输入！\错误提示\

} else {

datacon.getcom(\"update tb_User set

UserPwd='\"+txtUNPwd.Text.Trim()+\"'where UserName='\"+txtUName.Text.Trim()+\"'\"); MessageBox.Show(\"密码修改成功！\信息\MessageBoxIcon.Information); } } }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

private void frmEditPwd_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } } }

权限管理（frmRightManage.cs）

using 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.SystemSet {

public partial class frmRightManage : Form {

public frmRightManage() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon();

warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); private void frmRightManage_Load(object sender, EventArgs e) {

doperate.cboxBind(\"select UserName from tb_User\cboxUName); }

private void btnSure_Click(object sender, EventArgs e) {

datacon.getcom(\"update tb_User set UserRight='\"

+ cboxURight.Text.Trim() + \"'where UserName='\" + cboxUName.Text.Trim() + \"'\");

MessageBox.Show(\"权限修改成功！\信息\ }

private void btnExit_Click(object sender, EventArgs e) {

this.Close(); }

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()) {

cboxURight.Text = sqlread[\"UserRight\"].ToString().Trim(); }

sqlread.Close(); }

private void frmRightManage_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); } } }

用户管理（frmUserManage.cs）

using 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.SystemSet {

public partial class frmUserManage : Form {

public frmUserManage() {

InitializeComponent(); }

warehouse.BaseClass.DataCon datacon = new warehouse.BaseClass.DataCon(); warehouse.BaseClass.DataOperate doperate = new warehouse.BaseClass.DataOperate(); private void frmUserManage_Load(object sender, EventArgs e) {

DataSet myds = datacon.getds(\"select UserID as 用户编号,UserName as 用户名,UserPwd as 用户密码,\" + \"UserRight as 用户权限from tb_User\ dgvUInfo.DataSource=myds.Tables[\"tb_User\"];

doperate.cboxBind(\"select UserName from tb_User\cboxUName);

doperate.cboxBind(\"select UserRight from tb_User\cboxURight); }

private void btnAdd_Click(object sender, EventArgs e) { try {

int P_int_returnValue = doperate.InsertUser(cboxUName.Text.Trim(), txtUPwd.Text.Trim(), cboxURight.Text.Trim()); if (P_int_returnValue == 100) {

MessageBox.Show(\"该用户已经存在\警告\MessageBoxButtons.OK, MessageBoxIcon.Warning); }

else {

MessageBox.Show(\"用户信息添加成功！\信息\MessageBoxButtons.OK, MessageBoxIcon.Information); frmUserManage_Load(sender, e); } }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void btnEdit_Click(object sender, EventArgs e) { try {

doperate.updateUser(Convert.ToInt32(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value),

txtUPwd.Text.Trim(), cboxURight.Text.Trim()); //MessageBox.Show( cboxUName.Items[1].(),\"asdf\" ,MessageBoxButtons.OK);

//datacon.getcom(\"update tb_User set UserPwd='\" + txtUPwd.Text.Trim() + \"',UserRight='\" + cboxURight.Items.ToString() + \"' where UserID= \" + cboxUName.Items.ToString() + \"\");

//Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"用户信息修改成功！\信息\MessageBoxIcon.Information);

frmUserManage_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"信息\MessageBoxIcon.Information); } }

private void btnDel_Click(object sender, EventArgs e) {

try {

datacon.getcom(\"delete from tb_User where UserID=\" + Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim() + \"\");

MessageBox.Show(\"删除用户信息成功！\信息\MessageBoxIcon.Information);

frmUserManage_Load(sender, e); }

catch (Exception ex) {

MessageBox.Show(ex.Message, \"警告\MessageBoxIcon.Warning); } }

private void dgvUInfo_CellClick(object sender, DataGridViewCellEventArgs e) {

cboxUName.Text = Convert.ToString(dgvUInfo[1, dgvUInfo.CurrentCell.RowIndex].Value).Trim();

txtUPwd.Text = Convert.ToString(dgvUInfo[2, dgvUInfo.CurrentCell.RowIndex].Value).Trim();

cboxURight.Text = Convert.ToString(dgvUInfo[3, dgvUInfo.CurrentCell.RowIndex].Value).Trim(); }

private void frmUserManage_FormClosed(object sender, FormClosedEventArgs e) {

this.Close(); }

private void btnexit_Click(object sender, EventArgs e) {

this.Close(); } } }