labelmass_method1.cs

最好用的站点内容管理系统 全部源代码都有

                    }
                    if (b_ColbgCss)
                        str_newslist += "</span>";
                }
                else
                {
                    str_isDiv = "false";
                    row = getNavi(str_ShowNavi, str_NaviCSS, str_NaviPic, i) + " ";
                    row += Analyse_ReadNews((int)dt.Rows[i][0], nTitleNum, nContentNum, nNaviNumber, mystyle, styleid, 1, 1, 0);
                    //开始调用副新闻
                    if (subTF)
                    {
                        NetCMS.Model.NewsContent sNCI = new NetCMS.Model.NewsContent();
                        sNCI = this.getNewsInfo((int)dt.Rows[i][0], null);
                        row += getSubSTR(sNCI.NewsID, str_SubNaviCSS);
                    }
                    if (n_Cols == 1)
                    {
                        str_newslist += "<tr>" + newLine + "<td" + str_ColbgCSS + ">" + newLine + row + newLine + "</td>" + newLine + "</tr>" + newLine;
                    }
                    else
                    {
                        row = "<td width=\"" + (100 / n_Cols) + "%\"" + str_ColbgCSS + ">" + newLine + row + newLine + "</td>" + newLine;
                        if (i > 0 && ((i + 1) % n_Cols == 0))
                            row += "</tr>" + newLine + "<tr>" + newLine;
                        str_newslist += row;
                    }
                }
            }
            dt.Clear();
            dt.Dispose();
            //要控制一行显示多少条，可以在前台用CSS控制<li>的属性
            if (str_isDiv == "false")
            {
                if (str_newslist != string.Empty && n_Cols > 1)
                {
                    str_newslist = "<tr>" + newLine + str_newslist;
                    if (i % n_Cols != 0)
                    {
                        int n = n_Cols - i;
                        if (n < 0)
                        {
                            n = n_Cols - (i % n_Cols);
                        }
                        for (int j = 0; j < n; j++)
                        {
                            str_newslist += "<td width=\"" + (100 / n_Cols) + "%\">" + newLine + " </td>" + newLine;
                        }
                    }
                    str_newslist += "</tr>" + newLine;
                }
            }
            str_newslist = News_List_Head(str_isDiv, "", "") + str_newslist + News_List_End(str_isDiv);
            return str_newslist;
        }

        /// <summary>
        /// 取得子类新闻列表
        /// </summary>
        /// <param name="mystyle">样式内容</param>
        /// <param name="styleid">样式编号</param>
        /// <returns>返回子类新闻,说明，前台必须把标签存放于ul容器中</returns>
        protected string getSubNewsList(string mystyle, string styleid, int n_Cols, string str_Desc, string str_DescType, string str_isDiv, string str_ulID, string str_ulClass, string str_isPic, string str_TitleNumer, string str_ContentNumber, string str_NaviNumber, string str_ClickNumber, string str_ShowDateNumer, string str_ShowNavi, string str_NaviCSS, string str_ColbgCSS, string str_NaviPic, string str_SubNews,string str_ClassStyle)
        {
            //NT:LabelType=List,NT:Number=10,NT:NewsType=SubNews
            //此处如果为div则需要修改。后期修改。12.31日,by simplt
            string SqlFields = " [ID] ";
            string SqlCondition = DBConfig.TableNamePrefix + "News Where [isRecyle]=0 And [isLock]=0 And [SiteID]='" + this.Param_SiteID + "'";
            //-------判断是否调用图片
            if (str_isPic == "true")
                SqlCondition += " And [NewsType]=1";
            else if (str_isPic == "false")
                SqlCondition += " And ([NewsType]=0 Or [NewsType]=2)";
            //-------判断是否显示点击率大于多少
            if (str_ClickNumber != null && str_ClickNumber != "")
                SqlCondition += " And [Click] > " + int.Parse(str_ClickNumber);
            //-------判断显示最近多少天内信息
            if (str_ShowDateNumer != null && str_ShowDateNumer != "")
                SqlCondition += " And DateDiff(Day,[CreatTime] ,Getdate()) < " + int.Parse(str_ShowDateNumer);

            string SqlOrderBy = string.Empty;
            //-------排序
            if (str_Desc != null && str_Desc.ToLower() == "asc")
                SqlOrderBy += " asc";
            else
                SqlOrderBy += " Desc";
            switch (str_DescType)
            {
                case "id":
                    SqlOrderBy = " Order By id " + SqlOrderBy + "";
                    break;
                case "date":
                    SqlOrderBy = " Order By [CreatTime] " + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                case "click":
                    SqlOrderBy = " Order By [Click] " + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                case "pop":
                    SqlOrderBy = " Order By [OrderID]" + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                case "digg":
                    SqlOrderBy = " Order By [TopNum]" + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                default:
                    SqlOrderBy = " Order By [CreatTime] " + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
            }

            int nTitleNum = 30, nContentNum = 200, nNaviNumber = 200;
            if (str_TitleNumer != null && NetCMS.Common.Input.IsInteger(str_TitleNumer))
            {
                nTitleNum = int.Parse(str_TitleNumer);
            }
            if (str_ContentNumber != null && NetCMS.Common.Input.IsInteger(str_ContentNumber))
            {
                nContentNum = int.Parse(str_ContentNumber);
            }
            if (str_NaviNumber != null && NetCMS.Common.Input.IsInteger(str_NaviNumber))
            {
                nNaviNumber = int.Parse(str_NaviNumber);
            }

            string str_SubNaviCSS = string.Empty;
            bool subTF = false;
            if (str_SubNews != null)
            {
                if (str_SubNews == "true")
                {
                    subTF = true;
                    if (this.GetParamValue("NT:SubNaviCSS") != null)
                    {
                        str_SubNaviCSS = this.GetParamValue("NT:SubNaviCSS");
                    }
                }
            }
            string [] arr_ColbgCSS = null;
            bool b_ColbgCss = false;
            if (str_ColbgCSS != null)
            {
                arr_ColbgCSS = str_ColbgCSS.Split('|');
                b_ColbgCss = true;
            }
            string row = "";
            string Sql = "Select [ClassID],[ClassCName],[SavePath],[SaveClassframe],[ClassSaveRule],[isDelPoint] From [" + DBConfig.TableNamePrefix + "news_Class] Where [ParentID]='" + this.Param_CurrentClassID + "' And [isRecyle]=0 And [isLock]=0 And [IsURL]=0 order by orderID desc";
            DataTable dt = CommonData.DalPublish.ExecuteSql(Sql);
            if (dt == null || dt.Rows.Count == 0) return "";
            string str_classlist = "";
            int j;

            //栏目名称样式
            string str_tempClassStyle = "";
            if (str_ClassStyle != null)
            {
                str_tempClassStyle = " class=\"" + str_ClassStyle + "\"";
            }
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string str_newslist = "";
                string TMSTR = string.Empty;
                string classrow = "<a href=\"" + getClassURL(Convert.ToInt32(dt.Rows[i]["isDelPoint"].ToString()),
                                    dt.Rows[i]["ClassID"].ToString(), dt.Rows[i]["SavePath"].ToString(),
                                    dt.Rows[i]["SaveClassframe"].ToString(), dt.Rows[i]["ClassSaveRule"].ToString()) + "\" target=\"_blank\">" +
                                    dt.Rows[i]["ClassCName"].ToString() + "</a>";
                str_classlist += "<li>" + newLine;
                str_classlist += "<div " + str_tempClassStyle + " style=\"clear:both;\">" + newLine;
                str_classlist += classrow;
                str_classlist += "</div>" + newLine;
                string s_newsSql = "select top " + Param_Loop + " " + SqlFields + " from" +
                                   " " + SqlCondition + " And [ClassID]='" + dt.Rows[i]["ClassID"].ToString() + "'" + SqlOrderBy;
                DataTable dv = CommonData.DalPublish.ExecuteSql(s_newsSql);
                if (dv != null)
                {
                    for (j = 0; j < dv.Rows.Count; j++)
                    {
                        str_ColbgCSS = "";
                        if (b_ColbgCss)
                        {
                            if (j % 2 == 0)
                            {
                                str_ColbgCSS = " class=\"" + arr_ColbgCSS[0].ToString() + "\"";
                            }
                            else
                            {
                                str_ColbgCSS = " class=\"" + arr_ColbgCSS[1].ToString() + "\"";
                            }
                        }
                        if (b_ColbgCss)
                        {
                            str_newslist += "<span" + str_ColbgCSS + ">";
                        }
                        str_newslist += Analyse_ReadNews((int)dv.Rows[j][0], nTitleNum, nContentNum, nNaviNumber, mystyle, styleid, 1, 1, 0);
                        //开始调用副新闻
                        if (subTF)
                        {
                            NetCMS.Model.NewsContent sNCI = new NetCMS.Model.NewsContent();
                            sNCI = this.getNewsInfo((int)dv.Rows[j][0], null);
                            str_newslist += getSubSTR(sNCI.NewsID, str_SubNaviCSS);
                        }
                        if (b_ColbgCss)
                        {
                            str_newslist += "</span>";
                        }
                    }
                    dv.Clear();
                    dv.Dispose();
                    TMSTR += "<div style=\"clear:both;\">" + newLine;
                    TMSTR += "<ul>" + newLine;
                    TMSTR += str_newslist;
                    TMSTR += "</ul>" + newLine;
                    TMSTR += "</div>" + newLine;
                }
                str_classlist += TMSTR + "</li>" + newLine;
            }
            dt.Clear(); dt.Dispose();
            return str_classlist;
        }


        /// <summary>
        /// Get NewsList Table Or Div
        /// </summary>
        /// <param name="isDiv">是否输出DIV</param>
        /// <param name="ulID">DIV的ul属性ID</param>
        /// <param name="ulClass">DIV的ul属性Class</param>
        /// <returns>返回头部</returns>
        protected string News_List_Head(string isDiv, string ulID, string ulClass)
        {
            string str_Head = string.Empty;
            if (isDiv != "true")
            {
                str_Head += "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">" + newLine;
            }
            else
            {   //此项已屏蔽，无须定义ul的属性，在前台模板中控制。这样的好处可以得到纯w3c格式的div+css
                //if (ulID != null && ulClass != null)
                //    str_Head += "<ul id=\"" + ulID + "\" class=\"" + ulClass + "\">" + newLine;
                //else if (ulID != null && ulClass == null)
                //    str_Head += "<ul id=\"" + ulID + "\">" + newLine;
                //else if (ulID == null && ulClass != null)
                //    str_Head += "<ul class=\"" + ulClass + "\">" + newLine;
                //else
                str_Head += newLine;
            }
            return str_Head;
        }

        /// <summary>
        /// Get NewsList Table Or Div
        /// </summary>
        /// <param name="isDiv">是否输出DIV</param>
        /// <returns>返回尾部</returns>
        protected string News_List_End(string isDiv)
        {
            if (isDiv == "true")
                return newLine;
            else
                return "</table>" + newLine;
        }
        /// <summary>
        /// 获取标题前导航
        /// </summary>
        /// <param name="ShowNavi">是否显示导航</param>
        /// <param name="NaviPic">导航图片地址</param>
        /// <param name="i">当前循环的记录数</param>
        /// <returns>返回导航</returns>
        protected string getNavi(string ShowNavi,string NaviCSS, string NaviPic, int i)
        {
            string strNavi = string.Empty;
            string strNaviCSS = string.Empty;
            string strNaviCSS_1 = string.Empty;
            if (NaviCSS != null && NaviCSS != "")
            {
                //如果navicss为空，可以在前台CSS中控制<dd>的属性,by simplt
                strNaviCSS = "<dd class=\"" + NaviCSS + "\">";
                strNaviCSS_1 = "</dd>";
            }
            switch (ShowNavi)
            {
                case "1":
                    i++;
                    strNavi = strNaviCSS + i.ToString() + strNaviCSS_1;
                    break;
                case "2":
                    if (i <= 26)
                        strNavi = strNaviCSS + ((char)(i + 65)).ToString() + strNaviCSS_1;
                    break;
                case "3":
                    if (i <= 26)
                        strNavi = strNaviCSS + ((char)(i + 97)).ToString() + strNaviCSS_1;
                    break;
                case "4":
                    strNavi = "<img border=\"0\" src=\"" + RelpacePicPath(NaviPic) + "\" />";
                    break;
                default:
                    break;
            }
            return strNavi+" ";
        }
    }
}