提交

username@email.com

2025-12-18 66a1290f368df2f5f543e14fe6abf8b31bf76490

 CY_ECommercePlatform/CY.BLL/OA/CoreDeliverOrderBLL.cs

@@ -174,7 +174,7 @@
            }
              
            if (!string.IsNullOrEmpty(shipAddress))
                Condition += " and  b.shipAddress = '" + shipAddress + "'";
                Condition += " and  b.shipAddress like '%" + shipAddress + "%'";
           
            if (!string.IsNullOrEmpty(BuyerName))
                Condition += " and  c.Keyid  = '" + BuyerName + "'";
@@ -242,17 +242,17 @@
            }

            if (!string.IsNullOrEmpty(shipAddress))
                Condition += " and  b.shipAddress = '" + shipAddress + "'";
                Condition += " and  b.shipAddress like '%" + shipAddress + "%'";

            if (!string.IsNullOrEmpty(BuyerName))
                Condition += " and  c.Keyid  = '" + BuyerName + "'";


            if (!string.IsNullOrEmpty(createTimeStart))
                Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeStart + "')<=0 ";
                Condition += " and DATEDIFF(day,a.[OverTime],'" + createTimeStart + "')<=0 ";

            if (!string.IsNullOrEmpty(createTimeEnd))
                Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeEnd + "')>=0 ";
                Condition += " and DATEDIFF(day,a.[OverTime],'" + createTimeEnd + "')>=0 ";



@@ -261,7 +261,7 @@
            {
                new Criterion("", Condition),

                new Criterion("orderBy"," MakeTime desc  ")
                new Criterion("orderBy"," OverTime desc  ")
            };
            query.Criteria = criterias;
            return _ICoreDeliverOrderDAL.SelectModelPage(query, pa);