public ActionResult AllStoreShow(string keyString)
{
keyString = Request.Form["keyString"];
List <AllStoreViewModel> models = new List <AllStoreViewModel>();
foreach (TB_STORE store in db.TB_STORE.Where(a => a.NAME.Contains(keyString)).ToList())
{
AllStoreViewModel item = new AllStoreViewModel();
item.store_name = store.NAME;
item.rank = (int?)store.QUALITY_RATING;
item.store_id = (int?)store.ID;
List <ProductWithPicture_2_0> products = new List <ProductWithPicture_2_0>();
Products p_db = new Products();
foreach (TB_PRODUCT temp_item in p_db.TB_PRODUCT.Where(a => a.S_ID == store.ID).ToList())
{
ProductWithPicture_2_0 pwp = new ProductWithPicture_2_0();
Pro_pics pic_db = new Pro_pics();
pwp.product = temp_item;
TB_PRO_PIC pic = pic_db.TB_PRO_PIC.Where(a => a.P_ID == temp_item.ID && a.S_ID == temp_item.S_ID).First();
if (pic != null)
{
pwp.PICTURE = pic.PICTURE;
}
products.Add(pwp);
}
item.products = new List <ProductWithPicture_2_0>();
int i = 0;
while (i < 5 && i < products.Count)
{
item.products.Add(products[i]);
i++;
}
models.Add(item);
}
ViewData["StoreKeyString"] = "所有";
return(View(models));
}
public ActionResult AllStoreShow(string keyString)
{
keyString = Request.Form["keyString"];
List<AllStoreViewModel> models = new List<AllStoreViewModel>();
foreach (TB_STORE store in db.TB_STORE.Where(a => a.NAME.Contains(keyString)).ToList())
{
AllStoreViewModel item = new AllStoreViewModel();
item.store_name = store.NAME;
item.rank = (int?)store.QUALITY_RATING;
item.store_id = (int?)store.ID;
List<ProductWithPicture_2_0> products = new List<ProductWithPicture_2_0>();
Products p_db = new Products();
foreach (TB_PRODUCT temp_item in p_db.TB_PRODUCT.Where(a => a.S_ID == store.ID).ToList())
{
ProductWithPicture_2_0 pwp = new ProductWithPicture_2_0();
Pro_pics pic_db = new Pro_pics();
pwp.product = temp_item;
TB_PRO_PIC pic = pic_db.TB_PRO_PIC.Where(a => a.P_ID == temp_item.ID && a.S_ID == temp_item.S_ID).First();
if (pic != null)
{
pwp.PICTURE = pic.PICTURE;
}
products.Add(pwp);
}
item.products = new List<ProductWithPicture_2_0>();
int i = 0;
while (i < 5 && i < products.Count)
{
item.products.Add(products[i]);
i++;
}
models.Add(item);
}
ViewData["StoreKeyString"] = "所有";
return View(models);
}