管理信息系統(tǒng)ERP系統(tǒng)庫存子系統(tǒng)設計課設代碼

1、主界面程序using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using SJZU;public partial class Frm_Main: Form _public Frm_Main() _In itializeComp onen t();private void Frm_Main_Load( object sender, Ev

2、entArgs e)toolStripStatusLabel6.Text =DateTime.Now.ToStri ng();private void 查詢分析 ToolStripMenultem3_Click( object sender,Eve ntArgs e)Frm_Warehouse_Querfrm_Warehouse_Query = newFrm_Warehouse_Quer();frm_Warehouse_Query.ShowDialog(); 一 一private void 添加倉庫信息 ToolStripMenultem_Click( object sender, Eve n

3、tArgs e)Frm_Warehouse_Addrm_Warehouse_Add = newFrm_Warehouse_Ad(d;frm_Warehouse_Add.ShowDialog(); 一 一private void 修改倉庫信息 ToolStripMenultem_Click( object sender, Eve ntArgs e)Frm_Warehouse_Updatfrm_Warehouse_Update = new Frm_Warehouse_Update);frm_Warehouse_Update.ShowDialog();private void 刪除倉庫信息 Tool

4、StripMenultem_Click( object sender,Eve ntArgs e)Frm_Warehouse_Delete frm_Warehouse_Delete = newFrm_Warehouse_Delete(); frm_Warehouse_Delete.ShowDialog(); 一 一倉庫信息添加界面using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;usin

