private void button1_Click(object sender, EventArgs e) { if (txt_name.Text != "" && txt_home_num.Text != "" && txt_moo.Text != "" && txt_soi.Text != "" && txt_rd.Text != "" && txt_subdis.Text != "" && txt_dis.Text != "" && combo_province.Text != "" && txt_mobile.Text != "" && txt_id_card.Text != "" && txt_user_issuer.Text != "" && txt_plate.Text != "" && combo_province1.Text != "" && txt_brand.Text != "" && txt_color.Text != "" && txt_cb.Text != "" && txt_amount.Text != "" && txt_type.Text != "") { if (button1.Text == "บันทึก") { button1.Text = "ยืนยัน"; groupBox1.Enabled = false; groupBox2.Enabled = false; button2.Visible = true; } else { if (MessageBox.Show("ยืนยันข้อมุลถูกต้อง ใช่ หรือ ไม่", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { GetEmpConfirmForm getEmp = new GetEmpConfirmForm(); getEmp.ShowDialog(); if (getEmp.checkValue) { string emp_id = getEmp.emp_id; string cpoint = File.ReadAllText(script.file_cpoint).Split('|')[0]; string col = "`memo_id_list_id`,`memo_name_cus`,`memo_home_no`,`memo_moo`,`memo_soi`,`memo_rd`,`memo_subdis`,`memo_dis`,`memo_province_add`,`memo_tel`,memo_mobile,`memo_id_card`,`memo_card_no`,`memo_card_issuer`,`memo_card_is_date`,`memo_card_ex_date`,`memo_cpoint_id`,`memo_date`,`memo_time`,`memo_cabinet`,`memo_type_id`,`memo_license_plate`,`memo_province_plate`,`memo_brand`,`memo_color`,`mome_note`,`memo_emp_id`,memo_amount,`memo_fine_amount`,`memo_drive_id`,memo_type"; string value = "'5','" + txt_name.Text + "','" + txt_home_num.Text + "','" + txt_moo.Text + "','" + txt_soi.Text + "','" + txt_rd.Text + "','" + txt_subdis.Text + "','" + txt_dis.Text + "','" + combo_province.Text.Trim() + "','" + txt_tel.Text + "','" + txt_mobile.Text + "','" + txt_id_card.Text.Trim() + "','" + txt_card_num.Text.Trim() + "','" + txt_user_issuer.Text + "','" + card_is_date.Text + "','" + card_ex_date.Text + "','" + cpoint + "','" + date_memo.Text + "','" + time_memo.Text + "','" + txt_cb.Text + "','" + combo_type_car.Text + "','" + txt_plate.Text + "','" + combo_province1.Text.Trim() + "','" + txt_brand.Text + "','" + txt_color.Text + "','" + txt_note.Text.Trim() + "','" + emp_id + "','" + txt_amount.Text.Trim() + "','" + txt_fine_amount.Text.Trim() + "','" + txt_drive_id.Text.Trim() + "','" + txt_type.Text + "'"; string sql_insert = "INSERT INTO `tbl_memo` (" + col + ") VALUE (" + value + ")"; if (script.InsertUpdae_SQL(sql_insert)) { MessageBox.Show("บันทึกข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information); script.GetReportTollNotPay(date_memo.Value, txt_id_card.Text.Trim(), txt_card_num.Text.Trim()); this.Close(); } else { MessageBox.Show("Error : ผิดผลาด", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } else { MessageBox.Show("ใส่ข้อมูลให้ครบถ้วน", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void button1_Click(object sender, EventArgs e) { if (txt_id_card.Text != "" && txt_name.Text != "ไม่พบข้อมูล" && txt_bill.Text != "" && txt_bill_no.Text != "") { if (button1.Text == "บันทึก") { button1.Text = "ยืนยัน"; groupBox2.Enabled = false; groupBox1.Enabled = false; button2.Visible = true; } else { if (MessageBox.Show("ยืนยันข้อมุลถูกต้อง ใช่ หรือ ไม่", "", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { GetEmpConfirmForm getEmp = new GetEmpConfirmForm(); getEmp.ShowDialog(); if (getEmp.checkValue) { string emp_id = getEmp.emp_id; string update = "UPDATE `tbl_memo` SET `memo_amount`='" + txt_total.Text.Trim() + "',`memo_status`='1',`memo_bill_book`='" + txt_bill.Text.Trim() + "',`memo_bill_no`='" + txt_bill_no.Text.Trim() + "',`memo_date_payment`='" + date_pay.Value.ToString("dd-MM-yyyy") + "',`memo_emp_id_payment`='" + emp_id + "' WHERE `memo_id` = '" + lb_memo_id.Text.Trim() + "' AND `memo_status` IS NULL"; if (script.InsertUpdae_SQL(update)) { MessageBox.Show("บันทึกข้อมูลสำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { MessageBox.Show("Error : ผิดผลาด", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } else { MessageBox.Show("ใส่ข้อมูลให้ครบถ้วน", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }