| | |
| | | updateproject.Dianxiaozhuanyuan = intentionCustomer.Dianxiaozhuanyuan; |
| | | updateproject.Zuijinzhuizongtime = intentionCustomer.Zuijinzhuizongtime; |
| | | |
| | | updateproject.Weixin = intentionCustomer.Weixin; |
| | | updateproject.Shifoutianjiaweixin = intentionCustomer.Shifoutianjiaweixin; |
| | | updateproject.Weixiner = intentionCustomer.Weixiner; |
| | | updateproject.Weixintime = intentionCustomer.Weixintime; |
| | | |
| | | } |
| | | |
| | | _context.SaveChanges(); |
| | |
| | | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Yixiangtime) || (a.Yixiangtime >= Yixiangtimestart && a.Yixiangtime <= Yixiangtimeend)) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Yixiang) || ( a.Yixiang == searchEntity.Yixiang.Trim() && (a.Ywjl == null || a.Ywjl == searchEntity.YwjlYx) )) |
| | | //&& (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()) |
| | | select new IntentionCustomerDTO |
| | | { |
| | | Id = a.Id, |
| | |
| | | ShrTel = a.ShrTel, |
| | | ShrAddress = a.ShrAddress, |
| | | Remark = a.Remark, |
| | | |
| | | Weixin = a.Weixin, |
| | | Shifoutianjiaweixin = a.Shifoutianjiaweixin, |
| | | Weixiner = a.Weixiner, |
| | | Weixintime = a.Weixintime, |
| | | RecStatus = a.RecStatus, |
| | | Modifier = a.Modifier, |
| | | Modifytime = a.Modifytime, |
| | |
| | | } |
| | | ).OrderByDescending(x => x.Modifytime).ToList(); |
| | | |
| | | if (!string.IsNullOrWhiteSpace(searchEntity.Shifouweixin)) |
| | | { |
| | | query = query.Where( a=>a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()).ToList(); |
| | | } |
| | | |
| | | |
| | | if (searchEntity.totalrows == 0) |
| | | //if (searchEntity.totalrows == 0) |
| | | searchEntity.totalrows = query.Count(); |
| | | var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList(); |
| | | data.LoadData(searchEntity, lianlist); |
| | |
| | | var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); |
| | | return list; |
| | | } |
| | | |
| | | public List<IntentionCustomerDTO> GetListsalaryweixin(string userid, DateTime datemin, DateTime datemax) |
| | | { |
| | | |
| | | |
| | | var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A" && r.Weixiner == userid && r.Weixintime >= datemin && r.Weixintime < datemax).ToList(); |
| | | |
| | | var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); |
| | | return list; |
| | | } |
| | | |
| | | public List<IntentionCustomerDTO> GetListsalaryyixiang(string userid, DateTime datemin, DateTime datemax) |
| | | { |
| | | |
| | | |
| | | var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A" && r.Dianxiaozhuanyuan == userid && r.Yixiangtime >= datemin && r.Yixiangtime < datemax).ToList(); |
| | | |
| | | var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); |
| | | return list; |
| | | } |
| | | |
| | | } |
| | | } |