public PagesQueryItem GetPageDataPages(PagesQueryItem queryItem)
{
if (!string.IsNullOrWhiteSpace(queryItem.PageTitle))
{
queryItem.Sql += string.Format(" and t.PageTitle like '{0}'", queryItem.PageTitle);
}
if (queryItem.PageTypes > 0)
{
queryItem.Sql += string.Format(" and t.PageTypes={0}", queryItem.PageTypes);
}
if (queryItem.StartCTime != null && queryItem.StartCTime.Year > 2000 && queryItem.EndCTime != null && queryItem.EndCTime.Year > 2000)
{
queryItem.Sql += string.Format(" and t.CTime>='{0}' and t.CTime<='{1}'", queryItem.StartCTime, queryItem.EndCTime);
}
if (queryItem.StartCTime != null && queryItem.StartCTime.Year > 2000 && (queryItem.EndCTime == null || queryItem.EndCTime.Year <= 2000))
{
queryItem.Sql += string.Format(" and t.CTime>='{0}'", queryItem.StartCTime);
}
if ((queryItem.StartCTime == null || queryItem.StartCTime.Year <= 2000) && (queryItem.EndCTime != null && queryItem.EndCTime.Year >= 2000))
{
queryItem.Sql += string.Format(" and t.CTime<='{0}'", queryItem.EndCTime);
}
queryItem.PageData = PageCore <PagesQueryItem> .GetInstance.GetPageData(queryItem.Sql, queryItem.Page, queryItem.Limit, ref queryItem.Totals);
return(queryItem);
}
public TBaseResult <PagesQueryItem> GetPageDataPages(PagesQueryItem queryItem)
{
this.SafetySecretKey = queryItem.SafetySecretKey;
this.Usable = queryItem.IsUsable ? BasePluginType.Type.启用 : BasePluginType.Type.卸载;
var result = new TBaseResult <PagesQueryItem>()
{
Code = (int)EnumCore.CodeType.失败,
Message = "系统错误",
TData = new PagesQueryItem()
};
if (string.IsNullOrWhiteSpace(this.SafetySecretKey) || this.Usable == BasePluginType.Type.卸载 || PluginCore.GetInstance.VerifySafetySecretKey(this.SafetySecretKey))
{
return(result);
}
var dt = MenuManager.GetInstance.GetPageDataPages(queryItem);
result.Code = (int)EnumCore.CodeType.成功;
if (dt.PageData.Count <= 0)
{
result.Message = "暂无数据";
result.TData = dt;
return(result);
}
result.Message = "获取成功";
result.TData = dt;
return(result);
}
public JsonResult GetPageDataPages(PagesQueryItem queryEntity)
{
queryEntity.SafetySecretKey = PluginCore.GetInstance.SafetySecretValue;
queryEntity.IsUsable = true;
var result = IocPlugin.IocGetPageDataPagesPlugin.GetPageDataPages(queryEntity);
var pageResult = result.TData;
var pageList = pageResult.PageData.Select(m =>
{
return(new
{
displayID = m.ID,
displayPageTitle = m.PageTitle,
displayPageIcon = m.PageIcon,
displayPageType = m.GetPageTypeStr,
displayPageSort = m.PageSort,
displayPageUrl = m.PagePathUrl,
displayPageLevel = m.ParentLevel,
displayCTime = m.CTimeStr,
displayOperation = GetDisplayOperationPages(m.OpenId)
});
});
return(Json(new { code = 0, msg = string.Empty, count = pageResult.Totals, data = pageList }, JsonRequestBehavior.AllowGet));
}
