public override void InitPluginData(DbContext baseDbContext, IServiceProvider servicep, string webRootPath) { //base.InitPluginData(baseDbContext, servicep); var dbContext = servicep.GetService <WeiXinDbContext>(); if (dbContext.WeiXinConfigs.CountAsync().Result != 0) { return; } if (DataInitTool.workbook == null) { DataInitTool.OpenExcel("InitData.xlsx", webRootPath); } DataInitTool.ProcessSheet("Plugin_WeiXin_Config", colums => { WeiXinConfigEntity entity = new WeiXinConfigEntity(); entity.Id = colums[0]; entity.AppId = colums[1]; entity.EncodingAESKey = colums[2]; entity.Token = colums[3]; entity.AppSecret = colums[4]; entity.TenantId = colums[5]; dbContext.WeiXinConfigs.Add(entity); }); dbContext.SaveChanges(); }
public override void InitPluginData(DbContext baseDbContext, IServiceProvider servicep, string webRootPath) { //base.InitPluginData(baseDbContext, servicep); var dbContext = servicep.GetService <AreaDbContext>(); if (dbContext.Areas.CountAsync().Result != 0) { return; } if (DataInitTool.workbook == null) { DataInitTool.OpenExcel("InitData.xlsx", webRootPath); } DataInitTool.ProcessSheet("Sys_Area", colums => { AreaEntity entity = new AreaEntity(); entity.Id = colums[0]; entity.ParentId = colums[1]; entity.Layers = int.Parse(colums[2]); entity.EnCode = colums[3]; entity.FullName = colums[4]; entity.SimpleSpelling = colums[5]; entity.SortCode = int.Parse(colums[6]); entity.EnabledMark = bool.Parse(colums[8]); entity.CreateTime = DateTime.MinValue; dbContext.Areas.Add(entity); }); dbContext.SaveChanges(); }
public static void InitFreameworkDbData(this IApplicationBuilder app, IServiceProvider applicationServices, string webRootPath, EvolutionDBContext dbContext) { var sqlServerDatabase = dbContext.Database; //try //{ // int r = sqlServerDatabase.ExecuteSqlCommand("select count(*) from Sys_User"); // return; //} //catch(Exception ex) //{ // //这个ex是可预期的。 //} try { sqlServerDatabase.EnsureDeleted(); } catch { } if (sqlServerDatabase.EnsureCreated()) { //sqlServerDatabase.Migrate(); DataInitTool.ProcessFile("Sys_DbBackup.csv", webRootPath, colums => { DbBackupEntity entity = new DbBackupEntity(); entity.Id = colums[0]; entity.BackupType = colums[1]; entity.DbName = colums[2]; entity.FileName = colums[3]; entity.FileSize = colums[4]; entity.FilePath = colums[5]; entity.BackupTime = DateTime.Parse(colums[6]); entity.EnabledMark = bool.Parse(colums[9]); entity.CreateTime = DateTime.MinValue; dbContext.DbBackups.Add(entity); }); DataInitTool.ProcessFile("Sys_FilterIP.csv", webRootPath, colums => { FilterIPEntity entity = new FilterIPEntity(); entity.Id = colums[0]; entity.Type = bool.Parse(colums[1]); entity.StartIP = colums[2]; entity.EndIP = colums[3]; entity.EnabledMark = bool.Parse(colums[6]); entity.Description = colums[7]; entity.CreateTime = DateTime.Parse(colums[8]); dbContext.FilterIPs.Add(entity); }); DataInitTool.ProcessFile("Sys_Items.csv", webRootPath, colums => { ItemsEntity entity = new ItemsEntity(); entity.Id = colums[0]; entity.ParentId = colums[1]; entity.EnCode = colums[2]; entity.FullName = colums[3]; entity.IsTree = GetDefaultBool(colums[4], false); entity.Layers = int.Parse(colums[5]); entity.SortCode = int.Parse(colums[6]); entity.DeleteMark = GetDefaultBool(colums[7], false); entity.EnabledMark = GetDefaultBool(colums[8], true); entity.CreateTime = DateTime.MinValue; dbContext.Items.Add(entity); }); DataInitTool.ProcessFile("Sys_ItemsDetail.csv", webRootPath, colums => { ItemsDetailEntity entity = new ItemsDetailEntity(); entity.Id = colums[0]; entity.ItemId = colums[1]; entity.ParentId = colums[2]; entity.ItemCode = colums[3]; entity.ItemName = colums[4]; entity.IsDefault = GetDefaultBool(colums[6], false); entity.SortCode = int.Parse(colums[8]); entity.DeleteMark = GetDefaultBool(colums[9], false); entity.EnabledMark = GetDefaultBool(colums[10], true); dbContext.ItemsDetails.Add(entity); }); DataInitTool.ProcessFile("Sys_Log.csv", webRootPath, colums => { LogEntity entity = new LogEntity(); entity.Id = colums[0]; entity.Date = DateTime.Parse(colums[1]); entity.Account = colums[2]; entity.NickName = colums[3]; entity.Type = colums[4]; entity.IPAddress = colums[5]; entity.IPAddressName = colums[6]; entity.ModuleName = colums[8]; entity.Result = bool.Parse(colums[9]); entity.Description = colums[10]; entity.CreateTime = DateTime.MinValue; entity.CreatorUserId = colums[12]; dbContext.Logs.Add(entity); }); DataInitTool.ProcessFile("Sys_Menu.csv", webRootPath, colums => { MenuEntity entity = new MenuEntity(); entity.Id = colums[0]; entity.ParentId = colums[1]; entity.Layers = int.Parse(colums[2]); entity.FullName = colums[4]; entity.Icon = colums[5]; entity.UrlAddress = colums[6]; entity.Target = colums[7]; entity.IsMenu = bool.Parse(colums[8]); entity.IsExpand = bool.Parse(colums[9]); entity.IsPublic = bool.Parse(colums[10]); entity.AllowEdit = bool.Parse(colums[11]); entity.AllowDelete = bool.Parse(colums[12]); entity.SortCode = int.Parse(colums[13]); entity.DeleteMark = bool.Parse(colums[14]); entity.EnabledMark = bool.Parse(colums[15]); entity.Description = colums[16]; entity.CreateTime = DateTime.MinValue; entity.LastModifyTime = DateTime.MinValue; entity.LastModifyUserId = colums[20]; dbContext.Menus.Add(entity); }); DataInitTool.ProcessFile("Sys_MenuButton.csv", webRootPath, colums => { MenuButtonEntity entity = new MenuButtonEntity(); entity.Id = colums[0]; entity.MenuId = colums[1]; entity.ParentId = colums[2]; if (!string.IsNullOrEmpty(colums[3])) { entity.Layers = int.Parse(colums[3]); } entity.EnCode = colums[4]; entity.FullName = colums[5]; if (!string.IsNullOrEmpty(colums[7])) { entity.Location = int.Parse(colums[7]); } entity.JsEvent = colums[8]; entity.UrlAddress = colums[9]; if (!string.IsNullOrEmpty(colums[10])) { entity.Split = bool.Parse(colums[10]); } if (!string.IsNullOrEmpty(colums[11])) { entity.IsPublic = bool.Parse(colums[11]); } if (!string.IsNullOrEmpty(colums[12])) { entity.AllowEdit = bool.Parse(colums[12]); } if (!string.IsNullOrEmpty(colums[13])) { entity.AllowDelete = bool.Parse(colums[13]); } if (!string.IsNullOrEmpty(colums[14])) { entity.SortCode = int.Parse(colums[14]); } if (!string.IsNullOrEmpty(colums[15])) { entity.DeleteMark = bool.Parse(colums[15]); } if (!string.IsNullOrEmpty(colums[16])) { entity.EnabledMark = bool.Parse(colums[16]); } entity.CreateTime = DateTime.MinValue; entity.LastModifyTime = DateTime.MinValue; entity.LastModifyUserId = colums[20]; dbContext.ModuleButtons.Add(entity); }); DataInitTool.ProcessFile("Sys_Organize.csv", webRootPath, colums => { OrganizeEntity entity = new OrganizeEntity(); entity.Id = colums[0]; entity.ParentId = colums[1]; entity.Layers = int.Parse(colums[2]); entity.EnCode = colums[3]; entity.FullName = colums[4]; entity.ShortName = colums[5]; entity.CategoryId = colums[6]; entity.ManagerId = colums[7]; entity.Address = colums[14]; entity.SortCode = int.Parse(colums[17]); entity.DeleteMark = bool.Parse(colums[18]); entity.EnabledMark = bool.Parse(colums[19]); entity.CreateTime = DateTime.MinValue; dbContext.Organizes.Add(entity); }); DataInitTool.ProcessFile("Sys_Role.csv", webRootPath, colums => { RoleEntity entity = new RoleEntity(); entity.Id = colums[0]; entity.OrganizeId = colums[1]; entity.Category = int.Parse(colums[2]); entity.EnCode = colums[3]; entity.FullName = colums[4]; entity.Type = colums[5]; entity.AllowEdit = bool.Parse(colums[6]); entity.AllowDelete = bool.Parse(colums[7]); entity.SortCode = int.Parse(colums[8]); entity.DeleteMark = bool.Parse(colums[9]); entity.EnabledMark = bool.Parse(colums[10]); entity.CreateTime = DateTime.MinValue; entity.LastModifyTime = DateTime.MinValue; entity.LastModifyUserId = colums[15]; dbContext.Roles.Add(entity); }); DataInitTool.ProcessFile("Sys_RoleAuthorize.csv", webRootPath, colums => { RoleAuthorizeEntity entity = new RoleAuthorizeEntity(); entity.Id = colums[0]; entity.ItemType = int.Parse(colums[1]); entity.ItemId = colums[2]; entity.ObjectType = int.Parse(colums[3]); entity.ObjectId = colums[4]; //entity.SortCode = int.Parse(colums[5]); entity.CreateTime = DateTime.MinValue; entity.CreatorUserId = colums[7]; dbContext.RoleAuthorize.Add(entity); }); DataInitTool.ProcessFile("Sys_User.csv", webRootPath, colums => { UserEntity entity = new UserEntity(); entity.Id = colums[0]; entity.Account = colums[1]; entity.RealName = colums[2]; entity.NickName = colums[3]; entity.Gender = bool.Parse(colums[5]); entity.MobilePhone = colums[7]; entity.OrganizeId = colums[13]; entity.DepartmentId = colums[14]; entity.RoleId = colums[15]; entity.DutyId = colums[16]; entity.IsAdministrator = bool.Parse(colums[17]); entity.DeleteMark = bool.Parse(colums[19]); entity.EnabledMark = bool.Parse(colums[20]); entity.Description = colums[21]; entity.CreateTime = DateTime.MinValue; entity.LastModifyTime = DateTime.MinValue; entity.LastModifyUserId = colums[25]; dbContext.Users.Add(entity); }); DataInitTool.ProcessFile("Sys_UserLogOn.csv", webRootPath, colums => { UserLogOnEntity entityt = new UserLogOnEntity(); entityt.Id = colums[0]; entityt.UserId = colums[1]; entityt.UserPassword = colums[2]; entityt.UserSecretkey = colums[3]; if (!string.IsNullOrEmpty(colums[9])) { entityt.PreviousVisitTime = DateTime.Parse(colums[9]); } if (!string.IsNullOrEmpty(colums[10])) { entityt.LastVisitTime = DateTime.Parse(colums[10]); } if (!string.IsNullOrEmpty(colums[13])) { entityt.LogOnCount = int.Parse(colums[13]); } dbContext.UserLogOn.Add(entityt); }); dbContext.SaveChanges(); } }