public DataTable GetProductExtByQuery(ProductExtQueryFilter query, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetItemExtList");
dc.SetParameterValue("@ProductID", query.ProductID);
dc.SetParameterValue("@ProductStatus", query.ProductStatus);
if (query.ProductType != null)
{
dc.SetParameterValue("@ProductType", LegacyEnumMapper.ConvertProductType(query.ProductType.Value));
}
else
{
dc.SetParameterValue("@ProductType", null);
}
dc.SetParameterValue("@Manufacturer", query.Manufacturer);
dc.SetParameterValue("@ProductPrice", query.ProductPrice);
dc.SetParameterValue("@IsPermitRefund", query.IsPermitRefund);
dc.SetParameterValue("@Category1", query.Category1);
dc.SetParameterValue("@Category2", query.Category2);
dc.SetParameterValue("@Category3", query.Category3);
dc.SetParameterValue("@SortField", query.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", query.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", query.PagingInfo.PageIndex);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(ProductStatus) },
{ "IsPermitRefund", typeof(IsDefault) }
};
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(dc.GetParameterValue("@TotalCount"));
return(dt);
}
public virtual QueryResult GetProductExtByQuery(ProductExtQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductExtDA> .Instance.GetProductExtByQuery(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
