public Boolean AddCurrentCmnt(CurrentCmnt cmnt)
{
String sql = @"INSERT INTO [current_cmnt]([current_id], [user_id], [contents], [cmnt_date])
VALUES(@current_id, @user_id, @contents, @cmnt_date)";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@current_id", cmnt.CurrentId),
new SqlParameter("@user_id", cmnt.UserId),
new SqlParameter("@contents", cmnt.Contents),
new SqlParameter("@cmnt_date", cmnt.CmntDate)
};
Int32 line = (Int32)connector.Execute("non", sql, parameters);
return line <= 0 ? false : true;
}
// 发评论
protected void CmntBtn_Click(object sender, EventArgs e)
{
try
{
string cmntText = CmntText.Text.ToString();
Int64 currentId = GetCurrentId();
if (!IsSignIn())
{
Response.Redirect(URL_SIGNIN);
return;
}
User user = (User)Session["User"];
if (currentId != 0)
{
// 构建待插入对象
CurrentCmnt cmnt = new CurrentCmnt()
{
CurrentId = currentId,
UserId = user.Id,
Contents = cmntText,
CmntDate = DateTime.Now.ToLocalTime()
};
bool isOk = CurrentCmntService.AddCurrentCmnt(cmnt);
if (isOk)
{
DisplayCurrentCmnt(); // 从新显示评论区
}
}
}
catch (Exception ex)
{
PromptInfo.Text = ex.Message;
}
}
/// <summary>
/// 添加动态评论记录
/// </summary>
/// <param name="cmnt">实体对象</param>
/// <returns>布尔值：是否添加成功</returns>
public static Boolean AddCurrentCmnt(CurrentCmnt cmnt)
{
return(iDao.AddCurrentCmnt(cmnt));
}
