數(shù)據(jù)庫課程設計-倉庫管理系統(tǒng)

1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE2任務書1、課程設計題目倉庫管理系統(tǒng)2、設計任務和內(nèi)容一個小型通用的倉庫管理系統(tǒng)是實現(xiàn)企業(yè)對庫存商品出庫、入庫進行高效的管理。通過應用系統(tǒng)應能結(jié)合銷售情況對庫存商品進行錄入、刪除、修改等操作。按照一定的條件，查詢、統(tǒng)計符合條件的商品信息；并且對查詢、統(tǒng)計的結(jié)果有一定的輸出。本課題任務是開發(fā)一個小型的倉庫管理系統(tǒng)，并撰寫符合規(guī)范的課程設計說明書以體現(xiàn)設計過程和設計結(jié)果。3、設計步驟和要求設計步驟：首先進行相關資料查閱和學習，了解基本的業(yè)務流程和系統(tǒng)數(shù)據(jù)功能要求。然后結(jié)合軟件工程的理論和教材中數(shù)據(jù)庫設計的六個階段（重點是前三個階段）完成設計任務，即系統(tǒng)結(jié)構(gòu)設計（需求分析、概念結(jié)構(gòu)設計、邏輯結(jié)構(gòu)設計、物理結(jié)構(gòu)設計）和系統(tǒng)功能設計。設計要求：1、撰寫課程設計說明書。其要求如下：（1）①能反映完成了上述設計內(nèi)容要求。②要求撰寫不少于5000個文字（20頁）的文檔。③文檔中至少要包括：數(shù)據(jù)流圖、數(shù)據(jù)字典、E-R圖、數(shù)據(jù)庫表的詳細說明、系統(tǒng)功能結(jié)構(gòu)圖、主要功能模塊說明。④課程設計說明書一律用碳素墨水書寫，其中用戶界面設計可以附界面的計算機截圖或手工繪圖。（2）文檔格式要求（遵循數(shù)據(jù)庫原理及應用課程設計大綱上的要求）其中，正文部分：①分章、層次等，每一章從新一頁開始。②章節(jié)安排可如下安排．概述：包括項目背景、編寫目的、軟件定義、開發(fā)環(huán)境等內(nèi)容。．需求分析：問題陳述、需完成的功能。以數(shù)據(jù)流圖和數(shù)據(jù)字典表達。．概念結(jié)構(gòu)設計：將上述需求分析的成果抽象為ER模型圖。．邏輯結(jié)構(gòu)設計：把ER模型圖轉(zhuǎn)換為關系表；描述每一個基本表關系。并進行規(guī)范化；定義視圖、定義索引、主關鍵字、定義權(quán)限。．軟件功能設計：畫出系統(tǒng)功能結(jié)構(gòu)圖，描述每個功能所完成的任務。．代碼設計和界面設計：給出主要功能的代碼并有適當?shù)恼f明；界面設計要合理，給出主要界面。1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE52、一個可運行的倉庫管理系統(tǒng)原型。（可選）教師簽名：摘 要隨著計算機技術(shù)的飛速發(fā)展，計算機在企業(yè)管理中應用的普及，利用計算機實現(xiàn)管理企業(yè)勢在必行。而倉庫管理系統(tǒng)是典型的信息管理系統(tǒng)，其開發(fā)主要包括后臺數(shù)據(jù)庫的建立和維護以及前端應用程序的開發(fā)兩個方面。對前者要求建立起數(shù)據(jù)一致性和完整性強、數(shù)據(jù)安全性好的庫。而對于后者則要求應用程序功能完備，易使用等特點。本文通過分析瀏覽器/B/S小型企業(yè)倉庫管理系統(tǒng)的基本設計思想，簡要介紹了系統(tǒng)各功能模塊及數(shù)據(jù)庫的設計，著重討論了用SQLServer2005開發(fā)企業(yè)倉庫管理系統(tǒng)時的數(shù)據(jù)庫訪問技術(shù)和動態(tài)網(wǎng)頁制作技術(shù),并給出B/SWindowsXPVS.NET平臺下開發(fā)完成，使用C的開發(fā)語言，SQLServer2005作為后臺數(shù)據(jù)庫，該數(shù)據(jù)庫系統(tǒng)在安全性、準確性、運行速度方面均有絕對的優(yōu)勢，并且能夠?qū)θ萘枯^大的數(shù)據(jù)庫進行處理，效率高。系統(tǒng)有較高的安全性和較好的性能本文中除了有對程序的系統(tǒng)分析、總體設計、數(shù)據(jù)庫設計、功能實現(xiàn)等主體部分外，在這之前還介紹了與企業(yè)倉庫管理系統(tǒng)相關的信息、VS.NET與SQL的無縫鏈接技術(shù)等。關鍵詞倉庫管理；信息管理系統(tǒng)；B/S結(jié)構(gòu)；數(shù)據(jù)庫管理目錄第一章概述項目背景編寫目的軟件定義開發(fā)環(huán)境第二章需求分析可行性分析功能分析數(shù)據(jù)流圖數(shù)據(jù)字典第三章概念結(jié)構(gòu)設計1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE63.1E-R圖第四章邏輯結(jié)構(gòu)設計關系表基本表關系。規(guī)范化第五章軟件功能設計系統(tǒng)功能結(jié)構(gòu)圖功能任務簡介第六章代碼設計和界面設計概述第一章概述項目背景倉庫存放的貨物品種繁多，堆存方式以及處理過程也非常復雜，隨著業(yè)務量的增加，倉庫管理者需要處理的信息量會大幅上升，因此往往很難及時準確的掌握整個倉庫的運作狀態(tài)。針對這一情況，本系統(tǒng)在滿足倉庫的基本管理功能基礎上發(fā)揮信息系統(tǒng)的智能化，減輕倉庫管理人員和操作人員的工作負擔。系統(tǒng)主要的實現(xiàn)目標是監(jiān)控整個倉庫的運轉(zhuǎn)情況；提供完善的出入庫登記功能且擁有便捷的查詢功能。編寫目的根據(jù)任務書要求，假想一小型企業(yè)擁有多個倉庫，擁有多種物品，且物品在倉庫中存在耗損情況。開發(fā)數(shù)據(jù)庫和系統(tǒng)平臺解決此問題。軟件介紹本系統(tǒng)包括一下幾個模塊。1）貨物管理提供入庫登記、出庫登記、損耗登記三個方面的登記功能方便的修改庫存信息。2）檔案管理提供貨物檔案設置、倉庫設置、分類設置三個方面的內(nèi)容。分別允許用戶更改貨物的屬性，倉庫的屬性，分類的屬性。頁腳內(nèi)容71.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE21查詢統(tǒng)計提供入庫查詢、出庫查詢、耗損查詢、庫存查詢四個方面的內(nèi)容。允許用戶隨時查詢倉庫的現(xiàn)狀。系統(tǒng)維護提供貨物檔案設置、倉庫設置、分類設置三個方面的內(nèi)容。分別允許用戶更改貨物的屬性，倉庫的屬性，分類的屬性。系統(tǒng)信息提供用戶管理，更改密碼，系統(tǒng)說明，退出系統(tǒng)四項功能。使軟件功能更加完善。開發(fā)環(huán)境語言環(huán)境C#語言平臺環(huán)境SQLServer2000,VisualStudio2005系統(tǒng)開發(fā)環(huán)境Win7,處理器T8300,內(nèi)存2G,顯卡Geforce8600GTWinXp/Vista/Win7,PentiumII30064M3G以上，顯VGA顯卡第二章需求分析可行性分析本軟件所有處理流程內(nèi)置,通過界面操作可以完成所有功能能,使用者無需具備SQL及C#語言知識,且軟件所有功能完全可以達成編寫目的,軟件運行硬件要求不高,開發(fā)軟件是完全可行的。功能分析本軟件所有處理流程內(nèi)置,通過界面操作可以完成所有功能能,使用者無需具備SQL及C#語言知識,且軟件所有功能完全可以達成編寫目的,軟件運行硬件要求不高,開發(fā)軟件是完全可行的。略數(shù)據(jù)項別名含義說明類數(shù)據(jù)項別名含義說明類長取名型 度值范圍GoodsI物品號標志每個物品i40-65D數(shù)據(jù)SN

