/// <summary> /// 批量删除角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="ids">主键数组</param> /// <returns>影响行数</returns> public int BatchDelete(BaseUserInfo userInfo, string[] ids) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDbWithTransaction(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); // 这里是直接删除功能的实现 // result = roleManager.BatchDelete(ids); BaseRoleEntity roleEntity = null; // 把删除的记录放到被删除的表里(表名后面加了后缀Deleted,也可以放在另外一个数据库里也可以的) var roleDeletedManager = new BaseRoleManager(dbHelper, userInfo, tableName + "Deleted"); foreach (var id in ids) { // 逐个删除,逐个备份 roleEntity = manager.GetObject(id); // 先添加到被删除的表里,这时候原先数据的主键需要保留的,否则恢复数据时可能会乱套 roleDeletedManager.Add(roleEntity); // 数据备份好后再进行删除处理 result += manager.Delete(id); } }); return(result); }
/// <summary> /// 删除角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="role">角色</param> /// <returns>影响行数</returns> public int DeleteRole(BaseUserInfo userInfo, string role) { // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif int returnValue = 0; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo); string id = roleManager.GetId(new KeyValuePair <string, object>(BaseRoleEntity.FieldRealName, role)); if (!String.IsNullOrEmpty(id)) { // 在删除时,可能会把相关的其他配置角色会删除掉,所以需要调用这个方法。 returnValue = roleManager.Delete(id); } } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } return(returnValue); }
/// <summary> /// 删除角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>数据表</returns> public int Delete(BaseUserInfo userInfo, string id) { int result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { string tableName = userInfo.SystemCode + "Role"; var manager = new BaseRoleManager(dbHelper, userInfo, tableName); result = manager.Delete(id); }); return(result); }
/// <summary> /// 删除角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="id">主键</param> /// <returns>数据表</returns> public int Delete(BaseUserInfo userInfo, string id) { // 写入调试信息 #if (DEBUG) int milliStart = BaseBusinessLogic.StartDebug(userInfo, MethodBase.GetCurrentMethod()); #endif // 加强安全验证防止未授权匿名调用 #if (!DEBUG) LogOnService.UserIsLogOn(userInfo); #endif int returnValue = 0; using (IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType)) { try { dbHelper.Open(UserCenterDbConnection); string tableName = BaseRoleEntity.TableName; if (!string.IsNullOrEmpty(BaseSystemInfo.SystemCode)) { tableName = BaseSystemInfo.SystemCode + "Role"; } BaseRoleManager roleManager = new BaseRoleManager(dbHelper, userInfo, tableName); returnValue = roleManager.Delete(id); BaseLogManager.Instance.Add(dbHelper, userInfo, serviceName, AppMessage.RoleService_Delete, MethodBase.GetCurrentMethod()); } catch (Exception ex) { BaseExceptionManager.LogException(dbHelper, userInfo, ex); throw ex; } finally { dbHelper.Close(); } } // 写入调试信息 #if (DEBUG) BaseBusinessLogic.EndDebug(MethodBase.GetCurrentMethod(), milliStart); #endif return(returnValue); }
/// <summary> /// 删除角色 /// </summary> /// <param name="userInfo">用户</param> /// <param name="role">角色</param> /// <returns>影响行数</returns> public int DeleteRole(BaseUserInfo userInfo, string role) { var result = 0; var parameter = ServiceInfo.Create(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessUserCenterWriteDb(userInfo, parameter, (dbHelper) => { var roleManager = new BaseRoleManager(dbHelper, userInfo); var id = roleManager.GetId(new KeyValuePair <string, object>(BaseRoleEntity.FieldName, role)); if (!string.IsNullOrEmpty(id)) { // 在删除时,可能会把相关的其他配置角色会删除掉,所以需要调用这个方法。 result = roleManager.Delete(id); } }); return(result); }