/// <summary>
/// 根据主键删除企业安全管理资料计划总表
/// </summary>
/// <param name="SafetyDataEPlanId"></param>
public static void DeleteSafetyDataEPlanByID(string SafetyDataEPlanId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyDataE_SafetyDataEPlan SafetyDataEPlan = db.SafetyDataE_SafetyDataEPlan.FirstOrDefault(e => e.SafetyDataEPlanId == SafetyDataEPlanId);
if (SafetyDataEPlan != null)
{
db.SafetyDataE_SafetyDataEPlan.DeleteOnSubmit(SafetyDataEPlan);
db.SubmitChanges();
}
}
/// <summary>
/// 添加企业安全管理资料计划总表
/// </summary>
/// <param name="SafetyDataEPlan"></param>
public static void AddSafetyDataEPlan(Model.SafetyDataE_SafetyDataEPlan SafetyDataEPlan)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyDataE_SafetyDataEPlan newSafetyDataEPlan = new Model.SafetyDataE_SafetyDataEPlan
{
SafetyDataEPlanId = SafetyDataEPlan.SafetyDataEPlanId,
ProjectId = SafetyDataEPlan.ProjectId,
SafetyDataEId = SafetyDataEPlan.SafetyDataEId,
CheckDate = SafetyDataEPlan.CheckDate,
Score = SafetyDataEPlan.Score,
ShouldScore = SafetyDataEPlan.ShouldScore,
Remark = SafetyDataEPlan.Remark,
ReminderDate = SafetyDataEPlan.ReminderDate,
IsManual = SafetyDataEPlan.IsManual,
States = SafetyDataEPlan.States,
};
db.SafetyDataE_SafetyDataEPlan.InsertOnSubmit(newSafetyDataEPlan);
db.SubmitChanges();
}
/// <summary>
/// 修改企业安全管理资料计划总表
/// </summary>
/// <param name="SafetyDataEPlan"></param>
public static void UpdateSafetyDataEPlan(Model.SafetyDataE_SafetyDataEPlan SafetyDataEPlan)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyDataE_SafetyDataEPlan newSafetyDataEPlan = db.SafetyDataE_SafetyDataEPlan.FirstOrDefault(e => e.SafetyDataEPlanId == SafetyDataEPlan.SafetyDataEPlanId);
if (newSafetyDataEPlan != null)
{
newSafetyDataEPlan.CheckDate = SafetyDataEPlan.CheckDate;
newSafetyDataEPlan.Score = SafetyDataEPlan.Score;
newSafetyDataEPlan.Remark = SafetyDataEPlan.Remark;
newSafetyDataEPlan.ReminderDate = SafetyDataEPlan.ReminderDate;
newSafetyDataEPlan.States = SafetyDataEPlan.States;
db.SubmitChanges();
///当前计划项 没有提交时间时
if (newSafetyDataEPlan.States == BLL.Const.State_2 && !newSafetyDataEPlan.RealScore.HasValue)
{
GetSafetyDataEPlanRealScore(newSafetyDataEPlan);
}
}
}
/// <summary>
/// 添加考核明细时 得到实际考核分数
/// </summary>
/// <param name="SafetyDataEPlan">提交时间未空的考核计划明细集合</param>
private static void GetSafetyDataEPlanRealScore(Model.SafetyDataE_SafetyDataEPlan SafetyDataEPlan)
{
/// 考核项目、考核资料项、考核时间内 是否存在资料
var SafetyDataEItem = from x in Funs.DB.SafetyDataE_SafetyDataEItem
where x.ProjectId == SafetyDataEPlan.ProjectId && x.SafetyDataEId == SafetyDataEPlan.SafetyDataEId
orderby x.SubmitDate
select x;
if (SafetyDataEItem.Count() > 0)
{
SafetyDataEPlan.SubmitDate = SafetyDataEItem.FirstOrDefault().SubmitDate;
if (SafetyDataEPlan.SubmitDate <= SafetyDataEPlan.CheckDate || SafetyDataEPlan.ShouldScore <= 0) ///准时提交
{
SafetyDataEPlan.RealScore = SafetyDataEPlan.ShouldScore;
}
else ///超期提交
{
SafetyDataEPlan.RealScore = 0;
}
UpdateSafetyDataEPlan(SafetyDataEPlan);
}
}