public ExecResult Del(SiteNoticeQuery query)
{
ExecResult execResult = new ExecResult();
ISiteNoticeService service = ServiceContainer.Instance.Container.Resolve<ISiteNoticeService>();
Int64[] NoticeIDs = query.NoticeIDs;
if (NoticeIDs == null)
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "没有删除任何数据！";
return execResult;
}
string msg = string.Empty;
bool result = service.BatchDeleteSiteNotice(NoticeIDs);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "删除成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "删除失败！";
}
return execResult;
}
public ActionResult GetList(SiteNoticeQuery query)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList<SiteNoticeEntity> list = service.GetSiteNoticeList(query);
return Json(new { list });
}
public ActionResult GetPageList(SiteNoticeQuery 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<SiteNoticeEntity> pager = service.GetSiteNoticePageList(query);
return Json(new { Rows = pager.ItemList, Total = pager.TotalRecords });
}
public ActionResult Delete(Int64[] NoticeIDs)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteNoticeQuery query = new SiteNoticeQuery();
query.JournalID = CurAuthor.JournalID;
query.NoticeIDs = NoticeIDs;
ExecResult result = service.DelSiteNotice(query);
return Json(new { result = result.result, msg = result.msg });
}
private SiteNoticeEntity GetModel(Int64 NoticeID)
{
SiteNoticeEntity model = null;
if (NoticeID > 0)
{
SiteNoticeQuery query = new SiteNoticeQuery();
query.JournalID = CurAuthor.JournalID;
query.NoticeID = NoticeID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
model = service.GetSiteNoticeModel(query);
}
if (model == null)
model = new SiteNoticeEntity();
return model;
}
public ActionResult spjz(long ChannelID, int page = 1)
{
ViewBag.ChannelName = "";
ViewBag.PagerInfo = "";
SiteModel siteModel = new SiteModel();
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteChannelQuery query = new SiteChannelQuery();
query.JournalID = JournalID;
query.ChannelID = ChannelID;
SiteChannelEntity channelEntity = service.GetSiteChannelModel(query);
if (channelEntity != null)
{
ViewBag.ChannelName = channelEntity.Keywords;
if (channelEntity.ContentType == (int)EnumContentType.Information)
{
SiteContentQuery contentQuery = new SiteContentQuery();
contentQuery.ChannelID = ChannelID;
contentQuery.JournalID = JournalID;
contentQuery.CurrentPage = page;
contentQuery.PageSize = PageSize;
Pager<SiteContentEntity> pagerContentEntity = service.GetSiteContentPageList(contentQuery);
if (pagerContentEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerContentEntity.TotalPage, "/spjz/" + ChannelID, 10);
foreach (SiteContentEntity item in pagerContentEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Title;
newsItem.Content = item.Content;
newsItem.ChannelID = ChannelID;
newsItem.PKID = item.ContentID;
newsItem.FJPath = item.FJPath;
newsItem.LinkUrl = item.Linkurl;
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
}
}
}
else if (channelEntity.ContentType == (int)EnumContentType.SiteDescribe)
{
SiteNoticeQuery noticeQuery = new SiteNoticeQuery();
noticeQuery.ChannelID = ChannelID;
noticeQuery.JournalID = JournalID;
noticeQuery.CurrentPage = page;
noticeQuery.PageSize = PageSize;
Pager<SiteNoticeEntity> pagerNoticeEntity = service.GetSiteNoticePageList(noticeQuery);
if (pagerNoticeEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerNoticeEntity.TotalPage, "/spjz/" + ChannelID, 10);
foreach (SiteNoticeEntity item in pagerNoticeEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Title;
newsItem.Content = item.Content;
newsItem.ChannelID = ChannelID;
newsItem.PKID = item.NoticeID;
newsItem.FJPath = item.FjPath;
newsItem.LinkUrl = string.Format("/show/{0}/?itemid={1}", item.ChannelID, item.NoticeID);
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
}
}
}
else if (channelEntity.ContentType == (int)EnumContentType.Resources)
{
SiteResourceQuery resourceQuery = new SiteResourceQuery();
resourceQuery.ChannelID = ChannelID;
resourceQuery.JournalID = JournalID;
resourceQuery.CurrentPage = page;
resourceQuery.PageSize = PageSize;
Pager<SiteResourceEntity> pagerResourceEntity = service.GetSiteResourcePageList(resourceQuery);
if (pagerResourceEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerResourceEntity.TotalPage, "/spjz/" + ChannelID, 10);
foreach (SiteResourceEntity item in pagerResourceEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Name;
newsItem.LinkUrl = string.Format("/resource/?id={0}", item.ResourceID);
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
}
}
}
}
return View(siteModel);
}
/// <summary>
/// 显示指定的频道页面
/// </summary>
/// <param name="ChannelID"></param>
/// <param name="NewsID"></param>
/// <returns></returns>
public ActionResult channel(string ChannelUrl,int page=1)
{
ViewBag.Title = "";
ViewBag.ChannelName = "";
SiteModel siteModel = new SiteModel();
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteChannelQuery query = new SiteChannelQuery();
query.JournalID = JournalID;
query.ChannelUrl = ChannelUrl;
SiteChannelEntity channelEntity = service.GetSiteChannelModel(query);
if (channelEntity != null)
{
ViewBag.ChannelName = channelEntity.Keywords;
if (channelEntity.ContentType == (int)EnumContentType.SiteDescribe)
{
SiteNoticeQuery noticeQuery = new SiteNoticeQuery();
noticeQuery.ChannelID = channelEntity.ChannelID;
noticeQuery.JournalID = JournalID;
noticeQuery.CurrentPage = 1;
noticeQuery.PageSize = 1;
Pager<SiteNoticeEntity> pagerNoticeEntity = service.GetSiteNoticePageList(noticeQuery);
if (pagerNoticeEntity != null && pagerNoticeEntity.ItemList.Count > 0)
{
siteModel.ConentEntity.Title = pagerNoticeEntity.ItemList[0].Title;
siteModel.ConentEntity.Content = pagerNoticeEntity.ItemList[0].Content;
siteModel.ConentEntity.FJPath = pagerNoticeEntity.ItemList[0].FjPath;
siteModel.ConentEntity.PublishDate = pagerNoticeEntity.ItemList[0].AddDate;
}
}
else if (channelEntity.ContentType == (int)EnumContentType.Information)
{
SiteContentQuery contentQuery = new SiteContentQuery();
contentQuery.ChannelID = channelEntity.ChannelID;
contentQuery.JournalID = JournalID;
contentQuery.CurrentPage = page;
contentQuery.PageSize = PageSize;
Pager<SiteContentEntity> pagerContentEntity = service.GetSiteContentPageList(contentQuery);
if (pagerContentEntity != null)
{
ViewBag.PagerInfo = Utils.GetPageNumbers(page, pagerContentEntity.TotalPage, "/channel/" + channelEntity.ChannelID, 10);
siteModel.SiteContentList = new List<SiteContentEntity>();
foreach (SiteContentEntity item in pagerContentEntity.ItemList)
{
NewsModel newsItem = new NewsModel();
newsItem.Title = item.Title;
newsItem.Content = item.Content;
newsItem.ChannelID = channelEntity.ChannelID;
newsItem.PKID = item.ContentID;
newsItem.FJPath = item.FJPath;
newsItem.PublishDate = item.AddDate;
siteModel.ListConentEntity.Add(newsItem);
siteModel.SiteContentList.Add(item);
}
}
}
}
ViewBag.Title = siteModel.ConentEntity.Title;
if (channelEntity != null)
{
if (channelEntity.ContentType == (int)EnumContentType.Information && channelEntity.ChannelUrl=="list")
{
return View("list", siteModel);
}
}
return View(siteModel);
}
/// <summary>
/// 显示指定的频道页面
/// </summary>
/// <param name="ChannelID"></param>
/// <param name="NewsID"></param>
/// <returns></returns>
public ActionResult show(long ChannelID)
{
ViewBag.Title = "";
ViewBag.ChannelName = "";
SiteModel siteModel = new SiteModel();
long ItemID = TypeParse.ToLong(Request.QueryString["itemid"]);
if (ItemID > 0)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>();
SiteChannelQuery query = new SiteChannelQuery();
query.JournalID = JournalID;
query.ChannelID = ChannelID;
SiteChannelEntity channelEntity = service.GetSiteChannelModel(query);
if (channelEntity != null)
{
ViewBag.ChannelName = channelEntity.Keywords;
if (channelEntity.ContentType == (int)EnumContentType.Information)
{
SiteContentQuery contentQuery = new SiteContentQuery();
contentQuery.ChannelID = ChannelID;
contentQuery.JournalID = JournalID;
contentQuery.ContentID = ItemID;
SiteContentEntity contentEntity = service.GetSiteContentModel(contentQuery);
if (contentEntity != null)
{
string contentTitle = "";
contentTitle = string.Format("<span style=\"font-weight:{2};font-style:{3};color:{1}\">{0}</span>", contentEntity.Title, !string.IsNullOrEmpty(contentEntity.TitleColor) ? contentEntity.TitleColor : "#000",
contentEntity.IsBold ? "bold" : "normal", contentEntity.IsItalic ? "italic" : "normal");
siteModel.ConentEntity.Title = contentTitle;
siteModel.ConentEntity.FJPath = contentEntity.FJPath;
siteModel.ConentEntity.Content = contentEntity.Content;
siteModel.ConentEntity.ChannelID = contentEntity.ChannelID;
siteModel.ConentEntity.PublishDate = contentEntity.AddDate;
}
}
else if (channelEntity.ContentType == (int)EnumContentType.SiteDescribe)
{
SiteNoticeQuery noticeQuery = new SiteNoticeQuery();
noticeQuery.ChannelID = ChannelID;
noticeQuery.JournalID = JournalID;
noticeQuery.NoticeID = ItemID;
SiteNoticeEntity noticeEntity = service.GetSiteNoticeModel(noticeQuery);
if (noticeEntity != null)
{
siteModel.ConentEntity.Title = noticeEntity.Title;
siteModel.ConentEntity.Content = noticeEntity.Content;
siteModel.ConentEntity.ChannelID = noticeEntity.ChannelID;
siteModel.ConentEntity.PublishDate = noticeEntity.AddDate;
}
}
}
}
ViewBag.Title = Utils.ClearHtml(siteModel.ConentEntity.Title);
return View(siteModel);
}
public Pager<SiteNoticeEntity> GetPageList(SiteNoticeQuery query)
{
ISiteNoticeService service = ServiceContainer.Instance.Container.Resolve<ISiteNoticeService>();
Pager<SiteNoticeEntity> pager = service.GetSiteNoticePageList(query);
return pager;
}
/// <summary>
/// 获取站点公告数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<SiteNoticeEntity> GetSiteNoticeList(SiteNoticeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
IList<SiteNoticeEntity> list = clientHelper.Post<IList<SiteNoticeEntity>, SiteNoticeQuery>(GetAPIUrl(APIConstant.SITENOTICE__GETLIST), query);
return list;
}
/// <summary>
/// 将查询实体转换为Where语句
/// <param name="query">查询实体</param>
/// <returns>获取Where语句，不包含Where</returns>
/// </summary>
public string SiteNoticeQueryToSQLWhere(SiteNoticeQuery query)
{
StringBuilder strFilter = new StringBuilder();
strFilter.Append(" 1=1");
if (query.JournalID > 0)
strFilter.AppendFormat(" and JournalID={0}", query.JournalID);
if (query.ChannelID > 0)
strFilter.AppendFormat(" and ChannelID={0}", query.ChannelID);
return strFilter.ToString();
}
public Pager<SiteNoticeEntity> GetSiteNoticePageList(SiteNoticeQuery query)
{
string strSql = "SELECT DesID,JournalID,ChannelID,Title,Keywords,Description,Content,FjPath,AddDate,ROW_NUMBER() OVER(ORDER BY DesID DESC) AS ROW_ID FROM dbo.SiteDescribe with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.SiteDescribe with(nolock)";
string whereSQL = SiteNoticeQueryToSQLWhere(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<SiteNoticeEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeSiteNoticeList);
}
/// <summary>
/// 获取所有符合查询条件的数据
/// </summary>
/// <param name="siteNoticeQuery">SiteNoticeQuery查询实体对象</param>
/// <returns>List<SiteNoticeEntity></returns>
public List<SiteNoticeEntity> GetSiteNoticeList(SiteNoticeQuery siteNoticeQuery)
{
return SiteNoticeDataAccess.Instance.GetSiteNoticeList(siteNoticeQuery);
}
/// <summary>
/// 获取站点公告分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<SiteNoticeEntity> GetSiteNoticePageList(SiteNoticeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
Pager<SiteNoticeEntity> pager = clientHelper.Post<Pager<SiteNoticeEntity>, SiteNoticeQuery>(GetAPIUrl(APIConstant.SITENOTICE_GETPAGELIST), query);
return pager;
}
/// <summary>
/// 获取站点公告实体
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public SiteNoticeEntity GetSiteNoticeModel(SiteNoticeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
SiteNoticeEntity model = clientHelper.Post<SiteNoticeEntity, SiteNoticeQuery>(GetAPIUrl(APIConstant.SITENOTICE__GETMODEL), query);
return model;
}
public ActionResult zjjy(string ChannelUrl, int page = 1)
{
((dynamic)base.ViewBag).Title = "";
((dynamic)base.ViewBag).ChannelName = "";
SiteModel model = new SiteModel();
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve<ISiteConfigFacadeService>(new ResolverOverride[0]);
SiteChannelQuery query = new SiteChannelQuery
{
JournalID = base.JournalID,
ChannelUrl = ChannelUrl
};
SiteChannelEntity siteChannelModel = service.GetSiteChannelModel(query);
if (siteChannelModel != null)
{
((dynamic)base.ViewBag).ChannelName = siteChannelModel.Keywords;
if (siteChannelModel.ContentType == 4)
{
SiteNoticeQuery query2 = new SiteNoticeQuery
{
ChannelID = siteChannelModel.ChannelID,
JournalID = base.JournalID,
CurrentPage = 1,
PageSize = 1
};
Pager<SiteNoticeEntity> siteNoticePageList = service.GetSiteNoticePageList(query2);
if ((siteNoticePageList != null) && (siteNoticePageList.ItemList.Count > 0))
{
model.ConentEntity.Title = siteNoticePageList.ItemList[0].Title;
model.ConentEntity.Content = siteNoticePageList.ItemList[0].Content;
model.ConentEntity.PublishDate = siteNoticePageList.ItemList[0].AddDate;
}
}
else if (siteChannelModel.ContentType == 1)
{
SiteContentQuery query3 = new SiteContentQuery
{
ChannelID = new long?(siteChannelModel.ChannelID),
JournalID = base.JournalID,
CurrentPage = page,
PageSize = this.PageSize
};
Pager<SiteContentEntity> siteContentPageList = service.GetSiteContentPageList(query3);
if (siteContentPageList != null)
{
((dynamic)base.ViewBag).PagerInfo = WKT.Common.Utils.Utils.GetPageNumbers(page, siteContentPageList.TotalPage, "/zjjy/" + siteChannelModel.ChannelID, 10);
model.SiteContentList = new List<SiteContentEntity>();
foreach (SiteContentEntity entity2 in siteContentPageList.ItemList)
{
NewsModel item = new NewsModel
{
Title = entity2.Title,
Content = entity2.Content,
ChannelID = siteChannelModel.ChannelID,
PKID = entity2.ContentID,
PublishDate = entity2.AddDate
};
model.ListConentEntity.Add(item);
model.SiteContentList.Add(entity2);
}
}
}
}
((dynamic)base.ViewBag).Title = model.ConentEntity.Title;
if ((siteChannelModel != null) && ((siteChannelModel.ContentType == 1) && (siteChannelModel.ChannelUrl == "list")))
{
return base.View("list", model);
}
return base.View(model);
}
public List<SiteNoticeEntity> GetSiteNoticeList(SiteNoticeQuery query)
{
string strSql = "SELECT DesID,JournalID,ChannelID,Title,Keywords,Description,Content,FjPath,AddDate FROM dbo.SiteDescribe with(nolock)";
string whereSQL = SiteNoticeQueryToSQLWhere(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
return db.GetList<SiteNoticeEntity>(strSql, MakeSiteNoticeList);
}
public IList<SiteNoticeEntity> GetList(SiteNoticeQuery query)
{
ISiteNoticeService service = ServiceContainer.Instance.Container.Resolve<ISiteNoticeService>();
IList<SiteNoticeEntity> list = service.GetSiteNoticeList(query);
return list;
}
/// <summary>
/// 将查询实体转换为Order语句
/// <param name="query">查询实体</param>
/// <returns>获取Order语句，不包含Order</returns>
/// </summary>
public string SiteNoticeQueryToSQLOrder(SiteNoticeQuery query)
{
return " NoticeID DESC";
}
public SiteNoticeEntity GetModel(SiteNoticeQuery query)
{
ISiteNoticeService service = ServiceContainer.Instance.Container.Resolve<ISiteNoticeService>();
SiteNoticeEntity model = service.GetSiteNotice(query.NoticeID);
return model;
}
/// <summary>
/// 分页获取符合查询条件的数据
/// </summary>
/// <param name="siteNoticeQuery">SiteNoticeQuery查询实体对象</param>
/// <returns>Pager<SiteNoticeEntity></returns>
public Pager<SiteNoticeEntity> GetSiteNoticePageList(SiteNoticeQuery siteNoticeQuery)
{
return SiteNoticeBusProvider.GetSiteNoticePageList(siteNoticeQuery);
}
/// <summary>
/// 删除站点公告
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelSiteNotice(SiteNoticeQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, SiteNoticeQuery>(GetAPIUrl(APIConstant.SITENOTICE__DEL), query);
return result;
}
