protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
{
Datacon db = new Datacon();
string insertpaper = "insert into TaoTi(c_id,PaperName,PaperState,JoinTime,AnswerTime,Score,teacher_id) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "','" + DropDownList2.SelectedValue + "','" + DateTime.Now.ToString() + "','" + DropDownList1.SelectedValue + "', '" + Label21.Text + "','" + Session["ID"] + "')";
int afterID = db.GetIDInsert(insertpaper);//保存试卷，并返回自动生成的试卷编号
if (afterID > 0)
{
foreach (GridViewRow dr in GridView1.Rows)//保存试卷单选题信息
{
string single = "insert into TaoTiDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + int.Parse(((Label)dr.FindControl("Label3")).Text) + "," + int.Parse(SingleFen.Text) + ")";
db.Insert(single);
}
foreach (GridViewRow dr in GridView2.Rows)//保存试卷多选题信息
{
string multi = "insert into TaoTiDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + int.Parse(((Label)dr.FindControl("Label6")).Text) + "," + int.Parse(MultiFen.Text) + ")";
db.Insert(multi);
}
foreach (GridViewRow dr in GridView3.Rows)//保存试卷判断题信息
{
string judge = "insert into TaoTiDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + int.Parse(((Label)dr.FindControl("Label7")).Text) + "," + int.Parse(JudgeFen.Text) + ")";
db.Insert(judge);
}
}
Response.Write("<script>alert('添加成功！')</script>");
Response.Write("<script>window.location.href='AddTaoTi.aspx'</script>");
}
