/// <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);
}
