public IQueryable<ClientInfoEntity> GetClientInfosByCondition(ClientInfoSearchCondition condition) { var query = _clientinfoRepository.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.Clientname)) { query = query.Where(q => q.Clientname==condition.Clientname); } if (!string.IsNullOrEmpty(condition.Phone)) { query = query.Where(q => q.Phone==(condition.Phone)); } if (!string.IsNullOrEmpty(condition.Housetype)) { query = query.Where(q => q.Housetype.Contains(condition.Housetype)); } if (!string.IsNullOrEmpty(condition.Houses)) { query = query.Where(q => q.Houses.Contains(condition.Houses)); } if (condition.Ids != null && condition.Ids.Any()) { query = query.Where(q => condition.Ids.Contains(q.Id)); } if (condition.Addusers != null && condition.Addusers!=0) { query = query.Where(q => (q.Adduser == condition.Addusers)); } if (condition.Upusers != null && condition.Upusers.Any()) { query = query.Where(q => condition.Upusers.Contains(q.Upuser)); } if(condition.OrderBy.HasValue) { switch (condition.OrderBy.Value) { case EnumClientInfoSearchOrderBy.OrderById: query = condition.isDescending?query.OrderByDescending(q=>q.Id):query.OrderBy(q=>q.Id); break; case EnumClientInfoSearchOrderBy.OrderByTime: query = condition.isDescending ? query.OrderBy(q => q.Uptime) : query.OrderByDescending(q => q.Uptime); break; } } else { query = query.OrderBy(q=>q.Id); } 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 GetClientInfoCount (ClientInfoSearchCondition condition) { var query = _clientinfoRepository.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.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.Housetype)) { query = query.Where(q => q.Housetype.Contains(condition.Housetype)); } if (!string.IsNullOrEmpty(condition.Houses)) { query = query.Where(q => q.Houses.Contains(condition.Houses)); } if (condition.Ids != null && condition.Ids.Any()) { query = query.Where(q => condition.Ids.Contains(q.Id)); } if (condition.Addusers != 0) { query = query.Where(q => (q.Adduser == condition.Addusers)); } if (condition.Upusers != null && condition.Upusers.Any()) { query = query.Where(q => condition.Upusers.Contains(q.Upuser)); } return query.Count(); } catch(Exception e) { _log.Error(e,"数据库操作出错"); return -1; } }
public HttpResponseMessage GetBrokerDetails() { var user = (UserBase)_workContext.CurrentUser; if (user != null) { var broker = _brokerService.GetBrokerByUserId(user.Id);//获取当前经纪人 if (broker == null) { return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆")); } else { //更新到经纪人表中 可用金额 broker.Amount = Convert.ToDecimal(GetBrokerAmount()); _brokerService.Update(broker); var partnerCount = 0;//合伙人个数 var refereeCount = 0;//推荐人个数 var customerCount = 0;//客户个数 var levelStr = "";//等级 var orderStr = "0";//排名 var allMoneys = "0";//总佣金 var partnerlistsearchcon = new PartnerListSearchCondition { Brokers = broker, Status = EnumPartnerType.同意 }; partnerCount = _partnerlistService.GetPartnerListCount(partnerlistsearchcon); var recomagmentsearchcon = new RecommendAgentSearchCondition { BrokerId = broker.Id }; refereeCount = _recommendagentService.GetRecommendAgentCount(recomagmentsearchcon); var condition = new ClientInfoSearchCondition { Addusers = broker.Id }; customerCount = _clientInfoService.GetClientInfoCount(condition); levelStr = broker.Level.Name; allMoneys = broker.Amount.ToString(); orderStr = GetOrdersByuserId(broker.Id.ToString()); return PageHelper.toJson(new { partnerCount = partnerCount, refereeCount = refereeCount, customerCount = customerCount, levelStr = levelStr, orderStr = orderStr, allMoneys = allMoneys, photo = broker.Headphoto, Name = broker.Brokername }); } } return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆")); }
public HttpResponseMessage GetClientInfoNumByUserId() { var user = (UserBase)_workContext.CurrentUser; if (user != null) { var broker = _brokerService.GetBrokerByUserId(user.Id);//获取当前经纪人 if (broker != null) { var condition = new ClientInfoSearchCondition { Addusers = broker.Id }; var count = _clientInfoService.GetClientInfoCount(condition); return PageHelper.toJson(new { count }); } else { var count = 0; return PageHelper.toJson(new { count }); } } return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆")); }
public HttpResponseMessage GetClientInfoListByUserId(int page) { var user = (UserBase)_workContext.CurrentUser; if (user != null) { var broker = _brokerService.GetBrokerByUserId(user.Id);//获取当前经纪人 var condition = new ClientInfoSearchCondition { Addusers = broker.UserId, Page =page , PageCount =10 }; var list = _clientInfoService.GetClientInfosByCondition(condition).Select(p => new { p.Clientname, p.Phone, p.Id, p.Houses, p.Housetype }).ToList(); int totalCount = _clientInfoService.GetClientInfoCount(condition); return PageHelper.toJson(new { list = list,totalCount }); } return PageHelper.toJson(PageHelper.ReturnValue(false, "获取用户失败,请检查是否登陆")); }
public HttpResponseMessage Add([FromBody] BrokerLeadClientModel brokerleadclient) { if (brokerleadclient.Adduser == 0) return PageHelper.toJson(PageHelper.ReturnValue(false, "经济人ID不能为空!")); if (brokerleadclient.Broker == 0) return PageHelper.toJson(PageHelper.ReturnValue(false, "经纪人ID不能为空!")); if (string.IsNullOrEmpty(brokerleadclient.Clientname)) return PageHelper.toJson(PageHelper.ReturnValue(false, "客户名不能为空")); if (string.IsNullOrEmpty(brokerleadclient.Phone)) return PageHelper.toJson(PageHelper.ReturnValue(false, "客户电话不能为空!")); //查询客户信息 var sech = new BrokerLeadClientSearchCondition { ClientName = brokerleadclient.Clientname, Phone = brokerleadclient.Phone, Projectids = new[] { brokerleadclient.Projectid }, DelFlag = EnumDelFlag.默认 }; var cmodel = _brokerleadclientService.GetBrokerLeadClientsByCondition(sech).FirstOrDefault(); //检测客户是否存在于数据库 if (cmodel == null) { //客户信息 var client = new ClientInfoEntity { Clientname = brokerleadclient.Clientname, Phone = brokerleadclient.Phone.ToString(CultureInfo.InvariantCulture), Housetype = brokerleadclient.HouseType, Houses = brokerleadclient.Houses, Note = brokerleadclient.Note, Adduser = brokerleadclient.Broker, Addtime = DateTime.Now, Upuser = brokerleadclient.Broker, Uptime = DateTime.Now }; _clientInfoService.Create(client); } else { return PageHelper.toJson(PageHelper.ReturnValue(false, "该客户正在被带客!")); } //查询客户信息 var sech2 = new ClientInfoSearchCondition { Clientname = brokerleadclient.Clientname, Phone = brokerleadclient.Phone.ToString(CultureInfo.InvariantCulture), }; var cmodel2 = _clientInfoService.GetClientInfosByCondition(sech2).FirstOrDefault(); if (cmodel2 == null) { return PageHelper.toJson(PageHelper.ReturnValue(false, "带客出错!")); } //查询经纪人信息 var broker = _brokerService.GetBrokerByUserId(brokerleadclient.Adduser); //创建代客流程 var model = new BrokerLeadClientEntity(); model.Broker = _brokerService.GetBrokerById(brokerleadclient.Adduser); model.ClientInfo = cmodel2; model.ClientName = brokerleadclient.Clientname; model.Appointmenttime = Convert.ToDateTime(brokerleadclient.Appointmenttime); //model.Qq = Convert.ToInt32(brokerrecclient.Qq); model.Phone = brokerleadclient.Phone; //客户电话 model.Brokername = broker.Brokername; //model.BrokerLevel = broker.Level.Name; model.Broker = broker; model.Adduser = brokerleadclient.Adduser; model.Addtime = DateTime.Now; model.Upuser = brokerleadclient.Adduser; model.Uptime = DateTime.Now; //model.ProjectId = brokerleadclient.Id; model.ProjectId = brokerleadclient.Projectid; model.Projectname = brokerleadclient.Projectname; model.Status = EnumBLeadType.预约中; model.DelFlag = EnumDelFlag.默认; model.ComOrder = (int)EnumOrderType.带客订单; model.Details = brokerleadclient.Note; _brokerleadclientService.Create(model); return PageHelper.toJson(PageHelper.ReturnValue(true, "提交成功")); }