private void tabPage_giveTopiv_Enter(object sender, EventArgs e)
{
DAL.topics dal = new DAL.topics();
this.dgv_topics.DataSource = dal.get_all_topic_info();
load_cb_level();
load_cb_cate();
}
private void btn_delete_Click(object sender, EventArgs e)
{
if (selected_id != -1)
{
DAL.topics dal = new DAL.topics();
dal.delete_topic_info(selected_id);
this.dgv_topics.DataSource = dal.get_all_topic_info();
}
else
{
MessageBox.Show("请先单击选中任何行");
}
}
private void FTeacher_Load(object sender, EventArgs e)
{
checkBox1.Text = "A.";
checkBox2.Text = "B.";
checkBox3.Text = "C.";
checkBox4.Text = "D.";
load_cb_exam_cate();
load_cb_class();
load_cb_time();
dgv_exam.DataSource = Ado.SqlHelper.ExecuteDataTable(" SELECT * FROM ExamList WHERE isDel =0 ");
DAL.topics dal = new DAL.topics();
dgv_exam_topic.DataSource = dal.get_all_topic_info();
}
private void btn_addtopic_Click(object sender, EventArgs e)
{
if (tb_stem.Text.Trim() == string.Empty || tb_selectItem_A.Text.Trim() == string.Empty || tb_selectItem_B.Text.Trim() == string.Empty || tb_selectItem_C.Text.Trim() == string.Empty || tb_selectItem_C.Text.Trim() == string.Empty)
{
MessageBox.Show("请保证任何一项不可为空 ");
}
else if (checkBox1.Checked == false && checkBox2.Checked == false && checkBox3.Checked == false && checkBox4.Checked == false)
{
MessageBox.Show("请保证答案至少有一项 ");
}
else
{
DAL.topics dal = new DAL.topics();
string stem = tb_stem.Text;
stem += "A." + tb_selectItem_A.Text;
stem += "B." + tb_selectItem_B.Text;
stem += "C." + tb_selectItem_C.Text;
stem += "D." + tb_selectItem_D.Text;
string TopicAnswer = "";
int answers = 0;
foreach (var a in this.tabControl1.TabPages[0].Controls)
{
CheckBox onecheckbox = a as CheckBox;
if (onecheckbox != null && onecheckbox.Checked == true)
{
TopicAnswer += onecheckbox.Text.Substring(0, 2);
answers += 1;
}
}
int cate = Convert.ToInt32(cb_cate.SelectedValue);
int topiclevel = Convert.ToInt32(cb_level.SelectedValue);
int topicType = 0;
if (answers > 1)
{
topicType = 2;
}
else
{
topicType = 1;
}
if (dal.insert_topics_info(stem, TopicAnswer, cate, topiclevel, topicType, 0) >= 1)
{
MessageBox.Show("添加成功 ");
}
this.dgv_topics.DataSource = dal.get_all_topic_info();
}
}
private void dgv_topics_CellClick(object sender, DataGridViewCellEventArgs e)
{
selected_id = Convert.ToInt32(dgv_topics.SelectedRows[0].Cells[0].Value);//获取选中id
DAL.topics dal = new DAL.topics();
DataRow dt = dal.get_real_topic_info
(selected_id).Rows[0];
string[] stems = dt[1].ToString().Split(new string[] { "A.", "B.", "C", "D" }, StringSplitOptions.RemoveEmptyEntries);
if (stems.Count() == 0)
{
tb_stem.Text = "";
return;
}
else
{
tb_stem.Text = stems[0];
}
if (stems.Count() > 1)
{
tb_selectItem_A.Text = stems[1];
}
if (stems.Count() > 2)
{
tb_selectItem_B.Text = stems[2];
}
if (stems.Count() > 3)
{
tb_selectItem_C.Text = stems[3];
}
if (stems.Count() > 4)
{
tb_selectItem_D.Text = stems[4];
}
string[] answers = dt[2].ToString().Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries);
if (answers.Contains("A"))
{
checkBox1.Checked = true;
}
else
{
checkBox1.Checked = false;
}
if (answers.Contains("B"))
{
checkBox2.Checked = true;
}
else
{
checkBox2.Checked = false;
}
if (answers.Contains("C"))
{
checkBox3.Checked = true;
}
else
{
checkBox3.Checked = false;
}
if (answers.Contains("D"))
{
checkBox4.Checked = true;
}
else
{
checkBox4.Checked = false;
}
cb_cate.SelectedValue = Convert.ToInt32(dt[3]);
cb_level.SelectedValue = Convert.ToInt32(dt[4]);
}
