CB2-20200827ONU\Administrator
2021-10-08 d789099e9dc45e7fa3ee0eb73ee97f80b1963466
CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs
@@ -158,8 +158,18 @@
        {
            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 + "'";