/// <summary> /// 更新主留言內容 /// </summary> /// <param name="loginData">會員登入資料</param> /// <param name="Content">編輯內容</param> /// <param name="MainMessageID">主留言編號</param> /// <returns>新留言內容</returns> public string UpdateMainMessage(MemberLoginModel loginData, string Content, string MainMessageID) { //資料庫編輯過後的留言 string UpdatedMessage = string.Empty; //前端取得ID 為M_32 string[] MainID = MainMessageID.Split('_'); //判斷是否分析字串後是否長度大於0 & 是否可轉型 & 轉型後ID不可為0 int guestbookID = 0; if (MainID.Length > 0 && int.TryParse(MainID[1], out guestbookID) && guestbookID != 0) { UpdateMainMessageModel updateModel = new UpdateMainMessageModel { MemberID = loginData.Member_ID, GuestBookID = guestbookID, Content = Content, UpdateTime = DateTime.Now }; UpdatedMessage = guestbookRepository.UpdateMainMessageContent(updateModel); } return(UpdatedMessage); }
/// <summary> /// 更新主留言 /// </summary> /// <param name="updateModel">更新主留言資料</param> /// <returns>新的主留言內容</returns> public string UpdateMainMessageContent(UpdateMainMessageModel updateModel) { string newMainMessage = string.Empty; using (var conn = new SqlConnection(connection)) { var updatedContent = conn.QuerySingle <string>(CommontSPName.UpdateMainMessage, new { MemberID = updateModel.MemberID, UpdatedContent = updateModel.Content, MainID = updateModel.GuestBookID, UpdateTime = updateModel.UpdateTime }, commandType: System.Data.CommandType.StoredProcedure); newMainMessage = updatedContent; } return(newMainMessage); }