public IActionResult TestLogin()
{
try
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
UserInfo userInfo = new UserInfo()
{
id = 1,
Email = "Test",
AuthRole = new List <AuthRole>()
{
AuthRole.User
}
};
string token = Guid.NewGuid().ToString();
AuthRedis.SetToken(userInfo, token, LoginType.LimitWeb);
return(Ok(new ApiResponse(new { token })));
}
catch (Exception ex)
{
Log.Error(ex.Message);
throw ex;
}
}
public IActionResult PictureUpload(PictureDto body)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
if (!string.IsNullOrEmpty(body.PictureTitle) && !string.IsNullOrEmpty(body.PictureExplain))
{
string token = _httpContext.HttpContext.Request.Headers["Authorization"];
AuthRedis.GetUserByToken(token, out UserInfo userInfo);
PictureInfo PictureInfos = new PictureInfo()
{
Id = SequenceID.GetSequenceID(),
CreateTime = DateTime.Now,
Disable = false,
PictureContent = body.url,
UserID = userInfo.id,
LastModifiedTime = DateTime.Now,
PictureExplain = body.PictureExplain,
PictureTitle = body.PictureTitle,
RecommendIndex = body.Index,
PictureType = body.PictureType,
PhotoType = body.PhotoType
};
context.Add(PictureInfos);
context.SaveChanges();
PictureRedis.Del();
}
return(Ok(new ApiResponse()));
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult WordDel(long id)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
var wordinfo = context.WordInfo.Single(x => x.Id == id);
wordinfo.Disable = true;
context.SaveChanges();
return(Ok(new ApiResponse()));
}
//[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult PhotoList(PhotoType photoType)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
int total = 0;
List <PictureListDto> PictureListDtos = new List <PictureListDto>();
if (!PictureRedis.GetAll(out List <PictureInfo> Picture))
{
Picture = context.PictureInfo.Where(x => x.Disable == false).Include(x => x.Users).ToList();
total = Picture.Count();
if (Picture != null && Picture.Count > 0)
{
PictureRedis.SaveAll(Picture);
}
Picture = Picture.Where(x => x.Disable == false && x.PictureType == PictureType.Product && x.PhotoType == photoType).OrderByDescending(x => x.RecommendIndex).ToList();
foreach (var item in Picture)
{
PictureListDto PictureListDto = new PictureListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
Index = item.RecommendIndex,
UserName = item.Users.UserName,
PictureExplain = item.PictureExplain,
PictureTitle = item.PictureTitle,
PictureUrl = item.PictureContent,
PictureType = item.PictureType
};
PictureListDtos.Add(PictureListDto);
}
}
else
{
total = Picture.Count();
Picture = Picture.Where(x => x.Disable == false && x.PictureType == PictureType.Product && x.PhotoType == photoType).OrderByDescending(x => x.RecommendIndex).ToList();
foreach (var item in Picture)
{
PictureListDto PictureListDto = new PictureListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
Index = item.RecommendIndex,
UserName = item.Users.UserName,
PictureExplain = item.PictureExplain,
PictureTitle = item.PictureTitle,
PictureUrl = item.PictureContent,
PictureType = item.PictureType
};
PictureListDtos.Add(PictureListDto);
}
}
return(Ok(new ApiResponse(PictureListDtos, total)));
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult WordDetails(long ID)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
var wordList = context.WordInfo.Single(x => x.Disable == false && x.Id == ID);
WordLessDto WordInfos = new WordLessDto()
{
CreateTime = wordList.CreateTime,
HtmlContent = wordList.HtmlContent,
HtmlExplain = wordList.HtmlExplain,
HtmlTitle = wordList.HtmlTitle,
};
return(Ok(new ApiResponse(WordInfos)));
}
//[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult PictureInfo(long ID)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
var WordLists = context.WordInfo.Single(x => x.Disable == false && x.PictureID == ID);
WordInfoDto WordList = new WordInfoDto()
{
CreateTime = WordLists.CreateTime,
HtmlContent = WordLists.HtmlContent,
HtmlExplain = WordLists.HtmlExplain,
HtmlTitle = WordLists.HtmlTitle,
AttachedPath = WordLists.AttachedPath
};
return(Ok(new ApiResponse(WordList)));
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult PictureDel(long id)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
var PictureInfo = context.PictureInfo.Single(x => x.Id == id);
var WordInfo = context.WordInfo.Where(x => x.PictureID == id);
PictureInfo.Disable = true;
foreach (var item in WordInfo)
{
item.Disable = true;
}
context.SaveChanges();
WordRedis.Del();
PictureRedis.Del();
return(Ok(new ApiResponse()));
}
public bool moreAdd(int i)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
Test test = new Test();
for (int j = 0; j <= i; j++)
{
test = new Test()
{
Id = SequenceID.GetSequenceID(),
Name = "hangfire"
};
context.Add(test);
context.SaveChanges();
}
TestRedis.Del();
return(true);
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult PictureDetails(long ID)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
var PictureList = context.PictureInfo.Single(x => x.Disable == false && x.Id == ID);
PictureLessDto PictureDto = new PictureLessDto()
{
CreateTime = PictureList.CreateTime,
PictureUrl = PictureList.PictureContent,
PictureExplain = PictureList.PictureExplain,
PictureTitle = PictureList.PictureTitle,
Index = PictureList.RecommendIndex,
UserName = PictureList.Users.UserName,
PictureType = PictureList.PictureType
};
return(Ok(new ApiResponse(PictureDto)));
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult WordsUpLoad(WordDto body)
{
string token = _httpContext.HttpContext.Request.Headers["Authorization"];
AuthRedis.GetUserByToken(token, out UserInfo userInfo);
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
if (body.Eid == null)
{
int count = context.WordInfo.Where(x => x.PictureID == body.id).Count();
if (count > 0)
{
return(Ok(new ApiResponse(code: CodeAndMessage.已存在对应的资讯文档)));
}
WordInfo WordInfos = new WordInfo()
{
Id = SequenceID.GetSequenceID(),
CreateTime = DateTime.Now,
Disable = false,
HtmlContent = body.HtmlContent,
PictureID = body.id,
LastModifiedTime = DateTime.Now,
HtmlExplain = body.HtmlExplain,
HtmlTitle = body.HtmlTitle,
AttachedPath = body.AttachedPath
};
context.Add(WordInfos);
context.SaveChanges();
WordRedis.Del();
}
else
{
var WordInfo = context.WordInfo.Single(x => x.Id == body.Eid);
WordInfo.LastModifiedTime = DateTime.Now;
WordInfo.HtmlContent = body.HtmlContent;
WordInfo.HtmlExplain = body.HtmlExplain;
WordInfo.HtmlTitle = body.HtmlTitle;
WordInfo.AttachedPath = body.AttachedPath;
context.SaveChanges();
WordRedis.Del();
}
return(Ok(new ApiResponse()));
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult PictureInfo(PictureSelectDto body)
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
int total = 0;
List <PictureListDto> PictureListDtos = new List <PictureListDto>();
if (!PictureRedis.GetAll(out List <PictureInfo> Picture))
{
Picture = context.PictureInfo.Where(x => x.Disable == false).Include(x => x.Users).ToList();
total = Picture.Count();
if (Picture != null && Picture.Count > 0)
{
PictureRedis.SaveAll(Picture);
}
if (body.StartTime != null)
{
Picture = Picture.Where(x => x.CreateTime >= body.StartTime).ToList();
}
if (body.EndTime != null)
{
Picture = Picture.Where(x => x.CreateTime <= body.EndTime).ToList();
}
if (body.PictureType != null)
{
Picture = Picture.Where(x => x.PictureType == body.PictureType).ToList();
}
Picture = Picture.OrderByDescending(x => x.RecommendIndex).Skip(body.pageSize * (body.pageNum - 1)).Take(body.pageSize).ToList();
foreach (var item in Picture)
{
PictureListDto PictureListDto = new PictureListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
Index = item.RecommendIndex,
UserName = item.Users.UserName,
PictureExplain = item.PictureExplain,
PictureTitle = item.PictureTitle,
PictureUrl = item.PictureContent,
PictureType = item.PictureType
};
PictureListDtos.Add(PictureListDto);
}
}
else
{
total = Picture.Count();
if (body.StartTime != null)
{
Picture = Picture.Where(x => x.CreateTime >= body.StartTime).ToList();
}
if (body.EndTime != null)
{
Picture = Picture.Where(x => x.CreateTime <= body.EndTime).ToList();
}
if (body.PictureType != null)
{
Picture = Picture.Where(x => x.PictureType == body.PictureType).ToList();
}
Picture = Picture.OrderByDescending(x => x.RecommendIndex).Skip(body.pageSize * (body.pageNum - 1)).Take(body.pageSize).ToList();
foreach (var item in Picture)
{
PictureListDto PictureListDto = new PictureListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
Index = item.RecommendIndex,
UserName = item.Users.UserName,
PictureExplain = item.PictureExplain,
PictureTitle = item.PictureTitle,
PictureUrl = item.PictureContent,
PictureType = item.PictureType
};
PictureListDtos.Add(PictureListDto);
}
}
return(Ok(new ApiResponse(PictureListDtos, total)));
}
//[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult PictureList()
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
int total = 0;
List <PictureListDto> PictureListDtos = new List <PictureListDto>();
if (!PictureRedis.GetAll(out List <PictureInfo> Picture))
{
Picture = context.PictureInfo.Where(x => x.Disable == false).OrderByDescending(x => x.RecommendIndex).Include(x => x.Users).ToList();
total = Picture.Count();
if (Picture != null && Picture.Count > 0)
{
PictureRedis.SaveAll(Picture);
}
string token = _httpContext.HttpContext.Request.Headers["Authorization"];
if (string.IsNullOrEmpty(token))
{
Picture = Picture.Where(x => x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).Skip(0).Take(4).ToList();
}
else
{
if (!AuthRedis.GetUserByToken(token, out UserInfo userInfo))
{
Picture = Picture.Where(x => x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).Skip(0).Take(4).ToList();
}
else
{
//注册账号时间不能超过俩个小时
if (DateTime.Now.Hour - userInfo.CreateTime.Hour > 2 && userInfo.LoginType.First() != LoginType.FreeWeb)
{
Picture = Picture.Where(x => x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).Skip(0).Take(4).ToList();
}
}
Picture = Picture.Where(x => x.Disable == false && x.PictureType == PictureType.News).ToList();
}
foreach (var item in Picture)
{
PictureListDto PictureListDto = new PictureListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
Index = item.RecommendIndex,
UserName = item.Users.UserName,
PictureExplain = item.PictureExplain,
PictureTitle = item.PictureTitle,
PictureUrl = item.PictureContent,
PictureType = item.PictureType
};
PictureListDtos.Add(PictureListDto);
}
}
else
{
total = Picture.Count();
string token = _httpContext.HttpContext.Request.Headers["Authorization"];
if (string.IsNullOrEmpty(token))
{
Picture = Picture.Where(x => x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).Skip(0).Take(4).ToList();
}
else
{
if (!AuthRedis.GetUserByToken(token, out UserInfo userInfo))
{
Picture = Picture.Where(x => x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).Skip(0).Take(4).ToList();
}
else
{
//注册账号时间不能超过俩个小时
if (DateTime.Now.Hour - userInfo.CreateTime.Hour > 2 && userInfo.LoginType.First() != LoginType.FreeWeb)
{
Picture = Picture.Where(x => x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).Skip(0).Take(4).ToList();
}
}
Picture = Picture.Where(x => x.Disable == false && x.PictureType == PictureType.News).OrderByDescending(x => x.RecommendIndex).ToList();
}
foreach (var item in Picture)
{
PictureListDto PictureListDto = new PictureListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
Index = item.RecommendIndex,
UserName = item.Users.UserName,
PictureExplain = item.PictureExplain,
PictureTitle = item.PictureTitle,
PictureUrl = item.PictureContent,
PictureType = item.PictureType
};
PictureListDtos.Add(PictureListDto);
}
}
return(Ok(new ApiResponse(PictureListDtos, total)));
}
[AuthFilter]//身份认证，不带token或者token错误会被拦截器拦截进不来这个接口
public IActionResult WordInfo(WordSelectDto body)
{
int total = 0;
List <WordListDto> wordListDtos = new List <WordListDto>();
if (!WordRedis.GetAll(out List <WordInfo> Word))
{
using EFCoreContextWrite context = new EFCore.EFCoreContextWrite();
Word = context.WordInfo.Where(x => x.Disable == false).Include(x => x.PictureInfos).Include(x => x.PictureInfos.Users).ToList();
total = Word.Count();
if (Word != null && Word.Count > 0)
{
WordRedis.SaveAll(Word);
}
if (body.StartTime != null)
{
Word = Word.Where(x => x.CreateTime >= body.StartTime).ToList();
}
if (body.EndTime != null)
{
Word = Word.Where(x => x.CreateTime <= body.EndTime).ToList();
}
Word = Word.OrderByDescending(x => x.CreateTime).Skip(body.pageSize * (body.pageNum - 1)).Take(body.pageSize).ToList();
foreach (var item in Word)
{
WordListDto WordInfos = new WordListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
HtmlContent = item.HtmlContent,
HtmlExplain = item.HtmlExplain,
UserName = item.PictureInfos.Users.UserName,
HtmlTitle = item.HtmlTitle,
PictureTitle = item.PictureInfos.PictureTitle
};
wordListDtos.Add(WordInfos);
}
return(Ok(new ApiResponse(wordListDtos, total)));
}
else
{
total = Word.Count();
Word = Word.OrderByDescending(x => x.CreateTime).Skip(body.pageSize * (body.pageNum - 1)).Take(body.pageSize).ToList();
foreach (var item in Word)
{
WordListDto WordInfos = new WordListDto()
{
ID = item.Id,
CreateTime = item.CreateTime,
HtmlContent = item.HtmlContent,
HtmlExplain = item.HtmlExplain,
UserName = item.PictureInfos.Users.UserName,
HtmlTitle = item.HtmlTitle,
PictureTitle = item.PictureInfos.PictureTitle
};
wordListDtos.Add(WordInfos);
}
return(Ok(new ApiResponse(wordListDtos, total)));
}
}