大管家固定資產(chǎn)管理系統(tǒng)實訓(xùn)指導(dǎo)書

項目實訓(xùn)指導(dǎo)書

版本歷史版本/狀態(tài)修訂人修改日期備注1.0.0鄧?yán)^林2014-06-25創(chuàng)建文檔

開發(fā)背景隨著社會經(jīng)濟(jì)的不斷發(fā)展，企業(yè)規(guī)模越來越大，企業(yè)資產(chǎn)維護(hù)變得越來越困難，尤其是在手工管理方式下，財會人員對資產(chǎn)進(jìn)行折舊時。如果企業(yè)資產(chǎn)很多，可以想象財會人員的工作強(qiáng)度，既要按時對資產(chǎn)進(jìn)行折舊，即每年對資產(chǎn)進(jìn)行折舊，又要保證數(shù)據(jù)的準(zhǔn)確性，因為一旦某個年的資產(chǎn)折舊有誤，會影響以后的資產(chǎn)核算。信息化的發(fā)展幫助企業(yè)解決了上述難題，計算機(jī)的使用使財會人員從繁重的勞動中解脫出來，以往需要對資產(chǎn)信息一項一項核算、折舊，現(xiàn)在只需單擊一下按鈕，計算機(jī)便會自動完成企業(yè)所有資產(chǎn)的折舊，而且準(zhǔn)確無誤。項目目的掌握.NET平臺C/S結(jié)構(gòu)項目進(jìn)階掌握三層架構(gòu)的項目框架思想在項目中的運用通用數(shù)據(jù)訪問類的使用水晶報表圖形報表的使用知識點準(zhǔn)備Winform開發(fā)基礎(chǔ)Winform項目開發(fā)經(jīng)驗在線考試系統(tǒng)項目學(xué)習(xí)三層架構(gòu)的項目架構(gòu)思想MVC設(shè)計模式.NET平臺的三層架構(gòu)設(shè)計Winform皮膚控件使用IrisSkin插件ssk皮膚控件數(shù)據(jù)導(dǎo)出Excel利用Office提供的Excel組件導(dǎo)出數(shù)據(jù)DataGridView數(shù)據(jù)導(dǎo)出到Excel水晶報表水晶報表的基本使用方法柱形圖報表的展示多線程多線程的基本原理與技巧BackgroundWorker組件的使用鞏固的知識點WinForm項目開發(fā)三層系統(tǒng)架構(gòu)設(shè)計水晶報表的使用

需求分析系統(tǒng)架構(gòu)系統(tǒng)功能功能清單功能編號功能名稱備注01資產(chǎn)基本信息管理0101基本設(shè)置0102資產(chǎn)保管人員02員工基本信息0201部門管理0202員工管理03固定資產(chǎn)管理0301資產(chǎn)增長0302資產(chǎn)更新0303資產(chǎn)清理0304資產(chǎn)領(lǐng)用0305資產(chǎn)歸還0306分析統(tǒng)計04數(shù)據(jù)維護(hù)管理0401數(shù)據(jù)備份\恢復(fù)0402系統(tǒng)初始化05系統(tǒng)維護(hù)管理0501本單位信息0502系統(tǒng)操作員管理0503修改操作員信息0504權(quán)限設(shè)置06系統(tǒng)輔助工具0601記事本0602計算器07退出系統(tǒng)0701系統(tǒng)退出0702系統(tǒng)注銷系統(tǒng)用例用例說明用例01：資產(chǎn)基本信息管理用例圖描述： 可以維護(hù)以下的基本信息（增刪改查）：資產(chǎn)名稱資產(chǎn)類別保管地點增長方式清理方式計量單位資產(chǎn)保管人員用例02：員工基本信息用例圖：描述：維護(hù)系統(tǒng)的使用人員的信息：部門、員工。部門與員工為一對多的關(guān)系。用例03：固定資產(chǎn)管理用例圖：描述：系統(tǒng)的核功能，對資產(chǎn)的維護(hù)管理：資產(chǎn)增長：添加資產(chǎn)更新：修改資產(chǎn)清理：刪除資料領(lǐng)用：減少資產(chǎn)可用數(shù)量資產(chǎn)歸還：增加資產(chǎn)可用數(shù)量分析統(tǒng)計：資產(chǎn)折舊統(tǒng)計、各部門資產(chǎn)領(lǐng)用量：柱形圖各類別資產(chǎn)借出量：柱形圖各筆資產(chǎn)的使用率用例04：數(shù)據(jù)維護(hù)管理用例圖：描述：數(shù)據(jù)備份數(shù)據(jù)恢復(fù)系統(tǒng)初始化用例05：系統(tǒng)維護(hù)管理用例圖：描述：可以維護(hù)管理以下信息：本單位信息：修改操作員管理：增加、刪除、修改（僅限于本人）權(quán)限設(shè)置：模塊菜單授權(quán)用例06：系統(tǒng)輔助工具用例圖：描述：可以從系統(tǒng)內(nèi)直接打開Windows操作系統(tǒng)的記事本、計算器操作方便用例07：退出系統(tǒng)用例圖：描述：注銷則重新回到登錄窗體，可以繼續(xù)使用其他賬號登錄退出系統(tǒng)則關(guān)閉整個應(yīng)用程序

