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