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