倉庫管理系統(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);

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

3、figuration("")assembly: AssemblyCompany("")assembly: AssemblyProduct("warehouse")assembly: AssemblyCopyright("所有 2009")assembly: AssemblyTrademark("")assembly: AssemblyCulture("")/ 將 ComVisible 設(shè)置為 false 使此程序集中的類型/ 對 COM 組件不可見。如果需要從 COM 訪問此

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

5、;)數(shù)據(jù)庫連接類（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ù)庫連接 / <summary> / 建立數(shù)據(jù)庫連接. / </summary> / <returns>返回SqlConnection對象</returns> public Sql

6、Connection 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_str_sql

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

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

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

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

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

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

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

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

15、t;>表名</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_sqlstr, M

16、_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> public b

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

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

19、) 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>返回一個(gè)int類型的值</returns&

20、gt; public int UserLogin(string P_str_UserName, string P_str_UserPwd) SqlConnection sqlcon = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_Login", sqlcon); sqlcom mandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("UserName", SqlDbType.VarChar, 20).Value =

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

22、y(); catch (Exception ex) MessageBox.Show(ex.Message); finally sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); int P_int_returnValue = (int)returnValue.Value; return P_int_returnValue; #endregion #region 貨物入庫 / <summary> / 貨物入庫 / </summary> / <param name="P_int_GoodsID"&

23、gt;貨物編號</param> / <param name="P_str_GoodsName">貨物名稱</param> / <param name="P_str_PrName">供應(yīng)商名稱</param> / <param name="P_str_StoreName">倉庫名稱</param> / <param name="P_str_GoodsSpec">貨物規(guī)格</param> / <param

24、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="P_str_Remark">備注&

25、lt;/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_HPeople,string P_str_Remark) S

26、qlConnection sqlcon = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_insertInStore", sqlcon); sqlcom mandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("GoodsID", SqlDbType.BigInt).Value = P_int_GoodsID; sqlcom.Parameters.Add("GoodsName", SqlDbTyp

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

28、str_GoodsSpec; sqlcom.Parameters.Add("GoodsUnit", SqlDbType.Char, 8).Value = P_str_GoodsUnit; sqlcom.Parameters.Add("GoodsNum", SqlDbType.BigInt).Value = P_int_GoodsNum; sqlcom.Parameters.Add("GoodsPrice", SqlDbType.Money).Value = P_dml_GoodsPrice; sqlcom.Parameters.Add

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

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

31、lt;/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)商 </param> / <param name="P_i

32、nt_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(); SqlCommand sqlcom = new SqlCommand("

33、proc_insertProvider", sqlcon); sqlcom mandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("PrName", SqlDbType.VarChar, 100).Value = P_str_PrName; sqlcom.Parameters.Add("PrPeople", SqlDbType.VarChar, 20).Value = P_str_PrPeople; sqlcom.Parameters.Add("PrPhone&qu

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

35、;, 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_return

36、Value; #endregion #region 添加倉庫信息 / <summary> / 添加倉庫信息 / </summary> / <param name="P_str_StoreName">倉庫名稱</param> / <param name="P_str_StorePeople">倉庫負(fù)責(zé)</param> / <param name="P_str_StorePhone">倉庫</param> / <param name=&q

37、uot;P_str_StoreUnit">倉庫所屬單位</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, string P_str_StoreUnit, string P_int_S

38、toreRemark) SqlConnection sqlcon = datacon.getcon(); SqlCommand sqlcom = new SqlCommand("proc_insertStorage", sqlcon); sqlcom mandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("StoreName", SqlDbType.VarChar, 100).Value = P_str_StoreName; sqlcom.Parameters.Add("St

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

40、;, SqlDbType.VarChar, 1000).Value = P_int_StoreRemark; SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4); returnValue.Direction = ParameterDirection.ReturnValue; sqlcon.Open(); try sqlcom.ExecuteNonQuery(); catch (Exception ex) MessageBox.Show(ex.Message); f

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

42、rPwd">用戶密碼</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 = datacon.getcon(); SqlCommand sqlcom = new

43、 SqlCommand("proc_insertUser",sqlcon); sqlcom mandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("UserName", SqlDbType.VarChar, 20).Value = P_str_UserName; sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd; sqlcom.Parameters.Add(&q

44、uot;UserRight", SqlDbType.Char, 10).Value = P_str_UserRight; SqlParameter returnValue = sqlcom.Parameters.Add("returnValue", SqlDbType.Int, 4); returnValue.Direction = ParameterDirection.ReturnValue; sqlcon.Open(); try sqlcom.ExecuteNonQuery(); catch (Exception ex) MessageBox.Show(ex.

45、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">用戶編號</param> / <param name="

46、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 sqlcon = datacon.getcon(); SqlCommand sqlcom = ne

47、w SqlCommand("proc_updateUser", sqlcon); sqlcom mandType = CommandType.StoredProcedure; sqlcom.Parameters.Add("UserID", SqlDbType.BigInt).Value = P_int_UID; sqlcom.Parameters.Add("UserPwd", SqlDbType.VarChar, 20).Value = P_str_UserPwd; sqlcom.Parameters.Add("UserRi

48、ght", SqlDbType.Char, 10).Value = P_str_UserRight; sqlcon.Open(); try sqlcom.ExecuteNonQuery(); catch (Exception ex) MessageBox.Show(ex.Message); finally sqlcom.Dispose(); sqlcon.Close(); sqlcon.Dispose(); #endregion 登陸界面（frmLogin.cs）using System;using System.Collections.Generic;using System ponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;namespace warehouse public partial class frmLogin : Form public static string M_str_name;/記錄登錄用戶名字 public static string M_str_pwd;/記錄登錄用戶密碼 public static string M_str_right