| | |
|---|
| | | string CarId, string DriverId,string trueMemberId ="", string CustormerName = "", string BusinessManager = "") |
|---|
| | | { |
|---|
| | | string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 "; |
|---|
| | | string sort = " case when Sort is null then 1 else 0 end asc,Sort asc "; |
|---|
| | | string sort = " Dizhi asc "; |
|---|
| | | if (!string.IsNullOrEmpty(DeliveredTime) ) |
|---|
| | | { |
|---|
| | | if(DeliveredTime != "逾期") |
|---|
| | |
|---|
| | | else |
|---|
| | | { |
|---|
| | | Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime])<0 and od.[DeliveredTime] is null "; |
|---|
| | | sort = " DeliverTime desc,Sort asc "; |
|---|
| | | sort = " DeliverTime desc,Dizhi asc "; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
