| | |
| | | updateproject.Modifier = cooperatecustomCustomer.Modifier; |
| | | updateproject.Modifytime = cooperatecustomCustomer.Modifytime; |
| | | updateproject.Weixin = cooperatecustomCustomer.Weixin; |
| | | |
| | | updateproject.HuiyuanId = cooperatecustomCustomer.HuiyuanId; |
| | | updateproject.Shifoutianjiaweixin = cooperatecustomCustomer.Shifoutianjiaweixin; |
| | | updateproject.Weixintime = cooperatecustomCustomer.Weixintime; |
| | | updateproject.Weixiner = cooperatecustomCustomer.Weixiner; |
| | | } |
| | | |
| | | _context.SaveChanges(); |
| | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || a.Sheng == searchEntity.Sheng.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.City) || a.City == searchEntity.City.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || a.AreaId == searchEntity.AreaId.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || (searchEntity.Shifouweixin == "A" && a.Weixin != null) || (searchEntity.Shifouweixin != "A" && a.Weixin == null) ) |
| | | |
| | | && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()) |
| | | && (string.IsNullOrWhiteSpace(searchEntity.HuiyuanId) || a.HuiyuanId == searchEntity.HuiyuanId.Trim()) |
| | | |
| | | select new CooperatecustomCustomerDTO |
| | | { |
| | |
| | | CreatetimeName = a.Createtime.ToString("yyyy-MM-dd"), |
| | | Weixin = a.Weixin, |
| | | Shifoutianjiaweixin = a.Shifoutianjiaweixin, |
| | | HuiyuanId = a.HuiyuanId, |
| | | Weixiner = a.Weixiner, |
| | | Weixintime = a.Weixintime, |
| | | } |
| | | ).OrderByDescending(x => x.Modifytime).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 listPosition =( from a in _context.CooperatecustomCustomers.Where(r => r.RecStatus == "A" && r.Creater == userid) |
| | | join b in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.Shoulitime >= datemin && x.Shoulitime < datemax) |
| | | join b in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.Createtime >= datemin && x.Createtime < datemax) |
| | | on a.Id equals b.Khdw |
| | | |
| | | select a |
| | |
| | | var list = _mapper.Map<List<CooperatecustomCustomerDTO>>(listPosition); |
| | | return list; |
| | | } |
| | | |
| | | public List<CooperatecustomCustomerDTO> GetListsalaryweixin(string userid, DateTime datemin, DateTime datemax) |
| | | { |
| | | |
| | | |
| | | var listPosition = _context.CooperatecustomCustomers.Where(r => r.RecStatus == "A" && r.Weixiner == userid && r.Weixintime >= datemin && r.Weixintime < datemax).ToList(); |
| | | |
| | | var list = _mapper.Map<List<CooperatecustomCustomerDTO>>(listPosition); |
| | | return list; |
| | | } |
| | | } |
| | | } |