From 259584df9c06ade70f1f351affb35d4922e1263d Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 07 十一月 2025 16:23:13 +0800
Subject: [PATCH] 这个打印送货单，你们给我做两种，做一张打印没得数量的，做一张打印有数量的。送货单格式就是32开，就哎就是A4排一半。你们打了测试，注意，美观。 把那个把它做出来，下一批就用这个自动打。 不是不是打印的要数量都是有数量，要没得数量都没得数量。就是点打印的时候就两个按钮嘛，一个是有数量打印，或者或者或者空白送货单打印。 现在这个现在的送货单都是没有数量噻。现在那个要的，比如你那里再打你那个打印关闭的按钮，要把搞成两个打印嘛，就是打印空白送货单和打印送货单。 好点打印空白送货单的，就是现在这样子。点打印送货单，打印的就是那个跟有有就是有数据的送货单。作业本送货统计查询，状态查询需要修改逻辑
---
CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs | 84 ++++++++++++++++++++++++++++++++++++++++-
1 files changed, 81 insertions(+), 3 deletions(-)
diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs
index 6db6161..2b8837c 100644
--- a/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/OA/OA_DeliverPlanBLL.cs
@@ -119,6 +119,19 @@
return _IOA_DeliverPlanDAL.GetModelByformid(formid);
}
+
+
+ /// <summary>
+ /// 鏍规嵁deliverPlanPaicheid鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="deliverPlanPaicheid">缂栧彿</param>
+ /// <returns></returns>
+ public IEnumerable<Model.OA_DeliverPlan> GetModelByDeliverPlanPaicheid(Guid deliverPlanPaicheid)
+ {
+
+ return _IOA_DeliverPlanDAL.GetModelByDeliverPlanPaicheid(deliverPlanPaicheid);
+ }
+
/// <summary>
/// 鑾峰彇鍏ㄩ儴鍚堜綔瀹㈡埛
/// </summary>
@@ -154,22 +167,86 @@
/// <param name="pa"></param>
/// <returns></returns>
public IEnumerable<OA_DeliverPlan> SelectModelPage(Pagination pa, Guid FirmId, string DeliveredTime,
- string CarId, string DriverId,string trueMemberId ="")
+ string CarId, string DriverId,string trueMemberId ="", string CustormerName = "", string BusinessManager = "", string Paiche = "")
{
string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 ";
-
+ string sort = " Dizhi asc ";
if (!string.IsNullOrEmpty(DeliveredTime) )
{
if(DeliveredTime != "閫炬湡")
{
Condition += " and DATEDIFF(day,od.[DeliverTime],'" + DeliveredTime + "')=0 ";
+
}
else
{
- Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime])<=0 ";
+ Condition += " and DATEDIFF(day,GETDATE(),od.[DeliverTime])<0 ";
+ sort = " DeliverTime desc,Dizhi asc ";
}
}
+
+ if (!string.IsNullOrEmpty(CarId))
+ Condition += " and od.CarId = '" + CarId + "'";
+ if (!string.IsNullOrEmpty(DriverId))
+ Condition += " and od.DriverId = '" + DriverId + "'";
+ if (!string.IsNullOrEmpty(trueMemberId))
+ Condition += " and oss.MemberId = '" + trueMemberId + "'";
+ if (!string.IsNullOrEmpty(BusinessManager))
+ Condition += " and od.BusinessManagerId = '" + BusinessManager + "'";
+ if (!string.IsNullOrEmpty(CustormerName))
+ Condition += " and od.CompanyName like '%" + CustormerName + "%'";
+ if (!string.IsNullOrEmpty(Paiche))
+ {
+ if(Paiche == "1")
+ {
+ Condition += " and od.CarId >0";
+ }
+ else
+ {
+ Condition += " and ( od.CarId = 0 or od.CarId is null )";
+ }
+
+ }
+
+
+ Query query = new Query();
+ IList<Criterion> criterias = new List<Criterion>()
+ {
+ new Criterion("", Condition),
+
+ new Criterion("orderBy",sort)
+ };
+ query.Criteria = criterias;
+ return _IOA_DeliverPlanDAL.SelectModelPage(query, pa);
+ }
+
+
+
+ /// <summary>
+ /// 鏌ヨ鍚堜綔瀹㈡埛鍒嗛〉鍒楄〃
+ /// </summary>
+ /// <param name="pa"></param>
+ /// <returns></returns>
+ public IEnumerable<OA_DeliverPlan> SelectModelPageLishi(Pagination pa, Guid FirmId, string DeliveredTimestart, string DeliveredTimeend,
+ string CarId, string DriverId, string trueMemberId = "")
+ {
+ string Condition = " and od.FirmId ='" + FirmId + "' and od.shifouDelivery = 1 ";
+
+ if (!string.IsNullOrEmpty(DeliveredTimestart))
+ {
+
+ Condition += " and DATEDIFF(day,'"+ DeliveredTimestart + "',od.[DeliverTime])>=0 ";
+
+ }
+
+ if (!string.IsNullOrEmpty(DeliveredTimeend))
+ {
+
+ Condition += " and DATEDIFF(day,'" + DeliveredTimeend + "',od.[DeliverTime])<=0 ";
+
+ }
+
if (!string.IsNullOrEmpty(CarId))
Condition += " and od.CarId = '" + CarId + "'";
@@ -190,6 +267,7 @@
}
+
/// <summary>
/// 鏌ヨ鍚堜綔瀹㈡埛鍒嗛〉鍒楄〃
/// </summary>
--
Gitblit v1.9.1