/// <summary>
/// 设置并保存
/// </summary>
/// <param name="db">数据库连接对象</param>
public void SetAndSave(IModelToDbContextOfAuthor db)
{
List<SystemQuota> sqs = db.SystemQuotas.ToList();
sqs.Where(x => !this.Quotas.Any(q => q.Rebate == x.Rebate)).ToList()
.ForEach(x =>
{
db.SystemQuotas.Remove(x);
});
this.Quotas
.ForEach(quota =>
{
SystemQuota sq = sqs.FirstOrDefault(x => x.Rebate == quota.Rebate);
if (sq == null)
{
sq = new SystemQuota(quota.Rebate, new List<SystemQuotaDetail>());
db.SystemQuotas.Add(sq);
}
sq.Details.RemoveAll(x => !quota.Details.Any(d => d.Rebate == x.Rebate));
quota.Details
.ForEach(detail =>
{
SystemQuotaDetail sqd = sq.Details.FirstOrDefault(x => x.Rebate == detail.Rebate);
if (sqd == null)
{
sqd = new SystemQuotaDetail(detail.Rebate, detail.Sum);
sq.Details.Add(sqd);
}
else
{
sqd.Sum = detail.Sum;
}
});
});
db.SaveChanges();
}
