//更新多选题的信息
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();
}
