/// <summary>
/// 删除数据
/// </summary>
/// <param name="id">推文id</param>
public void Delete(int id)
{
ArticleDA.Delete(new ArticleEntity()
{
Id = id, IsDelete = DeletedEnums.Deleted
});
}
public OperationResult <SearchResultData> GetSearchResult(QueryRequest <string> query)
{
var result = new OperationResult <SearchResultData>();
try
{
result.Body = new SearchResultData();
result.Body.Articles = ArticleDA.GetArticleByKey(query);
if (result.Body.Articles == null)
{
result.Body.Articles = new List <ArticleShowData>();
}
result.Body.Lawyers = CustomerDA.GetCustomerByKey(query);
if (result.Body.Lawyers == null)
{
result.Body.Lawyers = new List <CustomerLawyerShowData>();
}
result.ErrCode = 0;
result.Message = "ok";
}
catch (Exception ex)
{
Logger.WriteException("GetShowItems", ex, query);
result.ErrCode = -1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="article">数据实体</param>
public void Update(ArticleVO articleVO)
{
using (ITransaction transaction = TransactionManager.Create())
{
ArticleEntity article = articleVO.ToArticleEntity();
this.CheckEntity(article);
if ((articleVO.ArticleDepartmentList == null || articleVO.ArticleDepartmentList.Count == 0) &&
string.IsNullOrEmpty(articleVO.UserIds))
{
throw new BusinessException("请选择推文对象或填写推送用户");
}
ArticleDA.Update(article);
// 插入用户id数据
if (!string.IsNullOrEmpty(articleVO.UserIds))
{
List <ArticleUser> articleUsers = articleVO.UserIds.Split(new char[] { '|' }).Select(p => new ArticleUser()
{
ArticleId = articleVO.BusinessId, UserId = p
}).ToList();
ArticleDA.BatchInserArticleUser(articleUsers);
}
// 插入分发得公司
transaction.Complete();
}
}
public int AddArticle(ArticleM article)
{
var tran = new TransactionScope();
try
{
//把文章数据写入数据库
var articleDa = new ArticleDA();
articleDa.AddArticle(article);
//为新增加的文章生成静态页面
//文章作者增加积分
//写日志
//提交事务
tran.Complete();
}
catch(Exception ex)
{
throw ex;
}
finally
{
tran.Dispose();
}
return 1;
}
public QueryResultList <ArticleShowData> GetDailyNews(QueryRequest <ArticleQueryData> query)
{
var result = new QueryResultList <ArticleShowData>();
try
{
result = ArticleDA.GetDailyNews(query);
if (result.Body == null)
{
result.Body = new List <ArticleShowData>();
}
result.ErrCode = 0;
result.Message = "ok";
}
catch (Exception ex)
{
Logger.WriteException("GetDailyNews", ex, query);
result.ErrCode = -1;
result.Message = ex.Message;
}
return(result);
}
public OperationResult <ArticleData> GetDetail(RequestOperation <int> request)
{
var result = new OperationResult <ArticleData>();
try
{
var row = ArticleDA.GetDetail(request.Body);
if (row == null)
{
result.ErrCode = 1;
result.Message = "不存在此文章";
}
else
{
result.Body = row;
result.ErrCode = 0;
result.Message = "ok";
}
}
catch (Exception ex)
{
//System.Reflection.MethodInfo.GetCurrentMethod().Name
Logger.WriteException("GetDetail", ex, request);
result.ErrCode = -1;
result.Message = ex.Message;
}
return(result);
}
public OperationResult SetArticleSortNo(RequestOperation <ArticleStatusData> request)
{
var result = new OperationResult();
try
{
var row = ArticleDA.SetArticleSortNo(request);
if (row == 0)
{
result.ErrCode = 1;
result.Message = "设置失败";
}
else
{
result.ErrCode = 0;
result.Message = "ok";
}
}
catch (Exception ex)
{
//System.Reflection.MethodInfo.GetCurrentMethod().Name
Logger.WriteException("SetArticleSortNo", ex, request);
result.ErrCode = -1;
result.Message = ex.Message;
}
return(result);
}
public int AddArticle(ArticleM article)
{
var tran = new TransactionScope();
try
{
//把文章数据写入数据库
var articleDa = new ArticleDA();
articleDa.AddArticle(article);
//为新增加的文章生成静态页面
//文章作者增加积分
//写日志
//提交事务
tran.Complete();
}
catch (Exception ex)
{
throw ex;
}
finally
{
tran.Dispose();
}
return(1);
}
public ConsulterEtatStockBL()
{
this.articleDA = new ArticleDA();
this.acheterDA = new AcheterDA();
this.categorieArticleDA = new CategorieArticleDA();
this.stockerDA = new StockerDA();
this.parametreDA = new ParametresDA();
this.journalDA = new JournalDA();
}
public GestionArticleBL()
{
articleDA = new ArticleDA();
setarticleDA = new SetarticleDA();
eleveDA = new EleveDA();
acheterDA = new AcheterDA();
composerDA = new ComposerDA();
stockerDA = new StockerDA();
composers = new List <ComposerBE>();
stockers = new List <StockerBE>();
parametreDA = new ParametresDA();
journalDA = new JournalDA();
inscrireDA = new InscrireDA();
classeDA = new ClasseDA();
}
/// <summary>
/// 插入数据
/// </summary>
/// <param name="article">数据实体</param>
public int Insert(ArticleVO articleVO)
{
using (ITransaction transaction = TransactionManager.Create())
{
ArticleEntity article = articleVO.ToArticleEntity();
this.CheckEntity(article);
article.IsDelete = DeletedEnums.Actived;
if ((articleVO.ArticleDepartmentList == null || articleVO.ArticleDepartmentList.Count == 0) &&
string.IsNullOrEmpty(articleVO.UserIds))
{
throw new BusinessException("请选择推文对象或填写推送用户");
}
int articleId = ArticleDA.Insert(article);
if (articleVO.ArticleDepartmentList != null && articleVO.ArticleDepartmentList.Count > 0)
{
articleVO.ArticleDepartmentList.ForEach(item =>
{
item.ArticleId = articleId;
});
ArticleDepartmentService.BatchInsert(articleVO.ArticleDepartmentList.Select(p => p.ToArticleDepartmentEntity()).ToList());
}
// 插入用户id数据
if (!string.IsNullOrEmpty(articleVO.UserIds))
{
List <ArticleUser> articleUsers = articleVO.UserIds.Split(new char[] { '|' }).Select(p => new ArticleUser()
{
ArticleId = articleId, UserId = p
}).ToList();
ArticleDA.BatchInserArticleUser(articleUsers);
}
// 插入分发得公司
transaction.Complete();
return(articleId);
}
}
/// <summary>
/// 查询推文列表
/// </summary>
/// <param name="filter">过滤条件</param>
/// <returns>返回推文列表</returns>
public QueryResult <ArticleVO> SearchPageList(QF_Article filter)
{
return(ArticleDA.SearchPageList(filter).ToArticleVOPageList());
}
public List <string> SearchArticleUserList(int articleId)
{
return(ArticleDA.SearchArticleUserList(articleId));
}
/// <summary>
/// 根据Id获取推文数据
/// </summary>
/// <param name="id">id</param>
/// <returns>返回推文数据</returns>
public ArticleVO GetById(int id)
{
return(ArticleDA.GetById(id).ToArticleVO());
}
public OperationResult <int> UpdateArticle(RequestOperation <ArticleData> request)
{
var result = new OperationResult <int>();
try
{
if (request.Body.ID <= 0 ||
String.IsNullOrEmpty(request.Body.Title) ||
String.IsNullOrEmpty(request.Body.Cover) ||
String.IsNullOrEmpty(request.Body.Contents))
{
result.Message = "缺少请求参数";
return(result);
}
var data = ArticleDA.UpdateArticle(request);
if (data <= 0)
{
result.ErrCode = 1;
result.Message = "添加文章失败";
}
else
{
int artid = request.Body.ID;
if (request.Body.Lawyers != null && request.Body.Lawyers.Count > 0)
{
//更新文章与律师关联
string sql = "INSERT INTO [dbo].[T_Article_Lawyers_Mapping]([ArtID],[LawyerID]) VALUES ";
string sqlCon = "({0},{1}),";
string fullStr = "";
foreach (var law in request.Body.Lawyers)
{
fullStr += String.Format(sqlCon, artid, law);
}
fullStr = sql + fullStr.TrimEnd(',');
//更新律师案例
fullStr += " UPDATE [dbo].[T_Customer_Lawyers] SET [CaseSeries] = @Summary,ArtID =@ArtID"
+ "WHERE [UserID] IN (" +
String.Join(",", request.Body.Lawyers)
+ ")";
ArticleDA.SetArticleLaw(artid, fullStr, request.Body.Summary);
}
else
{
//逻辑可能有问题,此处
//新增文章时,关联了律师案例,修改时,是否继续删除,待定
ArticleDA.SetArticleLaw(artid, "", request.Body.Summary);
}
result.Body = artid;
result.ErrCode = 0;
result.Message = "ok";
}
}
catch (Exception ex)
{
Logger.WriteException("UpdateArticle", ex, request);
result.ErrCode = -1;
result.Message = ex.Message;
}
return(result);
}
public CreerModifierArticleBL()
{
this.articleDA = new ArticleDA();
this.journalDA = new JournalDA();
}
