/// <summary>
/// 获取产品分类映射列表
/// </summary>
/// <param name="request"></param>
/// <param name="total"></param>
/// <returns></returns>
public List <ProductTypeMapping> GetProductTypeList(ProductTypeMappingListRequest request, out int total)
{
StringBuilder _query = new StringBuilder();
_query.AppendFormat(@"(select c.SysDictValue as FromSystem ,b.TeachLevelOneOrgName,b.ProductTypeName,b.NodeFlag,a.UpdateDate as MappingTime from T_POC_ProductTypeMap a
inner join T_EXT_ItemType b on a.FKItemTypeId=b.Id
inner join T_SYS_Dictionary c on cast(b.Pocsource as nvarchar)=c.SysDictKey
where a.FKProductTypeGuid=@ProductTypeID");
var _parameters = new DynamicParameters();
_parameters.Add("@ProductTypeID", request.ProductTypeId);
_query.AppendFormat(" ) h");
//总数
total = GetInfos <int>(EumDBName.POC, string.Format("SELECT COUNT(1) FROM {0} ", _query), _parameters).First();
//分页
var _queryPage = string.Format(@"select FromSystem,
TeachLevelOneOrgName ,
ProductTypeName ,
NodeFlag ,
MappingTime
from (select ROW_NUMBER() OVER(ORDER BY h.MappingTime desc) as RowNum,h.* from {0}) as RowNumberTable", _query);
if (request.Pagination)
{
_queryPage += " where RowNum between @rowbegin and @rowend ";
_parameters.Add("@rowbegin", (request.PageIndex - 1) * request.PageSize + 1);
_parameters.Add("@rowend", request.PageIndex * request.PageSize);
}
var list = GetInfos <ProductTypeMapping>(EumDBName.POC, _queryPage.ToString(), _parameters).ToList();
return(list);
}
/// <summary>
/// 查看产品类别映射关系
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ProductTypeMappingListResponse SearchProductTypeList(ProductTypeMappingListRequest request)
{
int total = 0;
ProductTypeMappingListResponse response = new ProductTypeMappingListResponse();
response.DataList = pocProductItemTypeRepository.GetProductTypeList(request, out total);
response.Total = total;
return(response);
}
public BaseResponse GetProductTypeMappingList(ProductTypeMappingListRequest request)
{
try
{
ProductTypeMappingListResponse response = PocProductDomainService.SearchProductTypeList(request);
return(ApiSuccessResult(response));
}
catch (Exception ex)
{
_Log4Net.Error("GetProductTypeMappingList--异常信息", ex);
return(ApiErrorResult(ex.Message));
}
}
