public ActionResult List(int offset, int limit, string search) { IQueryable <InfoBanner> articles; if (string.IsNullOrEmpty(search)) { articles = repository.GetAllList(offset, limit); } else { articles = repository.GetAllList(offset, limit, m => m.title.Contains(search)); } var total = repository.Count(); return(Jsonp(new { total = total, rows = articles }, JsonRequestBehavior.AllowGet)); } // GET: Users/Details/5
public ActionResult List(int offset, int limit, string search) { IQueryable <TotalMessage> articles; if (string.IsNullOrEmpty(search)) { articles = repository.GetAllList(offset, limit); } else { articles = repository.GetAllList(offset, limit, m => m.remark.Contains(search)); } var total = repository.Count(); return(Jsonp(new { total = total, rows = articles }, JsonRequestBehavior.AllowGet)); }
public async Task <JsonpResult> List(int offset, int limit, string search, long categoryid) { IQueryable <Article> articles; var total = 0; if (string.IsNullOrEmpty(search)) { if (categoryid != 0L) { var allC = await GetAllCategoriesByIdAsync(categoryid); articles = repository.GetAllList(offset, limit, m => m.categoryId, allC.ToArray()); total = repository.Count(m => m.categoryId, allC.ToArray()); } else { articles = repository.GetAllList(offset, limit); total = repository.Count(); } } else { if (categoryid != 0L) { var allC = await GetAllCategoriesByIdAsync(categoryid); articles = repository.GetAllList(offset, limit, m => m.title.Contains(search) || m.creatorName.Contains(search), m => m.categoryId, allC.ToArray()); total = repository.Count(m => m.title.Contains(search) || m.creatorName.Contains(search), m => m.categoryId, allC.ToArray()); } else { articles = repository.GetAllList(offset, limit, m => m.title.Contains(search) || m.creatorName.Contains(search)); total = repository.Count(m => m.title.Contains(search) || m.creatorName.Contains(search)); } } //var result = Mapper.Map<IQueryable<User>, IList<UserDto>>(users); return(Jsonp(new { total = total, rows = articles }, JsonRequestBehavior.AllowGet)); }
public ActionResult List(int offset, int limit, string search, long?id) { if (id == null) { return(Jsonp(new { total = 0, rows = 0 }, JsonRequestBehavior.AllowGet)); } IQueryable <ArticleComment> articles; if (string.IsNullOrEmpty(search)) { articles = repository.GetAllList(offset, limit, m => m.articleId == id); } else { articles = repository.GetAllList(offset, limit, m => (m.contents.Contains(search) || m.creatorName.Contains(search)) && m.articleId == id); } var total = repository.Count(); return(Jsonp(new { total = total, rows = articles }, JsonRequestBehavior.AllowGet)); }
public JsonpResult List(int offset, int limit, string search) { IList <ArticleCategory> oldList; if (string.IsNullOrEmpty(search)) { oldList = easonRepository.GetAllList(offset, limit).ToList(); } else { oldList = easonRepository.GetAllList(offset, limit, m => m.title.Contains(search)).ToList(); } //原始根 var roots = oldList.Where(i => i.parentId == 0); //获取所有父亲 var parents = oldList.GroupBy(m => m.parentId).Select(x => x.FirstOrDefault()).Where(i => i.parentId != 0).OrderBy(m => m.id).ToList(); var newList = new List <ArticleCategory>(); foreach (var item in roots) { parents.Add(item); // newList.Add(item); } parents = parents.OrderBy(m => m.parentId).ToList(); for (int i = 0; i < parents.Count(); i++) { if (!newList.Contains(parents[i])) { newList.Add(parents[i]); GetChild(parents[i].id, oldList, newList); } } var total = easonRepository.Count(); return(Jsonp(new { total = total, rows = newList }, JsonRequestBehavior.AllowGet)); }
public async System.Threading.Tasks.Task <ActionResult> Index(string phone) { var result = new ResultModel(); if (string.IsNullOrEmpty(phone)) { result.Code = 1001; result.Message = " 手机号格式不正确 "; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } if (!Utility.RegexUtils.IsPhone(phone)) { result.Code = 1002; result.Message = " 手机号格式不正确 "; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } var res = new EasonRepository <User, long>(); if (res.Count(m => m.telephone == phone) > 0) { result.Code = 1003; result.Message = " 该手机号已经注册过了 "; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } var date = DateTime.Now.AddMinutes(-1); var re = repository.FirstOrDefault(m => m.telephone == phone && m.creationTime > date); if (re != null) { result.Code = 1004; result.Message = " 请一分钟后再次发送 "; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } date = DateTime.Now.AddMinutes(60); if (repository.Count(m => m.ip == UserHostAddress && m.creationTime > date) > 1000) { result.Code = 1005; result.Message = " 该IP一小时内发送的短信数量过多"; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } IMessageService service = new MessageService(); try { var msg = new ShortMessage(); msg.creatorId = 1; msg.creatorName = "注册用户"; msg.creationTime = DateTime.Now; msg.telephone = phone; msg.code = new Random().Next(1000, 9999); msg.content = "验证码" + msg.code + ",您正在注册成为匹优爱用户,感谢您的支持!"; msg.ip = UserHostAddress; await repository.InsertAsync(msg); await repository.UnitOfWork.CommitAsync(); service.Register(msg.code.ToString(), msg.telephone); result.Code = 0; result.Message = string.Empty; result.Data = "发送成功!"; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { result.Code = 1001; result.Message = ex.Message; return(Jsonp(result, JsonRequestBehavior.AllowGet)); } }