public ActionResult ReviewBillIsEnabled(Int64 ItemID)
{
IFlowFacadeService service = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>();
ReviewBillQuery query = new ReviewBillQuery();
query.JournalID = CurAuthor.JournalID;
query.ItemID = ItemID;
bool result = service.ReviewBillIsEnabled(query);
return Json(new { result = result });
}
/// <summary>
/// 获取审稿单项数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<ReviewBillEntity> GetReviewBillList(ReviewBillQuery query)
{
return ReviewBillBusProvider.GetReviewBillList(query);
}
public ActionResult GetReviewBillList(ReviewBillQuery query)
{
IFlowFacadeService service = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>();
query.JournalID = CurAuthor.JournalID;
IList<ReviewBillEntity> list = service.GetReviewBillList(query);
return Json(new { list });
}
public ActionResult GetReviewBillTree(string defaultText)
{
ReviewBillQuery query = new ReviewBillQuery();
query.JournalID = JournalID;
IFlowFacadeService service = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>();
var list = service.GetReviewBillTreeList(query);
if (!string.IsNullOrWhiteSpace(defaultText))
list[0].text = Server.UrlDecode(defaultText);
return Content(JsonConvert.SerializeObject(list));
}
private ReviewBillEntity GetReviewBillModel(Int64 ItemID)
{
ReviewBillEntity model = null;
if (ItemID > 0)
{
ReviewBillQuery query = new ReviewBillQuery();
query.JournalID = CurAuthor.JournalID;
query.ItemID = ItemID;
IFlowFacadeService service = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>();
model = service.GetReviewBillModel(query);
}
if (model == null)
model = new ReviewBillEntity();
return model;
}
public ActionResult DelReviewBill(Int64 ItemID)
{
IFlowFacadeService service = ServiceContainer.Instance.Container.Resolve<IFlowFacadeService>();
ReviewBillQuery query = new ReviewBillQuery();
query.JournalID = CurAuthor.JournalID;
query.ItemID = ItemID;
ExecResult result = service.DelReviewBill(query);
return Json(new { result = result.result, msg = result.msg });
}
/// <summary>
/// 获取审稿单项分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<ReviewBillEntity> GetReviewBillPageList(ReviewBillQuery query)
{
string strSql = "SELECT *,ROW_NUMBER() OVER(ORDER BY SortID ASC) AS ROW_ID FROM dbo.ReviewBill with(nolock)",
sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.ReviewBill with(nolock)";
string whereSQL = GetReviewBillFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
sumStr += " WHERE " + whereSQL;
}
return db.GetPageList<ReviewBillEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex)
, sumStr
, query.CurrentPage, query.PageSize
, (dr, pager) =>
{
pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]);
}
, MakeReviewBillList);
}
public ExecResult DelReviewBill(ReviewBillQuery query)
{
IReviewBillService service = ServiceContainer.Instance.Container.Resolve<IReviewBillService>();
return service.DelReviewBill(query.JournalID, query.ItemID);
}
/// <summary>
/// 删除审稿单项
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult DelReviewBill(ReviewBillQuery query)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.PostAuth<ExecResult, ReviewBillQuery>(GetAPIUrl(APIConstant.REVIEWBILL_DEL), query);
return result;
}
/// <summary>
/// 获取审稿单项数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<ReviewBillEntity> GetReviewBillList(ReviewBillQuery query)
{
string strSql = "SELECT * FROM dbo.ReviewBill with(nolock)";
string whereSQL = GetReviewBillFilter(query);
if (!string.IsNullOrWhiteSpace(whereSQL))
{
strSql += " WHERE " + whereSQL;
}
strSql += " order by SortID";
return db.GetList<ReviewBillEntity>(strSql, MakeReviewBillList);
}
public Pager<ReviewBillEntity> GetReviewBillPageList(ReviewBillQuery query)
{
IReviewBillService service = ServiceContainer.Instance.Container.Resolve<IReviewBillService>();
Pager<ReviewBillEntity> pager = service.GetReviewBillPageList(query);
return pager;
}
public ReviewBillEntity GetReviewBilllModel(ReviewBillQuery query)
{
IReviewBillService service = ServiceContainer.Instance.Container.Resolve<IReviewBillService>();
ReviewBillEntity model = service.GetReviewBill(query.ItemID);
return model;
}
public IList<ReviewBillEntity> GetReviewBillList(ReviewBillQuery query)
{
IReviewBillService service = ServiceContainer.Instance.Container.Resolve<IReviewBillService>();
IList<ReviewBillEntity> list = service.GetReviewBillList(query);
return list;
}
/// <summary>
/// 获取审稿单项分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<ReviewBillEntity> GetReviewBillPageList(ReviewBillQuery query)
{
return ReviewBillBusProvider.GetReviewBillPageList(query);
}
/// <summary>
/// 获取查询条件
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
private string GetReviewBillFilter(ReviewBillQuery query)
{
StringBuilder strFilter = new StringBuilder(" JournalID = " + query.JournalID);
if (query.PItemID != null)
strFilter.Append(" and PItemID=").Append(query.PItemID.Value);
return strFilter.ToString();
}
/// <summary>
/// 获取审稿单项分页数据
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public Pager<ReviewBillEntity> GetReviewBillPageList(ReviewBillQuery query)
{
return ReviewBillDataAccess.Instance.GetReviewBillPageList(query);
}
public bool ReviewBillIsEnabled(ReviewBillQuery query)
{
IReviewBillService service = ServiceContainer.Instance.Container.Resolve<IReviewBillService>();
return service.ReviewBillIsEnabled(query.JournalID, query.ItemID);
}
