private async Task <List <SnArticle> > GetTagtext(int tag, bool isDesc) { var data = await CreateService <SnArticle>().Where(s => s.label_id == tag, c => c.article_id, isDesc).Select(s => new { s.article_id, s.title, s.title_text, s.time, s.give, s.read }).ToListAsync(); var list = new List <SnArticle>(); foreach (var t in data) { var s = new SnArticle(); s.article_id = t.article_id; s.title = t.title; s.title_text = t.title_text; s.time = t.time; s.give = t.give; s.read = t.read; list.Add(s); } return(list); }
/// <summary> /// 读取分页数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="isDesc"></param> /// <returns></returns> private async Task <List <SnArticle> > GetFyTitle(int pageIndex, int pageSize, bool isDesc) { var data = await Task.Run(() => CreateService <SnArticle>().Wherepage(s => true, c => c.article_id, pageIndex, pageSize, out _, isDesc).Select(s => new { s.article_id, s.title, s.comment, s.give, s.read, s.time, s.title_text, s.user_id }).ToList()); //解决方案二:foreach遍历 var list = new List <SnArticle>(); foreach (var t in data) { var s = new SnArticle(); s.article_id = t.article_id; s.title = t.title; s.comment = t.comment; s.give = t.give; s.read = t.read; s.time = t.time; s.title_text = t.title_text; s.user_id = t.user_id; list.Add(s); } return(list); }
public async Task <string> UpdateAsync(SnArticle entity) { int result = await CreateService <SnArticle>().UpdateAsync(entity); string Func(int data) => data == 1 ? "更新成功" : "更新失败"; return(Func(result)); }
private async Task <List <SnArticle> > GetTagtext(int tag, bool isDesc) { if (isDesc) { var data = await _service.SnArticle.Where(s => s.label_id == tag).Select(s => new { s.article_id, s.title, s.title_text, s.time, s.give, s.read }).OrderByDescending(s => s.article_id).ToListAsync(); var list = new List <SnArticle>(); foreach (var t in data) { var s = new SnArticle(); s.article_id = t.article_id; s.title = t.title; s.title_text = t.title_text; s.time = t.time; s.give = t.give; s.read = t.read; list.Add(s); } return(list); } else { var data = await _service.SnArticle.Where(s => s.label_id == tag).Select(s => new { s.article_id, s.title, s.title_text, s.time, s.give, s.read }).OrderBy(s => s.article_id).ToListAsync(); var list = new List <SnArticle>(); foreach (var t in data) { var s = new SnArticle(); s.article_id = t.article_id; s.title = t.title; s.title_text = t.title_text; s.time = t.time; s.give = t.give; s.read = t.read; list.Add(s); } return(list); } }
public async Task <SnArticle> GetByIdAsync(int id) { SnArticle result = null; result = _cacheutil.CacheString("GetByIdAsync" + id, result); if (result == null) { result = await CreateService <SnArticle>().GetByIdAsync(id); _cacheutil.CacheString("GetByIdAsync" + id, result); } return(result); }
public async Task <SnArticle> AsyGetTestName(int id) { SnArticle result = null; result = _cacheutil.CacheString("AsyGetTestName" + id, result); if (result == null) { result = await _service.SnArticle.FindAsync(id); _cacheutil.CacheString("AsyGetTestName" + id, result); } return(result); }
public async Task <bool> UpdatePortionAsync(SnArticle snArticle, string type) { var date = _service.SnArticle.Update(snArticle); //默认不更新 date.Property("user_id").IsModified = false; date.Property("title").IsModified = false; date.Property("title_text").IsModified = false; date.Property("text").IsModified = false; date.Property("time").IsModified = false; date.Property("label_id").IsModified = false; date.Property("give").IsModified = false; date.Property("read").IsModified = false; date.Property("comment").IsModified = false; date.Property("sort_id").IsModified = false; date.Property("type_title").IsModified = false; date.Property("url_img").IsModified = false; switch (type) { //指定字段进行更新操作 case "read": date.Property(type).IsModified = true; break; case "give": date.Property(type).IsModified = true; break; case "comment": date.Property(type).IsModified = true; break; default: return(false); } return(await _service.SaveChangesAsync() > 0); }
public async Task <IActionResult> UpdatePortionAsync(SnArticle entity, string type) { return(Ok(await _service.UpdatePortionAsync(entity, type))); }
public async Task <IActionResult> UpdateAsync(SnArticle entity) { var data = await _service.UpdateAsync(entity); return(Ok(data)); }
public async Task <ActionResult <SnArticle> > AddAsync(SnArticle entity) { return(Ok(await _service.AddAsync(entity))); }
public async Task <bool> UpdatePortionAsync(SnArticle snArticle, string name) { var date = await CreateService <SnArticle>().UpdateAsync1(snArticle, true, name); return(date); }
public async Task <SnArticle> AddAsync(SnArticle entity) { return(await CreateService <SnArticle>().AddAsync(entity)); }
public async Task <IActionResult> UpdateAsync(SnArticle entity) { return(Ok(await _service.UpdateAsync(entity))); }
/// <summary> /// 读取分页数据 /// </summary> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="isDesc"></param> /// <returns></returns> private async Task <List <SnArticle> > GetFyTitle(int pageIndex, int pageSize, bool isDesc) { if (isDesc) //降序 { var data = await _service.SnArticle.Where(s => true).Select(s => new { s.article_id, s.title, s.comment, s.give, s.read, s.time, s.title_text, s.user_id }).OrderByDescending(c => c.article_id).Skip((pageIndex - 1) * pageSize) .Take(pageSize).ToListAsync(); //解决方案二:foreach遍历 var list = new List <SnArticle>(); foreach (var t in data) { var s = new SnArticle(); s.article_id = t.article_id; s.title = t.title; s.comment = t.comment; s.give = t.give; s.read = t.read; s.time = t.time; s.title_text = t.title_text; s.user_id = t.user_id; list.Add(s); } return(list); } else { var data = await _service.SnArticle.Where(s => true).Select(s => new { s.article_id, s.title, s.comment, s.give, s.read, s.time, s.title_text, s.user_id }).OrderBy(c => c.article_id).Skip((pageIndex - 1) * pageSize) .Take(pageSize).ToListAsync(); var list = new List <SnArticle>(); foreach (var t in data) { var s = new SnArticle(); s.article_id = t.article_id; s.title = t.title; s.comment = t.comment; s.give = t.give; s.read = t.read; s.time = t.time; s.title_text = t.title_text; s.user_id = t.user_id; list.Add(s); } return(list); } }
public async Task <bool> UpdateAsync(SnArticle entity) { _service.SnArticle.Update(entity); return(await _service.SaveChangesAsync() > 0); }
/// <summary> /// 添加数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public async Task <bool> AddAsync(SnArticle entity) { await _service.SnArticle.AddAsync(entity); return(await _service.SaveChangesAsync() > 0); }