public testpaper Add(testpaper tp) { // 取机构用户id int organizationUserID = (int)tp.ID; // 向试卷表中添加 tp = db.testpaper.Add(tp); // 向生成关系表中添加 generate_testpaper_between_organizationuser_and_testpaper tmp = new generate_testpaper_between_organizationuser_and_testpaper { OrganizationUserID = organizationUserID, TestPaperID = (int)tp.ID, TimeOfGeneration = DateTime.Now }; db.generate_testpaper_between_organizationuser_and_testpaper.Add(tmp); db.SaveChanges(); return(tp); }
public bool DeleteByID(int id) { testpaper tp; if (TryGet(id, out tp)) { // 过期试卷可以删除 if (DateTime.Now > tp.OverTime) { // 解除生成关系 generate_testpaper_between_organizationuser_and_testpaper tmp = db.generate_testpaper_between_organizationuser_and_testpaper.Where(p => p.TestPaperID == id).FirstOrDefault(); db.generate_testpaper_between_organizationuser_and_testpaper.Remove(tmp); // 删除试卷 db.testpaper.Remove(tp); db.SaveChanges(); return(true); } } return(false); }