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

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>
@@ -314,11 +332,11 @@
            {
                if (selHetongshangchuan == "1")
                {
                    Condition += string.Format(" and EXISTS   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract] where CorporateClientsid=a.Keyid ) ");
                    Condition += string.Format(" and a.Keyid in   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract]  ) ");
                }
                else
                {
                    Condition += string.Format(" and NOT  EXISTS   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract] where CorporateClientsid=a.Keyid ) ");
                    Condition += string.Format(" and a.Keyid not in   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract]   ) ");
                }
            }
               
@@ -1185,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);
        }
    }
}