/// <summary>
/// 包含详细信息
/// </summary>
/// <param name="searchView"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public PagedList <TopicDetailView> GetTopicInfoList(ArticleTopicSearchView searchView, int pageIndex, int pageSize)
{
var expression = base.GetFilterEnabled();
var order = base.Order();
if (searchView.IgnoreCate.HasValue && searchView.IgnoreCate == true)
{
expression = expression.And(w => w.ParentId != null);
if (!searchView.ParentId.IsEmpty())
{
expression = expression.And(w => searchView.ParentId.Contains(w.ParentId));
}
}
else
{
if (searchView.ParentId == null)
{
expression = expression.And(w => w.ParentId == null);
}
else
{
expression = expression.And(w => searchView.ParentId.Contains(w.ParentId));
}
}
if (!searchView.TopicId.IsEmpty())
{
expression = expression.And(w => w.Id == searchView.TopicId);
}
if (searchView.HotTopic.HasValue && searchView.HotTopic.Value)
{
order = o => o.OrderByDescending(w => w.ReadCount);
}
var data = _Respository.GetPagedList(u => new TopicDetailView
{
Id = u.Id,
Title = u.Title,
CreatorTime = u.CreatorTime,
ParentId = u.ParentId,
ShortTitle = u.ShortTitle,
CoverUrl = u.CoverUrl,
BigCoverUrl = u.BigCoverUrl,
ReadCount = u.ReadCount,
MemberId = u.CreatorUserId,
PackageAmount = u.PackageAmount,
TopicStatus = u.TopicStatus,
MemberName = "admin",
ResourceCount = u.ResourceCount
}, expression, pageIndex, pageSize, o => o.OrderBy(b => b.SortCode));
var parentIds = data.Where(w => w.ParentId != null).Select(u => u.Id).Distinct().ToList();
Dictionary <string, int> valuePairs = new Dictionary <string, int>();
if (parentIds.Any())
{
//资源数量统计
if (parentIds.Any())
{
var articleService = CoreContextProvider.GetService <IArticleRespository>();
valuePairs = articleService.GetStaticsCount(parentIds, true);
}
}
//默认全是管理员
List <Member> memberDics = new List <Member>();
var memberIds = data.Where(w => w.MemberId != null).Select(u => u.MemberId).Distinct().ToArray();
if (memberIds.Any())
{
var memberRespository = CoreContextProvider.GetService <IMemberRespository>();
memberDics = memberRespository.GetMemberInfos(memberIds);
}
//相关用户统计
data.ForEach(cate =>
{
var statics = valuePairs.TryGetValue(cate.Id);
if (cate.ResourceCount == 0 && parentIds.Any())
{
cate.ResourceCount = statics;
}
if (memberDics.Any())
{
var mem = memberDics.Where(w => w.Id == cate.MemberId).FirstOrDefault();
if (mem != null)
{
cate.MemberName = mem.UserName;
cate.MemHeader = mem.HeadIcon;
cate.UserLevel = mem.UserLevel;
}
}
});
return(data);
}
/// <summary>
/// 审核专题
/// </summary>
/// <param name="id"></param>
/// <param name="auditStatus"></param>
/// <returns></returns>
public InvokeResult <bool> AuditTopic(string id, int auditStatus, string auditMessage)
{
var entity = GetForm(id);
if (entity.TopicStatus == (int)TopicStatus.Audited)
{
return(RequestResult.Failed <bool>("该专题已审核成功，不能重复审核！"));
}
entity.TopicStatus = auditStatus;
entity.EnabledMark = true;
entity.AuditMessage = auditMessage;
//审核其他文件操作
using (var tran = _Respository.BeginTransaction())
{
try
{
var b = false;
var articles = new List <Article>();
//先处理文件
string[] unZipFiles = new string[] { };
if (auditStatus == (int)TopicStatus.Audited && !entity.Attachment.IsEmpty())
{
//后台审核通过时写入
//压缩包文件 解压，把数据写入文库
if (File.Exists(FileHelper.MapFilePath(entity.Attachment)))
{
var zipfileInfo = new FileInfo(FileHelper.MapFilePath(entity.Attachment));//存在则覆盖
var unzipDir = FileDownHelper.UnZip(zipfileInfo.FullName, zipfileInfo.FullName.Replace(zipfileInfo.Extension, "topic"));
unZipFiles = Directory.GetFiles(unzipDir);
if (!unZipFiles.Any())
{
tran.Rollback();
return(RequestResult.Failed <bool>("资源解压后无文件，审核失败"));
}
System.Threading.Thread.Sleep(800);
foreach (var file in unZipFiles)
{
var extension = FileHelper.GetExtension(file);
var dir = $"/{ConfigManager.SysConfiguration.UploadFolder}/{DateTime.Now.ToString("yyyyMMdd")}";
if (!Directory.Exists(FileHelper.MapFilePath(dir)))
{
Directory.CreateDirectory(FileHelper.MapFilePath(dir));
}
var newFileName = $"{dir}/{Common.GuId().Replace("-", "")}{extension}";
FileHelper.CopyFile(file, FileHelper.MapFilePath(newFileName));
var title = FileHelper.GetFileName(file, false);
var article = new Article()
{
Title = title,
ShortTitle = title,
Keyword = title,
Description = title,
Attachment = newFileName,
AllowDownload = false,
SpecialTopicId = id,
IsOnline = true,
MemberId = entity.CreatorUserId,
OnlinePageCount = 5,
RequireAmount = 0,
PageCount = 5,
ResourceSize = (int)FileHelper.GetFileSize(file),
ResourceType = extension.Replace(".", ""),
BookStatus = (int)BookStatus.审核通过,
HasImages = true,
};
articles.Add(article);
b = _ArticleRespository.CreateOrUpdate(article);
if (!b)
{
tran.Rollback();
return(RequestResult.Failed <bool>("解压数据处理失败"));
}
CoreContextProvider.ConvertFileToImage(article.Attachment.Split(',').ToList(), article.PageCount, _logger);
}
}
}
//后处理专题
if (!articles.Any())
{
tran.Rollback();
return(RequestResult.Failed <bool>("审核解压后文档数为0，审核失败！"));
}
entity.ResourceCount = articles.Count;
b = _Respository.UpdateFields(entity, "TopicStatus", "AuditMessage", "ResourceCount", "EnabledMark");
if (!b)
{
tran.Rollback();
return(RequestResult.Failed <bool>("审核失败"));
}
if (!entity.CreatorUserId.IsEmpty())
{
var memberScoreService = CoreContextProvider.GetService <IMemberScoreService>();
b = memberScoreService.AddScore(entity.CreatorUserId, ScoreType.addtopic, id).Success;
if (!b)
{
tran.Rollback();
return(RequestResult.Failed <bool>("审核处理积分失败"));
}
}
if (unZipFiles != null && unZipFiles.Any())
{
//[method.AuditTopic(cea705b9-ae49-40f6-ad4c-bb06fef1ff7d,1)]:Cannot access destination table 'Article'.
//insert into articles
//articleService.AddBetch(articles);
}
tran.Commit();
return(RequestResult.Success(true));
}
catch (Exception ex)
{
tran.Rollback();
_logger.LogError($"[method.AuditTopic({id},{auditStatus})]:" + ex.ToString());
return(RequestResult.Failed <bool>("审核失败，数据异常"));
}
}
}
/// <summary>
/// 加载列表
/// </summary>
/// <param name="searchView"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public PagedList <TopicDetailView> GetTopicsList(ArticleTopicSearchView searchView, int pageIndex = 1, int pageSize = 20)
{
var expression = base.GetFilterEnabled();
var order = base.Order();
if (!searchView.Keyword.IsEmpty())
{
expression = expression.And(w => w.Title.Contains(searchView.Keyword));
}
if (searchView.IgnoreCate.HasValue && searchView.IgnoreCate == true)
{
expression = expression.And(w => w.ParentId != null);
if (!searchView.ParentId.IsEmpty())
{
expression = expression.And(w => searchView.ParentId.Contains(w.ParentId));
}
}
else
{
//if (searchView.ParentId == null)
//{
// expression = expression.And(w => w.ParentId == null);
//}
//else
//{
// expression = expression.And(w => searchView.ParentId.Contains(w.ParentId));
//}
if (searchView.ParentId != null)
{
searchView.ParentId = searchView.ParentId.Where(w => !w.IsEmpty()).ToArray();
if (searchView.ParentId.Any())
{
expression = expression.And(w => searchView.ParentId.Contains(w.ParentId));
}
}
}
if (searchView.TopicStatus.HasValue)
{
expression = expression.And(w => w.TopicStatus == (int)searchView.TopicStatus);
}
if (!searchView.MemberId.IsEmpty())
{
expression = expression.And(w => w.CreatorUserId == searchView.MemberId);
}
if (searchView.IsRemmand.HasValue)
{
order = o => o.OrderBy(w => w.SortCode);
}
var data = _Respository.GetPagedList(u => new TopicDetailView
{
Id = u.Id,
Title = u.Title,
CreatorTime = u.CreatorTime,
ParentId = u.ParentId,
ShortTitle = u.ShortTitle,
CoverUrl = u.CoverUrl,
BigCoverUrl = u.BigCoverUrl,
ReadCount = u.ReadCount,
MemberId = u.CreatorUserId,
TopicStatus = u.TopicStatus,
EnabledMark = u.EnabledMark,
Description = u.Description,
SortCode = u.SortCode,
PackageAmount = u.PackageAmount
}, expression, pageIndex, pageSize, order);
if (searchView.IsRemmand.HasValue)
{
var parentIds = data.Select(u => u.Id).ToArray();
var articles = CoreContextProvider.GetService <IArticleService>().GetTopArticles(ArticleTopEnum.NewHotArticle, 14, parentIds);
data.ForEach(cate => {
cate.ArticleDetails = articles.Where(w => w.CategoryId == cate.Id).ToList();
});
}
return(data);
}
SocketHandler(WebSocket socket)
{
logger = CoreContextProvider.GetLogger("SocketHandler");
this.socket = socket;
}
public override void OnActionExecuting(ActionExecutingContext context)
{
_Logger = CoreContextProvider.GetLogger(this.ControllerContext.ActionDescriptor.ControllerTypeInfo.Name);
base.OnActionExecuting(context);
}
/// <summary>
/// 审核状态
/// </summary>
/// <param name="aid"></param>
/// <param name="auditStatus"></param>
/// <returns></returns>
public InvokeResult <bool> AuditArticle(string aid, int auditStatus, string auditMessage)
{
var entity = GetForm(aid);
entity.BookStatus = auditStatus;
entity.AuditMessage = auditMessage;
using (var trans = _Respository.BeginTransaction())
{
try
{
var updateFileds = new List <string>()
{
"BookStatus", "AuditMessage"
};
if (!entity.ResourceType.IsEmpty() && auditStatus == (int)BookStatus.审核通过)
{
if (entity.ResourceType == "pdf" || entity.ResourceType == "doc" || entity.ResourceType == "docx" ||
entity.ResourceType == "ppt" || entity.ResourceType == "pptx" || entity.ResourceType == "xls" ||
entity.ResourceType == "xlsx")
{
entity.HasImages = false;
}
else
{
entity.HasImages = true;
}
//updateFileds.Add("HasImages");
if (entity.CoverUrl.IsEmpty() && !entity.Attachment.IsEmpty())
{
var attFile = entity.Attachment.Split(',')[0];
entity.CoverUrl = $"{attFile.Replace(FileHelper.GetExtension(FileHelper.MapFilePath(attFile)), "")}/{FileHelper.GetFileNameNoExtension(attFile)}1.jpg";
updateFileds.Add("CoverUrl");
}
}
var b = _Respository.UpdateFields(entity, updateFileds.ToArray());
if (!b)
{
trans.Rollback();
return(RequestResult.Failed <bool>("审核处理积分失败"));
}
if (auditStatus == (int)BookStatus.审核通过)
{
//关联专题 数量处理
if (!entity.SpecialTopicId.IsEmpty())
{
var articleTopicRespository = CoreContextProvider.GetService <IArticleTopicRespository>();
var topic = articleTopicRespository.Get(entity.SpecialTopicId);
if (topic != null)
{
topic.ResourceCount++;
if (!articleTopicRespository.UpdateFields(topic, "ResourceCount"))
{
trans.Rollback();
_logger.LogError($"审核时更新{topic.Id}:topic.ResourceCount+1失败！");
return(RequestResult.Failed <bool>("审核处理失败，请重试"));
}
}
}
//积分
var memberScoreService = CoreContextProvider.GetService <IMemberScoreService>();
var scoreResult = memberScoreService.AddScore(entity.MemberId, ScoreType.addbook, aid);
if (!scoreResult.Success)
{
trans.Rollback();
_logger.LogError(scoreResult.Message);
return(RequestResult.Failed <bool>("审核处理积分失败"));
}
}
trans.Commit();
//资源文件生成图片操作
if (!entity.ResourceType.IsEmpty() && auditStatus == (int)BookStatus.审核通过)
{
//if (entity.ResourceType == "pdf" || entity.ResourceType == "doc" || entity.ResourceType == "docx"
// || entity.ResourceType == "ppt" || entity.ResourceType == "pptx" || entity.ResourceType == "xls"
// || entity.ResourceType == "xlsx")
CoreContextProvider.ConvertFileToImage(entity.Attachment.Split(',').ToList(), entity.PageCount, _logger);
}
return(RequestResult.Success(true));
}
catch (Exception ex)
{
trans.Rollback();
_logger.LogError($"[method.AuditArticle({aid},{auditStatus})]:" + ex.Message);
return(RequestResult.Failed <bool>("审核失败，数据异常"));
}
}
}
