public DPSFile LoadFile(string fileName, string plant, DateTime currentDay)
{
Filename = fileName;
Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
DPSFile ms = new DPSFile(fileName, plant);
ms.IsCurrentDay(currentDay);
using (var stream = File.Open(fileName, FileMode.Open, FileAccess.Read)) {
using (var reader = ExcelReaderFactory.CreateReader(stream)) {
var result = reader.AsDataSet(new ExcelDataSetConfiguration()
{
ConfigureDataTable = (data) => new ExcelDataTableConfiguration()
{
UseHeaderRow = true
}
});
DataTableCollection table = result.Tables;
DataTable currentMonthSheet = table[0];
LoadProductionRecords(currentMonthSheet, ms, currentDay);
return(ms);
}
}
}
