public ActionResult createAD(AD ad) { if (Request.Cookies["userName"] == null) { return RedirectToAction("Index"); } string cookieUserName = Server.HtmlEncode(Request.Cookies["userName"].Value); if (cookieUserName.Length < 1) { return RedirectToAction("Index"); } ADBLL adBLL = new ADBLL(); if (adBLL.createAD(ad)) { return RedirectToAction("AD"); } else { return Content("创建失败"); } }
public bool createAD(AD ad) { string sql = string.Format("INSERT INTO AD(aTitle,aPicUrl,aLinkUrl) values('{0}','{1}','{2}')",ad.aTitle,ad.aPicUrl,ad.aLinkUrl); int n = DBHelper.NonQuery(sql); return n == 1; }
public ActionResult ADEdit(AD ad) { ADBLL adBLL = new ADBLL(); if (adBLL.EditAD(ad)) { return RedirectToAction("AD"); } else { return Content("修改失败"); } }
public bool EditAD(AD ad) { int n = DBHelper.NonQuery(string.Format("UPDATE AD SET aTitle='{0}',aPicUrl='{1}',aLinkUrl='{2}' where aId={3}", ad.aTitle, ad.aPicUrl, ad.aLinkUrl,ad.aId)); return n == 1; }