/// <summary>
/// 根据query得到相关商品信息
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void GetProductRelatedByQuery(ProductRelatedQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductRelatedQueryFilter query = new ProductRelatedQueryFilter();
int ProductSysNo;
int RelatedProductSysNo;
if (int.TryParse(model.RelatedProductSysNo, out RelatedProductSysNo))
{
query.RelatedProductSysNo = RelatedProductSysNo;
}
if (int.TryParse(model.ProductSysNo, out ProductSysNo))
{
query.ProductSysNo = ProductSysNo;
}
query.PMUserSysNo = Convert.ToInt32(model.PMUserSysNo);
query.PageInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
restClient.QueryDynamicData(GetItemRelateUrl, query, (obj, args) =>
{
if (args.FaultsHandle())
{
return;
}
callback(obj, args);
});
}
public virtual QueryResult GetProductRelatedByQuery(ProductRelatedQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductRelatedDA> .Instance.GetProductRelatedByQuery(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 根据query 得到相关商品信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetProductRelatedByQuery(ProductRelatedQueryFilter query, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetItemRelatedList");
dc.SetParameterValue("@ProductSysNo", query.ProductSysNo);
dc.SetParameterValue("@RelatedProductSysNo", query.RelatedProductSysNo);
dc.SetParameterValue("@PMSysNo", query.PMUserSysNo);
dc.SetParameterValue("@SortField", query.PageInfo.SortBy);
dc.SetParameterValue("@PageSize", query.PageInfo.PageSize);
dc.SetParameterValue("@PageCurrent", query.PageInfo.PageIndex);
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable();
totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
return(dt);
}
