/// <summary> /// 添加财务类别 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Add(FinanceCateEntity entity) { string Key = string.Format(CacheKey.JOOSHOW_FINANCECATE_CACHE, this.CompanyID); entity.SnNum = entity.SnNum.IsEmpty() ? ConvertHelper.NewGuid():entity.SnNum; entity.CateNum = entity.CateNum.IsEmpty() ? new SequenceProvider(this.CompanyID).GetSequence(typeof(FinanceCateEntity)) : entity.CateNum; entity.IncludeAll(); int line = this.FinanceCate.Add(entity); if (line > 0) { CacheHelper.Remove(Key); } return(line); }
/// <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); }