Index: OBJTimpl/WMSOrder/ImporteerPicking.cls.xml =================================================================== diff -u -r68334 -r68783 --- OBJTimpl/WMSOrder/ImporteerPicking.cls.xml (.../ImporteerPicking.cls.xml) (revision 68334) +++ OBJTimpl/WMSOrder/ImporteerPicking.cls.xml (.../ImporteerPicking.cls.xml) (revision 68783) @@ -29,8 +29,13 @@ 1 + +OBJTimpl.WMSOrder.OphalenOrderInOBJT +1 + + -PickLijnenOphaler:OBJTimpl.WMSOrder.OphalenPickLijnenConsolidatie="" +PickLijnenOphaler:OBJTimpl.WMSOrder.OphalenPickLijnenConsolidatie="",OrderOphaler:OBJTimpl.WMSOrder.OphalenOrderInOBJT="" 1 1 %Status @@ -39,6 +44,7 @@ Do ##class(dtoCorrelateVoorraadNiveau).%KillExtent() Set ..CheckOBJTFase=##class(OBJTimpl.CheckObjectiveFase).%New() set ..PickLijnenOphaler = $$$Inject(PickLijnenOphaler,##class(OBJTimpl.WMSOrder.OphalenPickLijnenConsolidatie).%New()) + Set ..OrderOphaler = $$$Inject(OrderOphaler,##class(OBJTimpl.WMSOrder.OphalenOrderInOBJT).%New()) Quit $$$OK ]]> @@ -126,18 +132,31 @@ @@ -157,13 +176,7 @@ 0 +Annulatie:%Boolean=0 0 ConsolidatieNr:%String +TECH.ResultSetIterator + +ConsolidatieNr:%String +TECH.ResultSetIterator +IdentNummer as IDENTNR, " + _ " 'annulatie' as FROMLOC ,'annulatie' as BRONPALLET ,'annulatie' as AFZETLOC ,'annulatie' as DOELPALLET , '' as USERID ," + _ " current_timestamp as PICKINGTIJDSTIP ,'annulatie' as TOLOC " + _ " from Flow_OrderWMS.lijn l " + _ " join flow_orderwms.sub s on s.lijn = l.id and s.verwerkingsoftware = 'V' " + _ " join flow_orderwms.Hoofding h on l.hoofding = h.id " + _ " where h.OBJTOutboundorderID = ? " + + Set Query = ##class(TECH.DynamicQuery).%New(SqlStatement,$ListBuild(ConsolidatieNr)) + #dim ResultSet As TECH.ResultSet = QueryAPI.GetResultSet(Query) + + Set Iterator=##class(TECH.ResultSetIterator).%New(ResultSet) + + Quit Iterator +]]> + + 1 %SQLGatewayConnection