Net全开源微信系统源码

USE [mxweixin] GO /****** Object: User [yubomcom] Script Date: 02/02/2015 09:24:52 ******/ CREATE USER [yubomcom] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo] GO /****** Object: Table [dbo].[wx_yyyUsersTemp] Script Date: 02/02/2015 09:24:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[wx_yyyUsersTemp]( [id] [int] IDENTITY(1,1) NOT NULL, [actId] [int] NULL, [openid] [varchar](100) NULL, [times] [int] NULL, [createDate] [datetime] NULL, CONSTRAINT [PK_wx_yyyUsersTemp_id] 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] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyUsersTemp', @level2type=N'COLUMN',@level2name=N'id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyUsersTemp', @level2type=N'COLUMN',@level2name=N'actId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户openid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyUsersTemp', @level2type=N'COLUMN',@level2name=N'openid' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyUsersTemp', @level2type=N'COLUMN',@level2name=N'times' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyUsersTemp', @level2type=N'COLUMN',@level2name=N'createDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'摇一摇用户抽奖临时表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyUsersTemp' GO /****** Object: Table [dbo].[wx_yyyAwardUser] Script Date: 02/02/2015 09:24:51 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[wx_yyyAwardUser]( [id] [int] IDENTITY(1,1) NOT NULL, [actId] [int] NULL, [uName] [varchar](50) NULL, [uTel] [varchar](500) NULL, [openid] [varchar](100) NULL, [jxName] [varchar](50) NULL, [jxIndex] [varchar](4000) NULL, [jpName] [varchar](200) NULL, [createDate] [datetime] NULL, [hasLingQu] [bit] NULL, [sn] [varchar](100) NULL, CONSTRAINT [PK_wx_yyyAwardUser_id] 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] GO SET ANSI_PADDING OFF GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyAwardUser', @level2type=N'COLUMN',@level2name=N'id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动主键Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyAwardUser', @level2type=N'COLUMN',@level2name=N'actId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyAwardUser', @level2type=N'COLUMN',@level2name=N'uName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户手机号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyAwardUser', @level2type=N'COLUMN',@level2name=N'uTel' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户openid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wx_yyyAwardUser', @level2type=N'COLUMN',@level2name=N'openid' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N