/// <summary>
/// 保存用户
/// </summary>
/// <param name="model">用户</param>
/// <returns>主键ID</returns>
public async Task <int> SaveUserAsync(User model)
{
using (IOSysContext db = new IOSysContext())
{
//更新
if (model.ID > 0)
{
db.Entry(model).State = EntityState.Modified;
}
//新增
else
{
await db.Users.AddAsync(model);
}
await db.SaveChangesAsync();
}
//移除缓存
var key = string.Format(SysConst.Cache.UserList_FamilyID, model.FamilyID);
CacheHelper.Remove(key);
return(model.ID);
}
/// <summary>
/// 保存支出类型
/// </summary>
/// <param name="list">支出类型</param>
/// <returns>改动条数</returns>
public async Task <int> SaveOutTypesAsync(List <OutType> list)
{
int retCount = 0;
using (IOSysContext db = new IOSysContext())
{
foreach (var model in list)
{
//更新
if (model.ID > 0)
{
db.Entry(model).State = EntityState.Modified;
}
//新增
else
{
await db.OutTypes.AddAsync(model);
}
}
retCount = await db.SaveChangesAsync();
}
//家庭ID
var lstFamilyID = list.Select(m => m.FamilyID).Distinct().ToList();
foreach (var familyID in lstFamilyID)
{
//移除缓存
var key = string.Format(SysConst.Cache.OutTypeList_FamilyID, familyID);
CacheHelper.Remove(key);
}
return(retCount);
}
/// <summary>
/// 修改使用的账户
/// </summary>
/// <param name="familyID">家庭ID</param>
/// <param name="newAmountAccountID">新账户ID</param>
/// <param name="newAmount">新金额</param>
/// <param name="oldAmountAccountID">原账户ID</param>
/// <param name="oldAmount">原金额</param>
/// <param name="db">数据库上下文</param>
public async Task ChangeAmountAccount(int familyID, int newAmountAccountID, decimal newAmount, int?oldAmountAccountID, decimal?oldAmount, IOSysContext db)
{
//新增使用账户
if (oldAmountAccountID.HasValue == false)
{
await this.UseAmountAccount(familyID, newAmountAccountID, newAmount, db);
}
//只修改了金额
else if (newAmountAccountID == oldAmountAccountID.Value)
{
var model = await this.GetAmountAccountAsync(familyID, newAmountAccountID);
model.Amount += (newAmount - oldAmount.Value);
db.Entry(model).State = EntityState.Modified;
}
//修改了账户
else
{
var taskUse = this.UseAmountAccount(familyID, newAmountAccountID, newAmount, db);
var taskUnuse = this.UnUseAmountAccount(familyID, oldAmountAccountID.Value, oldAmount.Value, db);
await taskUse;
await taskUnuse;
}
}
/// <summary>
/// 保存更新账户排序权重字段
/// </summary>
/// <param name="list">账户</param>
/// <returns>修改条数</returns>
public async Task <int> UpdateAmountAccountSortWeightAsync(List <AmountAccount> list)
{
int retCount = 0;
using (IOSysContext db = new IOSysContext())
{
foreach (var model in list)
{
//更新
if (model.ID > 0)
{
db.Entry(model).Property(m => m.SortWeight).IsModified = true;
}
}
retCount = await db.SaveChangesAsync();
}
//家庭ID
var lstFamilyID = list.Select(m => m.FamilyID).Distinct().ToList();
foreach (var familyID in lstFamilyID)
{
//移除缓存
var key = string.Format(SysConst.Cache.AmountAccountList_FamilyID, familyID);
CacheHelper.Remove(key);
}
return(retCount);
}
/// <summary>
/// 反使用账户
/// </summary>
/// <param name="familyID">家庭ID</param>
/// <param name="amountAccountID">账户ID</param>
/// <param name="amount">金额</param>
/// <param name="db">数据库上下文</param>
public async Task UnUseAmountAccount(int familyID, int amountAccountID, decimal amount, IOSysContext db)
{
//获取账户
var model = await this.GetAmountAccountAsync(familyID, amountAccountID);
model.Amount -= amount;
//model.SortWeight -= 1;
db.Entry(model).State = EntityState.Modified;
}
/// <summary>
/// 删除用户
/// </summary>
/// <param name="familyID">家庭ID</param>
/// <param name="userID">用户ID</param>
public async Task DeleteUserAsync(int familyID, int userID)
{
//获取原数据
var model = await this.GetUserAsync(familyID, userID);
if (model == null)
{
return;
}
//设删除标识
model.IsDelete = true;
using (IOSysContext db = new IOSysContext())
{
db.Entry(model).State = EntityState.Modified;
await db.SaveChangesAsync();
}
//移除缓存
var key = string.Format(SysConst.Cache.UserList_FamilyID, familyID);
CacheHelper.Remove(key);
}
/// <summary>
/// 保存收入信息
/// </summary>
/// <param name="model">收入信息</param>
/// <returns>主键ID</returns>
public async Task <int> SaveInComeAsync(InCome model)
{
using (IOSysContext db = new IOSysContext())
{
using (var trans = db.Database.BeginTransaction())
{
InCome oldModel = null;
//尝试查找原数据
if (model.ID > 0)
{
oldModel = db.InComes.AsNoTracking().Where(m => m.ID == model.ID && m.FamilyID == model.FamilyID).FirstOrDefault();
if (oldModel == null)
{
model.CreatorID = model.UpdateID.Value;
model.CreateTime = model.UpdateTime.Value;
}
}
//新增
if (oldModel == null)
{
//新增
await db.InComes.AddAsync(model);
//修改账户信息
await BasicDAL.Inst.UseAmountAccount(model.FamilyID, model.AmountAccountID, model.Amount, db);
////修改收入类型信息
//await BasicDAL.Inst.UseInType(model.FamilyID, model.InTypeID, db);
}
//更新
else
{
//设置更新者信息
model.UpdateID = model.UpdateID;
model.UpdateTime = model.UpdateTime;
model.CreatorID = oldModel.CreatorID;
model.CreateTime = oldModel.CreateTime;
//更新
db.Entry(model).State = EntityState.Modified;
//修改账户信息
await BasicDAL.Inst.ChangeAmountAccount(model.FamilyID, model.AmountAccountID, model.Amount, oldModel.AmountAccountID, oldModel.Amount, db);
////修改收入类型信息
//await BasicDAL.Inst.ChangeInType(model.FamilyID, model.InTypeID, oldModel.InTypeID, db);
}
//保存修改
await db.SaveChangesAsync();
//提交事务
trans.Commit();
}
}
//更新最小交易流水日期缓存
this.UpdateMinTurnoverDate(model.FamilyID, model.InDate);
return(model.ID);
}
/// <summary>
/// 保存借还信息
/// </summary>
/// <param name="model">借还信息</param>
/// <returns>主键ID</returns>
public async Task <int> SaveBorrowRepayAsync(BorrowRepay model)
{
using (IOSysContext db = new IOSysContext())
{
using (var trans = db.Database.BeginTransaction())
{
BorrowRepay oldModel = null;
//尝试查找原数据
if (model.ID > 0)
{
oldModel = db.BorrowRepays.AsNoTracking().Where(m => m.ID == model.ID && m.FamilyID == model.FamilyID).FirstOrDefault();
if (oldModel == null)
{
model.CreatorID = model.UpdateID.Value;
model.CreateTime = model.UpdateTime.Value;
}
}
//新增
if (oldModel == null)
{
//新增
await db.BorrowRepays.AddAsync(model);
//账户金额变动值
var amount = this.GetAmountDirectionForBorrowRepay(model.BRType, model.Amount);
//修改账户信息
await BasicDAL.Inst.UseAmountAccount(model.FamilyID, model.AmountAccountID, amount, db);
}
//更新
else
{
//设置更新者信息
model.UpdateID = model.UpdateID;
model.UpdateTime = model.UpdateTime;
model.CreatorID = oldModel.CreatorID;
model.CreateTime = oldModel.CreateTime;
//更新
db.Entry(model).State = EntityState.Modified;
//账户金额变动值
var newAmount = this.GetAmountDirectionForBorrowRepay(model.BRType, model.Amount);
var oldAmount = this.GetAmountDirectionForBorrowRepay(oldModel.BRType, oldModel.Amount);
//修改账户信息
await BasicDAL.Inst.ChangeAmountAccount(model.FamilyID, model.AmountAccountID, newAmount, oldModel.AmountAccountID, oldAmount, db);
}
//保存修改
await db.SaveChangesAsync();
//提交事务
trans.Commit();
}
}
//更新最小交易流水日期缓存
this.UpdateMinTurnoverDate(model.FamilyID, model.BRDate);
return(model.ID);
}
