public void Update(RoleDb model, List <RoleModuleRelationDb> roleModuleRelations)
{
using (var db = PermissionDal.DbContext)
{
using (var dbContextTransaction = PermissionDal.DbContext.Database.BeginTransaction()) //起一个事务
{
try
{
RoleDb tempModel = PermissionDal.GetModel(c => c.role_id == model.role_id);
ModelCopier.CopyModel(model, tempModel, "creator_name",
"creator_full_name", "creator_time");
PermissionDal.EditData(tempModel);
PermissionDal.DbContext.Database.ExecuteSqlCommand(" delete from role_module_relation where role_id=@p0 ", model.role_id);
PermissionDal.AddList(roleModuleRelations);
PermissionDal.DbContext.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
}
finally
{
PermissionDal.DbContextDispose();
}
}
}
}
public void Update(AdminUserDb model, string roleIds)
{
//AdminUserDb dbModel = PermissionDal.GetModel(c => c.user_name == model.user_name);
//ModelCopier.CopyModel(model, dbModel);
List <AdminUserRoleRelationDb> aurrList = GetAdminUserRoleRelationList(roleIds, model.user_name);
using (var db = PermissionDal.DbContext)
{
using (var dbContextTransaction = db.Database.BeginTransaction()) //起一个事务
{
try
{
PermissionDal.EditData(model);
PermissionDal.DbContext.Database.ExecuteSqlCommand(" delete from admin_user_role_relation where user_name=@p0;",
model.user_name);
// PermissionDal.Set<AdminUserRoleRelationDb>().RemoveRange(aurrList);
if (aurrList != null && aurrList.Count > 0)
{
PermissionDal.AddList(aurrList);
}
db.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
}
}
}
PermissionDal.DbContextDispose();
}
