private bool OccupyCheck(string strC1, string strC2, string strCL1, string strCL2) { string[] sql = new string[8]; int state = 0; sql[0] = "select *from z_tmp_teacherinfo where CClass1='" + strCL1 + "'and Course1_='" + strC1 + "'or CClass1='" + strCL1 + "'and Course2_='" + strC2 + "'"; sql[1] = "select *from z_tmp_teacherinfo where CClass1='" + strCL2 + "'and Course1_='" + strC1 + "'or CClass1='" + strCL2 + "'and Course2_='" + strC2 + "'"; sql[2] = "select *from z_tmp_teacherinfo where CClass2='" + strCL1 + "'and Course1_='" + strC1 + "'or CClass2='" + strCL1 + "'and Course2_='" + strC2 + "'"; sql[3] = "select *from z_tmp_teacherinfo where CClass2='" + strCL2 + "'and Course1_='" + strC1 + "'or CClass2='" + strCL2 + "'and Course2_='" + strC2 + "'"; //object obj0 = dao.ExecuteScale(sql[0]); //object obj1 = dao.ExecuteScale(sql[1]); //object obj2 = dao.ExecuteScale(sql[2]); //object obj3 = dao.ExecuteScale(sql[3]); for (int i = 0; i < 4; i++) { if (dao.ExecuteScale(sql[i]) != null) { state = 1; } } if (state == 1) { return(false); } else { return(true); } }
private void btnDelete_Click(object sender, EventArgs e) { string Confirm = "删除课程需要重新生成课表,确认继续删除?"; DialogResult dr = MessageBox.Show(Confirm, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (dr == DialogResult.OK) { truncateTable(); string sql = "select * from Z_tmp_CourseSum"; object obj = dao.ExecuteScale(sql); if (obj == null) { MessageBox.Show("当前数据库没有数据!"); } else { if (grdView.DataSource == null) { MessageBox.Show("请选中要删除的数据!"); } else { string Confirm1 = string.Format("确认删除课程{0},编号{1}?", grdView[1, grdView.SelectedCells[1].RowIndex].Value.ToString(), grdView[0, grdView.SelectedCells[0].RowIndex].Value.ToString()); DialogResult dr1 = MessageBox.Show(Confirm1, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr1 == DialogResult.OK) { string tmp = "delete from z_tmp_CourseSum where CID_='" + grdView[0, grdView.SelectedCells[0].RowIndex].Value.ToString() + "'"; dao.ExecuteNonQuery(tmp); string id_ = grdView[0, grdView.SelectedCells[0].RowIndex].Value.ToString(); string name = grdView[1, grdView.SelectedCells[1].RowIndex].Value.ToString(); log.InfoFormat("删除:{0},名称{1}", id_, name); } } } } query(); }
private void btnAlter_Click(object sender, EventArgs e) { string Confirm = "修改教师需要重新生成课表,确认继续修改?"; DialogResult dr = MessageBox.Show(Confirm, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (dr == DialogResult.OK) { truncateTable(); string sql = "select * from Z_tmp_teacherinfo"; object obj = dao.ExecuteScale(sql); if (obj == null) { MessageBox.Show("当前数据库没有数据!"); } else { if (grdview.DataSource == null) { MessageBox.Show("请选中要修改的行!"); query(); } else { string[] arr = new string[7]; for (int i = 0; i < 7; i++) { arr[i] = grdview[i, grdview.SelectedCells[i].RowIndex].Value.ToString(); } SubTeacher alter = new SubTeacher(); alter.getState(2); alter.getArry(arr); alter.ShowDialog(); } } query(); } }