/// <summary>
/// 修改试题类型信息
/// </summary>
/// <param name="Training"></param>
public static void UpdateTestTraining(Model.Training_TestTraining TestTraining)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Training_TestTraining newTestTraining = db.Training_TestTraining.FirstOrDefault(e => e.TrainingId == TestTraining.TrainingId);
if (newTestTraining != null)
{
newTestTraining.TrainingCode = TestTraining.TrainingCode;
newTestTraining.TrainingName = TestTraining.TrainingName;
newTestTraining.SupTrainingId = TestTraining.SupTrainingId;
newTestTraining.IsEndLever = TestTraining.IsEndLever;
db.SubmitChanges();
}
}
/// <summary>
/// 添加试题类型信息
/// </summary>
/// <param name="Training"></param>
public static void AddTestTraining(Model.Training_TestTraining TestTraining)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Training_TestTraining newTestTraining = new Model.Training_TestTraining
{
TrainingId = TestTraining.TrainingId,
TrainingCode = TestTraining.TrainingCode,
TrainingName = TestTraining.TrainingName,
SupTrainingId = TestTraining.SupTrainingId ?? "0",
IsEndLever = TestTraining.IsEndLever
};
db.Training_TestTraining.InsertOnSubmit(newTestTraining);
db.SubmitChanges();
}
/// <summary>
/// 根据主键删除信息
/// </summary>
/// <param name="TrainingId"></param>
public static void DeleteTestTrainingById(string TrainingId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Training_TestTraining TestTraining = db.Training_TestTraining.FirstOrDefault(e => e.TrainingId == TrainingId);
if (TestTraining != null)
{
var TrainingItem = from x in db.Training_TestTrainingItem where x.TrainingId == TrainingId select x;
if (TrainingItem.Count() > 0)
{
db.Training_TestTrainingItem.DeleteAllOnSubmit(TrainingItem);
}
db.Training_TestTraining.DeleteOnSubmit(TestTraining);
db.SubmitChanges();
}
}
