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_DriverRecordDAL.cs | 34 ++++++++++++++++++++++++++++++++--
1 files changed, 32 insertions(+), 2 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DriverRecordDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DriverRecordDAL.cs
index 086bb3d..59e2d81 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DriverRecordDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/OA_DriverRecordDAL.cs
@@ -28,8 +28,8 @@
" from [OA_DriverRecord] od " +
" left join [OA_CarManage] ocar on od.[CarID] = ocar.Keyid " +
-
- " where 0=0 ";
+
+ " where ClockType = 1 ";
const string FROMSOUCEEND = ") as t ";
/// <summary>
/// 鍒嗛〉榛樿鎺掑簭瀛楁
@@ -102,6 +102,36 @@
/// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public OA_DriverRecord GetModelByTimeCarIDClockType(DateTime CreatTime, int CarID, int ClockType)
+ {
+ try
+ {
+ string condition = " ";
+
+ condition = " CarID='" + CarID + "' and ClockType = 2 ";
+
+ condition += " and DATEDIFF(DAY,'"+ CreatTime.ToString("yyyy-MM-dd") + "',[CreatTime])=0 ";
+
+ // return null;//閿欒鏁版嵁杩斾細绌�
+
+ IList<OA_DriverRecord> result = _dataBase.SelectModel<OA_DriverRecord>("*", "OA_DriverRecord", condition) as IList<OA_DriverRecord>;//鎵ц鏌ヨ
+
+ return (null == result || result.Count == 0) ? null : result[0];//杩斿洖缁撴灉
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+
+
+ /// <summary>
/// 鍏ㄩ儴鏌ヨ
/// </summary>
/// <param name="query"></param>
--
Gitblit v1.9.1