public void PageSubmit()
{
int paperid = Convert.ToInt32(Session["PaperID"].ToString());
DataBase db = new DataBase();
//取出单选题的每题分值
if (GridView11.Rows.Count > 0)
{
int singlemark = int.Parse(((Label)GridView11.Rows[0].FindControl("Label4")).Text);
foreach (GridViewRow dr in GridView11.Rows)
{
string str = "";
if (((RadioButton)dr.FindControl("RadioButton1")).Checked)
{
str = "A";
}
else if (((RadioButton)dr.FindControl("RadioButton2")).Checked)
{
str = "B";
}
else if (((RadioButton)dr.FindControl("RadioButton3")).Checked)
{
str = "C";
}
else if (((RadioButton)dr.FindControl("RadioButton4")).Checked)
{
str = "D";
}
int titleid = int.Parse(((Label)dr.FindControl("Label40")).Text);
string single = "insert into UserAnswertb(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + Session["userID"].ToString() + "','" + paperid + "','单选题','" + titleid + "','" + singlemark + "','" + str + "','" + DateTime.Now.ToString() + "')";
db.Insert(single);
}
}
//取出多选题每题分值
if (GridView2.Rows.Count > 0)
{
int multimark = int.Parse(((Label)GridView2.Rows[0].FindControl("Label8")).Text);
foreach (GridViewRow dr in GridView2.Rows)//对多选题每题进行判断用户选择答案
{
string str = "";
if (((CheckBox)dr.FindControl("CheckBox1")).Checked)
{
str += "A";
}
if (((CheckBox)dr.FindControl("CheckBox2")).Checked)
{
str += "B";
}
if (((CheckBox)dr.FindControl("CheckBox3")).Checked)
{
str += "C";
}
if (((CheckBox)dr.FindControl("CheckBox4")).Checked)
{
str += "D";
}
int titleid = int.Parse(((Label)dr.FindControl("Label41")).Text);
string Multi = "insert into UserAnswertb(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + Session["userID"].ToString() + "','" + paperid + "','多选题','" + titleid + "','" + multimark + "','" + str + "','" + DateTime.Now.ToString() + "')";
db.Insert(Multi);
}
}
//取出判断题每题分值
if (GridView3.Rows.Count > 0)
{
int judgemark = int.Parse(((Label)GridView3.Rows[0].FindControl("Label12")).Text);
foreach (GridViewRow dr in GridView3.Rows)//对判断题每题进行判断用户选择答案
{
string str = "";
RadioButton rb5 = (RadioButton)dr.FindControl("RadioButton5");
RadioButton rb6 = (RadioButton)dr.FindControl("RadioButton6");
//CheckBox cbox5 = (CheckBox)dr.FindControl("CheckBox5");
//CheckBox cbox6 = (CheckBox)dr.FindControl("CheckBox6");
if (rb5.Checked)
{
str = Convert.ToString(true);
}
if (rb6.Checked)
{
str = Convert.ToString(false);
}
int titleid = int.Parse(((Label)dr.FindControl("Label42")).Text);
string Judge = "insert into UserAnswertb(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + Session["userID"].ToString() + "','" + paperid + "','判断题','" + titleid + "','" + judgemark + "','" + str + "','" + DateTime.Now.ToString() + "')";
db.Insert(Judge);
}
}
//取出填空题每题分值
if (GridView4.Rows.Count > 0)
{
int fillmark = int.Parse(((Label)GridView4.Rows[0].FindControl("Label17")).Text);
foreach (GridViewRow dr in GridView4.Rows)
{
string str = "";
str = ((TextBox)dr.FindControl("TextBox1")).Text.Trim();
int titleid = int.Parse(((Label)dr.FindControl("Label43")).Text);
string Fill = "insert into UserAnswertb(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + Session["userID"].ToString() + "','" + paperid + "','填空题','" + titleid + "','" + fillmark + "','" + str + "','" + DateTime.Now.ToString() + "')";
db.Insert(Fill);
}
}
//取出问答题每题分值
if (GridView5.Rows.Count > 0)
{
int quemark = int.Parse(((Label)GridView5.Rows[0].FindControl("Label37")).Text);
foreach (GridViewRow dr in GridView5.Rows)
{
string str = "";
str = ((TextBox)dr.FindControl("TextBox2")).Text.Trim();
int titleid = int.Parse(((Label)dr.FindControl("Label44")).Text);
string Que = "insert into UserAnswertb(UserID,PaperID,Type,TitleID,Mark,UserAnswer,ExamTime) values('" + Session["userID"].ToString() + "','" + paperid + "','问答题','" + titleid + "','" + quemark + "','" + str + "','" + DateTime.Now.ToString() + "')";
db.Insert(Que);
}
}
TempExam te = new TempExam();
te.DeleteTempExam(Session["UserID"].ToString(), Convert.ToInt32(Session["PaperID"]));
}
//将生成试卷保存到数据库
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
DataBase db = new DataBase();
string insertpaper = "insert into Paper(CourseID,PaperName,PaperState,NeedTime) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "',0," +int.Parse(ddlNeedTime.SelectedValue)*60+ ") SELECT @@IDENTITY as id";
int afterID = GetIDInsert(insertpaper);//保存试卷，并返回自动生成的试卷编号
if (afterID > 0)
{
foreach (GridViewRow dr in GridView11.Rows)//保存试卷单选题信息
{
string single = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + int.Parse(((Label)dr.FindControl("Label3")).Text) + "," + int.Parse(txtSingleFen.Text) + ")";
db.Insert(single);
}
foreach (GridViewRow dr in GridView2.Rows)//保存试卷多选题信息
{
string multi = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + int.Parse(((Label)dr.FindControl("Label6")).Text) + "," + int.Parse(txtMultiFen.Text) + ")";
db.Insert(multi);
}
foreach (GridViewRow dr in GridView3.Rows)//保存试卷判断题信息
{
string judge = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + int.Parse(((Label)dr.FindControl("Label7")).Text) + "," + int.Parse(txtJudgeFen.Text) + ")";
db.Insert(judge);
}
foreach (GridViewRow dr in GridView4.Rows)//保存试卷填空题信息
{
string fill = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'填空题'," + int.Parse(((Label)dr.FindControl("Label8")).Text) + "," + int.Parse(txtFillFen.Text) + ")";
db.Insert(fill);
}
foreach (GridViewRow dr in GridView5.Rows)//保存试卷填空题信息
{
string que = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'问答题'," + int.Parse(((Label)dr.FindControl("Label23")).Text) + "," + int.Parse(txtQuestionFen.Text) + ")";
db.Insert(que);
}
Page.RegisterStartupScript("", "<script language=javascript>alert('保存成功');location='PaperLists.aspx'</script>");
}
}
//将生成试卷保存到数据库
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
AjaxCommond ac = new AjaxCommond();
if (IsPaperNameNotExist())
{
DataBase db = new DataBase();
string insertpaper = "insert into Paper(CourseID,PaperName,PaperState,NeedTime) values(" + int.Parse(ddlCourse.SelectedValue) + ",'" + txtPaperName.Text + "',0," + int.Parse(ddlNeedTime.SelectedValue) * 60 + ") SELECT @@IDENTITY as id";
int afterID = GetIDInsert(insertpaper);//保存试卷，并返回自动生成的试卷编号
if (afterID > 0)
{
for (int i = 0; i < this.GridView11.Rows.Count; i++)
{
bool isChecked = ((CheckBox)GridView11.Rows[i].FindControl("chkSelect1")).Checked;
if (isChecked)
{
string str1 = ((Label)GridView11.Rows[i].FindControl("Label3")).Text;
string single = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'单选题'," + str1 + "," + int.Parse(txtSingleFen.Text) + ")";
db.Insert(single);
}
}
for (int i = 0; i < this.GridView2.Rows.Count; i++)
{
bool isChecked = ((CheckBox)GridView2.Rows[i].FindControl("chkSelect2")).Checked;
if (isChecked)
{
string str2 = ((Label)GridView2.Rows[i].FindControl("Label6")).Text;
string multi = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'多选题'," + str2 + "," + int.Parse(txtMultiFen.Text) + ")";
db.Insert(multi);
}
}
for (int i = 0; i < this.GridView3.Rows.Count; i++)
{
bool isChecked = ((CheckBox)GridView3.Rows[i].FindControl("chkSelect3")).Checked;
if (isChecked)
{
string str3 = ((Label)GridView3.Rows[i].FindControl("Label7")).Text;
string judge = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'判断题'," + str3 + "," + int.Parse(txtJudgeFen.Text) + ")";
db.Insert(judge);
}
}
for (int i = 0; i < this.GridView4.Rows.Count; i++)
{
bool isChecked = ((CheckBox)GridView4.Rows[i].FindControl("chkSelect4")).Checked;
if (isChecked)
{
string str4 = ((Label)GridView4.Rows[i].FindControl("Label8")).Text;
string fill = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'填空题'," + str4 + "," + int.Parse(txtFillFen.Text) + ")";
db.Insert(fill);
}
}
for (int i = 0; i < this.GridView5.Rows.Count; i++)
{
bool isChecked = ((CheckBox)GridView5.Rows[i].FindControl("chkSelect5")).Checked;
if (isChecked)
{
string str5 = ((Label)GridView5.Rows[i].FindControl("Label23")).Text;
string que = "insert into PaperDetail(PaperID,Type,TitleID,Mark) values(" + afterID + ",'问答题'," + str5 + "," + int.Parse(txtQuestionFen.Text) + ")";
db.Insert(que);
}
}
}
txtPaperName.Text = "";
ac.OpenDialogForButtonWithLocation((ImageButton)sender, "保存成功！");
}
else
{
ac.OpenDialogForButton((ImageButton)sender, "很遗憾！该试卷名称已经存在！！！");
return ;
}
}
