/// <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)); }