protected void GridViewBind()
{
MultiProblem multiproblem = new MultiProblem(); //创建多选题对象
DataSet ds = multiproblem.QueryMultiProblem(int.Parse(ddlCourse.SelectedValue));//根据试卷科目查询多选题信息
GridView1.DataSource = ds.Tables[0].DefaultView; //为GridView控件指名数据源
GridView1.DataBind(); //绑定数据
}
//删除多条记录
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
MultiProblem multi = new MultiProblem();//创建MultiProblem对象
foreach (GridViewRow dr in GridView1.Rows)//对GridView中的每一行进行判断
{
if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果选择了进行删除
{
int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
multi.ID = ID;
multi.DeleteByProc(ID);
}
}
}
//删除试题事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
MultiProblem multiproblem = new MultiProblem(); //创建单选题对象
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
if (multiproblem.DeleteByProc(ID))
{
Page.RegisterStartupScript("", "<script language=javascript>alert('成功删除试题！')</script>");
}
else
{
Page.RegisterStartupScript("", "<script language=javascript>alert('删除试题失败！')</script>");
}
GridViewBind();//重新绑定数据
}
//初始化数据
protected void InitData()
{
int multiProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号
MultiProblem multiproblem = new MultiProblem(); //创建单选题对象
if (multiproblem.LoadData(multiProblemID)) //如果取出题目信息，分别放在相应控件显示
{
ddlCourse.SelectedValue = multiproblem.CourseID.ToString();
ddlDiff.SelectedValue = multiproblem.DiffID.ToString();
txtTitle.Text = multiproblem.Title;
txtAnswerA.Text = multiproblem.AnswerA;
txtAnswerB.Text = multiproblem.AnswerB;
txtAnswerC.Text = multiproblem.AnswerC;
txtAnswerD.Text = multiproblem.AnswerD;
string answer = multiproblem.Answer;
for (int i = 0; i < answer.Length; i++)
{
string item = answer[i].ToString();
for (int j = 0; j < cblAnswer.Items.Count; j++)
{
if (item == cblAnswer.Items[j].Text)
{
cblAnswer.Items[j].Selected = true;
}
}
}
}
else //查询出错，给出提示
{
lblMessage.Text = "加载数据出错！";
}
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
MultiProblem multiproblem = new MultiProblem(); //创建单选题对象
multiproblem.CourseID = int.Parse(ddlCourse.SelectedValue);//为单选题对象各属性赋值
multiproblem.DiffID = int.Parse(ddlDiff.SelectedValue);//为填空题对象各属性赋值
multiproblem.Title = txtTitle.Text;
multiproblem.AnswerA = txtAnswerA.Text;
multiproblem.AnswerB = txtAnswerB.Text;
multiproblem.AnswerC = txtAnswerC.Text;
multiproblem.AnswerD = txtAnswerD.Text;
string answer = "";
for (int i = 0; i < cblAnswer.Items.Count; i++)
{
if (cblAnswer.Items[i].Selected)
{
answer += cblAnswer.Items[i].Text;
}
}
multiproblem.Answer = answer;
if (Request["ID"] != null) //如果是修改题目信息
{
multiproblem.ID = int.Parse(Request["ID"].ToString()); //取出试题主键
if (multiproblem.UpdateByProc(int.Parse(Request["ID"].ToString())))//调用修改试题方法修改试题
{
lblMessage.Text = "成功修改该多选题！";
txtTitle.Text = "";
txtAnswerA.Text = "";
txtAnswerB.Text = "";
txtAnswerC.Text = "";
txtAnswerD.Text = "";
for (int i = 0; i < cblAnswer.Items.Count; i++)
{
if (cblAnswer.Items[i].Selected)
{
cblAnswer.Items[i].Selected=false;
}
}
}
else
{
lblMessage.Text = "修改该多选题失败！";
}
}
else //如果是添加试题
{
if (multiproblem.InsertByProc()) //调用添加试题方法添加试题
{
lblMessage.Text = "成功添加该多选题！";
txtTitle.Text = "";
txtAnswerA.Text = "";
txtAnswerB.Text = "";
txtAnswerC.Text = "";
txtAnswerD.Text = "";
for (int i = 0; i < cblAnswer.Items.Count; i++)
{
if (cblAnswer.Items[i].Selected)
{
cblAnswer.Items[i].Selected = false;
}
}
}
else
{
lblMessage.Text = "添加该多选题失败！";
}
}
}
}
protected void txtTitle_TextChanged(object sender, EventArgs e)
{
MultiProblem mp = new MultiProblem();
if (mp.isReduplicated(txtTitle.Text.Trim()) == true)
{
Page.RegisterStartupScript("", "<script>alert('改题已经存在！');</script>");
txtTitle.Text = "";
}
}
