示例#1
0
 private void cbVariables_CheckedChanged(object sender, EventArgs e)
 {
     gbVariables.Enabled = cbVariables.Checked;
     Herramientas.Limpiar(gbVariables);
     if (cbVariables.Checked)
     {
         this.Height = 718;
     }
     else
     {
         this.Height = 524;
     }
 }
示例#2
0
        public static void truncarDataGrid(DataGridView dataGridView, int ordenTruncado)
        {
            Herramientas h = new Herramientas();

            for (int i = 0; i < dataGridView.Rows.Count; i++)
            {
                for (int j = 0; j < dataGridView.Columns.Count; j++)
                {
                    if (dataGridView.Rows[i].Cells[j].Value is Double)
                    {
                        dataGridView.Rows[i].Cells[j].Value = h.TruncadoMarcelo(Convert.ToDouble(dataGridView.Rows[i].Cells[j].Value), 4);
                    }
                }
            }
        }
示例#3
0
        private void btnF_Click(object sender, EventArgs e)
        {
            dataTablaBase.Rows.Clear();


            GeneradorTabla generador = new GeneradorTabla();
            Herramientas   h         = new Herramientas();

            double[,] matriz;

            h.valoresInexistentes(this, gbVariables);


            //Variables auxiliares
            int cantidadDias         = Convert.ToInt32(txtCantidadDia.Text);
            int cantidadSimulaciones = Convert.ToInt32(txtSimulaciones.Text);

            double acumulada     = 0;
            double acumuladaProm = 0;

            double reserva = Convert.ToInt32(txtReserva.Text);

            //TODOS LAS FUNCIONES MATRIZ = GENERAR.TABLABASE tienen el valor booleano invertido
            for (int j = 0; j < cantidadSimulaciones; j++)
            {
                if (cbVariables.Checked)
                {
                    //If para ver si se trabaja con numeros aleatorios o los fijos
                    if (cbNumerosAleatorios.Checked)
                    {
                        if (cbDiaAnterior.Checked)
                        {
                            for (int i = 0; i < cantidadDias; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva),
                                                              Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
                                                              cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);

                                reserva   = matriz[0, 4];
                                acumulada = matriz[0, 7];
                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1)
                                {
                                    dataTablaBase.Rows.Add();

                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                            reserva   = Convert.ToDouble(txtReserva.Text);
                        }
                        else
                        {
                            for (int i = 0; i < cantidadDias; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva),
                                                              Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
                                                              cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);

                                acumulada = matriz[0, 7];
                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1)
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                        }
                    }
                    else
                    {
                        if (cbDiaAnterior.Checked)
                        {
                            for (int i = 0; i < 20; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva),
                                                              Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
                                                              cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);

                                reserva   = matriz[0, 4];
                                acumulada = matriz[0, 7];

                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                            reserva   = Convert.ToDouble(txtReserva.Text);
                        }
                        else
                        {
                            for (int i = 0; i < 20; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva),
                                                              Convert.ToDouble(txtPrecioVenta.Text), Convert.ToDouble(txtPrecioVentaCementerio.Text), Convert.ToDouble(txtPrecioCompra.Text), Convert.ToDouble(txtPrecioCompraFaltantes.Text),
                                                              cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);

                                //reserva = matriz[0, 2];
                                acumulada = matriz[0, 7];

                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                            //reserva = Convert.ToDouble(txtReserva.Text);
                        }
                    }
                }
                //Variables False
                else
                {
                    if (cbNumerosAleatorios.Checked)
                    {
                        if (cbDiaAnterior.Checked)
                        {
                            for (int i = 0; i < cantidadDias; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);

                                reserva   = matriz[0, 4];
                                acumulada = matriz[0, 7];
                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1)
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                            reserva   = Convert.ToDouble(txtReserva.Text);
                        }
                        else
                        {
                            //ACA
                            for (int i = 0; i < cantidadDias; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, false, acumulada);

                                //reserva = matriz[0, 2];
                                acumulada = matriz[0, 7];
                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == (Convert.ToInt32(txtCantidadDia.Text)) - 1) //MODIFIQUE ESTE
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                        }
                    }
                    //Aleatorios False
                    else
                    {
                        if (cbDiaAnterior.Checked)
                        {
                            for (int i = 0; i < 20; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);

                                reserva   = matriz[0, 4];
                                acumulada = matriz[0, 7];
                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)//CAMBIO 2
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                            reserva   = Convert.ToDouble(txtReserva.Text);
                        }
                        else
                        {
                            for (int i = 0; i < 20; i++)
                            {
                                matriz = generador.tablaBase1(Convert.ToInt32(reserva), 12, 1.2, 8, 11, cbDiaAnterior.Checked, cbPuedeComprar.Checked, i, true, acumulada);

                                //reserva = matriz[0, 2];
                                acumulada = matriz[0, 7];
                                if ((i >= Convert.ToInt32(txtDesde.Text) && i < Convert.ToInt32(txtHasta.Text)) || i == 20 - 1)
                                {
                                    dataTablaBase.Rows.Add();
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[0].Value = matriz[0, 0];
                                    //Rnd Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[1].Value = matriz[0, 1];
                                    //Clima
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[2].Value = h.setearTipoDia(matriz[0, 2]);
                                    //Rnd Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[3].Value = matriz[0, 3];
                                    //Demanda
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[4].Value = matriz[0, 4];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[5].Value = matriz[0, 5];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[6].Value = matriz[0, 6];
                                    dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = matriz[0, 7];
                                }
                            }

                            dataTablaBase.Rows.Add();
                            h.formatearDataGridTexto(dataTablaBase);
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].Cells[7].Value = Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value) / Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[0].Value);
                            dataTablaBase.Rows.Add();
                            dataTablaBase.Rows[dataTablaBase.Rows.Count - 1].DefaultCellStyle.BackColor = Color.Black;
                            acumuladaProm += Convert.ToDouble(dataTablaBase.Rows[dataTablaBase.Rows.Count - 2].Cells[7].Value);

                            acumulada = 0;
                        }
                    }
                }
                Console.WriteLine("Simulacion F finalizada");
            }

            txtPromedioGanancia.Text = h.TruncadoMarcelo((acumuladaProm / Convert.ToDouble(txtSimulaciones.Text)), 4).ToString();

            Herramientas.truncarDataGrid(dataTablaBase, 4);
        }