private void Button1_Click_2(object sender, EventArgs e) { MQC.MQCReport mQCReport = new MQCReport(); string start = ""; string end = ""; string lot = ""; mQCReport.ExportReportProduction(); //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.GetDefectRateReportByLot(date_from, date_to, "B01", "0010",""); //Log.ExportExcelTool exportExcel = new Log.ExportExcelTool(); //exportExcel.ExportToTemplateMQCDefectTop16(MQCForm, @"C:\ERP_Temp\MQC_" + "" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); }
void bg_DoWork(object sender, DoWorkEventArgs e) { // does a job like writing to serial communication, webservices etc var worker = sender as BackgroundWorker; //foreach (var item in listReport) //{ // if(item.ReportName == "BackLogReport" && item.AttachedFolder != "") // { // if (cb_Backlog2Excel.Checked) // { // ExportDataBackLogToExcel(item.ReportName, int.Parse(item.Hours)-1); // } // } //} // Export to excel two MQCReport mQCReport = new MQCReport(); mQCReport.ExportReportProduction(); // System.Diagnostics.Debug.WriteLine("run !"); System.Threading.Thread.Sleep(100); }