Core/SM/Dal/LogDal.cs

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using Core.SM.Model;
using Common;
using Common.Data;
using Common.Data.Filter;
using Common.Provider;

namespace Core.SM.Dal
{
    public class LogDal : BaseRepository<Log>
    {
        public static LogDal Instance
        {
            get { return SingletonProvider<LogDal>.Instance; }
        }

        public string JsonDataForEasyUIdataGrid(int pageindex, int pagesize, string filterJSON)
        {
            var pcp = new ProcSmPage("SM_USER_LOG")
            {
                PageIndex = pageindex,
                PageSize = pagesize,
                OrderFields = "KeyId desc",
             
                WhereString = FilterTranslator.ToSql(filterJSON)
            };
            int recordCount;
            DataTable dt = base.GetPageWithSp(pcp, out recordCount);
            return JSONhelper.FormatJSONForEasyuiDataGrid(recordCount, dt);

        }

         public IEnumerable<Log> GetList(int days)
        {
            string sql = "select * from SM_USER_LOG where datediff(d,OperationDate,getdate()) > " + days;
            return DbUtils.ExecuteReader<Log>(sql, null);
        }

        /// <summary>
        /// 清除所有操作日志
        /// </summary>
        public void RemoveAll()
        {
            string sql = "truncate table SM_USER_LOG";
            DbUtils.ExecuteNonQuery(sql, null);
        }
    }
}