// 发回复
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"];
CurrentReply currentReply = new CurrentReply()
{
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);
currentReply.AimsId = aimsId;
}
// 添加回复记录到数据库
bool isOk = CurrentReplyService.AddCurrentReply(currentReply);
// 刷新评论区域
if (isOk)
{
replyText.Text = ""; // 清空输入框
DisplayCurrentCmntReply(repeateReply, currentReply.CmntId);
}
}
catch (Exception ex)
{
PromptInfo.Text = ex.Message;
}
}
public Boolean AddCurrentReply(CurrentReply reply)
{
String sql = null;
SqlParameter[] parameters = null;
if (reply.AimsId != 0) // 回复评论的回复
{
sql = @"INSERT INTO [current_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 [current_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 static Boolean AddCurrentReply(CurrentReply reply)
{
return(iDao.AddCurrentReply(reply));
}
