public EditStrapsForm(Form callingForm, string bag, string emp, string emp_con, TextBox straps) { moneyForm = callingForm as SendMoneyForm; txt_straps_call = straps as TextBox; bag_num = bag; emp_operate = emp; emp_contorl = emp_con; InitializeComponent(); }
private void next() { bool chk_back_money = false; string sql = "SELECT * FROM tbl_income JOIN tbl_emp ON tbl_income_emp_id = tbl_emp_id WHERE tbl_emp_id = '" + textBox1.Text + "' AND tbl_income_status_backmaney = '0'"; ConnectDB contxt = new ConnectDB(); MySqlConnection conn = new MySqlConnection(); conn = new MySqlConnection(contxt.context()); MySqlCommand cmd = new MySqlCommand(sql, conn); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); try { if (reader.Read()) { BackMoneyForm backMoneyForm = new BackMoneyForm(mainForm, textBox1.Text); this.Close(); backMoneyForm.ShowDialog(); } else { chk_back_money = true; } reader.Close(); if (chk_back_money) { sql = "SELECT * FROM tbl_income JOIN tbl_emp ON tbl_income_emp_id = tbl_emp_id WHERE tbl_emp_id = '" + textBox1.Text + "' AND tbl_income_status_backmaney = '1' AND tbl_income_bank IS NULL"; cmd = new MySqlCommand(sql, conn); reader = cmd.ExecuteReader(); if (reader.Read()) { //MessageBox.Show("คืนเงินแล้ว"); SendMoneyForm sendMoneyForm = new SendMoneyForm(mainForm, textBox1.Text); sendMoneyForm.ShowDialog(); this.Close(); } else { MessageBox.Show("ไม่พบข้อมูล หรืออาจจะนำส่งรายได้ไปแล้ว", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); textBox1.Clear(); textBox1.Focus(); } } } catch { //MessageBox.Show(e.ToString()); } conn.Close(); }