private void ChargedForm_Load(object sender, EventArgs e)
{
string sql = "SELECT * FROM tbl_around ";
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();
cb_around.Text = "เลือก";
while (reader.Read())
{
cb_around.Items.Add("ผลัด " + reader.GetString("tbl_around_id") + " (" + reader.GetString("tbl_around_time") + ")");
}
conn.Close();
/*CultureInfo _cultureEnInfo = new CultureInfo("en-US");
* DateTime dateEng = Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy"), _cultureEnInfo);
*
* dpk_date.Text = dateEng.ToString("dd/MM/yyyy", _cultureEnInfo);*/
dpk_date.CustomFormat = "dd-MM-yyyy";
dpk_date1.CustomFormat = "dd-MM-yyyy";
string sql_check = "SELECT * FROM tbl_incom_other WHERE tbl_incom_other_list_incom_id = '4' AND tbl_incom_other_date_send = SUBSTR(DATE_FORMAT( NOW(), '%d-%m-%Y' ),1,10)";
MySqlDataReader rs = script.Select_SQL(sql_check);
if (rs.Read())
{
rs.Close();
}
else
{
sql_check = "SELECT * FROM tbl_status_around WHERE tbl_status_around_close = '0' AND tbl_status_around_cpoint_id = '" + mainForm.cpoint_id + "'";
rs = script.Select_SQL(sql_check);
if (rs.Read())
{
//txt_straps.Text = script.GetStraps(rs.GetString("tbl_status_around_emp_open_id"));
}
else
{
MessageBox.Show("รองผู้จัดการด่านยังไม่ได้ทำการเปิดกะ ยังไม่สามารถนำส่งเงินรายได้ ได้ในขณะนี้", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
this.Close();
}
}
if (tabControl1.SelectedTab == tabPage1)
{
txt_t1_1.Text = "ส่งเงินรายได้ขาดระบบ ตามบันทึกที่ ";
lb_title.Text = tabPage1.Text;
lb_date.Text = "";
lb_line1.Text = txt_t1_1.Text + txt_rs.Text;
txt_t1_1.ReadOnly = true;
//txt_note.Enabled = false;
}
}
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();
}
private void txt_job_SelectedIndexChanged(object sender, EventArgs e)
{
//MessageBox.Show((txt_job.SelectedItem as ComboboxItem).Value.ToString());
ClearData();
data = cb_emp_name.SelectedItem.ToString().Split(':');
string sql = "SELECT * FROM tbl_income JOIN tbl_status_around ON tbl_income_around_id = tbl_status_around_id WHERE (tbl_income_user <> '0' OR tbl_income_fine <> '0') AND tbl_income_emp_id = '" + data[0].Trim() + "' AND tbl_status_around_aid = '" + cb_around.Text + "' AND tbl_income_job = '" + txt_job.Text + "' AND tbl_status_around_date = '" + date_value.Text + "'";
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())
{
if (!reader.IsDBNull(10))//10 = tbl_income_user
{
user = reader.GetString("tbl_income_user");
}
else
{
user = "******";
}
if (!reader.IsDBNull(11))// 11 = tbl_income_fine
{
fine = reader.GetString("tbl_income_fine");
}
else
{
fine = "0";
}
rdo_user.Enabled = Int32.Parse(user) > 0 ? true : false;
rdo_fine.Enabled = Int32.Parse(fine) > 0 ? true : false;
lb_user.Text = "( มีเงินในระบบ : " + user + " บาท )";
lb_fine.Text = "( มีเงินในระบบ : " + fine + " บาท )";
lb_user.Visible = true;
lb_fine.Visible = true;
}
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
conn.Close();
}
private void GetEmp()
{
ClearData();
if (cb_around.Text != "เลือก")
{
cb_emp_name.Items.Clear();
string date_select = date_value.Text;
string sql = "SELECT * FROM tbl_income JOIN tbl_emp ON tbl_income_emp_id = tbl_emp_id JOIN tbl_status_around ON tbl_income_around_id = tbl_status_around_id WHERE (tbl_income_user <> '0' OR tbl_income_fine <> '0') AND tbl_status_around_date = '" + date_select + "' AND tbl_status_around_aid = '" + cb_around.Text + "' AND tbl_status_around_cpoint_id = '" + mainForm.cpoint_id + "'";
//MessageBox.Show(sql);
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
{
//cb_emp_name.SelectedIndex = 0;
int i = 0;
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
if (i == 0)
{
cb_emp_name.Text = "เลือกพนักงานที่ทำรายการ";
//txt_job.Text = "เลือกงาน";
}
cb_emp_name.Items.Add(reader.GetString("tbl_emp_id") + " : " + reader.GetString("tbl_emp_name"));
//txt_job.Items.Add(reader.GetString("tbl_income_job"));
cb_emp_name.Enabled = true;
//txt_job.Enabled = true;
}
i++;
}
if (i == 0)
{
cb_emp_name.Items.Clear();
cb_emp_name.Enabled = false;
}
reader.Close();
}
catch
{
}
conn.Close();
}
}
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 AroundOpenForm(string emp, Form callingForm, string cpoint)
{
maniForm = callingForm as MenuForm;
InitializeComponent();
cpoint_id = cpoint;
emp_id = emp;
ConnectDB contxt = new ConnectDB();
MySqlConnection conn = new MySqlConnection();
conn = new MySqlConnection(contxt.context());
string sql = "SELECT * FROM tbl_emp e JOIN tbl_emp_group g ON e.tbl_emp_group_id = g.tbl_emp_group_id WHERE tbl_emp_id = '" + emp_id + "'";
MySqlCommand cmd = new MySqlCommand(sql, conn);
//MessageBox.Show(sql);
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
try
{
if (reader.Read())
{
if (!reader.IsDBNull(0))
{
txt_emp_name.Text = reader.GetString("tbl_emp_name");
txt_emp_name.BackColor = DefaultBackColor;
txt_emp_name.ForeColor = Color.Blue;
lb_group.Text = reader.GetString("tbl_emp_group_name");
lb_group.BackColor = DefaultBackColor;
lb_group.ForeColor = Color.Blue;
}
}
reader.Close();
}
catch
{
}
conn.Close();
//txt_emp.Text = data[0]+" "+data[1]+" "+data[2]+" "+data[3];
}
private void next()
{
//MessageBox.Show("คืนเงิน");
if (txt_fine.Text == "")
{
txt_fine.Text = "0.00";
}
if (double.Parse(txt_fine.Text) % 140 != 0)
{
MessageBox.Show("จำนวนเงินค่าปรับบัตรไม่ถูกต้อง", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txt_fine.Clear();
txt_fine.Focus();
}
else
{
if (MessageBox.Show("คืนเงินยืม\r\n" + txt_emp_id.Text + " " + txt_emp_name.Text + "\r\n- จำนวน " + txt_money.Text + " บาท \r\n- เงินผู้ใช้ทางไม่รับเงินทอน " + txt_chang.Text + " บาท \r\n- ค่าปรับบัตรหาย " + txt_fine.Text + " บาท \r\n----------------------\r\nยืนยัน ใช่ หรือ ไม่", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
ConnectDB contxt = new ConnectDB();
MySqlConnection conn = new MySqlConnection();
conn = new MySqlConnection(contxt.context());
conn.Open();
MySqlCommand comm = conn.CreateCommand();
try
{
comm.CommandText = "UPDATE tbl_income SET tbl_income_user = '******' ,tbl_income_fine = '" + double.Parse(txt_fine.Text) + "' ,tbl_income_status_backmaney = '1' WHERE tbl_income_emp_id = '" + txt_emp_id.Text + "' AND tbl_income_status_backmaney = '0' AND tbl_income_money_bag = '" + txt_bag.Text + "'";
comm.ExecuteNonQuery();
conn.Close();
MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
mainForm.Enabled = true;
this.Close();
}
catch
{
//
}
}
}
}
private void txt_emp_id_KeyUp(object sender, KeyEventArgs e)
{
string sql = "SELECT * FROM tbl_emp WHERE tbl_emp_id = '" + txt_emp_id.Text + "'";
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();
if (reader.Read())
{
txt_emp_name.Text = reader.GetString("tbl_emp_name");
lb_line3.Text = "เรียกเก็บจาก " + txt_emp_name.Text;
}
else
{
txt_emp_name.Text = "ไม่พบข้อมูล";
//lb_line3.Text = "" + txt_note.Text;
}
}
private void BackMoneyForm_Load(object sender, EventArgs e)
{
if (mainForm.line9 == "9")
{
label10.Visible = false;
txt_fine.Visible = false;
label9.Visible = false;
}
string sql = "SELECT * FROM tbl_income JOIN tbl_emp ON tbl_income_emp_id = tbl_emp_id WHERE tbl_emp_id = '" + emp_id + "' 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())
{
txt_emp_id.Text = emp_id;
txt_emp_name.Text = reader.GetString("tbl_emp_name");
txt_bag.Text = reader.GetString("tbl_income_money_bag");
txt_money.Text = String.Format("{0:N2}", double.Parse(reader.GetString("tbl_income_money")));
button2.Enabled = true;
}
reader.Close();
}
catch
{
//MessageBox.Show(e.ToString());
}
}
public void MenuForm_Load(object sender, EventArgs e)
{
label2.Text = "ฝ่ายบริหารการจัดเก็บเงินค่าธรรมเนียม กองทางหลวงพิเศษระหว่างเมือง\r\n";
label2.Text += "Application : " + Application.ProductName;
label2.Text += "\r\nVersion : " + Application.ProductVersion;
script.Set_Max_Connection();
FileInfo DirInfo = new FileInfo(script.file_conf);
if (!DirInfo.Exists)
{
MessageBox.Show("ไม่พบการเชื่อมต่อฐานข้อมูล กรุณา 'ตั้งค่า' ", "ผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
//server=localhost;database=testDB;uid=root;pwd=abc123;
//this.Close();
btn_around.Enabled = false;
btn_bag.Enabled = false;
btn_send.Enabled = false;
btn_edit.Enabled = false;
button1.Enabled = false;
btn_refund.Enabled = false;
btn_memo.Enabled = false;
btn_report.Enabled = false;
btn_setting.Enabled = true;
button2.Enabled = false;
button3.Enabled = false;
}
else
{
try
{
/*FileInfo DirInfo1 = new FileInfo(script.file_around);
* if (!DirInfo1.Exists)
* {
* btn_around.Image = Properties.Resources.success;
* btn_around.Text = "เปิดกะ";
* aroundStatus = true;
* }
* else
* {
* btn_around.Image = Properties.Resources.error;
* btn_around.Text = "ปิดกะ";
* aroundStatus = false;
* }*/
FileInfo DirInfo2 = new FileInfo(script.file_cpoint);
FileInfo DirInfo3 = new FileInfo(script.file_Straps);
bool cpoint_file = false;
if (DirInfo2.Exists && DirInfo3.Exists)
{
cpoint_file = true;
string[] cpoint = File.ReadAllText(@script.file_cpoint).Split('|');
string sql = "SELECT * FROM tbl_cpoint WHERE tbl_cpoint_id = '" + cpoint[0] + "'";
ConnectDB contxt = new ConnectDB();
MySqlConnection conn = new MySqlConnection();
conn = new MySqlConnection(contxt.context());
MySqlCommand cmd = new MySqlCommand(sql, conn);
//conn.Close();
conn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
try
{
if (reader.Read())
{
if (!reader.IsDBNull(0))
{
line9 = File.ReadAllText(script.file_cpoint).Split('|')[3];
lb_cpoint.Text = cpoint[0] + " ด่าน" + reader.GetString("tbl_cpoint_name") + " " + (line9 != "9" ? cpoint[1] : "") + " ";
cpoint_id = cpoint[0];
sub_cpoint = cpoint[1];
lb_time.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
groupBox1.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
lb_cpoint.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
group_around.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
lb_emp_name.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
label_date.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
lb_group.ForeColor = ColorTranslator.FromHtml(reader.GetString("tbl_cpoint_color"));
}
}
else
{
lb_cpoint.Text = "ไม่พบข้อมูลด่าน";
btn_around.Enabled = false;
}
reader.Close();
}
catch
{
}
conn.Close();
}
else
{
btn_around.Enabled = false;
btn_bag.Enabled = false;
btn_send.Enabled = false;
btn_edit.Enabled = false;
btn_report.Enabled = false;
btn_refund.Enabled = false;
btn_memo.Enabled = false;
button1.Enabled = false;
button2.Enabled = false;
button3.Enabled = false;
btn_setting.Enabled = false;
}
if (cpoint_file)
{
if (File.ReadAllText(@script.file_cpoint).Split('|')[2] != "1")
{
/*if (aroundStatus)
* {
* btn_bag.Enabled = false;
* btn_send.Enabled = false;
* btn_edit.Enabled = false;
* button1.Enabled = false;
* group_around.Visible = false;
* button2.Enabled = false;
* button3.Enabled = false;
* btn_report.Enabled = false;
* }
* else
* {*/
Script script = new Script();
try
{
string[] around = File.ReadAllText(script.file_around).Split('|');
around_num = around[1];
//string emp_control = script.Select_SQL();
emp_control_id = around[0];
}
catch { }
//around_num = around[1];
string sql = "SELECT * FROM tbl_status_around JOIN tbl_emp e ON tbl_status_around_emp_open_id = tbl_emp_id JOIN tbl_emp_group g ON e.tbl_emp_group_id = g.tbl_emp_group_id WHERE tbl_status_around_close = '0' AND tbl_status_around_cpoint_id = '" + cpoint_id + "' AND tbl_status_around_cpoint_sub_id = '" + sub_cpoint + "'";
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())
{
if (!reader.IsDBNull(0))
{
label_date.Text = script.GetMontThai(script.DateTimeParse(reader.GetString("tbl_status_around_date")));
lb_emp_name.Text = reader.GetString("tbl_emp_name");
label_date.Text += " " + script.GetAroundName(reader.GetString("tbl_status_around_aid"));
lb_group.Text = reader.GetString("tbl_emp_group_name");
around = int.Parse(reader.GetString("tbl_status_around_aid"));
//string[] aid = File.ReadAllText(@"around.txt").Split('|');
string sql_check_straps = "SELECT * FROM `tbl_income` JOIN `tbl_status_around` ON `tbl_income_around_id` = `tbl_status_around_id` JOIN `tbl_emp` ON `tbl_emp_id` = `tbl_income_emp_id` WHERE tbl_status_around_close = '0' AND tbl_status_around_cpoint_id = '" + cpoint_id + "' AND tbl_status_around_cpoint_sub_id = '" + sub_cpoint + "'";
cmd = new MySqlCommand(sql_check_straps, conn);
reader.Close();
reader = cmd.ExecuteReader();
if (reader.Read())
{
btn_send.Enabled = true;
sql_check_straps = "SELECT * FROM `tbl_income` JOIN `tbl_status_around` ON `tbl_income_around_id` = `tbl_status_around_id` JOIN `tbl_emp` ON `tbl_emp_id` = `tbl_income_emp_id` WHERE tbl_status_around_close = '0' AND tbl_status_around_cpoint_id = '" + cpoint_id + "' AND tbl_status_around_cpoint_sub_id = '" + sub_cpoint + "' AND tbl_income_bank IS NOT NULL AND tbl_income_status_backmaney ='1' ORDER BY tbl_income_id DESC ";
reader.Close();
reader = script.Select_SQL(sql_check_straps);
if (reader.Read())
{
button2.Enabled = true;
btn_edit.Enabled = true;
}
else
{
button2.Enabled = false;
btn_edit.Enabled = false;
}
}
else
{
button2.Enabled = false;
btn_send.Enabled = false;
btn_edit.Enabled = false;
}
conn.Close();
group_around.Visible = true;
btn_around.Image = Resources.error;
btn_around.Text = "ปิดกะ";
aroundStatus = false;
if (around == 2)
{
button1.Enabled = true;
}
else
{
button1.Enabled = false;
}
}
}
else
{
//lb_cpoint.Text = "ไม่พบข้อมูลด่าน";
group_around.Visible = false;
btn_around.Image = Resources.success;
btn_around.Text = "เปิดกะ";
aroundStatus = true;
btn_around.Enabled = true;
btn_bag.Enabled = false;
btn_send.Enabled = false;
btn_edit.Enabled = false;
btn_report.Enabled = false;
btn_refund.Enabled = false;
btn_memo.Enabled = false;
button1.Enabled = false;
button2.Enabled = false;
button3.Enabled = false;
btn_setting.Enabled = false;
}
}
catch
{
}
conn.Close();
// }
//button1.Enabled = false;
}
else
{
btn_around.Enabled = false;
btn_bag.Enabled = false;
btn_send.Enabled = false;
btn_edit.Enabled = false;
btn_report.Enabled = true;
btn_refund.Enabled = false;
btn_memo.Enabled = false;
button1.Enabled = true;
button2.Enabled = false;
button3.Enabled = false;
btn_setting.Enabled = false;
}
}
}
catch
{
MessageBox.Show("มีปัญหาการเชื่อมต่อฐานข้อมูล กรุุณาปิด/เปิดโปรแกรมใหม่ " + e.ToString(), "ผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
//MessageBox.Show("Error:" + err.ToString(), "", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
}
private void InsertAround()
{
if (script.AddCheckStraps(txt_straps_start.Text))
{
ConnectDB contxt = new ConnectDB();
MySqlConnection conn = new MySqlConnection();
conn = new MySqlConnection(contxt.context());
int aid = 0;
if (rb_2.Checked)
{
//MessageBox.Show("2");
aid = 2;
}
if (rb_3.Checked)
{
//MessageBox.Show("3");
aid = 3;
}
if (rb_1.Checked)
{
//MessageBox.Show("1");
aid = 1;
}
conn.Open();
DateTime date_send = new Script().GetDateAround();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = "INSERT INTO tbl_status_around (tbl_status_around_aid,tbl_status_around_emp_open_id,tbl_status_around_close,tbl_status_around_date,tbl_status_around_cpoint_id,tbl_status_around_cpoint_sub_id) VALUES(@aid, @emp_id,'0',@date,@cpoint,@subcpoint)";
comm.Parameters.Add("@aid", aid);
comm.Parameters.Add("@emp_id", emp_id);
comm.Parameters.Add("@date", date_send.ToString("dd-MM-yyyy"));
comm.Parameters.Add("@cpoint", cpoint_id);
comm.Parameters.Add("@subcpoint", maniForm.sub_cpoint);
comm.ExecuteNonQuery();
conn.Close();
StreamWriter file = new StreamWriter(script.file_around);
file.WriteLine(emp_id + "|" + aid + "|" + date_send.ToString("dd-MM-yyyy") + "|" + txt_straps_start.Text + "|");
file.Close();
FileInfo DirInfo2 = new FileInfo(filename);
if (DirInfo2.Exists)
{
string[] data1 = File.ReadAllText(new Script().file_around).Split('|');
Script script = new Script();
string status_around_id = "";
MySqlDataReader rs = script.Select_SQL("SELECT * FROM tbl_status_around WHERE `tbl_status_around_aid`='" + data1[1] + "' AND `tbl_status_around_emp_open_id`='" + data1[0] + "' AND `tbl_status_around_close` = '0'");
if (rs.Read())
{
status_around_id = rs.GetString("tbl_status_around_id");
string[] data = File.ReadAllLines(filename);
foreach (string line in data)
{
string[] line_data = line.Split('|');
script.InsertUpdae_SQL("UPDATE tbl_income SET tbl_income_around_id = '" + status_around_id + "' WHERE tbl_income_emp_id='" + line_data[0] + "' AND tbl_income_around_id IS NULL AND tbl_income_money_bag = '" + line_data[1] + "'");
}
File.Delete(filename);
}
rs.Close();
script.conn.Close();
}
//maniForm.Refresh();
Application.Restart();
}
}
private void next()
{
ConnectDB contxt = new ConnectDB();
MySqlConnection conn = new MySqlConnection();
conn = new MySqlConnection(contxt.context());
MySqlCommand comm = conn.CreateCommand();
bool check = false;
string sql_check_emp = "SELECT tbl_emp_id 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)";
comm = new MySqlCommand(sql_check_emp, conn);
conn.Open();
MySqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
check = true;
}
else
{
MessageBox.Show("รหัสไม่ถูกต้อง หรือไม่มีสิทธิ์ทำรายการ", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
conn.Close();
if (check)
{
string sql_insert = "INSERT INTO tbl_refun (tbl_refun_job,tbl_refun_transaction,tbl_refun_amount,tbl_refun_emp,tbl_refun_note,tbl_refun_date) VALUES ('" + (refunForm.txt_job.SelectedItem as ComboboxItem).Value.ToString() + "','" + (refunForm.rdo_fine.Checked ? "ค่าปรับบัตรหาย" : "เงินทอน") + "','" + (refunForm.rdo_fine.Checked ? refunForm.txt_fine.Text : refunForm.txt_user.Text) + "','" + txt_emp_id.Text + "','" + refunForm.txt_note.Text + "',NOW())";
conn.Open();
comm.CommandText = sql_insert;
if (comm.ExecuteNonQuery() > 0)
{
check = true;
}
else
{
check = false;
}
conn.Close();
if (check)
{
if (refunForm.rdo_fine.Checked == true)
{
if (refunForm.txt_fine.Text != "")
{
if (Int32.Parse(refunForm.txt_fine.Text) <= Int32.Parse(refunForm.fine))
{
conn.Open();
string sql = "UPDATE tbl_income SET tbl_income_fine = '" + (Int32.Parse(refunForm.fine) - Int32.Parse(refunForm.txt_fine.Text)) + "' WHERE tbl_income_id = '" + (refunForm.txt_job.SelectedItem as ComboboxItem).Value.ToString() + "'";
comm.CommandText = sql;
comm.ExecuteNonQuery();
MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "ผลลัพธ์", MessageBoxButtons.OK, MessageBoxIcon.Information);
conn.Close();
mainForm.Enabled = true;
refunForm.Close();
this.Close();
}
else
{
MessageBox.Show("ยอดเงินที่คืนผู้ใช้ทางมากกว่าเงินในระบบ " + (Int32.Parse(refunForm.txt_fine.Text) - Int32.Parse(refunForm.fine)) + " บาท", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
if (refunForm.rdo_user.Checked == true)
{
if (refunForm.txt_user.Text != "")
{
if (Int32.Parse(refunForm.txt_user.Text) <= Int32.Parse(refunForm.user))
{
conn.Open();
string sql = "UPDATE tbl_income SET tbl_income_user = '******' WHERE tbl_income_id = '" + (refunForm.txt_job.SelectedItem as ComboboxItem).Value.ToString() + "'";
comm.CommandText = sql;
comm.ExecuteNonQuery();
MessageBox.Show("บันทึกข้อมูลเรียบร้อย", "ผลลัพธ์", MessageBoxButtons.OK, MessageBoxIcon.Information);
conn.Close();
refunForm.Close();
mainForm.Enabled = true;
this.Close();
}
else
{
MessageBox.Show("ยอดเงินที่คืนผู้ใช้ทางมากกว่าเงินในระบบ " + (Int32.Parse(refunForm.txt_user.Text) - Int32.Parse(refunForm.user)) + " บาท", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
}
}
}
