Example #1
0
 void CambiarComprobante()
 {
     clsComp.OpenDB();
     datos = clsComp.ObtenerComprobantes(CloudContable.Info[0], FechaInicioD.Value.ToString("yyyy-MM-dd"), FechaFinD.Value.ToString("yyyy-MM-dd"), NFlecha, TipoComprobanteC.SelectedItem.ToString(), 0);
     Data1.Rows.Clear();
     clsComp.ObtenerComprobanteDetalle(datos[0], Data1);
     clsComp.CloseDB();
     NComprobanteT.Text = datos[2];
     if (datos[3] == "Diario")
     {
         TipoAsientoC.SelectedIndex = 0;
     }
     else if (datos[3] == "Ingreso")
     {
         TipoAsientoC.SelectedIndex = 1;
     }
     else if (datos[3] == "Egreso")
     {
         TipoAsientoC.SelectedIndex = 2;
     }
     RazonSocialT.Text       = datos[4];
     GlosaT.Text             = datos[5];
     NChequeT.Text           = datos[6];
     FechaComprobanteD.Value = Convert.ToDateTime(datos[7]);
     USDT.Text = datos[8];
     UFVT.Text = datos[9];
     ClsPublic.SumarDebeHaberComprobante(Data1, TDebeT, THaberT);
 }
Example #2
0
        private void Data1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            TextBox autoText = e.Control as TextBox;

            autoText.AutoCompleteMode   = AutoCompleteMode.Suggest;
            autoText.AutoCompleteSource = AutoCompleteSource.CustomSource;
            if (Data1.CurrentCell.ColumnIndex == 0)
            {
                if (autoText != null)
                {
                    autoText.AutoCompleteCustomSource = ClsPublic.CargatAutoCompleteCodigo();
                }
            }
            else if (Data1.CurrentCell.ColumnIndex == 1)
            {
                if (autoText != null)
                {
                    autoText.AutoCompleteCustomSource = ClsPublic.CargatAutoCompleteCuenta();
                }
            }
            else
            {
                autoText.AutoCompleteCustomSource = null;
            }
        }
Example #3
0
 private void Data1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
 {
     if (Data1.Rows[Data1.CurrentCell.RowIndex].Cells[0].Value == null)
     {
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[0].Value = "";
     }
     if (Data1.Rows[Data1.CurrentCell.RowIndex].Cells[1].Value == null)
     {
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[1].Value = "";
     }
     if (Data1.Columns[e.ColumnIndex].Index == 0)
     {
         string[] Data = ClsPublic.ObtenerDataPlanCuentaAutoComplete(Data1.Rows[Data1.CurrentCell.RowIndex].Cells[0].Value.ToString());
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[0].Value = Data[0];
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[1].Value = Data[1];
     }
     else if (Data1.Columns[e.ColumnIndex].Index == 1)
     {
         string[] Data = ClsPublic.ObtenerDataPlanCuentaAutoComplete(Data1.Rows[Data1.CurrentCell.RowIndex].Cells[1].Value.ToString());
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[0].Value = Data[0];
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[1].Value = Data[1];
     }
     else if (Data1.Columns[e.ColumnIndex].Index == 3)
     {
         try
         {
             Data1.Rows[Data1.CurrentCell.RowIndex].Cells[3].Value = Convert.ToDouble(Data1.Rows[Data1.CurrentCell.RowIndex].Cells[3].Value);
         }
         catch (FormatException)
         {
             Data1.Rows[Data1.CurrentCell.RowIndex].Cells[3].Value = 0.00;
         }
     }
     else if (Data1.Columns[e.ColumnIndex].Index == 4)
     {
         try
         {
             Data1.Rows[Data1.CurrentCell.RowIndex].Cells[4].Value = Convert.ToDouble(Data1.Rows[Data1.CurrentCell.RowIndex].Cells[4].Value);
         }
         catch (FormatException)
         {
             Data1.Rows[Data1.CurrentCell.RowIndex].Cells[4].Value = 0.00;
         }
     }
     if (Data1.Rows[Data1.CurrentCell.RowIndex].Cells[2].Value == null)
     {
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[2].Value = GlosaT.Text;
     }
     if (Data1.Rows[Data1.CurrentCell.RowIndex].Cells[3].Value == null)
     {
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[3].Value = 0.00;
     }
     if (Data1.Rows[Data1.CurrentCell.RowIndex].Cells[4].Value == null)
     {
         Data1.Rows[Data1.CurrentCell.RowIndex].Cells[4].Value = 0.00;
     }
     //ClsPublic.LimpiarDataGridSinCodigo(Data1);
     ClsPublic.SumarDebeHaberComprobante(Data1, TotalDebeT, TotalHaberT, DiferenciaL);
 }
