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