protected string DoUpdateNewsInfo(string pRequest)
{
//请求参数反序列化
var rq = pRequest.DeserializeJSONTo <APIRequest <UpdateNewsInfoRP> >();
//参数校验
rq.Parameters.Validate();
//构造响应数据
var rp = new APIResponse <UpdateNewsInfoRD>(new UpdateNewsInfoRD());
try
{
//更新数据库
LNewsEntity lNewsEn = new LNewsEntity();
lNewsEn.NewsId = rq.Parameters.NewsId;
lNewsEn.NewsType = rq.Parameters.NewsTypeId;
lNewsEn.Author = rq.Parameters.Author;
lNewsEn.NewsTitle = rq.Parameters.NewsTitle;
lNewsEn.Intro = rq.Parameters.Intro;
lNewsEn.Content = rq.Parameters.Content;
lNewsEn.ImageUrl = rq.Parameters.ImageUrl;
lNewsEn.PublishTime = rq.Parameters.PublishTime;
PrivateLNewsBLL.UpdateNewsInfo(lNewsEn, rq.Parameters.MappingId, rq.Parameters.OldNumberId, rq.Parameters.OldTypeId, rq.Parameters.MicroNumberID, rq.Parameters.MicroTypeID, rq.Parameters.LabelID, rq.Parameters.IsRelMicro);
}
catch (Exception ex)
{
Loggers.Exception(new ExceptionLogInfo(ex));
throw new Exception(ex.Message, ex);
}
return(rp.ToJSON());
}
/*||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||【新版资讯管理】Alan |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||*/
#region Alan 2014-08-14
/// <summary>
/// 获取新闻资讯列表 Add By Alan 2014-08-14
/// </summary>
/// <param name="lNewsEn">新闻资讯实体类</param>
/// <param name="startDate">开始日期</param>
/// <param name="endDate">结束日期</param>
/// <param name="keyword">搜索关键字</param>
/// <param name="sortOrder">排序方式：0 升序 1 降序</param>
/// <param name="sortField">排序字段</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">页大小</param>
/// <param name="pageCount">页大小</param>
/// <param name="rowCount">行大小</param>
/// <param name="isMappingNews">是否取未关联的资讯</param>
/// <returns>DataTable 数据集</returns>
public DataTable GetNewsList(LNewsEntity lNewsEn, string startDate, string endDate, string keyword, string sortField, int sortOrder, int pageIndex, int pageSize, bool isMappingNews, ref int pageCount, ref int rowCount)
{
DataSet ds = _currentDAO.GetNewsList(lNewsEn, startDate, endDate, keyword, sortField, sortOrder, pageIndex, pageSize, isMappingNews);
if (ds == null)
{
return(null);
}
rowCount = 0;
int.TryParse(ds.Tables[1].Rows[0][0].ToString(), out rowCount);
pageCount = rowCount / pageSize;
if (rowCount % pageSize > 0)
{
pageCount++;
}
return(ds.Tables[0]);
}
/// <summary>
/// 消息集合
/// </summary>
public LNewsEntity getNewsList(LNewsEntity entity, int page, int pageSize)
{
try
{
var result = new LNewsEntity();
IList <LNewsEntity> list = new List <LNewsEntity>();
DataSet ds = _currentDAO.getNewsList(entity, page, pageSize);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
list = DataTableToObject.ConvertToList <LNewsEntity>(ds.Tables[0]);
}
result.ICount = _currentDAO.getNewsListCount(entity);
result.EntityList = list;
return(result);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 更新新闻资讯
/// </summary>
/// <param name="lNewsEn">新闻资讯实体</param>
/// <param name="mappingId">新闻期刊关联标识ID</param>
/// <param name="microNumberID">刊号ID</param>
/// <param name="microTypeID">类别ID</param>
/// <param name="labelIds">标签ID</param>
/// <param name="isRelMicro">资讯是否关联微刊</param>
public void UpdateNewsInfo(LNewsEntity lNewsEn, string mappingId, string oldNumberId, string oldTypeId, string microNumberID, string microTypeID, string labelIds, bool isRelMicro)
{
_currentDAO.UpdateNewsInfo(lNewsEn, mappingId, oldNumberId, oldTypeId, microNumberID, microTypeID, labelIds.Split(','), isRelMicro);
}
/// <summary>
/// 新增新闻资讯
/// </summary>
/// <param name="lNewsEn">新闻资讯实体</param>
/// <param name="microNumberID">刊号ID</param>
/// <param name="microTypeID">类别ID</param>
/// <param name="labelID">标签ID</param>
public void AddNewsInfo(LNewsEntity lNewsEn, string microNumberID, string microTypeID, string labelID)
{
_currentDAO.AddNewsInfo(lNewsEn, microNumberID, microTypeID, labelID.Split(','));
}
public void Update(LNewsEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(LNewsEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(LNewsEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <LNewsEntity> PagedQueryByEntity(LNewsEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(LNewsEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public LNewsEntity[] QueryByEntity(LNewsEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Delete(LNewsEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Delete(pEntity, pTran);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(LNewsEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void Update(LNewsEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(LNewsEntity pEntity)
{
Update(pEntity, true);
}
