/// <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); }