public ActionResult Promotions() { ViewBag.path = CDictionary.picPath; DBprjDataContext db = new DBprjDataContext(); IEnumerable<ViewPromotions> table = from t in db.ViewPromotions select t; return View(table); }
public ActionResult CompanyPromotion(string id) { ViewBag.path = CDictionary.picPath; DBprjDataContext db = new DBprjDataContext(); IEnumerable<ViewPromotions> table = from t in db.ViewPromotions where t.廠商.StartsWith(id) select t; return View(table); }
public ActionResult ManliCard(string p) { int cardnum = Convert.ToInt32(Request.Form["txtNum"]); DBprjDataContext db = new DBprjDataContext(); IEnumerable<ManliCard> manlicard = from t in db.ManliCard where t.cardNumber.Equals(cardnum) select t; //db.ManliCard.FirstOrDefault(t => t.cardNumber == cardnum); //if (manlicard != null) //{ //} return View(manlicard); }