【正文】 ARY]GOSET ANSI_PADDING OFFGO客戶建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_kehu]( [id] [int] IDENTITY(1,1) NOT NULL, [mingcheng] [varchar](50) NULL, [dizhi] [varchar](50) NULL, [lianxiren] [varchar](50) NULL, [dianhua] [varchar](50) NULL, [youbian] [varchar](50) NULL, [chuanzhen] [varchar](50) NULL, [youxiang] [varchar](50) NULL, [kahuhang] [varchar](50) NULL, [zhanghao] [varchar](50) NULL, [type] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_kehugongying] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO下單建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_order]( [id] [int] IDENTITY(1,1) NOT NULL, [bianhao] [varchar](50) NOT NULL, [riqi] [varchar](50) NULL, [jine] [int] NULL, [kehu_name] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_order] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO入庫建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_ruku]( [id] [int] IDENTITY(1,1) NOT NULL, [goodsId] [int] NULL, [gongyingshangId] [int] NULL, [shijian] [varchar](50) NULL, [shuliang] [int] NULL, [zongjiage] [int] NULL, [jingshouren] [varchar](50) NULL, [beizhu] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_churuku] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO收付款建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_shoufukuan]( [id] [int] IDENTITY(1,1) NOT NULL, [jine] [int] NULL, [shijian] [varchar](50) NULL, [danjuhao] [varchar](50) NULL, [kuanlaiyuan] [varchar](50) NULL, [beizhu] [varchar](50) NULL, [type] [int] NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_shoufukuan] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO配送建表USE [db_cangchu]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_wuliu]( [id] [int] IDENTITY(1,1) NOT NULL, [chufadi] [varchar](50) NULL, [mudidi] [varchar](50) NULL, [facheshijian] [varchar](50) NULL, [fanhushijian] [varchar](50) NULL, [chepaihao] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_t_wuliu] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO1員工建表USE [db_cangchu]GO/****** Object: Table [dbo].[t_yuangong] Script Date: 05/06/2015 20:59:36 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_yuangong]( [id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [sex] [varchar](50) NULL, [age] [varchar](50) NULL, [tel] [varchar](50) NULL, [address] [varchar](50) NULL, [zhiwei] [varchar](50) NULL, [quanxian] [int] NULL, [loginName] [varchar](50) NULL, [loginPw] [varchar](50) NULL, [del] [varchar](50) NULL, CONSTRAINT [PK_yuangong] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO存儲過程USE [db_cangchu]GO/****** Object: StoredProcedure [dbo].[dt_addtosourcecontrol] Script Date: 05/07/2015 21:47:30 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[dt_addtosourcecontrol] vchSourceSafeINI varchar(255) = 39。作為一名當代大學生，應該積極主動的學習和吸收來自不同方面的先進科學知識，增強自身的實踐能力。雖然本次的畢業(yè)設計任務有點繁重，但是也正是這樣一項繁重的任務讓我體會到了將所學知識應用到實踐中的成就感，我相信：這份畢業(yè)設計就是我為我的四年大學生活交上的一份完美的答卷。因此，在今后的日子里我會注重培養(yǎng)自己的動手能力，將所學的知識應用到實踐當中去，為培養(yǎng)我的母校爭光，讓自己更加優(yōu)秀。他們教會我的不止是課堂上的知識，更珍貴的是為人處世的那些道理。通過他對于我在整體結(jié)構(gòu)設計和功能上的指導和建議，以及對于編程和數(shù)據(jù)庫的理解方面的悉心教導，對我能夠順利完成這次的畢業(yè)設計起到了關(guān)鍵性的作用。雖然做了很充足的準備，但是有時候也會出現(xiàn)一些之前完全沒有考慮到會出現(xiàn)的錯誤，這就需要我們正確對待這些錯誤并且積極去克服。當然，沒有什么是絕對完美的，可能一些現(xiàn)在沒發(fā)現(xiàn)的問題以后會出現(xiàn)，所以應該做好問題出現(xiàn)時快速檢測并解決的準備。 :字段名類型長度是否為空是否為主鍵描述userIdInt10否是管理員IDUsernameVarchar50是否管理員姓名UserpwVarchar50否否管理員登錄密碼 管理員信息表字段名類型長度是否為空是否為主鍵描述BaosunidInt10否否破損單編號BaosunshuliangInt6否否破損數(shù)量BaosunshijianDate50是否破損時間GoodsidInt50否否貨物編號 破損表字段名類型長度是否為空是否為主鍵描述ChukuidInt10否是出庫單編號ChukushijianDate50是否出庫日期GoodsidInt50否否出庫貨物編號ChukushuliangInt6否否出庫貨物數(shù)量ChukuzongjiaInt10是否出庫貨物總價個ChukujingshourenVarchar50是否出庫經(jīng)手人ChukubeizhuVarchar50是否備注 出庫表字段名類型長度是否為空是否為主鍵描述GoodsidInt6否是貨物編號GoodsnameVarchar50否否貨物名稱GoodschandiVarchar50是否貨物產(chǎn)地GoodsdanweiVarchar50是否貨物單位GoodsguigeVarchar50是否貨物規(guī)格Goodsbeizhuvarchar50是否貨物備注 貨物信息表字段名類型長度是否為空是否為主鍵描述yuanggongidInt6否是員工編號yuanggongnameVarchar50否否員工姓名YuefenDate否否月份JibengongziInt50是否基本工資JiabanfeiInt50是否加班費JiangjinInt50是否獎金Shifagongzi