/// <summary> /// 添加试题信息 /// </summary> /// <param name="TrainingItem"></param> public static void AddTestTrainingItem(Model.Training_TestTrainingItem TestTrainingItem) { Model.SUBHSSEDB db = Funs.DB; Model.Training_TestTrainingItem newTestTrainingItem = new Model.Training_TestTrainingItem { TrainingItemId = TestTrainingItem.TrainingItemId, TrainingId = TestTrainingItem.TrainingId, TrainingItemCode = TestTrainingItem.TrainingItemCode, TrainingItemName = TestTrainingItem.TrainingItemName, Abstracts = TestTrainingItem.Abstracts, AttachUrl = TestTrainingItem.AttachUrl, VersionNum = TestTrainingItem.VersionNum, TestType = TestTrainingItem.TestType, WorkPostIds = TestTrainingItem.WorkPostIds, WorkPostNames = TestTrainingItem.WorkPostNames, AItem = TestTrainingItem.AItem, BItem = TestTrainingItem.BItem, CItem = TestTrainingItem.CItem, DItem = TestTrainingItem.DItem, EItem = TestTrainingItem.EItem, AnswerItems = TestTrainingItem.AnswerItems, }; db.Training_TestTrainingItem.InsertOnSubmit(newTestTrainingItem); db.SubmitChanges(); }
/// <summary> /// 根据主键删除信息 /// </summary> /// <param name="TrainingItemId"></param> public static void DeleteTestTrainingItemById(string TrainingItemId) { Model.SUBHSSEDB db = Funs.DB; Model.Training_TestTrainingItem TestTrainingItem = db.Training_TestTrainingItem.FirstOrDefault(e => e.TrainingItemId == TrainingItemId); if (TestTrainingItem != null) { db.Training_TestTrainingItem.DeleteOnSubmit(TestTrainingItem); db.SubmitChanges(); } }
/// <summary> /// 修改试题信息 /// </summary> /// <param name="TrainingItem"></param> public static void UpdateTestTrainingItem(Model.Training_TestTrainingItem TestTrainingItem) { Model.SUBHSSEDB db = Funs.DB; Model.Training_TestTrainingItem newTestTrainingItem = db.Training_TestTrainingItem.FirstOrDefault(e => e.TrainingItemId == TestTrainingItem.TrainingItemId); if (newTestTrainingItem != null) { newTestTrainingItem.TrainingItemCode = TestTrainingItem.TrainingItemCode; newTestTrainingItem.TrainingItemName = TestTrainingItem.TrainingItemName; newTestTrainingItem.Abstracts = TestTrainingItem.Abstracts; newTestTrainingItem.AttachUrl = TestTrainingItem.AttachUrl; newTestTrainingItem.VersionNum = TestTrainingItem.VersionNum; newTestTrainingItem.TestType = TestTrainingItem.TestType; newTestTrainingItem.WorkPostIds = TestTrainingItem.WorkPostIds; newTestTrainingItem.WorkPostNames = TestTrainingItem.WorkPostNames; newTestTrainingItem.AItem = TestTrainingItem.AItem; newTestTrainingItem.BItem = TestTrainingItem.BItem; newTestTrainingItem.CItem = TestTrainingItem.CItem; newTestTrainingItem.DItem = TestTrainingItem.DItem; newTestTrainingItem.EItem = TestTrainingItem.EItem; newTestTrainingItem.AnswerItems = TestTrainingItem.AnswerItems; db.SubmitChanges(); } }