private void ShowInfo(int _id) { BLL.Forum_Topic bll = new BLL.Forum_Topic(); Model.Forum_Topic model = bll.GetModel(_id); //编写赋值操作Begin txtUserId.Text = model.PostUserId.ToString(); ddlBoardId.SelectedValue = model.BoardId.ToString(); txtTopicTypeId.Text = model.TopicTypeId.ToString(); txtTitle.Text = model.Title; txtViewCount.Text = model.ViewCount.ToString(); txtPostDatetime.Text = model.PostDatetime.ToString(); if (model.Digest == 1) { cblItem.Items[0].Selected = true; } if (model.Top == 1) { cblItem.Items[1].Selected = true; } if (model.Ban == 1) { cblItem.Items[2].Selected = true; } rblClose.SelectedValue = model.Close.ToString(); modelPost = new BLL.Forum_Post(model.PostSubTable).GetModel(" First=1 and TopicId=" + _id + " "); txtMessage.Text = modelPost.Message; //编写赋值操作End }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("plugin_forum_post", DTEnums.ActionEnum.Delete.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; BLL.Forum_Post bll = new BLL.Forum_Post(subTableId); BLL.Forum_Topic bllTopic = new BLL.Forum_Topic(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); int topicId = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidTopicId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { //调用与前台一样的方法 bllTopic.DeleterReply(id.ToString(), topicId); sucCount += 1; } } AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除dt_Forum_Post_" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("Post_list.aspx", "keywords={0}&subTableId={1}", this.keywords, this.subTableId.ToString())); }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("plugin_forum_topic", DTEnums.ActionEnum.Delete.ToString()); //检查权限 int sucCount = 0; int errorCount = 0; BLL.Forum_Topic bll = new BLL.Forum_Topic(); for (int i = 0; i < rptList.Items.Count; i++) { int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value); CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId"); if (cb.Checked) { if (bll.Delete(id)) { sucCount += 1; } else { errorCount += 1; } } } AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除dt_Forum_Topic" + sucCount + "条,失败" + errorCount + "条"); //记录日志 JscriptMsg("删除成功" + sucCount + "条,失败" + errorCount + "条!", Utils.CombUrlTxt("topic_list.aspx", "keywords={0}", this.keywords)); }
private bool DoAdd() { Model.Forum_Topic model = new Model.Forum_Topic(); BLL.Forum_Topic bll = new BLL.Forum_Topic(); //编写添加操作Begin model.BoardId = Convert.ToInt32(ddlBoardId.SelectedValue); //model.TopicTypeId = txtTopicTypeId.Text; model.Title = txtTitle.Text; if (string.IsNullOrEmpty(txtPostDatetime.Text)) { model.PostDatetime = System.DateTime.Now; } else { model.PostDatetime = Convert.ToDateTime(txtPostDatetime.Text); } model.Digest = 0; model.Top = 0; model.Ban = 0; model.Close = 0; if (cblItem.Items[0].Selected) { model.Digest = 1; } if (cblItem.Items[1].Selected) { model.Top = 1; } if (cblItem.Items[2].Selected) { model.Ban = 1; } if (rblClose.SelectedValue == "1") { model.Close = 1; } model.Message = txtMessage.Text; model.PostDatetime = System.DateTime.Now; model.PostUserId = Convert.ToInt32(txtUserId.Text); int _post_id = 0, _subTable_id = 0; //编写添加操作End if (bll.Add(model, out _subTable_id, out _post_id) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加dt_Forum_Topic:" + model.Title); //记录日志 return(true); } return(false); }
//设置操作 protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { ChkAdminLevel("plugin_forum_topic", DTEnums.ActionEnum.Edit.ToString()); //检查权限 int id = Convert.ToInt32(((HiddenField)e.Item.FindControl("hidId")).Value); BLL.Forum_Topic bll = new BLL.Forum_Topic(); Model.Forum_Topic model = bll.GetModel(id); switch (e.CommandName) { case "lbtnIsBan": if (model.Ban == 1) { bll.UpdateField(id, "[Ban]=0"); } else { bll.UpdateField(id, "[Ban]=1"); } break; case "lbtnIsTop": if (model.Top == 1) { bll.UpdateField(id, "[Top]=0"); } else { bll.UpdateField(id, "[Top]=1"); } break; case "lbtnDigest": if (model.Digest == 1) { bll.UpdateField(id, "[Digest]=0"); } else { bll.UpdateField(id, "[Digest]=1"); } break; case "lbtnClose": if (model.Close == 1) { bll.UpdateField(id, "[Close]=0"); } else { bll.UpdateField(id, "[Close]=1"); } break; } this.RptBind(" 1=1 " + CombSqlTxt(keywords), " id desc ");//添加where子句和order子句 }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.Forum_Topic bll = new BLL.Forum_Topic(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("topic_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
/// <summary> /// 删除一条数据,所有标题和回贴都清掉 /// </summary> public bool Delete(int Id) { //循环清除 BLL.Forum_Topic bllTopic = new Forum_Topic(); List <Model.Forum_Topic> listTopic = new BLL.Forum_Topic().GetModelList(" 1=1 "); foreach (Model.Forum_Topic item in listTopic) { bllTopic.Delete(item.Id); } return(dal.Delete(Id)); }
/// <summary> /// 重写虚方法,此方法在Init事件执行 /// </summary> protected override void InitPage() { topic_id = DTRequest.GetQueryInt("topic_id", 0); page = DTRequest.GetQueryInt("page", 1); if (page < 0) { page = 900000; } if (topic_id != 0) { BLL.Forum_Topic bllTopic = new BLL.Forum_Topic(); modelTopic = bllTopic.GetModel(topic_id); if (modelTopic == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("我的天,贴子没啦!"))); return; //modelTopic = new Model.Forum_Topic(); } int _groupId = 0; if (modelUserExtended != null) { _groupId = modelUserExtended.GroupId; } if (!BLL.Forum_BoardPermission.CheckPermission(modelTopic.BoardId + "|" + _groupId, "VisitTopic")) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("不好意思,目前您还没有权限进入!"))); return; } bool bolViewCount = false; //禁止过于频繁的过度刷新 if (HttpContext.Current.Session["SESSION_FORUM_TOPIC"] == null) { HttpContext.Current.Session["SESSION_FORUM_TOPIC"] = topic_id; bolViewCount = true; } else if (Convert.ToInt32(HttpContext.Current.Session["SESSION_FORUM_TOPIC"]) != topic_id) { bolViewCount = true; } if (bolViewCount) { bllTopic.UpdateField(topic_id, "ViewCount=ViewCount+1"); } board_id = modelTopic.BoardId; } modelBoard = new BLL.Forum_Board().GetModel(board_id); if (modelBoard == null) { modelBoard = new Model.Forum_Board(); } drPostList = new BLL.Forum_Post(modelTopic.PostSubTable).GetList(20, page, "", topic_id, "id asc", out totalcount).Tables[0].Select(" 1=1 ", "id asc"); pagelist = OutPageList(20, page, totalcount, linkurl("forum_topic", topic_id, "__id__"), 10); //权限 bolOperate = CheckOperate(board_id); }
private void editor(HttpContext context) { string _v = verify_code(context, vc); if (_v != "success") { JsonHelper.WriteJson(context, new { error = 1, description = _v }); } if (string.IsNullOrEmpty(message)) { JsonHelper.WriteJson(context, new { error = 1, description = "内容不写你打算做什么呢!" }); } if (!BLL.Forum_BoardPermission.CheckPermission(board_id + "|" + modelUser.GroupId, "UpdateMyselfReply")) { JsonHelper.WriteJson(context, new { error = 1, description = "您当前还没有权限哦!" }); } message = FilterWord(message); Model.Forum_Topic modelTopic = new BLL.Forum_Topic().GetModel(topic_id); foreach (string item in context.Request.Form.AllKeys) { if (item.ToLower().IndexOf("attachment_description_") != -1) { string strDescription = context.Request.Form[item].ToString(); string _id = item.ToLower().Replace("attachment_description_", "").Replace("'", ""); new BLL.Forum_Attachment().UpdateField("Id=" + _id, " Description='" + strDescription + "' "); } } //上传图片的张数 int attachment_count = new BLL.Forum_Attachment().GetCount(" [BoardId]=" + board_id + " and [UserId]=" + modelUser.UserId + " and [PostId]=" + post_id + " "); Model.Forum_Post modelPost = new BLL.Forum_Post(modelTopic.PostSubTable).GetModel(post_id); modelPost.Signature = signature; modelPost.Url = autoUrl; modelPost.Message = message; modelPost.Attachment = attachment_count; new BLL.Forum_Post(modelTopic.PostSubTable).Update(modelPost); JsonHelper.WriteJson(context, new { tid = modelTopic.Id, turl = turl }); }
private void reply(HttpContext context) { string _v = verify_code(context, vc); if (_v != "success") { JsonHelper.WriteJson(context, new { error = 1, description = _v }); } if (string.IsNullOrEmpty(message)) { JsonHelper.WriteJson(context, new { error = 1, description = "内容不写你打算做什么呢!" }); } if (!BLL.Forum_BoardPermission.CheckPermission(board_id + "|" + modelUser.GroupId, "PostReply")) { JsonHelper.WriteJson(context, new { error = 1, description = "您当前还没有权限哦!" }); } message = FilterWord(message); Model.Forum_Topic modelTopic = new BLL.Forum_Topic().GetModel(topic_id); int _post_id = new BLL.Forum_PostId().Add(new Model.Forum_PostId { TopicId = topic_id }); int attachment_count = 0; foreach (string item in context.Request.Form.AllKeys) { if (item.ToLower().IndexOf("attachment_description_") != -1) { attachment_count += 1; string strDescription = context.Request.Form[item].ToString().Replace("'", ""); string _id = item.ToLower().Replace("attachment_description_", "").Replace("'", ""); new BLL.Forum_Attachment().UpdateField("Id=" + _id, " [TopicId]=" + modelTopic.Id + ",[PostId]=" + _post_id + " , Description='" + strDescription + "' "); } } //int attachment_count = new BLL.Forum_Attachment().UpdateField(" [BoardId]=" + board_id + " and [UserId]=" + modelUser.UserId + " and [PostId]=0 ", " [TopicId]=" + modelTopic.Id + ",[PostId]=" + _post_id + " "); Model.Forum_Post modelPost = new Model.Forum_Post(); modelPost.BoardId = modelTopic.BoardId; modelPost.Title = modelTopic.Title; modelPost.Signature = signature; modelPost.Url = autoUrl; modelPost.Message = message; modelPost.TopicId = topic_id; modelPost.PostUserId = modelUser.UserId; modelPost.PostUsername = modelUser.UserName; modelPost.PostNickname = modelUser.Nickname; modelPost.PostDateTime = System.DateTime.Now; modelPost.Id = _post_id; modelPost.Attachment = attachment_count; BLL.Forum_Post bll = new BLL.Forum_Post(modelTopic.PostSubTable); //引用 if (post_id != 0) { Model.Forum_Post modelQuotePost = bll.GetModel(post_id); if (modelQuotePost != null) { if (string.IsNullOrEmpty(modelQuotePost.QuotePostIds)) { modelPost.QuotePostIds = modelQuotePost.Id.ToString(); } else { //拼接 modelPost.QuotePostIds = modelQuotePost.QuotePostIds + "," + modelQuotePost.Id.ToString(); } modelPost.QuoteUserId = modelQuotePost.PostUserId; modelPost.QuoteNickname = modelQuotePost.PostNickname; modelPost.QuoteMessage = modelQuotePost.Message; } } bll.Add(modelTopic, modelPost); HttpContext.Current.Session["SESSION_USER_EXTENDED"] = new BLL.Forum_UserExtended().SetGroupId(modelUser); JsonHelper.WriteJson(context, new { tid = modelTopic.Id, turl = new DTcms.Web.UI.BasePage().linkurl("forum_topic", modelTopic.Id, -_post_id) + "#reply_" + _post_id }); }
private bool DoEdit(int _id) { bool result = false; BLL.Forum_Topic bll = new BLL.Forum_Topic(); Model.Forum_Topic model = bll.GetModel(_id); //编写编辑操作Begin model.BoardId = Convert.ToInt32(ddlBoardId.SelectedValue); //model.TopicTypeId = txtTopicTypeId.Text; model.Title = txtTitle.Text; model.PostDatetime = Convert.ToDateTime(txtPostDatetime.Text); model.Digest = 0; model.Top = 0; model.Ban = 0; model.Close = 0; if (cblItem.Items[0].Selected) { model.Digest = 1; } if (cblItem.Items[1].Selected) { model.Top = 1; } if (cblItem.Items[2].Selected) { model.Ban = 1; } if (rblClose.SelectedValue == "1") { model.Close = 1; } model.Message = txtMessage.Text; modelPost = new BLL.Forum_Post(model.PostSubTable).GetModel(" First=1 and TopicId=" + _id + " "); modelPost.Message = txtMessage.Text; //编写编辑操作End model.PostUserId = modelUser.id; model.PostUsername = modelUser.user_name; model.PostNickname = modelUser.nick_name; modelPost.PostUserId = modelUser.id; modelPost.PostUsername = modelUser.user_name; modelPost.PostNickname = modelUser.nick_name; if (bll.Update(model, modelPost)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改管理员:" + model.Title); //记录日志 result = true; } return(result); }