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)); }
public bool SaveDsPO() { System.Data.DataTable dataTable = new System.Data.DataTable(); dataTable.Columns.Add("Article", System.Type.GetType("System.String")); dataTable.Columns[0].MaxLength = 17; dataTable.Columns.Add("Quantite", System.Type.GetType("System.String")); dataTable.Columns[1].MaxLength = 8; dataTable.Columns.Add("Date", System.Type.GetType("System.String")); dataTable.Columns[2].MaxLength = 8; dataTable.Columns.Add("Code_ABC", System.Type.GetType("System.String")); dataTable.Columns[3].MaxLength = 1; foreach (DataRow row in dsPoTable.Rows) { int dayCount = 0; if (DateTime.Now.DayOfWeek == 0) { dayCount = 6; } else { dayCount = ((int)DateTime.Now.DayOfWeek) - 1; } dayCount = -dayCount; DateTime date = DateTime.Now.AddDays(dayCount); for (int i = 0; i < horizon + 1; i++) { if ((Convert.ToInt32(row[2 + i])) > 0) { DataRow newRow = dataTable.NewRow(); newRow[0] = row[0].ToString(); newRow[1] = row[2 + i].ToString().PadLeft(8, '0'); newRow[2] = date.AddDays(-7).ToString("ddMMyyyy"); newRow[3] = row[1].ToString(); dataTable.Rows.Add(newRow); } date = date.AddDays(7); } } return(DSPrioritiesIO.WriteFile(dsPOFolder + "\\" + PO_RESULT_FILENAME, dataTable)); }
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)); }
public bool LoadDsPO() { int columnCount = 0; dsPoTable.Columns.Add("Reference", System.Type.GetType("System.String")); columnCount++; dsPoTable.Columns.Add("ABC", System.Type.GetType("System.String")); columnCount++; for (int i = 0; i < horizon + 1; i++) { dsPoTable.Columns.Add("PO_" + i.ToString(), System.Type.GetType("System.String")); dsPoTable.Columns[columnCount].Caption = "Number"; columnCount++; } return(DSPrioritiesIO.LoadTabFile(exportDsPOFileName, ref dsPoTable)); }
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)); }
private bool SaveDsPriorities() { System.Data.DataTable dataTable = new System.Data.DataTable(); dataTable.Columns.Add("OF", System.Type.GetType("System.String")); dataTable.Columns[0].MaxLength = 7; dataTable.Columns.Add("Priorité", System.Type.GetType("System.String")); dataTable.Columns[1].MaxLength = 2; foreach (DataGridViewRow row in dgvReceipts.Rows) { if (Convert.ToBoolean(row.Cells[0].Value)) { DataRow newRow = dataTable.NewRow(); newRow[0] = row.Cells[1].Value.ToString().PadLeft(7, '0'); newRow[1] = row.Cells[2].Value.ToString().PadLeft(2, '0'); dataTable.Rows.Add(newRow); } } return(DSPrioritiesIO.WriteFile(dsPrioritiesFolder + "\\" + PRIORITIES_RESULT_FILENAME, dataTable)); }