From d3205f4627ceb7af1344ce77715def28fee5545b Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 17 十二月 2025 08:56:19 +0800
Subject: [PATCH] 在“编号”和“片区”直接增加一列“送货时间”，该送货时间显示进行了“送货安排”操作的学校的时间，没有安排送货的学校就是空白 完成
---
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