From 10ada97c04a399429285003bfcf97bbf8b24e940 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 21 十一月 2022 14:41:52 +0800 Subject: [PATCH] 项目查询 --- zhengcaioa/Services/IntentionCustomerService.cs | 31 +++++++++++++++++++++++++++++-- 1 files changed, 29 insertions(+), 2 deletions(-) diff --git a/zhengcaioa/Services/IntentionCustomerService.cs b/zhengcaioa/Services/IntentionCustomerService.cs index 3b528fb..44f86b8 100644 --- a/zhengcaioa/Services/IntentionCustomerService.cs +++ b/zhengcaioa/Services/IntentionCustomerService.cs @@ -3,6 +3,7 @@ using System.Linq; using System.Text; using AutoMapper; +using CommonToolsCore; using DTO; using IServices; using Microsoft.AspNetCore.Mvc.Rendering; @@ -103,7 +104,13 @@ } _context.SaveChanges(); - resultEntity.ReturnID = intentionCustomer.Id; + + var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A").ToList(); + + var intentionCustomerDTOs = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); + CacheHelperNetCore.CacheInsert("intentionCustomerDTOs", intentionCustomerDTOs); + + resultEntity.ReturnID = intentionCustomer.Id; resultEntity.Result = true; } catch (Exception ex) @@ -295,6 +302,19 @@ { query = query.Where( a=>a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()).ToList(); } + if (!string.IsNullOrWhiteSpace(searchEntity.ShifouDianhua)) + { + if (searchEntity.ShifouDianhua != "A") + { + query = query.Where(a => a.Tel == null || a.Tel == "").ToList(); + } + else + { + query = query.Where(a => a.Tel != null && a.Tel != "").ToList(); + } + + } + //if (searchEntity.totalrows == 0) searchEntity.totalrows = query.Count(); @@ -336,10 +356,17 @@ /// <returns></returns> public List<IntentionCustomerDTO> GetList() { - + List<IntentionCustomerDTO> intentionCustomerDTOs = (List<IntentionCustomerDTO>)CacheHelperNetCore.CacheValue("intentionCustomerDTOs"); + if (intentionCustomerDTOs != null && intentionCustomerDTOs.Count > 0) + { + return intentionCustomerDTOs; + } var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A").ToList(); + intentionCustomerDTOs = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); + CacheHelperNetCore.CacheInsert("intentionCustomerDTOs", intentionCustomerDTOs); + var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); return list; } -- Gitblit v1.9.1