/// <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();
}
