public HttpResponseMessage GetClientInfoList(EnumBRECCType status, string clientName, int page, int pageSize, EnumBrokerRECClientSearchOrderBy orderByAll = EnumBrokerRECClientSearchOrderBy.OrderById, bool isDes = true) { var condition = new BrokerRECClientSearchCondition { OrderBy =orderByAll , Page = page, PageCount = pageSize, Status = status, Clientname = clientName, IsDescending =isDes //Brokername = clientName }; var list = _brokerRecClientService.GetBrokerRECClientsByCondition(condition).Select(a => new { a.Id, a.Clientname, a.ClientInfo.Phone, a.Brokername, a.Uptime }).ToList(); var totalCont = _brokerRecClientService.GetBrokerRECClientCount(condition); return PageHelper.toJson(new { list1 = list, condition1 = condition, totalCont1 = totalCont }); }
public HttpResponseMessage RecommendList([FromBody]BrokerRECClientModel brokerRecClientModel) { if (brokerRecClientModel == null) throw new ArgumentNullException("brokerRecClientModel"); var condition = new BrokerRECClientSearchCondition { OrderBy = EnumBrokerRECClientSearchOrderBy.OrderById, Status = brokerRecClientModel.Status }; return PageHelper.toJson(_brokerRecClientService.GetBrokerRECClientsByCondition(condition).ToList()); }
public HttpResponseMessage BrokerList(EnumBRECCType status, string brokername, int page, int pageSize, EnumBrokerRECClientSearchOrderBy orderByAll = EnumBrokerRECClientSearchOrderBy .OrderByTime, bool isDes = true) { var condition = new BrokerRECClientSearchCondition { OrderBy = orderByAll, Page = page, PageCount = pageSize, Status = status, Clientname = brokername, IsDescending =isDes }; var list = _brokerRecClientService.GetBrokerRECClientsByCondition(condition).Select(a => new { a.Id, a.Brokername, a.Brokerlevel, a.ClientInfo.Phone, a.Projectname, a.Addtime, a.Clientname, SecretaryName = a.SecretaryId.Brokername, a.SecretaryPhone, Waiter = a.WriterId.Brokername, a.WriterPhone, a.Uptime }).ToList().Select(b => new { b.Id, b.Brokername, b.Brokerlevel, b.Phone, b.Projectname, Addtime = b.Addtime.ToString("yyy-MM-dd"), b.Clientname, SecretaryName = b.Brokername, b.SecretaryPhone, Waiter = b.Brokername, b.WriterPhone, Uptime = b.Uptime.ToString("yyy-MM-dd") }); var totalCont = _brokerRecClientService.GetBrokerRECClientCount(condition); return PageHelper.toJson(new { list1 = list, condition1 = condition, totalCont1 = totalCont }); }
public HttpResponseMessage GetStatusByUserId(int page) { //============================================chenda start=========================================== var user = (UserBase)_workContext.CurrentUser; var broker = _brokerService.GetBrokerByUserId(user.Id); if (broker != null) { var condition = new BrokerLeadClientSearchCondition { OrderBy = EnumBrokerLeadClientSearchOrderBy.OrderByTime, Page = page, PageCount = 10, Brokers = broker }; var conditon2 = new BrokerRECClientSearchCondition { OrderBy =EnumBrokerRECClientSearchOrderBy.OrderByTime, Page = page, PageCount = 10, Brokers = broker }; var model = _brokerLeadClientService.GetBrokerLeadClientsByCondition(condition).ToList(); if (model == null) { return PageHelper.toJson(PageHelper.ReturnValue(false, "当前经纪人没有带过客户")); } var model2 = _brokerRecClientService.GetBrokerRECClientsByCondition(conditon2).ToList(); if (model2 == null) { return PageHelper.toJson(PageHelper.ReturnValue(false, "当前经纪人没有推荐过客户")); } List<ReturnCustomModel> listModel = new List<ReturnCustomModel>(); // 带客 var listdk= model.Select(p => new { StrType = "带客", Clientname = p.ClientInfo.Clientname, Housetype = p.ClientInfo.Housetype, Houses = p.ClientInfo.Houses, Phone = p.Broker.Phone, Status = p.Status, Id = p.Id, }).ToList().ToList(); foreach(var p in listdk) { listModel.Add(new ReturnCustomModel{ Clientname=p.Clientname, Houses=p.Houses, Housetype=p.Housetype, Id=p.Id.ToString(), Phone=p.Phone, Status=p.Status.ToString(), StrType=p.StrType}); } //推荐 var listtj= model2.Select(c => new { StrType = "推荐", Clientname = c.ClientInfo.Clientname, Housetype = c.ClientInfo.Housetype, Houses = c.ClientInfo.Houses, Phone = c.Broker.Phone, Status = c.Status, Id = c.Id, Uptime = c.Uptime.ToString(CultureInfo.InvariantCulture) }).ToList(); foreach (var p in listtj) { listModel.Add(new ReturnCustomModel { Clientname = p.Clientname, Houses = p.Houses, Housetype = p.Housetype, Id = p.Id.ToString(), Phone = p.Phone, Status = p.Status.ToString(), StrType = p.StrType}); } int totalCount = _brokerLeadClientService.GetBrokerLeadClientCount(condition) + _brokerRecClientService.GetBrokerRECClientCount(conditon2); return PageHelper.toJson(new { List = listModel, totalCount = totalCount }); } return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆")); //================================================================chenda end============================================================================ }
public HttpResponseMessage ClientInfo(int id) { var condition = new BrokerRECClientSearchCondition { Id = id }; var model = _brokerRecClientService.GetBrokerRECClientsByCondition(condition).ToList(); try { var clientModel = model.Select(p => new { Clientname = p.ClientInfo.Clientname, Phone = p.ClientInfo.Phone, Housetype = p.ClientInfo.Housetype, Houses = p.ClientInfo.Houses, Note = p.ClientInfo.Note, Uptime = p.Uptime.ToString(CultureInfo.InvariantCulture) }); var brokerModel = model.Select(p => new { Brokername = p.Brokername, Brokerlevel = p.Brokerlevel, Phone = p.Broker.Phone, Qq = p.Broker.Qq, RegTime = p.Broker.Regtime.ToString(CultureInfo.InvariantCulture), Projectname = p.Projectname }); return PageHelper.toJson(new { clientModel, brokerModel }); } catch { } return PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证错误!")); }
public IQueryable<BrokerRECClientEntity> GetBrokerRECClientsByCondition(BrokerRECClientSearchCondition condition) { var query = _brokerrecclientRepository.Table; try { if (condition.AddtimeBegin.HasValue) { query = query.Where(q => q.Addtime>= condition.AddtimeBegin.Value); } if (condition.AddtimeEnd.HasValue) { query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value); } if (condition.UptimeBegin.HasValue) { query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value); } if (condition.UptimeEnd.HasValue) { query = query.Where(q => q.Uptime < condition.UptimeEnd.Value); } if (!string.IsNullOrEmpty(condition.Phone)) { query = query.Where(q => q.Phone.Contains(condition.Phone)); } if (!string.IsNullOrEmpty(condition.Qq)) { query = query.Where(q => q.Qq.Contains(condition.Qq)); } if (!string.IsNullOrEmpty(condition.Clientname)) { query = query.Where(q => q.Clientname.Contains(condition.Clientname)); } if (!string.IsNullOrEmpty(condition.Brokername)) { query = query.Where(q => q.Brokername.Contains(condition.Brokername)); } if (!string.IsNullOrEmpty(condition.Brokerlevel)) { query = query.Where(q => q.Brokerlevel.Contains(condition.Brokerlevel)); } if (!string.IsNullOrEmpty(condition.Projectname)) { query = query.Where(q => q.Projectname.Contains(condition.Projectname)); } if (!string.IsNullOrEmpty(condition.SecretaryPhone)) { query = query.Where(q => q.SecretaryPhone.Contains(condition.SecretaryPhone)); } if (!string.IsNullOrEmpty(condition.WriterPhone)) { query = query.Where(q => q.WriterPhone.Contains(condition.WriterPhone)); } if (condition.Ids != null && condition.Ids.Any()) { query = query.Where(q => condition.Ids.Contains(q.Id)); } if (condition.Brokers != null ) { query = query.Where(q =>q.Broker.Id== condition.Brokers.Id); } if (condition.ClientInfos != null && condition.ClientInfos.Any()) { query = query.Where(q => condition.ClientInfos.Contains(q.ClientInfo)); } if (condition.Addusers != null && condition.Addusers.Any()) { query = query.Where(q => condition.Addusers.Contains(q.Adduser)); } if (condition.Upusers != null && condition.Upusers.Any()) { query = query.Where(q => condition.Upusers.Contains(q.Upuser)); } if (condition.Projectids != null && condition.Projectids.Any()) { query = query.Where(q => condition.Projectids.Contains(q.Projectid)); } if (condition.SecretaryIDs != null && condition.SecretaryIDs.Any()) { query = query.Where(q => condition.SecretaryIDs.Contains(q.SecretaryId)); } if (condition.Id >0) { query = query.Where(q => condition.Id ==q.Id); } if (condition.WriterIDs != null && condition.WriterIDs.Any()) { query = query.Where(q => condition.WriterIDs.Contains(q.WriterId)); } if(condition.OrderBy.HasValue) { switch (condition.OrderBy.Value) { case EnumBrokerRECClientSearchOrderBy.OrderById: query = condition.IsDescending ? query.OrderByDescending(q => q.Id) : query.OrderBy(q => q.Id); break; case EnumBrokerRECClientSearchOrderBy.OrderByTime: query = condition.IsDescending ? query.OrderByDescending(q => q.Uptime) : query.OrderBy(q => q.Uptime); break; case EnumBrokerRECClientSearchOrderBy.OrderByBrokername : query = condition.IsDescending ? query.OrderByDescending(q => q.Brokername) : query.OrderBy(q => q.Brokername); break; case EnumBrokerRECClientSearchOrderBy.OrderByBrokerlevel: query = condition.IsDescending ? query.OrderByDescending(q => q.Brokerlevel) : query.OrderBy(q => q.Brokerlevel); break; case EnumBrokerRECClientSearchOrderBy.OrderByClientname: query = condition.IsDescending ? query.OrderByDescending(q => q.Clientname) : query.OrderBy(q => q.Clientname); break; case EnumBrokerRECClientSearchOrderBy.OrderByPhone: query = condition.IsDescending ? query.OrderByDescending(q => q.Phone) : query.OrderBy(q => q.Phone); break; case EnumBrokerRECClientSearchOrderBy.OrderByProjectname: query = condition.IsDescending ? query.OrderByDescending(q => q.Projectname) : query.OrderBy(q => q.Projectname); break; case EnumBrokerRECClientSearchOrderBy.OrderByAddtime: query = condition.IsDescending ? query.OrderByDescending(q => q.Addtime) : query.OrderBy(q => q.Addtime); break; case EnumBrokerRECClientSearchOrderBy.OrderBySecretaryName: query = condition.IsDescending ? query.OrderByDescending(q => q.SecretaryId.Brokername) : query.OrderBy(q => q.SecretaryId.Brokername); break; case EnumBrokerRECClientSearchOrderBy.OrderByWaiter: query = condition.IsDescending ? query.OrderByDescending(q => q.WriterId.Brokername) : query.OrderBy(q => q.WriterId.Brokername); break; case EnumBrokerRECClientSearchOrderBy.OrderByUptime: query = condition.IsDescending ? query.OrderByDescending(q => q.Uptime) : query.OrderBy(q => q.Uptime); break; } } else { query = query.OrderBy(q=>q.Id); } if (condition.Status.HasValue) { query = query.Where(c => c.Status == condition.Status); } if (condition.DelFlag.HasValue) { query = query.Where(c => c.DelFlag == condition.DelFlag); } if (condition.Page.HasValue && condition.PageCount.HasValue) { query = query.Skip((condition.Page.Value - 1)*condition.PageCount.Value).Take(condition.PageCount.Value); } return query; } catch(Exception e) { _log.Error(e,"数据库操作出错"); return null; } }
public int GetBrokerRECClientCount (BrokerRECClientSearchCondition condition) { var query = _brokerrecclientRepository.Table; try { if (condition.AddtimeBegin.HasValue) { query = query.Where(q => q.Addtime>= condition.AddtimeBegin.Value); } if (condition.AddtimeEnd.HasValue) { query = query.Where(q => q.Addtime < condition.AddtimeEnd.Value); } if (condition.UptimeBegin.HasValue) { query = query.Where(q => q.Uptime>= condition.UptimeBegin.Value); } if (condition.UptimeEnd.HasValue) { query = query.Where(q => q.Uptime < condition.UptimeEnd.Value); } if (!string.IsNullOrEmpty(condition.Qq)) { query = query.Where(q => q.Qq.Contains(condition.Qq)); } if (!string.IsNullOrEmpty(condition.Clientname)) { query = query.Where(q => q.Clientname.Contains(condition.Clientname)); } if (!string.IsNullOrEmpty(condition.Phone)) { query = query.Where(q => q.Phone.Contains(condition.Phone)); } if (!string.IsNullOrEmpty(condition.Brokername)) { query = query.Where(q => q.Brokername.Contains(condition.Brokername)); } if (!string.IsNullOrEmpty(condition.Brokerlevel)) { query = query.Where(q => q.Brokerlevel.Contains(condition.Brokerlevel)); } if (!string.IsNullOrEmpty(condition.Projectname)) { query = query.Where(q => q.Projectname.Contains(condition.Projectname)); } if (!string.IsNullOrEmpty(condition.SecretaryPhone)) { query = query.Where(q => q.SecretaryPhone.Contains(condition.SecretaryPhone)); } if (!string.IsNullOrEmpty(condition.WriterPhone)) { query = query.Where(q => q.WriterPhone.Contains(condition.WriterPhone)); } if (condition.Ids != null && condition.Ids.Any()) { query = query.Where(q => condition.Ids.Contains(q.Id)); } if (condition.Brokers != null ) { query = query.Where(q =>q.Broker.Id== condition.Brokers.Id); } if (condition.ClientInfos != null && condition.ClientInfos.Any()) { query = query.Where(q => condition.ClientInfos.Contains(q.ClientInfo)); } if (condition.Addusers != null && condition.Addusers.Any()) { query = query.Where(q => condition.Addusers.Contains(q.Adduser)); } if (condition.Upusers != null && condition.Upusers.Any()) { query = query.Where(q => condition.Upusers.Contains(q.Upuser)); } if (condition.Projectids != null && condition.Projectids.Any()) { query = query.Where(q => condition.Projectids.Contains(q.Projectid)); } if (condition.SecretaryIDs != null && condition.SecretaryIDs.Any()) { query = query.Where(q => condition.SecretaryIDs.Contains(q.SecretaryId)); } if (condition.WriterIDs != null && condition.WriterIDs.Any()) { query = query.Where(q => condition.WriterIDs.Contains(q.WriterId)); } if (condition.DelFlag != null) { query = query.Where(q => q.DelFlag == condition.DelFlag); } if (condition.Status != null) { query = query.Where(q => q.Status == condition.Status); } return query.Count(); } catch(Exception e) { _log.Error(e,"数据库操作出错"); return -1; } }