/// <summary>
/// 分页列表
/// </summary>
public PagedList <FeVideoCategory> GetPaging(VideoCategoryQueryRequeest requeest)
{
requeest.Tables = "fevideocategory fvc";
requeest.Tablefields = "fvc.*";
requeest.OrderBy = "fvc.DisplayOrder";
var row = DBContext.Select <FeVideoCategory>(requeest.Tablefields).From(requeest.Tables);
var count = DBContext.Select <int>("count(0)").From(requeest.Tables);
//条件查询委托
Action <string, string, object> setWhere = (@where, name, value) =>
{
row.AndWhere(where).Parameter(name, value);
count.AndWhere(where).Parameter(name, value);
};
if (requeest.ParentSysNo.HasValue)
{
setWhere("fvc.ParentSysNo = @ParentSysNo", "ParentSysNo", requeest.ParentSysNo);
}
if (requeest.Status.HasValue)
{
setWhere("fvc.Status = @Status", "Status", requeest.Status);
}
var list = new PagedList <FeVideoCategory>
{
TData = row.Paging(requeest.CurrentPageIndex.GetHashCode(), requeest.PageSize.GetHashCode()).OrderBy(requeest.OrderBy).QueryMany(),
CurrentPageIndex = requeest.CurrentPageIndex.GetHashCode(),
TotalCount = count.QuerySingle(),
};
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
public List <FeVideoCategory> GetForumList(VideoCategoryQueryRequeest request)
{
var dataList = DBContext.Select <FeVideoCategory>("*").From("fevideocategory");
Action <string, string, object> setWhere = (@where, name, value) => dataList.AndWhere(@where).Parameter(name, value);
if (request.Status.HasValue)
{
setWhere("Status = @Status", "Status", request.Status.Value);
}
return(dataList.QueryMany());
}
/// <summary>
/// 分页列表
/// </summary>
public PagedList <FeVideoCategory> GetPaging(VideoCategoryQueryRequeest requeest)
{
return(Using <IVideoCategory>().GetPaging(requeest));
}
/// <summary>
/// 获取列表
/// </summary>
public List <FeVideoCategory> GetForumList(VideoCategoryQueryRequeest request)
{
return(Using <IVideoCategory>().GetForumList(request));
}
