private void next()
{
if (txt_emp_id.Text != "")
{
string emp_id = null;
string sql = "SELECT * FROM tbl_emp WHERE tbl_emp_id = '" + txt_emp_id.Text + "' AND (tbl_emp_group_id=3 OR tbl_emp_group_id=7 OR tbl_emp_group_id=4 OR tbl_emp_group_id=10 OR tbl_emp_group_id=11 OR tbl_emp_group_id > 10)";
ConnectDB contxt = new ConnectDB();
MySqlConnection conn = new MySqlConnection();
conn = new MySqlConnection(contxt.context());
MySqlCommand cmd = new MySqlCommand(sql, conn);
//MessageBox.Show(sql);
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
try
{
if (reader.Read())
{
if (!reader.IsDBNull(0))
{
emp_id = reader.GetString("tbl_emp_id");
AroundOpenForm form = new AroundOpenForm(emp_id, mainForm, cpoint_id);
form.ShowDialog();
this.Close();
}
}
else
{
MessageBox.Show("ไม่พบรหัส : " + txt_emp_id.Text + " ในระบบ หรือรหัสนี้ไม่มีสิทธ์เปิดกะ", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_emp_id.Clear();
txt_emp_id.Focus();
}
reader.Close();
}
catch
{
//MessageBox.Show(e.ToString());
}
conn.Close();
}
else
{
MessageBox.Show("กรุณาใส่รหัสูผ้เปิดผลัด", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public FineAndUser30DayForm(Form callForm, Form callFormOpen)
{
mainForm = callForm as MenuForm;
openForm = callFormOpen as AroundOpenForm;
InitializeComponent();
}