/// <summary>
/// 商品销售区域设置查询
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetProductSalesAreaBatchList(ProductSalesAreaBatchQueryFilter query, out int totalCount)
{
DataCommand dc;
if (query.IsSearchProduct) //查询商品
{
dc = DataCommandManager.GetDataCommand("GetItemSalesAreaListBatchByProduct");
}
else
{
dc = DataCommandManager.GetDataCommand("GetItemSalesAreaListBatch");
}
dc.SetParameterValue("@Category1SysNo", query.Category1SysNo);
dc.SetParameterValue("@Category2SysNo", query.Category2SysNo);
dc.SetParameterValue("@Category3SysNo", query.Category3SysNo);
dc.SetParameterValue("@ManufacturerName", query.ManufacturerName == null?null:string.Format("%{0}%", query.ManufacturerName));
dc.SetParameterValue("@ProductName", query.ProductName == null?null:string.Format("%{0}%", query.ProductName));
dc.SetParameterValue("@ProvinceSysNo", query.ProvinceSysNos);
dc.SetParameterValue("@StockSysNo", query.StockSysNos);
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 = (int)dc.GetParameterValue("@TotalCount");
return(dt);
}
public virtual QueryResult GetProductSalesAreaBatchList(ProductSalesAreaBatchQueryFilter query)
{
int totalCount;
var dataTable = ObjectFactory <IProductSalesAreaBatchDA> .Instance.GetProductSalesAreaBatchList(query, out totalCount);
return(new QueryResult
{
Data = dataTable,
TotalCount = totalCount
});
}
/// <summary>
/// 得到设置区域商品的信息
/// </summary>
/// <param name="model"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="SortField"></param>
/// <param name="callback"></param>
public void GetProductSalesAreaBatchList(ProductSalesAreaBatchQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
ProductSalesAreaBatchQueryFilter query = model.ConvertVM <ProductSalesAreaBatchQueryVM, ProductSalesAreaBatchQueryFilter>();
query.PageInfo = new PagingInfo()
{
PageIndex = PageIndex, PageSize = PageSize, SortBy = SortField
};
restClient.QueryDynamicData(GetProductSalesAreaBatchListUrl, query, (obj, arg) =>
{
if (arg.FaultsHandle())
{
return;
}
callback(obj, arg);
});
}
/// <summary>
/// 得到商品信息
/// </summary>
/// <param name="query"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable GetProductByQuery(ProductSalesAreaBatchQueryFilter query, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("GetProductSalesAreaBatch");
dc.SetParameterValue("@category1", query.Category1SysNo);
dc.SetParameterValue("@category2", query.Category2SysNo);
dc.SetParameterValue("@category3", query.Category3SysNo);
dc.SetParameterValue("@PageSize", query.PageInfo.PageSize);
dc.SetParameterValue("@PageIndex", query.PageInfo.PageIndex);
dc.SetParameterValue("@ProductStatus", query.ProductStatus);
dc.SetParameterValue("@VendorName", query.VendorName);
dc.SetParameterValue("@ManufacturerName", query.ManufacturerName);
dc.SetParameterValue("@productName", query.ProductName);
dc.SetParameterValue("@shortField", query.PageInfo.SortBy);
DataTable dt = new DataTable();
dt = dc.ExecuteDataTable(7, typeof(ProductStatus));
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(dt);
}
