public ActionResult SubmitForm(DbBackupEntity dbBackupEntity) { dbBackupEntity.F_FilePath = Server.MapPath("~/Resource/DbBackup/" + dbBackupEntity.F_FileName + ".bak"); dbBackupEntity.F_FileName = dbBackupEntity.F_FileName + ".bak"; dbBackupApp.SubmitForm(dbBackupEntity); return(Success("操作成功。")); }
public void SubmitForm(DbBackupEntity dbBackupEntity) { dbBackupEntity.F_Id = Common.GuId(); dbBackupEntity.F_EnabledMark = true; dbBackupEntity.F_BackupTime = DateTime.Now; service.ExecuteDbBackup(dbBackupEntity); }
public ActionResult SubmitForm(DbBackupEntity dbBackupEntity) { dbBackupEntity.F_FilePath = _hostingEnvironment.WebRootPath + "/Resource/DbBackup/" + dbBackupEntity.F_FileName + ".bak"; dbBackupEntity.F_FileName = dbBackupEntity.F_FileName + ".bak"; dbBackupApp.SubmitForm(dbBackupEntity); return(Success("操作成功。")); }
public Task <int> Save(DbBackupEntity dbBackupEntity) { dbBackupEntity.Id = Common.GuId(); dbBackupEntity.EnabledMark = true; dbBackupEntity.BackupTime = DateTime.Now; return(service.ExecuteDbBackup(dbBackupEntity)); }
public void ExecuteDbBackup(string dbName, string backupType, string desc = null, string filename = null) { using var trans = repoService.DbContext.Database.BeginTransaction(); DbBackupEntity dbBackupEntity = new DbBackupEntity { BackupTime = DateTime.Now, DbName = dbName, BackupType = backupType, Description = desc }; if (filename == null) { filename = dbBackupEntity.BackupTime !.ToString(); } if (string.IsNullOrEmpty(Path.GetExtension(filename))) { filename = Path.ChangeExtension(filename, ".bak"); } dbBackupEntity.FileName = filename; dbBackupEntity.FilePath ??= "~/Resource/DbBackup/" + dbBackupEntity.FileName; repoService.DbContext.Database.ExecuteSqlRaw( $"backup database {dbName} to disk ='{Path.Combine(hostingEnvironment.ContentRootPath, dbBackupEntity.FilePath)}'"); dbBackupEntity.FileSize = FileHelper.ToFileSize(FileHelper.GetFileSize(dbBackupEntity.FilePath)); repoService.Update(dbBackupEntity); trans.Commit(); }
public ActionResult SubmitForm(DbBackupEntity dbBackupEntity) { var module = new ModuleApp().GetList().Where(a => a.F_Layers == 1 && a.F_EnCode == moduleName).FirstOrDefault(); var moduleitem = new ModuleApp().GetList().Where(a => a.F_Layers > 1 && a.F_EnCode == className.Substring(0, className.Length - 10)).FirstOrDefault(); LogEntity logEntity = new LogEntity(module.F_FullName, moduleitem.F_FullName, DbLogType.Create.ToString()); logEntity.F_Description += DbLogType.Create.ToDescription(); try { logEntity.F_Account = OperatorProvider.Provider.GetCurrent().UserCode; logEntity.F_NickName = OperatorProvider.Provider.GetCurrent().UserName; dbBackupEntity.F_FilePath = Server.MapPath("~/Resource/DbBackup/" + dbBackupEntity.F_FileName + ".bak"); if (!Directory.Exists(Server.MapPath("~/Resource/DbBackup/"))) { DirectoryInfo directoryInfo = new DirectoryInfo(Server.MapPath("~/Resource/DbBackup/")); directoryInfo.Create(); } dbBackupEntity.F_FileName = dbBackupEntity.F_FileName + ".bak"; dbBackupApp.SubmitForm(dbBackupEntity); logEntity.F_Description += "操作成功"; new LogApp().WriteDbLog(logEntity); return(Success("操作成功。")); } catch (Exception ex) { logEntity.F_Result = false; logEntity.F_Description += "操作失败," + ex.Message; new LogApp().WriteDbLog(logEntity); return(Error(ex.Message)); } }
public async Task <IActionResult> SubmitForm(DbBackupEntity dbBackupEntity) { dbBackupEntity.FilePath = wwwPath.ContentRootPath + "/Resource/DbBackup/" + dbBackupEntity.FileName + ".bak"; dbBackupEntity.FileName = dbBackupEntity.FileName + ".bak"; await dbBackupApp.Save(dbBackupEntity); return(Success("操作成功。")); }
public ActionResult SubmitForm(DbBackupEntity dbBackupEntity) { string DBBasePath = Server.MapPath("/Resource/DbBackup/"); FileHelper.CreateDirectory(DBBasePath); dbBackupEntity.F_FilePath = DBBasePath + dbBackupEntity.F_FileName + ".bak"; dbBackupEntity.F_FileName = dbBackupEntity.F_FileName + ".bak"; dbBackupApp.SubmitForm(dbBackupEntity); base.OperateLog("数据库备份", "/SystemSecurity/DbBackup/SubmitForm", "数据备份", Application.DbLogType.Other); return(Success("操作成功。")); }
public ActionResult SubmitForm(DbBackupEntity dbBackupEntity) { if (!Directory.Exists(Server.MapPath("~/Resource/DbBackup/"))) { Directory.CreateDirectory(Server.MapPath("~/Resource/DbBackup/")); } dbBackupEntity.F_FilePath = Server.MapPath("~/Resource/DbBackup/" + dbBackupEntity.F_FileName + ".bak"); dbBackupEntity.F_FileName = dbBackupEntity.F_FileName + ".bak"; dbBackupApp.SubmitForm(dbBackupEntity); return(Success("操作成功。")); }
public void SubmitForm(DbBackupEntity entity, string keyValue) { if (!string.IsNullOrEmpty(keyValue)) { entity.Modify(keyValue); service.Update(entity); } else { entity.Create(); service.Insert(entity); } }
public void SubmitForm(DbBackupEntity dbBackupEntity) { dbBackupEntity.Id = Common.GuId(); dbBackupEntity.EnabledMark = true; dbBackupEntity.BackupTime = DateTime.Now; //var LoginInfo = OperatorProvider.Provider.GetCurrent(); var LoginInfo = SysLoginObjHelp.sysLoginObjHelp.GetOperator(); if (LoginInfo != null) { dbBackupEntity.CreatorUserId = LoginInfo.UserId; } dbBackupEntity.CreatorTime = DateTime.Now; service.ExecuteDbBackup(dbBackupEntity); //添加日志 LogHelp.logHelp.WriteDbLog(true, "添加数据库备份信息", Enums.DbLogType.Create, "数据库备份管理"); }
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(); } }
public void Delete(DbBackupEntity entity) { service.Delete(entity); }