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