private void Button1_Click(object sender, EventArgs e) { DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); DateTime date_to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30, 0, 0, 0); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReport(date_from, date_to, "B01", "0010"); Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplateMQCDefect(pathMonth, @"C:\ERP_Temp\Temp2" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); // exportExcel.ExportToTemplateMQCDefect(@"D:\AN\Report\Template\Testy.xlsx", @"C:\ERP_Temp\Temp2" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); }
private void Btn_Summary_Click(object sender, EventArgs e) { // LoadDataSummary loadDataSummary = new LoadDataSummary(); //List<MQCItemSummary> itemSummaries = loadDataSummary.GetMQCItemSummaries(dateTimeFrom, dateTimeTo, dept, process); // SummaryWindow summary = new SummaryWindow(itemSummaries); // summary.Show(); DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0); DateTime date_to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 30, 0, 0, 0); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReport(date_from, date_to, "B01", "0010"); Class.ToolSupport exportExcel = new Class.ToolSupport(); exportExcel.ExportToTemplateMQCDefect(pathMonth, @"C:\ERP_Temp\MQC_Report" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); }