Exemplo n.º 1
0
        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));
        }
Exemplo n.º 2
0
        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));
        }