/// <summary> /// 刪除角色 /// </summary> /// <param name="id"></param> /// <returns></returns> public string DeleteRole(string id) { string result = string.Empty; SQLConnTran sqlConnTran = _sqlConnectionHelper.BeginTransaction(); int deleteRoleUserResult = _roleUserRepo.DeleteRoleUserByRoleID(id, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans); int deleteRoleFunctionResult = _roleFunctionRepo.DeleteRoleFunctionByRoleID(id, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans); int deleteRoleResult = _roleRepo.DeleteRole(id, ref sqlConnTran.SqlConn, ref sqlConnTran.SqlTrans); if (deleteRoleUserResult >= 0 && deleteRoleFunctionResult >= 0 && deleteRoleResult > 0) { result = ""; } else { result = "刪除失敗。"; } _sqlConnectionHelper.Commit(); // tran.Commit(); return(result); }
/// <summary> /// 角色編輯功能 /// 儲存勾選功能時的變更 /// </summary> /// <param name="functionCheckVO"></param> /// <returns></returns> public string SaveRoleFunctionSetting(IEnumerable <FunctionCheckVO> functionCheckVO) { string result = string.Empty; string roleID; if (functionCheckVO != null && functionCheckVO.Any()) { roleID = functionCheckVO.First().RoleID.ToString(); List <RoleFunctionDTO> roleFunctionDTOs = new List <RoleFunctionDTO>(); foreach (var item in functionCheckVO) { RoleFunctionDTO roleFunctionDTO = new RoleFunctionDTO(); roleFunctionDTO.RoleID = item.RoleID; roleFunctionDTO.FunctionID = item.FunctionID; roleFunctionDTOs.Add(roleFunctionDTO); } var sqlConnTrans = _sqlConnectionHelper.BeginTransaction(); int deleteResult = _roleFunctionRepo.DeleteRoleFunctionByRoleID(roleID, ref sqlConnTrans.SqlConn, ref sqlConnTrans.SqlTrans); if (deleteResult < 0) { _sqlConnectionHelper.Rollback(); result = "刪除失敗。"; return(result); } int insertResult = 0; foreach (var item in roleFunctionDTOs) { insertResult += _roleFunctionRepo.InsertRoleFunction(item, ref sqlConnTrans.SqlConn, ref sqlConnTrans.SqlTrans); } _sqlConnectionHelper.Commit(); if (insertResult < 0) { _sqlConnectionHelper.Rollback(); result = "設定失敗。"; } } return(result); }