public bool Atualizar(Usuario usuario)
{
bool retorno = false;
try
{
_db.Usuarios.Where(w => w.Id == usuario.Id)
.ToList()
.ForEach(u =>
{
u.Nome = usuario.Nome;
u.Email = usuario.Email;
u.DataAlteracao = usuario.DataAlteracao;
u.AlteradoPor = usuario.AlteradoPor;
retorno = true;
});
_db.SaveChanges();
}
catch (Exception ex)
{
var dados = JsonConvert.SerializeObject(usuario);
retorno = false;
Logger.Debug(dados, ex);
_db.Dispose();
_db = new ContextBase();
}
return(retorno);
}
public void Dispose()
{
if (Transaction != null)
{
Transaction.Dispose();
}
if (Context != null)
{
Context.Database.Connection.Close();
Context.Dispose();
Context = null;
//DbInterception.Remove(intercepter);
//DbInterception.Remove(treeIntercepter);
}
}
internal static IWebHost MigrateDbContext <TContext>(this IWebHost webHost, Action <TContext> seeder) where TContext : DbContext
{
Task.Run(delegate
{
using (var scope = webHost.Services.CreateScope())
{
var context = new ContextBase();
try
{
context.Database.Migrate();
context.Dispose();
}
catch (Exception ex)
{
var logger = scope.ServiceProvider.GetRequiredService <ILogger <TContext> >();
logger.LogError(ex, "An error occurred while migrating the database.");
}
}
});
return(webHost);
}
public void Dispose()
{
_context.Dispose();
}
public void Dispose()
{
Db.Dispose();
}
public void Dispose()
{
// (Db?) se existir faça o dispose senao nao faça
Db?.Dispose();
}
public void Dispose()
{
_contextBase?.Dispose();
}
public void Dispose()
{
_dbContext.Dispose();
}
public ActionResultVM Export(QueryDataInputVM ivm, string title)
{
var vm = new ActionResultVM();
//文件路径
string path = "/upload/temp/";
var vpath = (GlobalTo.WebRootPath + path).Replace("\\", "/");
if (!Directory.Exists(vpath))
{
Directory.CreateDirectory(vpath);
}
//文件名
string filename = title.Replace(" ", "").Trim() + "_" + DateTime.Now.ToString("yyyyMMdd_HHmmss") + ".xlsx";
//导出的表数据
var dtReport = new DataTable();
try
{
var ovm = new QueryDataOutputVM();
var db = new ContextBase();
switch (ivm.tableName?.ToLower())
{
default:
vm.Set(ARTag.invalid);
break;
//角色
case "sysrole":
{
ovm = new SettingController().QuerySysRole(ivm);
dtReport = ExportAid.ModelsMapping(ivm, ovm);
}
break;
//用户
case "sysuser":
{
ovm = new SettingController().QuerySysUser(ivm);
dtReport = ExportAid.ModelsMapping(ivm, ovm);
}
break;
//日志
case "syslog":
{
ovm = new SettingController().QuerySysLog(ivm);
dtReport = ExportAid.ModelsMapping(ivm, ovm);
}
break;
}
db.Dispose();
if (vm.msg != ARTag.invalid.ToString())
{
//生成
if (Fast.NpoiTo.DataTableToExcel(dtReport, vpath + filename))
{
vm.data = path + filename;
//生成的Excel继续操作
ExportAid.ExcelDraw(vpath + filename, ivm);
vm.Set(ARTag.success);
}
else
{
vm.Set(ARTag.fail);
}
}
}
catch (Exception ex)
{
vm.Set(ex);
}
return(vm);
}
public void Dispose()
{
ContextBase.Database.EnsureDeleted();
ContextBase.Dispose();
}
public void Dispose()
{
Context.Dispose();
GC.SuppressFinalize(this);
}