public WebApiResult <List <combotree> > GetBuildList(string Property)
{
List <D_Build> Data;
List <combotree> tree = new List <combotree>();
if (Property.IsNullOrEmpty())
{
IQueryable <Sys_DataDict> DictionaryList = new Sys_DataDictBLL().GetList(p => p.DataDict_ParentCode == "47");
Data = new D_BuildBLL().GetAll().ToList();
DictionaryList.ForEach(p =>
{
tree.Add(new combotree {
id = p.DataDict_Code, text = p.DataDict_Name, attributes = "", children = children(p.DataDict_Code, Data)
});
});
}
else
{
Sys_DataDict DictionaryInfo = new Sys_DataDictBLL().Get(p => p.DataDict_Code == Property);
Data = new D_BuildBLL().GetList(p => p.Property == Property).ToList();
tree.Add(new combotree {
id = Property, text = DictionaryInfo.DataDict_Name, attributes = "", children = children("", Data)
});
}
var result = new WebApiPagingResult <List <combotree> >
{
Data = tree
};
return(result);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="paging">分页参数</param>
/// <returns>返回数据列表</returns>
public WebApiPagingResult<IQueryable<Basic_Logs>> List(PagingOptions paging)
{
var result = new WebApiPagingResult<IQueryable<Basic_Logs>>
{
Data = from item in DataContext.Basic_Logs
orderby item.LogTime descending
select item
};
return result.AsPaging(paging);
}
/// <summary>
/// 将 WebApiPagingResult 实例数据进行分页处理
/// </summary>
/// <typeparam name="T">数据实体类型</typeparam>
/// <param name="helper">helper</param>
/// <param name="options">分页参数</param>
/// <returns>返回数据分页后的 WebApiPagingResult 实例</returns>
public static WebApiPagingResult <IQueryable <T> > AsPaging <T>(
this WebApiPagingResult <IQueryable <T> > helper, PagingOptions options)
{
if (helper.Data != null && options != null)
{
var queryable = helper.Data;
#region Filters
var filters = options.GetFilter();
if (!string.IsNullOrWhiteSpace(filters))
{
queryable = queryable.Where(filters, options.FilterParameters);
var queryable2 = queryable.Where(filters, options.FilterParameters);
helper.RowsCount = queryable2.Count();
}
else
{
var queryable2 = queryable.Where("true");
helper.RowsCount = queryable2.Count();
}
#endregion
#region Sort
var sort = options.GetOrder();
if (!string.IsNullOrWhiteSpace(sort))
{
queryable = queryable.OrderBy(sort);
}
#endregion
#region Paging
if (options.PageIndex > 0 && options.PageSize > 0)
{
queryable = queryable.Skip((options.PageIndex - 1) * options.PageSize).Take(options.PageSize);
}
#endregion
helper.Data = queryable;
}
return(helper);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="paging">分页参数</param>
/// <returns>返回数据列表</returns>
public WebApiPagingResult<IQueryable<Basic_Announcement>> List(PagingOptions paging)
{
var result = new WebApiPagingResult<IQueryable<Basic_Announcement>>
{
Data = from item in DataContext.Basic_Announcement
where item.Deleted == false
orderby item.CreatedAt descending
select item
};
return result.AsPaging(paging);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="paging">分页参数</param>
/// <returns>返回数据列表</returns>
public virtual WebApiPagingResult<IQueryable<Product_ProductDefinition>> List(PagingOptions paging)
{
var result = new WebApiPagingResult<IQueryable<Product_ProductDefinition>>
{
Data = from item in DataContext.Product_ProductDefinition
orderby item.SortOrder
where item.Deleted == false
select item
};
return result.AsPaging(paging);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="paging">分页参数</param>
/// <returns>返回数据列表</returns>
public virtual WebApiPagingResult<IQueryable<Basic_CompanyInfo>> List(PagingOptions paging)
{
var result = new WebApiPagingResult<IQueryable<Basic_CompanyInfo>>
{
Data = from item in DataContext.Basic_CompanyInfo
orderby item.SortOrder
where item.Deleted == false
select item
};
return result.AsPaging(paging);
}
/// <summary>
/// 获取数据列表
/// </summary>
/// <param name="paging">分页参数</param>
/// <param name="ParentId">子节点查询条件</param>
/// <returns>返回数据列表</returns>
public virtual WebApiPagingResult<IQueryable<Basic_DataDictionary>> SubList(PagingOptions paging, Guid? ParentId)
{
var result = new WebApiPagingResult<IQueryable<Basic_DataDictionary>>
{
Data = from item in DataContext.Basic_DataDictionary
orderby item.SortOrder
where item.Deleted == false && item.ParentId == ParentId
select item
};
return result.AsPaging(paging);
}
