/// <summary> /// 获取分页产品信息列表 /// </summary> /// <param name="search">查询条件</param> /// <returns></returns> public POCProductPageInfoResponse GetPOCProductByPage(POCProductRequest search) { POCProductPageInfoResponse response = new POCProductPageInfoResponse(); response = pocProductRepository.GetPOCProductByPage(search); return(response); }
/// <summary> /// 获取分页产品信息列表 ViewModel /// </summary> /// <param name="search">查询条件</param> /// <returns></returns> public VMPOCProductPageInfoResponse GetVMPOCProductByPage(POCProductRequest search) { VMPOCProductPageInfoResponse responseVM = new VMPOCProductPageInfoResponse(); POCProductPageInfoResponse response = new POCProductPageInfoResponse(); response = pocProductRepository.GetPOCProductByPage(search); var responseList = response.ReusltList; var listVM = responseList.MapTo <VM_POC_Product>(); responseVM.ReusltList = listVM; return(responseVM); }
public BaseResponse GetPOCProductByPage(POCProductRequest request) { try { POCProductPageInfoResponse response = PocProductDomainService.GetPOCProductByPage(request); return(ApiSuccessResult(response)); //VMPOCProductPageInfoResponse response = PocProductDomainService.GetVMPOCProductByPage(request); //return ApiSuccessResult(response); } catch (Exception ex) { _Log4Net.Error("GetPOCProductByPage--异常信息", ex); return(ApiErrorResult(ex.Message)); } }
//public IList<T_POC_Product> GetAll(string strWhere) //{ // return GetInfos<T_POC_Product>(@"SELECT * FROM T_POC_Product WHERE 1=1 AND @strWhere", new { strWhere = @strWhere }); //} /// <summary> /// 获取分页产品信息列表 /// </summary> /// <param name="search">查询条件</param> /// <returns></returns> public POCProductPageInfoResponse GetPOCProductByPage(POCProductRequest search) { POCProductPageInfoResponse resultInfo = new POCProductPageInfoResponse(); string strWhere = string.Empty; var _parameters = new DynamicParameters(); #region 查询条件 if (search.ProductTypeGuid != Guid.Empty) { strWhere += " AND ProductTypeGuid=@ProductTypeGuid"; _parameters.Add("@ProductTypeGuid", search.ProductTypeGuid); } if ((search.CourseStatus == CourseStatusEnum.Deleted) || (search.CourseStatus == CourseStatusEnum.Disabled) || (search.CourseStatus == CourseStatusEnum.Enabled)) { strWhere += " AND CourseStatus=@CourseStatus"; _parameters.Add("@CourseStatus", search.CourseStatus); } if (!string.IsNullOrWhiteSpace(search.CourseName)) { var signs = new List <string> { "'", "[", "%", "_" }; strWhere += " AND CourseName like @CourseName"; _parameters.Add("@CourseName", $"%{search.CourseName.ReplaceBySigns(signs)}%"); } //if ((search.CheckedTreeNodes != null) && (search.CheckedTreeNodes.Count>0)) //{ // //获取所有选择的treeNode的Guid // GetChildNodeGuid(null, search.CheckedTreeNodes); // if (ChildNodeGuidList.Count>0) // { // strWhere += " AND ((GradeDictGuid in @CheckedTreeNodesGuid) or (CategoryDictGuid in @CheckedTreeNodesGuid)" + // "or (SubjectDictGuid in @CheckedTreeNodesGuid) or (TermDictGuid in @CheckedTreeNodesGuid) or (ClassTypeDictGuid in @CheckedTreeNodesGuid))"; // _parameters.Add("@CheckedTreeNodesGuid", ChildNodeGuidList); // } //} if ((search.CheckedNodeGuids != null) && (search.CheckedNodeGuids.Count > 0)) { List <Guid> listGuid = new List <Guid>(); foreach (var str in search.CheckedNodeGuids) { if ((!string.IsNullOrEmpty(str)) && (str.Length == 36)) { listGuid.Add(new Guid(str)); } } if (listGuid.Count > 0) { strWhere += " AND ((ProductTypeGuid in @CheckedTreeNodesGuid))"; _parameters.Add("@CheckedTreeNodesGuid", listGuid.ToArray()); } } #endregion string strSql = @"(SELECT * FROM T_POC_Product WHERE 1=1 " + strWhere + ") as t"; string SqlOrder = " ORDER BY t.Id desc"; if (!string.IsNullOrWhiteSpace(search.SortName)) { SqlOrder = " ORDER BY t." + search.SortName + " " + search.SortOrder; } string strQuery = "SELECT * FROM " + strSql + " " + SqlOrder; //resultInfo.allCount = GetPageCount<T_POC_Product>(EumDBName.OSC, strSql, "", new { DSI_Id = search.Id }); resultInfo.RecordCount = GetPageCount <T_POC_Product>(EumDBName.POC, strSql, "", _parameters); var sql = $"{strQuery} OFFSET {(search.PageIndex - 1) * search.PageSize} ROW FETCH NEXT {search.PageSize} ROWS ONLY"; resultInfo.ReusltList = GetInfos <T_POC_Product>(sql, _parameters).AsList(); return(resultInfo); }