private bool LoadDsjour()
{
if (dsFormat.Equals("ORIGINAL"))
{
dsjourTable.Columns.Add("Reference", System.Type.GetType("System.String"));
dsjourTable.Columns[0].MaxLength = 20;
dsjourTable.Columns.Add("Description", System.Type.GetType("System.String"));
dsjourTable.Columns[1].MaxLength = 24;
dsjourTable.Columns.Add("Filler", System.Type.GetType("System.String"));
dsjourTable.Columns[2].MaxLength = 1;
dsjourTable.Columns.Add("Cost", System.Type.GetType("System.String"));
dsjourTable.Columns[3].MaxLength = 10;
dsjourTable.Columns[3].Caption = "Decimal";
dsjourTable.Columns.Add("Price", System.Type.GetType("System.String"));
dsjourTable.Columns[4].MaxLength = 10;
dsjourTable.Columns[4].Caption = "Decimal";
dsjourTable.Columns.Add("Machine", System.Type.GetType("System.String"));
dsjourTable.Columns[5].MaxLength = 8;
dsjourTable.Columns.Add("Cell", System.Type.GetType("System.String"));
dsjourTable.Columns[6].MaxLength = 8;
dsjourTable.Columns.Add("Class", System.Type.GetType("System.String"));
dsjourTable.Columns[7].MaxLength = 8;
dsjourTable.Columns.Add("MTD", System.Type.GetType("System.String"));
dsjourTable.Columns[8].MaxLength = 8;
dsjourTable.Columns[8].Caption = "Number";
}
else if (dsFormat.Equals("10"))
{
dsjourTable.Columns.Add("Reference", System.Type.GetType("System.String"));
dsjourTable.Columns[0].MaxLength = 78;
dsjourTable.Columns.Add("Description", System.Type.GetType("System.String"));
dsjourTable.Columns[1].MaxLength = 24;
dsjourTable.Columns.Add("Filler", System.Type.GetType("System.String"));
dsjourTable.Columns[2].MaxLength = 1;
dsjourTable.Columns.Add("Cost", System.Type.GetType("System.String"));
dsjourTable.Columns[3].MaxLength = 10;
dsjourTable.Columns[3].Caption = "Decimal";
dsjourTable.Columns.Add("Price", System.Type.GetType("System.String"));
dsjourTable.Columns[4].MaxLength = 10;
dsjourTable.Columns[4].Caption = "Decimal";
dsjourTable.Columns.Add("Machine", System.Type.GetType("System.String"));
dsjourTable.Columns[5].MaxLength = 8;
dsjourTable.Columns.Add("Cell", System.Type.GetType("System.String"));
dsjourTable.Columns[6].MaxLength = 8;
dsjourTable.Columns.Add("Class", System.Type.GetType("System.String"));
dsjourTable.Columns[7].MaxLength = 8;
dsjourTable.Columns.Add("MTD", System.Type.GetType("System.String"));
dsjourTable.Columns[8].MaxLength = 8;
dsjourTable.Columns[8].Caption = "Number";
}
else
{
return(false);
}
return(DSPrioritiesIO.LoadFile(customerDatabase + "\\" + DSJOUR_FILENAME, ref dsjourTable));
}
private bool LoadExport()
{
int columnCount = 0;
if (dsFormat.Equals("ORIGINAL"))
{
exportTable.Columns.Add("Reference", System.Type.GetType("System.String"));
exportTable.Columns[0].MaxLength = 20;
columnCount++;
}
else if (dsFormat.Equals("10"))
{
exportTable.Columns.Add("Reference", System.Type.GetType("System.String"));
exportTable.Columns[0].MaxLength = 66;
columnCount++;
}
else
{
return(false);
}
exportTable.Columns.Add("MINIMUM_STOCK", System.Type.GetType("System.String"));
exportTable.Columns[columnCount].MaxLength = 8;
exportTable.Columns[columnCount].Caption = "Number";
columnCount++;
for (int i = 0; i < horizon + 1; i++)
{
exportTable.Columns.Add("GRRQMTS_" + i.ToString(), System.Type.GetType("System.String"));
exportTable.Columns[columnCount].MaxLength = 8;
exportTable.Columns[columnCount].Caption = "Number";
columnCount++;
}
for (int i = 0; i < horizon + 1; i++)
{
exportTable.Columns.Add("ENDINV_" + i.ToString(), System.Type.GetType("System.String"));
exportTable.Columns[columnCount].MaxLength = 8;
exportTable.Columns[columnCount].Caption = "Number";
columnCount++;
}
exportTable.Columns.Add("SCHREC_0", System.Type.GetType("System.String"));
exportTable.Columns[columnCount].MaxLength = 8;
exportTable.Columns[columnCount].Caption = "Number";
columnCount++;
return(DSPrioritiesIO.LoadFile(exportDsPrioritiesFileName, ref exportTable));
}
private bool LoadReceipts()
{
if (dsFormat.Equals("ORIGINAL"))
{
receiptsTable.Columns.Add("Reference", System.Type.GetType("System.String"));
receiptsTable.Columns[0].MaxLength = 20;
receiptsTable.Columns.Add("Quantity", System.Type.GetType("System.String"));
receiptsTable.Columns[1].MaxLength = 8;
receiptsTable.Columns[1].Caption = "Number";
receiptsTable.Columns.Add("Filler", System.Type.GetType("System.String"));
receiptsTable.Columns[2].MaxLength = 1;
receiptsTable.Columns.Add("PO_Number", System.Type.GetType("System.String"));
receiptsTable.Columns[3].MaxLength = 9;
receiptsTable.Columns.Add("Description", System.Type.GetType("System.String"));
receiptsTable.Columns[4].MaxLength = 51;
receiptsTable.Columns.Add("Date", System.Type.GetType("System.String"));
receiptsTable.Columns[5].MaxLength = 6;
}
else if (dsFormat.Equals("10"))
{
receiptsTable.Columns.Add("Reference", System.Type.GetType("System.String"));
receiptsTable.Columns[0].MaxLength = 78;
receiptsTable.Columns.Add("Quantity", System.Type.GetType("System.String"));
receiptsTable.Columns[1].MaxLength = 8;
receiptsTable.Columns[1].Caption = "Number";
receiptsTable.Columns.Add("Filler", System.Type.GetType("System.String"));
receiptsTable.Columns[2].MaxLength = 1;
receiptsTable.Columns.Add("PO_Number", System.Type.GetType("System.String"));
receiptsTable.Columns[3].MaxLength = 9;
receiptsTable.Columns.Add("Description", System.Type.GetType("System.String"));
receiptsTable.Columns[4].MaxLength = 51;
receiptsTable.Columns.Add("Date", System.Type.GetType("System.String"));
receiptsTable.Columns[5].MaxLength = 8;
}
else
{
return(false);
}
return(DSPrioritiesIO.LoadFile(customerDatabase + "\\" + RECEIPTS_FILENAME, ref receiptsTable));
}