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 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);
}
}
