/// <summary> /// 获得指定栏目内容页数 /// </summary> /// <param name="_channelid">频道ID</param> /// <param name="_classid">栏目ID</param> /// <param name="_includechild">是否包含子类内容</param> /// <returns></returns> public int GetContetPageCount(string _channelid, string _classid, bool _includechild) { using (DbOperHandler _doh = new Common().Doh()) { string _channeltype = new Normal_ChannelDAL().GetChannelType(_channelid); if (_channeltype.Length == 0) { return(0); } _doh.Reset(); _doh.SqlCmd = "SELECT [PageSize],[Code] FROM [jcms_normal_class] WHERE [ChannelId]=" + _channelid + " AND [Id]=" + _classid; int _pagesize = SiteGroupCms.Utils.Validator.StrToInt(_doh.GetDataTable().Rows[0]["PageSize"].ToString(), 0); string _classcode = _doh.GetDataTable().Rows[0]["Code"].ToString(); if (_pagesize == 0) { _pagesize = 20; } string _pstr = string.Empty; if (!_includechild) { _pstr = " [ClassID]=" + _classid + " AND [IsPass]=1 AND [ChannelId]=" + _channelid; } else { _pstr = " [ClassID] in (Select id FROM [jcms_normal_class] WHERE [Code] LIKE '" + _classcode + "%') AND [IsPass]=1 AND [ChannelId]=" + _channelid; } _doh.Reset(); _doh.ConditionExpress = _pstr; int _totalcount = _doh.Count("jcms_module_" + _channeltype); return(SiteGroupCms.Utils.Int.PageCount(_totalcount, _pagesize)); } }
/// <summary> /// 得到内容页地址 /// </summary> /// <param name="_contentid"></param> /// <param name="_truefile"></param> /// <returns></returns> public string GetContentLink(string _contentid) { SiteGroupCms.Dal.Normal_ChannelDAL _ChannelDal = new Normal_ChannelDAL(); SiteGroupCms.Dal.ArticleDal articledal = new ArticleDal(); SiteGroupCms.Entity.Article article = articledal.GetEntity(_contentid); if (article.Yyarticleid.ToString() != "" && article.Yyarticleid != 0)//如果引用文章 { _contentid = article.Yyarticleid.ToString(); } article = articledal.GetEntity(_contentid); //重新取引用的文章 if (article.Linkurl != "" && article.Linkurl != null) //如果是连接文章 // return article.Linkurl; //这个直接得到连接地址 { return("/ajaxhandler/Gethits.aspx?articleid=" + article.Id); //得到可以统计点击次数的连接地址 } SiteGroupCms.Entity.Normal_Channel _Channel = _ChannelDal.GetEntity(article.Catalogid.ToString()); site = (SiteGroupCms.Entity.Site)HttpContext.Current.Session["site"]; string qianstr = "/sites/" + site.Location + "/pub"; string centerstr = ""; //检查对应的文件夹是否存在,若不存在则创建,若存在则以id为标题生成 while (_Channel.Father != 0)//不为跟节点就继续往上走 { centerstr = "/" + _Channel.Dirname + centerstr; _Channel = _ChannelDal.GetEntity(_Channel.Father.ToString()); } centerstr = "/" + _Channel.Dirname + centerstr + "/"; string title = article.Addtime.Year.ToString() + article.Addtime.Month.ToString() + article.Addtime.Day.ToString() + _contentid; return(qianstr + centerstr + title + ".html"); }