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

username@email.com

2 天以前 be3b255bbe328d793ff20011683dca5aee1668a1

 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);
        }
    }
}