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