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