public List <INVENTORY_MOVEMENT> GetReceivingByParamZaapShiftRpt(InvGetReceivingByParamZaapShiftRptInput input)
{
var receivingMvtType = new List <string>()
{
EnumHelper.GetDescription(Core.Enums.MovementTypeCode.Usage261),
EnumHelper.GetDescription(Core.Enums.MovementTypeCode.Usage262),
EnumHelper.GetDescription(Core.Enums.MovementTypeCode.Usage201),
EnumHelper.GetDescription(Core.Enums.MovementTypeCode.Usage202)
};
Expression <Func <INVENTORY_MOVEMENT, bool> > queryFilter = c => c.POSTING_DATE.HasValue && c.POSTING_DATE.Value <= input.EndDate;
queryFilter = queryFilter.And(c => c.POSTING_DATE.HasValue && c.POSTING_DATE >= input.StartDate);
queryFilter = queryFilter.And(c => c.PLANT_ID == input.PlantId);
queryFilter = queryFilter.And(c => c.ORDR == input.Ordr);
queryFilter = queryFilter.And(c => receivingMvtType.Contains(c.MVT));
return(_repository.Get(queryFilter).ToList());
}
public List <ZAAP_SHIFT_RPT> GetForLack1ByParam(InvGetReceivingByParamZaapShiftRptInput input)
{
Expression <Func <ZAAP_SHIFT_RPT, bool> > queryFilter = c => c.POSTING_DATE.HasValue && c.POSTING_DATE.Value <= input.EndDate;
queryFilter = queryFilter.And(c => c.POSTING_DATE.HasValue && c.POSTING_DATE >= input.StartDate);
queryFilter = queryFilter.And(c => c.WERKS == input.PlantId);
queryFilter = queryFilter.And(c => c.FA_CODE == input.FaCode);
queryFilter = queryFilter.And(c => c.ORDR == input.Ordr);
//queryFilter = queryFilter.And(c => receivingMvtType.Contains(c.MVT));
return(_repository.Get(queryFilter).ToList());
}
