private readonly DTcms.Model.siteconfig siteConfig = new DTcms.BLL.siteconfig().loadConfig(); //获得站点配置信息 /// <summary> /// 获取主题列表 /// </summary> /// <returns></returns> public DataTable get_topic_list(int top, string strwhere, string orderby) { DataTable dt = new DataTable(); if (!string.IsNullOrEmpty(strwhere)) { strwhere += " and "; } strwhere += " BoardId in (SELECT [Id] FROM [" + siteConfig.sysdatabaseprefix + "Forum_Board] where Show=1)"; dt = new BLL.Forum_Topic().GetList(top, strwhere, orderby).Tables[0]; return(dt); }
/// <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)); }
public static void BoardTodayTopicCount(bool bol = false) { //没有统计过 if (HttpContext.Current.Application["BoardTodayTopicTime"] == null) { bol = true; HttpContext.Current.Application["BoardTodayTopicTime"] = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01")); } DateTime dtTime = Convert.ToDateTime(HttpContext.Current.Application["BoardTodayTopicTime"]); TimeSpan ts = System.DateTime.Now - dtTime; //时间已经超过了24小时 if (ts.TotalSeconds > 86400.0) { bol = true; } if (bol) { BLL.Forum_Board bll = new BLL.Forum_Board(); bll.UpdateField(" 1=1 ", "TodayTopicCount=0"); List <Model.Forum_Board> list = bll.GetModelList(" 1=1 "); //所有版块重新统计 foreach (Model.Forum_Board modelBoard in list) { int _total = new BLL.Forum_Topic().GetTotal(" BoardId=" + modelBoard.Id + " and PostDatetime>'" + System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01") + "' "); string strValue = "[TodayTopicCount]=[TodayTopicCount]+" + _total + ""; bll.UpdateField(" Id in (0" + modelBoard.ClassList + "0) ", strValue); } HttpContext.Current.Application["BoardTodayTopicTime"] = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd 00:00:01")); } }
/// <summary> /// 删除一条数据,相关会员贴子和记录都清掉,掉用和前端一样的方法 /// </summary> public bool Delete(int UserId) { BLL.Forum_MyTopic bllMyTopic = new Forum_MyTopic(); BLL.Forum_MyPost bllMyPost = new Forum_MyPost(); BLL.Forum_Topic bllTopic = new Forum_Topic(); //清我的贴子 List <Model.Forum_MyTopic> listMyTopic = bllMyTopic.GetModelList("UserId=" + UserId); foreach (Model.Forum_MyTopic item in listMyTopic) { bllTopic.Delete(item.TopicId); } //清我的回贴记录 bllMyPost.Delete("UserId=" + UserId); return(dal.Delete(UserId)); }