Example #4
0
        public static void CargarForm(object formulario)
        {
            ClsPublic.Ocultar(ContenidoC);
            ContenidoC.Controls.Clear();
            Control fh = formulario as Control;

            ContenidoC.Controls.Add(fh);
            ClsPublic.Animar(ContenidoC);
        }
Example #5
0
        public static void AgregarC(Control cont)
        {
            ClsPublic.Ocultar(ContenidoC);
            Control fh = cont as Control;

            ContenidoC.Controls.Add(fh);
            int i = ContenidoC.Controls.Count;

            ContenidoC.Controls[0].Visible = false;
            ClsPublic.Animar(ContenidoC);
        }
Example #6
0
        public static void CargarC(Control cont)
        {
            ClsPublic.Ocultar(ContenidoC);
            ContenidoC.Controls.Clear();
            Control fh = cont as Control;

            ContenidoC.Controls.Add(fh);
            ClsPublic.Animar(ContenidoC);
            //ContenidoC.Controls.Clear();
            //ContenidoC.Controls.Add(cont);
        }
 public void ObtenerComprobanteDetalle(string idcomprobante, DataGridView data)
 {
     if (conexion.State == ConnectionState.Open)
     {
         MySqlDataAdapter tabla;
         DataTable        datatable = new DataTable();
         string           comando   = "CALL obtenerComprobantesDetalle({0})";
         string           cmd       = string.Format(comando, idcomprobante);
         tabla = new MySqlDataAdapter(cmd, conexion);
         tabla.Fill(datatable);
         foreach (DataRow dtRow in datatable.Rows)
         {
             data.Rows.Add(dtRow[2], ClsPublic.ObtenerNombreCuenta(dtRow[2].ToString()), dtRow[3], Convert.ToDouble(dtRow[4]).ToString("N2"), Convert.ToDouble(dtRow[5]).ToString("N2"));
         }
     }
     else
     {
         MessageBox.Show("No existe Conexión", "Cloud Contable");
     }
 }
Example #8
0
 private void CancelarB_Click(object sender, EventArgs e)
 {
     ClsPublic.LimpiarDataGridSinCodigo(Data1);
     if (TotalDebeT.Text == TotalHaberT.Text && Data1.RowCount > 1)
     {
         clsComp.OpenDB();
         if (!clsComp.ObtenerNComprobante(CloudContable.Info[0]).Equals(NComprobanteT.Text))
         {
             MessageBox.Show("El Número de Comprobante Se ha Actualizado");
         }
         clsComp.RegistrarComprobante(Data1, CloudContable.Info[0], CloudContable.Info[1], clsComp.ObtenerNComprobante(CloudContable.Info[0]), TipoComprobanteC.SelectedItem.ToString(), RazonSocialT.Text, GlosaT.Text, NChequeT.Text, FechaComprobanteD.Value.ToString("yyyy-MM-dd"), TasaUSDT.Text, TasaUFVT.Text);
         NComprobanteT.Text = clsComp.ObtenerNComprobante(CloudContable.Info[0]);
         clsComp.CloseDB();
         Clear();
     }
     else
     {
         MessageBox.Show("No se Puede Registrar el Asiento\n-Revise los totales\n-Revise que la cantidad de cuentas utilizadas", "Cloud Contable");
     }
 }