Master.CanYinWu.DAL/IISLogRecordDAL.cs

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

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

using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Master.CanYinWu.Entity.ViewModel;
using Master.CanYinWu.Utility;

namespace Master.CanYinWu.DAL
{
    public class IISLogRecordDAL
    {
        private IDbConnection conn;

        #region 404状态码网址列表
        /// <summary>
        /// 404状态码网址列表
        /// </summary>    
        public async Task<Tuple<IEnumerable<IISLogRecordViewModel>, int>> Get404UrlList(int pageIndex, int pageSize, string whereType = "yesterday", string startTime =null, string endTime =null)
        {
            string sql = $@" SELECT i_date
						        ,cs_uri_stem
						        ,ROW_NUMBER() OVER(ORDER BY CONVERT(DATETIME ,i_date+' '+i_time) DESC) AS 
						         rownumber
						  FROM   IISLogRecord i
						  WHERE  sc_status = '404'
						        {SqlDateTimeStr(whereType, startTime, endTime)}";

            StringBuilder sb = new StringBuilder(@"select * from(" + sql + " ");
            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", pageIndex);
            dp.Add("PageSize", pageSize);
            StringBuilder sqlTotal = new StringBuilder(@"select count(1) from (" + sql + ")as a ");
            DynamicParameters dpTotal = new DynamicParameters();
            sb.Append(" )as a where rownumber BETWEEN(((@PageIndex - 1) * @PageSize) + 1) and @PageIndex * @PageSize ");
            using (conn = ConnectionFactory.Connection())
            {
                var query = await conn.QueryAsync<IISLogRecordViewModel>(sb.ToString(), dp);
                var total = await conn.ExecuteScalarAsync<int>(sqlTotal.ToString(), dpTotal);
                return new Tuple<IEnumerable<IISLogRecordViewModel>, int>(query, total);
            }
        }
        /// <summary>
        /// mip站点404列表
        /// </summary>       
        public async Task<Tuple<IEnumerable<IISLogRecordViewModel>, int>> Get404MipUrlList(int pageIndex, int pageSize, string whereType = "yesterday", string startTime = null, string endTime = null)
        {
            string sql = $@" SELECT i_date
						        ,cs_uri_stem
						        ,ROW_NUMBER() OVER(ORDER BY CONVERT(DATETIME ,i_date+' '+i_time) DESC) AS 
						         rownumber
						  FROM   MipIISLogRecord i
						  WHERE  sc_status = '404'
						        {SqlDateTimeStr(whereType, startTime, endTime)}";

            StringBuilder sb = new StringBuilder(@"select * from(" + sql + " ");
            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", pageIndex);