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.pt; using WMS.BZModels.Dto.PT.TaskDtos; using WMS.BZSqlSugar; namespace WMS.BZServices.PT { public class TaskDtlService { private readonly Repository _WCSTaskdtlrepository; public TaskDtlService(Repository WCSTaskdtlrepository) { _WCSTaskdtlrepository = WCSTaskdtlrepository; } /// /// /// /// 任务id /// 任务的新增时间 /// public IList GetDtlById(int ParentTaskCode, DateTime addTime) { var predicate = Expressionable.Create(); 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>(); return lists; } } }