WEBUI/WMS.BZServices/FJ/TaskDtlService.cs

using Mapster;
using SqlSugar;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using wms.sqlsugar.model.fj;
using WMS.BZModels.Dto.FJ.TaskDtos;
using WMS.BZModels.Dto.FJ.WareCellDtos;
using WMS.BZSqlSugar;

namespace WMS.BZServices.FJ
{
    public class TaskDtlService
    {
        private readonly Repository<WCSTaskdtl> _WCSTaskdtlrepository;

        public TaskDtlService(Repository<WCSTaskdtl> WCSTaskdtlrepository)
        {
            _WCSTaskdtlrepository = WCSTaskdtlrepository;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="ParentTaskCode">任务id</param>
        /// <param name="addTime">任务的新增时间</param>
        /// <returns></returns>
        public IList<TaskdtlDto> GetDtlById(int ParentTaskCode, DateTime addTime)
        {
            var predicate = Expressionable.Create<WCSTaskdtl>();
            predicate = predicate.And(m => m.ParentTaskCode.Equals(ParentTaskCode));
            var query = _WCSTaskdtlrepository.Queryable().With(SqlWith.NoLock).Where(predicate.ToExpression()).SplitTable(addTime, addTime.AddDays(30));
            var lists = query.OrderBy(o => o.AddTime, OrderByType.Asc).ToList().Adapt<List<TaskdtlDto>>();
            return lists;
        }
    }
}