src/Services/Sys_logServices.cs

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

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

using IRepository;
using IServices;
using Microsoft.Extensions.Configuration;
using SqlSugar;
using System;
using YL.Core.Entity;
using YL.Core.Orm.SqlSugar;
using YL.Utils.Extensions;
using YL.Utils.Json;
using YL.Utils.Pub;
using YL.Utils.Table;

namespace Services
{
    public class Sys_logServices : BaseServices<Sys_log>, ISys_logServices
    {
        private readonly SqlSugarClient _client;
        private readonly IConfiguration _configuration;

        public Sys_logServices(
            IConfiguration configuration,
            SqlSugarClient client, ISys_logRepository repository) : base(repository)
        {
            _configuration = configuration;
            _client = client;
        }

        public string PageList(Bootstrap.BootstrapParams bootstrap)
        {
            int totalNumber = 0;
            if (bootstrap.offset != 0)
            {
                bootstrap.offset = bootstrap.offset / bootstrap.limit + 1;
            }
            var query = _client.Queryable<Sys_log, Sys_user, Sys_user>
                ((s, c, u) => new object[] {
                   JoinType.Left,s.CreateBy==c.UserId,
                   JoinType.Left,s.ModifiedBy==u.UserId
                 })
                 .Select((s, c, u) => new
                 {
                     LogId = s.LogId.ToString(),
                     s.LogIp,
                     s.LogType,
                     s.Url,
                     s.Browser,
                     s.Description,
                     CName = c.UserNickname,
                     s.CreateDate,
                     UName = u.UserNickname,
                     s.ModifiedDate
                 }).MergeTable();
            if (!bootstrap.search.IsEmpty())
            {
                query.Where((s) => s.LogType.Contains(bootstrap.search));
            }
            if (!bootstrap.datemin.IsEmpty() && !bootstrap.datemax.IsEmpty())
            {
                query.Where(s => s.CreateDate > bootstrap.datemin.ToDateTimeB() && s.CreateDate <= bootstrap.datemax.ToDateTimeE());
            }