public bool ExportReportProductionFromToNewForm(DateTime from, DateTime To, string Pathsave)
{
try
{
DefectRateReport defectRateReport = new DefectRateReport();
List <DefectRateData> defectRateDatas = new List <DefectRateData>();
defectRateDatas = defectRateReport.GetListDefectRateReportFromTo("B01", "0010", from, To);
if (defectRateDatas.Count == 0)
{
return(false);
}
List <string> listHeaderRW25 = GetListStringHeaderReworkTop25();
MQCExportData mQCExportData = new MQCExportData();
mQCExportData.ExportToTemplateMQCDefectDaily(pathDailyNew, Pathsave, listHeaderRW25, defectRateDatas, from, To);
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "ExportReportProductionDaiLy()", ex.Message);
return(false);
}
}
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 Lb_Lot_Click(object sender, EventArgs e)
{
DefectRateReport defectRateReport = new DefectRateReport();
DateTime date_from = DateTime.Now;
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", mQCItem1.PO);
Class.ToolSupport exportExcel = new Class.ToolSupport();
exportExcel.ExportToTemplateMQCDefectTop16(MQCForm, @"C:\ERP_Temp\MQC_" + mQCItem1.PO + "-" + 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);
}
public bool ExportReportProductionDaiLy(PeriodProduction period, string Pathsave)
{
try
{
DefectRateReport defectRateReport = new DefectRateReport();
List <DefectRateData> defectRateDatas = new List <DefectRateData>();
defectRateDatas = defectRateReport.GetListDefectRateReportAmountOfTimeDaily("B01", "0010", period);
if (defectRateDatas.Count == 0)
{
return(false);
}
Class.ToolSupport exportExcel = new Class.ToolSupport();
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "ExportReportProductionDaiLy()", ex.Message);
return(false);
}
}
public bool ExportReportProductionFromTo(DateTime from, DateTime To, string Pathsave)
{
try
{
DefectRateReport defectRateReport = new DefectRateReport();
List <DefectRateData> defectRateDatas = new List <DefectRateData>();
defectRateDatas = defectRateReport.GetListDefectRateReportFromTo("B01", "0010", from, To);
if (defectRateDatas.Count == 0)
{
return(false);
}
Class.ToolSupport exportExcel = new Class.ToolSupport();
exportExcel.ExportToTemplateMQCDefectDaily(pathDaily, Pathsave, defectRateDatas, from, To);
return(true);
}
catch (Exception ex)
{
SystemLog.Output(SystemLog.MSG_TYPE.Err, "ExportReportProductionDaiLy()", ex.Message);
return(false);
}
}