| | |
|---|
| | | { |
|---|
| | | string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 "; |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(DeliveredTime) && DeliveredTime!="预期") |
|---|
| | | Condition += " and DATEDIFF(day,od.[DeliverTime],'" + DeliveredTime + "')=0 "; |
|---|
| | | if (!string.IsNullOrEmpty(DeliveredTime) ) |
|---|
| | | { |
|---|
| | | if(DeliveredTime != "逾期") |
|---|
| | | { |
|---|
| | | Condition += " and DATEDIFF(day,od.[DeliverTime],'" + DeliveredTime + "')=0 "; |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime])<=0 "; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(CarId)) |
|---|
| | | Condition += " and od.CarId = '" + CarId + "'"; |
|---|
