private void button1_Click(object sender, EventArgs e) { if (textBox3.Text != "") { if (script.GetEmpName(textBox2.Text.Trim()) != "ไม่พบข้อมูลพนักงาน") { string sql = "select * from tbl_code_edit where tbl_code_name = '" + textBox1.Text + "' and tbl_code_status is Null"; if (textBox1.Text != "" && textBox2.Text != "") { MySqlDataReader rs = adminScript.GetCodeEdit(sql); if (rs.Read()) { adminScript.InsertUpdaeCodeEdit("UPDATE tbl_code_edit SET tbl_code_user_emp='" + textBox2.Text + "',tbl_code_date= NOW(),tbl_code_cpoint='" + mainForm.cpoint_id + "',tbl_code_note='" + textBox3.Text + "' where tbl_code_name = '" + textBox1.Text + "'"); sql = "SELECT COUNT(*) AS num FROM tbl_code_edit WHERE tbl_code_user_emp = '" + textBox2.Text + "' AND MONTH(tbl_code_date) = MONTH(CURDATE()) AND YEAR(tbl_code_date) = YEAR(CURDATE())"; rs = adminScript.GetCodeEdit(sql); if (rs.Read()) { MessageBox.Show(script.GetEmpName(textBox2.Text) + " มีประวัติของแก้ไขงานใน " + script.GetMontThai(DateTime.Now.Date).Split(' ')[1] + " ทั้งหมด " + rs.GetString("num") + " ครั้ง\r\n !!ต้องมีความรอบครอบมากขึ้นกว่านี้^^", "", MessageBoxButtons.OK, MessageBoxIcon.Information); AdminMenuForm adminEdit = new AdminMenuForm(textBox1.Text.Trim()); this.Hide(); adminEdit.ShowDialog(); this.Close(); } // } else { MessageBox.Show("รหัสแก้ไขงานไม่ถูกต้อง", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } else { MessageBox.Show("รหัสรองฯ ไม่ถูกต้อง", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } else { MessageBox.Show("กรุณาใส่เหตุที่ต้องแก้ไข", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void button3_Click(object sender, EventArgs e) { AdminMenuForm adminMenu = new AdminMenuForm(""); adminMenu.ShowDialog(); }