From 66beb245e516809514642c00922f0339bf760518 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 09 五月 2025 08:38:00 +0800
Subject: [PATCH] 菜单 行政管理=》行政管理=》问题反馈 /Pages/business/DeliverPlanPaicheList.aspx 06
---
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..b73566c 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.shifouDelivery = 1 and od.DeliveredTime is not null and od.wentifankui is not null and od.wentifankui!='' ";
+ 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