/// <summary> /// 保存账户 /// </summary> /// <param name="info">账户</param> /// <returns>主键ID</returns> public async Task <ResultInfo <int> > SaveAmountAccountAsync(AmountAccountInfo info) { //获取原有列表 var list = await BasicDAL.Inst.QueryAmountAccountAsync(this.LoginInfo.FamilyID); //判断名称是否已被使用 if (list.Exists(m => m.ID != info.ID && m.Name == info.Name)) { return(new ResultInfo <int>(false, this.Res.Bas.NameExisted, -1)); } //尝试查找原数据 var model = list.Find(m => m.ID == info.ID); //新建 if (model == null) { model = new AmountAccount(); model.FamilyID = this.LoginInfo.FamilyID; model.InitAmount = info.Amount; model.Amount = info.Amount; } model.Name = info.Name; model.IsActive = info.IsActive; model.Remark = info.Remark; //设置创建者/更新者字段值 this.SetCreateUpdateFields(model); //保存到数据库 await BasicDAL.Inst.SaveAmountAccountAsync(model); return(new ResultInfo <int>(true, Res.Gen.OK, model.ID)); }
/// <summary> /// 保存账户 /// </summary> /// <param name="model">账户</param> /// <returns>主键ID</returns> public async Task <int> SaveAmountAccountAsync(AmountAccount model) { using (IOSysContext db = new IOSysContext()) { //更新 if (model.ID > 0) { db.Entry(model).State = EntityState.Modified; } //新增 else { await db.AmountAccounts.AddAsync(model); } await db.SaveChangesAsync(); } //移除缓存 var key = string.Format(SysConst.Cache.AmountAccountList_FamilyID, model.FamilyID); CacheHelper.Remove(key); return(model.ID); }
/// <summary> /// 删除账户 /// </summary> /// <param name="model">账户</param> public async Task DeleteAmountAccountAsync(AmountAccount model) { using (IOSysContext db = new IOSysContext()) { db.AmountAccounts.Remove(model); await db.SaveChangesAsync(); } //移除缓存 var key = string.Format(SysConst.Cache.AmountAccountList_FamilyID, model.FamilyID); CacheHelper.Remove(key); }