App_Code/DAO/Bs_NewsDao.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Bs_NewsDao 的摘要说明
/// </summary>
public class Bs_NewsDao
{

    /// <summary>
    /// 获取新闻列表
    /// </summary>
    /// <param name="code">类别编码</param>
    /// <param name="size">获取数,0获取全部</param>
    /// <returns></returns>
    public DataTable getNewsInCode(string code, int size)
    {
        string strSql = "";
        string strTop = "";
        if (size > 0)
        {
            strTop = " top " + size + " ";
        }

        strSql = string.Format("select {1} * from Bs_News where Bs_NewsKindCode like '{0}%' order by sortno  ", code, strTop);

        return CSA.DAL.DBAccess.getRS(strSql);


    }


    /// <summary>
    /// 获取新闻列表
    /// </summary>
    /// <param name="code">类别编码</param>
    /// <param name="pageIndex">当前页数</param>
    /// <param name="pageSize">显示行数</param>
    /// <param name="SortExpression">排序</param>
    /// <param name="recordCound">结果总数</param>
    /// <returns></returns>
    public DataTable getNewsInCode(string code, int pageIndex, int pageSize, string SortExpression, out int recordCound)
    {   string strSql = string.Format("select  * from Bs_News where Bs_NewsKindCode like '{0}%' order by sortno ", code);
        DataTable dtResult = CSA.DAL.DBAccess.getRS(strSql);
        recordCound = dtResult.Rows.Count;
        return CSA.DAL.PageHelper.getPage(dtResult, pageSize, pageIndex);
    }




    /// <summary>
    /// 获取文章实体