5、g System.Windows.Forms;using SJZU.SWEIMS.BusinessModel;using SJZU.SWEIMS.BusinessLogic;public partial class Frm_Warehouse_Add Formpublic Frm_Warehouse_Add() 一 一In itializeComp onen t();private void Frm_Warehouse_Add_Load(bject sender, EventArgs e)/添加按鈕事件private void btnAdd_Click( object sender, Even

6、tArgs e)if ( stringsNullOrEmpty(txtWarehouseCode.Text.Trim()MessageBoxShow(”請將數(shù)據(jù)完整輸入！,提示, MessageBoxButt on s.OK);elseWarehouseMa nagwarehouseMa nage = new WarehouseMan agWarehouseTable warehouseTable = new WarehouseTable() warehouseTable.WarehouseCode =(string )txtWarehouseCode.Text;warehouseTable.

7、WarehouseName =string )txtProperty.Text;string )txtAddress.Text;string )txtTel.Text;string )txtDirector.Text; string )txtCreateBy.Text;yyyyMMdd);string )txtSummary.Text;(string )txtWarehouseName.Text; warehouseTable.Property =( warehouseTable.Departme nt =(string )txtDepartment.Text; warehouseTable.

8、Address =( warehouseTable.Tel =( warehouseTable.Director =( warehouseTable.CreateBy =( warehouseTable.CreateTime = int .Parse(dtpCreateTime.Value.ToString( warehouseTable.Summary =( int i = warehouseMa nage.AddWarehouseTable(warehouseTable);if (i 0)MessageBoxShow(” 已插入+ i +條記錄！,提示,MessageBoxButt on

9、s.OK);elseMessageBoxShow(” 插入失?。?提示, MessageBoxButt on s.OK);/取消按鈕事件object sender,Eve ntArgs e)private void btnCan el_Click(null ; null ; null ;null ;txtWarehouseCode.Text = txtWarehouseName.Text = txtProperty.Text = txtDepartme nt.Text =nullnull ;nullnulltxtAddress.Text = txtTel.Text = txtDirector.

10、Text = txtCreateBy.Text =txtSummary.Text =null ;/退出按鈕事件private void btnExit_Click(object sender,EventArgs e) _this .Close();倉庫信息刪除界面using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using SJZU

11、.SWEIMS.BusinessLogic;public partial class Frm_Warehouse_Delete : Formpublic Frm_Warehouse_Delete() 一 一In itializeComp onen t();點開刪除界面時，向下拉菜單中加載可選的倉庫編號private void Frm_Warehouse_Delete_Load(object sender, EventArgse)AddWarehouseCode();private void AddWarehouseCode() newcboWarehouseCode.DataSource =W

12、arehouseMa nag().GetWarehouseCode(); cboWarehouseCode.DisplayMember =WAREHOUSECQDE/查詢選擇的倉庫信息private void btnQuery_Click( object sender, EventArgs e) _if ( string .IsNullQrEmpty(cboWarehouseCode.Text)MessageBo)6how(”請選擇出庫單編號！);elsedgvWarehouseDetails.DataSource =newWarehouseMa nage.GetWarehouseTable(

13、cboWarehouseCode.Text);/刪除選中的倉庫private void btnDelete_Click(object sender, EventArgs e) _if ( string .IsNullQrEmpty(cboWarehouseCode.Text)MessageBo)6how(”請選擇出庫單編號！);elseint i = newWarehouseMa nage.DeleteWarehouse(cboWarehouseCode.Text);MessageBo)6how(” 已經(jīng)刪除+i+條記錄！);dgvWarehouseDetails.DataSource =nu

14、ll ;AddWarehouseCode();點擊退出，關閉窗口private void btnExit_Click(object sender, EventArgs e) _this .Close();倉庫信息更新界面using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using SJZU.SWEIMS.BusinessModel;

15、using SJZU.SWEIMS.BusinessLogic;using System.Data.SqlClient;using SJZU.SWEIMS.DBUtility;public partial class Frm_Warehouse_Update Form 一 一WarehouseMa nagwarehouseMa nage = new WarehouseMa nagSqlDataAdapter adapter;DataTable table;public Frm_Warehouse_Update()In itializeComp onen t();private void Frm

16、_Warehouse_Update_Loadobject sender, EventArgse)cboWarehouseCode.DataSource =warehouseMa nage.GetWarehouseCode();cboWarehouseCode.DisplayMember =WAREHOUSECQDE/查詢倉庫信息private void btnQuery_Click( object sender, EventArgs e) _if ( string .IsNullQrEmpty(cboWarehouseCode.Text)MessageBo)6how(”請選擇要查詢的倉庫編號！

17、);elsestri ng warehouseCode = cboWarehouseCode.Text;stri ng strsql = select * from WAREHOUSE whereWAREHQUSECQDE+=warehouseCode;stri ng connection Stri ng= SQLHelper._c onnection Stri ng;SqlConnection conn = newSqlConnection (connectionString);adapter =new SqlDataAdapter (strsql, conn);SqlComma ndBui

18、lder builder =newSqlComma ndBuilder(adapter);adaptern sertComma nd = builder.Get In sertComma nd(); adapter.DeleteComma nd = builder.GetDeleteComma nd(); adapter.UpdateComma nd = builder.GetUpdateComma nd(); table =new DataTable ();adapter.Fill(table);dgvWarehouseDetails.DataSource = table;private v

19、oid btnUpdate_Click( object sender, EventArgs e) _dgvWarehouseDetails.E ndEdit();tryadapter.Update(table);MessageBo)6how(” 保存成功！);catch ( SqlException err)MessageBo)6how(err.Message,保存成功！);private void btnExit_Click(object sender,EventArgs e) _this .Close();倉庫信息查詢界面using System;using System.Collecti

20、ons.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using SJZU.SWEIMS.BusinessModel;using SJZU.SWEIMS.BusinessLogic;public partial class Frm_Warehouse_Query Form 一 一public Frm_Warehouse_Query() 一 一In itializeComp onen t();privat

21、e void Frm_Warehouse_Query_Loadobject sender, EventArgse)/按選擇的條件查詢倉庫信息private void btnQuery_Click( object sender, EventArgs e) _int startTime =int .Parse(dtpStart.Value.ToString(yyyyMMdd);int endTime = int .Parse(dtpEnd.Value.ToString(yyyyMMdd);if (startTime endTime)MessageBo)6how(開始時間不能晚于結束時間！);els

22、e/按時間查詢，倉庫編號和負責人都不是查詢條件if (cbWarehouseCode.Checked = false &cbDirector.Checked = false )dgvWarehouseDetails.DataSource =newWarehouseMa nag(e.GetWarehouseTable(startTime, en dTime);/按時間和倉庫編號查詢else if (cbWarehouseCode.Checked = true &cbDirector.Checked = false )stri ng warehouseCode = txtWarehouseCode

23、.Text;if ( stringsNullOrEmpty(warehouseCode.Trim()MessageBo）6how（請輸入倉庫編號!）;elsedgvWarehouseDetails.DataSource =newWarehouseMa nag(e.GetWarehouseTable(startTime, en dTime, warehouseCode);/按時間和負責人查詢else if (cbWarehouseCode.Checked = false & cbDirector.Checked = true )stri ng director = txtDirector.Tex

24、t;if ( stringsNullOrEmpty(director.Trim()MessageBo)6how(” 請輸入負責人!);elsedgvWarehouseDetails.DataSource =newWarehouseMa nag(e.GetWarehouseTable(startTime, en dTime, director,9);/按時間，倉庫編號，負責人查詢else if (cbWarehouseCode.Checked = true & cbDirector.Checked = true )stri ng warehouseCode = txtWarehouseCode.

25、Text; stri ng director = txtDirector.Text;if ( stringsNullOrEmpty(warehouseCode.Trim() | stringsNullOrEmpty(director.Trim()MessageBo)6how(”所選條件不能為空!);elsedgvWarehouseDetails.DataSource =newWarehouseMa nag(e.GetWarehouseTable(startTime, en dTime, warehouseCode,director);private void btnExit_Click( ob

26、ject sender,EventArgs e)this .Close();邏輯層代碼using System;using System.Collections.Generic;using System.Text;using System.Data.SqlClient;using SJZU.SWEIMS.DBUtility;using SJZU.SWEIMS.BusinessModel; using System.Data;n amespaceSJZU.SWEIMS.Busi nessLogic public class WarehouseManage /向數(shù)據(jù)庫WAREHOU表中添加倉庫數(shù)據(jù)

27、public int AddWarehouseTable( WarehouseTable warehouseTable)stri ng strsql =+II+in sert into WAREHOUSE(WAREHOUSECODE, WAREHOUSENAME, PROPERTY, DEPARTMENT, ADDRESS,TEL, DIRECTOR, CREATEBY, CREATETIME, SUMMARY)VALUES(WAREHOUSECODE, WAREHOUSENAME, PROPERTY, DEPARTMENT, ADDRESS,TEL, DIRECTOR, CREATEBY,

28、CREATETIME, SUMMAR Y)SqIParameter commandParms = new SqlParameter newSqlParameter (WAREHOUSEC,ODfiehouseTable.WarehouseCode),new SqIParameter (WAREHOUSENAME warehouseTable.WarehouseName),new SqlParameter (PROPERTY warehouseTable.Property),new SqlParameter (DEPARTMENT warehouseTable.Departme nt),newS

29、qlParameter (ADDRES,warehouseTable.Address),newSqlParameter (TELwarehouseTable.Tel),new SqlParameter (DIRECTOR warehouseTable.Director),new SqlParameter (CREATEB,Y warehouseTable.CreateBy),newSqlParameter (CREATETIM,warehouseTable.CreateTime),newSqlParameter (SUMMARY3rehouseTable.Summary);int i = SQ

30、LHelper.ExecuteSql(strsql,commandParms); return i;/取得倉庫編號public DataTable GetWarehouseCode()stri ng strSql = select WAREHOUSECODE from WAREHOUSE return SQLHelper.Query(strSql).TablesO;/根據(jù)倉庫編號查詢倉庫詳細信息public DataTable GetWarehouseTable( string warehouseCode)stri ng strSql = select * from WAREHOUwEere

31、WAREHOUSECODE =WAREHOUSECODESqlParameter commandParms = new SqlParameter new SqlParameter (WAREHOUSEC,ODEehouseCode) ;return SQLHelper.Query(strSql, comma ndParms).TablesO;/根據(jù)倉庫編號刪除倉庫信息public int DeleteWarehouse( string warehouseCode)stri ng strSql = delete from WAREHOUSE where WAREHOUSECODE =WAREHO

32、USECODESqlParameter commandParms = new SqlParameter new SqlParameter (WAREHOUSEC,ODEehouseCode) ;return SQLHelper.ExecuteSql(strSql, comma ndParms);/根據(jù)時間階段查詢倉庫信息public DataTable GetWarehouseTable( int startTime, int endTime)stri ng strSql = select * from WAREHOUWEere CREATETIME= startTime and CREATE

33、TIME = en dTimeSqlParameter commandParms = new SqlParameter new SqlParameter (startTime , startTime), new SqlParameter (endTime en dTime) ;return SQLHelper.Query(strSql, comma ndParms).TablesO;/根據(jù)時間階段和倉庫編號查詢public DataTable GetWarehouseTable( int startTime, int endTime,stri ng warehouseCode)stri ng

34、strSql = select * from WAREHOUwEere CREATETIME= startTime and CREATETIM= en dTimea nd WAREHOUSECODE=warehouse CodeSqlParameter commandParms = new SqlParameter new SqlParameter (startTime , startTime), new SqlParameter (endTime endTime), new SqlParameter (warehouseCode warehouseCode);return SQLHelper

35、.Query(strSql, comma ndParms).TablesO;/根據(jù)時間階段和負責人查詢public DataTable GetWarehouseTable( int startTime, intendTime, string director, int i)stri ng strSql = select * from WAREHOUwEere CREATETIME= startTime and CREATETIME = en dTime and DIRECTOR=directorSqlParameter commandParms = new SqlParameter new S

36、qlParameter (startTime , startTime), new SqlParameter (endTime endTime), new SqlParameter (director , director) ;return SQLHelper.Query(strSql, comma ndParms).TablesO;/根據(jù)時間階段，倉庫編號和負責人查詢public DataTable GetWarehouseTable( int startTime, int endTime,string warehouseCode, string director)stri ng strSql = select * from WAREHOUwEere CREATETIME= startTime and CREATETIME = en dTime and WAREHOUSECODE=warehouseCode and DIRECTOR =director;SqlParameter commandParms = new SqlParameter new SqlParameter (startTime , startTime), new SqlParameter (end