From 0dd76c2492f1afbe335b50a8ffb76e4af94271df Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 10 十月 2025 15:16:51 +0800
Subject: [PATCH] 新增设备 人员增加模糊查询 完成 日期默认当天 完成
---
CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs | 45 ++++++++++++++++++++++++++++++++++++++-------
1 files changed, 38 insertions(+), 7 deletions(-)
diff --git a/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs
index d883838..c7d8954 100644
--- a/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/OA/Adm_tongxunluBLL.cs
@@ -115,12 +115,26 @@
return _IAdm_tongxunluDAL.GetModelByKeyid(keyid);
}
- /// <summary>
- /// 鍒犻櫎鍚堜綔瀹㈡埛
- /// </summary>
- /// <param name="rType"></param>
- /// <returns></returns>
- public bool DeleteModel(CY.Model.Adm_tongxunlu rType)
+
+
+ /// <summary>
+ /// 鑾峰彇鍏ㄩ儴鍚堜綔瀹㈡埛
+ /// </summary>
+ /// <param name="Keyid">涓婚敭id</param>
+ /// <returns></returns>
+ public IEnumerable<Model.Adm_tongxunlu> GetModelByKeyids(string keyids)
+ {
+
+ return _IAdm_tongxunluDAL.GetModelByKeyids(keyids);
+ }
+
+
+ /// <summary>
+ /// 鍒犻櫎鍚堜綔瀹㈡埛
+ /// </summary>
+ /// <param name="rType"></param>
+ /// <returns></returns>
+ public bool DeleteModel(CY.Model.Adm_tongxunlu rType)
{
try
{
@@ -138,7 +152,7 @@
/// </summary>
/// <param name="pa"></param>
/// <returns></returns>
- public IEnumerable<Adm_tongxunlu> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string danwei_name)
+ public IEnumerable<Adm_tongxunlu> SelectModelPage(Pagination pa, Guid FirmId, string type_id, string danwei_name,bool IsChangyongziliao,int? staffid, string selquanxin)
{
string Condition = " and ok.FirmId ='" + FirmId + "' and ok.rec_status = 'A' ";
@@ -148,10 +162,27 @@
Condition += " and ok.type_id = " + type_id + "";
}
+ if (!string.IsNullOrEmpty(selquanxin))
+ {
+ if (selquanxin == "1")
+ {
+ Condition += " and ( ok.[Jusequanxian] = '' or ok.[Jusequanxian] = ',,' )";
+ }
+ else if (selquanxin == "2")
+ {
+ Condition += " and (ok.[Jusequanxian] != '' and ok.[Jusequanxian] != ',,' )";
+ }
+
+ }
+
if (!string.IsNullOrEmpty(danwei_name))
{
Condition += " and ok.danwei_name like '%" + danwei_name + "%'";
}
+ if(IsChangyongziliao == false && staffid.HasValue && staffid>0)
+ {
+ Condition += " and ok.Jusequanxian like '%," + staffid + ",%'";
+ }
Query query = new Query();
IList<Criterion> criterias = new List<Criterion>()
--
Gitblit v1.9.1