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 建立数据库连接 ///
///
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对象 读取数据 /// /// 创建一个DataSet对象 ///
/// SQL语句 /// 表名 ///
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对象 读取数据 /// /// 创建一个SqlDataReader对象 ///
/// SQL语句 ///
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 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控件 /// /// 对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 验证文本框输入为数字 /// /// 验证文本框输入为数字 ///
/// 输入字符 ///
return Regex.IsMatch(M_str_num, \"^[0-9]*$\"); } #endregion
#region 验证文本框输入为电话号码 /// /// 验证文本框输入为电话号码 ///
/// 输入字符串 ///
return Regex.IsMatch(M_str_phone, @\"\\d{3,4}-\\d{7,8}\"); }
#endregion
#region 验证文本框输入为传真号码 /// /// 验证文本框输入为传真号码 ///
/// 输入字符串 ///
return Regex.IsMatch(M_str_fax, @\"86-\\d{2,3}-\\d{7,8}\"); } #endregion #region 用户登录 ///
/// 用户名 /// 用户密码 ///
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 货物入库 ///
/// 货物编号 /// 货物名称 /// 供应商名称 /// 仓库名称 /// 货物规格 /// 计量单位 /// 进货数量 /// 货物单价 /// 经手 /// 备注 ///
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 添加供应商信息 ///
/// 供应商名称 /// 负责
/// 供应商联系电话 /// 供应商传真号码 /// 备注 ///
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 添加仓库信息 ///
/// 仓库名称 /// 仓库负责 /// 仓库电话 /// 仓库所属单位 /// 备注 ///
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 添加新用户 ///
/// 用户名 /// 用户密码 /// 用户权限 ///
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 修改用户信息 ///
/// 用户编号 /// 用户密码 /// 用户权限 ///
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(); } } }
因篇幅问题不能全部显示,请点此查看更多更全内容
Copyright © 2019- ovod.cn 版权所有 湘ICP备2023023988号-4
违法及侵权请联系:TEL:199 1889 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务