From a92925ca1001f3f5f8c3e649b23ef30af7138486 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 28 七月 2025 15:23:59 +0800
Subject: [PATCH] 打印样式修改

---
 CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs |   57 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 56 insertions(+), 1 deletions(-)

diff --git a/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs b/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs
index 0320225..74d9ec5 100644
--- a/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs
+++ b/CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs
@@ -252,7 +252,7 @@
         public IEnumerable<OA_CorporateClients> GetModelPageList(Pagination pa, Guid FirmId, string UserName, DateTime? beginTime,
 DateTime? endTime, string AccountManagerId, string BusinessManagerId, string CustomerIndustriesId, string CustomerTypeId, string DegreeImportanId,string LastOrderTime, string selOrderCount, string selOrderMoney, string SourcesInfoId, string TurnoverIntentionId,
 string OrderCount, string OrderMoney, string UserNum, string selLastOrderTime, string Province, string City, string County, bool IsStaff, Guid StaffMemberId,int? StaffId,string Shifouwanjie=null,
-bool? NeedWeifu=null,bool?NeedJiejiaRiWeiFu=null)
+bool? NeedWeifu=null,bool?NeedJiejiaRiWeiFu=null, string selHetongshangchuan = null)
         {
             string Condition = " and a.FirmId ='" + FirmId + "'";
 
@@ -309,6 +309,20 @@
 
             if (!string.IsNullOrEmpty(selOrderMoney) && !string.IsNullOrEmpty(OrderMoney))
                 Condition += string.Format(" and OrderMoney{0}'{1}'", selOrderMoney, OrderMoney);
+
+            if (!string.IsNullOrEmpty(selHetongshangchuan))
+            {
+                if (selHetongshangchuan == "1")
+                {
+                    Condition += string.Format(" and a.Keyid in   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract]  ) ");
+                }
+                else
+                {
+                    Condition += string.Format(" and a.Keyid not in   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract]   ) ");
+                }
+            }
+               
+            
 
             if (!string.IsNullOrEmpty(selLastOrderTime) && !string.IsNullOrEmpty(LastOrderTime))
                 Condition += string.Format(" and CAST(LastOrderTime AS DATE) {0} CAST(getdate()-{1} AS date)", LastOrderTime, selLastOrderTime);
@@ -1171,5 +1185,46 @@
         {
             return _IOA_CorporateClientsDal.SelectVisitListByBuzAndTime(BusinessManagerId, chaxuntime);
         }
+
+
+        /// <summary>
+        /// 娣诲姞闄勪欢
+        /// </summary>
+        /// <param name="rType"></param>
+        /// <returns></returns>
+        public bool Insertattachment(OA_attachment a_Attachment)
+        {
+            try
+            {
+                _IOA_CorporateClientsDal.Insertattachment(a_Attachment);
+            }
+            catch (Exception ex)
+            {
+                throw ex;
+            }
+            return true;
+        }
+
+
+        /// <summary>
+        /// 鑾峰彇闄勪欢
+        /// </summary>
+        /// <param name="Keyid">涓婚敭id</param>
+        /// <returns></returns>
+        public IEnumerable<OA_attachment> GetattachmentlList(string OA_Id)
+        {
+             
+            return _IOA_CorporateClientsDal.GetattachmentlList(OA_Id);
+        }
+
+        /// <summary>
+        /// 鍗曚釜鏌ヨ璁块棶
+        /// </summary>
+        /// <param name="Keyid">缂栧彿</param>
+        /// <returns></returns>
+        public OA_CorporateClientsVisit SelectVisitByKeyid(Guid Keyid)
+        {
+            return _IOA_CorporateClientsDal.SelectVisitByKeyid(Keyid);
+        }
     }
 }
\ No newline at end of file

--
Gitblit v1.9.1