/// <summary> /// 插入判断题信息 /// </summary> /// <param name="s">判断题实体</param> public static int InsertJudge(JudgeInfo s) { ExamDbDataContext dc = DataAccess.CreateDBContext(); dc.JudgeInfo.InsertOnSubmit(s); dc.SubmitChanges(); // PurgeCacheItems("AllSubjects_" + s.DepartmentID.ToString()); return s.JudgeID; }
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e) { JudgeInfo j = new JudgeInfo(); j.Title = txtTitle.Text; j.RightAnswer =bool.Parse(rblAnswer.SelectedValue); Judge.InsertJudge(j); txtTitle.Text = ""; this.ClientScript.RegisterStartupScript(this.GetType(), "Hint", "<script>alert('成功保存数据')</script>"); }
/// <summary> /// 更新判断题信息 /// </summary> /// <param name="s">判断题实体</param> public static void UpdateJudge(JudgeInfo s) { ExamDbDataContext dc = DataAccess.CreateDBContext(); AttachInfo<JudgeInfo>(dc.JudgeInfo, s); // PurgeCacheItems("AllJudges_" + s.DepartmentID.ToString()); dc.SubmitChanges(); }
/// <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(); }
private static IList<JudgeInfo> ChangeExcelToJudges(string filePath) { IList<JudgeInfo> judges = new List<JudgeInfo>(); string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\""; if (filePath.EndsWith("xlsx")) strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\""; OleDbConnection myConn = new OleDbConnection(strConn); string strCom = " SELECT * FROM [Sheet1$]"; OleDbCommand cmd = new OleDbCommand(strCom, myConn); OleDbDataReader dr = null; try { myConn.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { //if(dr["姓名"]==null||dr["学号"]==null||dr["班级"]==null||dr["专业"]==null|| dr["家庭地址"]==null) // continue; string sAnswers = ""; JudgeInfo s = new JudgeInfo(); s.Title = dr["题目"].ToString(); sAnswers = dr["答案"].ToString(); s.CourseID = BLLBase.ReturnID(BLLBase.GetCourseDic(), dr["课程"].ToString()); s.ChapterID = BLLBase.ReturnID(BLLBase.GetChapterDic(), dr["章节"].ToString()); if (sAnswers == "对") s.RightAnswer = true; else s.RightAnswer = false; judges.Add(s); // HttpContext.Current.Response.Write("一条记录<br>"); } } catch (Exception e) { HttpContext.Current.Response.Write("错误信息:" + e.Message); judges = null; } finally { if (dr != null) dr.Close(); myConn.Close(); } return judges; }
private void detach_JudgeInfo(JudgeInfo entity) { this.SendPropertyChanging(); entity.CourseInfo = null; }
private void attach_JudgeInfo(JudgeInfo entity) { this.SendPropertyChanging(); entity.CourseInfo = this; }