旗舰版连锁店会员积分管理系统源码.rar

--Mem drop table Mem CREATE TABLE [Mem]([MemID] [int] IDENTITY(1,1) NOT NULL,[MemCard] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemPassword] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemSex] [bit] NULL,[MemIdentityCard] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemMobile] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemPhoto] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,[MemBirthdayType] [bit] NULL,[MemBirthday] [datetime] NULL,[MemIsPast] [bit] NULL,[MemPastTime] [datetime] NULL,[MemPoint] [int] NULL CONSTRAINT [DF_Mem_MemPoint] DEFAULT ((0)),[MemPointAutomatic] [bit] NULL,[MemMoney] [money] NULL CONSTRAINT [DF_Mem_MemMoney] DEFAULT ((0)),[MemConsumeMoney] [money] NULL,[MemConsumeLastTime] [datetime] NULL,[MemConsumeCount] [int] NULL,[MemEmail] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemAddress] [nvarchar](200) COLLATE Chinese_PRC_CI_AS NULL,[MemState] [int] NULL,[MemRecommendID] [int] NULL,[MemLevelID] [int] NULL,[MemShopID] [int] NULL,[MemCreateTime] [datetime] NULL,[MemRemark] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,[MemUserID] [int] NULL,[MemTelePhone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemQRCode] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL,[MemProvince] [varchar](50) NULL,[MemCity] [varchar](50) NULL,[MemCounty] [varchar](50) NULL,[MemVillage] [varchar](50) NULL,[MemQuestion] [varchar](500) NULL,[MemAnswer] [varchar](500) NULL,[MemWeiXinCard] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemCardNumber] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,[MemAttention] [int] NULL CONSTRAINT [DF_Mem_MemAttention] DEFAULT ((2)) ,[MemWeiXinCards] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,CONSTRAINT [PK_Member] PRIMARY KEY CLUSTERED ([MemID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY] SET IDENTITY_Insert Mem ON INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [MemAttention], [MemWeiXinCards]) VALUES (0, N'0', N'E62A9E6C1892C6BB', N'散客', 1, NULL, NULL, NULL, NULL, CAST(0x0000000000000000 AS DateTime), 0, CAST(0x000592BB00000000 AS DateTime), 0, NULL, 0.0000, NULL, NULL, NULL, NULL, NULL, 0, NULL, -1, 1, CAST(0x0000A1A600000000 AS DateTime), NULL, 1, NULL, N'', N'', N'', N'', N'', N'', N'', NULL, N'', 2, N'') INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [MemAttention], [MemWeiXinCards]) VALUES (1, N'1000', N'0CB41BCC3AB27066', N'王雪梅', 1, N'420321199512235689', N'13554753250', N'', 1, CAST(0x0000A51400000000 AS DateTime), 0, CAST(0x000592BB00000000 AS DateTime), 0, 1, 0.0000, NULL, NULL, NULL, N'123@126.com', N'', 0, 0, 0, 1, CAST(0x0000A51400000000 AS DateTime), N'', 1, N'', N'', N'1', N'2', N'3', N'4', NULL, NULL, NULL, N'201509151000', 2, NULL) INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [MemAttention], [MemWeiXinCards]) VALUES (2, N'1001', N'0CB41BCC3AB27066', N'陈勇', 1, N'', N'13546568941', N'', 1, CAST(0x0000A51400000000 AS DateTime), 0, CAST(0x000592BB00000000 AS DateTime), 0, 1, 0.0000, NULL, NULL, NULL, N'', N'', 0, 0, 0, 1, CAST(0x0000A51400000000 AS DateTime), N'', 1, N'', N'', N'1', N'2', N'3', N'5', NULL, NULL, NULL, N'', 2, NULL) INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [MemAttention], [MemWeiXinCards]) VALUES (3, N'1002', N'0CB41BCC3AB27066', N'蒋宗璐', 1, N'', N'13545698956', N'', 1, CAST(0x0000A51400000000 AS DateTime), 0, CAST(0x000592BB00000000 AS DateTime), 0, 1, 0.0000, NULL, NULL, NULL, N'', N'', 0, 0, 0, 1, CAST(0x0000A51400000000 AS DateTime), N'', 1, N'', N'', N'237', N'330', N'331', N'336', NULL, NULL, NULL, N'', 2, NULL) INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [MemAttention], [MemWeiXinCards]) VALUES (4, N'1003', N'0CB41BCC3AB27066', N'吴文兰', 1, N'', N'13546598956', N'', 1, CAST(0x0000A51400000000 AS DateTime), 0, CAST(0x000592BB00000000 AS DateTime), 0, 1, 0.0000, NULL, NULL, NULL, N'', N'', 0, 0, 0, 1, CAST(0x0000A51400000000 AS DateTime), N'', 1, N'', N'', N'', N'', N'', N'', NULL, NULL, NULL, N'', 2, NULL) INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [MemAttention], [MemWeiXinCards]) VALUES (5, N'1004', N'0CB41BCC3AB27066', N'朱成福', 1, N'', N'13568945623', N'', 1, CAST(0x0000000000000000 AS DateTime), 0, CAST(0x000592BB00000000 AS DateTime), 0, 1, 0.0000, NULL, NULL, NULL, N'', N'', 0, 0, 0, 1, CAST(0x0000A51400000000 AS DateTime), N'', 1, N'', N'', N'1815', N'1922', N'1923', N'1924', NULL, NULL, NULL, N'', 2, NULL) INSERT [dbo].[Mem] ([MemID], [MemCard], [MemPassword], [MemName], [MemSex], [MemIdentityCard], [MemMobile], [MemPhoto], [MemBirthdayType], [MemBirthday], [MemIsPast], [MemPastTime], [MemPoint], [MemPointAutomatic], [MemMoney], [MemConsumeMoney], [MemConsumeLastTime], [MemConsumeCount], [MemEmail], [MemAddress], [MemState], [MemRecommendID], [MemLevelID], [MemShopID], [MemCreateTime], [MemRemark], [MemUserID], [MemTelePhone], [MemQRCode], [MemProvince], [MemCity], [MemCounty], [MemVillage], [MemQuestion], [MemAnswer], [MemWeiXinCard], [MemCardNumber], [Me