918博天堂

Server : Microsoft-IIS/10.0
System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586
User : jxgj ( 0)
PHP Version : 7.0.33
Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server
Directory : D:/tmp_aspnet/root/5f1e4137/8eca010b/
Upload File :
Current File : D:/tmp_aspnet/root/5f1e4137/8eca010b/App_Code.-mty-7id.8.cs
?#pragma checksum "D:\wwwroot\njjbjycom\wwwroot\App_Code\SingleColumn.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "8BC7A9A9C2280207588E4CA981F4B7E61341250B"

#line 1 "D:\wwwroot\njjbjycom\wwwroot\App_Code\SingleColumn.cs"
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Text;
using System.Data;

/// <summary>
///SingleColumn 的提要注明
/// </summary>
public class SingleColumn
{
	public SingleColumn()
	{
		//
		//TODO: 在此处增长机关函数逻辑
		//
	}

    /// <summary>
    /// 获取栏目列表默认第一个栏目
    /// </summary>
    /// <param name="columnid"></param>
    /// <returns></returns>
    public static int GetDefaultColumn(int columnid)
    {
        int defaultId = 0;
        DataTable dtColumns = BusinessLogic.ReturnDt("select top 1 ID,ClassId,Title,Sort from system_Contents where ClassId=" + columnid + " order by Sort asc,ID desc");
        if (dtColumns.Rows.Count > 0)
        {
            defaultId = Convert.ToInt32(dtColumns.Rows[0]["ID"]);
        }
        return defaultId;
    }

    /// <summary>
    /// 获取单页栏目列表
    /// </summary>
    /// <param name="columnid"></param>
    /// <returns></returns>
    public static StringBuilder GetColumnList(string columnUrl, int columnid)
    {
        StringBuilder ColumnList = new StringBuilder();
        DataTable dtColumns = BusinessLogic.ReturnDt("select ID,ClassId,Title,Sort from system_Contents where ClassId=" + columnid + " order by Sort asc,ID desc");
        if (dtColumns.Rows.Count > 0)
        {
            for (int m = 0; m < dtColumns.Rows.Count; m++)
            {
                ColumnList.Append("<li>");
                ColumnList.Append("<a href=\"" + columnUrl + ".aspx?Id=" + Convert.ToString(dtColumns.Rows[m]["ID"]) + "\">" + Convert.ToString(dtColumns.Rows[m]["Title"]) + "</a>");
                ColumnList.Append("</li>");
            }
        }
        return ColumnList;
    }

    /// <summary>
    /// 获取单页栏目列表
    /// </summary>
    /// <param name="columnid"></param>
    /// <returns></returns>
    public static StringBuilder GetColumnList1(string webUrl, string columnUrl, int columnid)
    {
        StringBuilder ColumnList = new StringBuilder();
        DataTable dtColumns = BusinessLogic.ReturnDt("select ID,ClassId,Title,Sort from system_Contents where ClassId=" + columnid + " order by Sort asc,ID desc");
        if (dtColumns.Rows.Count > 0)
        {
            for (int m = 0; m < dtColumns.Rows.Count; m++)
            {
                ColumnList.Append("<a href=\"" + webUrl + columnUrl + ".aspx?Id=" + Convert.ToString(dtColumns.Rows[m]["ID"]) + "\">" + Convert.ToString(dtColumns.Rows[m]["Title"]) + "</a>");
            }
        }
        return ColumnList;
    }
    public static StringBuilder GetColumnList(string webUrl, string columnUrl, int columnid)
    {
        StringBuilder ColumnList = new StringBuilder();
        DataTable dtColumns = BusinessLogic.ReturnDt("select ID,ClassId,Title,Sort from system_Contents where ClassId=" + columnid + " order by Sort asc,ID desc");
        if (dtColumns.Rows.Count > 0)
        {
            for (int m = 0; m < dtColumns.Rows.Count; m++)
            {
                ColumnList.Append("<li>");
                ColumnList.Append("<a href=\"" + webUrl + columnUrl + ".aspx?Id=" + Convert.ToString(dtColumns.Rows[m]["ID"]) + "\">" + Convert.ToString(dtColumns.Rows[m]["Title"]) + "</a>");
                ColumnList.Append("</li>");
            }
        }
        return ColumnList;
    }
    public static StringBuilder GetServiceList(string webUrl, string columnUrl, int columnid)
    {
        StringBuilder ColumnList = new StringBuilder();
        DataTable dtColumns = BusinessLogic.ReturnDt("select ID,ClassId,Title,Sort from system_Services where ClassId=" + columnid + " order by Sort asc,ID desc");
        if (dtColumns.Rows.Count > 0)
        {
            for (int m = 0; m < dtColumns.Rows.Count; m++)
            {
                ColumnList.Append("<dt>");
                ColumnList.Append("<a href=\"" + webUrl + columnUrl + "/" + Convert.ToString(dtColumns.Rows[m]["ID"]) + ".aspx\">" + Convert.ToString(dtColumns.Rows[m]["Title"]) + "</a>");
                ColumnList.Append("</dt>");
            }
        }
        return ColumnList;
    }




    /// <summary>
    /// 获取单页栏目列表
    /// </summary>
    /// <param name="columnid"></param>
    /// <returns></returns>
    public static StringBuilder GetColumnList(string columnUrl, int columnid, int id)
    {
        StringBuilder ColumnList = new StringBuilder();
        DataTable dtColumns = BusinessLogic.ReturnDt("select ID,ClassId,Title,Sort from system_Contents where ClassId=" + columnid + " order by Sort asc,ID desc");
        if (dtColumns.Rows.Count > 0)
        {
            for (int m = 0; m < dtColumns.Rows.Count; m++)
            {
                ColumnList.Append("<li>");
                if(id == Convert.ToInt32(dtColumns.Rows[m]["ID"]))
                {
                    ColumnList.Append("<a href=\"" + columnUrl + "?Id=" + Convert.ToString(dtColumns.Rows[m]["ID"]) + "\" class=\"ahover\">" + Convert.ToString(dtColumns.Rows[m]["Title"]) + "</a>");
                }
                else
                {
                    ColumnList.Append("<a href=\"" + columnUrl + "?Id=" + Convert.ToString(dtColumns.Rows[m]["ID"]) + "\">" + Convert.ToString(dtColumns.Rows[m]["Title"]) + "</a>");
                }
                ColumnList.Append("</li>");
            }
        }
        return ColumnList;
    }
}


#line default
#line hidden