//var q = this.DbContext.Query<WikiDocument>().FilterDeleted().WhereIfNotNullOrEmpty(keyword, a => a.Title.Contains(keyword) || a.Tag.Contains(keyword));
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="page">分页信息</param>
/// <param name="keyword">关键词</param>
/// <returns>返回分页数据</returns>
public PagedData <role> GetPageData(ACEPagination page, string keyword)
{
//查询相关的字段，根据页面的指定的字段
PagedData <role> pageData = new PagedData <role>();
pageData = TakePageData(page);
try
{
if (string.IsNullOrEmpty(keyword))
{
pageData = TakePageData(page);
}
else if (changeParse(keyword))
{
pageData.DataList = pageData.DataList.Where(a => a.id == Convert.ToInt32(keyword)).ToList <role>();
}
else
{
pageData.DataList = pageData.DataList.Where(a => a.rolename.Contains(keyword)).ToList <role>();
}
return(pageData);
}
catch (Exception)
{
return(null);
}
}
//显示数据，树形
public ActionResult GetModels(ACEPagination pagination, string keyword)
{
try
{
var pagedData = IdalCommon.IareaEx.getEntityList();
//PagedData<area> pagedData = IdalCommon.IareaEx.GetPageData(pagination, keyword);
// var data = pageData.DataList;
if (!string.IsNullOrEmpty(keyword))
{
if (IdalCommon.IareaEx.changeParse(keyword))
{
pagedData = TreeJson.TreeWhere(pagedData, a => a.encode.Contains(keyword), a => a.id.ToString(), a => a.parentid.ToString());
}
else
{
pagedData = TreeJson.TreeWhere(pagedData, a => a.fullname.Contains(keyword), a => a.id.ToString(), a => a.parentid.ToString());
}
}
List <DataTableTree> ret = new List <DataTableTree>(); //构建区域树
DataTableTree.AppendChildren(pagedData, ref ret, null, 0, a => a.id.ToString(), a => a.parentid); //将id、parentid需转化成string型
return(this.SuccessData(ret));
}
catch (Exception)
{
return(this.FailedMsg("显示出错"));
}
}
/// <summary>
///
/// </summary>
/// <param name="page"></param>
/// <param name="keyword"></param>
/// <returns></returns>
public PagedData <workflownodeaction> GetPageData(ACEPagination page, string keyword)
{
PagedData <workflownodeaction> pageData = new PagedData <workflownodeaction>();
pageData = TakePageData(page);
try
{
if (string.IsNullOrEmpty(keyword))
{
pageData = TakePageData(page);
}
else if (changeParse(keyword))
{
pageData.DataList = pageData.DataList.Where(a => a.id == Convert.ToInt32(keyword)).ToList <workflownodeaction>();
}
else
{
pageData.DataList = pageData.DataList.Where(a => a.nodeactionname.Contains(keyword)).ToList <workflownodeaction>();
}
return(pageData);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public ActionResult GetModels(ACEPagination pagination, string keyword)
{
var data = IdalCommon.IworkflowEx.getEntityList();
PagedData <workflow> pagedData = IdalCommon.IworkflowEx.GetPageData(pagination, keyword);
return(this.SuccessData(pagedData));
}
/// <summary>
/// 查看数据
/// </summary>
/// <param name="keyword">搜索框关键词</param>
/// <returns></returns>
public ActionResult GetModels(ACEPagination pagination, string keyword)
{
try
{
//resourceEx reex = new resourceEx();
//分页代码
//return this.SuccessData(IdalCommon.IresourceEx.GetTreePageData(pagination, keyword));
#region
var pagedData = IdalCommon.IresourceEx.getEntityList();
if (!string.IsNullOrEmpty(keyword))
{
pagedData = TreeJson.TreeWhere(pagedData, a => a.resourcename.Contains(keyword), a => a.id.ToString(), a => a.resourceowner);
}
List <DataTableTree> ret = new List <DataTableTree>();
DataTableTree.AppendChildren(pagedData, ref ret, null, 0, a => a.id.ToString(), a => a.resourceowner);
return(this.SuccessData(ret));
#endregion
}
catch (Exception)
{
return(this.FailedMsg("出错！"));
}
}
//获取action表的所有数据
public ActionResult GetModels(ACEPagination pagination, string keyword)//根据搜索框的keyword值获取数据
{
//var data = IdalCommon.IactionEx.getEntityList();
//return this.SuccessData(data);
PagedData <action> pageData = IdalCommon.IactionEx.GetPageData(pagination, keyword);
return(this.SuccessData(pageData));
}
public PagedData <TEntity> TakePageData(ACEPagination page)
{
PagedData <TEntity> pageData = page.ToPagedData <TEntity>();
pageData.DataList = getPageGroup(page.Page, page.PageSize); //获取当前页数据
pageData.TotalCount = getEntityList().Count(); //总数据条数
return(pageData); //pageData:返回分页信息
}
/// <summary>
/// 高级查询+分页
/// </summary>
/// <param name="searchStr">查询条件，拼接格式为("key=groupname，value=总经理")</param>
/// <returns>string ：拼接后的where条件</returns>
/// 前台的数据格式："{\"groupOp\":\"AND\",\"rules\":[{\"field\":\"id\",\"op\":\"eq\",\"data\":\"54\"},{\"field\":\"actioncode\",\"op\":\"lt\",\"data\":\"454\"}]}"
public PagedData <TEntity> mutiplySearch(string filters, ACEPagination pagination, string tableName)
{
PagedData <TEntity> pagedData = TakePageData(pagination);
MutiplySearch.Search obj = Json.ToObject <MutiplySearch.Search>(filters);
List <TEntity> list = getSql(obj, tableName);
pagedData.TotalCount = list.Count();
pagedData.DataList = list;
return(pagedData);
}
/// <summary>
/// 查看数据
/// </summary>
/// <param name="keyword">搜索框关键词</param>
/// <returns></returns>
public ActionResult GetModels(ACEPagination pagination, string keyword)
{
try
{
//List<propertymapping> pagedData = IdalCommon.IpropertyMappingEx.getEntityList();
PagedData <propertymapping> pagedData = IdalCommon.IpropertyMappingEx.GetPageData(pagination, keyword);
return(this.SuccessData(pagedData));
}
catch (Exception)
{
return(this.FailedMsg("出错！"));
}
}
public ActionResult GetModels(ACEPagination pagination, string keyword, string filters)
{
PagedData <article> pagedData = new PagedData <article>();
if (!string.IsNullOrEmpty(filters))
{
filters = SqlFilter.SqlFilters(filters); //过滤特殊字符
pagedData = IdalCommon.IarticleEx.mutiplySearch(filters, pagination, "article");
}
else
{
pagedData = IdalCommon.IarticleEx.GetPageData(pagination, keyword);
}
return(this.SuccessData(pagedData));
}
//var q = this.DbContext.Query<WikiDocument>().FilterDeleted().WhereIfNotNullOrEmpty(keyword, a => a.Title.Contains(keyword) || a.Tag.Contains(keyword));
/// <summary>
/// 获取分页数据
/// </summary>
/// <param name="page">分页信息</param>
/// <param name="keyword">关键词</param>
/// <returns>返回分页数据</returns>
public PagedData <propertymapping> GetPageData(ACEPagination page, string keyword)
{
//查询相关的字段，根据页面的指定的字段
PagedData <propertymapping> pageData = new PagedData <propertymapping>();
pageData = TakePageData(page);
try
{
if (string.IsNullOrEmpty(keyword))
{
pageData = TakePageData(page);
}
else
{
pageData.DataList = pageData.DataList.Where(a => a.propertyName.Contains(keyword)).ToList <propertymapping>();
}
return(pageData);
}
catch (Exception)
{
return(null);
}
}
//获取树形分页数据
public PagedData <DataTableTree> GetTreePageData(ACEPagination page, string keyword)
{
//查询相关的字段，根据页面的指定的字段
List <DataTableTree> listtree = new List <DataTableTree>();
PagedData <DataTableTree> pageData = new PagedData <DataTableTree>(listtree, 100, 1, 20);
List <resource> res = new List <resource>();
List <resource> resall = new List <resource>();
res = this.getPageGroup(page.Page, page.PageSize); //获取当前页资源数据
//pageData = TakePageData(page);
try
{
if (string.IsNullOrEmpty(keyword))
{
resall = this.getEntityList();//获取的资源总条数
DataTableTree.AppendChildren(res, ref listtree, null, 0, a => a.id.ToString(), a => a.resourceowner);
pageData = new PagedData <DataTableTree>(listtree, resall.Count, page.Page, page.PageSize);
}
else
{
resall = this.getEntityList().Where(a => a.resourcename.Contains(keyword)).ToList <resource>();//获取的资源总条数
DataTableTree.AppendChildren(resall, ref listtree, null, 0, a => a.id.ToString(), a => a.resourceowner);
pageData = new PagedData <DataTableTree>(listtree, resall.Count, page.Page, page.PageSize);
}
// pageData.DataList = listtree;
// pageData.TotalCount = resall. Count; ////总数据条数
//pageData.DataList = pageData.DataList.Where(a => a.resourcename.Contains(keyword)).ToList<resource>();
return(pageData);
}
catch (Exception)
{
return(null);
}
//return pageData;
}