數(shù)據(jù)庫設(shè)計邏輯設(shè)計系統(tǒng)的E-R圖如下：數(shù)據(jù)表清單表名功能說明1、AddType資產(chǎn)增長方式2、clearTypoe資產(chǎn)清理類型3、EqName資產(chǎn)名稱4、Type資產(chǎn)類型5、KeepPlace保管地點6、Unit計量單位7、Keeper資產(chǎn)保管人員8、Department部門9、SyUsers用戶表10、Func系統(tǒng)功能表11、Power用戶功能表1、AddType資產(chǎn)增長方式13、Employee員工信息表14、Equipment固定資產(chǎn)表15、Borrow資產(chǎn)領(lǐng)用表16、Clear資產(chǎn)清理表18、Return資產(chǎn)歸還表

數(shù)據(jù)表設(shè)計表AddType表名AddType列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵Typevarchar(50)非空補(bǔ)充說明 表Borrow表名Borrow列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵eqNovarchar(50)非空Countint空departvarchar(50)空borrwervarchar(50)空datevarchar(50)空bookervarchar(50)空補(bǔ)充說明表Clear表名Clear列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵eqNovarchar(50)非空Countint空外鍵GradeclearTypevarchar(50)clearervarchar(50)clearDatevarchar(50)markvarchar(50)補(bǔ)充說明表ClearType表名ClearType列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵Typevarchar(50)非空補(bǔ)充說明表CompanyInfo表名CompanyInfo列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵Namevarchar(50)非空LinkManvarchar(50)非空Addressvarchar(50)非空補(bǔ)充說明表Department表名Department列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵departmentvarchar(50)非空補(bǔ)充說明表Employee表名Employee列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明empidint非空主鍵namevarchar(50)非空sexvarchar(20)非空departIdint非空補(bǔ)充說明表EqName表名EqName列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵Namevarchar(50)非空補(bǔ)充說明表eqReturn表名eqReturn列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵eqNovarchar(50)非空unitvarchar(50)空Countint空datevarchar(50)空keepervarchar(50)空bookervarchar(50)空補(bǔ)充說明表Equipment表名Equipment列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明eqNovarchar(50)非空主鍵typevarchar(50)空Namevarchar(50)空labelint空modelvarchar(50)空plusvarchar(50)空Countint空unitvarchar(50)空pricemoney空makervarchar(50)空birthdayvarchar(50)空AddTypevarchar(50)空keepPlacevarchar(50)空keeperint空UserTimevarchar(50)空bookervarchar(50)空boodDatevarchar(50)空photovarbinary(MAX)空補(bǔ)充說明表Func表名Func列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明Menu_idint非空主鍵Menu_Namevarchar(50)非空parentMenuIdvarchar(20)非空Menu_Descint非空補(bǔ)充說明表Keeper表名Keeper列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵keepervarchar(50)非空補(bǔ)充說明表KeepPlace表名KeepPlace列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵Placevarchar(50)非空補(bǔ)充說明表Power表名Power列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明UserLoginNamevarchar(50)空menu_idint空補(bǔ)充說明表Return表名Return列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵Borrowerint空eqNovarchar(50)非空Countint空datevarchar(50)空bookervarchar(50)空補(bǔ)充說明表SyUsers表名SyUsers列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空主鍵loginnamevarchar(50)非空loginpwdvarchar(50)空namevarchar(50)非空補(bǔ)充說明表Type表名Type列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空Typevarchar(50)非空補(bǔ)充說明表Unit表名Unit列名數(shù)據(jù)類型（精度范圍）空/非空約束條件其它說明idint非空unitvarchar(50)空補(bǔ)充說明數(shù)據(jù)庫相關(guān)數(shù)據(jù)表腳本ifexists(select*fromsysobjectswhereid=OBJECT_ID('[AddType]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[AddType]CREATETABLE[AddType]([id][int]IDENTITY(1,1)NOTNULL,[Type][varchar](50)NOTNULL)ALTERTABLE[AddType]WITHNOCHECKADDCONSTRAINT[PK_AddType]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[AddType]ONINSERT[AddType]([id],[Type])VALUES(3,N'自建')INSERT[AddType]([id],[Type])VALUES(5,N'上級分配')INSERT[AddType]([id],[Type])VALUES(6,N'購買')INSERT[AddType]([id],[Type])VALUES(7,N'抵債')INSERT[AddType]([id],[Type])VALUES(8,N'并購')INSERT[AddType]([id],[Type])VALUES(9,N'接受捐贈')INSERT[AddType]([id],[Type])VALUES(10,N'租用')SETIDENTITY_INSERT[AddType]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Borrow]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Borrow]CREATETABLE[Borrow]([id][int]IDENTITY(1,1)NOTNULL,[eqNo][varchar](50)NOTNULL,[Count][int]NULL,[depart][varchar](50)NULL,[borrwer][varchar](50)NULL,[date][varchar](50)NULL,[booker][varchar](50)NULL)ALTERTABLE[Borrow]WITHNOCHECKADDCONSTRAINT[PK_Borrow]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[Borrow]ONINSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(1,N'080427-1000',1,N'商務(wù)部',N'1001',N'2008-5-1820:07:54',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(2,N'080427-1004',3,N'發(fā)改委',N'1020',N'2007-1-1820:08:12',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(3,N'080427-1003',1,N'商務(wù)部',N'1024',N'2005-1-1820:33:30',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(4,N'080427-1004',1,N'國防部',N'1004',N'2006-1-2320:34:09',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(5,N'080427-1009',1,N'公安部',N'1000',N'2005-5-120:34:51',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(6,N'080427-1009',1,N'公安部',N'1000',N'2005-5-120:34:51',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(7,N'080427-1008',2,N'商務(wù)部',N'1001',N'2006-5-520:48:08',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(8,N'080501-1014',2,N'財政部',N'1027',N'2003-5-1820:49:10',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(9,N'080429-1011',2,N'商務(wù)部',N'1001',N'2003-4-2520:49:42',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(10,N'080503-1018',1,N'國防部',N'1028',N'2008-5-1820:50:13',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(11,N'080506-1019',5,N'國防部',N'1029',N'2006-9-1020:50:45',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(12,N'080506-1019',5,N'國防部',N'1029',N'2006-9-1020:50:45',N'小王')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(13,N'080506-1019',2,N'商務(wù)部',N'1025',N'2006-12-2012:28:45',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(14,N'080429-1011',1,N'財政部',N'1003',N'2006-1-2312:32:06',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(15,N'080521-1039',1,N'教育部',N'1016',N'2006-9-2114:48:34',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(16,N'080521-1040',1,N'外交部',N'1012',N'2007-4-214:53:20',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(17,N'080520-1032',1,N'農(nóng)業(yè)部',N'1026',N'2006-1-1114:53:56',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(18,N'080520-1031',20,N'國土資源部',N'1009',N'2006-4-314:54:31',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(19,N'080521-1033',1,N'發(fā)改委',N'1020',N'2007-11-1114:55:15',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(20,N'080501-1015',2,N'發(fā)改委',N'1007',N'2007-9-1815:00:48',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(21,N'080521-1033',1,N'農(nóng)業(yè)部',N'1026',N'2007-12-317:00:47',N'sa')INSERT[Borrow]([id],[eqNo],[Count],[depart],[borrwer],[date],[booker])VALUES(23,N'080427-1003',1,N'商務(wù)部',N'1001',N'2014/06/2121:33:24',N'sa')SETIDENTITY_INSERT[Borrow]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Clear]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Clear]CREATETABLE[Clear]([id][int]IDENTITY(1,1)NOTNULL,[eqNo][varchar](50)NOTNULL,[Count][int]NULL,[clearType][varchar](50)NULL,[clearer][varchar](50)NULL,[clearDate][varchar](50)NULL,[mark][varchar](200)NULL)ALTERTABLE[Clear]WITHNOCHECKADDCONSTRAINT[PK_Clear]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[Clear]ONINSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate],[mark])VALUES(1,N'080427-1004',1,N'損壞',N'sa',N'2008-5-20',N'損壞嚴(yán)重，無法修復(fù)')INSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate])VALUES(2,N'080427-1004',1,N'丟失',N'sa',N'2008-5-20')INSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate])VALUES(3,N'080506-1019',5,N'變賣',N'sa',N'2008-5-21')INSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate])VALUES(4,N'080427-1006',2,N'丟失',N'sa',N'2008-5-21')INSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate])VALUES(5,N'080428-1010',1,N'變賣',N'sa',N'2008-5-21')INSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate])VALUES(6,N'080501-1017',1,N'丟失',N'sa',N'2008-5-21')INSERT[Clear]([id],[eqNo],[Count],[clearType],[clearer],[clearDate])VALUES(7,N'080501-1013',20,N'丟失',N'sa',N'2008-5-21')SETIDENTITY_INSERT[Clear]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[ClearType]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[ClearType]CREATETABLE[ClearType]([id][int]IDENTITY(1,1)NOTNULL,[Type][varchar](50)NOTNULL)ALTERTABLE[ClearType]WITHNOCHECKADDCONSTRAINT[PK_ClearType]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[ClearType]ONINSERT[ClearType]([id],[Type])VALUES(2,N'變賣')INSERT[ClearType]([id],[Type])VALUES(3,N'報廢')INSERT[ClearType]([id],[Type])VALUES(4,N'丟失')INSERT[ClearType]([id],[Type])VALUES(5,N'損壞')INSERT[ClearType]([id],[Type])VALUES(6,N'自然損耗')SETIDENTITY_INSERT[ClearType]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[CompanyInfo]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[CompanyInfo]CREATETABLE[CompanyInfo]([id][int]IDENTITY(1,1)NOTNULL,[Name][varchar](50)NOTNULL,[LinkMan][varchar](50)NOTNULL,[Adress][varchar](50)NOTNULL)ALTERTABLE[CompanyInfo]WITHNOCHECKADDCONSTRAINT[PK_CompanyInfo]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[CompanyInfo]ONINSERT[CompanyInfo]([id],[Name],[LinkMan],[Adress])VALUES(1,N'國務(wù)院',N'李',N'北京市海淀區(qū)中南海')SETIDENTITY_INSERT[CompanyInfo]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Department]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Department]CREATETABLE[Department]([id][int]IDENTITY(1,1)NOTNULL,[departname][varchar](50)NOTNULL)ALTERTABLE[Department]WITHNOCHECKADDCONSTRAINT[PK_Department]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[Department]ONINSERT[Department]([id],[departname])VALUES(2,N'商務(wù)部')INSERT[Department]([id],[departname])VALUES(4,N'公安部')INSERT[Department]([id],[departname])VALUES(5,N'國土資源部')INSERT[Department]([id],[departname])VALUES(12,N'信息產(chǎn)業(yè)部')INSERT[Department]([id],[departname])VALUES(13,N'發(fā)改委')INSERT[Department]([id],[departname])VALUES(16,N'農(nóng)業(yè)部')INSERT[Department]([id],[departname])VALUES(17,N'教育部')INSERT[Department]([id],[departname])VALUES(18,N'國防部')INSERT[Department]([id],[departname])VALUES(19,N'財政部')INSERT[Department]([id],[departname])VALUES(20,N'外交部')SETIDENTITY_INSERT[Department]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Employee]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Employee]CREATETABLE[Employee]([empid][int]IDENTITY(1,1)NOTNULL,[name][varchar](50)NOTNULL,[sex][varchar](20)NOTNULL,[departId][int]NOTNULL)ALTERTABLE[Employee]WITHNOCHECKADDCONSTRAINT[PK_Employee]PRIMARYKEYNONCLUSTERED([empid])SETIDENTITY_INSERT[Employee]ONINSERT[Employee]([empid],[name],[sex],[departId])VALUES(1000,N'呂布',N'男',4)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1001,N'貂蟬',N'女',2)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1003,N'西施',N'女',19)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1004,N'關(guān)羽',N'男',18)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1005,N'林沖',N'男',12)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1006,N'韋小寶',N'男',17)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1007,N'段譽(yù)',N'男',13)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1008,N'李廣',N'男',17)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1009,N'包拯',N'男',5)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1010,N'岳飛',N'男',18)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1011,N'蔡文姬',N'女',5)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1012,N'王昭君',N'女',20)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1013,N'沈括',N'男',12)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1014,N'徐霞客',N'男',12)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1015,N'武則天',N'女',2)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1016,N'李煜',N'男',17)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1017,N'林則徐',N'男',18)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1018,N'文成公主',N'女',20)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1019,N'展昭',N'男',4)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1020,N'李世民',N'男',13)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1021,N'李鴻章',N'男',20)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1022,N'李白',N'男',17)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1023,N'劉安',N'男',5)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1024,N'劉邦',N'男',2)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1025,N'愛新覺羅玄燁',N'男',2)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1026,N'趙匡胤',N'男',16)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1027,N'蘇軾',N'男',19)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1028,N'李清照',N'女',18)INSERT[Employee]([empid],[name],[sex],[departId])VALUES(1029,N'史可法',N'女',18)SETIDENTITY_INSERT[Employee]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[EqName]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[EqName]CREATETABLE[EqName]([id][int]IDENTITY(1,1)NOTNULL,[Name][varchar](50)NOTNULL)ALTERTABLE[EqName]WITHNOCHECKADDCONSTRAINT[PK_EqName]PRIMARYKEYNONCLUSTERED([id])SETIDENTITY_INSERT[EqName]ONINSERT[EqName]([id],[Name])VALUES(16,N'柜式空調(diào)')INSERT[EqName]([id],[Name])VALUES(17,N'數(shù)控機(jī)床')INSERT[EqName]([id],[Name])VALUES(20,N'廠房')INSERT[EqName]([id],[Name])VALUES(23,N'汽車')INSERT[EqName]([id],[Name])VALUES(25,N'叉車')INSERT[EqName]([id],[Name])VALUES(26,N'生產(chǎn)線')INSERT[EqName]([id],[Name])VALUES(27,N'打印機(jī)')INSERT[EqName]([id],[Name])VALUES(28,N'復(fù)印機(jī)')SETIDENTITY_INSERT[EqName]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[eqReturn]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[eqReturn]CREATETABLE[eqReturn]([id][int]IDENTITY(1,1)NOTNULL,[eqNo][varchar](50)NOTNULL,[unit][varchar](50)NULL,[Count][int]NULL,[date][varchar](50)NULL,[keeper][varchar](50)NULL,[booker][varchar](50)NULL)ALTERTABLE[eqReturn]WITHNOCHECKADDCONSTRAINT[PK_eqReturn]PRIMARYKEYNONCLUSTERED([eqNo])SETIDENTITY_INSERT[eqReturn]ONSETIDENTITY_INSERT[eqReturn]OFFifexists(select*fromsysobjectswhereid=OBJECT_ID('[Equipment]')andOBJECTPROPERTY(id,'IsUserTable')=1)DROPTABLE[Equipment]CREATETABLE[Equipment]([eqNo][varchar](50)NOTNULL,[type][varchar](50)NULL,[Name][varchar](50)NULL,[label][varchar](50)NULL,[model][varchar](50)NULL,[plus][varchar](50)NULL,[Count][int]NULL,[unit][varchar](50)NULL,[price][money]NULL,[maker][varchar](200)NULL,[birthday][varchar](50)NULL,[AddType][varchar](50)NULL,[keepPlace][varchar](50)NULL,[keeper][int]NULL,[UseTime][varchar](20)NULL,[booker][varchar](50)NULL,[boodDate][varchar](50)NULL,[photo][varbinary](MAX)NULL)ALTERTABLE[Equipment]WITHNOCHECKADDCONSTRAINT[PK_Equipment]PRIMARYKEYNONCLUSTERED([eqNo])INSERT[Equipment]([eqNo],[type],[Name],[label],[model],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1000',N'辦公用品',N'筆記本電腦',N'聯(lián)想',N'揚天',2,N'臺',10000.0000,N'中國聯(lián)想公司',N'2008-2-1',N'購買',N'前臺',1003,N'4',N'xiaowang',N'2006-4-11')INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1001',N'通訊設(shè)備',N'電話機(jī)',N'中興',20,N'臺',100.0000,N'中興科技',N'2008-3-1',N'購買',N'后勤倉庫',1003,N'1',N'xiaowang',N'2008-4-27')INSERT[Equipment]([eqNo],[type],[Name],[label],[model],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080427-1002',N'交通工具',N'汽車',N'大眾',N'past2000',1,N'輛',50000.0000,N'上海大眾',N'2007-1-1',N'購買',N'車庫',1007,N'3',N'xiaowang',N'2005-4-23',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1003',N'搬運工具',N'叉車',N'合力',5,N'臺',25000.0000,N'2007-2-15',N'購買',N'成品倉',1003,N'25',N'xiaowang',N'1999-4-27')INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1004',N'家電',N'窗式空調(diào)',N'格里',36,N'臺',1250.0000,N'2007-2-16',N'購買',N'男宿舍',1012,N'10',N'xiaowang',N'2004-4-27')INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1005',N'家電',N'窗式空調(diào)',N'海爾',18,N'臺',1250.0000,N'青島海爾',N'2007-2-16',N'購買',N'男宿舍',1013,N'8',N'xiaowang',N'2001-4-10')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1006',N'桌椅',N'辦公椅',13,N'把',45.0000,N'2008-3-31',N'抵債',N'辦公室',1003,N'10',N'xiaowang',N'2002-4-6')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1007',N'大型機(jī)械',N'數(shù)控機(jī)床',2,N'臺',100000.0000,N'2007-9-27',N'并購',N'辦公室',1012,N'20',N'xiaowang',N'2002-4-6')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080427-1008',N'大型機(jī)械',N'柜式空調(diào)',9,N'臺',2500.0000,N'09292007',N'并購',N'辦公室',1007,N'13',N'xiaowang',N'2004-4-6')INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080427-1009',N'交通工具',N'汽車',N'江淮',1,N'臺',200000.0000,N'合肥江淮',N'2007-9-18',N'上級分配',N'車庫',1003,N'5',N'xiaowang',N'2004-4-6',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080429-1011',N'交通工具',N'汽車',N'江淮',12,N'臺',100000.0000,N'合肥江淮集團(tuán)',N'2008-3-17',N'購買',N'車庫',1012,N'5',N'xiaowang',N'2005-1-1')INSERT[Equipment]([eqNo],[type],[Name],[model],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080501-1012',N'大型機(jī)械',N'數(shù)控機(jī)床',N'a-b7810',10,N'臺',500000.0000,N'沈陽車床制造集團(tuán)',N'2005-5-31',N'購買',N'生產(chǎn)車間',1003,N'21',N'小王',N'2000-5-1',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080501-1013',N'燃料',N'汽油',77,N'臺',100.0000,N'中國石化',N'2002-4-24',N'上級分配',N'后勤倉庫',1013,N'1',N'小王',N'2006-5-10')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080501-1014',N'大型機(jī)械',N'數(shù)控機(jī)床',2,N'臺',40000.0000,N'2007-1-1',N'接受捐贈',N'大料倉',1003,N'5',N'小王',N'2005-5-11')INSERT[Equipment]([eqNo],[type],[Name],[plus],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080501-1015',N'交通工具',N'臺式電腦',N'索尼鼠標(biāo)',25,N'臺',1500.0000,N'2008-5-1',N'租用',N'成品倉',1003,N'3',N'小王',N'2006-8-1')INSERT[Equipment]([eqNo],[type],[Name],[label],[model],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080501-1016',N'交通工具',N'汽車',N'長安',N'長安鈴木',3,N'輛',50000.0000,N'長安汽車',N'2008-5-1',N'租用',N'車庫',1003,N'10',N'小王',N'2008-5-1')INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080501-1017',N'家電',N'窗式空調(diào)',N'小天鵝',9,N'臺',1000.0000,N'2008-2-1',N'上級分配',N'女宿舍',1003,N'7',N'小王',N'2006-4-22',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080503-1018',N'交通工具',N'筆記本電腦',1,N'臺',1000.0000,N'2006-5-3',N'購買',N'前臺',1013,N'5',N'小王',N'2006-5-3')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080506-1019',N'桌椅',N'辦公椅',15,N'把',60.0000,N'2008-5-6',N'抵債',N'后勤倉庫',1003,N'10',N'小王',N'2008-5-6')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080510-1020',N'大型機(jī)械',N'數(shù)控機(jī)床',2,N'臺',135000.0000,N'北京*****公司',N'2007-12-31',N'上級分配',N'生產(chǎn)車間',1007,N'8',N'小王',N'2008-5-10',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080510-1021',N'家電',N'窗式空調(diào)',N'小天鵝',10,N'臺',1300.0000,N'2006-1-30',N'并購',N'辦公室',1003,N'6',N'小王',N'2007-9-21')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080510-1022',N'交通工具',N'汽油',20,N'桶',120.0000,N'2007-4-10',N'自建',N'副料倉',1006,N'1',N'小王',N'2007-11-10')INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate])VALUES(N'080511-1023',N'家電',N'柜式空調(diào)',3,N'臺',2500.0000,N'2006-9-11',N'租用',N'前臺',1003,N'10',N'小王',N'2007-5-30')INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080515-1024',N'交通工具',N'汽車',N'奇瑞',1,N'輛',89000.0000,N'安徽奇瑞',N'2003-4-15',N'上級分配',N'車庫',1006,N'10',N'小王',N'2005-1-1',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080518-1025',N'交通工具',N'汽車',N'安凱',4,N'輛',200000.0000,N'安徽安凱',N'2006-5-1',N'自建',N'工廠大院',1007,N'7',N'小王',N'2007-1-18',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080518-1026',N'交通工具',N'電話機(jī)',N'聯(lián)想',10,N'臺',235.0000,N'2006-5-18',N'租用',N'后勤倉庫',1012,N'6',N'小王',N'2007-12-31',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[model],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080520-1027',N'家電',N'柜式空調(diào)',N'美的',N'ms1994',5,N'臺',2500.0000,N'2008-5-20',N'抵債',N'女宿舍',1012,N'4',N'sa',N'2008-5-20',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080520-1028',N'搬運工具',N'叉車',5,N'臺',2500.0000,N'2004-4-20',N'租用',N'裁床車間',1007,N'10',N'sa',N'2005-5-1',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080520-1029',N'通訊設(shè)備',N'電話機(jī)',40,N'臺',300.0000,N'2007-4-20',N'并購',N'女宿舍',1006,N'10',N'sa',N'2007-5-20',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080520-1030',N'大型機(jī)械',N'生產(chǎn)線',1,N'臺',240000.0000,N'2007-5-16',N'購買',N'生產(chǎn)車間',1003,N'10',N'sa',N'2007-9-25',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080520-1031',N'燃料',N'汽油',500,N'桶',300.0000,N'2006-5-20',N'購買',N'副料倉',1003,N'1',N'sa',N'2007-5-20',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080520-1032',N'交通工具',N'汽車',N'紅旗',1,N'輛',120000.0000,N'2006-1-13',N'抵債',N'車庫',1006,N'10',N'sa',N'2007-4-1',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080521-1033',N'辦公用品',N'復(fù)印機(jī)',3,N'臺',35000.0000,N'2004-5-21',N'并購',N'辦公室',1003,N'6',N'sa',N'2006-1-3',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080521-1034',N'辦公用品',N'打印機(jī)',3,N'臺',2500.0000,N'2007-4-22',N'租用',N'前臺',1007,N'5',N'sa',N'2008-1-3',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080521-1035',N'燃料',N'汽油',3,N'桶',1500.0000,N'2008-4-22',N'抵債',N'車庫',1012,N'4',N'sa',N'2008-5-1',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080521-1036',N'桌椅',N'辦公椅',50,N'把',100.0000,N'2005-6-1',N'購買',N'男宿舍',1003,N'5',N'sa',N'2006-5-1',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[Count],[unit],[price],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080521-1037',N'大型機(jī)械',N'數(shù)控機(jī)床',50,N'臺',150000.0000,N'2004-6-11',N'上級分配',N'裁床車間',1006,N'10',N'sa',N'2007-2-7',System.Byte[])INSERT[Equipment]([eqNo],[type],[Name],[label],[Count],[unit],[price],[maker],[birthday],[AddType],[keepPlace],[keeper],[UseTime],[booker],[boodDate],[photo])VALUES(N'080521-1038',N'大型機(jī)械',N'汽車',N'江淮賓悅',2