| | |
| | | { |
| | | Condition += " and ( DATEDIFF(DAY,GETDATE(),ob.[DeliveryTime])<=0 or DATEDIFF(DAY,GETDATE(),oe.[DelayTime])<=0 )"; |
| | | } |
| | | else if (DeliveryTime == "明天逾期") |
| | | { |
| | | Condition += " and ( DATEDIFF(DAY,GETDATE(),ob.[DeliveryTime])<=1 or DATEDIFF(DAY,GETDATE(),oe.[DelayTime])<=1 )"; |
| | | } |
| | | |
| | | } |
| | | |
| | |
| | | { |
| | | Condition += " and ( DATEDIFF(DAY,GETDATE(),ob.[DeliveryTime])<=0 or DATEDIFF(DAY,GETDATE(),oe.[DelayTime])<=0 )"; |
| | | } |
| | | |
| | | else if (DeliveryTime == "明天逾期") |
| | | { |
| | | Condition += " and ( DATEDIFF(DAY,GETDATE(),ob.[DeliveryTime])<=1 or DATEDIFF(DAY,GETDATE(),oe.[DelayTime])<=1 )"; |
| | | } |
| | | } |
| | | |
| | | if (!string.IsNullOrEmpty(Province)) |