提交

username@email.com

2021-09-06 030609a2b7574d9a2f169a043a1a31cf14b68645

 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 + "'";