【導(dǎo)讀】理】、和等模塊組成。系統(tǒng)前端開發(fā)工具采用Visual. 設(shè)計(jì)主要包括后臺(tái)數(shù)據(jù)庫的建立和維護(hù)以及前端應(yīng)用程序的開發(fā)兩個(gè)方面。入該系統(tǒng)后，用戶可以對系統(tǒng)中的信息進(jìn)行添加、修改、刪除和查詢等操作。外，如果是管理員登錄，還可以對用戶的權(quán)限、用戶名和密碼進(jìn)行設(shè)置或修改。在信息技術(shù)的催化之下，世界經(jīng)濟(jì)的變革已經(jīng)進(jìn)入了加速狀態(tài)。與供方的關(guān)系變得更加密切和復(fù)雜。強(qiáng)化管理，規(guī)范業(yè)務(wù)流程，提高透明度，加快商品資金。經(jīng)過實(shí)際的考察與研究，設(shè)計(jì)了這一商品進(jìn)銷存報(bào)表系統(tǒng)。信息管理的知識(shí)。當(dāng)今社會(huì)是一個(gè)辦公智能化的社會(huì)，又是一個(gè)信息化的社會(huì)，所以企業(yè)管

　　

【正文】 ods] ([GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[UserID] [int] NULL ,《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[DepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsNum] [int] NULL ,[GoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsTime] [datetime] NULL ,[GoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsPrice] [money] NULL ,[SellPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Popedom] ([PopedomID] [int] IDENTITY (1, 1) NOT NULL ,[SysUserSort] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[SysUserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[EmployeeInfo] [bit] NULL ,[CompanyInfo] [bit] NULL ,[CustomerInfo] [bit] NULL ,[GoodsInInfo] [bit] NULL ,[GoodsOutInfo] [bit] NULL ,[SellGoodsInfo] [bit] NULL ,[ReGoodsInfo] [bit] NULL ,[StockChangeInfo] [bit] NULL ,[StockAlarmInfo] [bit] NULL ,[SysUser] [bit] NULL ,[PopedomInfo] [bit] NULL ,[BakDataInfo] [bit] NULL ,[ReBakDataInfo] [bit] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Post] ([PostID] [int] IDENTITY (1, 1) NOT NULL ,[PostName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PostDescription] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_ReGoods] ([ReGoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StockID] [int] NULL ,《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[UserID] [int] NULL ,[CustomerID] [int] NULL ,[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[DepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsTime] [datetime] NULL ,[ReGoodsNum] [int] NULL ,[ReGoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[ReGoodsResult] [nvarchar] (400) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsSort] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Sell] ([SellID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StockID] [int] NULL ,[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[UserID] [int] NULL ,[GoodsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsNum] [int] NULL ,[GoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsTime] [datetime] NULL ,[GoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsPrice] [money] NULL ,[SellPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Stock] ([StockID] [int] IDENTITY (1, 1) NOT NULL ,[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[DepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[StockNum] [int] NULL ,[AlarmNum] [int] NULL ,[GoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院[GoodsTime] [datetime] NULL ,[GoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsPrice] [money] NULL ,[SellPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_StockTemp] ([StockTempID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StockID] [int] NULL ,[UserID] [int] NULL ,[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[FDepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[LDepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CGoodsTime] [datetime] NULL ,[StockNum] [int] NULL ,[CGoodsNum] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Unit] ([UnitID] [int] IDENTITY (1, 1) NOT NULL ,[UnitName] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_User] ([UserID] [int] IDENTITY (1, 1) NOT NULL ,[Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[SysLoginName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Pwd] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[Sex] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Birthday] [datetime] NULL ,[Department] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Post] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PhoneH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PhoneM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[PopedomID] [int] NULL ) ON [PRIMARY]GO《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程