/// <summary> /// 删除判断题信息 /// </summary> /// <param name="s">判断题实体</param> public static void DeleteJudge(JudgeInfo s, ExamDbDataContext dc) { AttachInfo<JudgeInfo>(dc.JudgeInfo, s); dc.JudgeInfo.DeleteOnSubmit(s); dc.SubmitChanges(); }
public static void UpdateStudent(StudentInfo s, ExamDbDataContext dc) { AttachInfo<StudentInfo>(dc.StudentInfo, s); dc.SubmitChanges(); PurgeCacheItems("AllStudents"); PurgeCacheItems("StudentsToSelect_" + s.DepartmentID); }
/// <summary> /// 更新判断题信息 /// </summary> /// <param name="s">判断题实体</param> public static void UpdateJudge(JudgeInfo s, ExamDbDataContext dc) { AttachInfo<JudgeInfo>(dc.JudgeInfo, s); dc.SubmitChanges(); // PurgeCacheItems("AllJudges_" + s.DepartmentID.ToString()); }
/// <summary> /// 更新基本试卷信息 /// </summary> /// <param name="s">基本试卷实体</param> public static void UpdateBasicExam(BasicExamInfo s, ExamDbDataContext dc) { AttachInfo<BasicExamInfo>(dc.BasicExamInfo, s); dc.SubmitChanges(); // PurgeCacheItems("AllBasicExams_" + s.DepartmentID.ToString()); }
/// <summary> /// 删除基本试卷信息 /// </summary> /// <param name="s">基本试卷实体</param> public static void DeleteBasicExam(BasicExamInfo s, ExamDbDataContext dc) { AttachInfo<BasicExamInfo>(dc.BasicExamInfo, s); dc.BasicExamInfo.DeleteOnSubmit(s); dc.SubmitChanges(); }
/// <summary> /// 更新正式课题信息 /// </summary> /// <param name="s">课题实体</param> public static void UpdateSubject(SubjectInfo s, ExamDbDataContext dc) { AttachInfo<SubjectInfo>(dc.SubjectInfo, s); dc.SubmitChanges(); PurgeCacheItems("AllSubjects_" + s.DepartmentID.ToString()); }
/// <summary> /// 删除试题信息 /// </summary> /// <param name="s">试题实体</param> public static void DeleteQuestion(QuestionInfo s, ExamDbDataContext dc) { AttachInfo<QuestionInfo>(dc.QuestionInfo, s); dc.QuestionInfo.DeleteOnSubmit(s); dc.SubmitChanges(); }
/// <summary> /// 更新选择项信息 /// </summary> /// <param name="s">选择项实体</param> public static void UpdateChoiceItem(ChoiceItemInfo s, ExamDbDataContext dc) { AttachInfo<ChoiceItemInfo>(dc.ChoiceItemInfo, s); dc.SubmitChanges(); // PurgeCacheItems("AllChoiceItems_" + s.DepartmentID.ToString()); }
/// <summary> /// 删除选择题信息 /// </summary> /// <param name="s">选择题实体</param> public static void DeleteSelectChoice(SelectChoiceInfo s, ExamDbDataContext dc) { AttachInfo<SelectChoiceInfo>(dc.SelectChoiceInfo, s); dc.SelectChoiceInfo.DeleteOnSubmit(s); dc.SubmitChanges(); }
/// <summary> /// 更新教师实体信息 /// </summary> /// <param name="s">需要更新的教师实体</param> public static void UpdateTeacher(TeacherInfo t, ExamDbDataContext dc) { AttachInfo<TeacherInfo>(dc.TeacherInfo, t); dc.SubmitChanges(); }
/// <summary> /// 根据指定专业id返回对应选择项, /// </summary> /// <param name="id">选择项id</param> /// <returns></returns> //public static IList<ChoiceItemInfo> GetChoiceItemsByID(int majorID) //{ // ExamDbDataContext dc = DataAccess.CreateDBContext(); // var ChoiceItems = from s in dc.ChoiceItemInfo // where s.MajorID==majorID // select s; // return ToList<ChoiceItemInfo>(ChoiceItems); //} /// <summary> /// 删除选择项信息 /// </summary> /// <param name="s">选择项实体</param> public static void DeleteChoiceItem(ChoiceItemInfo s, ExamDbDataContext dc) { AttachInfo<ChoiceItemInfo>(dc.ChoiceItemInfo, s); dc.ChoiceItemInfo.DeleteOnSubmit(s); dc.SubmitChanges(); }
///// <summary> ///// 根据基本试卷id,返回统计结果 ///// </summary> ///// <param name="id">随机试卷id</param> ///// <returns></returns> //public static IList<RandomExamInfo> GetResultsByBasicExamID(int basicExamID) //{ // IList<RandomExamInfo> randomList = GetRandomExamsByBasicExamID(basicExamID); // var results = from s in randomList // group s by s.ClassID; // var rr=from r in results // select new{ //} /// <summary> /// 删除随机试卷信息 /// </summary> /// <param name="s">随机试卷实体</param> public static void DeleteExam(RandomExamInfo s, ExamDbDataContext dc) { AttachInfo<RandomExamInfo>(dc.RandomExamInfo, s); if (Utility.DeleteStuXMLFile(s.StuNum, s.BasicExamID)) { dc.RandomExamInfo.DeleteOnSubmit(s); dc.SubmitChanges(); PurgeCacheItems("RandomExams"); } else return; }
public static bool CheckZeroRandomExam() { ExamDbDataContext dc = new ExamDbDataContext(); var exams = dc.RandomExamInfo.Where(p => (DateTime)p.EndTime < DateTime.Now && p.HasFinished == false && p.TotalGetMark == 0); foreach (var r in exams) { r.HasFinished = true; r.InExaming = false; //if(File.Exists(r.ExamInfoFilePath)) //SetTotalMark(XElement.Load(r.ExamInfoFilePath), 0, 0, 0, true); } dc.SubmitChanges(); // singleChoicesElement.Attribute("getMark").Value; return true; }
protected void imgBtnConfirm_Click(object sender, ImageClickEventArgs e) { int courseID=int.Parse(ddlCourses.SelectedValue); if (courseID == 0) { lblMessage.Text = "请选择课程!!"; return; } int singNum = int.Parse(txtSingleNum.Text); int singMark = int.Parse(txtSingleFen.Text); int mutilNum = int.Parse(txtMultiNum.Text); int mutilMark = int.Parse(txtMultiFen.Text); int judgeNum = int.Parse(txtJudgeNum.Text); int judgeMark = int.Parse(txtJudgeFen.Text); int totalMark=int.Parse(txtTotalMark.Text); int sumMark= singMark * singNum + mutilMark * mutilNum + judgeMark * judgeNum; if (totalMark != sumMark) lblMessage.Text = "试卷总分不匹配,请重新计算!"; else { //插入试卷。 BasicExamInfo exam = null; ExamDbDataContext dc=new ExamDbDataContext(); if (string.IsNullOrEmpty(hideExamID.Value)) { exam = new BasicExamInfo(); exam.AddedDate = DateTime.Now; } else exam = BasicExam.GetBasicExamByID(int.Parse(hideExamID.Value), out dc); exam.BasicExamTitle = txtPaperName.Text; exam.BasicExamDesc = txtDesc.Text; exam.JudgeNum = judgeNum; exam.JudgeMark = judgeMark; exam.MutilChoiceNum = mutilNum; exam.MutilChoiceMark = mutilMark; exam.SingChoiceNum = singNum; exam.SingChoiceMark = singMark; exam.CourseID = courseID; if (ddlChapters.Items.Count == 0) exam.ChapterID = 0; else exam.ChapterID = int.Parse(ddlChapters.SelectedValue); exam.TimeUse = int.Parse(txtTotalTime.Text); if(string.IsNullOrEmpty(hideExamID.Value)) BasicExam.InsertBasicExam(exam); else dc.SubmitChanges(); this.ClientScript.RegisterStartupScript(this.GetType(), "Hint", "<script>alert('成功保存试卷')</script>"); ClearTextBoxValue(); hideExamID.Value=""; } Egv.DataBind(); }
/// <summary> ///更新通知 /// </summary> /// <param name="n">通知实体</param> public static void UpdateNotice(NoticeInfo n, ExamDbDataContext dc) { AttachInfo<NoticeInfo>(dc.NoticeInfo, n); dc.SubmitChanges(); }
/// <summary> /// 更新试题信息 /// </summary> /// <param name="s">试题实体</param> public static void UpdateQuestion(QuestionInfo s, ExamDbDataContext dc) { AttachInfo<QuestionInfo>(dc.QuestionInfo, s); dc.SubmitChanges(); // PurgeCacheItems("AllQuestions_" + s.DepartmentID.ToString()); }
/// <summary> /// 删除一个管理员用户 /// </summary> /// <param name="a"></param> public static void DeleteAdminUser(AdminUserInfo a,ExamDbDataContext dc) { AttachInfo<AdminUserInfo>(dc.AdminUserInfo,a); dc.AdminUserInfo.DeleteOnSubmit(a); dc.SubmitChanges(); }
/// <summary> /// 删除课题信息 /// </summary> /// <param name="s">课题实体</param> public static void DeleteSubject(SubjectInfo s, ExamDbDataContext dc) { AttachInfo<SubjectInfo>(dc.SubjectInfo,s); dc.SubjectInfo.DeleteOnSubmit(s); dc.SubmitChanges(); }