/// <summary>
/// 根据教育培训主键删除一个教育培训信息
/// </summary>
/// <param name="trainingId">教育培训主键</param>
public static void DeleteTrainingByTrainingId(string trainingId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.EduTrain_TrainRecord training = db.EduTrain_TrainRecord.FirstOrDefault(e => e.TrainingId == trainingId);
if (training != null)
{
///删除培训明细
EduTrain_TrainRecordDetailService.DeleteTrainDetailByTrainingId(trainingId);
///删除编码表记录
CodeRecordsService.DeleteCodeRecordsByDataId(training.TrainingId);
////删除附件表
CommonService.DeleteAttachFileById(training.TrainingId);
///删除工程师日志收集记录
var flowOperate = from x in db.Sys_FlowOperate where x.DataId == training.TrainingId select x;
if (flowOperate.Count() > 0)
{
var details = BLL.EduTrain_TrainRecordDetailService.GetTrainRecordDetailByTrainingId(training.TrainingId);
foreach (var item in flowOperate)
{
BLL.HSSELogService.CollectHSSELog(training.ProjectId, item.OperaterId, item.OperaterTime, "27", training.TrainContent, Const.BtnDelete, details.Count());
}
////删除流程表
BLL.CommonService.DeleteFlowOperateByID(training.TrainingId);
}
///删除培训试卷
EduTrain_TrainTestService.DeleteTrainTestByTrainingId(training.TrainingId);
db.EduTrain_TrainRecord.DeleteOnSubmit(training);
db.SubmitChanges();
}
}
/// <summary>
/// 插入培训人员 3
/// </summary>
/// <param name="projectId"></param>
/// <param name="arr"></param>
public static bool AddTrainRecordPerson(string projectId, JArray arr, Model.Sys_User user)
{
Model.SUBHSSEDB db = Funs.DB;
bool isOk = true;
try
{
foreach (var item in arr)
{
string trainingId = null; ////培训记录ID
var getTrainRecord = db.EduTrain_TrainRecord.FirstOrDefault(x => x.FromRecordId == item["RecordId"].ToString());
if (getTrainRecord != null)
{
trainingId = getTrainRecord.TrainingId;
}
string personId = null; ///人员信息ID
var getPerson = db.SitePerson_Person.FirstOrDefault(x => x.IdentityCard == item["IdentifyId"].ToString());
if (getPerson != null)
{
personId = getPerson.PersonId;
}
bool checkResult = false;
if (item["IsPass"].ToString() == "1")
{
checkResult = true;
}
if (!string.IsNullOrEmpty(trainingId) && !string.IsNullOrEmpty(personId))
{
Model.EduTrain_TrainRecordDetail newTrainRecordDetail = new Model.EduTrain_TrainRecordDetail
{
TrainingId = trainingId,
PersonId = personId,
CheckScore = Funs.GetNewDecimal(item["Score"].ToString()),
CheckResult = checkResult,
};
var getTrainRecordDetail = db.EduTrain_TrainRecordDetail.FirstOrDefault(x => x.TrainingId == trainingId && x.PersonId == personId);
if (getTrainRecordDetail == null)
{
EduTrain_TrainRecordDetailService.AddTrainDetail(newTrainRecordDetail);
}
else
{
getTrainRecordDetail.CheckScore = newTrainRecordDetail.CheckScore;
getTrainRecordDetail.CheckResult = newTrainRecordDetail.CheckResult;
EduTrain_TrainRecordDetailService.UpdateTrainDetail(getTrainRecordDetail);
}
}
else
{
isOk = false;
}
}
}
catch (Exception ex)
{
isOk = false;
ErrLogInfo.WriteLog(string.Empty, ex);
}
return(isOk);
}