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