public SingleResult <bool> SaveNianDu()
{
SingleResult <bool> singleResult = new SingleResult <bool>();
var time = DateTime.Now.Year;
var query_jilus = GetJilus(0, 1000).Results;
var query_nd = _dbContext.CgJiLu.Where(x => x.Status != -1).GroupBy(x => x.SuoShuNianDu).ToList();
List <CgNianDuKaoHeFen> lists = new List <CgNianDuKaoHeFen>();
query_jilus.ForEach(x =>
{
query_nd.ForEach(p =>
{
if (_dbContext.CgNianDuKaoHeFen.Any(y => y.UserId == x.UserId && y.NianDu == p.Key))
{
UpdateKeYanFen(x.UserId.Value, p.Key);
}
else
{
CgNianDuKaoHeFen result = new CgNianDuKaoHeFen();
result.Id = Guid.NewGuid();
result.UserId = x.UserId.Value;
result.UserName = x.UserName;
result.BuMenId = x.BumenId.Value;
result.BuMenMingCheng = x.Bumen;
result.ZhuanJiZhiWu = x.ZhuanJiZhiWu.ToString();
result.JiaoGuanZhiWu = x.JiaoGuanZhiWu.ToString();
result.NianDu = p.Key;
result.Status = 1;
result.CreateDate = result.LastUpdateDate = DateTime.Now;
lists.Add(result);
}
});
});
if (lists != null && lists.Count > 0)
{
_dbContext.CgNianDuKaoHeFen.AddRange(lists);
}
singleResult.Result = _dbContext.SaveChanges() > 0;
return(singleResult);
}
public SingleResult <bool> UpdateNianDu(CgNianDuKaoHeFen entity)
{
SingleResult <bool> singleResult = new SingleResult <bool>();
try
{
if (_dbContext.CgNianDuKaoHeFen.Any(x => x.Id == entity.Id))
{
var query = _dbContext.CgNianDuKaoHeFen.SingleOrDefault(x => x.Id == entity.Id);
query.KaoHeFen = entity.KaoHeFen;
query.KeYanFen = entity.KeYanFen;
query.LastUpdateDate = DateTime.Now;
}
singleResult.Result = _dbContext.SaveChanges() > 0;
}
catch (Exception ex)
{
_loggerService.LogException(_fapContext.CurrentUser, null, "", ex);
singleResult.Error = new Error("系统未知错误", ex);
}
return(singleResult);
}
