VB6 SQLSERVER销售管理系统完整源代码.rar

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[入库单]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[入库单] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[客户]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[客户] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[库存]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[库存] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[用户]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[用户] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[销售记录]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[销售记录] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[音像类型]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[音像类型] GO CREATE TABLE [dbo].[入库单] ( [入库日期] [datetime] NULL , [入库时间] [datetime] NULL , [操作员] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [商品编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [助记码] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [音像商品名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [音像制品类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [数量] [numeric](18, 0) NULL , [进货价格] [money] NULL , [售出价格] [money] NULL , [库存最小报警] [numeric](18, 0) NULL , [库存最大报警] [numeric](18, 0) NULL , [商品简介] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[客户] ( [客户名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [联系方式] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [信用度] [int] NULL , [已付金额] [money] NULL , [欠费金额] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[库存] ( [商品编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [助记码] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [音像商品名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [音像制品类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [数量] [numeric](18, 0) NULL , [进货价格] [money] NULL , [售出价格] [money] NULL , [最小报警库存] [numeric](18, 0) NULL , [最大报警库存] [numeric](18, 0) NULL , [商品简介] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[用户] ( [用户名] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [密码] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [商品销售] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [销售修改] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [销售删除] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [入库管理] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [库存管理] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [客户管理] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [用户管理] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[销售记录] ( [已付款] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL , [日期] [datetime] NOT NULL , [客户名称] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [商品编号] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [助记码] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [数量] [numeric](18, 0) NULL , [单价] [money] NULL , [总价格] [money] NULL , [操作员] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[音像类型] ( [音像类型] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO