public QueryObject <Role> QueryRoles(RoleRequest roleRequest) { var sql = @"select t.* from roles t where (@UserId is null or t.RoleId in (Select ur.Role_RoleId from UserRoles ur where ur.User_UserId = @UserId)) and (@Name is null or @Name = Name) and (@NameWith is null or Name like @NameWith) and (@DisplayNameWith is null or DisplayName like @DisplayNameWith) and (@State is null or State = @State) "; return(new QueryObject <Role>(_databaseInstance, sql, roleRequest)); }
/// <summary> /// 获取角色列表 /// </summary> /// <param name="roleRequest"></param> /// <returns></returns> public DataTables <Role> GetRoles(RoleRequest roleRequest) { SqlParameter[] param = { new SqlParameter("@Name", roleRequest.Name), new SqlParameter("@pageIndex", roleRequest.PageIndex), new SqlParameter("@pageSize", roleRequest.PageSize), new SqlParameter("@DisplayNameWith", roleRequest.DisplayNameWith), new SqlParameter("@NameWith", roleRequest.NameWith), new SqlParameter("@UserId", roleRequest.UserId), new SqlParameter("@State", roleRequest.State) }; StoreProcedure sp = new StoreProcedure("P_getRoles", param); return(_databaseInstance.GetTables <Role>(sp)); }