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; }