示例#1
0
        public List <GetGeneratePriceListTermListDto> GetGeneratePriceListTermByTermID(int termID)//passed
        {
            var dataGroup = (from A in _msTermRepo.GetAll()
                             join B in _msTermAddDiscRepo.GetAll() on A.Id equals B.termID into BB
                             from B in BB.DefaultIfEmpty()
                             where A.Id == termID
                             orderby B.addDiscNo ascending
                             select new GetGeneratePriceListTermListDto
            {
                termRemarks = A.remarks,
                discPct = B == null ? 0 : B.addDiscPct / 100,
                discAmt = B == null ? 0 : B.addDiscAmt,
            })
                            .ToList();

            var dataResult = dataGroup.Select(x => new GetGeneratePriceListTermListDto
            {
                termRemarks = x.termRemarks,
                discPct     = Convert.ToDouble(x.discPct.ToString("0.##")),
                discAmt     = x.discAmt
            }).ToList();

            return(dataResult);
        }