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/Adm_tongxunluDAL.cs | 39 ++++++++++++++++++++++++++++++++++++---
1 files changed, 36 insertions(+), 3 deletions(-)
diff --git a/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs b/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs
index 010f0fc..ada61e6 100644
--- a/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs
+++ b/CY_ECommercePlatform/CY.SQLDAL/OA/Adm_tongxunluDAL.cs
@@ -69,11 +69,12 @@
new SqlParameter("@createtime",trueModel.createtime),
new SqlParameter("@modifier",trueModel.modifier),
new SqlParameter("@modifytime",trueModel.modifytime),
-
+ new SqlParameter("@Jusequanxian",string.IsNullOrEmpty(trueModel.Jusequanxian)?"":trueModel.Jusequanxian),
+
};
- string sql = "Insert Into Adm_tongxunlu ([FirmId],[type_id],[danwei_name],[lianxiren], [lianxidianhua], [beuzhu],[rec_status], [creater],[createtime], [modifier],[modifytime])"
- + " Values (@FirmId,@type_id,@danwei_name, @lianxiren, @lianxidianhua, @beuzhu, @rec_status, @creater, @createtime, @modifier,@modifytime)";
+ string sql = "Insert Into Adm_tongxunlu ([FirmId],[type_id],[danwei_name],[lianxiren], [lianxidianhua], [beuzhu],[rec_status], [creater],[createtime], [modifier],[modifytime],[Jusequanxian])"
+ + " Values (@FirmId,@type_id,@danwei_name, @lianxiren, @lianxidianhua, @beuzhu, @rec_status, @creater, @createtime, @modifier,@modifytime,@Jusequanxian)";
try
{
_dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>());
@@ -165,6 +166,38 @@
/// <summary>
+ /// 鏍规嵁缂栧彿鑾峰緱淇℃伅
+ /// </summary>
+ /// <param name="Keyid">缂栧彿</param>
+ /// <returns></returns>
+ public IEnumerable<Adm_tongxunlu> GetModelByKeyids(string keyids)
+ {
+ try
+ {
+ string condition = " ";
+ if (!string.IsNullOrEmpty(keyids))
+ {
+ condition = " Keyid in (" + keyids + ")";
+ }
+ else
+ {
+ return null;
+ }
+
+ // return null;//閿欒鏁版嵁杩斾細绌�
+
+ return _dataBase.SelectModel<Adm_tongxunlu>("*", "Adm_tongxunlu", condition) as IList<Adm_tongxunlu>;//鎵ц鏌ヨ
+
+
+ }
+ catch (Exception ex)
+ {
+ throw ex;
+ }
+ }
+
+
+ /// <summary>
/// 鍏ㄩ儴鏌ヨ
/// </summary>
/// <param name="query"></param>
--
Gitblit v1.9.1