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);
        }
Exemplo n.º 3
0
        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);
            });
        }