20250722 川印系统客户访问增加长度，增加附件何查看 20250721 川印系统修改 完成

username@email.com

2 天以前 be3b255bbe328d793ff20011683dca5aee1668a1

 CY_ECommercePlatform/CY.BLL/OA/OA_CorporateClientsBLL.cs

@@ -314,11 +314,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 +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);
        }
    }
}