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