protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
SingleProblem singleProble = new SingleProblem();
singleProble.ID = int.Parse(Request["ID"].ToString());
singleProble.CourseID = Convert.ToInt32(ddlCourse.SelectedValue);
singleProble.Title = txtTitle.Text;
singleProble.AnswerA = txtAnswerA.Text;
singleProble.AnswerB = txtAnswerB.Text;
singleProble.AnswerC = txtAnswerC.Text;
singleProble.AnswerD = txtAnswerD.Text;
singleProble.Answer = ddlAnswer.SelectedValue;
if (singleSelectedService.UpdateSingleSelected(singleProble))
{
lblMessage.Text = "修改成功!";
txtTitle.Text = string.Empty;
txtAnswerA.Text = string.Empty;
txtAnswerB.Text = string.Empty;
txtAnswerC.Text = string.Empty;
txtAnswerD.Text = string.Empty;
}
else
{
lblMessage.Text = "修改失败!";
}
}
//GridView控件绑定数据事件
protected void GridViewBind()
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
DataSet ds = singleproblem.QuerySingleProblem(int.Parse(ddlCourse.SelectedValue));//根据试卷科目查询单选题信息
GridView1.DataSource = ds.Tables[0].DefaultView; //为GridView控件指名数据源
GridView1.DataBind(); //绑定数据
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
SingleProblem sp = new SingleProblem();
sp.CourseID = Convert.ToInt32(ddlCourse.SelectedValue);
sp.Title = txtTitle.Text;
sp.AnswerA = txtAnswerA.Text;
sp.AnswerB = txtAnswerB.Text;
sp.AnswerC = txtAnswerC.Text;
sp.AnswerD = txtAnswerD.Text;
sp.Answer = ddlAnswer.SelectedValue;
if (SingleSelectedManager.AddSingleSelected(sp))
{
lblMessage.Text = "添加成功！";
txtTitle.Text = string.Empty;
txtAnswerA.Text = string.Empty;
txtAnswerB.Text = string.Empty;
txtAnswerC.Text = string.Empty;
txtAnswerD.Text = string.Empty;
}
else
{
lblMessage.Text = "添加失败！";
}
}
protected void Button_preview_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
singleproblem.c_id = int.Parse(ddlCourse.SelectedValue); //为单选题对象各属性赋值
singleproblem.Title = txtTitle.Text;
singleproblem.AnswerA = txtAnswerA.Text;
singleproblem.AnswerB = txtAnswerB.Text;
singleproblem.AnswerC = txtAnswerC.Text;
singleproblem.AnswerD = txtAnswerD.Text;
singleproblem.Answer = ddlAnswer.SelectedItem.Text;
if (Request["ID"] != null) //如果是修改题目信息
{
singleproblem.ID = int.Parse(Request["ID"].ToString()); //取出试题主键
if (singleproblem.UpdateByProc(int.Parse(Request["ID"].ToString()))) //调用修改试题方法修改试题
{
Response.Write("<script>alert('修改成功！');</script>");
}
else
{
Response.Write("<script>alert('修改失败！');</script>");
}
Response.Write("<script>window.location.href='ManageDanXuan.aspx'</script>");
}
}
}
//GridView控件绑定数据事件
protected void GridViewBind()
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
DataSet ds = singleproblem.QuerySingleProblem(int.Parse(ddlCourse.SelectedValue)); //根据考试科目查询单选题信息
GridView1.DataSource = ds.Tables[0].DefaultView; //为GridView控件指名数据源
GridView1.DataBind(); //绑定数据
}
//添加或修改事件
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
singleproblem.CourseID = int.Parse(ddlCourse.SelectedValue);//为单选题对象各属性赋值
singleproblem.DiffID = int.Parse(ddlDiff.SelectedValue);//为填空题对象各属性赋值
singleproblem.Title = txtTitle.Text;
//if (singleproblem.isReduplicated(txtTitle.Text.Trim()) == true)
//{
// Page.RegisterStartupScript("", "<script>alert('改题已经存在！');</script>");
// txtTitle.Text = "";
// return;
//}
singleproblem.AnswerA = txtAnswerA.Text;
singleproblem.AnswerB = txtAnswerB.Text;
singleproblem.AnswerC = txtAnswerC.Text;
singleproblem.AnswerD = txtAnswerD.Text;
singleproblem.Answer = ddlAnswer.SelectedItem.Text;
if (Request["ID"] != null) //如果是修改题目信息
{
singleproblem.ID = int.Parse(Request["ID"].ToString()); //取出试题主键
if (singleproblem.UpdateByProc(int.Parse(Request["ID"].ToString())))//调用修改试题方法修改试题
{
lblMessage.Text = "成功修改该单选题！";
txtTitle.Text = "";
txtAnswerA.Text = "";
txtAnswerB.Text = "";
txtAnswerC.Text = "";
txtAnswerD.Text = "";
ddlAnswer.SelectedIndex = 0;
}
else
{
lblMessage.Text = "修改该单选题失败！";
}
}
else //如果是添加试题
{
if (singleproblem.InsertByProc()) //调用添加试题方法添加试题
{
lblMessage.Text = "成功添加该单选题！";
txtTitle.Text = "";
txtAnswerA.Text = "";
txtAnswerB.Text = "";
txtAnswerC.Text = "";
txtAnswerD.Text = "";
ddlAnswer.SelectedIndex = 0;
}
else
{
lblMessage.Text = "添加该单选题失败！";
}
}
}
}
//添加或修改事件
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
singleproblem.CourseID = int.Parse(ddlCourse.SelectedValue); //为单选题对象各属性赋值
singleproblem.DiffID = int.Parse(ddlDiff.SelectedValue); //为填空题对象各属性赋值
singleproblem.Title = txtTitle.Text;
//if (singleproblem.isReduplicated(txtTitle.Text.Trim()) == true)
//{
// Page.RegisterStartupScript("", "<script>alert('改题已经存在！');</script>");
// txtTitle.Text = "";
// return;
//}
singleproblem.AnswerA = txtAnswerA.Text;
singleproblem.AnswerB = txtAnswerB.Text;
singleproblem.AnswerC = txtAnswerC.Text;
singleproblem.AnswerD = txtAnswerD.Text;
singleproblem.Answer = ddlAnswer.SelectedItem.Text;
if (Request["ID"] != null) //如果是修改题目信息
{
singleproblem.ID = int.Parse(Request["ID"].ToString()); //取出试题主键
if (singleproblem.UpdateByProc(int.Parse(Request["ID"].ToString()))) //调用修改试题方法修改试题
{
lblMessage.Text = "成功修改该单选题！";
txtTitle.Text = "";
txtAnswerA.Text = "";
txtAnswerB.Text = "";
txtAnswerC.Text = "";
txtAnswerD.Text = "";
ddlAnswer.SelectedIndex = 0;
}
else
{
lblMessage.Text = "修改该单选题失败！";
}
}
else //如果是添加试题
{
if (singleproblem.InsertByProc()) //调用添加试题方法添加试题
{
lblMessage.Text = "成功添加该单选题！";
txtTitle.Text = "";
txtAnswerA.Text = "";
txtAnswerB.Text = "";
txtAnswerC.Text = "";
txtAnswerD.Text = "";
ddlAnswer.SelectedIndex = 0;
}
else
{
lblMessage.Text = "添加该单选题失败！";
}
}
}
}
protected void txtTitle_TextChanged(object sender, EventArgs e)
{
SingleProblem sp = new SingleProblem();
if (sp.isReduplicated(txtTitle.Text.Trim()) == true)
{
Page.RegisterStartupScript("", "<script>alert('改题已经存在！');</script>");
txtTitle.Text = "";
}
}
//删除多条记录
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SingleProblem single = new SingleProblem();//创建SingleProblem对象
foreach (GridViewRow dr in GridView1.Rows)//对GridView中的每一行进行判断
{
if (((CheckBox)dr.FindControl("xuanze")).Checked)//如果选择了进行删除
{
int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
single.ID = ID;
single.DeleteByProc(ID);
}
}
}
//删除多条记录
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SingleProblem single = new SingleProblem(); //创建SingleProblem对象
foreach (GridViewRow dr in GridView1.Rows) //对GridView中的每一行进行判断
{
if (((CheckBox)dr.FindControl("xuanze")).Checked) //如果选择了进行删除
{
int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
single.ID = ID;
single.DeleteByProc(ID);
}
}
}
//删除试题事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
if (singleproblem.DeleteByProc(ID))
{
Page.RegisterStartupScript("", "<script language=javascript>alert('成功删除试题！')</script>");
}
else
{
Page.RegisterStartupScript("", "<script language=javascript>alert('删除试题失败！')</script>");
}
GridView1.EditIndex = -1;
GridViewBind();//重新绑定数据
}
//删除试题事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
if (singleproblem.DeleteByProc(ID))
{
Response.Write("<script language=javascript>alert('成功删除试题！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('删除试题失败！')</script>");
}
GridView1.EditIndex = -1;
GridViewBind();//重新绑定数据
}
//初始化数据
protected void InitData()
{
int SingleProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
if (singleproblem.LoadData(SingleProblemID)) //如果取出题目信息，分别放在相应控件显示
{
ddlCourse.SelectedValue = singleproblem.CourseID.ToString();
txtTitle.Text = singleproblem.Title;
txtAnswerA.Text = singleproblem.AnswerA;
txtAnswerB.Text = singleproblem.AnswerB;
txtAnswerC.Text = singleproblem.AnswerC;
txtAnswerD.Text = singleproblem.AnswerD;
ddlAnswer.SelectedItem.Text = singleproblem.Answer;
}
else //查询出错，给出提示
{
lblMessage.Text = "加载数据出错！";
}
}
protected void InitData()
{
int SingleProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
if (singleproblem.LoadData(SingleProblemID)) //如果取出题目信息，分别放在相应控件显示
{
db.ecDropDownList(ddlCourse, "select * from Course where c_id=(select c_id from SingleProblem where ID='" + SingleProblemID + " ')", "c_name", "c_id");
txtTitle.Text = singleproblem.Title;
txtAnswerA.Text = singleproblem.AnswerA;
txtAnswerB.Text = singleproblem.AnswerB;
txtAnswerC.Text = singleproblem.AnswerC;
txtAnswerD.Text = singleproblem.AnswerD;
ddlAnswer.SelectedItem.Text = singleproblem.Answer;
}
else //查询出错，给出提示
{
Response.Write("<script>alert('加载数据错误！');</script>");
Response.Write("<script>window.location.href='ChangeDanXuan.aspx'</script>");
}
}
protected void save_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
singleproblem.CourseID = int.Parse(ddlCourse.SelectedValue); //为单选题对象各属性赋值
singleproblem.Title = txtTitle.Text;
singleproblem.AnswerA = txtAnswerA.Text;
singleproblem.AnswerB = txtAnswerB.Text;
singleproblem.AnswerC = txtAnswerC.Text;
singleproblem.AnswerD = txtAnswerD.Text;
singleproblem.Answer = ddlAnswer.SelectedItem.Text;
if (Request["ID"] != null) //如果是修改题目信息
{
singleproblem.ID = int.Parse(Request["ID"].ToString()); //取出试题主键
if (singleproblem.UpdateByProc(int.Parse(Request["ID"].ToString()))) //调用修改试题方法修改试题
{
lblMessage.Text = "成功修改该单选题！";
}
else
{
lblMessage.Text = "修改该单选题失败！";
}
}
else //如果是添加试题
{
if (singleproblem.InsertByProc()) //调用添加试题方法添加试题
{
lblMessage.Text = "成功添加该单选题！";
}
else
{
lblMessage.Text = "添加该单选题失败！";
}
}
}
}
public bool AddSingleSelected(SingleProblem sp)
{
return service.InsertQuestion(sp);
}
//初始化数据
protected void InitData()
{
int SingleProblemID = int.Parse(Request["ID"].ToString()); //取出传递过来的试题编号
SingleProblem singleproblem = new SingleProblem(); //创建单选题对象
if (singleproblem.LoadData(SingleProblemID)) //如果取出题目信息，分别放在相应控件显示
{
ddlCourse.SelectedValue = singleproblem.CourseID.ToString();
ddlDiff.SelectedValue = singleproblem.DiffID.ToString();
txtTitle.Text = singleproblem.Title;
txtAnswerA.Text = singleproblem.AnswerA;
txtAnswerB.Text = singleproblem.AnswerB;
txtAnswerC.Text = singleproblem.AnswerC;
txtAnswerD.Text = singleproblem.AnswerD;
ddlAnswer.SelectedValue = singleproblem.Answer.ToUpper();
}
else //查询出错，给出提示
{
lblMessage.Text = "加载数据出错！";
}
}
public bool UpdateSingleSelected(SingleProblem spp)
{
return service.UpdateQuestion(spp);
}
protected void txtTitle_TextChanged(object sender, EventArgs e)
{
SingleProblem sp = new SingleProblem();
if (sp.isReduplicated(txtTitle.Text.Trim()) == true)
{
Page.RegisterStartupScript("", "<script>alert('改题已经存在！');</script>");
txtTitle.Text = "";
}
}
