public ActionResult EditArticles(FormCollection form) { int boardId = 0; bool resultBoardId = int.TryParse(form["boardId"].ToString(), out boardId); article_Tb Item = new article_Tb(); Item = Service_Article_P.GetArticle_Md(boardId); Item.title = form["title"].Trim(); int themeId = 0; bool resultthemeId = int.TryParse(form["theme_id"].ToString().Trim(), out themeId); if (resultthemeId) { Item.arti_theme = themeId; } Item.arti_txt = form["article_txt"]; bool result = Service_Article_P.UpdateArticle_Md(Item); //如有更改theme則更改返回頁面時Url的theme值 NameValueCollection nvc = (NameValueCollection)TempData["ArticleQueryString"]; string url = "?"; foreach (string key in nvc.Keys) { url += key + "="; url += (!key.Equals("theme")) ? nvc[key] : themeId.ToString(); url += "&"; } //收尾 url += "order=0"; Method.RedirectUrl = "/Article/ReviewArticle" + url; TempData[InternalVal._RESULTMSG] = "文章修改成功!"; return(RedirectToAction("ResultMessage", "Home")); }
public ActionResult AddArticle(article_Tb articleItem) { if (articleItem == null) { TempData[InternalVal._RESULTMSG] = "發生錯誤!請重新發佈文章!"; return(RedirectToAction("ResultMessage", "Home")); } //產生流水號 string str = ""; str += "AR000"; str += DateTime.Now.ToString("yyMM"); str += DateTime.Now.ToString("dd"); str += new Random().Next(10, 99); str += DateTime.Now.ToString("hh"); str += DateTime.Now.ToString("mm"); str += DateTime.Now.ToString("ss"); str += new Random().Next(10, 99); articleItem.numNo = str; bool result = Service_Article_P.InsertArticle_Md(articleItem); if (result) { TempData[InternalVal._RESULTMSG] = "文章發佈成功!"; } else { TempData[InternalVal._RESULTMSG] = "文章發佈失敗!"; } TempData["ArticleNO"] = str; article_Tb Item = Service_Article_P.GetArticle_Md(str); return(RedirectToAction("ReviewArticle", new { article = Item.arti_id, board = articleItem.board_id, theme = articleItem.arti_theme })); }
public bool InsertArticle_Md(article_Tb articleItem) { //為空則回傳false if (articleItem == null) { return(false); } string strSql = "insert article_tb (title, arti_date, arti_txt, view_num, arti_theme, board_id, user_id, numNo) " + "values(@title, @arti_date, @arti_txt, @view_num, @arti_theme, @board_id, @user_id, @numNo)"; SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@title", SqlDbType.NChar), new SqlParameter("@arti_date", SqlDbType.DateTime), new SqlParameter("@arti_txt", SqlDbType.NText), new SqlParameter("@view_num", SqlDbType.Int), new SqlParameter("@arti_theme", SqlDbType.Int), //某版區塊文章 new SqlParameter("@board_id", SqlDbType.Int), //全部文章 new SqlParameter("@user_id", SqlDbType.Int), new SqlParameter("@numNo", SqlDbType.NVarChar) }; sqlParameters[0].Value = articleItem.title.ToString(); sqlParameters[1].Value = DateTime.Now; sqlParameters[2].Value = articleItem.arti_txt.ToString(); sqlParameters[3].Value = 0; sqlParameters[4].Value = int.Parse(articleItem.arti_theme.ToString()); sqlParameters[5].Value = int.Parse(articleItem.board_id.ToString()); sqlParameters[6].Value = int.Parse(articleItem.user_id.ToString()); sqlParameters[7].Value = articleItem.numNo.ToString(); //是否有資料變更 return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, strSql, sqlParameters) > 0); }
public ActionResult CheckArticleInfo(string title, string board_id, string theme_id, string article_txt) { Method.ValueIsEmpty(title); Method.ValueIsEmpty(board_id); Method.ValueIsEmpty(theme_id); Method.ValueIsEmpty(article_txt); if (Method.ValueIsEmpty_Val) { return(View("LaunchArticle", (HomeViewModel)Session["ViewModel"])); } //int getBoardId = Service_Board_P.GetBoardIdOfTheme_Md(int.Parse(theme_id.Trim())); int getBoardId = Service_Board_P.GetBoardIdOfTheme_Md(int.Parse(theme_id.Trim())); if (getBoardId != int.Parse(board_id.Trim())) { TempData[InternalVal._RESULTMSG] = "該討論版無此分類!請重新發佈文章!"; return(RedirectToAction("ResultMessage", "Home")); } article_Tb articleItem = new article_Tb() { title = title.Trim(), arti_txt = article_txt.Trim(), board_id = int.Parse(board_id.Trim()), arti_theme = int.Parse(theme_id.Trim()), user_id = Service_User_P.GetUserInfo_Md(Session[InternalVal._SESSIONACCOUNT].ToString()).user_id }; return(RedirectToAction("AddArticle", articleItem)); }
public bool UpdateArticle_Md(article_Tb articleItem) { article_Tb objItem = db.article_Tb.FirstOrDefault(m => m.arti_id == articleItem.arti_id); objItem.title = articleItem.title.ToString(); objItem.arti_update = DateTime.Now; objItem.arti_txt = articleItem.arti_txt.ToString(); objItem.arti_theme = int.Parse(articleItem.arti_theme.ToString()); //更換文章區塊 return(db.SaveChanges() > 0); }
/// <summary> /// 刪除文章回覆 /// </summary> /// <param name="replyId"></param> /// <param name="article"></param> /// <returns></returns> public ActionResult DeleteReply(int replyId, int article) { HomeViewModel viewModel = new HomeViewModel(); article_reply_Tb replyItem = new article_reply_Tb(); article_Tb articleItem = new article_Tb(); replyItem = Service_Article_P.GetArticleReply_Md(replyId); articleItem = Service_Article_P.GetArticle_Md(article); articleItem.title = Method.StrSubstring(articleItem.title, 0, 30); viewModel.replyAritlceItem = replyItem; viewModel.articleItem = articleItem; return(View(viewModel)); }
/// <summary> /// 觀看文章 /// </summary> /// <param name="article"></param> /// <param name="board"></param> /// <param name="theme"></param> /// <returns></returns> public ActionResult ReviewArticle(int?article, int?board, int?theme) { HomeViewModel viewModel = new HomeViewModel(); //文章ID為空直接跳轉至該討論版 Method.ValueIsEmpty(article); if (Method.ValueIsEmpty_Val) { return(RedirectToAction("BoardArticle", new { board = board })); } //討論版ID為空直接跳轉至首頁 Method.ValueIsEmpty(board); if (Method.ValueIsEmpty_Val) { return(RedirectToAction("Index", "Home")); } article_Tb articleItem = new article_Tb(); articleItem = Service_Article_P.GetArticle_Md((int)article); //檢查該筆文章是否符合 if (articleItem.arti_id != article || articleItem.board_id != board || articleItem.arti_theme != theme) { TempData[InternalVal._RESULTMSG] = "無該筆文章!"; return(RedirectToAction("ResultMessage", "Home")); } //獲取當前的URL參數 TempData["ArticleUrl"] = Request.Url.Query; TempData["ArticleQueryString"] = Request.QueryString; //文章內容資訊 viewModel.articleItem = articleItem; viewModel.replyCount = Service_Article_P.GetArticleReplyCount_Md((int)article); viewModel.boardItem = new board_Tb() { id = (int)board, board_name = Service_Board_P.GetBoardName_Md((int)board) }; viewModel.userItem = Service_User_P.GetUserInfo_Md(articleItem.user_id); //文章回覆 List <article_reply_Tb> replyArticleItems = Service_Article_P.ListArticleReply_Md((int)article).ToList(); viewModel.replyAritlceList = replyArticleItems; List <user_Tb> userItems = new List <user_Tb>(); for (int i = 0; i < replyArticleItems.Count(); i++) { userItems.Add(Service_User_P.GetUserInfo_Md(replyArticleItems[i].user_id)); } viewModel.userInfoList = userItems; return(View(viewModel)); }
public ActionResult EditArticle(int article, int board, int theme) { HomeViewModel viewModel = new HomeViewModel(); board_Tb boardItem = new board_Tb(); article_Tb articleItem = new article_Tb(); List <board_Tb> themeItems = new List <board_Tb>(); articleItem = Service_Article_P.GetArticle_Md(article); boardItem = Service_Board_P.BoardItem_Md(null, theme); boardItem.id = theme; boardItem.theme_board_id = board; boardItem.board_name = Service_Board_P.GetBoardName_Md(board); themeItems = Service_Board_P.ListTheme_Md(board); viewModel.articleItem = articleItem; viewModel.boardItem = boardItem; viewModel.themeList = themeItems; return(View(viewModel)); }
public bool InsertArticle_Md(article_Tb articleItem) { //為空則回傳false if (articleItem == null) { return(false); } using (var connection = new SqlConnection(_connection)) { string strSql = @"insert article_tb ( title, arti_date, arti_txt, view_num, arti_theme, board_id, user_id, numNo) values( @title, @arti_date, @arti_txt, @view_num, @arti_theme, @board_id, @user_id, @numNo)"; articleItem.arti_date = DateTime.Now; articleItem.view_num = 0; //是否有資料變更 return(connection.Execute(strSql, articleItem) > 0); } }
public ActionResult ReplyArticle(int?article, int?board, int?theme, int?reply) { //判斷是否有文章編號 Method.ValueIsEmpty(article); if (Method.ValueIsEmpty_Val) { return(RedirectToAction("Index", "Home")); } HomeViewModel viewModel = new HomeViewModel(); article_Tb articleItem = new article_Tb(); article_reply_Tb replyItem = new article_reply_Tb(); int num = (int)article; articleItem = Service_Article_P.GetArticle_Md(num); articleItem.title = Method.StrSubstring(articleItem.title, 0, 50); board_Tb boardItem = new board_Tb(); boardItem = Service_Board_P.BoardItem_Md(null, theme); viewModel.replyCount = Service_Article_P.GetArticleReplyCount_Md((int)article); //回覆樓主 TempData["replyAuthor"] = true; if (boardItem.theme_board_id != board && boardItem.id != theme) { TempData[InternalVal._RESULTMSG] = "發生錯誤!無法回覆文章!"; return(RedirectToAction("ResultMessage", "Home")); } if (reply != null) { replyItem = Service_Article_P.GetArticleReply_Md(reply); articleItem.arti_txt = "\"引用:" + Method.StrSubstring(replyItem.reply_txt, 0, 30) + "\""; TempData["replyAuthor"] = false; } boardItem.theme_board_id = articleItem.board_id; boardItem.id = (int)theme; boardItem.board_name = Service_Board_P.GetBoardName_Md((int)board); boardItem.theme_name = boardItem.theme_name; viewModel.articleItem = articleItem; viewModel.boardItem = boardItem; return(View(viewModel)); }
/// <summary> /// 獲取單筆文章內容 /// </summary> /// <param name="numStr">文章流水編號</param> /// <returns></returns> public article_Tb GetArticle_Md(string numStr) { article_Tb objItem = db.article_Tb.FirstOrDefault(s => s.numNo == numStr); return(objItem); }
/// <summary> /// 獲取單筆文章內容 /// </summary> /// <param name="id">article_id</param> /// <returns></returns> public article_Tb GetArticle_Md(int id) { article_Tb objItem = db.article_Tb.FirstOrDefault(s => s.arti_id == id); return(objItem); }
public bool UpdateArticle_Md(article_Tb articleItem) { return(Repository_Article_P.UpdateArticle_Md(articleItem)); }
public bool InsertArticle_Md(article_Tb articleItem) { return(Repository_Article_P.InsertArticle_Md(articleItem)); }
/// <summary> /// 獲取單筆文章內容 /// </summary> /// <param name="numStr">文章流水編號</param> /// <returns></returns> public article_Tb GetArticle_Md(string numStr) { article_Tb objItem = Repository_Article_P.GetArticle_Md(numStr); return(objItem); }