庫存編

標志每條庫存信

nt 535i 4

流0-65號 息 nt 535SortID 類別ID 標志類

i 4nt 535

0-65StorageID

倉庫ID 標志倉庫編

i 4nt 535

0-65InOrder號

入庫單 每條入庫操作對應單號

i 4535

0-65OutOrder

出庫單 每條出庫操作對應單號

i 4535

0-65BreakOrder

損耗單 每條損耗操作對應單號

i 4535

0-65數(shù)據(jù)流名 說明 據(jù)來

數(shù) 組成據(jù)去向存儲入庫 把入庫信 貨 入 入庫單號,倉庫號,物品號,入庫數(shù)量,入庫單單息存入入庫單物庫單位,入庫日期單存儲出庫把出庫信息存入出庫單庫倉出庫單出庫單號,倉庫號,物品號,出庫數(shù)量,出庫單位,出庫日期存儲耗損把損耗信倉損耗損單號,倉庫號,物單息存入損耗單庫耗表品號,耗損數(shù)量,耗損日期,損耗備注數(shù)據(jù)結(jié)構(gòu)數(shù)據(jù)結(jié)數(shù)據(jù)結(jié)含義說明組成構(gòu)名貨物操作入庫出庫及損物品號,物品名,類別名稱,規(guī)格耗的物品倉庫存放所有貨物的載ID,倉庫名稱體數(shù)據(jù)存儲數(shù)據(jù)存說明編號流入數(shù)流出數(shù)組成儲名據(jù)流據(jù)流入庫單所有入D1入庫單入庫單庫信息記錄號,倉庫號,號,,入,入,入,入庫單位,入庫單位,入庫日期入庫日期入庫備注庫備注出庫單所有出D2出庫單出庫單庫信息記錄號,倉庫號,號,,出,出,出,出庫單位,出庫單位,出庫日期出庫日期出庫備注庫備注損耗單所有損D3耗損單耗損單耗信息記錄號,,耗號,,耗損數(shù)量,耗損數(shù)量,耗損日期損損日期損耗備注耗備注耗備注處理過程處理過程處理過程說明輸入輸出處理名入庫審核對入庫申入庫申請同意的入判斷入庫請進行審核庫申請,駁回 信息完整及數(shù)的入庫申請據(jù)正確與否,均正確則通過否則駁回入庫處理 將物品存 同意的入 入庫信 把貨物入入庫并登記入 庫申庫表

