From 92a92c2fc694810fdba050f1034ef107ad5c858f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 十一月 2025 09:05:16 +0800
Subject: [PATCH] 那个作业本送货，查看明细或查看送货情况。这个列表中，比如说某个品种，它本来就没得的， 、那个格子里头不显零，格子里头就不要任何数据。不然，我们要要混乱好写了0的 ，我们才晓得这是有好已经送了的，就这样子修改，就某个品种，它本来就没得的格子头就是空白， 不不要写的，你这样子修改一下。
---
CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanPaicheBLL.cs | 63 ++++++++++++++++++++++++++++++-
1 files changed, 61 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanPaicheBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanPaicheBLL.cs
index bd02330..3a079a2 100644
--- a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanPaicheBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanPaicheBLL.cs
@@ -238,9 +238,68 @@
-
-
+
+
+ /// <summary>
+ /// 鏌ヨ鍚堜綔瀹㈡埛鍒嗛〉鍒楄〃
+ /// </summary>
+ /// <param name="pa"></param>
+ /// <returns></returns>
+ public IEnumerable<OA_DeliverPlan> SelectModelPageWenti(Pagination pa, Guid FirmId,
+ string DeliveredTimeStart, string DeliveredTimeEnd, string DriverId, string Zerenren , string CustormerName , string Wanjiestatus )
+ {
+ string Condition = " and od.FirmId ='" + FirmId + "' and od.DeliveredTime is not null and od.wentifankui is not null and od.wentifankui!='' "; // and od.shifouDelivery = 1
+ string sort = "DeliveredTime desc ";
+
+
+ if (!string.IsNullOrEmpty(DeliveredTimeStart))
+ {
+ Condition += " and DATEDIFF(day,'" + DeliveredTimeStart + "',od.[DeliveredTime]) >= 0 ";
+ }
+
+ if (!string.IsNullOrEmpty(DeliveredTimeEnd))
+ {
+ Condition += " and DATEDIFF(day,'" + DeliveredTimeEnd + "',od.[DeliveredTime]) <= 0 ";
+ }
+
+ if (!string.IsNullOrEmpty(DriverId))
+ Condition += " and od.DriverId = '" + DriverId + "'";
+
+ if (!string.IsNullOrEmpty(Zerenren))
+ Condition += " and od.Zerenren = '" + Zerenren + "'";
+ if (!string.IsNullOrEmpty(CustormerName))
+ Condition += " and od.CompanyName like '%" + CustormerName + "%'";
+
+
+
+
+ if (!string.IsNullOrEmpty(Wanjiestatus))
+ {
+ if (Wanjiestatus == "1")
+ {
+ Condition += " and od.Wanjiestatus = 1 ";
+ }
+ else
+ {
+ Condition += " and ( od.Wanjiestatus is null or od.Wanjiestatus = 0 )";
+ }
+
+ }
+
+
+ Query query = new Query();
+ IList<Criterion> criterias = new List<Criterion>()
+ {
+ new Criterion("", Condition),
+
+ new Criterion("orderBy",sort)
+ };
+ query.Criteria = criterias;
+ return _IOA_DeliverPlanPaicheDAL.SelectModelPageWenti(query, pa);
+ }
+
+
}
}
--
Gitblit v1.9.1