public object QueryManageDetail([FromForm] List <int> employeeIds, [FromForm] KpiPlan kpiId)
{
if (employeeIds.Count() > 0)
{
var condition = new Condition <KpiTemplateRecord>();
condition.And(p => p.KpiType == KpiType.User);
condition.And(p => p.KpiId == kpiId);
if (employeeIds.Count() > 0)
{
condition.And(p => employeeIds.Contains(p.EmployeeId));
}
var lsTpl = _tplRecordBusiness.Query(condition.Combine());
var lsTplContent = new List <KpiTemplateContentsDto>();
if (lsTpl.Count() > 0)
{
foreach (var item in lsTpl)
{
lsTplContent.AddRange(JsonConvert.DeserializeObject <List <KpiTemplateContentsDto> >(item.Contents).ToList());
}
return(lsTplContent
.GroupBy(p => new { p.EvaluationId, p.EvaluationName, p.EvaluationType })
.Select(p => p.Key)
.OrderBy(p => p.EvaluationId)
.Select(p => new EvaluationDto {
Id = p.EvaluationId, Name = p.EvaluationName, EvaluationTypeName = p.EvaluationType
})
.ToList());
}
}
return(new List <EvaluationDto>());
}
public IList <ScheduleKPI> GetByKpi([FromForm] int eid, [FromForm] KpiPlan planId, [FromForm] DateTime startDate, [FromForm] DateTime endDate)
{
//先根据条件获取所有日程
IList <Schedule> list = _scheduleBusiness.GetByKpi(eid, planId, startDate, endDate);
//封装新集合
IList <ScheduleKPI> newList = new List <ScheduleKPI>();
foreach (Schedule item in list)
{
ScheduleKPI sm = new ScheduleKPI();
sm.Id = item.Id;
sm.Title = item.Title;
sm.BeginTime = item.BeginTime;
sm.EndTime = item.EndTime;
sm.KpiManageRecordId = item.KpiManageRecordId;
sm.KpiManageRecordName = item.KpiManageRecordName;
//完成了的集合
IList <ScheduleComplete> cmp = _scheduleCompleteBusiness.Get(item.Id);
//执行人集合
string exestring = item.Executors.Substring(1);
exestring = exestring.Substring(0, exestring.Length - 1);
string[] exes = exestring.Split(",");
//如果完成数等于执行人数
if (cmp.Count >= exes.Length)
{
sm.Completion = "已完成";
}
else
{
sm.Completion = "未完成";
}
newList.Add(sm);
}
return(newList);
}
/// <summary>
/// 查询需要生成的数据
/// </summary>
/// <param name="kpiId">考核方案</param>
/// <param name="year">年份</param>
/// <param name="kpiDate">考核时间</param>
/// <returns></returns>
public List <KpiTemplateRecord> QueryByGenerated(KpiPlan kpiId, int year, string kpiDate)
{
var query = from tr in _dbContext.KpiTemplateRecord
where tr.KpiId == kpiId &
!(
from mr in _dbContext.KpiManageRecord where mr.KpiId == kpiId & mr.Year == year & mr.KpiDate == kpiDate select mr.KpiTemplateRecordId
).Contains(tr.Id)
select tr;
return(query.ToList());
}
public IList <Schedule> GetByKpi(int eid, KpiPlan planId, DateTime startDate, DateTime endDate)
{
List <KeyValuePair <string, OrderBy> > order = new List <KeyValuePair <string, OrderBy> >
{
new KeyValuePair <string, OrderBy>("AddTime", OrderBy.Desc)
};
return(base.Query(p => p.EmployeeId == eid && p.KpiPlan == planId &&
p.EndTime >= startDate.Date
//DateTime.Compare(DateTime.ParseExact(p.EndTime.ToString(), "yyyy-MM-dd", null),
//DateTime.ParseExact(startDate.ToString(), "yyyy-MM-dd", null)) >= 0
&&
p.EndTime <= endDate.Date,
//DateTime.Compare(DateTime.ParseExact(p.EndTime.ToString(), "yyyy-MM-dd", null),
//DateTime.ParseExact(endDate.ToString(), "yyyy-MM-dd", null)) <= 0,
p => p, order));
//&& p.KpiPlan.Equals((KpiPlan)planId) && p.EndTime.ToString("yyyy-MM-dd").Contains(date)
}
public Result GeneratedManage(KpiPlan kpiId)
{
return(_wrappers.GeneratedManage(kpiId));
}
/// <summary>
/// 查询需要生成的数据
/// </summary>
/// <param name="kpiId">考核方案</param>
/// <param name="year">年份</param>
/// <param name="kpiDate">考核时间</param>
/// <returns></returns>
public List <KpiTemplateRecord> QueryByGenerated(KpiPlan kpiId, int year, string kpiDate)
{
return(_repository.QueryByGenerated(kpiId, year, kpiDate));
}
/// <summary>
/// [生成] 考核记录
/// </summary>
/// <param name="kpiId">考核方案</param>
/// <returns></returns>
public Result GeneratedManage(KpiPlan kpiId)
{
try
{
var dtNow = DateTime.Now;
var currTime = 0;
var currYear = dtNow.Year;
switch (kpiId)
{
case KpiPlan.Monthly:
currTime = dtNow.Month;
break;
case KpiPlan.Quarter:
currTime = TimeHelper.GetQurater(dtNow);
break;
case KpiPlan.HalfYear:
currTime = dtNow.Month < 7 ? 1 : 2;
break;
case KpiPlan.Annual:
currTime = 1;
break;
}
var kpiDate = currTime.ToString();
using (TransactionScope ts = new TransactionScope())
{
var dbTplRecord = _tplRecordBusiness.QueryByGenerated(kpiId, currYear, kpiDate);
if (dbTplRecord.Count <= 0)
{
return Result.Fail("没有需要生成的数据", "201");
}
//考核管理统计
var dbMagTotal = _magTotalBusiness.Query(p => p.KpiId == kpiId && p.Year == currYear);
//考核管理统计
var lsNotExistMagTotal = new List<KpiManageTotal>();
var lsExistMagTotal = new List<KpiManageTotal>();
//考核管理记录
var lsNotExistMagRecord = new List<KpiManageRecord>();
//考核管理明细
var lsNotExistMagDetail = new List<KpiManageDetail>();
foreach (var tplRecord in dbTplRecord)
{
#region 考核管理统计
KpiManageTotal modelMagTotal = null;
if (dbMagTotal.Count > 0)
{
modelMagTotal = dbMagTotal.FirstOrDefault(p => p.KpiType == tplRecord.KpiType && p.CompanyId == tplRecord.CompanyId && p.DptId == tplRecord.DptId && p.EmployeeId == tplRecord.EmployeeId);
}
if (modelMagTotal == null)
{
modelMagTotal = new KpiManageTotal()
{
Id = 0,
KpiType = tplRecord.KpiType,
KpiId = tplRecord.KpiId,
KpiName = tplRecord.KpiName,
CompanyId = tplRecord.CompanyId,
CompanyName = tplRecord.CompanyName,
DptId = tplRecord.DptId,
DptName = tplRecord.DptName,
EmployeeId = tplRecord.EmployeeId,
UserName = tplRecord.UserName,
Year = currYear
};
for (int i = 0; i < 12; i++)
{
DynaimcHelper.DynamicFileds[i].Score.SetValue(modelMagTotal, (decimal)0);
if ((i + 1) < currTime)
{
DynaimcHelper.DynamicFileds[i].Status.SetValue(modelMagTotal, KpiStatus.Invalid);
}
else if ((i + 1) == currTime)
{
DynaimcHelper.DynamicFileds[i].Status.SetValue(modelMagTotal, KpiStatus.Assess);
}
else
{
DynaimcHelper.DynamicFileds[i].Status.SetValue(modelMagTotal, KpiStatus.NotStarted);
}
}
lsNotExistMagTotal.Add(modelMagTotal);
}
else
{
for (int i = 0; i < 12; i++)
{
if ((i + 1) == currTime)
{
DynaimcHelper.DynamicFileds[i].Status.SetValue(modelMagTotal, KpiStatus.Assess);
}
}
lsExistMagTotal.Add(modelMagTotal);
}
#endregion
lsNotExistMagRecord.Add(new KpiManageRecord()
{
Id = 0,
KpiTemplateRecordId = tplRecord.Id,
KpiType = tplRecord.KpiType,
KpiId = tplRecord.KpiId,
KpiName = tplRecord.KpiName,
CompanyId = tplRecord.CompanyId,
CompanyName = tplRecord.CompanyName,
DptId = tplRecord.DptId,
DptName = tplRecord.DptName,
EmployeeId = tplRecord.EmployeeId,
UserName = tplRecord.UserName,
Year = currYear,
KpiDate = kpiDate,
Steps = KpiSteps.Zero,
StepsCompanyId = tplRecord.CompanyId,
StepsCompanyName = tplRecord.CompanyName,
StepsDptId = tplRecord.DptId,
StepsDptName = tplRecord.DptName,
StepsEmployeeId = tplRecord.EmployeeId,
StepsUserName = tplRecord.UserName,
AddDate = dtNow,
Score = 0,
Status = KpiStatus.Assess
});
}
_magRecordBusiness.AddRange(lsNotExistMagRecord);
foreach (var magTecord in lsNotExistMagRecord)
{
var modelTplRecord = dbTplRecord.FirstOrDefault(p => p.Id == magTecord.KpiTemplateRecordId);
if (modelTplRecord != null)
{
var lsTplContents = JsonConvert.DeserializeObject<List<KpiTemplateContentsDto>>(modelTplRecord.Contents).OrderBy(p => p.EvaluationId);
foreach (var tplContent in lsTplContents)
{
lsNotExistMagDetail.Add(new KpiManageDetail
{
Id = 0,
KpiManageRecordId = magTecord.Id,
CompanyId = magTecord.CompanyId,
DptId = magTecord.DptId,
EmployeeId = magTecord.EmployeeId,
EvaluationId = tplContent.EvaluationId,
EvaluationName = tplContent.EvaluationName,
EvaluationType = tplContent.EvaluationType,
Weight = tplContent.Weight,
Explain = tplContent.Explain,
Year = magTecord.Year,
KpiDate = magTecord.KpiDate,
SelfScore = 0,
OneScore = 0,
TwoScore = 0
});
}
}
}
if (lsNotExistMagDetail.Count > 0)
{
_magDetailBusiness.AddRange(lsNotExistMagDetail);
}
_magTotalBusiness.AddRange(lsNotExistMagTotal);
if (lsExistMagTotal.Count > 0)
{
_magTotalBusiness.UpdateRange(lsExistMagTotal);
}
ts.Complete();
return Result.Success();
}
}
catch (Exception ex)
{
return Result.Fail("失败：" + ex.Message);
}
}