/// <summary>
/// 增加教育培训明细信息
/// </summary>
/// <param name="trainTest">教育培训明细信息实体</param>
public static void AddTrainTest(Model.EduTrain_TrainTest trainTest)
{
Model.SUBHSSEDB db = Funs.DB;
Model.EduTrain_TrainTest newTrainTest = new Model.EduTrain_TrainTest
{
TrainTestId = trainTest.TrainTestId,
TrainingId = trainTest.TrainingId,
ExamNo = trainTest.ExamNo,
GroupNo = trainTest.GroupNo,
CourseID = trainTest.CourseID,
COrder = trainTest.COrder,
QsnCode = trainTest.QsnCode,
QsnId = trainTest.QsnId,
QsnContent = trainTest.QsnContent,
QsnFileName = trainTest.QsnFileName,
QsnAnswer = trainTest.QsnAnswer,
QsnCategory = trainTest.QsnCategory,
QsnKind = trainTest.QsnKind,
Description = trainTest.Description,
QsnImportant = trainTest.QsnImportant,
Analysis = trainTest.Analysis,
UploadTime = trainTest.UploadTime,
};
db.EduTrain_TrainTest.InsertOnSubmit(newTrainTest);
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);
}
