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