private void button2_Click(object sender, EventArgs e)
{
AdminScript adminScript = new AdminScript();
string sql_query = "SELECT tbl_emp_id, tbl_emp_name, (SELECT COUNT(*) FROM `tbl_code_edit` WHERE `tbl_code_user_emp` = e.`tbl_emp_id` AND MONTH(tbl_code_date) = '" + date_start.Value.Month + "' AND YEAR(tbl_code_date) = '" + date_start.Value.Year + "') AS amount , `tbl_code_date`,tbl_cpoint_id,tbl_cpoint_name,tbl_code_note FROM `tbl_code_edit` LEFT JOIN `tbl_emp` e ON `tbl_code_user_emp` = tbl_emp_id LEFT JOIN `tbl_cpoint` ON `tbl_cpoint_id` = `tbl_code_cpoint` WHERE `tbl_code_status` IS NOT NULL AND MONTH(tbl_code_date) = '" + date_start.Value.Month + "' AND YEAR(tbl_code_date) = '" + date_start.Value.Year + "' ORDER BY tbl_cpoint_id,DATE_FORMAT(tbl_code_date,'%d-%m-%Y'),tbl_code_user_emp";
MySqlDataAdapter adap = new MySqlDataAdapter();
MySqlConnection conn = new MySqlConnection(adminScript.strCon);
MySqlCommand cmd = new MySqlCommand();;
DataSet_Report dataSet1 = new DataSet_Report();
PopupReport popup = new PopupReport();
string nameCpoint = script.GetCpoint(File.ReadAllText(script.file_cpoint).Split('|')[0]);
popup.Text = "รายงานการขอแก้ไขงาน ระบบ TIS";
cmd.Connection = conn;
conn.Close();
conn.Open();
cmd.CommandText = sql_query;
adap.SelectCommand = cmd;
dataSet1.Clear();
adap.Fill(dataSet1, "report_EditJob");
conn.Close();
EditJob editJob = new EditJob();
editJob.SetDataSource(dataSet1);
/*DefectiveStrapsReport defectiveStraps = new DefectiveStrapsReport();
* defectiveStraps.SetDataSource(dataSet1);
* defectiveStraps.SetParameterValue("para_cpoint", nameCpoint);*/
popup.cry_View.ReportSource = editJob;
popup.Show();
}
