var malzemePlan = from pln in mye.URETIM_MALZEME_PLANLAMAs
from bdn in mye.BEDEN_HAREKETLERIs.Where(a =
a.BdnHar_DRECid_DBCno == pln.upl_RECid_DBCno
a.BdnHar_DRECid_RECno == pln.upl_RECid_RECno
a.BdnHar_Tipi == 'N').DefaultIfEmpty()
where pln.upl_isemri == isEmriKodu &&
pln.upl_satirno == 0 &&
pln.upl_uretim_tuket == 1
select new
{
pln.upl_urstokkod,
pln.upl_depno,
bdn.BdnHar_BedenNo,
bdn.BdnHar_HarGor
};
Hiç yorum yok:
Yorum Gönder