ASPNET微信微商三级分销系统源码

CREATE TABLE [dbo].[aspnet_DistributorGrade] ( [GradeId] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR (100) NULL, [Description] NVARCHAR (500) NULL, [CommissionsLimit] MONEY NOT NULL, [FirstCommissionRise] DECIMAL (18, 2) NOT NULL, [SecondCommissionRise] DECIMAL (18, 2) NOT NULL, [ThirdCommissionRise] DECIMAL (18, 2) NOT NULL, [IsDefault] BIT NULL, [Ico] VARCHAR (255) NOT NULL, [AddCommission] DECIMAL (18, 2) NOT NULL, CONSTRAINT [PK_aspnet_DistributorGrade] PRIMARY KEY CLUSTERED ([GradeId] ASC) ON [PRIMARY] ) ON [PRIMARY]; GO CREATE TABLE [dbo].[aspnet_Distributors] ( [UserId] INT NOT NULL, [StoreName] VARCHAR (255) NOT NULL, [Logo] VARCHAR (255) NULL, [BackImage] VARCHAR (500) NOT NULL, [RequestAccount] VARCHAR (500) NULL, [AccountTime] DATETIME NULL, [GradeId] INT NOT NULL, [ReferralUserId] INT NOT NULL, [ReferralPath] VARCHAR (50) NULL, [OrdersTotal] MONEY NOT NULL, [ReferralOrders] INT NOT NULL, [ReferralBlance] MONEY NOT NULL, [ReferralRequestBalance] MONEY NOT NULL, [CreateTime] DATETIME NOT NULL, [ReferralStatus] INT NOT NULL, [StoreDescription] NTEXT NOT NULL, [DistributorGradeId] INT NULL, [StoreCard] VARCHAR (255) NULL, [CardCreatTime] DATETIME NULL, CONSTRAINT [PK_aspnet_Distributors] PRIMARY KEY CLUSTERED ([UserId] ASC) ON [PRIMARY] ) ON [PRIMARY]; GO CREATE TABLE [dbo].[aspnet_Managers] ( [UserId] INT IDENTITY (1, 1) NOT NULL, [RoleId] INT NOT NULL, [UserName] NVARCHAR (256) NOT NULL, [Password] NVARCHAR (256) NOT NULL, [Email] NVARCHAR (256) NOT NULL, [CreateDate] DATETIME NOT NULL, CONSTRAINT [PK_aspnet_Managers] PRIMARY KEY CLUSTERED ([UserId] ASC) ON [PRIMARY] ) ON [PRIMARY]; GO CREATE TABLE [dbo].[aspnet_MemberGrades] ( [GradeId] INT IDENTITY (1, 1) NOT NULL, [Name] NVARCHAR (100) NOT NULL, [Description] NVARCHAR (500) NULL, [Points] INT NOT NULL, [IsDefault] BIT NOT NULL, [Discount] INT NOT NULL, [TranVol] DECIMAL (18, 2) NULL, [TranTimes] INT NULL, CONSTRAINT [PK_aspnet_MemberGrades] PRIMARY KEY CLUSTERED ([GradeId] ASC) ON [PRIMARY] ) ON [PRIMARY]; GO CREATE TABLE [dbo].[aspnet_Members] ( [UserId] INT IDENTITY (1, 1) NOT NULL, [GradeId] INT NOT NULL, [ReferralUserId] INT NULL, [UserName] NVARCHAR (256) NOT NULL, [CreateDate] DATETIME NOT NULL, [OrderNumber] INT NOT NULL, [Expenditure] MONEY NOT NULL, [Points] INT NOT NULL, [TopRegionId] INT NULL, [RegionId] INT NULL, [RealName] NVARCHAR (50) NULL, [Email] NVARCHAR (256) NULL, [CellPhone] NVARCHAR (50) NULL, [QQ] NVARCHAR (20) NULL, [Address] NVARCHAR (300) NULL, [VipCardNumber] NVARCHAR (150) NULL, [VipCardDate] DATETIME NULL, [OpenId] NVARCHAR (128) NULL, [SessionId] NVARCHAR (128) NULL, [SessionEndTime] DATETIME NULL, [Password] NVARCHAR (256) NULL, [MicroSignal] NVARCHAR (50) NULL, [UserHead] NVARCHAR (500) NULL, [UserBindName] NVARCHAR (50) NULL, [S