提交

username@email.com

2024-11-26 c7b8b87f07523d638ee6e9f4604431941302364e

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