public async Task <IHttpActionResult> GetNoticeReply(int id)
{
NoticeReply noticeReply = await db.NoticeReplies.FindAsync(id);
if (noticeReply == null)
{
return(NotFound());
}
return(Ok(noticeReply));
}
/// <summary>
/// 提交评论回复按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ReplyBtn_Click(object sender, EventArgs e)
{
Button replyBtn = (Button)sender;
HiddenField hiddenCmntId = replyBtn.Parent.FindControl("HiddenCmntId") as HiddenField;
HiddenField hiddenAimsId = replyBtn.Parent.FindControl("HiddenAimsId") as HiddenField;
TextBox replyText = replyBtn.Parent.FindControl("ReplyText") as TextBox;
Panel cmntReplyPanel = replyBtn.Parent as Panel;
Repeater repeateReply = cmntReplyPanel.Parent.FindControl("ReptCmntReply") as Repeater;
try
{
if (!IsSignIn())
{
Response.Redirect(URL_SIGNIN);
return;
}
User user = (User)Session["User"];
NoticeReply noticeReply = new NoticeReply()
{
CmntId = Int64.Parse(hiddenCmntId.Value),
UserId = user.Id,
Contents = replyText.Text.Trim(),
ReplyDate = DateTime.Now.ToLocalTime(),
};
string _aimsId = hiddenAimsId.Value; // 获取回复目标编号
if (!String.IsNullOrEmpty(_aimsId))
{
Int64 aimsId = Int64.Parse(_aimsId);
noticeReply.AimsId = aimsId;
}
// 添加回复记录到数据库
bool isOk = NoticeReplyService.AddNoticeReply(noticeReply);
// 刷新评论区域
if (isOk)
{
replyText.Text = ""; // 清空输入框
DisplayNoticeCmntReply(repeateReply, noticeReply.CmntId);
}
}
catch (Exception ex)
{
PromptInfo.Text = ex.Message;
}
}
public async Task <IHttpActionResult> PutNoticeReply(int id, NoticeReply reply)
{
PetterResultType <NoticeReply> petterResultType = new PetterResultType <NoticeReply>();
List <NoticeReply> noticeReplies = new List <NoticeReply>();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
NoticeReply noticeReply = await db.NoticeReplies.FindAsync(id);
if (noticeReply == null)
{
return(NotFound());
}
// 수정권한 체크
if (noticeReply.MemberNo != noticeReply.MemberNo)
{
return(BadRequest(ModelState));
}
noticeReply.Reply = reply.Reply;
noticeReply.StateFlag = StateFlags.Use;
noticeReply.DateModified = DateTime.Now;
db.Entry(noticeReply).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
noticeReplies.Add(noticeReply);
petterResultType.IsSuccessful = true;
petterResultType.JsonDataSet = noticeReplies;
return(Ok(petterResultType));
}
public Boolean AddNoticeReply(NoticeReply reply)
{
String sql = null;
SqlParameter[] parameters = null;
if (reply.AimsId != 0)
{
sql = @"INSERT INTO [notice_reply]([cmnt_id], [aims_id], [user_id], [contents], [reply_date])
VALUES(@cmnt_id, @aims_id, @user_id, @contents, @reply_date)";
parameters = new SqlParameter[]
{
new SqlParameter("@cmnt_id", reply.CmntId),
new SqlParameter("@aims_id", reply.AimsId),
new SqlParameter("@user_id", reply.UserId),
new SqlParameter("@contents", reply.Contents),
new SqlParameter("@reply_date", reply.ReplyDate)
};
}
else
{
sql = @"INSERT INTO [notice_reply]([cmnt_id], [user_id], [contents], [reply_date])
VALUES(@cmnt_id, @user_id, @contents, @reply_date)";
parameters = new SqlParameter[]
{
new SqlParameter("@cmnt_id", reply.CmntId),
new SqlParameter("@user_id", reply.UserId),
new SqlParameter("@contents", reply.Contents),
new SqlParameter("@reply_date", reply.ReplyDate)
};
}
Int32 line = (Int32)connector.Execute("non", sql, parameters);
return(line <= 0 ? false : true);
}
public async Task <IHttpActionResult> DeleteNoticeReply(int id)
{
PetterResultType <NoticeReply> petterResultType = new PetterResultType <NoticeReply>();
List <NoticeReply> noticeReplies = new List <NoticeReply>();
NoticeReply noticeReply = await db.NoticeReplies.FindAsync(id);
if (noticeReply == null)
{
return(NotFound());
}
noticeReply.StateFlag = StateFlags.Delete;
noticeReply.DateDeleted = DateTime.Now;
db.Entry(noticeReply).State = EntityState.Modified;
await db.SaveChangesAsync();
noticeReplies.Add(noticeReply);
petterResultType.IsSuccessful = true;
petterResultType.JsonDataSet = noticeReplies;
return(Ok(petterResultType));
}
public async Task <IHttpActionResult> PostNoticeReply(NoticeReply noticeReply)
{
PetterResultType <NoticeReply> petterResultType = new PetterResultType <NoticeReply>();
List <NoticeReply> noticeReplies = new List <NoticeReply>();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
noticeReply.StateFlag = StateFlags.Use;
noticeReply.DateCreated = DateTime.Now;
noticeReply.DateModified = DateTime.Now;
db.NoticeReplies.Add(noticeReply);
await db.SaveChangesAsync();
noticeReplies.Add(noticeReply);
petterResultType.IsSuccessful = true;
petterResultType.JsonDataSet = noticeReplies;
return(Ok(petterResultType));
}
/// <summary>
/// 添加启示评论回复
/// </summary>
/// <param name="reply">实体对象</param>
/// <returns>布尔值：是否成功</returns>
public static Boolean AddNoticeReply(NoticeReply reply)
{
return(iNoticeReplyDao.AddNoticeReply(reply));
}
