提交

username@email.com

2025-05-21 a980cd04341d71216e0f59bd4b7327fe9fc50032

 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 + "'";

@@ -310,6 +310,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);