息,入庫單

庫并把信息記錄到入庫單出庫審核對出庫申請進行審核出庫申請同意的出庫申請駁回判斷出庫操作是否夠權(quán)的出庫申請限并核對倉庫中貨物是否足夠操作均正確則通過否則駁回出庫處理 將物品出 同意的出 出庫信 把貨物出庫并登記入出 庫申庫表

息,出庫單

庫并把信息記錄到出庫單損耗審核對損耗申損耗申請同意的損判斷損耗請進行審核耗申請駁回操作權(quán)限是否的損耗申請夠及倉庫中是否有此物均正確則通過,否則駁回損耗處理 將物品損 同意的損 損耗信 把貨物損耗報廢并登記 耗申請耗報廢并登記 耗申請息,損耗表耗報廢并把信入損耗表息記錄到損耗單第三章概念結(jié)構(gòu)設計3.1E-R圖圖略第四章邏輯結(jié)構(gòu)設計關系表類別信息表SortInfo字段名數(shù)據(jù)類必填字主鍵 備型 段SortIDint是是IDSortNameVarchar(1是0)稱SortLimitInt是限倉庫信息表StorageInfo字段名數(shù)據(jù)類必填字主鍵 備型 段StoragetIint是是IDDStorageNaStorageNaVarchar(2是me0)稱物品信息表GoodsInfo字段名數(shù)據(jù)類必填字主鍵 備型 段GoodsIDint是是IDGoodsNaVarchar(2是me0)稱SortIDInt是限SpecVarchar(10)限庫存信息庫存信息StoreInfo庫 字段名 數(shù)據(jù)類主鍵型

必填字段

存信息備注入SN int 是 是 庫存

庫信息入庫信息InInfo

動編號StoreID字段名

Int數(shù)據(jù)類t

是必填字主鍵段

倉庫號備注r

是

單號m

IntInt

是 數(shù)量是 倉庫號e e 是 修日InNum Int

期入庫數(shù)量InUnit

Varchar(2 0)

入庫單位InDate DateTime 期InRemark期InRemarkVarchar(100)OutInfo注字段名數(shù)據(jù)類必填字主鍵 備型 段OutOrderint是是號StorageIDInt是倉庫號GoodsIDInt是物品號OutNumInt是量OutUnitVarchar(2是0)位OutDateDateTime期

庫信息入

