private void skinButton5_Click(object sender, EventArgs e)
{
if (skinCheckBox1.Checked == true && skinCheckBox2.Checked == true)
{
MessageBox.Show("请不要勾选两项");
}
if (skinCheckBox1.Checked == true && skinCheckBox2.Checked == false)
{
string sql = string.Format("update {0} set {1}='{2}' where 姓名='{3}'", tablename, time, skinCheckBox1.Text.ToString(), skinLabelallname.Text.ToString());
if (Updatedata.Update1(sql) > 0)
{
MessageBox.Show("修改成功");
DataTable dataTable = selectData.table(tablename);
skinDataGridView1.DataSource = dataTable;
}
}
if (skinCheckBox2.Checked == true && skinCheckBox1.Checked == false)
{
string sql = string.Format("update {0} set {1}='{2}' where 姓名='{3}'", tablename, time, skinCheckBox2.Text.ToString(), skinLabelallname.Text.ToString());
if (Updatedata.Update1(sql) > 0)
{
MessageBox.Show("修改成功");
DataTable dataTable = selectData.table(tablename);
skinDataGridView1.DataSource = dataTable;
}
}
}
private void skinButton2_Click(object sender, EventArgs e)
{
string sql = string.Format("insert into User_Teacher(userName,userPassword) values ('{0}','{1}')", user.Text.ToString(), password.Text.ToString());
if (skinWaterTextBox1.Text.ToString() == skinCode1.CodeStr)
{
if (password.Text.ToString() == skinWaterTextBox2.Text.ToString())
{
if (Updatedata.Update1(sql) > 0)
{
MessageBox.Show("注册成功！", "提示");
}
}
else
{
MessageBox.Show("两次密码输入不一致!", "提示");
skinWaterTextBox2.Text = "";
}
}
else
{
MessageBox.Show("验证码错误！", "提示");
skinWaterTextBox1.Text = "";
}
}
private void skinButton2_Click(object sender, EventArgs e)
{
string time = "考勤时间" + skinWaterTextBox5.Text.ToString();
if (skinCheckBox1.Checked == true && skinCheckBox3.Checked == true && skinCheckBox4.Checked == true)
{
MessageBox.Show("请不要勾选多项");
}
if (skinCheckBox1.Checked == true && skinCheckBox3.Checked == true)
{
MessageBox.Show("请不要勾选多项");
}
if (skinCheckBox1.Checked == true && skinCheckBox4.Checked == true)
{
MessageBox.Show("请不要勾选多项");
}
if (skinCheckBox3.Checked == true && skinCheckBox4.Checked == true)
{
MessageBox.Show("请不要勾选多项");
}
if (skinCheckBox1.Checked == true && skinCheckBox3.Checked == false && skinCheckBox4.Checked == false)
{
string sql = string.Format("update {0} set {1}='{2}' where 姓名='{3}'", tablename, time, skinCheckBox1.Text.ToString(), skinWaterTextBox3.Text.ToString());
if (Updatedata.Update1(sql) > 0)
{
MessageBox.Show("修改成功");
DataTable dataTable = selectData.table1(tablename, skinWaterTextBox3.Text.ToString());
skinDataGridView1.DataSource = dataTable;
}
}
if (skinCheckBox3.Checked == true && skinCheckBox1.Checked == false && skinCheckBox4.Checked == false)
{
string sql = string.Format("update {0} set {1}='{2}' where 姓名='{3}'", tablename, time, skinCheckBox3.Text.ToString(), skinWaterTextBox3.Text.ToString());
if (Updatedata.Update1(sql) > 0)
{
MessageBox.Show("修改成功");
DataTable dataTable = selectData.table1(tablename, skinWaterTextBox3.Text.ToString());
skinDataGridView1.DataSource = dataTable;
}
}
if (skinCheckBox4.Checked == true && skinCheckBox1.Checked == false && skinCheckBox3.Checked == false)
{
string sql = string.Format("update {0} set {1}='{2}' where 姓名='{3}'", tablename, time, skinCheckBox4.Text.ToString(), skinWaterTextBox3.Text.ToString());
if (Updatedata.Update1(sql) > 0)
{
MessageBox.Show("修改成功");
DataTable dataTable = selectData.table1(tablename, skinWaterTextBox3.Text.ToString());
skinDataGridView1.DataSource = dataTable;
}
}
}
