public HttpResponseMessage GetRecommendAgentList(EnumRecommendAgentSearchOrderBy orderByAll = EnumRecommendAgentSearchOrderBy.OrderById, bool isDes = true, string name = null, int page = 1, int pageSize = 10)
{
var recomagmentsearchcon = new RecommendAgentSearchCondition
{
Brokername = name,
Page = Convert.ToInt32(page),
PageCount = pageSize,
OrderBy =orderByAll ,
isDescending =isDes
};
var recommendAgentList = _recommendagentService.GetRecommendAgentsByCondition(recomagmentsearchcon).Select(p => new
{
BBrokername = p.Brokername,
PresenteebId = p.PresenteebId,
Brokername = p.Broker.Brokername,
}).ToList();
var partnerListCount = _recommendagentService.GetRecommendAgentCount(recomagmentsearchcon);
return PageHelper.toJson(new { List = recommendAgentList, Condition = recomagmentsearchcon, totalCount = partnerListCount });
}
public HttpResponseMessage GetRecommendAgentListById(int id = 0)
{
var recomagmentsearchcon = new RecommendAgentSearchCondition
{
PresenteebId = id
};
var recommendAgentList = _recommendagentService.GetRecommendAgentsByCondition(recomagmentsearchcon).Select(p => new
{
BBrokername = p.Brokername,
phone = p.Broker.Phone,
regtime = p.Broker.Regtime,
agentlevel = p.Broker.Agentlevel,
Brokername = p.Broker.Brokername,
Nickname = p.Broker.Nickname,
Headphono = p.Broker.Headphoto,
Amount = p.Broker.Amount,
Sfz = p.Broker.Sfz,
}).ToList();
var partnerListCount = _recommendagentService.GetRecommendAgentCount(recomagmentsearchcon);
return PageHelper.toJson(new { List = recommendAgentList, Condition = recomagmentsearchcon, totalCount = partnerListCount });
}
public HttpResponseMessage GetRecommendAgentListByUserId(string userId)
{
var recomagmentsearchcon = new RecommendAgentSearchCondition
{
BrokerId = Convert.ToInt32(userId)
};
return PageHelper.toJson(_recommendagentService.GetRecommendAgentsByCondition(recomagmentsearchcon).Select(p => new
{
p.Phone,
p.Qq,
p.Brokername,
p.Agentlevel,
p.Id
}).ToList());
}
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<RecommendAgentEntity> GetRecommendAgentsByCondition(RecommendAgentSearchCondition condition)
{
var query = _recommendagentRepository.Table;
try
{
if (condition.RegtimeBegin.HasValue)
{
query = query.Where(q => q.Regtime>= condition.RegtimeBegin.Value);
}
if (condition.RegtimeEnd.HasValue)
{
query = query.Where(q => q.Regtime < condition.RegtimeEnd.Value);
}
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 == condition.Phone);
}
if (!string.IsNullOrEmpty(condition.Qq))
{
query = query.Where(q => q.Qq == condition.Qq);
}
if (condition.PresenteebId>0)
{
query = query.Where(q => q.PresenteebId == condition.PresenteebId );
}
if (!string.IsNullOrEmpty(condition.Brokername))
{
query = query.Where(q => q.Brokername.Contains(condition.Brokername));
}
if (!string.IsNullOrEmpty(condition.Agentlevel))
{
query = query.Where(q => q.Agentlevel.Contains(condition.Agentlevel));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if (!string.IsNullOrEmpty(condition.BrokerId.ToString()) && condition.BrokerId!=0 )
{
query = query.Where(q => q.Broker.Id == condition.BrokerId);
}
if (condition.PresenteebIds != null && condition.PresenteebIds.Any())
{
query = query.Where(q => condition.PresenteebIds.Contains(q.PresenteebId));
}
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.OrderBy.HasValue)
{
switch (condition.OrderBy.Value)
{
case EnumRecommendAgentSearchOrderBy.OrderById:
query = condition.isDescending?query.OrderByDescending(q=>q.Id):query.OrderBy(q=>q.Id);
break;
case EnumRecommendAgentSearchOrderBy.OrderByBBrokername:
query = condition.isDescending ? query.OrderByDescending(q => q.Brokername) : query.OrderBy(q => q.Brokername);
break;
case EnumRecommendAgentSearchOrderBy.OrderByBrokername:
query = condition.isDescending ? query.OrderByDescending(q => q.Broker.Brokername) : query.OrderBy(q => q.Broker.Brokername);
break;
case EnumRecommendAgentSearchOrderBy.OrderByPresenteebId:
query = condition.isDescending ? query.OrderByDescending(q => q.PresenteebId) : query.OrderBy(q => q.PresenteebId);
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 GetRecommendAgentCount (RecommendAgentSearchCondition condition)
{
var query = _recommendagentRepository.Table;
try
{
if (condition.RegtimeBegin.HasValue)
{
query = query.Where(q => q.Regtime>= condition.RegtimeBegin.Value);
}
if (condition.RegtimeEnd.HasValue)
{
query = query.Where(q => q.Regtime < condition.RegtimeEnd.Value);
}
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 == condition.Phone);
}
if (!string.IsNullOrEmpty(condition.Qq))
{
query = query.Where(q => q.Qq == condition.Qq);
}
if (!string.IsNullOrEmpty(condition.Brokername))
{
query = query.Where(q => q.Brokername.Contains(condition.Brokername));
}
if (!string.IsNullOrEmpty(condition.Agentlevel))
{
query = query.Where(q => q.Agentlevel.Contains(condition.Agentlevel));
}
if (condition.Ids != null && condition.Ids.Any())
{
query = query.Where(q => condition.Ids.Contains(q.Id));
}
if ( !string.IsNullOrEmpty( condition.BrokerId.ToString()) )
{
query = query.Where(q =>q.Broker.Id==condition.BrokerId);
}
if (condition.PresenteebIds != null && condition.PresenteebIds.Any())
{
query = query.Where(q => condition.PresenteebIds.Contains(q.PresenteebId));
}
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));
}
return query.Count();
}
catch(Exception e)
{
_log.Error(e,"数据库操作出错");
return -1;
}
}