//更新多选题的信息 public bool UpdateByProc(int TID) { SqlParameter[] Params = new SqlParameter[8]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //题目编号 Params[1] = DB.MakeInParam("@c_id", SqlDbType.Int, 4, c_id); //科目编号 Params[2] = DB.MakeInParam("@Title", SqlDbType.VarChar, 1000, Title); //题目 Params[3] = DB.MakeInParam("@AnswerA", SqlDbType.VarChar, 500, AnswerA); //答案A Params[4] = DB.MakeInParam("@AnswerB", SqlDbType.VarChar, 500, AnswerB); //答案B Params[5] = DB.MakeInParam("@AnswerC", SqlDbType.VarChar, 500, AnswerC); //答案C Params[6] = DB.MakeInParam("@AnswerD", SqlDbType.VarChar, 500, AnswerD); //答案D Params[7] = DB.MakeInParam("@Answer", SqlDbType.VarChar, 50, Answer); //答案 int Count = -1; Count = DB.RunProc("Proc_MultiProblemModify", Params); if (Count > 0) { return(true); } else { return(false); } }
//根据题目ID 初始化题目 //输入: // TID - 题目编号; //输出: // 题目存在:返回True; // 题目不在:返回False; public bool LoadData(int TID) { SqlParameter[] Params = new SqlParameter[1]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //用户编号 DataSet ds = DB.GetDataSet("Proc_MultiProblemDetail", Params); ds.CaseSensitive = false; DataRow DR; if (ds.Tables[0].Rows.Count > 0) { DR = ds.Tables[0].Rows[0]; this._c_id = GetSafeData.ValidateDataRow_N(DR, "c_id"); //科目编号 this._Title = GetSafeData.ValidateDataRow_S(DR, "Title"); //题目 this._AnswerA = GetSafeData.ValidateDataRow_S(DR, "AnswerA"); //答案A this._AnswerB = GetSafeData.ValidateDataRow_S(DR, "AnswerB"); //答案B this._AnswerC = GetSafeData.ValidateDataRow_S(DR, "AnswerC"); //答案C this._AnswerD = GetSafeData.ValidateDataRow_S(DR, "AnswerD"); //答案D this._Answer = GetSafeData.ValidateDataRow_S(DR, "Answer"); //答案 return(true); } else { return(false); } }
public bool CheckScore(string XUserID, int XPaperID) { SqlParameter[] Params = new SqlParameter[2]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, XUserID); Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, XPaperID); SqlDataReader DR = DB.RunProcGetReader("Proc_ScoreDetail", Params); if (!DR.Read()) { return(false); } else { return(true); } }
//更新试卷信息 public bool UpdateByProc(int PID) { SqlParameter[] Params = new SqlParameter[2]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, PID); //试卷编号 Params[1] = DB.MakeInParam("@PaperState", SqlDbType.Bit, 1, PaperState); //试卷状态 int Count = -1; Count = DB.RunProc("Proc_PaperModify", Params); if (Count > 0) { return(true); } else { return(false); } }
//向Paper表中添加试卷信息(采用存储过程) //输出: // 插入成功:返回True; // 插入失败:返回False; public bool InsertByProc() { SqlParameter[] Params = new SqlParameter[3]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@c_id", SqlDbType.Int, 4, c_id); //科目编号 Params[1] = DB.MakeInParam("@PaperName", SqlDbType.VarChar, 200, PaperName); //试卷名称 Params[2] = DB.MakeInParam("@PaperState", SqlDbType.Bit, 1, PaperState); //试卷状态 int Count = -1; Count = DB.RunProc("Proc_PaperAdd", Params); if (Count > 0) { return(true); } else { return(false); } }
protected void InitData() //读取试题 { SqlParameter[] Params1 = new SqlParameter[2]; Datacon DB = new Datacon(); int paperID = int.Parse(Session["PaperID"].ToString()); Params1[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params1[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "单选题"); //题目类型 DataSet ds1 = DB.GetDataSet("Proc_PaperDetail", Params1); GridView1.DataSource = ds1; GridView1.DataBind(); ((Label)GridView1.HeaderRow.FindControl("Label27")).Text = ((Label)GridView1.Rows[0].FindControl("Label4")).Text; SqlParameter[] Params2 = new SqlParameter[2]; Params2[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params2[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "多选题"); //题目类型 DataSet ds2 = DB.GetDataSet("Proc_PaperDetail", Params2); GridView2.DataSource = ds2; GridView2.DataBind(); ((Label)GridView2.HeaderRow.FindControl("Label28")).Text = ((Label)GridView2.Rows[0].FindControl("Label8")).Text; SqlParameter[] Params3 = new SqlParameter[2]; Params3[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params3[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "判断题"); //题目类型 DataSet ds3 = DB.GetDataSet("Proc_PaperDetail", Params3); GridView3.DataSource = ds3; GridView3.DataBind(); ((Label)GridView3.HeaderRow.FindControl("Label29")).Text = ((Label)GridView3.Rows[0].FindControl("Label12")).Text; }
//向Score表中添加成绩 //输出: // 插入成功:返回True; // 插入失败:返回False; public bool InsertByProc() { SqlParameter[] Params = new SqlParameter[6]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 20, UserID); Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, PaperID); Params[2] = DB.MakeInParam("@Score", SqlDbType.Int, 4, Score); Params[3] = DB.MakeInParam("@sscore", SqlDbType.Int, 4, sscore); Params[4] = DB.MakeInParam("@mscore", SqlDbType.Int, 4, mscore); Params[5] = DB.MakeInParam("@jscore", SqlDbType.Int, 4, jscore); int Count = -1; Count = DB.RunProc("Proc_ScoreAdd", Params); if (Count > 0) { return(true); } else { return(false); } }
protected void InitData() { Datacon DB = new Datacon(); int paperID = Convert.ToInt32(Request.QueryString["PaperID"].ToString()); SqlParameter[] Params1 = new SqlParameter[2]; Params1[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params1[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "单选题"); //题目类型 DataSet ds1 = DB.GetDataSet("Proc_PaperDetail", Params1); GridView1.DataSource = ds1; GridView1.DataBind(); SqlParameter[] Params2 = new SqlParameter[2]; Params2[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params2[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "多选题"); //题目类型 DataSet ds2 = DB.GetDataSet("Proc_PaperDetail", Params2); GridView2.DataSource = ds2; GridView2.DataBind(); SqlParameter[] Params3 = new SqlParameter[2]; Params3[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params3[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "判断题"); //题目类型 DataSet ds3 = DB.GetDataSet("Proc_PaperDetail", Params3); GridView3.DataSource = ds3; GridView3.DataBind(); }
//更新试卷是否评阅的状态 public bool UpdateByProc(string XUserID, int XPaperID, string Xstate) { SqlParameter[] Params = new SqlParameter[3]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@UserID", SqlDbType.VarChar, 50, XUserID); Params[1] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, XPaperID); Params[2] = DB.MakeInParam("@state", SqlDbType.VarChar, 50, Xstate); int Count = -1; Count = DB.RunProc("Proc_UserAnswerStateModify", Params); if (Count > 0) { return(true); } else { return(false); } }
//更新判断题的信息 public bool UpdateByProc(int TID) { SqlParameter[] Params = new SqlParameter[4]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, TID); //题目编号 Params[1] = DB.MakeInParam("@c_id", SqlDbType.Int, 4, c_id); //科目编号 Params[2] = DB.MakeInParam("@Title", SqlDbType.VarChar, 1000, Title); //题目 Params[3] = DB.MakeInParam("@Answer", SqlDbType.Bit, 1, Answer); //答案 int Count = -1; Count = DB.RunProc("Proc_JudgeProblemModify", Params); if (Count > 0) { return(true); } else { return(false); } }
//删除成绩 //输入: // XUserID - 用户编号; //输出: // 删除成功:返回True; // 删除失败:返回False; public bool DeleteByProc(int SID) { SqlParameter[] Params = new SqlParameter[1]; Datacon DB = new Datacon(); Params[0] = DB.MakeInParam("@ID", SqlDbType.Int, 4, SID); //成绩编号 int Count = -1; Count = DB.RunProc("Proc_ScoreDelete", Params); if (Count > 0) { return(true); } else { return(false); } }
protected void InitData() { Datacon DB = new Datacon(); try { paperID = Convert.ToInt32(Request.QueryString["PaperID"].ToString()); } catch { Response.Write("<script>alert('无法获取试卷ID!')</script>"); Response.Write("<script language=javascript>top.location.href='index.aspx'</script>"); } SqlParameter[] Params1 = new SqlParameter[2]; Params1[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params1[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "单选题"); //题目类型 DataSet ds1 = DB.GetDataSet("Proc_PaperDetail", Params1); GridView1.DataSource = ds1; GridView1.DataBind(); SqlParameter[] Params2 = new SqlParameter[2]; Params2[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params2[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "多选题"); //题目类型 DataSet ds2 = DB.GetDataSet("Proc_PaperDetail", Params2); GridView2.DataSource = ds2; GridView2.DataBind(); SqlParameter[] Params3 = new SqlParameter[2]; Params3[0] = DB.MakeInParam("@PaperID", SqlDbType.Int, 4, paperID); //试卷编号 Params3[1] = DB.MakeInParam("@Type", SqlDbType.VarChar, 10, "判断题"); //题目类型 DataSet ds3 = DB.GetDataSet("Proc_PaperDetail", Params3); GridView3.DataSource = ds3; GridView3.DataBind(); }