//<---------------------------------新增留言---------------------------->
public JsonResult CreateComment(int MemberID, string Main, int ArticleID)
{
tComment list = new tComment()
{
MemberID = MemberID,
Main = Main,
ArticleID = ArticleID,
UpTime = DateTime.Now,
};
tc.create(list);
return(Json(tc.getAll().LastOrDefault(t => t.No > 0).No, JsonRequestBehavior.AllowGet));
}
//<---------------------------------顯示回文留言---------------------------->
public JsonResult ReComment()
{
var list = trc.getAll().Select(m => new
{
MemberName = tm.getAll().FirstOrDefault(t => t.MemberID == m.MemberID).MemberName,
Main = m.Main,
UpTime = m.UpTime,
MemberID = m.MemberID,
ReArticleID = m.ReArticleID,
ImgURL = tm.getAll().FirstOrDefault(t => t.MemberID == m.MemberID).ImgURL,
No = m.No,
});
return(Json(list, JsonRequestBehavior.AllowGet));
}
//<---------------------------------新增文章---------------------------->
public JsonResult CreateDiscuss(tArticle form)
{
tArticle list = new tArticle()
{
Category = form.Category,
Title = form.Title,
Main = form.Main,
UpTime = DateTime.Now,
LoveCount = 0,
ViewCount = 0,
MemberID = form.MemberID
};
ta.create(list);
var ID = ta.getAll().LastOrDefault(m => m.ArticleID > 0).ArticleID;
return(Json(ID, JsonRequestBehavior.AllowGet));
}
//<-----------------登入--------------------->
public string Login(string Account, string Password, bool RememberMe)
{
string result;
if (tm.getAll().FirstOrDefault(m => m.Account == Account && m.Password == Password) != null)
{
if (tm.getAll().FirstOrDefault(m => m.Account == Account).Status == 1)
{
Response.Cookies["AutoLogin"]["MemberID"] = tm.getAll().FirstOrDefault(m => m.Account == Account).MemberID.ToString();
Response.Cookies["AutoLogin"]["MemberName"] = tm.getAll().FirstOrDefault(m => m.Account == Account).MemberName.ToString();
result = "登入成功";
if (RememberMe)
{
Response.Cookies["AutoLogin"].Expires = DateTime.Now.AddMonths(1);
}
}
else
{
result = "帳號已被封鎖 或 尚未啟用請確認信箱";
}
}
else
{
result = "帳號密碼錯誤";
}
return(result);
}
//<---------------------------------刪除文章---------------------------->
public JsonResult DelDiscuss(int ArticleID)
{
var count = tra.getAll().Where(m => m.ArticleID == ArticleID).Count(); //抓到回文數
for (int i = 0; i < count; i++)
{
var raid = tra.getAll().FirstOrDefault(m => m.ArticleID == ArticleID).ReArticleID;
var count1 = trc.getAll().Where(m => m.ReArticleID == raid).Count();
for (int k = 0; k < count1; k++)
{
trc.delete(trc.getAll().FirstOrDefault(m => m.ReArticleID == raid).No); //殺回文留言
}
var count2 = tral.getAll().Where(m => m.ReArticleID == raid).Count();
for (int k = 0; k < count2; k++)
{
tral.delete(tral.getAll().FirstOrDefault(m => m.ReArticleID == raid).No); //殺回文愛心
}
tra.delete(tra.getAll().FirstOrDefault(m => m.ArticleID == ArticleID).ReArticleID); //殺回文
}
var ccount = tc.getAll().Where(m => m.ArticleID == ArticleID).Count();
for (int i = 0; i < ccount; i++)
{
tc.delete(tc.getAll().FirstOrDefault(m => m.ArticleID == ArticleID).No); //殺本文留言
}
var ccount1 = tal.getAll().Where(m => m.ArticleID == ArticleID).Count();
for (int i = 0; i < ccount1; i++)
{
tal.delete(tal.getAll().FirstOrDefault(m => m.ArticleID == ArticleID).No); //殺本文愛心
}
ta.delete(ArticleID); //殺本文
return(Json("", JsonRequestBehavior.AllowGet));
}