public ActionResult DeleteEssay(string uid, string title)
{
DBHelper tmpDBHelper = new DBHelper();
tmpDBHelper.SqlExcute("delete from Essay where UserID = '" + uid + "'and EssayTitle = '" + title + "'");
return Redirect("ManageEssay");
}
public ActionResult Delete(string uid, string title, string content)
{
// TODO: Add delete logic here
DBHelper db = new DBHelper();
var DelStr = CommentDelStr(uid, title, content);
db.SqlExcute(DelStr);
return RedirectToAction("Index");
}
public ActionResult CreateEssay(Essay model)
{
DBHelper tmpDBHelper = new DBHelper();
var title = model.Title;
var content = model.Content;
var userID = Session["UserId"].ToString();
tmpDBHelper.SqlExcute("insert into Essay(UserId,EssayTitle,EssayContent) values('" + userID + "','" + title + "','" + content + "')");
return Redirect("ListEssay");
}
public ActionResult Create(string content)
{
DBHelper db = new DBHelper();
var uid = Session["UserId"].ToString();
ViewBag.Essay = db.GetEssyByUid_Title(essay_uid, essay_title);
//**************************************************************
try
{
// TODO: Add insert logic here
db.SqlExcute(CommentCreateSql(essay_title, content));
ViewBag.CommentList = db.GetCommentListByTitle(essay_title);
Response.Write("<script>alert('评论成功！')</script>");
return View();
}
catch
{
return View();
}
}
public ActionResult Register(RegisterViewModel model)
{
if (ModelState.IsValid)
{
if (!ExistAccount(model.UserId))
{
DBHelper db = new DBHelper();
db.SqlExcute(StoreAccountText(model.UserId, model.Pwd));
return Redirect("~/Essay/ListEssay");
}
else
{
Response.Write("<script>alert('该手机号码已被注册')</script>");
return View(model);
}
}
// 如果我们进行到这一步时某个地方出错，则重新显示表单
return View(model);
}
