倉(cāng)庫(kù)管理系統(tǒng)代碼

1、系統(tǒng)主函數(shù)（program.cs）using System;using System.Collections.Generic;using System.Windows.Forms;namespace warehouse static class Program / <summary> / 應(yīng)用程序的主入口點(diǎn)。 / </summary> STAThread static void Main() Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Ap

2、plication.Run(new frmLogin();/運(yùn)行一個(gè)登陸對(duì)象 程序集的常規(guī)信息using System.Reflection;using System.Runtime.CompilerServices;using System.Runtime.InteropServices;/ 有關(guān)程序集的常規(guī)信息通過(guò)下列屬性集/ 控制。更改這些屬性值可修改/ 與程序集關(guān)聯(lián)的信息。assembly: AssemblyTitle("warehouse")assembly: AssemblyDescription("")assembly: AssemblyC

3、onfiguration("")assembly: AssemblyCompany("")assembly: AssemblyProduct("warehouse")assembly: AssemblyCopyright("版權(quán)所有 2009")assembly: AssemblyTrademark("")assembly: AssemblyCulture("")/ 將 ComVisible 設(shè)置為 false 使此程序集中的類型/ 對(duì) COM 組件不可見(jiàn)。如果需要從 COM

4、 訪問(wèn)此程序集中的類型，/ 則將該類型上的 ComVisible 屬性設(shè)置為 true。assembly: ComVisible(false)/ 如果此項(xiàng)目向 COM 公開(kāi)，則下列 GUID 用于類型庫(kù)的 IDassembly: Guid("063bd674-c4cc-4dc9-81ee-3791409e9189")/ 程序集的版本信息由下面?zhèn)€值組成:/ 主版本/ 次版本 / 內(nèi)部版本號(hào)/ 修訂號(hào)/assembly: AssemblyVersion("")assembly: AssemblyFileVersion("

5、")數(shù)據(jù)庫(kù)連接類（DataCon.cs）:using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;namespace warehouse.BaseClass class DataCon #region 建立數(shù)據(jù)庫(kù)連接 / <summary> / 建立數(shù)據(jù)庫(kù)連接. / </summary> / <returns>返回SqlConnection對(duì)象</returns> publi

6、c 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 執(zhí)行SqlCommand命令 / <summary> / 執(zhí)行SqlCommand / </summary> / <param name="M_st

7、r_sqlstr">SQL語(yǔ)句</param> public void getcom(string M_str_sqlstr) SqlConnection sqlcon = this.getcon(); sqlcon.Open(); SqlCommand sqlcom = new SqlCommand(M_str_sqlstr， sqlcon); sqlcom.ExecuteNonQuery();/返回受影響的行數(shù) sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); #endregion #region 創(chuàng)建Dat

8、aSet對(duì)象讀取數(shù)據(jù) / <summary> / 創(chuàng)建一個(gè)DataSet對(duì)象 / </summary> / <param name="M_str_sqlstr">SQL語(yǔ)句</param> / <param name="M_str_table">表名</param> / <returns>返回DataSet對(duì)象</returns> public DataSet getds(string M_str_sqlstr, string M_str_table) Sql

9、Connection 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 創(chuàng)建SqlDataReader對(duì)象讀取數(shù)據(jù) / <summary> / 創(chuàng)建一個(gè)SqlDataReader對(duì)象 / </summary> / <param

10、 name="M_str_sqlstr">SQL語(yǔ)句</param> / <returns>返回SqlDataReader對(duì)象</returns> public SqlDataReader getread(string M_str_sqlstr) SqlConnection sqlcon = this.getcon(); SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon); sqlcon.Open(); SqlDataReader sqlread = sqlcom.Exe

