/// <summary> /// 来源系统产品体系--课程信息表 /// </summary> /// <param name="fkProductCourseGuid"></param> /// <returns></returns> public EXTCoursePageInfoResponse GetEXTCourseByPage(POCEXTCourseRequest search) { EXTCoursePageInfoResponse response = new EXTCoursePageInfoResponse(); response = pocProductRepository.GetEXTCourseByPage(search); return(response); }
//public static void FindEvery(TreeView tv, List<DictTreeResponse> CheckedTreeNodes, Guid parentGuid) //{ // if (CheckedTreeNodes.Count > 0) // { // foreach (var item in CheckedTreeNodes) // { // if (item.value.ToUpper() == parentGuid.ToString().ToUpper()) // { // tv.SelectedNode = item; // //tv.SelectedNode.Expand();//展开找到的节点 // //tv.SelectedNode.BackColor = System.Drawing.Color.LightGray;//谁知道在Node失去选中状态时,如何取消掉这个BackColor的,请留言评论 // //return;//找到一个就返回,没有return则继续查找 直到遍历所有节点 // } // FindEvery(tv, item.Nodes, parentGuid); // } // } //} /// <summary> /// 来源系统产品体系--课程信息表 /// </summary> /// <param name="fkProductCourseGuid"></param> /// <returns></returns> public EXTCoursePageInfoResponse GetEXTCourseByPage(POCEXTCourseRequest search) { EXTCoursePageInfoResponse resultInfo = new EXTCoursePageInfoResponse(); 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 * FROM T_EXT_Course 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_EXT_Course>(EumDBName.POC, strSql, "", _parameters); var sql = $"{strQuery} OFFSET {(search.PageIndex - 1) * search.PageSize} ROW FETCH NEXT {search.PageSize} ROWS ONLY"; resultInfo.ReusltList = GetInfos <T_EXT_Course>(sql, _parameters); return(resultInfo); }