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/OA/OA_WorkPlan_attachmentDAL.cs |   15 ++++++++++++++-
 1 files changed, 14 insertions(+), 1 deletions(-)

diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlan_attachmentDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlan_attachmentDAL.cs
index 60235f0..dceba0f 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlan_attachmentDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_WorkPlan_attachmentDAL.cs
@@ -166,11 +166,24 @@
         /// <returns></returns>
         public IEnumerable<Model.OA_WorkPlan_attachment> GetModelByKaipiaoId(int OA_WorkPlanId)
         {
-            return _dataBase.SelectModel<Model.OA_WorkPlan_attachment>(" * ", " OA_WorkPlan_attachment ", " OA_WorkPlanId = '" + OA_WorkPlanId + "' order by CreateTime desc ") as IList<Model.OA_WorkPlan_attachment>;//鎵ц鏌ヨ
+            return _dataBase.SelectModel<Model.OA_WorkPlan_attachment>(" * ", " OA_WorkPlan_attachment ", " OA_WorkPlanId = '" + OA_WorkPlanId + "' and [AttachmentType] in (1,2) order by CreateTime desc ") as IList<Model.OA_WorkPlan_attachment>;//鎵ц鏌ヨ
         }
 
 
         /// <summary>
+        /// 鍏ㄩ儴鏌ヨ
+        /// </summary>
+        /// <param name="query"></param>
+        /// <returns></returns>
+        public IEnumerable<Model.OA_WorkPlan_attachment> GetModelByKaipiaoIdandType(int OA_WorkPlanId, int AttachmentType)
+        {
+            return _dataBase.SelectModel<Model.OA_WorkPlan_attachment>(" * ", " OA_WorkPlan_attachment ", " OA_WorkPlanId = '" + OA_WorkPlanId + "' and [AttachmentType] = '" + AttachmentType + "' order by CreateTime desc ") as IList<Model.OA_WorkPlan_attachment>;//鎵ц鏌ヨ
+        }
+
+        
+
+
+        /// <summary>
         /// 鍒嗛〉鏌ヨ
         /// </summary>
         /// <param name="query"></param>

--
Gitblit v1.9.1