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