public ActionResult GetList(SiteContentQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList <SiteContentEntity> list = service.GetSiteContentList(query);
return(Json(new { list }));
}
/// <summary>
/// 获取资讯分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <SiteContentEntity> GetSiteContentPageList(SiteContentQuery query)
{
Pager <SiteContentEntity> pager = SiteContentBusProvider.GetSiteContentPageList(query);
if (pager != null)
{
pager.ItemList = GetSiteContentList(pager.ItemList, query);
}
return(pager);
}
public ActionResult GetPageList(SiteContentQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
query.CurrentPage = Convert.ToInt32(Request.Params["page"]);
query.PageSize = Convert.ToInt32(Request.Params["pagesize"]);
Pager <SiteContentEntity> pager = service.GetSiteContentPageList(query);
return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords }));
}
public ActionResult Delete(Int64[] ContentIDs)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
SiteContentQuery query = new SiteContentQuery();
query.JournalID = CurAuthor.JournalID;
query.ContentIDs = ContentIDs;
ExecResult result = service.DelSiteContent(query);
return(Json(new { result = result.result, msg = result.msg }));
}
/// <summary>
/// 获取资讯数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SiteContentEntity> GetSiteContentList(SiteContentQuery query)
{
string strSql = "SELECT * FROM dbo.SiteContent a with(nolock)";
string whereSQL = GetSiteContentFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by SortID";
return(db.GetList <SiteContentEntity>(strSql, MakeSiteContentList));
}
/// <summary>
/// 获取条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetSiteContentFilter(SiteContentQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID=" + query.JournalID);
if (query.ChannelID != null)
{
strFilter.AppendFormat(" and ChannelID={0}", query.ChannelID.Value);
}
if (query.IsPhoto)
{
strFilter.Append(" and TitlePhoto<>''");
}
return(strFilter.ToString());
}
private SiteContentEntity GetModel(Int64 ContentID)
{
SiteContentEntity model = null;
if (ContentID > 0)
{
SiteContentQuery query = new SiteContentQuery();
query.JournalID = CurAuthor.JournalID;
query.ContentID = ContentID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model = service.GetSiteContentModel(query);
}
if (model == null)
{
model = new SiteContentEntity();
}
return(model);
}
/// <summary>
/// 获取资讯分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager <SiteContentEntity> GetSiteContentPageList(SiteContentQuery query)
{
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY SortID ASC) AS ROW_ID FROM dbo.SiteContent a with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.SiteContent with(nolock)";
string whereSQL = GetSiteContentFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return(db.GetPageList <SiteContentEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeSiteContentList));
}
/// <summary>
/// 获取资讯数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SiteContentEntity> GetSiteContentList(SiteContentQuery query)
{
return(GetSiteContentList(SiteContentBusProvider.GetSiteContentList(query), query));
}
/// <summary>
/// 组装数据
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
private IList <SiteContentEntity> GetSiteContentList(IList <SiteContentEntity> list, SiteContentQuery siteContentQuery)
{
if (list == null || list.Count == 0)
{
return(list);
}
AuthorInfoService service = new AuthorInfoService();
AuthorInfoQuery query = new AuthorInfoQuery();
query.JournalID = siteContentQuery.JournalID;
var dict = service.AuthorInfoBusProvider.GetAuthorDict(query);
foreach (var mode in list)
{
mode.InAuthorName = dict.GetValue(mode.InAuthor, mode.InAuthor.ToString());
}
return(list);
}
/// <summary>
/// 获取资讯数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList <SiteContentEntity> GetSiteContentList(SiteContentQuery query)
{
return(SiteContentDataAccess.Instance.GetSiteContentList(query));
}
