public ListResultDto <GetUnitItemListDto> GetDataMsUnitItem(GetUnitItemInputDto input)
{
var getData = (from A in _msUnitItemRepo.GetAll()
join B in _msUnitRepo.GetAll() on A.unitID equals B.Id
join C in _msClusterRepo.GetAll() on B.clusterID equals C.Id
join D in _msCompanyRepo.GetAll() on A.coCode equals D.coCode into L1
from D in L1.DefaultIfEmpty()
join E in _lkItemRepo.GetAll() on A.itemID equals E.Id
where input.itemID.Contains(A.itemID) && input.unitID.Contains(A.unitID)
select new GetUnitItemListDto
{
coID = D == null ? 0 : D.Id,
coCode = D == null ? null : D.coCode,
coName = D == null ? null : D.coName,
item = E.itemName,
itemID = A.Id,
unitID = A.unitID,
unitNo = B.unitNo,
unitItemID = A.Id,
clusterCode = C.clusterCode
}).ToList();
return(new ListResultDto <GetUnitItemListDto>(getData));
}
