/// <summary> /// 获取年卷排序 /// </summary> /// <param name="query"></param> /// <returns></returns> private string GetYearVolumeOrder(YearVolumeQuery query) { return " Year DESC "; }
/// <summary> /// 获取年卷分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query) { string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY " + GetYearVolumeOrder(query) + ") AS ROW_ID FROM dbo.YearVolume with(nolock)", sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.YearVolume with(nolock)"; string whereSQL = GetYearVolumeFilter(query); if (!string.IsNullOrWhiteSpace(whereSQL)) { strSql += " WHERE " + whereSQL; sumStr += " WHERE " + whereSQL; } return db.GetPageList<YearVolumeEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex) , sumStr , query.CurrentPage, query.PageSize , (dr, pager) => { pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]); } , MakeYearVolumeList); }
/// <summary> /// 获取年卷条件 /// </summary> /// <param name="query"></param> /// <returns></returns> private string GetYearVolumeFilter(YearVolumeQuery query) { StringBuilder strFilter = new StringBuilder(" JournalID= " + query.JournalID); if (query.Status != null) strFilter.Append(" and Status=").Append(query.Status.Value); return strFilter.ToString(); }
/// <summary> /// 获取年卷分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query) { return IssueDataAccess.Instance.GetYearVolumePageList(query); }
/// <summary> /// 获取年卷数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList<YearVolumeEntity> GetYearVolumeList(YearVolumeQuery query) { string strSql = "SELECT * FROM dbo.YearVolume with(nolock)"; string whereSQL = GetYearVolumeFilter(query); if (!string.IsNullOrWhiteSpace(whereSQL)) { strSql += " WHERE " + whereSQL; } strSql += " order by " + GetYearVolumeOrder(query); return db.GetList<YearVolumeEntity>(strSql, MakeYearVolumeList); }
public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query) { IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>(); Pager<YearVolumeEntity> pager = service.GetYearVolumePageList(query); return pager; }
/// <summary> /// 获取年卷设置列表 /// </summary> /// <param name="query"></param> /// <returns></returns> public IList<YearVolumeEntity> GetYearVolumeList(YearVolumeQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); IList<YearVolumeEntity> list = clientHelper.Post<IList<YearVolumeEntity>, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_GETLIST), query); return list; }
public ActionResult GetYearVolumePageList(YearVolumeQuery query) { IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>(); query.JournalID = CurAuthor.JournalID; query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); Pager<YearVolumeEntity> pager = service.GetYearVolumePageList(query); return Json(new { Rows = pager.ItemList, Total = pager.TotalRecords }); }
public ActionResult IssuePush(IssueContentQuery query) { //获取模板文件内容 string str = WKT.Common.Utils.Utils.ReadFileContent(Utils.GetMapPath(SiteConfig.RootPath + "/data/Issue.Template")); StringBuilder sb = new StringBuilder(str); IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>(); //根据年获取卷 YearVolumeQuery YVQuery = new YearVolumeQuery(); YVQuery.JournalID = CurAuthor.JournalID; IList<YearVolumeEntity> YearVolList = service.GetYearVolumeList(YVQuery); int Volume = YearVolList.Single<YearVolumeEntity>(p => p.Year == query.Year).Volume; //根据查询条件获取期刊列表 query.JournalID = CurAuthor.JournalID; IList<IssueContentEntity> list = service.GetIssueContentList(query); //替换模板文件基本内容 str = str.Replace("%Year%", query.Year.ToString()).Replace("%Vol%", Volume.ToString()).Replace("%Issue%", query.Issue.ToString()).Replace("%SiteName%", SiteConfig.SiteName).Replace("%SiteURL%", "<a href=\"http://" + Request.Url.Host + "\" target=\"_blank\">http://" + Request.Url.Host + "</a>"); //向模板文件加入期刊列表内容 string listing = string.Empty; for (int i = 0; i < list.Count; i++) { listing += "<tr>"; listing += "<td style=\"text-align:center; width:50px; font-weight:bold;\">" + (i + 1) + "</td>"; listing += "<td style=\"text-align:left; font-weight:bold;\"><a href=\"http://" + Request.Url.Host + "/Magazine/Show?id=" + list[i].ContentID + "\" target=\"_blank\">" + list[i].Title + "</a></td>"; listing += "</tr>"; listing += "<tr>"; listing += "<td colspan=\"2\" style=\"text-align:left; padding-left:55px; font-size:12px;border-bottom:1px solid #e2e2e2;\">" + list[i].Authors + "</td>"; listing += "</tr>"; } str = str.Replace("%Content%", listing); //WKT.Common.Utils.Utils.WritStrToFile(str, @"D:\xx.htm"); return Json(new { flag = 1, htmlContent = str }); }
public ActionResult DelYearVolume(Int64[] SetIDs) { IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>(); YearVolumeQuery query = new YearVolumeQuery(); query.JournalID = CurAuthor.JournalID; query.setIDs = SetIDs; ExecResult result = service.DelYearVolume(query); return Json(new { result = result.result, msg = result.msg }); }
public ActionResult GetYearVolumeList(YearVolumeQuery query) { IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>(); query.JournalID = CurAuthor.JournalID; IList<YearVolumeEntity> list = service.GetYearVolumeList(query); return Json(new { list }); }
/// <summary> /// 删除年卷设置 /// </summary> /// <param name="query"></param> /// <returns></returns> public ExecResult DelYearVolume(YearVolumeQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); ExecResult result = clientHelper.Post<ExecResult, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_DEL), query); return result; }
/// <summary> /// 获取年卷设置分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); Pager<YearVolumeEntity> pager = clientHelper.Post<Pager<YearVolumeEntity>, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_GETPAGELIST), query); return pager; }
/// <summary> /// 获取年卷设置实体 /// </summary> /// <param name="query"></param> /// <returns></returns> public YearVolumeEntity GetYearVolumeModel(YearVolumeQuery query) { HttpClientHelper clientHelper = new HttpClientHelper(); YearVolumeEntity model = clientHelper.Post<YearVolumeEntity, YearVolumeQuery>(GetAPIUrl(APIConstant.YEARVOLUME_GETMODEL), query); return model; }
public IList<YearVolumeEntity> GetYearVolumeList(YearVolumeQuery query) { IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>(); IList<YearVolumeEntity> list = service.GetYearVolumeList(query); return list; }
private YearVolumeEntity GetYearVolumeModel(Int64 SetID) { YearVolumeQuery query = new YearVolumeQuery(); query.JournalID = CurAuthor.JournalID; query.setID = SetID; IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>(); YearVolumeEntity model = service.GetYearVolumeModel(query); if (model == null) model = new YearVolumeEntity(); return model; }
public YearVolumeEntity GetYearVolumeModel(YearVolumeQuery query) { IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>(); YearVolumeEntity model=null; if (query.setID == 0) model = service.GetMaxYearVolume(query.JournalID); else model = service.GetYearVolume(query.setID); return model; }
public ActionResult FinanceOutAccount() { IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>(); //获取所有年 YearVolumeQuery query = new YearVolumeQuery(); query.JournalID = JournalID; IList<YearVolumeEntity> listYearVolume = service.GetYearVolumeList(query); //获取所有期 IssueSetQuery issueSetQuery = new IssueSetQuery(); issueSetQuery.JournalID = JournalID; IList<IssueSetEntity> listIssue = service.GetIssueSetList(issueSetQuery); ViewBag.listYearVolume = listYearVolume; ViewBag.listIssue = listIssue; return View(); }
public ExecResult DelYearVolume(YearVolumeQuery query) { IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>(); return service.DelYearVolume(query.setIDs); }
/// <summary> /// 获取年卷分页数据 /// </summary> /// <param name="query"></param> /// <returns></returns> public Pager<YearVolumeEntity> GetYearVolumePageList(YearVolumeQuery query) { return IssueBusProvider.GetYearVolumePageList(query); }