public virtual QueryResult GetProductQueryPriceChangeLog(ProductPriceChangeLogQueryFilter query) { int totalCount; var dataTable = ObjectFactory <IProductQueryPriceChangeLogDA> .Instance.GetProductQueryPriceChangeLog(query, out totalCount); return(new QueryResult { Data = dataTable, TotalCount = totalCount }); }
public DataTable GetProductQueryPriceChangeLog(ProductPriceChangeLogQueryFilter query, out int totalCount) { DataCommand dc = DataCommandManager.GetDataCommand("GetCategoryQueryPriceChangeLogList"); dc.SetParameterValue("@ProductSysno", query.ProductSysno); dc.SetParameterValue("@ProductID", query.ProductID); dc.SetParameterValue("@CreateDateFrom", query.CreateDateFrom); dc.SetParameterValue("@CreateDateTo", query.CreateDateTo); dc.SetParameterValue("@PriceLogType", query.PriceLogType); 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 void GetProductQueryPriceChangeLog(ProductQueryPriceChangeLogQueryVM model, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback) { ProductPriceChangeLogQueryFilter query = new ProductPriceChangeLogQueryFilter(); query = model.ConvertVM <ProductQueryPriceChangeLogQueryVM, ProductPriceChangeLogQueryFilter>(); query.PageInfo = new PagingInfo { PageSize = PageSize, PageIndex = PageIndex, SortBy = SortField }; restClient.QueryDynamicData(GetProductNotifyUrl, query, (obj, args) => { if (args.FaultsHandle()) { return; } callback(obj, args); }); }