private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Split('-').Length == 2)
{
string sql = "SELECT * FROM tbl_income i JOIN tbl_status_around a ON i.tbl_income_around_id = a.tbl_status_around_id WHERE tbl_income_id = '" + textBox1.Text.Split('-')[1].Trim() + "' limit 1";
cpoint = textBox1.Text.Split('-')[0];
MySqlDataReader rs = script.Select_SQL(sql, script.getConn(cpoint, groupbox1));
GetData(rs);
}
else
{
MessageBox.Show("รูปแบบไม่ถูกต้อง", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button2_Click(object sender, EventArgs e)
{
string sql = "SELECT * FROM tbl_income JOIN tbl_emp ON tbl_income_emp_id=tbl_emp_id WHERE tbl_income_around_id IS NULL";
//MessageBox.Show(txtCpoint.SelectedItem.ToString());
if (codeEdit == "")
{
cpoint = (txtCpoint.SelectedItem as ComboboxItem).Value.ToString();
}
MySqlDataReader rs = adminScript.Select_SQL(sql, adminScript.getConn(cpoint, groupBox1));
ListBoxEmp.Items.Clear();
int i = 0;
while (rs.Read())
{
ListBoxEmp.Items.Insert(i, new ComboboxItem("ถุงเงิน : " + rs.GetString("tbl_income_money_bag") + " ชื่อ-สกุล : " + rs.GetString("tbl_emp_name"), rs.GetString("tbl_income_id")));
i++;
}
rs.Close();
adminScript.CloseCon();
button1.Enabled = true;
ListBoxEmp.Enabled = true;
}
private void button3_Click(object sender, EventArgs e)
{
if (MessageBox.Show("ยืนยันที่จะส่งข้อมูลไปที่ด่านฯ?", "ยืนยัน?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string data = "";
string name = "";
MySqlDataReader rs = script.Select_SQL("SELECT * FROM tbl_cpoint where tbl_cpoint_status = '0' order by tbl_cpoint_id");
int i = 1;
while (rs.Read())
{
if (i == 1)
{
data += rs.GetString("tbl_cpoint_id");
name += rs.GetString("tbl_cpoint_name");
}
else
{
data += "," + rs.GetString("tbl_cpoint_id");
name += "," + rs.GetString("tbl_cpoint_name");
}
i++;
}
rs.Close();
script.conn.Close();
string sql = "UPDATE tbl_emp SET tbl_emp_name = '" + textBox2.Text.Trim() + "',tbl_emp_group_id='" + (comboBox1.SelectedItem as ComboboxItem).Value.ToString() + "' WHERE tbl_emp_id = '" + label3.Text.Trim() + "'";
string[] cpoint = data.Split(',');
string[] cpointName = name.Split(',');
for (i = 0; i < cpoint.Length; i++)
{
MySqlConnection conn = script.getConn(cpoint[i]);
if (script.InsertUpdae_SQL(sql, conn))
{
MessageBox.Show("ส่งข้อมูลไปด่านฯ " + cpointName[i] + " สำเร็จ", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("!!!Error : ส่งข้อมูลไปด่านฯ " + cpointName[i] + " ล้มเหลว กรุณาตรวสอบกานเชื่อมต่อ", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conn.Close();
}
}
}
public void Export(string sql_para)
{
string sql = sql_para;
string data_text = "";
string name = "";
MySqlDataReader rs = adminScript.Select_SQL("SELECT * FROM tbl_cpoint where tbl_cpoint_status = '0' order by tbl_cpoint_id");
int i = 1;
while (rs.Read())
{
if (i == 1)
{
data_text += rs.GetString("tbl_cpoint_id");
name += rs.GetString("tbl_cpoint_name");
}
else
{
data_text += "," + rs.GetString("tbl_cpoint_id");
name += "," + rs.GetString("tbl_cpoint_name");
}
i++;
}
rs.Close();
script.conn.Close();
string[] cpoint = data_text.Split(',');
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "xls files (*.xls)|*.xls|All files (*.*)|*.*";
saveFileDialog1.RestoreDirectory = true;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
for (i = 0; i < cpoint.Length; i++)
{
MySqlConnection connection = adminScript.getConn(cpoint[i]);
try
{
MySqlDataAdapter data = adminScript.Select_SQLDataAdapter(sql, connection);
DataTable dat = new DataTable("Execl");
DataSet da = new DataSet();
data.Fill(da);
data.Fill(dat);
DateTime date = DateTime.Now;
//dat.WriteXml(saveFileDialog1.FileName.Split('.')[0] + "_" + cpoint[i] + ".xls");
string folderPath = saveFileDialog1.FileName.Split('.')[0] + "_";
using (XLWorkbook wb = new XLWorkbook())
{
wb.Worksheets.Add(da);
wb.SaveAs(folderPath + dateTimePicker1.Value.ToString("ddMMMyyyy") + "-" + dateTimePicker2.Value.ToString("ddMMMyyyy") + "_" + name.Split(',')[i] + ".xlsx");
}
//MessageBox.Show("export ข้อมูลด่านฯ " + name.Split(',')[i]+" สำเร็จ");
}
catch
{
MessageBox.Show("!!!Error : export ข้อมูลด่านฯ " + name.Split(',')[i] + " ล้มเหลว มีปัญหาการเชื่อมต่อ", "ผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
MessageBox.Show("export สำเร็จ");
}
}
