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