void myform_UpDate2(string state, string time) { tutors_state1 = state; cbo_tutor_state.Text = state; time1 = time; /* string mysql = "SELECT 教员编号,教员姓名,经办状态,经办时间,经办人,处理备注 FROM [Parents-Tutors] WHERE " + * "打印编号='" + print_num1 + "' ORDER BY 经办时间 DESC"; * DataSet mydataset = mydb.ExecuteQuery(mysql, "Parents-Tutors"); * dgv_tutors.DataSource = mydataset.Tables["Parents-Tutors"]; * CCTRS ctr = new CCTRS(); * ctr.ColorDataGridView(dgv_tutors);*/ CmbDataGridview cmbd = new CmbDataGridview(); /* CCTRS ctr = new CCTRS(); * ctr.ColorDataGridView(dgv_tutors);*/ string mystr = "SELECT 教员编号,教员姓名,经办状态,经办时间,经办人,处理备注 FROM [Parents-Tutors] WHERE " + "打印编号='" + print_num1 + "' ORDER BY (SELECT right(经办时间,10)) DESC"; dgv_tutors.DataSource = null; cmbd.bind(dgv_tutors, mystr, "Parents-Tutors"); dgv_tutors.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader; dgv_tutors.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; mystr = "UPDATE [Parents] SET 家教状态='" + tutors_state1 + "' WHERE ID='" + ID1 + "'"; mydb.ExecuteNonQuery(mystr); SetTop(); }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { DialogResult result = DialogResult.No; try { if (dgv_inquire.SelectedRows.Count > 0) { result = MessageBox.Show("是否删除选中项?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk); if (result == DialogResult.Yes) { CommDB mydb = new CommDB(); string mysql = "DELETE FROM [Parents] WHERE ID = '" + dgv_inquire.SelectedRows[0].Cells[1].Value.ToString() + "'"; mydb.ExecuteNonQuery(mysql); MessageBox.Show("删除成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_inquire, mystr, "Parents"); }
private void inquire() { if (txt_student_num.Text == "" && txt_tutors_name.Text == "" && txt_tutors_num.Text == "" && txt_phone.Text == "") { CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_inquire, mystr, "Tutors"); return; } CommDB mydb = new CommDB(); string mysql = "", tempstr = ""; if (txt_tutors_num.Text != "") { tempstr = "教员编号 Like '%" + txt_tutors_num.Text.Trim() + "%'"; } if (txt_tutors_name.Text != "") { if (tempstr == "") { tempstr = "姓名 Like '%" + txt_tutors_name.Text.Trim() + "%'"; } else { tempstr += " AND 姓名 Like '%" + txt_tutors_name.Text.Trim() + "%'"; } } if (txt_student_num.Text != "") { if (tempstr == "") { tempstr = "学号 Like '%" + txt_student_num.Text.Trim() + "%'"; } else { tempstr += " AND 学号 Like '%" + txt_student_num.Text.Trim() + "%'"; } } if (txt_phone.Text != "") { if (tempstr == "") { tempstr = "联系方式 Like '%" + txt_phone.Text.Trim() + "%'"; } else { tempstr += " AND 联系方式 Like '%" + txt_phone.Text.Trim() + "%'"; } } if (tempstr == "") { mysql = "SELECT * FROM [Tutors] ORDER BY 教员编号"; } else { mysql += "SELECT * FROM [Tutors] WHERE " + tempstr + " ORDER BY 教员编号 DESC"; } DataSet mydataset = mydb.ExecuteQuery(mysql, "Tutors"); dgv_inquire.DataSource = mydataset.Tables["Tutors"]; }
private void 择此家教ToolStripMenuItem_Click(object sender, EventArgs e) { try { num1 = dgv_inquire.SelectedRows[0].Cells[2].Value.ToString(); string mysql = "SELECT 是否黑名单 FROM [Tutors] WHERE 教员编号='" + num1 + "'"; CommDB mydb = new CommDB(); string flag = mydb.Returnafield(mysql); if (flag == "是") { MessageBox.Show("此教员已被列入黑名单!请重新选择!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } else { name1 = dgv_inquire.SelectedRows[0].Cells[3].Value.ToString(); UpDate3(num1, name1); this.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } CmbDataGridview cmbd = new CmbDataGridview(); }
private void btn_refresh_Click(object sender, EventArgs e) { CmbDataGridview cmbd = new CmbDataGridview(); string mystr = "SELECT 教员编号,教员姓名,经办状态,经办时间,经办人,处理备注 FROM [Parents-Tutors] WHERE " + "打印编号='" + print_num1 + "' ORDER BY (SELECT right(经办时间,10)) DESC"; cmbd.bind(dgv_tutors, mystr, "Parents-Tutors"); }
private void btn_refresh_Click(object sender, EventArgs e) { CmbDataGridview cmbd = new CmbDataGridview(); string mystr = "SELECT 家长编号,打印编号,经办状态,经办时间,经办人,处理备注 FROM [Tutors-Parents] WHERE " + "教员编号='" + tutors_num1 + "'" + " ORDER BY (SELECT right(经办时间,10)) DESC"; cmbd.bind(dgv_parents, mystr, "Tutors-Parents"); }
private void Responsibility_Load(object sender, EventArgs e) { CmbDataGridview cmbd = new CmbDataGridview(); CCTRS ctr = new CCTRS(); ctr.ColorDataGridView(dgv_responsibility); cmbd.bind(dgv_responsibility, mystr, "Responsibility"); dgv_responsibility.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; }
private void btn_delete_Click(object sender, EventArgs e) { CmbDataGridview cmbd = new CmbDataGridview(); DialogResult result = DialogResult.No; int n = 0; try { for (int i = 0; i < dgv_inquire.Rows.Count; i++) { if ((bool)dgv_inquire.Rows[i].Cells[0].EditedFormattedValue == true) //判断该复选框是否被选中 { n++; if (n == 1) { result = MessageBox.Show("是否删除勾选项?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk); } if (result == DialogResult.Yes) { string mysql = "DELETE FROM [Parents] WHERE ID = '" + dgv_inquire.Rows[i].Cells[1].Value.ToString() + "'"; mydb.ExecuteNonQuery(mysql); } } } if (n != 0) { MessageBox.Show("删除成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); cmbd.bind(dgv_inquire, mystr, "Parents"); } if (dgv_inquire.SelectedRows.Count > 0 && n == 0) { result = MessageBox.Show("是否删除选中项?", "操作提示", MessageBoxButtons.YesNo, MessageBoxIcon.Asterisk); if (result == DialogResult.Yes) { CommDB mydb = new CommDB(); string mysql = "DELETE FROM [Parents] WHERE ID = '" + dgv_inquire.SelectedRows[0].Cells[1].Value.ToString() + "'"; mydb.ExecuteNonQuery(mysql); MessageBox.Show("删除成功!", "操作提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "操作数据库出错!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } cmbd.bind(dgv_inquire, mystr, "Parents"); }
private void btn_check_Click(object sender, EventArgs e) { if (txt_parentnum.Text.Trim() == "" && txt_print_num.Text.Trim() == "" && txt_time.Text.Trim() == "") { CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_responsibility, mystr, "Responsibility"); return; } string mysql = "", tempstr = ""; if (txt_parentnum.Text != "") { tempstr = "家长编号 Like '%" + txt_parentnum.Text.Trim() + "%'"; } if (txt_print_num.Text != "") { if (tempstr == "") { tempstr = "打印编号 Like '%" + txt_print_num.Text.Trim() + "%'"; } else { tempstr += " AND 打印编号 Like '%" + txt_print_num.Text.Trim() + "%'"; } } if (txt_time.Text != "") { if (tempstr == "") { tempstr = "经办时间 Like '%" + txt_time.Text.Trim() + "%'"; } else { tempstr += " AND 经办时间 Like '%" + txt_time.Text.Trim() + "%'"; } } if (tempstr == "") { mysql = "SELECT 家长编号,打印编号,经办状态,经办时间,经办人,处理备注 FROM [Responsibility] ORDER BY 经办时间 DESC"; } else { mysql += "SELECT 家长编号,打印编号,经办状态,经办时间,经办人,处理备注 FROM [Responsibility] WHERE " + tempstr + " ORDER BY 经办时间 DESC"; } DataSet mydataset = mydb.ExecuteQuery(mysql, "Responsibility"); dgv_responsibility.DataSource = mydataset.Tables["Responsibility"]; }
void myform_SetTop() { if (txt_adr.Text == "" && txt_parentnum.Text == "" && txt_phone.Text == "" && txt_printnum.Text == "") { CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_inquire, mystr, "Parents"); } else { inquire(); } dgv_inquire.SelectedRows[0].Selected = false; dgv_inquire.Rows[selectnum].Selected = true; dgv_inquire.FirstDisplayedScrollingRowIndex = p; }
void myform_SetTop2() { if (txt_student_num.Text == "" && txt_tutors_name.Text == "" && txt_phone.Text == "" && txt_tutors_num.Text == "") { CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_inquire, mystr, "Tutors"); } else { inquire(); } dgv_inquire.SelectedRows[0].Selected = false; dgv_inquire.Rows[selectnum].Selected = true; dgv_inquire.FirstDisplayedScrollingRowIndex = p; }
private void Workers_Revise_Load(object sender, EventArgs e) { CmbDataGridview cmbdgv = new CmbDataGridview(); CCTRS ctr = new CCTRS(); ctr.ColorDataGridView(dgv_inquire); string tb = "Workers"; cmbdgv.bind(dgv_inquire, mystr, tb); for (int i = 1; i < dgv_inquire.ColumnCount; i++) { dgv_inquire.Columns[i].ReadOnly = true; } dgv_inquire.Columns[0].ReadOnly = false; dgv_inquire.Columns[1].Visible = false; dgv_inquire.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
private void Students_Revise_Load(object sender, EventArgs e) { CmbDataGridview cmbd = new CmbDataGridview(); CCTRS ctr = new CCTRS(); ctr.ColorDataGridView(dgv_parents); string mystr = "SELECT 家长编号,打印编号,经办状态,经办时间,经办人,处理备注 FROM [Tutors-Parents] WHERE " + "教员编号='" + tutors_num1 + "'" + " ORDER BY (SELECT right(经办时间,10)) DESC"; cmbd.bind(dgv_parents, mystr, "Tutors-Parents"); dgv_parents.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader; dgv_parents.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; txt_num.Text = tutors_num1; txt_student_name.Text = tutors_name1; txt_student_num.Text = student_num1; cmbc.cboDataBind(cbo_subject, "SELECT distinct 院系专业 FROM [Tutors]", "Tutors", "院系专业"); cbo_subject.Text = grade_subject1; cbo_degree.Text = tutors_degree1; if (sex1 == "男") { rdo_man.Checked = true; } if (sex1 == "女") { rdo_woman.Checked = true; } txt_phone.Text = phone1; txt_place.Text = place1; if (blacklist1 == "是") { cbo_yesno.SelectedItem = "是"; } if (blacklist1 == "否") { cbo_yesno.SelectedItem = "否"; } txt_imprisonment.Text = imprisonment1; txt_important_remarks.Text = remarks1; }
private void Tutors_revise_Load(object sender, EventArgs e) { CmbClass cmbc = new CmbClass(); cmbc.cboDataBind(cbo_reception, "SELECT distinct 姓名 FROM [Workers]", "Workers", "姓名"); CmbDataGridview cmbd = new CmbDataGridview(); CCTRS ctr = new CCTRS(); ctr.ColorDataGridView(dgv_tutors); string mystr = "SELECT 教员编号,教员姓名,经办状态,经办时间,经办人,处理备注 FROM [Parents-Tutors] WHERE " + "打印编号='" + print_num1 + "' ORDER BY (SELECT right(经办时间,10)) DESC"; cmbd.bind(dgv_tutors, mystr, "Parents-Tutors"); dgv_tutors.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.ColumnHeader; dgv_tutors.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; txt_parent_num.Text = parent_num1; txt_print_num.Text = print_num1; mystr = "SELECT 接入时间 FROM [Parents] WHERE ID='" + ID1 + "'"; dt_recepiton_time.Text = mydb.Returnafield(mystr); txt_parent_name.Text = parent_name1; txt_phone.Text = phone1; mystr = "SELECT 家教地址简单 FROM [Parents] WHERE ID='" + ID1 + "'"; txt_sadd.Text = mydb.Returnafield(mystr); txt_dadd.Text = dadd1; txt_grade_subject.Text = grade_subject1; if (student_sex1 == "男") { rdo_man.Checked = true; } if (student_sex1 == "女") { rdo_woman.Checked = true; } txt_tutor_price.Text = tutors_price1; txt_tutor_time.Text = tutors_time1; mystr = "SELECT 接待人 FROM [Parents] WHERE ID='" + ID1 + "'"; cbo_reception.Text = mydb.Returnafield(mystr); mystr = "SELECT 教员要求性别 FROM [Parents] WHERE ID='" + ID1 + "'"; cbo_sex.SelectedItem = mydb.Returnafield(mystr); mystr = "SELECT 教员要求地域 FROM [Parents] WHERE ID='" + ID1 + "'"; txt_place.Text = mydb.Returnafield(mystr); mystr = "SELECT 教员要求年级 FROM [Parents] WHERE ID='" + ID1 + "'"; txt_grade.Text = mydb.Returnafield(mystr); mystr = "SELECT 教员要求专业 FROM [Parents] WHERE ID='" + ID1 + "'"; txt_subject.Text = mydb.Returnafield(mystr); mystr = "SELECT 教员要求其他 FROM [Parents] WHERE ID='" + ID1 + "'"; txt_other_requests.Text = mydb.Returnafield(mystr); // string[] tutors_state = tutors_state1.Split(' '); // cbo_tutor_state.SelectedItem = tutors_state.Last(); cbo_tutor_state.SelectedItem = tutors_state1; txt_important_remarks.Text = important_mark1; cbo_payment_state.SelectedItem = payment_state1; dt_payment_time.Text = payment_time1; if (cbo_payment_state.SelectedItem.ToString() == "待缴" || cbo_payment_state.SelectedItem.ToString() == "无需缴纳") { dt_payment_time.Enabled = false; } if (cbo_payment_state.SelectedItem.ToString() == "已缴") { dt_payment_time.Enabled = true; } flag = true; }
private void inquire() { if (txt_parentnum.Text == "" && txt_printnum.Text == "" && txt_adr.Text == "" && txt_phone.Text == "") { CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_inquire, mystr, "Parents"); return; } CommDB mydb = new CommDB(); string mysql = "", tempstr = ""; if (txt_parentnum.Text != "") { tempstr = "家长编号 Like '%" + txt_parentnum.Text.Trim() + "%'"; } if (txt_printnum.Text != "") { if (tempstr == "") { tempstr = "打印编号 Like '%" + txt_printnum.Text.Trim() + "%'"; } else { tempstr += " AND 打印编号 Like '%" + txt_printnum.Text.Trim() + "%'"; } } if (txt_adr.Text != "") { if (tempstr == "") { tempstr = "家教地址详细 Like '%" + txt_adr.Text.Trim() + "%'"; } else { tempstr += " AND 家教地址详细 Like '%" + txt_adr.Text.Trim() + "%'"; } } if (txt_phone.Text != "") { if (tempstr == "") { tempstr = "联系方式 Like '%" + txt_phone.Text.Trim() + "%'"; } else { tempstr += " AND 联系方式 Like '%" + txt_phone.Text.Trim() + "%'"; } } if (tempstr == "") { mysql = "SELECT ID,家长编号,打印编号,家长称呼,联系方式," + "年级科目,学员性别,家教状态,经办时间,家教价格,家教时间,家教地址详细,重要备注,缴费状态,缴费时间 FROM [Parents] ORDER BY 打印编号"; } else { mysql += "SELECT ID,家长编号,打印编号,家长称呼,联系方式," + "年级科目,学员性别,家教状态,经办时间,家教价格,家教时间,家教地址详细,重要备注,缴费状态,缴费时间 FROM [Parents] WHERE " + tempstr + " ORDER BY 打印编号 DESC"; } DataSet mydataset = mydb.ExecuteQuery(mysql, "Parents"); dgv_inquire.DataSource = mydataset.Tables["Parents"]; }
void myform_SetTop3() { CmbDataGridview cmbd = new CmbDataGridview(); cmbd.bind(dgv_inquire, mystr, "Workers"); }