Beispiel #1
0
        public formBaseMark()//string TabEnc, string TabLin
        {
            InitializeComponent();
            try
            {
                //oTabEnc = TabEnc;
                //oTabLin = TabLin;



                textBoxButtonFecReg.Text = DateTime.Now.ToString("dd/MM/yyyy");
                textBoxButtonFecVen.Text = DateTime.Now.ToString("dd/MM/yyyy");
                textBoxButtonFecDoc.Text = DateTime.Now.ToString("dd/MM/yyyy");

                /*consiciones de pago*/
                DataTable dt = Conexion.Ejecutar_dt("SELECT * FROM CONPAG");
                comboBoxConPag.DisplayMember = "Descri";
                comboBoxConPag.ValueMember   = "CodCon";
                comboBoxConPag.DataSource    = dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                ElogFormBase.save(this, ex);
            }



            //Data grid
        }
Beispiel #2
0
        // Valida celdas
        private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
        {
            try
            {
                //Valida que las celdas de codigo y nombre de articulo queden vacias

                if (dataGridView1.Columns[e.ColumnIndex].Index == 1)
                {
                    /*
                     *                  if (String.IsNullOrEmpty(dataGridView1.Rows[e.RowIndex].Cells[0].FormattedValue.ToString()) && String.IsNullOrEmpty(e.FormattedValue.ToString()))
                     *                  {
                     *                          e.Cancel = true;
                     *                          dataGridView1.Rows[e.RowIndex].ErrorText = "Insertar valor";
                     *
                     *                  }
                     */
                }
                //validar cantidad numerico y mayor que 0
                if (dataGridView1.Columns[e.ColumnIndex].Index == 2)
                {
                    Double newInteger;
                    if (!double.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger <= 0)
                    {
                        e.Cancel = true;

                        dataGridView1.Rows[e.RowIndex].ErrorText = "the value must be a non-negative integer";
                    }
                }
                // validar precio
                if (dataGridView1.Columns[e.ColumnIndex].Index == 3)
                {
                    Double newInteger;
                    if (!double.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger <= 0)
                    {
                        e.Cancel = true;
                        dataGridView1.Rows[e.RowIndex].ErrorText = "the value must be a non-negative integer";
                    }
                }
                //validar precio bruto
                if (dataGridView1.Columns[e.ColumnIndex].Index == 4)
                {
                    Double newInteger;
                    if (!double.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger <= 0)
                    {
                        e.Cancel = true;
                        dataGridView1.Rows[e.RowIndex].ErrorText = "the value must be a non-negative integer";
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                ElogFormBase.save(this, ex);
            }
        }
Beispiel #3
0
 private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)
 {
     try
     {
         if (dataGridView1.CurrentCell.ColumnIndex == 0 || dataGridView1.CurrentCell.ColumnIndex == 1)
         {
             if (textBoxButtonCodCli.Text == "")
             {
                 textBoxButtonCodCli.Focus();
                 MessageBox.Show("Ingresar Codigo de SN");
             }
             else
             {
                 dataGridView1.BeginEdit(true);
             }
         }
     }
     catch (Exception ex)
     {
         //MessageBox.Show(ex.Message);
         ElogFormBase.save(this, ex);
     }
 }
Beispiel #4
0
        private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                switch (dataGridView1.Columns[e.ColumnIndex].Index)
                {
                case 0:

                    if (dataGridView1.CurrentRow.Cells[0].Value != null)
                    {
                        // Busqueda de Articulo por codigo
                        DataSet ds0 = ds_Art(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());

                        if (ds0.Tables[0].Rows.Count == 1)
                        {
                            dataGridView1.Rows[e.RowIndex].Cells[2].Value = 1.ToString("N2");                                     //cantidad
                            dataGridView1.Rows[e.RowIndex].Cells[1].Value = ds0.Tables[0].Rows[0].ItemArray[1].ToString();        //nombre
                            dataGridView1.Rows[e.RowIndex].Cells[4].Value = ds0.Tables[0].Rows[0].ItemArray[2].ToString();        //precio bruto
                            dataGridView1.Rows[e.RowIndex].Cells[6].Value = ds0.Tables[0].Rows[0].ItemArray[4].ToString();        // unidad de medida

                            // Consulta Ultimo presio atendido al mismo cliente
                            DataSet ds1 = ds_UltiPrec(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), textBoxButtonCodCli.Text.Trim());
                            if (ds1.Tables[0].Rows.Count >= 1)
                            {
                                dataGridView1.Rows[e.RowIndex].Cells[4].Value = ds1.Tables[0].Rows[0].ItemArray[0].ToString();
                                dataGridView1.Rows[e.RowIndex].Cells[3].Value = CalcPrecUni(ds1.Tables[0].Rows[0].ItemArray[0].ToString()).ToString("N4");
                            }
                            else
                            {
                                dataGridView1.Rows[e.RowIndex].Cells[3].Value = 0.ToString("N4");
                                dataGridView1.Rows[e.RowIndex].Cells[4].Value = 0.ToString("N2");
                            }

                            //total de las lineas
                            dataGridView1.Rows[e.RowIndex].Cells[7].Value = TotLin(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
                            dataGridView1.Rows[e.RowIndex].Cells[8].Value = TotLin(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());
                            dataGridView1.Rows[e.RowIndex].Cells[8].Value = TotImpLine(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());

                            SumaTotales();
                        }
                        else
                        {
                            MessageBox.Show("Codigo no existe");
                        }
                    }
                    break;

                case 1:
                    if (dataGridView1.CurrentRow.Cells[1].Value != null)
                    {
                        DataSet ds = ds_ArtDes(dataGridView1.CurrentRow.Cells[1].Value.ToString());

                        if (ds.Tables[0].Rows.Count == 1)
                        {
                            dataGridView1.Rows[e.RowIndex].Cells[2].Value = 1.ToString("N2");
                            dataGridView1.Rows[e.RowIndex].Cells[1].Value = ds.Tables[0].Rows[0].ItemArray[1].ToString();
                            dataGridView1.Rows[e.RowIndex].Cells[4].Value = ds.Tables[0].Rows[0].ItemArray[2].ToString();
                            dataGridView1.Rows[e.RowIndex].Cells[6].Value = ds.Tables[0].Rows[0].ItemArray[4].ToString();

                            // Consulta Ultimo presio atendido al mismo cliente
                            DataSet ds1 = ds_UltiPrec(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), textBoxButtonCodCli.Text.Trim());
                            if (ds1.Tables[0].Rows.Count >= 1)
                            {
                                dataGridView1.Rows[e.RowIndex].Cells[4].Value = ds1.Tables[0].Rows[0].ItemArray[0].ToString();
                                dataGridView1.Rows[e.RowIndex].Cells[3].Value = CalcPrecUni(ds1.Tables[0].Rows[0].ItemArray[0].ToString()).ToString("N4");
                            }
                            else
                            {
                                dataGridView1.Rows[e.RowIndex].Cells[3].Value = 0.ToString("N4");
                                dataGridView1.Rows[e.RowIndex].Cells[4].Value = 0.ToString("N2");
                            }

                            //total de las lineas
                            dataGridView1.Rows[e.RowIndex].Cells[7].Value = TotLin(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
                            dataGridView1.Rows[e.RowIndex].Cells[8].Value = TotLin(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());
                            dataGridView1.Rows[e.RowIndex].Cells[8].Value = TotImpLine(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString(), dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());
                            SumaTotales();
                        }
                    }
                    break;

                case 2:

                    oCantid = double.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());
                    oPreUni = double.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
                    if (oPreUni >= 0)
                    {
                        oImpu   = (oCantid * oPreUni) * 0.18;
                        oPreBru = oPreUni * 1.18;
                        oTotal  = oCantid * oPreUni;
                        oTotBru = oCantid * oPreBru;
                        //
                        dataGridView1.Rows[e.RowIndex].Cells[4].Value = oPreBru.ToString("N2");
                        dataGridView1.Rows[e.RowIndex].Cells[7].Value = oTotal.ToString("N2");
                        dataGridView1.Rows[e.RowIndex].Cells[8].Value = oTotBru.ToString("N2");
                        dataGridView1.Rows[e.RowIndex].Cells[9].Value = oImpu.ToString("N2");
                        //
                        dataGridView1.Rows[e.RowIndex].Cells[2].Value = oCantid.ToString("N2");
                        //
                        SumaTotales();
                    }
                    else
                    {
                        MessageBox.Show("INGRESAR PRECIO DE ARTICULO");
                    }


                    break;

                case 3:

                    oCantid = double.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());
                    oPreUni = double.Parse(dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString());
                    if (oPreUni >= 0)
                    {
                        oImpu   = (oCantid * oPreUni) * 0.18;
                        oPreBru = oPreUni * 1.18;
                        oTotal  = oCantid * oPreUni;
                        oTotBru = oCantid * oPreBru;
                        //
                        dataGridView1.Rows[e.RowIndex].Cells[4].Value = oPreBru.ToString("N2");
                        dataGridView1.Rows[e.RowIndex].Cells[7].Value = oTotal.ToString("N2");
                        dataGridView1.Rows[e.RowIndex].Cells[8].Value = oTotBru.ToString("N2");
                        dataGridView1.Rows[e.RowIndex].Cells[9].Value = oImpu.ToString("N2");

                        //
                        dataGridView1.Rows[e.RowIndex].Cells[3].Value = oPreUni.ToString("N2");
                        //
                        SumaTotales();
                    }
                    else
                    {
                        MessageBox.Show("INGRESAR PRECIO DE ARTICULO");
                    }


                    break;

                case 4:                         //precio bruto

                    oCantid = double.Parse(dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString());
                    oPreBru = double.Parse(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());

                    oPreUni = oPreBru / 1.18;
                    oTotal  = oCantid * oPreUni;
                    oTotBru = oCantid * oPreBru;

                    oImpu = oTotBru - oTotal;
                    //
                    dataGridView1.Rows[e.RowIndex].Cells[3].Value = oPreUni.ToString("N2");
                    dataGridView1.Rows[e.RowIndex].Cells[7].Value = oTotal.ToString("N2");
                    dataGridView1.Rows[e.RowIndex].Cells[8].Value = oTotBru.ToString("N2");
                    dataGridView1.Rows[e.RowIndex].Cells[9].Value = oImpu.ToString("N2");
                    //
                    dataGridView1.Rows[e.RowIndex].Cells[4].Value = oPreBru.ToString("N2");
                    //
                    SumaTotales();
                    break;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                ElogFormBase.save(this, ex);
            }
        }