11、cuteReader(CommandBehavior.CloseConnection);/方法的參數(shù)表示如果關(guān)閉關(guān)聯(lián)的對(duì)象sqlread則關(guān)聯(lián)的連接sqlcon也關(guān)閉了 return sqlread; #endregion 數(shù)據(jù)庫(kù)操作類（DataOperate.cs）:using System;using System.Collections.Generic;/命名空間包含定義泛型集合的接口和類，泛型集合允許用戶創(chuàng)建強(qiáng)類型集合，它能提供比非泛型強(qiáng)類型集合的類型安全性和性能using System.Text;/System.Text 命名空間包含表示 ASCII、Unicode、UTF-7 和

12、UTF-8 字符編碼的類；用于將字符塊轉(zhuǎn)換為字節(jié)塊和將字節(jié)塊轉(zhuǎn)換為字符塊的抽象基類；以及操作和格式化 String 對(duì)象而不創(chuàng)建 String 的中間實(shí)例的 Helper 類.using System.Windows.Forms;using System.Data;using System.Data.SqlClient;using System.Collections;/using System.Drawing;/命名空間提供了對(duì)GDI+ 基本圖形功能的訪問(wèn).using System.IO;/提供用于創(chuàng)建、復(fù)制、刪除、移動(dòng)和打開(kāi)文件的靜態(tài)方法，并協(xié)助創(chuàng)建FileStream 對(duì)象using S

13、ystem.IO.Compression;/里面包括兩個(gè)類GzipStream和DeflaterStream，它們都可以用于解壓縮，但是不支持ZIP、RAR等常用的壓縮文件，using System.Drawing.Text;/using System.Drawing.Drawing2D;/命名空間提供高級(jí)的二維和矢量圖形功能.using System.Drawing.Imaging;/為源自 Bitmap 和 Metafile 的類提供功能的抽象基類。using System.Text.RegularExpressions;/命名空間包含一些類，這些類提供對(duì).NET Framework 正則

14、表達(dá)式引擎的訪問(wèn)。該命名空間提供正則表達(dá)式功能namespace warehouse.BaseClass class DataOperate DataCon datacon = new DataCon();/聲明DataCon類的一個(gè)對(duì)象，以調(diào)用其方法 #region 綁定ComboBox控件 / <summary> / 對(duì)ComboBox控件進(jìn)行數(shù)據(jù)綁定 / </summary> / <param name="M_str_sqlstr">SQL語(yǔ)句</param> / <param name="M_str_t

15、able">表名</param> / <param name="M_str_tbMember">數(shù)據(jù)表中字段名</param> / <param name="cbox">ComboBox控件ID</param> public void cboxBind(string M_str_sqlstr, string M_str_table, string M_str_tbMember, ComboBox cbox) DataSet myds = datacon.getds(M_str_s

16、qlstr, M_str_table); cbox.DataSource = myds.TablesM_str_table; cbox.DisplayMember = M_str_tbMember;/顯示username字段 #endregion #region 驗(yàn)證文本框輸入為數(shù)字 / <summary> / 驗(yàn)證文本框輸入為數(shù)字 / </summary> / <param name="M_str_num">輸入字符</param> / <returns>返回一個(gè)bool類型的值</returns>

17、public bool validateNum(string M_str_num) return Regex.IsMatch(M_str_num, "0-9*$"); #endregion #region 驗(yàn)證文本框輸入為電話號(hào)碼 / <summary> / 驗(yàn)證文本框輸入為電話號(hào)碼 / </summary> / <param name="M_str_phone">輸入字符串</param> / <returns>返回一個(gè)bool類型的值</returns> public bool

18、validatePhone(string M_str_phone) return Regex.IsMatch(M_str_phone, "d3,4-d7,8"); #endregion #region 驗(yàn)證文本框輸入為傳真號(hào)碼 / <summary> / 驗(yàn)證文本框輸入為傳真號(hào)碼 / </summary> / <param name="M_str_fax">輸入字符串</param> / <returns>返回一個(gè)bool類型的值</returns> public bool vali

19、dateFax(string M_str_fax) return Regex.IsMatch(M_str_fax, "86-d2,3-d7,8"); #endregion #region 用戶登錄 / <summary> / 用戶登錄 / </summary> / <param name="P_str_UserName">用戶名</param> / <param name="P_str_UserPwd">用戶密碼</param> / <returns>

