/// <summary>
/// 查询财务类别分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List <FinanceCateEntity> GetList(FinanceCateEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete)
.And(a => a.CompanyID == this.CompanyID);
if (!entity.CateNum.IsEmpty())
{
entity.And("CateNum", ECondition.Like, "%" + entity.CateNum + "%");
}
if (!entity.CateName.IsEmpty())
{
entity.And("CateName", ECondition.Like, "%" + entity.CateName + "%");
}
entity.OrderBy(a => a.ID, EOrderBy.DESC);
int rowCount = 0;
List <FinanceCateEntity> list = this.FinanceCate.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
return(list);
}
/// <summary>
/// 查询所有的财务类别
/// </summary>
/// <returns></returns>
public List <FinanceCateEntity> GetList()
{
string Key = string.Format(CacheKey.JOOSHOW_FINANCECATE_CACHE, this.CompanyID);
List <FinanceCateEntity> list = CacheHelper.Get(Key) as List <FinanceCateEntity>;
if (!list.IsNullOrEmpty())
{
return(list);
}
FinanceCateEntity entity = new FinanceCateEntity();
entity.OrderBy(a => a.ID, EOrderBy.DESC);
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete)
.And(a => a.CompanyID == this.CompanyID);
list = this.FinanceCate.GetList(entity);
if (!list.IsNullOrEmpty())
{
CacheHelper.Insert(Key, list);
}
return(list);
}