WEBUI/WMS.BZServices/FJ/WCSPalletizingDtlService.cs

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using wms.sqlsugar.model.fj;
using WMS.BZModels;
using WMS.BZModels.Dto.FJ.ReportDtos;
using WMS.BZModels.Dto.FJ.WCSCachelineDtos;
using WMS.BZModels.Dto.FJ.WCSPalletizingDtos;
using WMS.BZSqlSugar;
using WMS.Info;

namespace WMS.BZServices.FJ
{
    public class WCSPalletizingDtlService
    {
        private readonly Repository<WCSPalletizinglayer> _WCSPalletizinglayerRepository;
        private readonly Repository<WCSPalletizingrow> _WCSPalletizingrowRepository;
        private readonly Repository<WCSPalletizingloc> _WCSPalletizinglocRepository;
        public WCSPalletizingDtlService(Repository<WCSPalletizinglayer> wCSPalletizinglayerRepository, Repository<WCSPalletizingrow> wCSPalletizingrowRepository, Repository<WCSPalletizingloc> wCSPalletizinglocRepository)
        {
            _WCSPalletizinglayerRepository = wCSPalletizinglayerRepository;
            _WCSPalletizingrowRepository = wCSPalletizingrowRepository;
            _WCSPalletizinglocRepository = wCSPalletizinglocRepository;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="palletizingId">id</param>
        /// <returns></returns>
        public IList<WCSPalletizingDtlDto> GetDtlById(int palletizingId)
        {
            var predicate = Expressionable.Create<WCSPalletizinglayer, WCSPalletizingrow, WCSPalletizingloc>();
            predicate = predicate.And((layer, rows, cols) => layer.PalletizingId == palletizingId);
            var list = _WCSPalletizinglayerRepository.Context.Queryable<WCSPalletizinglayer, WCSPalletizingrow, WCSPalletizingloc>((layer, rows, cols) => new object[] {
                JoinType.Left, layer.Id == rows.PalletizingLayerId,
                JoinType.Left,cols.PalletizingRowId== rows.Id
               }).Where(predicate.ToExpression())
                .Select((layer, rows, cols) => new WCSPalletizingDtlDto
                {
                    IsEmpty=layer.IsEmpty,
                    LayerNo=layer.LayerNo,
                    RowCountQty=layer.RowCountQty,
                    MatCodeList= layer.MatCodeList,
                    Finish= layer.Finish,
                    RowsIsEmpty=rows.IsEmpty,
                    QtyMaxCount=rows.QtyMaxCount,
                    RowNo=rows.RowNo,
                    IsMixRow=rows.IsMixRow,
                    CacheLineId= rows.CacheLineId,
                    RowsMatCodeList=rows.MatCodeList,
                    RowsFinish= rows.Finish,
                    AddTime=rows.AddTime,
                    EditTime=rows.EditTime,
                    LineCode=rows.LineCode,
                    TaskId=cols.TaskId,
                    ColsIsEmpty=cols.IsEmpty,
                    XYNo=cols.XYNo,
                    DevCode=cols.DevCode,
                    MatCode= cols.MatCode,
                    SideNum=cols.SideNum,
                    SpoolType = cols.SpoolType,
                    ColsFinish=cols.Finish

                }).ToList();
            return list;
        }


    }
}