20、返回一個(gè)int類型的值</returns> public int UserLogin(string P_str_UserName, string P_str_UserPwd) SqlConnection sqlcon = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_Login", sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("UserName", Sql

21、DbType.VarChar, 20).Value = P_str_UserName; sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd; SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4); returnValue.Direction = ParameterDirection.ReturnValue;/返回值？ sqlcon.Open()

22、; 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 貨物入庫(kù) / <summary> / 貨物入庫(kù) / </summary> / <param name

23、="P_int_GoodsID">貨物編號(hào)</param> / <param name="P_str_GoodsName">貨物名稱</param> / <param name="P_str_PrName">供應(yīng)商名稱</param> / <param name="P_str_StoreName">倉(cāng)庫(kù)名稱</param> / <param name="P_str_GoodsSpec">貨物規(guī)格

24、</param> / <param name="P_str_GoodsUnit">計(jì)量單位</param> / <param name="P_int_GoodsNum">進(jìn)貨數(shù)量</param> / <param name="P_dml_GoodsPrice">貨物單價(jià)</param> / <param name="P_str_HPeople">經(jīng)手</param> / <param name=&quo

25、t;P_str_Remark">備注</param> / <returns>返回一個(gè)int類型的值</returns> 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_HPe

26、ople,string P_str_Remark) SqlConnection sqlcon = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_insertInStore", sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("GoodsID", SqlDbType.BigInt).Value = P_int_GoodsID; sqlcom.Parameters.Add(&

27、quot;GoodsName", SqlDbType.VarChar, 50).Value = P_str_GoodsName; sqlcom.Parameters.Add("PrName", SqlDbType.VarChar, 100).Value = P_str_PrName; sqlcom.Parameters.Add("StoreName", SqlDbType.VarChar, 100).Value = P_str_StoreName; sqlcom.Parameters.Add("GoodsSpec", Sql

28、DbType.VarChar, 50).Value = P_str_GoodsSpec; sqlcom.Parameters.Add("GoodsUnit", SqlDbType.Char, 8).Value = P_str_GoodsUnit; sqlcom.Parameters.Add("GoodsNum", SqlDbType.BigInt).Value = P_int_GoodsNum; sqlcom.Parameters.Add("GoodsPrice", SqlDbType.Money).Value = P_dml_Goo

29、dsPrice; sqlcom.Parameters.Add("HandlePeople", SqlDbType.VarChar, 20).Value = P_str_HPeople; sqlcom.Parameters.Add("ISRemark", SqlDbType.VarChar, 1000).Value = P_str_Remark; SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4); returnValue.D

30、irection = 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 添加供應(yīng)商信息 /

31、 <summary> / 添加供應(yīng)商信息 / </summary> / <param name="P_str_PrName">供應(yīng)商名稱</param> / <param name="P_str_PrPeople">負(fù)責(zé)</param> / <param name="P_str_PrPhone">供應(yīng)商聯(lián)系電話</param> / <param name="P_str_PrFax">供應(yīng)商傳真號(hào)碼</p

32、aram> / <param name="P_int_PrRemark">備注</param> / <returns>返回一個(gè)int類型的值</returns> public int InsertProvider(string P_str_PrName, string P_str_PrPeople, string P_str_PrPhone, string P_str_PrFax, string P_int_PrRemark) SqlConnection sqlcon = datacon.getcon(); SqlCom

33、mand sqlcom = new SqlCommand("proc_insertProvider", sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("PrName", SqlDbType.VarChar, 100).Value = P_str_PrName; sqlcom.Parameters.Add("PrPeople", SqlDbType.VarChar, 20).Value = P_str_PrPeople;

34、sqlcom.Parameters.Add("PrPhone", SqlDbType.VarChar, 20).Value = P_str_PrPhone; sqlcom.Parameters.Add("PrFax", SqlDbType.VarChar, 20).Value = P_str_PrFax; sqlcom.Parameters.Add("PrRemark", SqlDbType.VarChar, 1000).Value = P_int_PrRemark; SqlParameter returnValue = sqlcom

35、.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)

