/// <summary>
/// 从数据库中获取中级填空题记录
/// </summary>
public static BlankMid GetBlank(int Id)
{
SQLHelper dbAccess = new SQLHelper(); //实例化一个SQLHelper类
string sql = "Select * from [BlankMid] where Id = @Id";
SqlParameter[] para = { new SqlParameter("@Id", Id) }; //利用参数para进行动态定义
SqlDataReader dr = dbAccess.GetDRWithPara(sql, para); //获取查询数据流
//根据查询得到的数据，对成员赋值
//数据流中是否有数据
if (dr.Read())
{
BlankMid b = new BlankMid();
b.Id = int.Parse(dr["Id"].ToString());
b.qFront = dr["qFront"].ToString();
b.qBack = dr["qBack"].ToString();
b.answer = dr["answer"].ToString();
b.explain = dr["explain"].ToString();
b.suggestion = int.Parse(dr["suggestion"].ToString());
//关闭SqlDataReader对象，此时连接同时关闭
dr.Close();
return(b);
}
else
{
dr.Close();
return(null);
}
}
//判断填空题
public static bool JudgingBlank(BlankMid b, TextBox txt1, Label lbl1, Button btn1)
{
bool correct;
if (txt1.Text.Trim() == b.answer)
{
lbl1.Text = "√";
btn1.Visible = true;
return(correct = true);
}
else
{
lbl1.Text = "× 正确答案：" + b.answer;;
btn1.Visible = true;
return(correct = false);
}
}
//填空题分数计算
public static int blankScore(BlankMid b1, BlankMid b2, BlankMid b3, TextBox txt1, TextBox txt2, TextBox txt3)
{
int score = 0;
if (txt1.Text.Trim() == b1.answer)
{
score += 5;
}
if (txt2.Text.Trim() == b2.answer)
{
score += 5;
}
if (txt3.Text.Trim() == b3.answer)
{
score += 5;
}
return(score);
}
//通过Label控件显示填空题题目
public static void ShowQuestionBlank(BlankMid b, Label lbl1, Label lbl2)
{
lbl1.Text = b.qFront.ToString();
lbl2.Text = b.qBack.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["stuId"] != null)
{
//随机出题
long tick = DateTime.Now.Ticks;
Random ran = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
int iDown = 1;
int iUp = TestMidManager.CountRadio();
int[] n = new int[5];
while (true)
{
int i = 0;
n[0] = ran.Next(iDown, iUp);
n[1] = ran.Next(iDown, iUp);
n[2] = ran.Next(iDown, iUp);
n[3] = ran.Next(iDown, iUp);
n[4] = ran.Next(iDown, iUp);
if (n[0] != n[1] && n[0] != n[2] && n[0] != n[3] && n[0] != n[4] && n[1] != n[2] && n[1] != n[3] && n[1] != n[4] && n[2] != n[3] && n[2] != n[4] && n[3] != n[4])
{
i = 4;
}
if (i == 4)
{
break;
}
}
r1 = TestMidManager.GetRadio(n[0]);
TestMidManager.ShowQuestionRadio(r1, rdolistS1, lblS1);
r2 = TestMidManager.GetRadio(n[1]);
TestMidManager.ShowQuestionRadio(r2, rdolistS2, lblS2);
r3 = TestMidManager.GetRadio(n[2]);
TestMidManager.ShowQuestionRadio(r3, rdolistS3, lblS3);
r4 = TestMidManager.GetRadio(n[3]);
TestMidManager.ShowQuestionRadio(r4, rdolistS4, lblS4);
r5 = TestMidManager.GetRadio(n[4]);
TestMidManager.ShowQuestionRadio(r5, rdolistS5, lblS5);
//随机出题
int iUp1 = TestMidManager.CountJudge();
int[] j = new int[4];
while (true)
{
int i = 0;
j[0] = ran.Next(iDown, iUp1);
j[1] = ran.Next(iDown, iUp1);
j[2] = ran.Next(iDown, iUp1);
j[3] = ran.Next(iDown, iUp1);
if (j[0] != j[1] && j[0] != j[2] && j[0] != j[3] && j[1] != j[2] && j[1] != j[3] && j[2] != j[3])
{
i = 3;
}
if (i == 3)
{
break;
}
}
j1 = TestMidManager.GetJudge(j[0]);
TestMidManager.ShowQuestionJudge(j1, rdolistJ1, lblJ1);
j2 = TestMidManager.GetJudge(j[1]);
TestMidManager.ShowQuestionJudge(j2, rdolistJ2, lblJ2);
j3 = TestMidManager.GetJudge(j[2]);
TestMidManager.ShowQuestionJudge(j3, rdolistJ3, lblJ3);
j4 = TestMidManager.GetJudge(j[3]);
TestMidManager.ShowQuestionJudge(j4, rdolistJ4, lblJ4);
//随机出题
int iUp2 = TestMidManager.CountBlank();
int[] k = new int[3];
while (true)
{
int i = 0;
k[0] = ran.Next(iDown, iUp2);
k[1] = ran.Next(iDown, iUp2);
k[2] = ran.Next(iDown, iUp2);
if (k[0] != k[1] && k[0] != k[2] && k[1] != k[2])
{
i = 2;
}
if (i == 2)
{
break;
}
}
b1 = TestMidManager.GetBlank(k[0]);
TestMidManager.ShowQuestionBlank(b1, lblB1, lblB12);
b2 = TestMidManager.GetBlank(k[1]);
TestMidManager.ShowQuestionBlank(b2, lblB2, lblB22);
b3 = TestMidManager.GetBlank(k[2]);
TestMidManager.ShowQuestionBlank(b3, lblB3, lblB32);
//随机出题
int iUp3 = TestMidManager.CountDesign();
int[] m = new int[2];
m[0] = ran.Next(iDown, iUp3);
d1 = TestMidManager.GetDesign(m[0]);
TestMidManager.ShowQuestionDesign2(d1, lblD1);
}
else
{
Response.Redirect("Login.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) //防止点保存后，页面再一次刷新，和验证码一样
{
if (Session["stuId"] != null)
{
int score1 = 0;
int score2 = 0;
int score3 = 0;
string stuId = Session["stuId"].ToString();
stuNews1 = ClassUnitManager.GetStudyingInform(stuId);
score1 = stuNews1.pretest;
score2 = stuNews1.low;
score3 = stuNews1.mid;
if (int.Parse(Request.QueryString["caid"].ToString().Trim()) == 1) //不是第一次做题，读取断点
{
BreakingPointRadio bpr = new BreakingPointRadio();
bpr = BreakingPointManager.LoadBreakingPointRadio(Session["stuId"].ToString());
r1 = TestMidManager.GetRadio(bpr.r1);
TestMidManager.ShowQuestionRadio(r1, rdolistS1, lblS1);
r2 = TestMidManager.GetRadio(bpr.r2);
TestMidManager.ShowQuestionRadio(r2, rdolistS2, lblS2);
r3 = TestMidManager.GetRadio(bpr.r3);
TestMidManager.ShowQuestionRadio(r3, rdolistS3, lblS3);
r4 = TestMidManager.GetRadio(bpr.r4);
TestMidManager.ShowQuestionRadio(r4, rdolistS4, lblS4);
r5 = TestMidManager.GetRadio(bpr.r5);
TestMidManager.ShowQuestionRadio(r5, rdolistS5, lblS5);
BreakingPointJudge bpj = new BreakingPointJudge();
bpj = BreakingPointManager.LoadBreakingPointJudge(Session["stuId"].ToString());
j1 = TestMidManager.GetJudge(bpj.j1);
TestMidManager.ShowQuestionJudge(j1, rdolistJ1, lblJ1);
j2 = TestMidManager.GetJudge(bpj.j2);
TestMidManager.ShowQuestionJudge(j2, rdolistJ2, lblJ2);
j3 = TestMidManager.GetJudge(bpj.j3);
TestMidManager.ShowQuestionJudge(j3, rdolistJ3, lblJ3);
j4 = TestMidManager.GetJudge(bpj.j4);
TestMidManager.ShowQuestionJudge(j4, rdolistJ4, lblJ4);
BreakingPointBlank bpb = new BreakingPointBlank();
bpb = BreakingPointManager.LoadBreakingPointBlank(Session["stuId"].ToString());
b1 = TestMidManager.GetBlank(bpb.b1);
TestMidManager.ShowQuestionBlank(b1, lblB1, lblB12);
b2 = TestMidManager.GetBlank(bpb.b2);
TestMidManager.ShowQuestionBlank(b2, lblB2, lblB22);
b3 = TestMidManager.GetBlank(bpb.b3);
TestMidManager.ShowQuestionBlank(b3, lblB3, lblB32);
BreakingPointDesign bpd = new BreakingPointDesign();
bpd = BreakingPointManager.LoadBreakingPointDesign(Session["stuId"].ToString());
d1 = TestMidManager.GetDesign(bpd.d1);
TestMidManager.ShowQuestionDesign(d1, lblD1, lblD1S1, lblD1S2, rdolistD1S1, rdolistD1S2);
TestMidManager.ShowRadioBreakingpoint(bpr, rdolistS1, rdolistS2, rdolistS3, rdolistS4, rdolistS5);
TestMidManager.ShowJudgeBreakingpoint(bpj, rdolistJ1, rdolistJ2, rdolistJ3, rdolistJ4);
TestMidManager.ShowBlankBreakingpoint(bpb, txtB11, txtB21, txtB31);
}
else if (int.Parse(Request.QueryString["caid"].ToString().Trim()) == 0)
{
if (score1 >= 75 || score2 >= 60)
{
//随机出题（加入错题的权重,原先的题号不变，多余的错题作为普通题目放到最后进行随机）
long tick = DateTime.Now.Ticks;
Random ran = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
int iDown = 1;
int iUp = TestMidManager.CountRadio();
int[] rr = new int[iUp + 1];
for (int mn = 1; mn <= TestMidManager.CountRadio(); mn++)
{
rr[mn] = WrongRadioManager.WrongRadionum(Session["stuId"].ToString(), mn, "Mid", "WrongRadio");
iUp = iUp + rr[mn];
}
int[] n = new int[5];
while (true)
{
int i;
n[0] = ran.Next(iDown, iUp);
n[1] = ran.Next(iDown, iUp);
n[2] = ran.Next(iDown, iUp);
n[3] = ran.Next(iDown, iUp);
n[4] = ran.Next(iDown, iUp);
//对随机选出的5个数重映射题号
for (i = 0; i <= 4; i++)
{
if (n[i] > TestMidManager.CountRadio())
{
int temp;
temp = n[i] - TestMidManager.CountRadio();
int p;
for (p = 1; p <= TestMidManager.CountRadio(); p++)
{
temp = temp - rr[p];
if (temp <= 0)
{
break;
}
}
n[i] = p;
}
}
if (n[0] != n[1] && n[0] != n[2] && n[0] != n[3] && n[0] != n[4] && n[1] != n[2] && n[1] != n[3] && n[1] != n[4] && n[2] != n[3] && n[2] != n[4] && n[3] != n[4])
{
i = 4;
}
if (i == 4)
{
break;
}
}
r1 = TestMidManager.GetRadio(n[0]);
TestMidManager.ShowQuestionRadio(r1, rdolistS1, lblS1);
r2 = TestMidManager.GetRadio(n[1]);
TestMidManager.ShowQuestionRadio(r2, rdolistS2, lblS2);
r3 = TestMidManager.GetRadio(n[2]);
TestMidManager.ShowQuestionRadio(r3, rdolistS3, lblS3);
r4 = TestMidManager.GetRadio(n[3]);
TestMidManager.ShowQuestionRadio(r4, rdolistS4, lblS4);
r5 = TestMidManager.GetRadio(n[4]);
TestMidManager.ShowQuestionRadio(r5, rdolistS5, lblS5);
//随机出题
int iUp1 = TestMidManager.CountJudge();
int[] jj = new int[iUp1 + 1];
for (int mn = 1; mn <= TestHighManager.CountJudge(); mn++)
{
jj[mn] = WrongRadioManager.WrongRadionum(Session["stuId"].ToString(), mn, "Mid", "WrongJudge");
iUp1 = iUp1 + jj[mn];
}
int[] j = new int[4];
while (true)
{
int i;
j[0] = ran.Next(iDown, iUp1);
j[1] = ran.Next(iDown, iUp1);
j[2] = ran.Next(iDown, iUp1);
j[3] = ran.Next(iDown, iUp1);
//对随机选出的4个数重映射题号
for (i = 0; i <= 3; i++)
{
if (j[i] > TestMidManager.CountJudge())
{
int temp;
temp = j[i] - TestMidManager.CountJudge();
int p;
for (p = 1; p <= TestMidManager.CountJudge(); p++)
{
temp = temp - jj[p];
if (temp <= 0)
{
break;
}
}
j[i] = p;
}
}
if (j[0] != j[1] && j[0] != j[2] && j[0] != j[3] && j[1] != j[2] && j[1] != j[3] && j[2] != j[3])
{
i = 3;
}
if (i == 3)
{
break;
}
}
j1 = TestMidManager.GetJudge(j[0]);
TestMidManager.ShowQuestionJudge(j1, rdolistJ1, lblJ1);
j2 = TestMidManager.GetJudge(j[1]);
TestMidManager.ShowQuestionJudge(j2, rdolistJ2, lblJ2);
j3 = TestMidManager.GetJudge(j[2]);
TestMidManager.ShowQuestionJudge(j3, rdolistJ3, lblJ3);
j4 = TestMidManager.GetJudge(j[3]);
TestMidManager.ShowQuestionJudge(j4, rdolistJ4, lblJ4);
//随机出题
int iUp2 = TestMidManager.CountBlank();
int[] kk = new int[iUp2 + 1];
for (int mn = 1; mn <= TestMidManager.CountBlank(); mn++)
{
kk[mn] = WrongRadioManager.WrongRadionum(Session["stuId"].ToString(), mn, "Mid", "WrongBlank");
iUp2 = iUp2 + kk[mn];
}
int[] k = new int[3];
while (true)
{
int i;
k[0] = ran.Next(iDown, iUp2);
k[1] = ran.Next(iDown, iUp2);
k[2] = ran.Next(iDown, iUp2);
//对随机选出的3个数重映射题号
for (i = 0; i <= 2; i++)
{
if (k[i] > TestMidManager.CountBlank())
{
int temp;
temp = k[i] - TestMidManager.CountBlank();
int p;
for (p = 1; p <= TestMidManager.CountBlank(); p++)
{
temp = temp - kk[p];
if (temp <= 0)
{
break;
}
}
k[i] = p;
}
}
if (k[0] != k[1] && k[0] != k[2] && k[1] != k[2])
{
i = 2;
}
if (i == 2)
{
break;
}
}
b1 = TestMidManager.GetBlank(k[0]);
TestMidManager.ShowQuestionBlank(b1, lblB1, lblB12);
b2 = TestMidManager.GetBlank(k[1]);
TestMidManager.ShowQuestionBlank(b2, lblB2, lblB22);
b3 = TestMidManager.GetBlank(k[2]);
TestMidManager.ShowQuestionBlank(b3, lblB3, lblB32);
//随机出题
int iUp3 = TestMidManager.CountDesign();
int[] m = new int[2];
m[0] = ran.Next(iDown, iUp3);
d1 = TestMidManager.GetDesign(m[0]);
TestMidManager.ShowQuestionDesign(d1, lblD1, lblD1S1, lblD1S2, rdolistD1S1, rdolistD1S2);
}
else
{
lblTitle.Visible = false;
PanelAll.Visible = false;
PanelDesign.Visible = false;
btnSubmit.Visible = false;
btnOk.Visible = false;
btnSave.Visible = false;
//Response.Write("<script type = 'text/javascript'> alert('你未通过低等级测试，不能进行该等级测试！'); </script>");
RegisterClientScriptBlock("", "<script>alert('你未通过前测或低等级测试，不能进行中级测试！')</script>");
}
}
}
else
{
Response.Redirect("Login.aspx");
}
}
}
