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_ShejijijianDAL.cs | 21 ++++++++++++++++++++-
1 files changed, 20 insertions(+), 1 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShejijijianDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShejijijianDAL.cs
index 7223609..107d5f7 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShejijijianDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_ShejijijianDAL.cs
@@ -59,7 +59,7 @@
IList<SqlParameter> sqlParms = new List<SqlParameter>()
{
- new SqlParameter("@Keyid",trueModel.Keyid),
+ //new SqlParameter("@Keyid",trueModel.Keyid),
new SqlParameter("@FirmId",trueModel.FirmId),
new SqlParameter("@Dingdanleixing",string.IsNullOrEmpty(trueModel.Dingdanleixing)?"":trueModel.Dingdanleixing),
new SqlParameter("@DingdanleixingName",string.IsNullOrEmpty(trueModel.DingdanleixingName)?"":trueModel.DingdanleixingName),
@@ -268,5 +268,24 @@
}
return true;
}
+
+ /// <summary>
+ /// 鎵归噺鍒犻櫎
+ /// </summary>
+ /// <param name="keyids"></param>
+ /// <param name="Memberid"></param>
+ /// <returns></returns>
+ public bool DelAllModel(string keyids, Guid Memberid)
+ {
+ try
+ {
+ int result = _dataBase.ExecuteSql(" DELETE dbo.OA_Shejijijian WHERE Keyid IN (" + keyids.Trim(',') + ") ");
+ return (result > 0);
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
}
}
--
Gitblit v1.9.1