36、returnValue.Value; return P_int_returnValue; #endregion #region 添加倉(cāng)庫(kù)信息 / <summary> / 添加倉(cāng)庫(kù)信息 / </summary> / <param name="P_str_StoreName">倉(cāng)庫(kù)名稱</param> / <param name="P_str_StorePeople">倉(cāng)庫(kù)負(fù)責(zé)</param> / <param name="P_str_StorePhone"&g

37、t;倉(cāng)庫(kù)電話</param> / <param name="P_str_StoreUnit">倉(cāng)庫(kù)所屬單位</param> / <param name="P_int_StoreRemark">備注</param> / <returns>返回一個(gè)int類型的值</returns> public int InsertStorage(string P_str_StoreName, string P_str_StorePeople, string P_str_StorePhone

38、, string P_str_StoreUnit, string P_int_StoreRemark) SqlConnection sqlcon = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_insertStorage", sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("StoreName", SqlDbType.VarChar, 100).Value = P_st

39、r_StoreName; sqlcom.Parameters.Add("StorePeople", SqlDbType.VarChar, 20).Value = P_str_StorePeople; sqlcom.Parameters.Add("StorePhone", SqlDbType.VarChar, 20).Value = P_str_StorePhone; sqlcom.Parameters.Add("StoreUnit", SqlDbType.VarChar, 100).Value = P_str_StoreUnit; s

40、qlcom.Parameters.Add("StoreRemark", SqlDbType.VarChar, 1000).Value = P_int_StoreRemark; SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4); returnValue.Direction = ParameterDirection.ReturnValue; sqlcon.Open(); try sqlcom.ExecuteNonQuery(); catch (E

41、xception ex) MessageBox.Show(ex.Message); finally sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); int P_int_returnValue = (int)returnValue.Value; return P_int_returnValue; #endregion #region 添加新用戶 / <summary> / 添加新用戶 / </summary> / <param name="P_str_UserName">用戶名<

42、/param> / <param name="P_str_UserPwd">用戶密碼</param> / <param name="P_str_UserRight">用戶權(quán)限</param> / <returns>返回一個(gè)int類型的值</returns> public int InsertUser(string P_str_UserName, string P_str_UserPwd, string P_str_UserRight) SqlConnection sqlcon

43、= datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_insertUser",sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("UserName", SqlDbType.VarChar, 20).Value = P_str_UserName; sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).V

44、alue = P_str_UserPwd; sqlcom.Parameters.Add("UserRight", SqlDbType.Char, 10).Value = P_str_UserRight; SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4); returnValue.Direction = ParameterDirection.ReturnValue; sqlcon.Open(); try sqlcom.ExecuteNonQue

45、ry(); catch (Exception ex) MessageBox.Show(ex.Message); finally sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); int P_int_returnValue = (int)returnValue.Value; return P_int_returnValue; #endregion #region 修改用戶信息 / <summary> / 修改用戶信息 / </summary> / <param name="P_int_UID"

46、>用戶編號(hào)</param> / <param name="P_str_UserPwd">用戶密碼</param> / <param name="P_str_UserRight">用戶權(quán)限</param> / <returns>返回一個(gè)int類型的值</returns> public void updateUser(int P_int_UID,string P_str_UserPwd, string P_str_UserRight) SqlConnection sql

47、con = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_updateUser", sqlcon); sqlcom.CommandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("UserID", SqlDbType.BigInt).Value = P_int_UID; sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value =

48、P_str_UserPwd; sqlcom.Parameters.Add("UserRight", SqlDbType.Char, 10).Value = P_str_UserRight; sqlcon.Open(); try sqlcom.ExecuteNonQuery(); catch (Exception ex) MessageBox.Show(ex.Message); finally sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); #endregion 登陸界面（frmLogin.cs）using System

49、;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;/記錄登錄用戶密碼 publ