public ActionResult DiscountShow(int?isHigh, int?store_id, string name)
{
DiscountViewModel model = new DiscountViewModel();
model.name = name;
model.store_id = store_id;
if (isHigh == 0)
{
model.dis = "五折以上商品";
model.products = db.Database.SqlQuery <TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString() + "AND DISCOUNT_RATE < 1 AND DISCOUNT_RATE > 0.5").ToList();
}
else if (isHigh == 1)
{
model.dis = "五折以下商品";
model.products = IndexModel.low_products = db.Database.SqlQuery <TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString() + "AND DISCOUNT_RATE < 0.5").ToList();
}
else
{
model.dis = "全部商品";
model.products = IndexModel.low_products = db.Database.SqlQuery <TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString()).ToList();
}
return(View(model));
}
public ActionResult DiscountShow(int? isHigh, int? store_id, string name)
{
DiscountViewModel model = new DiscountViewModel();
model.name = name;
model.store_id = store_id;
if (isHigh == 0)
{
model.dis = "五折以上商品";
model.products = db.Database.SqlQuery<TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString() + "AND DISCOUNT_RATE < 1 AND DISCOUNT_RATE > 0.5").ToList();
}
else if (isHigh == 1)
{
model.dis = "五折以下商品";
model.products = IndexModel.low_products = db.Database.SqlQuery<TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString() + "AND DISCOUNT_RATE < 0.5").ToList();
}
else
{
model.dis = "全部商品";
model.products = IndexModel.low_products = db.Database.SqlQuery<TB_PRODUCT>("SELECT * FROM TB_PRODUCT WHERE S_ID = " + store_id.ToString()).ToList();
}
return View(model);
}
