/// <summary>
/// 激活ID
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Pass(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
AgentSearchResult result = new AgentSearchResult();
CommonService <AgentEntity> cs = new CommonService <AgentEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(id);
if (User == null)
{
//没有值就返回null
result.AgentList = null;
return(0);
}
//已经开通
if (User.Flag == 1)
{
return(1);
}
else
{
User.OpenTime = DateTime.Now;
User.Flag = 1;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 删除ID
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Del(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
AgentSearchResult result = new AgentSearchResult();
CommonService <AgentEntity> cs = new CommonService <AgentEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(id);
if (User == null)
{
//没有值就返回null
result.AgentList = null;
return(0);
}
//删除
if (User.Flag >= 1)
{
return(1);
}
else
{
User.IsDeleted = true;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 分页
/// </summary>
/// <param name="Id"></param>
/// <param name="usercode"></param>
/// <param name="Level"></param>
/// <param name="Strat"></param>
/// <param name="End"></param>
/// <param name="i">I为0就是查询未开通</param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public PartialViewResult MemberGetPage(string Id, string usercode, DateTime?Strat, DateTime?End, int i, int pageIndex = 1)
{
AgentListViewModel model = new AgentListViewModel();
AgentSearchResult result = agentServeice.GetAgentList(Id, usercode, Strat, End, pageIndex, pageSize, i);
model.AgentListDTO = result.AgentList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
string Table = "";
if (i == 0)
{
Table = "AgentPage";
}
else
{
Table = "AgentListPage";
}
return(PartialView(Table, model));
//return Json(new AjaxResult { Status = "1", Data = model });
}
/// <summary>
/// i=0就是查询未开通会员，查询开通会员
/// </summary>
/// <param name="Id">下拉选择值</param>
/// <param name="usercode">输入的UserCode</param>
/// <param name="Level">选择的等级</param>
/// <param name="Strat">开通时间</param>
/// <param name="End">开通时间</param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="i">i=0就是查询未开通会员</param>
/// <returns></returns>
public AgentSearchResult GetAgentList(string Id, string usercode, DateTime?Strat, DateTime?End, int PageIndex, int PageSize, int i)
{
using (MyDbContext dbc = new MyDbContext())
{
CommonService <AgentEntity> cs = new CommonService <AgentEntity>(dbc);
var User = cs.GetAll();
if (i == 0)
{
User = User.Where(a => a.AgentType == 0);
}
AgentSearchResult AgentSearch = new AgentSearchResult();
if (Id != "0")
{
if (usercode != "")
{
if (Id == "1")
{
User = User.Where(p => p.AgentCode.Contains(usercode));
}
}
}
if (Strat != null)
{
User = User.Where(p => p.OpenTime >= Strat);
}
if (End != null)
{
User = User.Where(p => p.OpenTime <= End);
}
AgentSearch.TotalCount = User.LongCount();
AgentSearch.AgentList = User.OrderByDescending(p => p.ID).ToList().Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray();
return(AgentSearch);
}
}
public AgentSearchResult GetPageList(int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
AgentSearchResult result = new AgentSearchResult();
CommonService <AgentEntity> cs = new CommonService <AgentEntity>(dbc);
var User = cs.GetAll();
result.TotalCount = User.LongCount();
result.AgentList = User.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(a => new AgentListDTO {
UserID = a.UserID
}).ToArray();
return(result);
}
}
/// <summary>
/// 查询Agent用户存在不存在
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public AgentSearchResult GetAgentName(string name)
{
using (MyDbContext dbc = new MyDbContext())
{
AgentSearchResult result = new AgentSearchResult();
CommonService <AgentEntity> cs = new CommonService <AgentEntity>(dbc);
//先查询有没有值。
var User = cs.GetAll().Where(p => p.AgentCode == name);
if (User == null)
{
//没有值就返回null
result.AgentList = null;
return(result);
}
else
{
result.AgentList = User.OrderByDescending(p => p.ID).ToList().Where(p => p.AgentCode == name).Select(p => ToAgent(p)).ToArray();
return(result);
}
}
}
public PartialViewResult Agent_Page(string Id, string usercode, DateTime?Strat, DateTime?End, int i, int pageIndex = 1)
{
AgentListViewModel model = new AgentListViewModel();
AgentSearchResult result = agentServeice.GetAgentList(Id, usercode, Strat, End, pageIndex, pageSize, i);
model.AgentListDTO = result.AgentList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(PartialView("AgentPage", model));
}
