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