庫信息OutRemarVarchar(1OutRemarVarchar(1k00)注BreakInfo字段名數(shù)據(jù)類必填字主鍵 備型 段BreakOrdint是是er號StorageIDInt是倉庫號GoodsIDInt是物品號BreakNuInt是m量BreakDatDateTimee期BreakRemarkVarchar(100)注

戶信息UserInfo字段名數(shù)據(jù)類必填字主鍵 備型 段UserIDint是是IDUserNameVarchar(2是0)稱UserPassVarchar(8是word)碼UserLimitint是限基本表關系1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE221.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE29規(guī)范化createdatabaseStoreage--物品信息ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[GoodsInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableGoodsInfoGOCREATETABLEGoodsInfo(GoodsID intidentity(1,1)primarykey, --物品號編號 主GoodsNamevarchar(20)notnull, --物品名SortIDSpec)--類別信息

intnotvarchar(10)

--類別ID 外--規(guī)格 可空ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[SortInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableSortInfoGOCREATETABLESortInfo(SortID intidentity(1,1)primarykey, --類別ID 主SortNameSortLimit)--倉庫信息

varchar(10)notnull,intnotnull

--類別名稱--類別權(quán)限ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[StorageInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableStorageInfoGOCREATETABLEStorageInfo(StorageID intidentity(1,1)primarykey, --倉庫ID 主StorageNamevarchar(20)notnull)--庫存信息

--倉庫名稱ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[StoreInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableStoreInfoGOCREATETABLEStoreInfo(SN intidentity(1,1primarykey, --StoreIDGoodsIDSortID

intnotintnotintnot

--倉庫號 外--物品號 外--類別ID 外GoodsNum intnotEditDatedatetime)--入庫信息

--物品數(shù)量--修改日期可空ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[InInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableInInfoGOCREATETABLEInInfo(InOrder intidentity(1,1primarykey, --入庫單號主StorageID

intreferencesStorageInfo(StorageID)notnull,

--倉庫號 外GoodsIDInNum

intreferencesGoodsInfo(GoodsID)notnull, --物品號 外intnotnull, --入庫數(shù)量InUnit

datetime,

--入庫單位可空--入庫日期可空InRemark )--出庫信息

--入庫備注可空ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[OutInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableOutInfoGOCREATETABLEOutInfo(OutOrder intidentity(1,1primarykey, --出庫單號主StorageID

intreferencesStorageInfo(StorageID)notnull,

--倉庫號 外GoodsID intreferencesGoodsInfo(GoodsID)notnull, --物品號 外OutNumOutUnitOutDate

intnotnull,datetime,

--出庫數(shù)量--出庫單位可空--出庫日期可空OutRemarkvarchar(100))--損耗信息

--出庫備注可空ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[BreakInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableBreakInfoGOCREATETABLEBreakInfo(BreakOrderintidentity(1,1primarykey, --損耗單號主StorageID

intreferencesStorageInfo(StorageID)notnull,

--倉庫號 外GoodsID intreferencesGoodsInfo(GoodsID)notnull, --物品號 外BreakNum intnotBreakDate datetime,

--損耗數(shù)量--損耗日期可空)--用戶信息

--損耗備注可空ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[UserInfo]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptableUserInfoGOCREATETABLEUserInfo(UserID

intidentity(1,1)primarykey,

--用戶ID 主UserName

--用戶名UserPassword varchar(8),UserLimitint --類別(權(quán)限)圖略功能任務簡介簡述個部分功能

--用戶密碼第五章軟件功能設計代碼設計主界面1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE32usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE39namespaceXRX{publicpartialclassMain:Form{publicMain(){InitializeComponent();}privatevoid入庫登記(objectsender,EventArgse){GoodsManage.InManageAa=newXRX.GoodsManage.InManage();Aa.ShowDialog();}privatevoid出庫登記(objectsender,EventArgse){GoodsManage.OutManageAb=newXRX.GoodsManage.OutManage();Ab.ShowDialog();}privatevoid耗損登記(objectsender,EventArgse){GoodsManage.BreakManageAc=newXRX.GoodsManage.BreakManage();Ac.ShowDialog();}privatevoid貨物檔案設置(objectsender,EventArgse){InfoManage.GoodsInfoBa=newXRX.InfoManage.GoodsInfo();Ba.ShowDialog();}privatevoid倉庫檔案設置(objectsender,EventArgse){InfoManage.StoreInfoBb=newXRX.InfoManage.StoreInfo();Bb.ShowDialog();}privatevoid分類檔案設置(objectsender,EventArgse){InfoManage.SortInfoBc=newXRX.InfoManage.SortInfo();Bc.ShowDialog();}privatevoid入庫查詢(objectsender,EventArgse){QueryManage.InQueryCa=newXRX.QueryManage.InQuery();Ca.ShowDialog();}privatevoid出庫查詢(objectsender,EventArgse){QueryManage.OutQueryCb=newXRX.QueryManage.OutQuery();Cb.ShowDialog();}privatevoid損耗查詢(objectsender,EventArgse){QueryManage.BreakQueryCc=newXRX.QueryManage.BreakQuery();Cc.ShowDialog();}privatevoid庫存查詢(objectsender,EventArgse){QueryManage.StoreQueryCd=newXRX.QueryManage.StoreQuery();Cd.ShowDialog();}privatevoid備份數(shù)據(jù)(objectsender,EventArgse){SysManage.DataStoreDa=newXRX.SysManage.DataStore();Da.ShowDialog();}privatevoid恢復數(shù)據(jù)(objectsender,EventArgse){SysManage.DataRevertDb=newXRX.SysManage.DataRevert();Db.ShowDialog();}privatevoid用戶管理(objectsender,EventArgse){OtherManage.UserManageEa=newXRX.OtherManage.UserManage();Ea.ShowDialog();}privatevoid更改密碼(objectsender,EventArgse){OtherManage.EditPasswordEb=newXRX.OtherManage.EditPassword();Eb.ShowDialog();}privatevoid系統(tǒng)說明(objectsender,EventArgse){OtherManage.HelpEc=newXRX.OtherManage.Help();Ec.ShowDialog();}privatevoid退出系統(tǒng)(objectsender,EventArgse){Application.Exit();}privatevoidMain_FormClosing(objectsender,FormClosingEventArgse){if(MessageBox.Show("您真的要退出本系統(tǒng)嗎？","提示",MessageBoxButtons.OKCancel,MessageBoxIcon.Information)==DialogResult.OK)Application.Exit();}privatevoidMain_Load(objectsender,EventArgse){}}}登陸界面1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE40usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceXRX{publicpartialclassLogin:Form{1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE45publicstaticstringstrUName="";publicstaticstringstrUPwd="";publicLogin(){InitializeComponent();}privatevoidLogin_Load(objectsender,EventArgse){Useru=newUser();DataSetds=u.showLogin();this.cboxUName.DataSource=ds.Tables[0].DefaultView;this.cboxUName.DisplayMember="UserName";}privatevoidLogin_Click(objectsender,EventArgse){DataBasedb=newDataBase();SqlParameter[]Pa=newSqlParameter[3];Pa[0]=db.MakeInParam("@UserName",SqlDbType.VarChar,20,this.cboxUName.Text);Pa[1]=db.MakeInParam("@UserPassword",SqlDbType.VarChar,20,this.txtPwd.Text);Pa[2]=db.MakeOutParam("@rtn",SqlDbType.Int,20);db.ExecuteNonQuery(CommandType.StoredProcedure,"sp_Login",Pa);stringrtn=Pa[2].Value.ToString();if(rtn=="1"){Mainmain=newMain();strUName=this.cboxUName.Text;strUPwd=this.txtPwd.Text;this.Hide();main.Show();}elseMessageBox.Show("密碼錯誤!","登陸失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}privatevoidExit_Click(objectsender,EventArgse){Application.Exit();}privatevoidcboxUName_SelectedValueChanged(objectsender,EventArgse){DataBasedb=newDataBase();SqlDataReaderdr=db.ExecuteReader(CommandType.Text,"selectUserLimitfromUserInfowhereUserName='"+this.cboxUName.Text.Trim()+"'",null);if(dr.Read()){stringa=dr["UserLimit"].ToString();if(a=="1")this.labURight.Text"一級用戶";if(a"2")this.labURight.Text"二級用戶";if(a"3")this.labURight.Text"三級用戶";if(a"4")this.labURight.Text"管理員";if(a"5")this.labURight.Text="超級管理員";}dr.Close();}privatevoidcboxUName_SelectedIndexChanged(objectsender,EventArgse){}privatevoidLogin_FormClosing(objectsender,FormClosingEventArgse){Application.Exit();}}}入庫管理界面1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE46usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE53namespaceXRX.GoodsManage{publicpartialclassInManage:Form{inta=0,aa=0,bb=0;publicInManage(){InitializeComponent();}privatevoidInManage_Load(objectsender,EventArgse){aaa();}privatevoidaaa(){DataBasedb=newDataBase();DataSetds=db.GetDs(CommandType.StoredProcedure,"up_findStro",null);this.dgvISManage.DataSource=ds.Tables[0];this.cboxSName.DataSource=ds.Tables[0].DefaultView;this.cboxSName.DisplayMember="StorageName";boBox1.DataSourceds.Tables[0].DefaultView;boBox1.DisplayMember="GoodsName";this.dgvISManage.Columns[0].Visible=false;this.dgvISManage.Columns[1].HeaderText"倉庫名";this.dgvISManage.Columns[2].HeaderText"物品名";this.dgvISManage.Columns[3].HeaderText="入庫數(shù)量";this.dgvISManage.Columns[4].HeaderText="入庫單位";this.dgvISManage.Columns[5].HeaderText="入庫日期";this.dgvISManage.Columns[6].HeaderText="備注";this.dgvISManage.Columns[1].Width=100;this.dgvISManage.Columns[2].Width=80;this.dgvISManage.Columns[3].Width=80;this.dgvISManage.Columns[4].Width=80;this.dgvISManage.Columns[5].Width=80;this.dgvISManage.Columns[6].Width=100;this.dgvISManage.ReadOnly=true;//只讀dgvISManage.SelectionMode=DataGridViewSelectionMode.FullRowSelect;//選中行this.dgvISManage.AllowUserToResizeRows=false;this.dgvISManage.AllowUserToResizeColumns=false;//禁止拖動this.dgvISManage.DefaultCellStyle.Alignment=DataGridViewContentAlignment.MiddleCenter;//文本居中this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment=DataGridViewContentAlignment.MiddleCenter;//表頭居中}privatevoiddgvISManage_CellClick(objectsender,DataGridViewCellEventArgse){try{a=Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString());this.cboxSName.Text=this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString();this.textBox1.Text=this.dgvISManage.Rows[e.RowIndex].Cells[7].Value.ToString();boBox1.Text=this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString();this.txtGSpec.Text=this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString();this.dateTimePicker1.Value=Convert.ToDateTime(this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString());this.txtGIPrice.Text=this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString();this.txtISRemark.Text=this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString();}catch{}}privatevoidbtnAdd_Click(objectsender,EventArgse){DataBasedb=newDataBase();SqlParameter[]Pa=newSqlParameter[6];Pa[0]=db.MakeInParam("@StorageID",SqlDbType.Int,4,aa);Pa[1]=db.MakeInParam("@GoodsID",SqlDbType.Int,4,bb);Pa[2]=db.MakeInParam("@InNum",SqlDbType.Int,4,Convert.ToInt32(this.txtGSpec.Text));Pa[3]=db.MakeInParam("@InUnit",SqlDbType.VarChar,20,this.txtGIPrice.Text);Pa[4]=db.MakeInParam("@InDate",SqlDbType.VarChar,20,this.dateTimePicker1.Value);Pa[5]=db.MakeInParam("@InRemark",SqlDbType.VarChar,20,this.txtISRemark.Text);intb=db.ExecuteNonQuery(CommandType.StoredProcedure,"up_InStore",Pa);intAdd=db.ExecuteNonQuery(CommandType.Text,"insertintoInInfo(StorageID,GoodsID,InNum,InUnit,InDate,InRemark)values('"+aa+"','"+bb+"','"+this.txtGSpec.Text+"','"+this.txtGIPrice+"','"+this.dateTimePicker1.Value+"','"+this.txtISRemark.Text+"')",null);if(Add==1){MessageBox.Show("添加入庫信息成功""添加成功"MessageBoxButtons.OK,MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("添加入庫信息失敗","添加失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}privatevoidcboxSName_SelectedIndexChanged(objectsender,EventArgse){DataBasedb=newDataBase();SqlDataReaderdr=db.ExecuteReader(CommandType.Text,"selectStorageIDfromStorageInfowhereStorageName='"+this.cboxSName.Text+"'",null);if(dr.Read())aa=Convert.ToInt32(dr["StorageID"].ToString());dr.Close();SqlDataReaderdr2=db.ExecuteReader(CommandType.Text,"selectGoodsIDfromGoodsInfowhereGoodsName='"+boBox1.Text+"'",null);if(dr2.Read())bb=Convert.ToInt32(dr2["GoodsID"].ToString());dr2.Close();}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}privatevoidbtnDel_Click(objectsender,EventArgse){DataBasedb=newDataBase();intDelete=db.ExecuteNonQuery(CommandType.Text,"deletefromInInfowhereInOrder='"+a+"'",null);if(Delete==1){MessageBox.Show("刪除入庫信息成功","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);aaa();}else1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE54{MessageBox.Show("刪除入庫信息失敗","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}}}出庫管理界面usingSystem;1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE62usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceXRX.GoodsManage{publicpartialclassOutManage:Form{inta=0,aa=0,bb=0;publicOutManage(){InitializeComponent();}privatevoidbtnAdd_Click(objectsender,EventArgse){DataBasedb=newDataBase();SqlParameter[]Pa=newSqlParameter[6];Pa[0]=db.MakeInParam("@StorageID",SqlDbType.Int,4,aa);Pa[1]=db.MakeInParam("@GoodsID",SqlDbType.Int,4,bb);Pa[2]=db.MakeInParam("@OutNum",SqlDbType.Int,4,Convert.ToInt32(this.txtGSpec.Text));Pa[3]=db.MakeInParam("@OutUnit",SqlDbType.VarChar,20,this.txtGIPrice.Text);Pa[4]=db.MakeInParam("@OutDate",SqlDbType.VarChar,20,this.dateTimePicker1.Value);Pa[5]=db.MakeInParam("@OutRemark",SqlDbType.VarChar,20,this.txtISRemark.Text);intb=db.ExecuteNonQuery(CommandType.StoredProcedure,"up_OutStore",Pa);intAdd=db.ExecuteNonQuery(CommandType.Text,"insertintoOutInfo(StorageID,GoodsID,OutNum,OutUnit,OutDate,OutRemark)values('"+aa+"','"+bb+"','"+this.txtGSpec.Text+"','"+this.txtGIPrice+"','"+this.dateTimePicker1.Value+"','"+this.txtISRemark.Text+"')",null);if(Add==1){MessageBox.Show("添加出庫信息成功""添加成功"MessageBoxButtons.OK,MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("添加出庫信息失敗","添加失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}privatevoidbtnDel_Click(objectsender,EventArgse){DataBasedb=newDataBase();intDelete=db.ExecuteNonQuery(CommandType.Text,"deletefromOutInfowhereOutOrder='"+a+"'",null);if(Delete==1){MessageBox.Show("刪除入庫信息成功","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("刪除入庫信息失敗","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}privatevoidOutManage_Load(objectsender,EventArgse){aaa();}privatevoidaaa(){DataBasedb=newDataBase();DataSetds=db.GetDs(CommandType.StoredProcedure,"up_findStrob",null);this.dgvISManage.DataSource=ds.Tables[0];this.cboxSName.DataSource=ds.Tables[0].DefaultView;this.cboxSName.DisplayMember="StorageName";boBox1.DataSourceds.Tables[0].DefaultView;boBox1.DisplayMember="GoodsName";this.dgvISManage.Columns[0].Visible=false;this.dgvISManage.Columns[1].HeaderText"倉庫名";this.dgvISManage.Columns[2].HeaderText"物品名";this.dgvISManage.Columns[3].HeaderText="出庫數(shù)量";this.dgvISManage.Columns[4].HeaderText="出庫單位";this.dgvISManage.Columns[5].HeaderText="出庫日期";this.dgvISManage.Columns[6].HeaderText="備注";this.dgvISManage.Columns[1].Width=100;this.dgvISManage.Columns[2].Width=80;this.dgvISManage.Columns[3].Width=80;this.dgvISManage.Columns[4].Width=80;this.dgvISManage.Columns[5].Width=80;this.dgvISManage.Columns[6].Width=100;this.dgvISManage.ReadOnly=true;//只讀dgvISManage.SelectionMode=DataGridViewSelectionMode.FullRowSelect;//選中行this.dgvISManage.AllowUserToResizeRows=false;this.dgvISManage.AllowUserToResizeColumns=false;//禁止拖動this.dgvISManage.DefaultCellStyle.Alignment=DataGridViewContentAlignment.MiddleCenter;//文本居中this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment=DataGridViewContentAlignment.MiddleCenter;//表頭居中}privatevoiddgvISManage_CellClick(objectsender,DataGridViewCellEventArgse){try{a=Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString());this.cboxSName.Text=this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString();this.textBox1.Text=this.dgvISManage.Rows[e.RowIndex].Cells[7].Value.ToString();boBox1.Text=this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString();this.txtGSpec.Text=this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString();this.dateTimePicker1.Value=Convert.ToDateTime(this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString());this.txtGIPrice.Text=this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString();this.txtISRemark.Text=this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString();}catch{}}privatevoidcboxSName_SelectedIndexChanged(objectsender,EventArgse){DataBasedb=newDataBase();SqlDataReaderdr=db.ExecuteReader(CommandType.Text,"selectStorageIDfromStorageInfowhereStorageName='"+this.cboxSName.Text+"'",null);if(dr.Read())aa=Convert.ToInt32(dr["StorageID"].ToString());dr.Close();SqlDataReaderdr2=db.ExecuteReader(CommandType.Text,"selectGoodsIDfromGoodsInfowhereGoodsName='"+boBox1.Text+"'",null);if(dr2.Read())bb=Convert.ToInt32(dr2["GoodsID"].ToString());dr2.Close();}}}1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE633.3損耗管理界面using3.3損耗管理界面usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE70namespaceXRX.GoodsManage{publicpartialclassBreakManage:Form{inta=0,aa=0,bb=0;publicBreakManage(){InitializeComponent();}privatevoidbtnAdd_Click(objectsender,EventArgse){DataBasedb=newDataBase();SqlParameter[]Pa=newSqlParameter[6];Pa[0]=db.MakeInParam("@StorageID",SqlDbType.Int,4,aa);Pa[1]=db.MakeInParam("@GoodsID",SqlDbType.Int,4,bb);Pa[2]=db.MakeInParam("@BreakNum",SqlDbType.Int,4,Convert.ToInt32(this.txtGSpec.Text));Pa[3]=db.MakeInParam("@BreakDate",SqlDbType.VarChar,20,this.dateTimePicker1.Value);Pa[4]=db.MakeInParam("@BreakRemark",SqlDbType.VarChar,20,this.txtISRemark.Text);intb=db.ExecuteNonQuery(CommandType.StoredProcedure,"up_BreakStore",Pa);intAdd=db.ExecuteNonQuery(CommandType.Text,"insertintoBreakInfo(StorageID,GoodsID,BreakNum,BreakDate,BreakRemark)values('"+aa+"','"+bb+"','"+this.txtGSpec.Text+"','"+this.dateTimePicker1.Value+"','"+this.txtISRemark.Text+"')",null);if(Add==1){MessageBox.Show("添加損耗信息成功""添加成功"MessageBoxButtons.OK,MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("添加損耗信息失敗","添加失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}privatevoidbtnDel_Click(objectsender,EventArgse){DataBasedb=newDataBase();intDelete=db.ExecuteNonQuery(CommandType.Text,"deletefromBreakInfowhereBreakOrder='"+a+"'",null);if(Delete==1){MessageBox.Show("刪除入庫信息成功","修改成功",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);aaa();}else{MessageBox.Show("刪除入庫信息失敗","修改失敗",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}privatevoidBreakManage_Load(objectsender,EventArgse){aaa();}privatevoidaaa(){DataBasedb=newDataBase();DataSetds=db.GetDs(CommandType.StoredProcedure,"up_findStroc",null);this.dgvISManage.DataSource=ds.Tables[0];this.cboxSName.DataSource=ds.Tables[0].DefaultView;this.cboxSName.DisplayMember="StorageName";boBox1.DataSource=ds.Tables[0].DefaultView;boBox1.DisplayMember="GoodsName";this.dgvISManage.Columns[0].Visible=false;this.dgvISManage.Columns[1].HeaderText"倉庫名";this.dgvISManage.Columns[2].HeaderText"物品名";this.dgvISManage.Columns[3].HeaderText="損耗數(shù)量";this.dgvISManage.Columns[4].HeaderText="損耗日期";this.dgvISManage.Columns[5].HeaderText="備注";this.dgvISManage.Columns[1].Width=100;this.dgvISManage.Columns[2].Width=80;this.dgvISManage.Columns[3].Width=80;this.dgvISManage.Columns[4].Width=80;this.dgvISManage.Columns[5].Width=100;this.dgvISManage.ReadOnly=true;//只讀dgvISManage.SelectionMode=DataGridViewSelectionMode.FullRowSelect;//選中行this.dgvISManage.AllowUserToResizeRows=false;this.dgvISManage.AllowUserToResizeColumns=false;//禁止拖動this.dgvISManage.DefaultCellStyle.Alignment=DataGridViewContentAlignment.MiddleCenter;//文本居中this.dgvISManage.ColumnHeadersDefaultCellStyle.Alignment=DataGridViewContentAlignment.MiddleCenter;//表頭居中}privatevoiddgvISManage_CellClick(objectsender,DataGridViewCellEventArgse){try{a=Convert.ToInt32(this.dgvISManage.Rows[e.RowIndex].Cells[0].Value.ToString());this.cboxSName.Text=this.dgvISManage.Rows[e.RowIndex].Cells[1].Value.ToString();this.textBox1.Text=this.dgvISManage.Rows[e.RowIndex].Cells[6].Value.ToString();boBox1.Text=this.dgvISManage.Rows[e.RowIndex].Cells[2].Value.ToString();this.dateTimePicker1.Value=Convert.ToDateTime(this.dgvISManage.Rows[e.RowIndex].Cells[4].Value.ToString());this.txtGSpec.Text=this.dgvISManage.Rows[e.RowIndex].Cells[3].Value.ToString();this.txtISRemark.Text=this.dgvISManage.Rows[e.RowIndex].Cells[5].Value.ToString();}catch{}}privatevoidcboxSName_SelectedIndexChanged(objectsender,EventArgse){DataBasedb=newDataBase();SqlDataReaderdr=db.ExecuteReader(CommandType.Text,"selectStorageIDfromStorageInfowhereStorageName='"+this.cboxSName.Text+"'",null);if(dr.Read())aa=Convert.ToInt32(dr["StorageID"].ToString());dr.Close();SqlDataReaderdr2=db.ExecuteReader(CommandType.Text,"selectGoodsIDfromGoodsInfowhereGoodsName='"+boBox1.Text+"'",null);if(dr2.Read())bb=Convert.ToInt32(dr2["GoodsID"].ToString());dr2.Close();}}1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE73}貨物信息管理usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceXRX.InfoManage{publicpartialclassGoodsInfo:Form{publicGoodsInfo(){InitializeComponent();}}}倉庫信息管理usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE75namespaceXRX.InfoManage{publicpartialclassStoreInfo:Form{publicStoreInfo(){InitializeComponent();}privatevoidbtnAdd_Click(objectsender,EventArgse){}privatevoidbtnEdit_Click(objectsender,EventArgse){}privatevoidbtnDel_Click(objectsender,EventArgse){}privatevoidbtnExit_Click(objectsender,EventArgse){}privatevoiddgvPInfo_CellClick(objectsender,DataGridViewCellEventArgse){}privatevoidStoreInfo_Load(objectsender,EventArgse){}privatevoidaaa(){}}}類型信息管理1.1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE78usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceXRX.InfoManage{publicpartialclassSortInfo:Form{publicSortInfo(){InitializeComponent();}}}入庫查詢usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;namespaceXRX.QueryManage1.概述1.概述頁腳內(nèi)容頁腳內(nèi)容PAGE80{public