客户增加合同查询

username@email.com

2024-09-26 d5574b3631e7a9667d43fdf6e73a1d876e37c365

 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 EXISTS   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract] where CorporateClientsid=a.Keyid ) ");
                }
                else
                {
                    Condition += string.Format(" and NOT  EXISTS   ( select  CorporateClientsid  from [dbo].[OA_CorporateClientContract] where CorporateClientsid=a.Keyid ) ");
                }
            }
               
            

            if (!string.IsNullOrEmpty(selLastOrderTime) && !string.IsNullOrEmpty(LastOrderTime))
                Condition += string.Format(" and CAST(LastOrderTime AS DATE) {0} CAST(getdate()-{1} AS date)", LastOrderTime, selLastOrderTime);