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 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 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 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, "提交成功")));
}
