labelmass_method5.cs

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

            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="ChID">频道ID</param>
        /// <returns>返回值</returns>
        public string Analyse_ChannelClassList(int ChID)
        {
            //判断数据库是否存在
            string ChTable = CommonData.DalPublish.GetCHDatable(ChID);
            if (ChTable == "#")
            {
                return "频道数据库找不到";
            }
            string mystyle = this.Mass_Inserted;
            string styleid = Regex.Match(mystyle, @"\[\#NT:StyleID=(?<sid>[^\]]+)]", RegexOptions.Compiled).Groups["sid"].Value.Trim();
            if (!styleid.Equals(string.Empty))
            {
                mystyle = LabelStyle.GetCHStyleByID(int.Parse(styleid), ChID);
            }
            if (mystyle.Trim().Equals(string.Empty))
                return string.Empty;
            string str_NewsType = this.GetParamValue("NT:Type");
            int n_Cols;
            if (!int.TryParse(this.GetParamValue("NT:Cols"), out n_Cols))
                n_Cols = 1;
            if (n_Cols < 1)
                n_Cols = 1;
            string str_Desc = this.GetParamValue("NT:Desc");
            string str_DescType = this.GetParamValue("NT:OrderBy");
            if (str_DescType == null)
            {
                str_DescType = "id";
            }
            string str_isDiv = this.GetParamValue("NT:isDiv");
            if (str_isDiv == null)
            {
                str_isDiv = "true";
            }
            string str_bfStr = this.GetParamValue("NT:bfStr");
            string str_isPic = this.GetParamValue("NT:isPic");
            string str_TitleNumer = this.GetParamValue("NT:TitleNumer");
            string str_ShowNavi = this.GetParamValue("NT:ShowNavi");
            string str_NaviCSS = this.GetParamValue("NT:NaviCSS");
            string str_ColbgCSS = this.GetParamValue("NT:ColbgCSS");
            string str_PageStyle = this.GetParamValue("NT:PageStyle");
            int PageTF = 0;
            int PageLineNum = 100;
            string PageLineContent = "";
            string PageLineContent1 = "";
            if (str_bfStr != string.Empty && str_bfStr != null)
            {
                if (str_bfStr.IndexOf("|") > -1)
                {
                    string[] BFARR = str_bfStr.Split('|');
                    PageTF = int.Parse(BFARR[0].ToString());
                    PageLineNum = int.Parse(BFARR[1].ToString());
                    PageLineContent = BFARR[2].ToString();
                    switch (PageTF)
                    {
                        case 0:
                            PageLineContent1 = "<span class=\"" + PageLineContent + "\" style=\"width:100%\"></span>";
                            break;
                        case 1:
                            PageLineContent1 = "<img src=\"" + PageLineContent + "\" border=\"0\" />";
                            break;
                        case 2:
                            PageLineContent1 = PageLineContent;
                            break;
                    }
                }
            }
            string getWhere = "";
            if (str_NewsType == "info")
            {
                getWhere += " and ClassID=" + this.Param_CurrentCHClassID + "";
            }
            else
            {
                getWhere += " And SpecialID='" + this.Param_CurrentCHSpecialID + "'";
            }

            string SqlFields = " [id] ";
            string SqlCondition = ChTable + " Where [isLock]=0 " + getWhere + "";
            //-------判断是否调用图片
            if (str_isPic == "true")
            {
                SqlCondition += " And [PicURL]<>''";
            }
            else if (str_isPic == "false")
            {
                SqlCondition += " And [PicURL]='' ";
            }

            string getPageTF = "{$NT:P0}{Page:0$$}";
            int PerPageNum = 30;
            string PageStyle = "0";
            string PageTitleColor = "";
            string PageCSS = "";
            if (str_PageStyle != string.Empty && str_PageStyle != null)
            {
                string[] PageARR = str_PageStyle.Split('$');
                PageStyle = PageARR[0].ToString();
                PerPageNum = int.Parse(PageARR[2].ToString());
                PageTitleColor = PageARR[1].ToString();
                PageCSS = PageARR[3].ToString();
            }
            getPageTF = "{$NT:P0}{Page:" + PageStyle + "$" + PageTitleColor + "$" + PageCSS + "}";
            #region 排序
            string SqlOrderBy = string.Empty;
            //-------排序
            if (str_Desc != null && str_Desc.ToLower() == "asc")
            {
                SqlOrderBy += " asc";
            }
            else
            {
                SqlOrderBy += " Desc";
            }
            switch (str_DescType.ToLower())
            {
                case "id":
                    SqlOrderBy = " Order By id " + SqlOrderBy + "";
                    break;
                case "creattime":
                    SqlOrderBy = " Order By [CreatTime] " + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                case "click":
                    SqlOrderBy = " Order By [Click] " + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                case "orderid":
                    SqlOrderBy = " Order By [OrderID]" + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
                default:
                    SqlOrderBy = " Order By [CreatTime]" + SqlOrderBy + ",id " + SqlOrderBy + "";
                    break;
            }
            #endregion 排序
            string Sql = "select " + SqlFields + " from " + SqlCondition + SqlOrderBy;
            DataTable dt = CommonData.DalPublish.ExecuteSql(Sql);
            if (dt == null || dt.Rows.Count < 1) return string.Empty;
            string str_newslist = string.Empty;
            int i;
            int nTitleNum = 30;
            if (str_TitleNumer != null && NetCMS.Common.Input.IsInteger(str_TitleNumer))
            {
                nTitleNum = int.Parse(str_TitleNumer);
            }
            int dtcount = dt.Rows.Count;
            str_newslist = "{NT:NewsLIST}" + News_List_Head(str_isDiv, "", "");
            string tmpPageLineContent1 = "";
            if (str_isDiv != "true")
            {
                str_newslist += News_List_Head(str_isDiv, "", "");
                if (n_Cols != 1)
                {
                    str_newslist += "<tr>";
                }
            }
            for (i = 0; i < dtcount; i++)
            {
                if ((i + 1) % PageLineNum == 0)
                {
                    tmpPageLineContent1 = PageLineContent1;
                }
                else
                {
                    tmpPageLineContent1 = "";
                }
                if (str_isDiv == "false")
                {
                    string row = getNavi(str_ShowNavi, str_NaviCSS, "", i);
                    row += Analyse_ChRead((int)dt.Rows[i][0], nTitleNum, mystyle, styleid, 0, ChTable, ChID);
                    if (n_Cols == 1)
                    {
                        row += tmpPageLineContent1;
                    }
                    if (n_Cols == 1)
                    {
                        str_newslist += "<tr>" + newLine + "<td>" + newLine + row + newLine + "</td>" + newLine + "</tr>" + newLine;
                    }
                    else
                    {
                        row = "<td width=\"" + (100 / n_Cols) + "%\">" + newLine + row + newLine + "</td>" + newLine;
                        if (((i + 1) % n_Cols == 0))
                        {
                            if ((i + 1) < dtcount)
                            {
                                row += "</tr>" + newLine + "<tr>" + newLine;
                            }
                        }
                        str_newslist += row;
                    }
                }
                else
                {
                    str_isDiv = "true";
                    str_newslist += getNavi(str_ShowNavi, str_NaviCSS, "", i);
                    str_newslist += Analyse_ChRead((int)dt.Rows[i][0], nTitleNum, mystyle, styleid, 0, ChTable, ChID) + tmpPageLineContent1;
                }

                if ((i + 1) % (PerPageNum) == 0)
                {
                    if ((i + 1) < dtcount)
                    {
                        str_newslist += News_List_End(str_isDiv) + getPageTF + News_List_Head(str_isDiv, "", "");
                    }
                }
                if (str_isDiv == "false")
                {
                    if ((i + 1) == dtcount)
                    {
                        if (n_Cols != 1)
                        {
                            str_newslist += "</tr>" + newLine;
                        }
                        str_newslist += News_List_End(str_isDiv) + newLine;
                    }
                }
            }
            dt.Clear(); dt.Dispose();
            return str_newslist + "{/NT:NewsLIST}";
        }

        /// <summary>
        /// 生成浏览类信息，频道
        /// </summary>
        /// <param name="ChID">频道ID</param>