/// <summary>
/// 添加主题
/// </summary>
/// <param name="bbsPosts">主题对象</param>
/// <returns>添加的记录行数</returns>
public int AddPostByTopicId(BbsPosts bbsPosts)
{
SqlParameter[] parameters = {
new SqlParameter("@topicId", SqlDbType.Int,4),
new SqlParameter("@postContent", SqlDbType.NText),
new SqlParameter("@postUserName", SqlDbType.NChar,20),
new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
new SqlParameter("@userNo", SqlDbType.NVarChar,50),
new SqlParameter("@userType", SqlDbType.Int),
new SqlParameter("@courseNo", SqlDbType.NVarChar,50)};
parameters[0].Value = bbsPosts.topicId;
parameters[1].Value = bbsPosts.postContent;
parameters[2].Value = bbsPosts.postUserName;
parameters[3].Value = bbsPosts.attachmentIds;
parameters[4].Value = bbsPosts.postUserNo;
parameters[5].Value = bbsPosts.postUserType;
parameters[6].Value = bbsPosts.courseNo;
return int.Parse(SqlHelper.ExecuteScalar(conn, "spBbsPostsAdd", parameters).ToString());
}
protected void btnCommit_Click(object sender, EventArgs e)
{
if (Textarea1.Value.Length == 0)
{
Javascript.GoHistory(-1, "请填写回复内容！", Page);
return;
}
int lastPostId = 0;
DalOperationAboutBbs dalOperationAboutBbs = new DalOperationAboutBbs();
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
BbsPosts post = new BbsPosts
{
topicId = topicId,
postContent = CommonUtility.JavascriptStringFilterAll(Textarea1.Value),
postUserName = (UserCookiesInfo.userType != 3) ? UserCookiesInfo.userName : UserCookiesInfo.userNo + " " + UserCookiesInfo.userName,
updateTime = DateTime.Now,
attachmentIds = hidAttachmentId.Value,
postUserNo = UserCookiesInfo.userNo,
postUserType = UserCookiesInfo.userType,
courseNo = forumId
};
lastPostId = dalOperationAboutBbs.AddPostByTopicId(post);
PageDataBinds();
hidAttachmentId.Value = string.Empty;
Textarea1.Value = string.Empty;
Javascript.JavaScriptLocationHref("#post" + lastPostId.ToString(), Page);
}
