/* * 注意:ver必须是全个List的唯一,使用最后一项加1来放到新项 * 更新版本号只需留最后一个版本号即可 */ public static List<SqlUpdateModel> GetUpdateList() { List<SqlUpdateModel> list = new List<SqlUpdateModel>(); string sql; SqlUpdateModel sqlModel; sql = "select 1"; sqlModel = new SqlUpdateModel(); sqlModel.SetSQL(2, sql); list.Add(sqlModel); return list; }
/* * 注意:ver必须是全个List的唯一,使用最后一项加1来放到新项 * 更新版本号只需留最后一个版本号即可 */ public static List<SqlUpdateModel> GetUpdateList() { List<SqlUpdateModel> list = new List<SqlUpdateModel>(); string sql; SqlUpdateModel sqlModel; sql = "select 1"; sqlModel = new SqlUpdateModel(); sqlModel.SetSQL(2, sql); list.Add(sqlModel); sql = "CREATE TABLE TeacherToClass([SchoolNo] [nvarchar](30) NOT NULL,[Guid] [nvarchar](100) NOT NULL,[Class] [nvarchar](max) NOT NULL) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(3, "TeacherToClass", sql); list.Add(sqlModel); sql = @"CREATE VIEW WXTemplateSettingV AS SELECT dbo.WXTemplateSetting.TemplateType, dbo.WXTemplateSetting.WxOriginalID, dbo.WXTemplateSetting.TemplateId, dbo.WXTemplateSetting.Url, dbo.WXTemplateSetting.TopColor, dbo.WXTemplateSetting.TemplateObj, dbo.WxPublicPlatform.UrlString, dbo.WxPublicPlatform.Token, dbo.WxPublicPlatform.AppId, dbo.WxPublicPlatform.AppSecret, dbo.WXTemplateSetting.Evenid FROM dbo.WXTemplateSetting INNER JOIN dbo.WxPublicPlatform ON dbo.WXTemplateSetting.WxOriginalID = dbo.WxPublicPlatform.OriginalID"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(4, "WXTemplateSettingV", sql); list.Add(sqlModel); sql = "CREATE TABLE SendTemplateMessage([PaperNo] [nvarchar](50) NOT NULL,AppId nvarchar(50) NOT NULL,AppSecret nvarchar(100) NOT NULL,OpenId nvarchar(70) NOT NULL,TemplateId nvarchar(70) NOT NULL,TopColor nvarchar(30) NOT NULL,Url nvarchar(50) NOT NULL,Data nvarchar(MAX) NOT NULL,HappendDate datetime NOT NULL,IsSend bit NOT NULL,SendDate datetime NOT NULL) ON [PRIMARY]TEXTIMAGE_ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(5, "SendTemplateMessage", sql); list.Add(sqlModel); sql = "ALTER TABLE SchoolData ADD SendTimeUp nvarchar(30) NOT NULL DEFAULT ('0:00:00'), SendTimeDown nvarchar(30) NOT NULL DEFAULT ('23:59:00')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(6, "SchoolData", "SendTimeUp", sql); list.Add(sqlModel); sql = "CREATE TABLE DbUpdate ( TableName nvarchar(50) NOT NULL, IsUpdate bit NOT NULL ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(7, "DbUpdate", sql); list.Add(sqlModel); sql = "ALTER TABLE DbUpdate ADD CONSTRAINT PK_DbUpdate PRIMARY KEY CLUSTERED (TableName) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetSQL(8, sql); list.Add(sqlModel); sql = "ALTER TABLE SendTemplateMessage ADD SchoolNo nvarchar(50) NOT NULL"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(9, "SendTemplateMessage", "SchoolNo", sql); list.Add(sqlModel); sql = @"CREATE VIEW StudentParentV AS SELECT dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.ParentBindInfo.OpenId FROM dbo.SJ_DepartStaff INNER JOIN dbo.ParentBindInfo ON dbo.SJ_DepartStaff.DS_Tele = dbo.ParentBindInfo.Phone"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(10, "StudentParentV", sql); list.Add(sqlModel); sql = @"CREATE VIEW TeacherToClassV AS SELECT ISNULL(dbo.TeacherToClass.Class, N'') AS Class, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo FROM dbo.TeacherToClass RIGHT OUTER JOIN dbo.SJ_DepartStaff ON dbo.TeacherToClass.Guid = dbo.SJ_DepartStaff.DS_UID AND dbo.TeacherToClass.SchoolNo = dbo.SJ_DepartStaff.SchoolNo WHERE (dbo.SJ_DepartStaff.DS_Post <> '学生')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(11, "TeacherToClassV", sql); list.Add(sqlModel); sql = "ALTER TABLE SendTemplateMessage ADD DeadTime datetime NOT NULL DEFAULT getdate()"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(12, "SendTemplateMessage", "DeadTime", sql); list.Add(sqlModel); sql = "ALTER TABLE TeacherBindInfo ADD [SchoolNo] [nvarchar](50) NOT NULL"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(13, "TeacherBindInfo", "SchoolNo", sql); list.Add(sqlModel); sql = "ALTER TABLE TeacherToClass ADD IdentityName nvarchar(100) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(14, "TeacherToClass", "IdentityName", sql); list.Add(sqlModel); sql = @"ALTER VIEW TeacherToClassV AS SELECT ISNULL(dbo.TeacherToClass.Class, N'') AS Class, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.TeacherToClass.IdentityName FROM dbo.TeacherToClass RIGHT OUTER JOIN dbo.SJ_DepartStaff ON dbo.TeacherToClass.Guid = dbo.SJ_DepartStaff.DS_UID AND dbo.TeacherToClass.SchoolNo = dbo.SJ_DepartStaff.SchoolNo WHERE (dbo.SJ_DepartStaff.DS_Post <> '学生')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(15, "TeacherToClassV", sql); list.Add(sqlModel); sql = "ALTER TABLE ParentBindInfo ADD StuentUId nvarchar(100) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(16, "ParentBindInfo", "StuentUId", sql); list.Add(sqlModel); sql = @"ALTER VIEW StudentParentV AS SELECT dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.ParentBindInfo.OpenId FROM dbo.SJ_DepartStaff INNER JOIN dbo.ParentBindInfo ON dbo.SJ_DepartStaff.DS_UID = dbo.ParentBindInfo.StuentUId"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(17, "StudentParentV", sql); list.Add(sqlModel); sql = "ALTER TABLE ParentBindInfo DROP CONSTRAINT PK_ParentBindInfo"; sqlModel = new SqlUpdateModel(); sqlModel.SetSQL(18, sql); list.Add(sqlModel); sql = @"CREATE VIEW TeacherBindInfoV AS SELECT dbo.TeacherBindInfo.OpenId, dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo FROM dbo.TeacherBindInfo INNER JOIN dbo.SJ_DepartStaff ON dbo.TeacherBindInfo.TeacherId = dbo.SJ_DepartStaff.DS_JID AND dbo.TeacherBindInfo.SchoolNo = dbo.SJ_DepartStaff.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(19, "TeacherBindInfoV", sql); list.Add(sqlModel); sql = "ALTER TABLE SchoolData ADD City nvarchar(50) NOT NULL DEFAULT (''), District nvarchar(50) NOT NULL DEFAULT (''), Town nvarchar(50) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(20, "SchoolData", "City", sql); list.Add(sqlModel); sql = @"CREATE VIEW SJ_DepartStaffV AS SELECT dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.SchoolData.SchoolPwd, dbo.SchoolData.SchoolName, dbo.SchoolData.CanUse, dbo.SchoolData.SendTimeUp, dbo.SchoolData.SendTimeDown, dbo.SchoolData.City, dbo.SchoolData.District, dbo.SchoolData.Town FROM dbo.SJ_DepartStaff LEFT OUTER JOIN dbo.SchoolData ON dbo.SJ_DepartStaff.SchoolNo = dbo.SchoolData.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(21, "SJ_DepartStaffV", sql); list.Add(sqlModel); sql = @"CREATE TABLE MainPagePic( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [ImgPath] [nvarchar](100) NOT NULL, [SortNo] [bigint] NOT NULL, CONSTRAINT [PK_MainPagePic] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(22, "MainPagePic", sql); list.Add(sqlModel); sql = @"CREATE TABLE Advs( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [PaperNo] [nvarchar](100) NOT NULL, [SchoolNos] [nvarchar](Max) NOT NULL, [SchoolNames] [nvarchar](Max) NOT NULL, [ImgPath] [nvarchar](100) NOT NULL CONSTRAINT [PK_Advs] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(23, "Advs", sql); list.Add(sqlModel); sql = @"CREATE TABLE BackgroundImage( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [ImgPath] [nvarchar](100) NOT NULL, [SortNo] [bigint] NOT NULL, CONSTRAINT [PK_BackgroundImage] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(24, "BackgroundImage", sql); list.Add(sqlModel); sql = @"CREATE TABLE SchoolNews( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [NewsType] [int] NOT NULL, [Headlines] [nvarchar](100) NOT NULL, [HappenDate] [datetime] NOT NULL, [Photo] [nvarchar](300) NOT NULL, [Music] [nvarchar](100) NOT NULL, [Remarks] [ntext] NOT NULL, CONSTRAINT [PK_SchoolNews] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(25, "SchoolNews", sql); list.Add(sqlModel); sql = @"CREATE TABLE Notice( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [Headlines] [nvarchar](100) NOT NULL, [HappenDate] [datetime] NOT NULL, [Photo] [nvarchar](300) NOT NULL, [Music] [nvarchar](100) NOT NULL, [Remarks] [ntext] NOT NULL, CONSTRAINT [PK_Notice] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(26, "Notice", sql); list.Add(sqlModel); sql = @"CREATE TABLE SchoolActive( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [Headlines] [nvarchar](100) NOT NULL, [HappenDate] [datetime] NOT NULL, [Photo] [nvarchar](300) NOT NULL, [Music] [nvarchar](100) NOT NULL, [Remarks] [ntext] NOT NULL, [See] [bigint] NOT NULL DEFAULT 0, [IsLookShow] [bit] NOT NULL, CONSTRAINT [PK_SchoolActive] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(27, "SchoolActive", sql); list.Add(sqlModel); sql = @"CREATE TABLE MailBox( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [Name] [nvarchar](50) NOT NULL DEFAULT (''), [Phone] [nvarchar](50) NOT NULL DEFAULT (''), [Head] [nvarchar](100) NOT NULL DEFAULT (''), [MailContent] [nvarchar](MAX) NOT NULL DEFAULT (''), [OpenId] [nvarchar](100) NOT NULL, [HappenDate] [datetime] NOT NULL CONSTRAINT [PK_MailBox] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(28, "MailBox", sql); list.Add(sqlModel); sql = @"CREATE VIEW MailBoxV AS SELECT dbo.MailBox.SchoolNo, dbo.MailBox.Name, dbo.MailBox.Phone, dbo.MailBox.Head, dbo.MailBox.MailContent, dbo.MailBox.OpenId, dbo.MailBox.HappenDate, dbo.SchoolData.SchoolName, dbo.SchoolData.City, dbo.SchoolData.District, dbo.SchoolData.Town FROM dbo.MailBox LEFT OUTER JOIN dbo.SchoolData ON dbo.MailBox.SchoolNo = dbo.SchoolData.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(29, "MailBoxV", sql); list.Add(sqlModel); sql = "ALTER TABLE SchoolData ADD UseSchoolAbout bit NOT NULL DEFAULT 0, UseSchoolNotice bit NOT NULL DEFAULT 0, UseSchoolActice bit NOT NULL DEFAULT 0, UseSchoolMainBox bit NOT NULL DEFAULT 0"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(30, "SchoolData", "UseSchoolAbout", sql); list.Add(sqlModel); sql = "ALTER TABLE Advs ADD Link [nvarchar](200) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(31, "Advs", "Link", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','DepartStaffNewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','DepartStaffModifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','AdvsNewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','AdvsModifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews0NewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews0MofifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews1NewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews1MofifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews2NewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews2MofifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews3NewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolNews3MofifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','NoticeNewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','NoticeModifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolActiveNewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','SchoolActiveModifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','MainPagePicSetPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','BackgroundImageSetPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','MailBoxSearch1Power')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(32, "PowerName", "PowerName", "DepartStaffNewPower", sql); list.Add(sqlModel); sql = "ALTER TABLE Users ADD BindSchoolNo [nvarchar](200) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(33, "Users", "BindSchoolNo", sql); list.Add(sqlModel); sql = @"ALTER VIEW UserV AS SELECT TOP (100) PERCENT Users.Evenid, Users.UserID, Users.UserName, Users.UserPassword, Users.DepartmentNo, Users.Duty, Users.MovePhone, Users.MsgBalance, Users.MACRestrict, Users.MAC1, Users.MAC2, Users.MAC3, Users.MAC4, Users.MAC5, Users.Email, Users.SMTPServer, Users.EmailID, Users.EmailPassword, Users.CompanyPwd, Users.ClientCheck, Users.Login, Users.RoleId, Users.Deputy, Users.Planner, Users.Buyer, Users.SalesMan, Users.WarehouseMan, ISNULL(Department.DepartmentName, N'') AS DepartmentName, Users.Photo, Users.DisclaimerCustomerNo, Users.DisclaimerCustomerSort, Users.DisclaimerProviderNo, Users.DisclaimerProviderSort, Users.DisclaimerWarehouseNo, Users.Pickinger, Users.LoginICCard, Users.DisclaimerProductNo, Users.DisclaimerProductSort, Users.TurnRoom, Users.BindSchoolNo FROM Users LEFT OUTER JOIN Department ON Users.DepartmentNo = Department.DepartmentNo ORDER BY Users.UserID"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(34, "UserV", sql); list.Add(sqlModel); sql = @"CREATE TABLE OneCardApplication( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [School] [nvarchar](100) NOT NULL, [Name] [nvarchar](50) NOT NULL DEFAULT (''), [Banji] [nvarchar](50) NOT NULL DEFAULT (''), [Phone] [nvarchar](50) NOT NULL DEFAULT (''), [StudentImg] [nvarchar](100) NOT NULL DEFAULT (''), [Remark] [nvarchar](200) NOT NULL DEFAULT (''), [OpenId] [nvarchar](100) NOT NULL, [HappenDate] [datetime] NOT NULL CONSTRAINT [PK_OneCardApplication] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(35, "OneCardApplication", sql); list.Add(sqlModel); sql = @"CREATE TABLE ClassActice( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [Banji] [nvarchar](100) NOT NULL, [MakeMan] [nvarchar](100) NOT NULL, [Headlines] [nvarchar](MAX) NOT NULL, [HappenDate] [datetime] NOT NULL, [Photos] [nvarchar](MAX) NOT NULL, CONSTRAINT [PK_ClassActice] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(36, "ClassActice", sql); list.Add(sqlModel); sql = @"CREATE TABLE Music( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [MusicName] [nvarchar](100) NOT NULL, [Path] [nvarchar](100) NOT NULL CONSTRAINT [PK_Music] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(37, "Music", sql); list.Add(sqlModel); sql = @"CREATE TABLE MainPageBackgroundPic( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [ImgPath] [nvarchar](100) NOT NULL, CONSTRAINT [PK_MainPageBackgroundPic] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(38, "MainPageBackgroundPic", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','BackGroupMusicManagerPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','OneCardApplicationSearch1Power') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','MainPageBackgroundPicSetPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','ClassActiceModifyPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','ClassActiceNewPower')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(39, "PowerName", "PowerName", "BackGroupMusicManagerPower", sql); list.Add(sqlModel); sql = @"CREATE TABLE MainPageFeatures( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [FeaturesNum] [int] NOT NULL, [Features] [nvarchar](1000) NOT NULL, CONSTRAINT [PK_MainPageFeatures] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(40, "MainPageFeatures", sql); list.Add(sqlModel); sql = "INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','MainPageFeaturesSetPower')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(41, "PowerName", "PowerName", "MainPageFeaturesSetPower", sql); list.Add(sqlModel); sql = "ALTER TABLE OneCardApplication ADD StudentNo [nvarchar](100) NOT NULL DEFAULT (''),DeliveryAddress [nvarchar](300) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(42, "OneCardApplication", "StudentNo", sql); list.Add(sqlModel); sql = "ALTER TABLE SendTemplateMessage ADD TemplateType [nvarchar](50) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(43, "SendTemplateMessage", "TemplateType", sql); list.Add(sqlModel); sql = "ALTER TABLE SendTemplateMessage ADD DS_JID [nvarchar](50) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(44, "SendTemplateMessage", "DS_JID", sql); list.Add(sqlModel); sql = @"CREATE TABLE StudentStar( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [Headlines] [nvarchar](100) NOT NULL, [HappenDate] [datetime] NOT NULL, [Photo] [nvarchar](300) NOT NULL, [Music] [nvarchar](100) NOT NULL, [Remarks] [ntext] NOT NULL, [See] [bigint] NOT NULL DEFAULT 0, [IsLookShow] [bit] NOT NULL, CONSTRAINT [PK_StudentStar] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(45, "StudentStar", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','StudentStarNewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','StudentStarModifyPower')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(46, "PowerName", "PowerName", "StudentStarNewPower", sql); list.Add(sqlModel); sql = @"CREATE TABLE TeacherStudentMessage( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, SchoolNo nvarchar(100) NOT NULL, FromOpenId nvarchar(50) NOT NULL, ToOpenId nvarchar(50) NOT NULL, FromName nvarchar(200) NOT NULL, ToName nvarchar(200) NOT NULL, Message nvarchar(500) NOT NULL, HappenDate datetime NOT NULL, MessageType int NOT NULL, IsRead bit NOT NULL, CONSTRAINT [PK_TeacherStudentMessage] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(47, "TeacherStudentMessage", sql); list.Add(sqlModel); sql = @"CREATE VIEW TeacherToClassBindV AS SELECT ISNULL(dbo.TeacherToClass.Class, N'') AS Class, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.TeacherToClass.IdentityName, dbo.TeacherBindInfo.OpenId FROM dbo.TeacherBindInfo INNER JOIN dbo.SJ_DepartStaff ON dbo.TeacherBindInfo.TeacherId = dbo.SJ_DepartStaff.DS_JID AND dbo.TeacherBindInfo.SchoolNo = dbo.SJ_DepartStaff.SchoolNo LEFT OUTER JOIN dbo.TeacherToClass ON dbo.SJ_DepartStaff.DS_UID = dbo.TeacherToClass.Guid AND dbo.SJ_DepartStaff.SchoolNo = dbo.TeacherToClass.SchoolNo WHERE (dbo.SJ_DepartStaff.DS_Post <> '学生')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(48, "TeacherToClassBindV", sql); list.Add(sqlModel); sql = "ALTER TABLE ParentBindInfo ADD IdentityName [nvarchar](100) NOT NULL DEFAULT ('爸爸')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(49, "ParentBindInfo", "IdentityName", sql); list.Add(sqlModel); sql = @"ALTER VIEW StudentParentV AS SELECT dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.ParentBindInfo.OpenId, dbo.ParentBindInfo.IdentityName FROM dbo.SJ_DepartStaff INNER JOIN dbo.ParentBindInfo ON dbo.SJ_DepartStaff.DS_UID = dbo.ParentBindInfo.StuentUId"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(50, "StudentParentV", sql); list.Add(sqlModel); sql = @"CREATE TABLE StudentPoint( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, [SchoolNo] [nvarchar](100) NOT NULL, [BanjiName] [nvarchar](100) NOT NULL, [XinMing] [nvarchar](100) NOT NULL, [BianHao] [nvarchar](100) NOT NULL, [ExamType] [nvarchar](100) NOT NULL, [ExamName] [nvarchar](100) NOT NULL, [ExamTime] [datetime] NOT NULL, [HappenDate] [datetime] NOT NULL, [YuWen] [float] NOT NULL default -1, [ShuXue] [float] NOT NULL default -1, [YingYu] [float] NOT NULL default -1, [ZhengZhi] [float] NOT NULL default -1, [WuLi] [float] NOT NULL default -1, [HuaXue] [float] NOT NULL default -1, [DiLi] [float] NOT NULL default -1, [LiShi] [float] NOT NULL default -1, [ShengWu] [float] NOT NULL default -1, [MeiShu] [float] NOT NULL default -1, [YinYue] [float] NOT NULL default -1, [TiYu] [float] NOT NULL default -1, [DeYuKaoKe] [float] NOT NULL default -1, [NaoDongJiShu] [float] NOT NULL default -1, [JiSuanJi] [float] NOT NULL default -1, [WuLiShiYan] [float] NOT NULL default -1, [HuaXueShiYan] [float] NOT NULL default -1, [ShengWuShiYan] [float] NOT NULL default -1, [TongYongJiShu] [float] NOT NULL default -1, [ZhongHeShiJian] [float] NOT NULL default -1, [XinXiJiShu] [float] NOT NULL default -1, [DiErWaiYu] [float] NOT NULL default -1, [BanJiPaiMing] [float] NOT NULL default -1, [NianJiPaiMing] [float] NOT NULL default -1, CONSTRAINT [PK_StudentPoint] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(51, "StudentPoint", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','StudentPointNewPower') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','StudentPointSearch1Power')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(52, "PowerName", "PowerName", "StudentPointNewPower", sql); list.Add(sqlModel); sql = "ALTER TABLE ClassActice ADD MakeManNo [nvarchar](100) NOT NULL DEFAULT ('')"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(53, "ClassActice", "MakeManNo", sql); list.Add(sqlModel); sql = "ALTER TABLE ClassActice ADD MakeManType int NOT NULL DEFAULT 0"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(54, "ClassActice", "MakeManType", sql); list.Add(sqlModel); sql = @"ALTER VIEW UserV AS SELECT TOP (100) PERCENT dbo.Users.Evenid, dbo.Users.UserID, dbo.Users.UserName, dbo.Users.UserPassword, dbo.Users.DepartmentNo, dbo.Users.Duty, dbo.Users.MovePhone, dbo.Users.MsgBalance, dbo.Users.MACRestrict, dbo.Users.MAC1, dbo.Users.MAC2, dbo.Users.MAC3, dbo.Users.MAC4, dbo.Users.MAC5, dbo.Users.Email, dbo.Users.SMTPServer, dbo.Users.EmailID, dbo.Users.EmailPassword, dbo.Users.CompanyPwd, dbo.Users.ClientCheck, dbo.Users.Login, dbo.Users.RoleId, dbo.Users.Deputy, dbo.Users.Planner, dbo.Users.Buyer, dbo.Users.SalesMan, dbo.Users.WarehouseMan, ISNULL(dbo.Department.DepartmentName, N'') AS DepartmentName, dbo.Users.Photo, dbo.Users.DisclaimerCustomerNo, dbo.Users.DisclaimerCustomerSort, dbo.Users.DisclaimerProviderNo, dbo.Users.DisclaimerProviderSort, dbo.Users.DisclaimerWarehouseNo, dbo.Users.Pickinger, dbo.Users.LoginICCard, dbo.Users.DisclaimerProductNo, dbo.Users.DisclaimerProductSort, dbo.Users.TurnRoom, dbo.Users.BindSchoolNo, dbo.SchoolData.SchoolName FROM dbo.Users LEFT OUTER JOIN dbo.SchoolData ON dbo.Users.BindSchoolNo = dbo.SchoolData.SchoolNo LEFT OUTER JOIN dbo.Department ON dbo.Users.DepartmentNo = dbo.Department.DepartmentNo ORDER BY dbo.Users.UserID"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(55, "UserV", sql); list.Add(sqlModel); sql = @"CREATE TABLE TeacherSendMessage( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, SchoolNo nvarchar(100) NOT NULL, SchoolName nvarchar(100) NOT NULL, Message nvarchar(MAX) NOT NULL, MessageHead nvarchar(500) NOT NULL, MessageFoot nvarchar(500) NOT NULL, FromMan nvarchar(100) NOT NULL, FromName nvarchar(100) NOT NULL, FromIdentityName nvarchar(100) NOT NULL, ToUid nvarchar(200) NOT NULL, ToOpenid nvarchar(100) NOT NULL, Url nvarchar(500) NOT NULL, MessageType int NOT NULL, HappenDate datetime NOT NULL, ErrMessage nvarchar(1000) NOT NULL, IsSend bit NOT NULL, IsErr bit NOT NULL, CONSTRAINT [PK_TeacherSendMessage] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(56, "TeacherSendMessage", sql); list.Add(sqlModel); sql = @"CREATE VIEW TeacherSendMessageV AS SELECT dbo.TeacherSendMessage.SchoolNo, dbo.TeacherSendMessage.SchoolName, dbo.TeacherSendMessage.Message, dbo.TeacherSendMessage.MessageHead, dbo.TeacherSendMessage.MessageFoot, dbo.TeacherSendMessage.FromMan, dbo.TeacherSendMessage.FromName, dbo.TeacherSendMessage.FromIdentityName, dbo.TeacherSendMessage.ToUid, dbo.TeacherSendMessage.ToOpenid, dbo.TeacherSendMessage.Url, dbo.TeacherSendMessage.MessageType, dbo.TeacherSendMessage.HappenDate, dbo.TeacherSendMessage.ErrMessage, dbo.TeacherSendMessage.IsSend, dbo.TeacherSendMessage.IsErr, dbo.SJ_DepartStaff.DS_Name FROM dbo.TeacherSendMessage LEFT OUTER JOIN dbo.SJ_DepartStaff ON dbo.TeacherSendMessage.ToUid = dbo.SJ_DepartStaff.DS_UID"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(57, "TeacherSendMessageV", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Sale','TeacherSendMessageSearch1Power')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(58, "PowerName", "PowerName", "TeacherSendMessageSearch1Power", sql); list.Add(sqlModel); sql = @"CREATE TABLE AttendanceRecord( [f_RecID] [bigint] NOT NULL, f_ReadDate datetime NOT NULL, f_ControllerSN nvarchar(100), f_DoorNames nvarchar(100), f_ReaderName nvarchar(100), DS_JID nvarchar(100), DS_Name nvarchar(100), DS_Sex nvarchar(30), DS_DocumentNo nvarchar(200), DS_Tele nvarchar(100), DS_Post nvarchar(100), D_Name nvarchar(100), ECI_CardID nvarchar(100), ECI_CardfaceID nvarchar(100), SchoolNo nvarchar(100) NOT NULL, ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(59, "AttendanceRecord", sql); list.Add(sqlModel); sql = @"CREATE TABLE PayRecord( [CA_ND] [bigint] NOT NULL, ECI_CardID nvarchar(100), ECI_CardfaceID nvarchar(100), Oper_Login nvarchar(100), DS_Name nvarchar(100), D_Name nvarchar(100), CA_OperateType nvarchar(100), CA_OccDate datetime NOT NULL, CA_Amount float, CA_AccountType nvarchar(100), CA_AddType nvarchar(100), CA_Balance float, SchoolNo nvarchar(100) NOT NULL, ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(60, "PayRecord", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','AttendanceRecordSearch1Power') INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','PayRecordSearch1Power')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(61, "PowerName", "PowerName", "AttendanceRecordSearch1Power", sql); list.Add(sqlModel); sql = @"CREATE VIEW AttendanceRecordV AS SELECT dbo.AttendanceRecord.f_RecID, dbo.AttendanceRecord.f_ReadDate, dbo.AttendanceRecord.f_ControllerSN, dbo.AttendanceRecord.f_DoorNames, dbo.AttendanceRecord.f_ReaderName, dbo.AttendanceRecord.DS_JID, dbo.AttendanceRecord.DS_Name, dbo.AttendanceRecord.DS_Sex, dbo.AttendanceRecord.DS_DocumentNo, dbo.AttendanceRecord.DS_Tele, dbo.AttendanceRecord.DS_Post, dbo.AttendanceRecord.D_Name, dbo.AttendanceRecord.ECI_CardID, dbo.AttendanceRecord.ECI_CardfaceID, dbo.AttendanceRecord.SchoolNo, dbo.SchoolData.SchoolName FROM dbo.AttendanceRecord LEFT OUTER JOIN dbo.SchoolData ON dbo.AttendanceRecord.SchoolNo = dbo.SchoolData.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(62, "AttendanceRecordV", sql); list.Add(sqlModel); sql = @"CREATE VIEW PayRecordV AS SELECT dbo.PayRecord.CA_ND, dbo.PayRecord.ECI_CardID, dbo.PayRecord.ECI_CardfaceID, dbo.PayRecord.Oper_Login, dbo.PayRecord.DS_Name, dbo.PayRecord.D_Name, dbo.PayRecord.CA_OperateType, dbo.PayRecord.CA_OccDate, dbo.PayRecord.CA_Amount, dbo.PayRecord.CA_AccountType, dbo.PayRecord.CA_AddType, dbo.PayRecord.CA_Balance, dbo.PayRecord.SchoolNo, dbo.SchoolData.SchoolName FROM dbo.PayRecord LEFT OUTER JOIN dbo.SchoolData ON dbo.PayRecord.SchoolNo = dbo.SchoolData.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(63, "PayRecordV", sql); list.Add(sqlModel); sql = "ALTER TABLE SJ_DepartStaff ADD IsManager bit NOT NULL DEFAULT 0"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterTableAddColumn(64, "SJ_DepartStaff", "IsManager", sql); list.Add(sqlModel); sql = @"ALTER VIEW SJ_DepartStaffV AS SELECT dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.SchoolData.SchoolPwd, dbo.SchoolData.SchoolName, dbo.SchoolData.CanUse, dbo.SchoolData.SendTimeUp, dbo.SchoolData.SendTimeDown, dbo.SchoolData.City, dbo.SchoolData.District, dbo.SchoolData.Town, dbo.SJ_DepartStaff.IsManager FROM dbo.SJ_DepartStaff LEFT OUTER JOIN dbo.SchoolData ON dbo.SJ_DepartStaff.SchoolNo = dbo.SchoolData.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(65, "SJ_DepartStaffV", sql); list.Add(sqlModel); sql = @"ALTER VIEW TeacherBindInfoV AS SELECT dbo.TeacherBindInfo.OpenId, dbo.SJ_DepartStaff.DS_JID, dbo.SJ_DepartStaff.D_Name, dbo.SJ_DepartStaff.DS_Name, dbo.SJ_DepartStaff.DS_Sex, dbo.SJ_DepartStaff.DS_DocumentNo, dbo.SJ_DepartStaff.DS_Tele, dbo.SJ_DepartStaff.DS_Post, dbo.SJ_DepartStaff.DS_UID, dbo.SJ_DepartStaff.SchoolNo, dbo.SJ_DepartStaff.IsManager FROM dbo.TeacherBindInfo INNER JOIN dbo.SJ_DepartStaff ON dbo.TeacherBindInfo.TeacherId = dbo.SJ_DepartStaff.DS_JID AND dbo.TeacherBindInfo.SchoolNo = dbo.SJ_DepartStaff.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAlterView(66, "TeacherBindInfoV", sql); list.Add(sqlModel); sql = @"CREATE TABLE TeacherDayCheckRecord( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, SchoolNo nvarchar(100) NOT NULL, DS_Name nvarchar(100) NOT NULL, DS_JID nvarchar(100) NOT NULL, D_Name nvarchar(100) NOT NULL, LeaveType int NOT NULL, Memos nvarchar(200) NOT NULL, HappenDate datetime NOT NULL, CONSTRAINT [PK_TeacherDayCheckRecord] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(67, "TeacherDayCheckRecord", sql); list.Add(sqlModel); sql = @"CREATE TABLE TeacherDayCheckSubmitRecord( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, SchoolNo nvarchar(100) NOT NULL, D_Name nvarchar(100) NOT NULL, IsSubmit bit NOT NULL, HappenDate datetime NOT NULL, CONSTRAINT [PK_TeacherDayCheckSubmitRecord] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(68, "TeacherDayCheckSubmitRecord", sql); list.Add(sqlModel); sql = @"CREATE TABLE StudentLeaveRecord( [Evenid] [bigint] IDENTITY(1,1) NOT NULL, SchoolNo nvarchar(100) NOT NULL, Student_Name nvarchar(100) NOT NULL, Student_JID nvarchar(100) NOT NULL, Student_DName nvarchar(100) NOT NULL, Student_Openid nvarchar(100) NOT NULL, Teacher_Name nvarchar(100) NOT NULL, Teacher_JID nvarchar(100) NOT NULL, Teacher_Openid nvarchar(100) NOT NULL, TimeSelect datetime NOT NULL, LeaveType int NOT NULL, TimeChose int NOT NULL, Memos nvarchar(200) NOT NULL, RecordState int NOT NULL, HappenDate datetime NOT NULL, CONSTRAINT [PK_StudentLeaveRecord] PRIMARY KEY CLUSTERED ( [Evenid] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]"; sqlModel = new SqlUpdateModel(); sqlModel.SetCreateTableSql(69, "StudentLeaveRecord", sql); list.Add(sqlModel); sql = @"CREATE VIEW StudentLeaveRecordV AS SELECT dbo.StudentLeaveRecord.Evenid, dbo.StudentLeaveRecord.SchoolNo, dbo.StudentLeaveRecord.Student_Name, dbo.StudentLeaveRecord.Student_JID, dbo.StudentLeaveRecord.Student_DName, dbo.StudentLeaveRecord.Student_Openid, dbo.StudentLeaveRecord.Teacher_Name, dbo.StudentLeaveRecord.Teacher_JID, dbo.StudentLeaveRecord.Teacher_Openid, dbo.StudentLeaveRecord.TimeSelect, dbo.StudentLeaveRecord.LeaveType, dbo.StudentLeaveRecord.TimeChose, dbo.StudentLeaveRecord.Memos, dbo.StudentLeaveRecord.RecordState, dbo.StudentLeaveRecord.HappenDate, dbo.SchoolData.SchoolName FROM dbo.StudentLeaveRecord LEFT OUTER JOIN dbo.SchoolData ON dbo.StudentLeaveRecord.SchoolNo = dbo.SchoolData.SchoolNo"; sqlModel = new SqlUpdateModel(); sqlModel.SetAddView(70, "StudentLeaveRecordV", sql); list.Add(sqlModel); sql = @"INSERT INTO PowerName([Modules] ,[PowerName]) VALUES ('Base','StudentLeaveRecordSearch1Power')"; sqlModel = new SqlUpdateModel(); sqlModel.SetInsertTable(71, "PowerName", "PowerName", "StudentLeaveRecordSearch1Power", sql); list.Add(sqlModel); return list; }