/// <summary>
/// 删除试题
/// </summary>
/// <param name="EDU_ID"></param>
public static void DeleteTestDB(string testId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Edu_Online_TestDB test = db.Edu_Online_TestDB.First(e => e.TestId == testId);
db.Edu_Online_TestDB.DeleteOnSubmit(test);
db.SubmitChanges();
}
/// <summary>
/// 修改试题
/// </summary>
/// <param name="teamGroup"></param>
public static void UpdateTestDB(Model.Edu_Online_TestDB test)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Edu_Online_TestDB newTest = db.Edu_Online_TestDB.First(e => e.TestId == test.TestId);
newTest.TestType = test.TestType;
newTest.Chapter = test.Chapter;
newTest.ItemType = test.ItemType;
newTest.TestNo = test.TestNo;
newTest.TestKey = test.TestKey;
newTest.KeyNumber = test.KeyNumber;
newTest.TestContent = test.TestContent;
newTest.TestPath = test.TestPath;
db.SubmitChanges();
}
/// <summary>
/// 添加试题
/// </summary>
/// <param name="?"></param>
public static void AddTestDB(Model.Edu_Online_TestDB test)
{
Model.SUBHSSEDB db = Funs.DB;
string newKeyID = SQLHelper.GetNewID(typeof(Model.Edu_Online_TestDB));
Model.Edu_Online_TestDB newTest = new Model.Edu_Online_TestDB
{
TestId = newKeyID,
TestType = test.TestType,
Chapter = test.Chapter,
ItemType = test.ItemType,
TestNo = test.TestNo,
TestKey = test.TestKey,
KeyNumber = test.KeyNumber,
TestContent = test.TestContent,
TestPath = test.TestPath
};
db.Edu_Online_TestDB.InsertOnSubmit(newTest);
db.SubmitChanges();
}
