[Asp.net]Calendar+JqueryUi实现日程管理（右键菜单，添加，编辑，删除，源码）

 

 1 USE [Wolfy.Schedule]

 2 GO

 3 

 4 /****** Object:  Table [dbo].[TB_Schedule]    Script Date: 2014/7/5 16:30:00 ******/

 5 SET ANSI_NULLS ON

 6 GO

 7 

 8 SET QUOTED_IDENTIFIER ON

 9 GO

10 

11 SET ANSI_PADDING ON

12 GO

13 

14 CREATE TABLE [dbo].[TB_Schedule](

15     [scheduleId] [int] IDENTITY(1,1) NOT NULL,

16     [scheduleDescription] [nvarchar](320) NULL,

17     [scheduleCreateDate] [datetime] NULL,

18     [scheduleColor] [varchar](32) NULL,

19     [scheduleTitle] [nvarchar](160) NULL,

20     [userId] [int] NOT NULL,

21     [schedulePlanDate] [datetime] NULL,

22  CONSTRAINT [PK_TB_Schedule] PRIMARY KEY CLUSTERED 

23 (

24     [scheduleId] ASC

25 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

26 ) ON [PRIMARY]

27 

28 GO

29 

30 SET ANSI_PADDING OFF

31 GO

 

 

 1 USE [Wolfy.Schedule]

 2 GO

 3 

 4 /****** Object:  Table [dbo].[TB_UserInfo]    Script Date: 2014/7/5 16:30:22 ******/

 5 SET ANSI_NULLS ON

 6 GO

 7 

 8 SET QUOTED_IDENTIFIER ON

 9 GO

10 

11 SET ANSI_PADDING ON

12 GO

13 

14 CREATE TABLE [dbo].[TB_UserInfo](

15     [userId] [int] IDENTITY(1,1) NOT NULL,

16     [userName] [nvarchar](20) NULL,

17     [userGender] [bit] NULL,

18     [userLoginName] [varchar](32) NULL,

19     [userPwd] [varchar](32) NULL,

20     [userCreateDate] [datetime] NULL,

21     [userIsDelete] [bit] NULL,

22     [userBirthday] [datetime] NULL,

23     [userLoginCount] [int] NULL,

24     [userAge] [int] NULL,

25  CONSTRAINT [PK_TB_UserInfo] PRIMARY KEY CLUSTERED 

26 (

27     [userId] ASC

28 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

29 ) ON [PRIMARY]

30 

31 GO

32 

33 SET ANSI_PADDING OFF

34 GO