/// <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> /// 插入试卷 4 /// </summary> /// <param name="projectId"></param> /// <param name="arr"></param> public static bool AddEduTrain_TrainTest(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 trainTestId = item["ID"].ToString(); if (!string.IsNullOrEmpty(trainingId) && !string.IsNullOrEmpty(trainTestId)) { Model.EduTrain_TrainTest newTrainTest = new Model.EduTrain_TrainTest { TrainTestId = trainTestId, TrainingId = trainingId, ExamNo = item["ExamNo"].ToString(), GroupNo = item["GroupNo"].ToString(), CourseID = item["CourseID"].ToString(), COrder = Funs.GetNewInt(item["COrder"].ToString()), QsnCode = item["QsnCode"].ToString(), QsnId = item["QsnId"].ToString(), QsnContent = item["QsnContent"].ToString(), QsnFileName = item["QsnFileName"].ToString(), QsnAnswer = item["QsnAnswer"].ToString(), QsnCategory = item["QsnCategory"].ToString(), QsnKind = item["QsnKind"].ToString(), Description = item["Description"].ToString(), QsnImportant = item["QsnImportant"].ToString(), Analysis = item["Analysis"].ToString(), UploadTime = Funs.GetNewDateTime(item["UploadTime"].ToString()), }; var getTrainRecordDetail = db.EduTrain_TrainTest.FirstOrDefault(x => x.TrainTestId == trainTestId); if (getTrainRecordDetail == null) { EduTrain_TrainTestService.AddTrainTest(newTrainTest); } else { newTrainTest.ExamNo = newTrainTest.ExamNo; newTrainTest.GroupNo = newTrainTest.GroupNo; newTrainTest.CourseID = newTrainTest.CourseID; newTrainTest.COrder = newTrainTest.COrder; newTrainTest.QsnCode = newTrainTest.QsnCode; newTrainTest.QsnId = newTrainTest.QsnId; newTrainTest.QsnContent = newTrainTest.QsnContent; newTrainTest.QsnFileName = newTrainTest.QsnFileName; newTrainTest.QsnAnswer = newTrainTest.QsnAnswer; newTrainTest.QsnCategory = newTrainTest.QsnCategory; newTrainTest.QsnKind = newTrainTest.QsnKind; newTrainTest.Description = newTrainTest.Description; newTrainTest.QsnImportant = newTrainTest.QsnImportant; newTrainTest.Analysis = newTrainTest.Analysis; newTrainTest.UploadTime = newTrainTest.UploadTime; db.SubmitChanges(); } } else { isOk = false; } } } catch (Exception ex) { isOk = false; ErrLogInfo.WriteLog(string.Empty, ex); } return(isOk); }