/// <summary> /// 回覆取得 /// </summary> /// <returns></returns> public ActionResult ReplyIndex(int?messagesId) { Library.MessageReply model = messageWeb.GetMessageReplys().ToList() .Find(x => x.Messages.Id == messagesId); string UserAccount = ""; string UserName = ""; if (messagesId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if (SessionManagement.LoginUser != null) { UserAccount = SessionManagement.LoginUser.UserAccount; ViewBag.UserAccount = UserAccount; UserName = SessionManagement.LoginUser.UserName; ViewBag.UserName = UserName; } if (SessionManagement.LoginUser.UserClass != 2) { return(RedirectToAction("Index")); } return(View(model)); }
/// <summary> /// 取得留言回覆 /// </summary> /// <returns></returns> public IEnumerable <MessageReply> GetMessageReplys() { List <MessageReply> result = new List <MessageReply>(); using (SqlConnection con = new SqlConnection(DBConnection.ConnectString)) { SqlCommand cmd = new SqlCommand(SPName.MessageReply.MessageRely_Get, con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); int currentID = 0; MessageReply item = null; while (dr.Read()) { if (currentID == 0 || int.Parse(dr["Message_Id"].ToString()) != currentID) { Message msg = new Message() { Id = Convert.ToInt32(dr["Message_Id"]), UserId = Convert.ToInt32(dr["Message_UserId"]), UserName = dr["Message_UserName"].ToString(), Context = dr["Message_Context"].ToString(), CreatDate = Convert.ToDateTime(dr["Message_CreatDate"].ToString()) }; item = new MessageReply(); item.Messages = msg; item.ReplyList = new List <Reply>(); if (dr["Reply_Id"] != DBNull.Value) { Reply reply = new Reply() { Id = Convert.ToInt32(dr["Reply_Id"]), UserName = dr["Reply_UserName"].ToString(), Context = dr["Reply_Context"].ToString(), CreatDate = Convert.ToDateTime(dr["Reply_CreatDate"].ToString()) }; item.ReplyList.Add(reply); } result.Add(item); currentID = msg.Id; } else { item.ReplyList.Add(new Reply { Id = Convert.ToInt32(dr["Reply_Id"]), UserName = dr["Reply_UserName"].ToString(), Context = dr["Reply_Context"].ToString(), CreatDate = Convert.ToDateTime(dr["Reply_CreatDate"].ToString()) }); } } } return(result); }
/// <summary> /// Session登入取得資料 /// </summary> /// <returns></returns> //public string SessionGet() //{ // string UserAccount = ""; // string UserName = ""; // int Id = 0; // byte UserClass = 0; // if (Session["UserAccount"] != null) // { // UserAccount = Session["UserAccount"].ToString(); // ViewBag.UserAccount = UserAccount; // UserName = Session["UserName"].ToString(); // ViewBag.UserName = UserName; // int.TryParse(Session["Id"].ToString(), out Id); // ViewBag.Id = Id; // byte.TryParse(Session["UserClass"].ToString(), out UserClass); // ViewBag.UserClass = UserClass; // } // return (); //} #endregion #region 回覆取得 /// <summary> /// 回覆取得 /// </summary> /// <returns></returns> public ActionResult ReplyIndex(int messagesId) { //List<MessageReply> model = messageWeb.GetMessageReplys().ToList(); //Library.MessageReply model = messageWeb.GetMessageReplys().ToList() // .Find(x => x.Messages.Id == messagesId); Library.MessageReply model = messageWeb.GetMessageReplys().ToList() .Find(x => x.Messages.Id == messagesId); return(View(model)); }