/// <summary>
/// 添加考核明细时 得到实际考核分数
/// </summary>
/// <param name="safetyDataCheckItem">提交时间未空的考核计划明细集合</param>
private static void GetSafetyDataCheckItemRealScore(Model.SafetyData_SafetyDataCheckItem safetyDataCheckItem)
{
///考核项目
var safetyDataCheckProject = BLL.SafetyDataCheckItemService.GetSafetyDataCheckProjectBySafetyDataCheckProjectId(safetyDataCheckItem.SafetyDataCheckProjectId);
if (safetyDataCheckProject != null)
{
/// 考核项目、考核资料项、考核时间内 是否存在资料
var safetyDataItem = from x in Funs.DB.SafetyData_SafetyDataItem
where x.ProjectId == safetyDataCheckProject.ProjectId && x.SafetyDataId == safetyDataCheckItem.SafetyDataId && x.CompileDate >= safetyDataCheckItem.StartDate && x.CompileDate <= safetyDataCheckItem.EndDate
orderby x.SubmitDate
select x;
if (safetyDataItem.Count() > 0)
{
safetyDataCheckItem.SubmitDate = safetyDataItem.FirstOrDefault().SubmitDate;
if (safetyDataCheckItem.SubmitDate <= safetyDataCheckItem.EndDate || safetyDataCheckItem.ShouldScore < 0) ///准时提交
{
safetyDataCheckItem.RealScore = safetyDataCheckItem.ShouldScore;
}
else ///超期提交
{
safetyDataCheckItem.RealScore = 0;
}
UpdateSafetyDataCheckItem(safetyDataCheckItem);
}
}
}
/// <summary>
/// 添加企业安全管理资料考核明细
/// </summary>
/// <param name="SafetyDataCheckItem"></param>
public static void AddSafetyDataCheckItem(Model.SafetyData_SafetyDataCheckItem SafetyDataCheckItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyData_SafetyDataCheckItem newSafetyDataCheckItem = new Model.SafetyData_SafetyDataCheckItem
{
SafetyDataCheckItemId = SafetyDataCheckItem.SafetyDataCheckItemId,
SafetyDataCheckProjectId = SafetyDataCheckItem.SafetyDataCheckProjectId,
SafetyDataId = SafetyDataCheckItem.SafetyDataId,
CheckDate = SafetyDataCheckItem.CheckDate,
StartDate = SafetyDataCheckItem.StartDate,
EndDate = SafetyDataCheckItem.EndDate,
ReminderDate = SafetyDataCheckItem.ReminderDate,
SubmitDate = SafetyDataCheckItem.SubmitDate,
ShouldScore = SafetyDataCheckItem.ShouldScore,
RealScore = SafetyDataCheckItem.RealScore,
Remark = SafetyDataCheckItem.Remark,
SafetyDataPlanId = SafetyDataCheckItem.SafetyDataPlanId
};
db.SafetyData_SafetyDataCheckItem.InsertOnSubmit(newSafetyDataCheckItem);
db.SubmitChanges();
if (!newSafetyDataCheckItem.SubmitDate.HasValue)
{
/// 添加考核明细时 得实际到考核分数
GetSafetyDataCheckItemRealScore(newSafetyDataCheckItem);
}
}
/// <summary>
/// 根据主键删除企业安全管理资料考核明细
/// </summary>
/// <param name="SafetyDataCheckItemId"></param>
public static void DeleteSafetyDataCheckItemBySafetyDataCheckItemId(string SafetyDataCheckItemId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyData_SafetyDataCheckItem SafetyDataCheckItem = db.SafetyData_SafetyDataCheckItem.FirstOrDefault(e => e.SafetyDataCheckItemId == SafetyDataCheckItemId);
if (SafetyDataCheckItem != null)
{
db.SafetyData_SafetyDataCheckItem.DeleteOnSubmit(SafetyDataCheckItem);
db.SubmitChanges();
}
}
/// <summary>
/// 修改企业安全管理资料考核明细
/// </summary>
/// <param name="SafetyDataCheckItem"></param>
public static void UpdateSafetyDataCheckItem(Model.SafetyData_SafetyDataCheckItem SafetyDataCheckItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyData_SafetyDataCheckItem newSafetyDataCheckItem = db.SafetyData_SafetyDataCheckItem.FirstOrDefault(e => e.SafetyDataCheckItemId == SafetyDataCheckItem.SafetyDataCheckItemId);
if (newSafetyDataCheckItem != null)
{
newSafetyDataCheckItem.StartDate = SafetyDataCheckItem.StartDate;
newSafetyDataCheckItem.EndDate = SafetyDataCheckItem.EndDate;
newSafetyDataCheckItem.ReminderDate = SafetyDataCheckItem.ReminderDate;
newSafetyDataCheckItem.SubmitDate = SafetyDataCheckItem.SubmitDate;
newSafetyDataCheckItem.ShouldScore = SafetyDataCheckItem.ShouldScore;
newSafetyDataCheckItem.RealScore = SafetyDataCheckItem.RealScore;
newSafetyDataCheckItem.Remark = SafetyDataCheckItem.Remark;
db.SubmitChanges();
if (!newSafetyDataCheckItem.SubmitDate.HasValue)
{
/// 添加考核明细时 得到实际考核分数
GetSafetyDataCheckItemRealScore(newSafetyDataCheckItem);
}
}
}
