/// <summary> /// 来源系统产品体系--课程信息表 ViewModel /// </summary> /// <param name="fkProductCourseGuid"></param> /// <returns></returns> public VMEXTCoursePageInfoResponse GetVMEXTCourseByPage(POCEXTCourseRequest search) { VMEXTCoursePageInfoResponse response = new VMEXTCoursePageInfoResponse(); response = pocProductRepository.GetVMEXTCourseByPage(search); return(response); }
public BaseResponse GetEXTCourseByPage(POCEXTCourseRequest request) { try { VMEXTCoursePageInfoResponse response = PocProductDomainService.GetVMEXTCourseByPage(request); return(ApiSuccessResult(response)); } catch (Exception ex) { _Log4Net.Error("GetEXTCourseByPage--异常信息", ex); return(ApiErrorResult(ex.Message)); } }
/// <summary> /// 来源系统产品体系--课程信息表 ViewModel /// </summary> /// <param name="fkProductCourseGuid"></param> /// <returns></returns> public VMEXTCoursePageInfoResponse GetVMEXTCourseByPage(POCEXTCourseRequest search) { VMEXTCoursePageInfoResponse resultInfo = new VMEXTCoursePageInfoResponse(); string strWhere = string.Empty; var _parameters = new DynamicParameters(); #region 查询条件 if (search.FKProductCourseGuid != Guid.Empty) { strWhere += " AND FKProductCourseGuid=@FKProductCourseGuid"; _parameters.Add("@FKProductCourseGuid", search.FKProductCourseGuid); } if ((search.ExtractStatus == EXTCourseExtractStatusEnum.HasAssociated) || (search.ExtractStatus == EXTCourseExtractStatusEnum.HasExtract) || (search.ExtractStatus == EXTCourseExtractStatusEnum.WaitExtract)) { strWhere += " AND ExtractStatus=@ExtractStatus"; _parameters.Add("@ExtractStatus", search.ExtractStatus); } #endregion string strSql = @"(SELECT i.ProductTypeName,(SELECT COUNT(1) FROM T_EXT_CourseRange r WHERE UPPER(r.CourseID)=UPPER(c.CourseID)) CampusCountName, c.* FROM T_EXT_Course c LEFT JOIN T_EXT_ItemType i on c.FromSystem = i.FromSystem and UPPER(i.ProductTypeID)=UPPER(c.ProductTypeOneID) 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.RecordCount = GetPageCount <VM_EXT_Course>(EumDBName.POC, strSql, "", _parameters); var sql = $"{strQuery} OFFSET {(search.PageIndex - 1) * search.PageSize} ROW FETCH NEXT {search.PageSize} ROWS ONLY"; var queryInfo = GetInfos <VM_EXT_Course>(EumDBName.POC, sql, _parameters); resultInfo.ReusltList = queryInfo; return(resultInfo); }