Index: TAOR rework/TAOR rework/TAOR rework.vbproj
===================================================================
diff -u -r1954 -r1955
--- TAOR rework/TAOR rework/TAOR rework.vbproj (.../TAOR rework.vbproj) (revision 1954)
+++ TAOR rework/TAOR rework/TAOR rework.vbproj (.../TAOR rework.vbproj) (revision 1955)
@@ -29,7 +29,7 @@
TAOR rework
Robin De Bock
false
- 4
+ 5
6.1.6.%2a
false
true
Index: TAOR rework/TAOR rework/databases/Automilling/AutomillingMapper.vb
===================================================================
diff -u -r1954 -r1955
--- TAOR rework/TAOR rework/databases/Automilling/AutomillingMapper.vb (.../AutomillingMapper.vb) (revision 1954)
+++ TAOR rework/TAOR rework/databases/Automilling/AutomillingMapper.vb (.../AutomillingMapper.vb) (revision 1955)
@@ -365,7 +365,9 @@
Const queryProduction = "
SELECT PickSequence, PickPlace, PalletID, SlotNbr, LeftRight, FeedbackERP, PickTimeStamp, MillingTimeStamp, DropTimeStamp, InsertTimeStamp, BatchID, SequenceNbr, ProductCode, Color, PickListID, NettoLength, NettoHeight, OversizeLength, OversizeHeight, ProgramLeftInner, ProgramLeftOuter, ProgramRightInner, ProgramRightOuter, PrintBarcodeLeft, PrintBarcodeRight, PrintTextLeft1, PrintTextLeft2, PrintTextLeft3, PrintTextRight1, PrintTextRight2, PrintTextRight3, PrintTextLeft4, PrintTextRight4, tablework, adjustment_X1, adjustment_X2, adjustment_YA, adjustment_YB, adjustment_YC, adjustment_YD
FROM [Automilling].[dbo].[Production]
- where PickTimeStamp IS NOT NULL and MillingTimeStamp IS NULL"
+ where PickTimeStamp IS NOT NULL
+ and MillingTimeStamp IS NULL
+ and 2 > DATEDIFF(DAY,PickTimeStamp, GETDATE())"
Const queryHistory = "
SELECT PickSequence, PickPlace, PalletID, SlotNbr, LeftRight, FeedbackERP, PickTimeStamp, MillingTimeStamp, DropTimeStamp, InsertTimeStamp, BatchID, SequenceNbr, ProductCode, Color, PickListID, NettoLength, NettoHeight, OversizeLength, OversizeHeight, ProgramLeftInner, ProgramLeftOuter, ProgramRightInner, ProgramRightOuter, PrintBarcodeLeft, PrintBarcodeRight, PrintTextLeft1, PrintTextLeft2, PrintTextLeft3, PrintTextRight1, PrintTextRight2, PrintTextRight3, PrintTextLeft4, PrintTextRight4, tablework, adjustment_X1, adjustment_X2, adjustment_YA, adjustment_YB, adjustment_YC, adjustment_YD
FROM [Automilling].[dbo].[History]