LK.WXAD.Dals/ArticleInfo.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;
namespace LK.WXAD.Dals
{
	/// <summary>
	/// 数据访问类:ArticleInfo
	/// </summary>
	public partial class ArticleInfo
	{
        public string sqlConnectionString = LK.WXAD.SqlConn.SqlConn.SqlConnectionString();

        public ArticleInfo()
		{}
		#region  BasicMethod

		/// <summary>
		/// 得到最大ID
		/// </summary>
		public int GetMaxId()
		{
		return new GetMaxID().GetID("ArticleID", "LK_ArticleInfo"); 
		}


        /// <summary>
        /// 文章列表
        /// </summary>
        /// <param name="strWhere"></param>
        /// <param name="pageSize"></param>
        /// <param name="pageIndex"></param>
        /// <param name="counts"></param>
        /// <param name="pageCounts"></param>
        /// <returns></returns>
        public DataTable GetList(string strWhere, int pageSize, int pageIndex, out int counts, out int pageCounts)
        {
            return LK.WXAD.Commons.PageView.GetPageView("V_LK_ArticleInfo", "*", pageSize, pageIndex, "ArticleID", true, strWhere, "ArticleID", out counts, out pageCounts).Tables[0];
        }



        public DataTable GetListByAjax(string strWhere, int pageSize, int pageIndex, out int counts, out int pageCounts,int type)
        {
            if (type == 0)
            {
                return LK.WXAD.Commons.PageView.GetPageView("V_LK_ArticleInfo", "ArticleTitle,ArticlePic,ArticleMemo,ArticleAddDate,ArticleHitNum,ArticleGiveNum,ArticleGUID", pageSize, pageIndex, "ArticleID", true, strWhere, "ArticleID", out counts, out pageCounts).Tables[0];
            }
            else {//按热度
                return LK.WXAD.Commons.PageView.GetPageView("V_LK_ArticleInfo", "ArticleTitle,ArticlePic,ArticleMemo,ArticleAddDate,ArticleHitNum,ArticleGiveNum,ArticleGUID", pageSize, pageIndex, "ArticleHitNum", true, strWhere, "ArticleID", out counts, out pageCounts).Tables[0];
            }
        }

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(int ArticleID)
		{