DAL/AgencyNewsInfoAccess.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Model;

namespace DAL
{
    public class AgencyNewsInfoAccess
    {
        DBbase db = new DBbase();
        SysLogAccess sysLogAccess = new SysLogAccess();
        SysLog sysLogModel = new SysLog();
        public AgencyNewsInfoAccess()
        { }

        /// <summary>
        /// 分页查询资讯信息
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageCount"></param>
        /// <returns></returns>
        public DataTable GetAllNewsInfo(int PageIndex, int PageSize, out int PageCount, out int RecordCount, string strWhere)
        {
            try
            {

                string strSql = " SELECT P.newsId,P.newsClassID,P.newsTitle,P.dateTime,P.isChecked,P.writer,C.id,C.newsClassName,C.newsClassKey,C.newsClassDes FROM tb_AgencyNews P  " +
                                " LEFT JOIN tb_AgencyClass C ON P.newsClassID=C.id ";
                string strShow = " newsId,newsTitle,newsClassName,dateTime,isChecked,writer,newsClassKey,newsClassDes ";
                return AccessHelper.ExecutePager(PageIndex, PageSize, "newsId", strShow, strSql, strWhere, " newsId DESC ", out PageCount, out RecordCount);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据分类ID，分页查询资讯信息
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageCount"></param>
        /// <returns></returns>
        public DataTable GetNewsListByClD(int PageIndex, int PageSize, out int PageCount, out int RecordCount, string strWhere, int classId)
        {
            try
            {

                string strSql = "select * from tb_AgencyNews where isChecked='1' and newsClassID='" + classId + "'";
                string strShow = " newsId,newsTitle,dateTime,isChecked,writer ";
                return AccessHelper.ExecutePager(PageIndex, PageSize, "newsId", strShow, strSql, strWhere, " newsId DESC ", out PageCount, out RecordCount);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }