public ProductTypeCollection FetchAll() { ProductTypeCollection coll = new ProductTypeCollection(); Query qry = new Query(ProductType.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public void Get() { // ObservableCollection<Product> list = new ObservableCollection<Product>(); try { ProductTypeCollection = db.GetProductType(); ProductCollection = db.GetProduct(); } catch (Exception e) { MessageBox.Show("Błąd podczas pobierania danych z bazy: " + e.Message); } foreach (Product p in ProductCollection) { try { //fu = _listaSzczegolyFaktur.Where(x => x.IdFaktury == f.Id).First(); p.ProductType = ProductTypeCollection.Where(x => x.Id == p.ProductTypeId).First(); } catch (Exception) { } } // ProductCollectionGridView = ProductCollection; }
/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List <ProductTypeInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount) { if (pPageIndex <= 1) { pPageIndex = 1; } List <ProductTypeInfo> list = new List <ProductTypeInfo>(); Query q = ProductType.CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression, pOrderBy.ToString()); ProductTypeCollection collection = new ProductTypeCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (ProductType productType in collection) { ProductTypeInfo productTypeInfo = new ProductTypeInfo(); LoadFromDAL(productTypeInfo, productType); list.Add(productTypeInfo); } pRecordCount = q.GetRecordCount(); return(list); }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List <ProductTypeInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(ProductTypeInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return(CachedEntityCommander.GetCache(cacheKey) as List <ProductTypeInfo>); } else { List <ProductTypeInfo> list = new List <ProductTypeInfo>(); ProductTypeCollection collection = new ProductTypeCollection(); Query qry = new Query(ProductType.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach (ProductType productType in collection) { ProductTypeInfo productTypeInfo = new ProductTypeInfo(); LoadFromDAL(productTypeInfo, productType); list.Add(productTypeInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(ProductTypeInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return(list); } }
public void GetProductSellingPagesFull() { Assert.IsNotNull(TestData.ProductSearchResults2); ProductTypeCollection al = new ProductTypeCollection(); ProductFamilyTypeCollection fm = TestData.ProductSearchResults2[0].AttributeSet[0].ProductFamilies; for(int i = 0; i < fm.Count; i++ ) { if( fm[i].FamilyMembers != null && fm[i].FamilyMembers.Count > 0 ) { ProductType pt = fm[i].FamilyMembers[0]; pt.ProductReferenceID = null; pt.stockPhotoURL = null; al.Add(pt); } } GetProductSellingPagesCall api = new GetProductSellingPagesCall(this.apiContext); api.ProductList = al; api.UseCase = ProductUseCaseCodeType.AddItem; // Make API call. api.Execute(); //check whether the call is success. Assert.IsTrue(api.ApiResponse.Ack==AckCodeType.Success || api.ApiResponse.Ack==AckCodeType.Warning,"do not success!"); Assert.IsNotNull(api.ApiResponse.ProductSellingPagesData); Assert.Greater(api.ApiResponse.ProductSellingPagesData.Length,0); }
public void GetProductSellingPages() { Assert.IsNotNull(TestData.ProductSearchResults); ProductTypeCollection al = new ProductTypeCollection(); ProductFamilyTypeCollection fm = TestData.ProductSearchResults[0].AttributeSet[0].ProductFamilies; for(int i = 0; i < fm.Count; i++ ) { if( fm[i].FamilyMembers != null && fm[i].FamilyMembers.Count > 0 ) { ProductType pt = fm[i].FamilyMembers[0]; pt.ProductReferenceID = null; pt.stockPhotoURL = null; al.Add(pt); // Only retrieve 3 pages if( al.Count >= 1 ) break; } } GetProductSellingPagesCall api = new GetProductSellingPagesCall(this.apiContext); api.ProductList = al; api.UseCase = ProductUseCaseCodeType.AddItem; // Make API call. String sellingPage = api.GetProductSellingPages(api.UseCase, api.ProductList); Assert.IsNotNull(sellingPage); }
/// <summary> /// his type is deprecated as the call is no longer available. /// </summary> /// /// <param name="UseCase"> /// Specifies the context in which the call is being executed, which will imply /// certain validation rules. Use this property to make sure you retrieve the /// appropriate version of product information and attribute meta-data /// when you are listing, revising, or relisting an item with Pre-filled Item Information. /// </param> /// /// <param name="ProductList"> /// A catalog product identifies a prototype description /// of a well-known type of item, such as a popular book. /// As this call supports batch requests, you can pass in an array of products /// to retrieve data for several products at the same time. /// </param> /// public string GetProductSellingPages(ProductUseCaseCodeType UseCase, ProductTypeCollection ProductList) { this.UseCase = UseCase; this.ProductList = ProductList; Execute(); return(ApiResponse.ProductSellingPagesData); }
/// <summary> /// his type is deprecated as the call is no longer available. /// </summary> /// /// <param name="UseCase"> /// Specifies the context in which the call is being executed, which will imply /// certain validation rules. Use this property to make sure you retrieve the /// appropriate version of product information and attribute meta-data /// when you are listing, revising, or relisting an item with Pre-filled Item Information. /// </param> /// /// <param name="ProductList"> /// A catalog product identifies a prototype description /// of a well-known type of item, such as a popular book. /// As this call supports batch requests, you can pass in an array of products /// to retrieve data for several products at the same time. /// </param> /// public string GetProductSellingPages(ProductUseCaseCodeType UseCase, ProductTypeCollection ProductList) { this.UseCase = UseCase; this.ProductList = ProductList; Execute(); return ApiResponse.ProductSellingPagesData; }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List <ProductTypeInfo> pList, ProductTypeCollection pCollection) { foreach (ProductType productType in pCollection) { ProductTypeInfo productTypeInfo = new ProductTypeInfo(); LoadFromDAL(productTypeInfo, productType); pList.Add(productTypeInfo); } }
protected override async Task <bool> GetDataAsync() { var resource = new ProductTypeResource(Context); _results = await resource.GetProductTypesAsync(startIndex : StartIndex, pageSize : PageSize, sortBy : SortBy, filter : Filter, responseFields : ResponseFields); TotalCount = _results.TotalCount; PageCount = _results.PageCount; PageSize = _results.PageSize; return(_results.Items != null && _results.Items.Count > 0); }
private void FillDropDowns() { CommonHelper.FillDropDownWithEnum(this.ddlDownloadActivationType, typeof(DownloadActivationTypeEnum)); CommonHelper.FillDropDownWithEnum(this.ddlCyclePeriod, typeof(RecurringProductCyclePeriodEnum)); this.ddlTemplate.Items.Clear(); ProductTemplateCollection productTemplateCollection = TemplateManager.GetAllProductTemplates(); foreach (ProductTemplate productTemplate in productTemplateCollection) { ListItem item2 = new ListItem(productTemplate.Name, productTemplate.ProductTemplateId.ToString()); this.ddlTemplate.Items.Add(item2); } this.ddlProductType.Items.Clear(); ProductTypeCollection productTypeCollection = ProductManager.GetAllProductTypes(); foreach (ProductType productType in productTypeCollection) { ListItem item2 = new ListItem(productType.Name, productType.ProductTypeId.ToString()); this.ddlProductType.Items.Add(item2); } this.ddlTaxCategory.Items.Clear(); ListItem itemTaxCategory = new ListItem("---", "0"); this.ddlTaxCategory.Items.Add(itemTaxCategory); TaxCategoryCollection taxCategoryCollection = TaxCategoryManager.GetAllTaxCategories(); foreach (TaxCategory taxCategory in taxCategoryCollection) { ListItem item2 = new ListItem(taxCategory.Name, taxCategory.TaxCategoryId.ToString()); this.ddlTaxCategory.Items.Add(item2); } this.ddlWarehouse.Items.Clear(); ListItem itemWarehouse = new ListItem("---", "0"); this.ddlWarehouse.Items.Add(itemWarehouse); WarehouseCollection warehouseCollection = WarehouseManager.GetAllWarehouses(); foreach (Warehouse warehouse in warehouseCollection) { ListItem item2 = new ListItem(warehouse.Name, warehouse.WarehouseId.ToString()); this.ddlWarehouse.Items.Add(item2); } CommonHelper.FillDropDownWithEnum(this.ddlLowStockActivity, typeof(LowStockActivityEnum)); }
void ShowWindowEditProduct() // Wyświetlenie okna dialogowego do edycji typu produktu { if (SelectedProduct != null) { NewProductVM = new AddProductViewModel(); NewProductVM.Prod = SelectedProduct; NewProductVM.ProductType = ProductTypeCollection.Where(x => x.Id == SelectedProduct.ProductTypeId).First(); NewProductVM.IdVisible = Visibility.Visible; NewProductVM.IsEnabled = false; _addProductWindow = new AddProductWindow(); _addProductWindow.DataContext = NewProductVM; _addProductWindow.Title = "Edycja produktu"; _addProductWindow.ShowDialog(); } }
private void FillDropDowns() { this.ddlTemplate.Items.Clear(); ProductTemplateCollection productTemplateCollection = TemplateManager.GetAllProductTemplates(); foreach (ProductTemplate productTemplate in productTemplateCollection) { ListItem item2 = new ListItem(productTemplate.Name, productTemplate.ProductTemplateID.ToString()); this.ddlTemplate.Items.Add(item2); } this.ddlProductType.Items.Clear(); ProductTypeCollection productTypeCollection = ProductManager.GetAllProductTypes(); foreach (ProductType productType in productTypeCollection) { ListItem item2 = new ListItem(productType.Name, productType.ProductTypeID.ToString()); this.ddlProductType.Items.Add(item2); } }
/// <summary> /// 批量装载 /// </summary> internal static void LoadFromDALPatch(List< ProductTypeInfo> pList, ProductTypeCollection pCollection) { foreach (ProductType productType in pCollection) { ProductTypeInfo productTypeInfo = new ProductTypeInfo(); LoadFromDAL(productTypeInfo, productType ); pList.Add(productTypeInfo); } }
/// <summary> /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据 /// </summary> /// <param name="pPageIndex">页数</param> /// <param name="pPageSize">每页列表</param> /// <param name="pOrderBy">排序</param> /// <param name="pSortExpression">排序字段</param> /// <param name="pRecordCount">列表行数</param> /// <returns>数据分页</returns> public static List<ProductTypeInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount) { if(pPageIndex<=1) pPageIndex=1; List< ProductTypeInfo> list = new List< ProductTypeInfo>(); Query q = ProductType .CreateQuery(); q.PageIndex = pPageIndex; q.PageSize = pPageSize; q.ORDER_BY(pSortExpression,pOrderBy.ToString()); ProductTypeCollection collection=new ProductTypeCollection(); collection.LoadAndCloseReader(q.ExecuteReader()); foreach (ProductType productType in collection) { ProductTypeInfo productTypeInfo = new ProductTypeInfo(); LoadFromDAL(productTypeInfo, productType); list.Add(productTypeInfo); } pRecordCount=q.GetRecordCount(); return list; }
/// <summary> /// 获得数据列表 /// </summary> /// <returns></returns> public static List<ProductTypeInfo> GetList() { string cacheKey = GetCacheKey(); //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取 if (CachedEntityCommander.IsTypeRegistered(typeof(ProductTypeInfo)) && CachedEntityCommander.GetCache(cacheKey) != null) { return CachedEntityCommander.GetCache(cacheKey) as List< ProductTypeInfo>; } else { List< ProductTypeInfo> list =new List< ProductTypeInfo>(); ProductTypeCollection collection=new ProductTypeCollection(); Query qry = new Query(ProductType.Schema); collection.LoadAndCloseReader(qry.ExecuteReader()); foreach(ProductType productType in collection) { ProductTypeInfo productTypeInfo= new ProductTypeInfo(); LoadFromDAL(productTypeInfo,productType); list.Add(productTypeInfo); } //生成缓存 if (CachedEntityCommander.IsTypeRegistered(typeof(ProductTypeInfo))) { CachedEntityCommander.SetCache(cacheKey, list); } return list; } }
private static ProductTypeCollection DBMapping(DBProductTypeCollection dbCollection) { if (dbCollection == null) return null; ProductTypeCollection collection = new ProductTypeCollection(); foreach (DBProductType dbItem in dbCollection) { ProductType item = DBMapping(dbItem); collection.Add(item); } return collection; }
public ProductTypeCollection FetchByID(object ProductTypeId) { ProductTypeCollection coll = new ProductTypeCollection().Where("ProductTypeId", ProductTypeId).Load(); return coll; }
public ProductTypeCollection FetchByQuery(Query qry) { ProductTypeCollection coll = new ProductTypeCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }