新增设备 人员增加模糊查询 完成 日期默认当天 完成

username@email.com

2025-10-10 0dd76c2492f1afbe335b50a8ffb76e4af94271df

 CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs

@@ -85,6 +85,24 @@
            }
        }


        /// <summary>
        /// 修改合作客户
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool UpdateWanjie(CY.Model.OA_CorporateClients m_OA_CorporateClients)
        {
            try
            {
                return _IOA_CorporateClientsDal.UpdateWanjie(m_OA_CorporateClients);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 设置自动外协
        /// </summary>
@@ -252,7 +270,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 +327,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 +1203,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);
        }
    }
}