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 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 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 SearchBrokerRecClient(string userid) { var sech = new BrokerRECClientSearchCondition { Brokers = _brokerService.GetBrokerById(Convert.ToInt32(userid)) }; var list = _brokerRecClientService.GetBrokerRECClientsByCondition(sech).Select(p => new { p.Brokerlevel, p.Brokername, p.ClientInfo.Phone, ProjectName = p.Projectid == 0 ? "" : _productService.GetProductById(p.Projectid).Productname, }).ToList(); return(PageHelper.toJson(new { List = list })); }
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 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); } }
public HttpResponseMessage Add([FromBody] BrokerRECClientModel brokerrecclient) { if (brokerrecclient.Adduser == 0) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "经济人ID不能为空!"))); } if (brokerrecclient.Broker == 0) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "经纪人ID不能为空"))); } if (string.IsNullOrEmpty(brokerrecclient.Clientname)) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "客户名不能为空"))); } if (string.IsNullOrEmpty(brokerrecclient.Phone)) { return(PageHelper.toJson(PageHelper.ReturnValue(false, "客户电话不能为空!"))); } //查询客户信息 var sech = new BrokerRECClientSearchCondition { Clientname = brokerrecclient.Clientname, Phone = brokerrecclient.Phone, Projectids = new[] { brokerrecclient.Projectid }, DelFlag = EnumDelFlag.默认 }; var cmodel = _brokerRecClientService.GetBrokerRECClientsByCondition(sech); //检测客户是否存在于数据库 if (!cmodel.Any()) { //客户信息 var client = new ClientInfoEntity { Clientname = brokerrecclient.Clientname, Phone = brokerrecclient.Phone.ToString(CultureInfo.InvariantCulture), Housetype = brokerrecclient.HouseType, Houses = brokerrecclient.Houses, Note = brokerrecclient.Note, Adduser = brokerrecclient.Broker, Addtime = DateTime.Now, Upuser = brokerrecclient.Broker, Uptime = DateTime.Now }; _clientInfoService.Create(client); } else { return(PageHelper.toJson(PageHelper.ReturnValue(false, "该客户正在被推荐!"))); } //查询客户信息 var sech2 = new ClientInfoSearchCondition { Clientname = brokerrecclient.Clientname, Phone = brokerrecclient.Phone.ToString(CultureInfo.InvariantCulture), }; var cmodel2 = _clientInfoService.GetClientInfosByCondition(sech2).FirstOrDefault(); //查询经纪人信息 var broker = _brokerService.GetBrokerByUserId(brokerrecclient.Adduser); //创建推荐流程 var model = new BrokerRECClientEntity(); model.Broker = _brokerService.GetBrokerById(brokerrecclient.Adduser); model.ClientInfo = cmodel2; model.Clientname = brokerrecclient.Clientname; //model.Qq = Convert.ToInt32(brokerrecclient.Qq); model.Phone = brokerrecclient.Phone; //客户电话 model.Brokername = broker.Brokername; model.Brokerlevel = broker.Level.Name; model.Broker = broker; model.Adduser = brokerrecclient.Adduser; model.Addtime = DateTime.Now; model.Upuser = brokerrecclient.Adduser; model.Uptime = DateTime.Now; model.Projectid = brokerrecclient.Projectid; model.Projectname = brokerrecclient.Projectname; model.Status = EnumBRECCType.审核中; model.DelFlag = EnumDelFlag.默认; model.RecOrder = (int)EnumOrderType.推荐订单; _brokerRecClientService.Create(model); return(PageHelper.toJson(PageHelper.ReturnValue(true, "提交成功"))); }
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============================================================================ }