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);
}
