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(); } }