From 120215455f4fb2e5a1447f3ecda87f36aca1f38f Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 27 二月 2026 08:54:22 +0800
Subject: [PATCH] 1）有到期时间的，到期前3个月变成红色（像人事管理那样）；没有到期时间的，从建档时间起算，9个月后变成红色。完成 （2）建档后1个月没有下单，变成血红色。 完成 （3）列表中删除“完结状态”；操作中删除“订单关联” 完成 （4）在“应收款订单”后面增加“未收款金额” 、“逾期收款”完成
---
CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs | 7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
index f601522..418ea4f 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/EC/EC_SpecialOrdersDAL.cs
@@ -388,7 +388,7 @@
/// <param name="MemberId"></param>
/// <returns></returns>
public IEnumerable<Model.EC_SpecialOrders> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, string PrintName, string
-CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime)
+CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime, string PSF_PressesDesk)
{
try
{
@@ -419,7 +419,10 @@
{
Condition += string.Format(" and PSO_OrderNum like '%{0}%'", PSO_OrderNum);
}
-
+ if (!string.IsNullOrEmpty(PSF_PressesDesk))
+ {
+ Condition += string.Format(" and a.[Keyid] not in ( select [SpecialOrderId] from [EC_SpecialForums] where [PSF_PressesDesk] = '{0}')", PSF_PressesDesk);
+ }
return _dataBase.SelectModelPage<Model.EC_SpecialOrders>(pagination, " a.*,b.BuyerName as CustomName,b.DocumentName as PrintName ", " EC_SpecialOrders as a left join EC_OrderBasic as b on a.PO_OrderId = b.Keyid ", " PSO_OrderNum DESC ", " PSO_OrderNum DESC ", Condition);
}
--
Gitblit v1.9.1