public void ExportReportProduction() { string startTime = ""; string Startdate = ""; string endTime = ""; string endDate = ""; string lot = ""; string fileRead = ""; var ishaveFile = iSHaveFileDone(ref startTime, ref Startdate, ref endTime, ref endDate, ref lot, ref fileRead); if (ishaveFile) { try { Thread.Sleep(10000); DateTime StartDate = DateTime.Parse(Startdate).Date; DateTime EndDate = DateTime.Parse(endDate).Date; TimeSpan timeStart = TimeSpan.Parse(startTime); TimeSpan timeEnd = TimeSpan.Parse(endTime); DefectRateData defectRateData = new DefectRateData(); DefectRateReport defectRateReport = new DefectRateReport(); defectRateData = defectRateReport.GetDefectRateReportByLot(StartDate, timeStart, EndDate, timeEnd, "B01", "0010", lot); if (defectRateData.TotalQuantity > 0) { Log.ExportExcelTool exportExcel = new Log.ExportExcelTool(); checkFolderSaveProduction(true); exportExcel.ExportToTemplateMQCDefectTop16(MQCForm, pathSaveProduction + DateTime.Now.ToString("yyyy-MM-dd") + "\\" + "MQC_" + lot + "" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); } if (File.Exists(fileRead)) { File.Move(fileRead, PathDoneMoving + new FileInfo(fileRead).Name); } } catch (Exception ex) { Logfile.Output(StatusLog.Normal, "ExportReportProduction()", ex.Message); if (File.Exists(fileRead)) { // string temp = PathErrorFiles + new FileInfo(fileRead).Name; File.Move(fileRead, PathErrorFiles + new FileInfo(fileRead).Name); } } } }
public bool ExportReportProductionWeekly() { try { DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = Class.DateTimeControl.StartOfWeek(DayOfWeek.Monday); DateTime date_to = DateTime.Today.AddDays(-(int)DateTime.Today.DayOfWeek + 7); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReportAmountOfTime(date_from, date_to, "B01", "0010"); if (defectRateData.TotalQuantity == 0) { return(false); } Log.ExportExcelTool exportExcel = new Log.ExportExcelTool(); exportExcel.ExportToTemplateMQCDefectAmountOfTime(date_from, date_to, pathMonth, @"C:\ERP_Temp\MQC_Weekly_Report" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); return(true); } catch (Exception ex) { Logfile.Output(StatusLog.Error, "ExportReportProductionDaiLy()", ex.Message); return(false); } }
public bool ExportReportProductionDaiLy(PeriodProduction period) { try { DefectRateReport defectRateReport = new DefectRateReport(); List <DefectRateData> defectRateDatas = new List <DefectRateData>(); defectRateDatas = defectRateReport.GetListDefectRateReportAmountOfTimeDaily("B01", "0010", period); if (defectRateDatas.Count == 0) { return(false); } Log.ExportExcelTool exportExcel = new Log.ExportExcelTool(); exportExcel.ExportToTemplateMQCDefectDaily(pathDaily, @"C:\ERP_Temp\MQC_Daily_Report" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateDatas); return(true); } catch (Exception ex) { Logfile.Output(StatusLog.Error, "ExportReportProductionDaiLy()", ex.Message); return(false); } }
public bool ExportReportProductionMonthly() { try { DefectRateReport defectRateReport = new DefectRateReport(); DateTime date_from = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime date_to = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month)); DefectRateData defectRateData = new DefectRateData(); defectRateData = defectRateReport.GetDefectRateReportAmountOfTime(date_from, date_to, "B01", "0010"); if (defectRateData.TotalQuantity == 0) { return(false); } Log.ExportExcelTool exportExcel = new Log.ExportExcelTool(); exportExcel.ExportToTemplateMQCDefectAmountOfTime(date_from, date_to, pathMonth, @"C:\ERP_Temp\MQC_Monthly_Report" + "-" + DateTime.Now.ToString("yyyyMMdd hhmmss") + ".xlsx", defectRateData); return(true); } catch (Exception ex) { Logfile.Output(StatusLog.Error, "ExportReportProductionDaiLy()", ex.Message); return(false); } }