private void BindKaoJuan()
{
DataTable dt = KaoJuanService.SelectAll();
if (dt != null && dt.Rows.Count != 0)
{
ListView1.DataSource = dt;
ListView1.DataBind();
}
}
private void GetPager()
{
int id = int.Parse(Request.QueryString["id"].ToString());
//客观题
SqlDataReader dr = KaoJuanService.SelectKaoJuan(id);
dr.Read();
lblKaoJuanName.Text = dr["KaoJuanName"].ToString();
Label15.Text = dr["PageFen"].ToString();
SqlDataReader dr2 = ZuJuanService.SelectZuJuan(id);
GridView1.DataSource = dr2;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
KaoJuan kj = new KaoJuan();
kj.KaoJuanName = TextBox4.Text.Trim();
kj.PageFen = int.Parse(TextBox5.Text.Trim());
kj.CourseName = ddlCourse.SelectedItem.Text.Trim();
kj.CourseID = int.Parse(ddlCourse.SelectedValue);
KaoJuanService.Insert(kj);
SqlDataReader dr;
//单选题
dr = DBHelper.GetDataReader("select top " + TextBox1.Text + " * from ObQuestion where CourseID='" + ddlCourse.SelectedValue + "' order by newid()");
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataReader sdr = KaoJuanService.SelectKaoJuanTop1();
if (sdr.Read())
{
int id = int.Parse(sdr["KaoJuanID"].ToString());
//单选题
foreach (GridViewRow dr in GridView1.Rows)
{
ZuJuan zj = new ZuJuan();
zj.KaoJuanID = id;
zj.TitleID = int.Parse(((Label)dr.FindControl("Label3")).Text);
zj.Mark = int.Parse(((Label)dr.FindControl("Label4")).Text);
ZuJuanService.Insert(zj);
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "true", "<script>alert('生成成功！');</script>");
}
}
