public static List<Brand> GetBrandsByProductOnMain(ProductOnMain.TypeFlag type) { var subCmd = string.Empty; switch (type) { case ProductOnMain.TypeFlag.New: subCmd = "New=1"; break; case ProductOnMain.TypeFlag.Bestseller: subCmd = "Bestseller=1"; break; case ProductOnMain.TypeFlag.Discount: subCmd = "Discount>0"; break; } string cmd = "Select Brand.BrandID, Brand.BrandName, UrlPath, Brand.SortOrder from Catalog.Brand where BrandID in (select BrandID from Catalog.Product where " + subCmd + " ) order by Brand.BrandName"; return SQLDataAccess.ExecuteReadList<Brand>(cmd, CommandType.Text, reader => new Brand { BrandId = SQLDataHelper.GetInt(reader, "BrandID"), Name = SQLDataHelper.GetString(reader, "BrandName"), UrlPath = SQLDataHelper.GetString(reader, "UrlPath") }); }
public UserControls_FilterBrand() { WorkType = ProductOnMain.TypeFlag.None; }
public FilterBrand() { WorkType = ProductOnMain.TypeFlag.None; }