Ejemplo n.º 1
0
        private void GetCuentaContable(string cuentaNo = "")
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            //Vamos a Buscar el Producto
            frm.titulo         = @"CUENTAS CONTABLES";
            frm.TablaOVista    = "TCONTA_CATALOGO";
            frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsControl = 0 And EsMovimiento = 1";
            frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


            col             = new WinControl_ELR_NET.MyColumna();
            col.NombreCampo = "Cuenta_Contable";
            col.HeaderText  = "Cuenta Contable";
            col.Ancho       = 140;
            frm.columnas[0] = col;

            col             = new WinControl_ELR_NET.MyColumna();
            col.NombreCampo = "Descripcion";
            col.HeaderText  = "Descripcion";
            col.Ancho       = -1;
            frm.columnas[1] = col;

            frm.ShowDialog();

            if (frm.FilaSelecionada != null)
            {
                txtCuentaContable.Text = objUtil.GetAsString("Cuenta_Contable", frm.FilaSelecionada);
            }
        }
Ejemplo n.º 2
0
        public override void HandleCellKeyDown(object sender, KeyEventArgs e)
        {
            //base.HandleCellKeyDown(sender, e);
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            try
            {
                if (COLUMNA_ACTUAL_GRID_DETALLE == "PRODUCTO_ID")
                {
                    if (e.KeyCode == Keys.F9)
                    {
                        //Vamos a Buscar el Producto
                        frm.titulo      = @"PRODUCTOS Y\O SERVICIOS PARA COMPRA";
                        frm.TablaOVista = "VCATEGORIA_PRODUCTOS";
                        frm.columnas    = new WinControl_ELR_NET.MyColumna[2];


                        col             = new WinControl_ELR_NET.MyColumna();
                        col.NombreCampo = "Producto_Id";
                        col.HeaderText  = "Codigo";
                        col.Ancho       = 120;
                        frm.columnas[0] = col;

                        col             = new WinControl_ELR_NET.MyColumna();
                        col.NombreCampo = "Nombre_Corto";
                        col.HeaderText  = "Nombre";
                        col.Ancho       = -1;
                        frm.columnas[1] = col;

                        frm.ShowDialog();

                        if (frm.FilaSelecionada != null)
                        {
                            drProducto = frm.FilaSelecionada;
                            //Mandamos el Focus a la columna Cantidad
                            DataGridDetalle.CurrentCell = DataGridDetalle["Cantidad", DataGridDetalle.CurrentRow.Index];
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
            finally
            {
                frm.Dispose();
            }
        }
Ejemplo n.º 3
0
        private void GetCuentaContable(string cuentaNo = "")
        {
            string cuentaContable = "";

            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            //Vamos a Buscar la Cuenta Contable
            try
            {
                frm.titulo         = @"CUENTAS CONTABLES";
                frm.TablaOVista    = "TCONTA_CATALOGO";
                frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsControl = 0";
                frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                col                        = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo            = "Cuenta_Contable";
                col.HeaderText             = "Cuenta Contable";
                col.Ancho                  = 140;
                frm.columnas[0]            = col;
                frm.DefaultColumnaBusqueda = "Cuenta_Contable";

                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Descripcion";
                col.HeaderText  = "Descripcion";
                col.Ancho       = -1;
                frm.columnas[1] = col;

                frm.ShowDialog();

                if (frm.FilaSelecionada != null)
                {
                    cuentaContable         = objUtil.GetAsString("Cuenta_Contable", frm.FilaSelecionada);
                    txtCuentaContable.Text = cuentaContable;
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
            finally
            {
                this.Cursor = Cursors.Default;
                frm.Dispose();
            }
        }
        private void GetCuentaContable(string cuentaNo = "")
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            try
            {
                //Vamos a Buscar el Producto
                frm.titulo          = @"CUENTAS CONTABLES";
                frm.TablaOVista     = "TCONTA_CATALOGO";
                frm.FiltroEstatico  = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsControl = 0 And EsMovimiento = 1 ";
                frm.FiltroEstatico += " And SUBSTRING(Cuenta_Contable, 1, 1) In ('5', '6' ) ";
                frm.columnas        = new WinControl_ELR_NET.MyColumna[2];


                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Cuenta_Contable";
                col.HeaderText  = "Cuenta Contable";
                col.Ancho       = 140;
                frm.columnas[0] = col;

                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Descripcion";
                col.HeaderText  = "Descripcion";
                col.Ancho       = -1;
                frm.columnas[1] = col;

                frm.ShowDialog();

                if (frm.FilaSelecionada != null)
                {
                    DRCuentasContables = frm.FilaSelecionada;
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                frm.Dispose();
            }
        }
Ejemplo n.º 5
0
        private void btnBuscarCuenta_Click(object sender, EventArgs e)
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            try
            {
                frm.titulo         = @"CUENTAS CONTABLES";
                frm.TablaOVista    = "TCONTA_CATALOGO";
                frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString();
                frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Cuenta_Contable";
                col.HeaderText  = "Cuenta Contable";
                col.Ancho       = 140;
                frm.columnas[0] = col;

                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Descripcion";
                col.HeaderText  = "Descripcion";
                col.Ancho       = -1;
                frm.columnas[1] = col;

                frm.DefaultColumnaBusqueda = "Cuenta_Contable";
                frm.ShowDialog();

                if (frm.FilaSelecionada != null)
                {
                    txtCuentaContable.Text = objUtil.GetAsString("Cuenta_Contable", frm.FilaSelecionada);
                    txtDescripcion.Text    = objUtil.GetAsString("Descripcion", frm.FilaSelecionada);
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
            finally
            {
                frm.Dispose();
            }
        }
        private void GetCuentaContable(string cuentaNo = "")
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            try
            {
                //Vamos a Buscar LA CUENTA
                DRCuentasContables = null;
                frm.titulo         = @"CUENTAS CONTABLES";
                frm.TablaOVista    = "TCONTA_CATALOGO";
                frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsControl = 0 And EsMovimiento = 1";
                frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Cuenta_Contable";
                col.HeaderText  = "Cuenta Contable";
                col.Ancho       = 140;
                frm.columnas[0] = col;

                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Descripcion";
                col.HeaderText  = "Descripcion";
                col.Ancho       = -1;
                frm.columnas[1] = col;

                frm.ShowDialog();

                if (frm.FilaSelecionada != null)
                {
                    DRCuentasContables = frm.FilaSelecionada;
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
        }
        private void GetCuentaContable(DataGridView senderGrid, string cuentaNo = "")
        {
            int    index          = 0;
            string nombreCampo    = "";
            string cuentaContable = "";
            string SSQL           = "";
            int    valorUnico     = 0;
            string nombreTabla    = "";
            string columnaCuenta  = "";
            string columnaUnico   = "";


            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            //Vamos a Buscar la Cuenta Contable
            try
            {
                nombreTabla = "";

                frm.titulo         = @"CUENTAS CONTABLES";
                frm.TablaOVista    = "TCONTA_CATALOGO";
                frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsControl = 0";
                frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                col                        = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo            = "Cuenta_Contable";
                col.HeaderText             = "Cuenta Contable";
                col.Ancho                  = 140;
                frm.columnas[0]            = col;
                frm.DefaultColumnaBusqueda = "Cuenta_Contable";

                col             = new WinControl_ELR_NET.MyColumna();
                col.NombreCampo = "Descripcion";
                col.HeaderText  = "Descripcion";
                col.Ancho       = -1;
                frm.columnas[1] = col;

                frm.ShowDialog();

                if (frm.FilaSelecionada != null)
                {
                    this.Cursor = Cursors.WaitCursor;

                    //Buscamos la columna que Contiene la Fecha Contable
                    foreach (DataGridViewColumn item in senderGrid.Columns)
                    {
                        if (item.DataPropertyName.ToUpper() == "CUENTA_CONTABLE" && columnaCuenta.Trim() == "")
                        {
                            columnaCuenta = item.Name;
                        }
                        if (item.DataPropertyName.ToUpper() == "UNICO" && columnaUnico.Trim() == "")
                        {
                            columnaUnico = item.Name;
                        }

                        if (columnaCuenta != "" && columnaUnico != "")
                        {
                            break;
                        }
                    }

                    cuentaContable = objUtil.GetAsString("Cuenta_Contable", frm.FilaSelecionada);
                    index          = senderGrid.CurrentRow.Index;

                    senderGrid[columnaCuenta, index].Value = cuentaContable;

                    valorUnico = int.Parse(senderGrid[columnaUnico, index].Value.ToString());

                    if (senderGrid == dtgActivosFijosCuentas)
                    {
                        nombreCampo = senderGrid["Nombre_Campo", index].Value.ToString();

                        SSQL  = " UPDATE TACTIVOS_FIJOS_TIPOS SET " + nombreCampo + " = '" + cuentaContable + "' ";
                        SSQL += " WHERE Unico = " + valorUnico.ToString();

                        objDB.EjecutarSQL(SSQL);
                    }
                    else if (senderGrid == dtgCategorias)
                    {
                        nombreCampo = senderGrid["Nombre_Campo_Categoria", index].Value.ToString();

                        SSQL  = " UPDATE TCLASIFICADOR_PRODUCTOS_CATEGORIAS SET " + nombreCampo + " = '" + cuentaContable + "' ";
                        SSQL += " WHERE Unico = " + valorUnico.ToString();

                        objDB.EjecutarSQL(SSQL);
                    }
                    else if (senderGrid == dtgCuentasBanco)
                    {
                        nombreTabla = "TBANCOS_CUENTAS_BANCARIAS";
                    }
                    else if (senderGrid == dtgTransCaja)
                    {
                        nombreTabla = "TCAJAS_TIPO_TRANS";
                    }
                    else if (senderGrid == dtgCajas)
                    {
                        nombreTabla = "TCAJAS";
                    }
                    else if (senderGrid == dtgEnlaceDetalle)
                    {
                        nombreTabla = "TCONTA_ENLACES_CUENTAS";
                    }
                    else if (senderGrid == dtgTransBancarias)
                    {
                        nombreTabla = "TBANCOS_TRANS_TIPOS";
                    }


                    if (nombreTabla != "" && valorUnico > 0)
                    {
                        SSQL  = " UPDATE " + nombreTabla + " Set Cuenta_Contable = '" + cuentaContable + "' ";
                        SSQL += " WHERE Unico = " + valorUnico.ToString();
                        objDB.EjecutarSQL(SSQL);
                    }

                    senderGrid.CurrentCell = senderGrid[columnaCuenta, index];
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
            finally
            {
                this.Cursor = Cursors.Default;
                frm.Dispose();
            }
        }
Ejemplo n.º 8
0
        void GetVendedor(int id = 0)
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;
            DataTable DTVendedores = null;
            DataRow   DRVendedor   = null;

            try
            {
                if (id > 0)
                {
                    objDB.LimpiarFiltros();
                    objDB.AddFiltroIgualA("Empleado_Id", id.ToString());
                    objDB.AddFiltroIgualA("EsActivo", "1");
                    objDB.AddFiltroIgualA("EsVendedor", "1");
                    DTVendedores = objDB.GetAll("VVENDEDORES", 1, objDB.Filtros);
                    if (DTVendedores.Rows.Count > 0)
                    {
                        DRVendedor = DTVendedores.Rows[0];
                    }
                }
                else
                {
                    //Realizamos una Busqueda General
                    frm.titulo         = "VENDEDORES";
                    frm.TablaOVista    = "VVENDEDORES";
                    frm.FiltroEstatico = "EsActivo = 1 And EsVendedor = 1";
                    frm.columnas       = new WinControl_ELR_NET.MyColumna[3];


                    col             = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo = "Empleado_Id";
                    col.HeaderText  = "Codigo";
                    col.Ancho       = 120;
                    frm.columnas[0] = col;

                    col             = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo = "CedulaRNC";
                    col.HeaderText  = @"Cedula\RNC";
                    col.Ancho       = 130;
                    frm.columnas[1] = col;

                    col                        = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo            = "Nombre_Completo";
                    col.HeaderText             = "Nombre";
                    col.Ancho                  = -1;
                    frm.columnas[2]            = col;
                    frm.DefaultColumnaBusqueda = "Nombre_Completo";

                    frm.ShowDialog();

                    if (frm.FilaSelecionada != null)
                    {
                        DRVendedor = frm.FilaSelecionada;
                    }
                }

                if (DRVendedor != null)
                {
                    txtCodigoVendedor.Text = DRVendedor["Empleado_Id"].ToString();
                    txtNombreVendedor.Text = DRVendedor["Nombre_Completo"].ToString();

                    txtBusquedaProducto.Focus();
                }
                else
                {
                    txtCodigoVendedor.Text = "0";
                    txtNombreVendedor.Text = nombreUsuario.ToUpper();
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError("Error al Buscar Cliente, " + ex.Message);
            }
            finally
            {
                frm.Dispose();
                col          = null;
                DTVendedores = null;
                DRVendedor   = null;
            }
        }
        void GetCentroCosto(string codigo = "")
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;
            DataTable DTData = null;
            DataRow   fila0 = null;
            string    SSQL = "";
            int       index = 0;
            string    descripcionCuenta = "", descripcionAuxiliar = "", valorUnico = "0";

            try
            {
                if (DTDetalle == null)
                {
                    return;
                }
                if (DTDetalle.Rows.Count <= 0)
                {
                    return;
                }

                if (codigo != "")
                {
                    SSQL  = "SELECT TOP 1 Codigo_Auxiliar, Descripcion FROM VCONTA_AUXILIARES ";
                    SSQL += " WHERE Cast(Codigo_Auxiliar as Varchar) Like '" + codigo + "%' ";
                    SSQL += " Order by Codigo_Auxiliar";

                    DTData = objDB.GetSQL(SSQL);
                    if (DTData.Rows.Count > 0)
                    {
                        fila0 = DTData.Rows[0];
                    }
                }
                else
                {
                    //Vamos a Buscar el Producto
                    frm.titulo           = @"OFICINA O CENTRO DE COSTO";
                    frm.TablaOVista      = "VCONTA_AUXILIARES";
                    frm.FiltroEstatico   = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsActivo = 1";
                    frm.columnas         = new WinControl_ELR_NET.MyColumna[2];
                    frm.CondicionOrderBY = "Codigo_Auxiliar";


                    col             = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo = "Codigo_Auxiliar";
                    col.HeaderText  = "Codigo";
                    col.Ancho       = 140;
                    frm.columnas[0] = col;

                    col                        = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo            = "Descripcion";
                    col.HeaderText             = "Descripcion";
                    col.Ancho                  = -1;
                    frm.columnas[1]            = col;
                    frm.DefaultColumnaBusqueda = "Descripcion";

                    frm.ShowDialog();

                    if (frm.FilaSelecionada != null)
                    {
                        fila0 = frm.FilaSelecionada;
                    }
                }

                if (fila0 != null)
                {
                    codigoAuxiliar      = objUtil.GetAsInt("Codigo_Auxiliar", fila0);
                    descripcionAuxiliar = objUtil.GetAsString("Descripcion", fila0);

                    index                    = DataGridDetalle.CurrentRow.Index;
                    valorUnico               = DataGridDetalle["ItemNumero", index].Value.ToString();
                    fila0                    = DTDetalle.Select("ItemNumero = " + valorUnico)[0];
                    descripcionCuenta        = objUtil.GetAsString("Descripcion_Cuenta", fila0);
                    fila0["Codigo_Auxiliar"] = codigoAuxiliar;
                    fila0["Descripcion"]     = descripcionCuenta + ", " + descripcionAuxiliar;
                    DataGridDetalle.Refresh();

                    DataGridDetalle["Cuenta_Contable", index].Selected = true;

                    DataGridDetalle.CurrentCell = DataGridDetalle["Total", index];

                    DataGridDetalle.BeginEdit(false);
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
            finally
            {
                frm.Dispose();
            }
        }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     WinControl_ELR_NET.MyColumna myColumna5 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna6 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna3 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna4 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna1 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna2 = new WinControl_ELR_NET.MyColumna();
     this.panel1               = new System.Windows.Forms.Panel();
     this.btnAceptar           = new System.Windows.Forms.Button();
     this.btnCancelar          = new System.Windows.Forms.Button();
     this.pnOficina            = new System.Windows.Forms.Panel();
     this.chkPorOficina        = new System.Windows.Forms.CheckBox();
     this.pnPorEvaluador       = new System.Windows.Forms.Panel();
     this.chkPorEvaluador      = new System.Windows.Forms.CheckBox();
     this.lblNombreEvaluador   = new System.Windows.Forms.Label();
     this.label7               = new System.Windows.Forms.Label();
     this.lblEvaluadorId       = new System.Windows.Forms.Label();
     this.pnPorOficialCredito  = new System.Windows.Forms.Panel();
     this.chkPorOficialCredito = new System.Windows.Forms.CheckBox();
     this.lblNombreOficial     = new System.Windows.Forms.Label();
     this.label9               = new System.Windows.Forms.Label();
     this.lblOficialId         = new System.Windows.Forms.Label();
     this.pnPorCajaId          = new System.Windows.Forms.Panel();
     this.chkPorCajaId         = new System.Windows.Forms.CheckBox();
     this.pnVendedor           = new System.Windows.Forms.Panel();
     this.chkPorVendedor       = new System.Windows.Forms.CheckBox();
     this.lblNombreVendedor    = new System.Windows.Forms.Label();
     this.label15              = new System.Windows.Forms.Label();
     this.lblVendedorId        = new System.Windows.Forms.Label();
     this.pnPorRangoFecha      = new System.Windows.Forms.Panel();
     this.dtpFechaHasta        = new System.Windows.Forms.DateTimePicker();
     this.dtpFechaDesde        = new System.Windows.Forms.DateTimePicker();
     this.label2               = new System.Windows.Forms.Label();
     this.label1               = new System.Windows.Forms.Label();
     this.pnFechaHasta         = new System.Windows.Forms.Panel();
     this.dtpAFecha            = new System.Windows.Forms.DateTimePicker();
     this.label13              = new System.Windows.Forms.Label();
     this.btnPorVendedor       = new WinControl_ELR_NET.ELRBotonBuscar();
     this.cboCaja              = new WinControl_ELR_NET.ELRCombobox();
     this.btnPorOficialCredito = new WinControl_ELR_NET.ELRBotonBuscar();
     this.btnBusquedaEvaluador = new WinControl_ELR_NET.ELRBotonBuscar();
     this.cboOficina           = new WinControl_ELR_NET.ELRCombobox();
     this.panel1.SuspendLayout();
     this.pnOficina.SuspendLayout();
     this.pnPorEvaluador.SuspendLayout();
     this.pnPorOficialCredito.SuspendLayout();
     this.pnPorCajaId.SuspendLayout();
     this.pnVendedor.SuspendLayout();
     this.pnPorRangoFecha.SuspendLayout();
     this.pnFechaHasta.SuspendLayout();
     this.SuspendLayout();
     //
     // panel1
     //
     this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.panel1.Controls.Add(this.btnAceptar);
     this.panel1.Controls.Add(this.btnCancelar);
     this.panel1.Dock     = System.Windows.Forms.DockStyle.Bottom;
     this.panel1.Location = new System.Drawing.Point(0, 604);
     this.panel1.Name     = "panel1";
     this.panel1.Size     = new System.Drawing.Size(608, 42);
     this.panel1.TabIndex = 4;
     //
     // btnAceptar
     //
     this.btnAceptar.Dock     = System.Windows.Forms.DockStyle.Right;
     this.btnAceptar.Location = new System.Drawing.Point(442, 0);
     this.btnAceptar.Name     = "btnAceptar";
     this.btnAceptar.Size     = new System.Drawing.Size(81, 38);
     this.btnAceptar.TabIndex = 0;
     this.btnAceptar.Text     = "Aceptar";
     this.btnAceptar.UseVisualStyleBackColor = true;
     this.btnAceptar.Click += new System.EventHandler(this.btnAceptar_Click);
     //
     // btnCancelar
     //
     this.btnCancelar.DialogResult            = System.Windows.Forms.DialogResult.Cancel;
     this.btnCancelar.Dock                    = System.Windows.Forms.DockStyle.Right;
     this.btnCancelar.Location                = new System.Drawing.Point(523, 0);
     this.btnCancelar.Name                    = "btnCancelar";
     this.btnCancelar.Size                    = new System.Drawing.Size(81, 38);
     this.btnCancelar.TabIndex                = 1;
     this.btnCancelar.Text                    = "Cancelar";
     this.btnCancelar.UseVisualStyleBackColor = true;
     this.btnCancelar.Click                  += new System.EventHandler(this.btnCancelar_Click);
     //
     // pnOficina
     //
     this.pnOficina.Controls.Add(this.chkPorOficina);
     this.pnOficina.Controls.Add(this.cboOficina);
     this.pnOficina.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnOficina.Location = new System.Drawing.Point(0, 0);
     this.pnOficina.Name     = "pnOficina";
     this.pnOficina.Size     = new System.Drawing.Size(608, 54);
     this.pnOficina.TabIndex = 12;
     //
     // chkPorOficina
     //
     this.chkPorOficina.AutoSize = true;
     this.chkPorOficina.Location = new System.Drawing.Point(12, 14);
     this.chkPorOficina.Name     = "chkPorOficina";
     this.chkPorOficina.Size     = new System.Drawing.Size(109, 25);
     this.chkPorOficina.TabIndex = 15;
     this.chkPorOficina.Text     = "Por Oficina:";
     this.chkPorOficina.UseVisualStyleBackColor = true;
     this.chkPorOficina.CheckedChanged         += new System.EventHandler(this.Opcion_Cheched);
     //
     // pnPorEvaluador
     //
     this.pnPorEvaluador.Controls.Add(this.btnBusquedaEvaluador);
     this.pnPorEvaluador.Controls.Add(this.chkPorEvaluador);
     this.pnPorEvaluador.Controls.Add(this.lblNombreEvaluador);
     this.pnPorEvaluador.Controls.Add(this.label7);
     this.pnPorEvaluador.Controls.Add(this.lblEvaluadorId);
     this.pnPorEvaluador.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnPorEvaluador.Location = new System.Drawing.Point(0, 54);
     this.pnPorEvaluador.Name     = "pnPorEvaluador";
     this.pnPorEvaluador.Size     = new System.Drawing.Size(608, 88);
     this.pnPorEvaluador.TabIndex = 13;
     //
     // chkPorEvaluador
     //
     this.chkPorEvaluador.AutoSize = true;
     this.chkPorEvaluador.Location = new System.Drawing.Point(12, 13);
     this.chkPorEvaluador.Name     = "chkPorEvaluador";
     this.chkPorEvaluador.Size     = new System.Drawing.Size(126, 25);
     this.chkPorEvaluador.TabIndex = 14;
     this.chkPorEvaluador.Text     = "Por Evaluador";
     this.chkPorEvaluador.UseVisualStyleBackColor = true;
     this.chkPorEvaluador.CheckedChanged         += new System.EventHandler(this.Opcion_Cheched);
     //
     // lblNombreEvaluador
     //
     this.lblNombreEvaluador.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.lblNombreEvaluador.Location    = new System.Drawing.Point(175, 48);
     this.lblNombreEvaluador.Name        = "lblNombreEvaluador";
     this.lblNombreEvaluador.Size        = new System.Drawing.Size(420, 30);
     this.lblNombreEvaluador.TabIndex    = 12;
     this.lblNombreEvaluador.Text        = "(TODOS)";
     //
     // label7
     //
     this.label7.AutoSize = true;
     this.label7.Location = new System.Drawing.Point(12, 48);
     this.label7.Name     = "label7";
     this.label7.Size     = new System.Drawing.Size(71, 21);
     this.label7.TabIndex = 11;
     this.label7.Text     = "Nombre:";
     //
     // lblEvaluadorId
     //
     this.lblEvaluadorId.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.lblEvaluadorId.Location    = new System.Drawing.Point(174, 13);
     this.lblEvaluadorId.Name        = "lblEvaluadorId";
     this.lblEvaluadorId.Size        = new System.Drawing.Size(110, 30);
     this.lblEvaluadorId.TabIndex    = 10;
     this.lblEvaluadorId.Text        = "000000";
     //
     // pnPorOficialCredito
     //
     this.pnPorOficialCredito.Controls.Add(this.btnPorOficialCredito);
     this.pnPorOficialCredito.Controls.Add(this.chkPorOficialCredito);
     this.pnPorOficialCredito.Controls.Add(this.lblNombreOficial);
     this.pnPorOficialCredito.Controls.Add(this.label9);
     this.pnPorOficialCredito.Controls.Add(this.lblOficialId);
     this.pnPorOficialCredito.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnPorOficialCredito.Location = new System.Drawing.Point(0, 142);
     this.pnPorOficialCredito.Name     = "pnPorOficialCredito";
     this.pnPorOficialCredito.Size     = new System.Drawing.Size(608, 88);
     this.pnPorOficialCredito.TabIndex = 14;
     //
     // chkPorOficialCredito
     //
     this.chkPorOficialCredito.AutoSize = true;
     this.chkPorOficialCredito.Location = new System.Drawing.Point(12, 13);
     this.chkPorOficialCredito.Name     = "chkPorOficialCredito";
     this.chkPorOficialCredito.Size     = new System.Drawing.Size(156, 25);
     this.chkPorOficialCredito.TabIndex = 15;
     this.chkPorOficialCredito.Text     = "Por Oficial Credito";
     this.chkPorOficialCredito.UseVisualStyleBackColor = true;
     this.chkPorOficialCredito.CheckedChanged         += new System.EventHandler(this.Opcion_Cheched);
     //
     // lblNombreOficial
     //
     this.lblNombreOficial.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.lblNombreOficial.Location    = new System.Drawing.Point(174, 48);
     this.lblNombreOficial.Name        = "lblNombreOficial";
     this.lblNombreOficial.Size        = new System.Drawing.Size(420, 30);
     this.lblNombreOficial.TabIndex    = 12;
     this.lblNombreOficial.Text        = "(TODOS)";
     //
     // label9
     //
     this.label9.AutoSize = true;
     this.label9.Location = new System.Drawing.Point(12, 48);
     this.label9.Name     = "label9";
     this.label9.Size     = new System.Drawing.Size(71, 21);
     this.label9.TabIndex = 11;
     this.label9.Text     = "Nombre:";
     //
     // lblOficialId
     //
     this.lblOficialId.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.lblOficialId.Location    = new System.Drawing.Point(174, 13);
     this.lblOficialId.Name        = "lblOficialId";
     this.lblOficialId.Size        = new System.Drawing.Size(110, 30);
     this.lblOficialId.TabIndex    = 10;
     this.lblOficialId.Text        = "000000";
     //
     // pnPorCajaId
     //
     this.pnPorCajaId.Controls.Add(this.chkPorCajaId);
     this.pnPorCajaId.Controls.Add(this.cboCaja);
     this.pnPorCajaId.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnPorCajaId.Location = new System.Drawing.Point(0, 230);
     this.pnPorCajaId.Name     = "pnPorCajaId";
     this.pnPorCajaId.Size     = new System.Drawing.Size(608, 47);
     this.pnPorCajaId.TabIndex = 15;
     //
     // chkPorCajaId
     //
     this.chkPorCajaId.AutoSize = true;
     this.chkPorCajaId.Location = new System.Drawing.Point(12, 8);
     this.chkPorCajaId.Name     = "chkPorCajaId";
     this.chkPorCajaId.Size     = new System.Drawing.Size(90, 25);
     this.chkPorCajaId.TabIndex = 16;
     this.chkPorCajaId.Text     = "Por Caja:";
     this.chkPorCajaId.UseVisualStyleBackColor = true;
     this.chkPorCajaId.CheckedChanged         += new System.EventHandler(this.Opcion_Cheched);
     //
     // pnVendedor
     //
     this.pnVendedor.Controls.Add(this.btnPorVendedor);
     this.pnVendedor.Controls.Add(this.chkPorVendedor);
     this.pnVendedor.Controls.Add(this.lblNombreVendedor);
     this.pnVendedor.Controls.Add(this.label15);
     this.pnVendedor.Controls.Add(this.lblVendedorId);
     this.pnVendedor.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnVendedor.Location = new System.Drawing.Point(0, 277);
     this.pnVendedor.Name     = "pnVendedor";
     this.pnVendedor.Size     = new System.Drawing.Size(608, 88);
     this.pnVendedor.TabIndex = 18;
     //
     // chkPorVendedor
     //
     this.chkPorVendedor.AutoSize = true;
     this.chkPorVendedor.Location = new System.Drawing.Point(12, 6);
     this.chkPorVendedor.Name     = "chkPorVendedor";
     this.chkPorVendedor.Size     = new System.Drawing.Size(128, 25);
     this.chkPorVendedor.TabIndex = 17;
     this.chkPorVendedor.Text     = "Por Vendedor:";
     this.chkPorVendedor.UseVisualStyleBackColor = true;
     this.chkPorVendedor.CheckedChanged         += new System.EventHandler(this.Opcion_Cheched);
     //
     // lblNombreVendedor
     //
     this.lblNombreVendedor.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.lblNombreVendedor.Location    = new System.Drawing.Point(174, 48);
     this.lblNombreVendedor.Name        = "lblNombreVendedor";
     this.lblNombreVendedor.Size        = new System.Drawing.Size(420, 30);
     this.lblNombreVendedor.TabIndex    = 12;
     this.lblNombreVendedor.Text        = "(TODOS)";
     //
     // label15
     //
     this.label15.AutoSize = true;
     this.label15.Location = new System.Drawing.Point(8, 48);
     this.label15.Name     = "label15";
     this.label15.Size     = new System.Drawing.Size(71, 21);
     this.label15.TabIndex = 11;
     this.label15.Text     = "Nombre:";
     //
     // lblVendedorId
     //
     this.lblVendedorId.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.lblVendedorId.Location    = new System.Drawing.Point(174, 12);
     this.lblVendedorId.Name        = "lblVendedorId";
     this.lblVendedorId.Size        = new System.Drawing.Size(110, 30);
     this.lblVendedorId.TabIndex    = 10;
     this.lblVendedorId.Text        = "000000";
     //
     // pnPorRangoFecha
     //
     this.pnPorRangoFecha.Controls.Add(this.dtpFechaHasta);
     this.pnPorRangoFecha.Controls.Add(this.dtpFechaDesde);
     this.pnPorRangoFecha.Controls.Add(this.label2);
     this.pnPorRangoFecha.Controls.Add(this.label1);
     this.pnPorRangoFecha.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnPorRangoFecha.Location = new System.Drawing.Point(0, 449);
     this.pnPorRangoFecha.Name     = "pnPorRangoFecha";
     this.pnPorRangoFecha.Size     = new System.Drawing.Size(608, 140);
     this.pnPorRangoFecha.TabIndex = 20;
     //
     // dtpFechaHasta
     //
     this.dtpFechaHasta.Format   = System.Windows.Forms.DateTimePickerFormat.Short;
     this.dtpFechaHasta.Location = new System.Drawing.Point(175, 75);
     this.dtpFechaHasta.Name     = "dtpFechaHasta";
     this.dtpFechaHasta.Size     = new System.Drawing.Size(265, 29);
     this.dtpFechaHasta.TabIndex = 23;
     //
     // dtpFechaDesde
     //
     this.dtpFechaDesde.Format   = System.Windows.Forms.DateTimePickerFormat.Short;
     this.dtpFechaDesde.Location = new System.Drawing.Point(174, 21);
     this.dtpFechaDesde.Name     = "dtpFechaDesde";
     this.dtpFechaDesde.Size     = new System.Drawing.Size(266, 29);
     this.dtpFechaDesde.TabIndex = 21;
     //
     // label2
     //
     this.label2.AutoSize = true;
     this.label2.Location = new System.Drawing.Point(84, 76);
     this.label2.Name     = "label2";
     this.label2.Size     = new System.Drawing.Size(52, 21);
     this.label2.TabIndex = 22;
     this.label2.Text     = "Hasta:";
     //
     // label1
     //
     this.label1.AutoSize = true;
     this.label1.Location = new System.Drawing.Point(84, 21);
     this.label1.Name     = "label1";
     this.label1.Size     = new System.Drawing.Size(56, 21);
     this.label1.TabIndex = 20;
     this.label1.Text     = "Desde:";
     //
     // pnFechaHasta
     //
     this.pnFechaHasta.Controls.Add(this.dtpAFecha);
     this.pnFechaHasta.Controls.Add(this.label13);
     this.pnFechaHasta.Dock     = System.Windows.Forms.DockStyle.Top;
     this.pnFechaHasta.Location = new System.Drawing.Point(0, 365);
     this.pnFechaHasta.Name     = "pnFechaHasta";
     this.pnFechaHasta.Size     = new System.Drawing.Size(608, 84);
     this.pnFechaHasta.TabIndex = 19;
     //
     // dtpAFecha
     //
     this.dtpAFecha.Format   = System.Windows.Forms.DateTimePickerFormat.Short;
     this.dtpAFecha.Location = new System.Drawing.Point(174, 24);
     this.dtpAFecha.Name     = "dtpAFecha";
     this.dtpAFecha.Size     = new System.Drawing.Size(266, 29);
     this.dtpAFecha.TabIndex = 21;
     //
     // label13
     //
     this.label13.AutoSize = true;
     this.label13.Location = new System.Drawing.Point(84, 24);
     this.label13.Name     = "label13";
     this.label13.Size     = new System.Drawing.Size(67, 21);
     this.label13.TabIndex = 20;
     this.label13.Text     = "A Fecha:";
     //
     // btnPorVendedor
     //
     this.btnPorVendedor.AMostrar = null;
     myColumna5.Ancho             = 100;
     myColumna5.HeaderText        = "Id";
     myColumna5.NombreCampo       = "Empleado_Id";
     myColumna6.Ancho             = 300;
     myColumna6.HeaderText        = "Nombre";
     myColumna6.NombreCampo       = "Nombre_Completo";
     this.btnPorVendedor.columnas = new WinControl_ELR_NET.MyColumna[] {
         myColumna5,
         myColumna6
     };
     this.btnPorVendedor.CondicionABuscar  = "Campo_Busqueda Like \'%\' + @aBuscar + \'%\'";
     this.btnPorVendedor.CondicionOrderBY  = "";
     this.btnPorVendedor.EsAutoIncremental = true;
     this.btnPorVendedor.FiltroEstatico    = "";
     this.btnPorVendedor.Limite            = 100;
     this.btnPorVendedor.Location          = new System.Drawing.Point(290, 12);
     this.btnPorVendedor.Name                    = "btnPorVendedor";
     this.btnPorVendedor.Size                    = new System.Drawing.Size(74, 33);
     this.btnPorVendedor.TabIndex                = 18;
     this.btnPorVendedor.TablaOVista             = "VEMPLEADOS";
     this.btnPorVendedor.Text                    = "Buscar";
     this.btnPorVendedor.Titulo                  = "Busqueda General";
     this.btnPorVendedor.UseVisualStyleBackColor = true;
     this.btnPorVendedor.Click                  += new System.EventHandler(this.btnPorVendedor_Click);
     //
     // cboCaja
     //
     this.cboCaja.CampoData          = "";
     this.cboCaja.CampoJoinCombobox2 = "";
     this.cboCaja.ComboboxAFiltrar   = null;
     this.cboCaja.DisplayMember      = "Nombre";
     this.cboCaja.DSData             = null;
     this.cboCaja.EsEditable         = true;
     this.cboCaja.FiltroBusqueda     = "";
     this.cboCaja.FormattingEnabled  = true;
     this.cboCaja.Location           = new System.Drawing.Point(174, 6);
     this.cboCaja.Name                = "cboCaja";
     this.cboCaja.NombreTabla         = "";
     this.cboCaja.Size                = new System.Drawing.Size(381, 29);
     this.cboCaja.SSQL                = "";
     this.cboCaja.TabIndex            = 0;
     this.cboCaja.TablaOVistaConsulta = "TCajas";
     this.cboCaja.ValorPorDefecto     = "0";
     this.cboCaja.ValueMember         = "Caja_Id";
     //
     // btnPorOficialCredito
     //
     this.btnPorOficialCredito.AMostrar = null;
     myColumna3.Ancho                   = 100;
     myColumna3.HeaderText              = "Id";
     myColumna3.NombreCampo             = "Empleado_Id";
     myColumna4.Ancho                   = 300;
     myColumna4.HeaderText              = "Nombre";
     myColumna4.NombreCampo             = "Nombre_Completo";
     this.btnPorOficialCredito.columnas = new WinControl_ELR_NET.MyColumna[] {
         myColumna3,
         myColumna4
     };
     this.btnPorOficialCredito.CondicionABuscar  = "Campo_Busqueda Like \'%\' + @aBuscar + \'%\'";
     this.btnPorOficialCredito.CondicionOrderBY  = "";
     this.btnPorOficialCredito.EsAutoIncremental = true;
     this.btnPorOficialCredito.FiltroEstatico    = "";
     this.btnPorOficialCredito.Limite            = 100;
     this.btnPorOficialCredito.Location          = new System.Drawing.Point(290, 12);
     this.btnPorOficialCredito.Name                    = "btnPorOficialCredito";
     this.btnPorOficialCredito.Size                    = new System.Drawing.Size(74, 33);
     this.btnPorOficialCredito.TabIndex                = 16;
     this.btnPorOficialCredito.TablaOVista             = "VEMPLEADOS";
     this.btnPorOficialCredito.Text                    = "Buscar";
     this.btnPorOficialCredito.Titulo                  = "Busqueda General";
     this.btnPorOficialCredito.UseVisualStyleBackColor = true;
     this.btnPorOficialCredito.Click                  += new System.EventHandler(this.btnPorOficialCredito_Click);
     //
     // btnBusquedaEvaluador
     //
     this.btnBusquedaEvaluador.AMostrar = null;
     myColumna1.Ancho                   = 100;
     myColumna1.HeaderText              = "Id";
     myColumna1.NombreCampo             = "Empleado_Id";
     myColumna2.Ancho                   = 300;
     myColumna2.HeaderText              = "Nombre";
     myColumna2.NombreCampo             = "Nombre_Completo";
     this.btnBusquedaEvaluador.columnas = new WinControl_ELR_NET.MyColumna[] {
         myColumna1,
         myColumna2
     };
     this.btnBusquedaEvaluador.CondicionABuscar  = "Campo_Busqueda Like \'%\' + @aBuscar + \'%\'";
     this.btnBusquedaEvaluador.CondicionOrderBY  = "";
     this.btnBusquedaEvaluador.EsAutoIncremental = true;
     this.btnBusquedaEvaluador.FiltroEstatico    = "";
     this.btnBusquedaEvaluador.Limite            = 100;
     this.btnBusquedaEvaluador.Location          = new System.Drawing.Point(290, 12);
     this.btnBusquedaEvaluador.Name                    = "btnBusquedaEvaluador";
     this.btnBusquedaEvaluador.Size                    = new System.Drawing.Size(74, 33);
     this.btnBusquedaEvaluador.TabIndex                = 15;
     this.btnBusquedaEvaluador.TablaOVista             = "VEMPLEADOS";
     this.btnBusquedaEvaluador.Text                    = "Buscar";
     this.btnBusquedaEvaluador.Titulo                  = "Busqueda General";
     this.btnBusquedaEvaluador.UseVisualStyleBackColor = true;
     this.btnBusquedaEvaluador.Click                  += new System.EventHandler(this.btnBusquedaEvaluador_Click);
     //
     // cboOficina
     //
     this.cboOficina.CampoData          = "";
     this.cboOficina.CampoJoinCombobox2 = "";
     this.cboOficina.ComboboxAFiltrar   = null;
     this.cboOficina.DisplayMember      = "Nombre";
     this.cboOficina.DSData             = null;
     this.cboOficina.EsEditable         = true;
     this.cboOficina.FiltroBusqueda     = "";
     this.cboOficina.FormattingEnabled  = true;
     this.cboOficina.Location           = new System.Drawing.Point(174, 12);
     this.cboOficina.Name                = "cboOficina";
     this.cboOficina.NombreTabla         = "";
     this.cboOficina.Size                = new System.Drawing.Size(420, 29);
     this.cboOficina.SSQL                = "";
     this.cboOficina.TabIndex            = 0;
     this.cboOficina.TablaOVistaConsulta = "TEMPRESAS_OFICINAS";
     this.cboOficina.ValorPorDefecto     = "0";
     this.cboOficina.ValueMember         = "Oficina_Id";
     //
     // FormParamReportes
     //
     this.AcceptButton        = this.btnAceptar;
     this.AutoScaleDimensions = new System.Drawing.SizeF(9F, 21F);
     this.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
     this.CancelButton        = this.btnCancelar;
     this.ClientSize          = new System.Drawing.Size(608, 646);
     this.Controls.Add(this.pnPorRangoFecha);
     this.Controls.Add(this.pnFechaHasta);
     this.Controls.Add(this.pnVendedor);
     this.Controls.Add(this.pnPorCajaId);
     this.Controls.Add(this.pnPorOficialCredito);
     this.Controls.Add(this.pnPorEvaluador);
     this.Controls.Add(this.pnOficina);
     this.Controls.Add(this.panel1);
     this.Font            = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
     this.Margin          = new System.Windows.Forms.Padding(4, 5, 4, 5);
     this.MaximizeBox     = false;
     this.MinimizeBox     = false;
     this.Name            = "FormParamReportes";
     this.StartPosition   = System.Windows.Forms.FormStartPosition.CenterScreen;
     this.Text            = "ELEGIR RANGO FECHA";
     this.Load           += new System.EventHandler(this.FormRangoFecha_Load);
     this.panel1.ResumeLayout(false);
     this.pnOficina.ResumeLayout(false);
     this.pnOficina.PerformLayout();
     this.pnPorEvaluador.ResumeLayout(false);
     this.pnPorEvaluador.PerformLayout();
     this.pnPorOficialCredito.ResumeLayout(false);
     this.pnPorOficialCredito.PerformLayout();
     this.pnPorCajaId.ResumeLayout(false);
     this.pnPorCajaId.PerformLayout();
     this.pnVendedor.ResumeLayout(false);
     this.pnVendedor.PerformLayout();
     this.pnPorRangoFecha.ResumeLayout(false);
     this.pnPorRangoFecha.PerformLayout();
     this.pnFechaHasta.ResumeLayout(false);
     this.pnFechaHasta.PerformLayout();
     this.ResumeLayout(false);
 }
Ejemplo n.º 11
0
        void GetCentroCosto(string codigo = "")
        {
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;
            DataTable DTData = null;
            DataRow   fila0 = null;
            string    SSQL = "", codigoAuxiliar = "0", descripcion = "(TODOS)";

            try
            {
                if (codigo != "")
                {
                    SSQL  = "SELECT TOP 1 Codigo_Auxiliar, Descripcion FROM VCONTA_AUXILIARES ";
                    SSQL += " WHERE Cast(Codigo_Auxiliar as Varchar) Like '" + codigo + "%' ";
                    SSQL += " Order by Codigo_Auxiliar";

                    DTData = objDB.GetSQL(SSQL);
                    if (DTData.Rows.Count > 0)
                    {
                        fila0 = DTData.Rows[0];
                    }
                }
                else
                {
                    //Vamos a Buscar el Producto
                    frm.titulo           = @"OFICINA O CENTRO DE COSTO";
                    frm.TablaOVista      = "VCONTA_AUXILIARES";
                    frm.FiltroEstatico   = "Empresa_Id  = " + empresaID.ToString() + " And EsActivo = 1";
                    frm.columnas         = new WinControl_ELR_NET.MyColumna[2];
                    frm.CondicionOrderBY = "Codigo_Auxiliar";


                    col             = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo = "Codigo_Auxiliar";
                    col.HeaderText  = "Codigo";
                    col.Ancho       = 140;
                    frm.columnas[0] = col;

                    col                        = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo            = "Descripcion";
                    col.HeaderText             = "Descripcion";
                    col.Ancho                  = -1;
                    frm.columnas[1]            = col;
                    frm.DefaultColumnaBusqueda = "Descripcion";

                    frm.ShowDialog();

                    if (frm.FilaSelecionada != null)
                    {
                        fila0 = frm.FilaSelecionada;
                    }
                }

                if (fila0 != null)
                {
                    codigoAuxiliar = objUtil.GetAsString("Codigo_Auxiliar", fila0, "0");
                    descripcion    = objUtil.GetAsString("Descripcion", fila0);
                }

                txtCentroCosto.Text            = codigoAuxiliar;
                lblDescripcionCentroCosto.Text = descripcion;
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
        }
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     WinControl_ELR_NET.MyColumna myColumna1 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna2 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna myColumna3 = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.Valida    valida1    = new WinControl_ELR_NET.Valida();
     WinControl_ELR_NET.Valida    valida2    = new WinControl_ELR_NET.Valida();
     WinControl_ELR_NET.Valida    valida3    = new WinControl_ELR_NET.Valida();
     this.cboTipoTransaccion = new WinControl_ELR_NET.ELRCombobox();
     this.txtMonto           = new WinControl_ELR_NET.ELRTextBox();
     this.txtConcepto        = new WinControl_ELR_NET.ELRTextBox();
     this.panel1             = new System.Windows.Forms.Panel();
     this.label1             = new System.Windows.Forms.Label();
     this.label2             = new System.Windows.Forms.Label();
     this.txtCedulaRNC       = new WinControl_ELR_NET.ELRTextBox();
     this.btnBuscarEntidad   = new WinControl_ELR_NET.ELRBotonBuscar();
     this.label3             = new System.Windows.Forms.Label();
     this.txtNombreEntidad   = new WinControl_ELR_NET.ELRTextBox();
     this.label4             = new System.Windows.Forms.Label();
     this.lblMontoLetra      = new System.Windows.Forms.Label();
     this.label5             = new System.Windows.Forms.Label();
     this.pnBotones.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.DSDatos)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.MyErrorProvider)).BeginInit();
     this.panel1.SuspendLayout();
     this.SuspendLayout();
     //
     // pnBotones
     //
     this.pnBotones.Location = new System.Drawing.Point(0, 355);
     this.pnBotones.Size     = new System.Drawing.Size(684, 43);
     this.pnBotones.TabIndex = 11;
     //
     // btnGrabar
     //
     this.btnGrabar.Location = new System.Drawing.Point(490, 0);
     this.btnGrabar.TabIndex = 0;
     //
     // btnCancelar
     //
     this.btnCancelar.Location = new System.Drawing.Point(585, 0);
     this.btnCancelar.TabIndex = 1;
     //
     // btnSiguientePage
     //
     this.btnSiguientePage.Location = new System.Drawing.Point(395, 0);
     //
     // cboTipoTransaccion
     //
     this.cboTipoTransaccion.AValidar           = null;
     this.cboTipoTransaccion.CampoData          = "Tipo_Trans";
     this.cboTipoTransaccion.CampoJoinCombobox2 = "";
     this.cboTipoTransaccion.ComboboxAFiltrar   = null;
     this.cboTipoTransaccion.DisplayMember      = "Descripcion";
     this.cboTipoTransaccion.DSData             = this.DSDatos;
     this.cboTipoTransaccion.EsEditable         = true;
     this.cboTipoTransaccion.FiltroBusqueda     = "EsActivo = 1 And Tipo_Trans > 0 and EsOtro = 1";
     this.cboTipoTransaccion.FormattingEnabled  = true;
     this.cboTipoTransaccion.Location           = new System.Drawing.Point(156, 10);
     this.cboTipoTransaccion.Name                = "cboTipoTransaccion";
     this.cboTipoTransaccion.NombreTabla         = "";
     this.cboTipoTransaccion.Size                = new System.Drawing.Size(507, 29);
     this.cboTipoTransaccion.SSQL                = "";
     this.cboTipoTransaccion.TabIndex            = 1;
     this.cboTipoTransaccion.TablaOVistaConsulta = "TCAJAS_TIPO_TRANS";
     this.cboTipoTransaccion.UsaDataGlobal       = false;
     this.cboTipoTransaccion.ValorPorDefecto     = "0";
     this.cboTipoTransaccion.ValueMember         = "Tipo_Trans";
     //
     // txtMonto
     //
     this.txtMonto.AMostrar            = null;
     this.txtMonto.AValidar            = null;
     this.txtMonto.CampoBusquedaID     = "";
     this.txtMonto.CampoData           = "Monto";
     this.txtMonto.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtMonto.ColumnasBusqGeneral = null;
     this.txtMonto.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtMonto.Decimales           = 0;
     this.txtMonto.DSData              = this.DSDatos;
     this.txtMonto.EsAutoGenerado      = false;
     this.txtMonto.EsBusqueda          = false;
     this.txtMonto.EsEditable          = true;
     this.txtMonto.FiltroBusqueda      = "";
     this.txtMonto.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.txtMonto.Location            = new System.Drawing.Point(158, 163);
     this.txtMonto.Name                = "txtMonto";
     this.txtMonto.NombreTabla         = "";
     this.txtMonto.SepDecimal          = '\0';
     this.txtMonto.Size                = new System.Drawing.Size(164, 29);
     this.txtMonto.TabIndex            = 7;
     this.txtMonto.TablaOVistaBusqueda = "";
     this.txtMonto.TextAlign           = System.Windows.Forms.HorizontalAlignment.Right;
     this.txtMonto.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtMonto.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtMonto.ValorPorDefecto     = "0.00";
     this.txtMonto.Leave              += new System.EventHandler(this.txtMonto_Leave);
     //
     // txtConcepto
     //
     this.txtConcepto.AMostrar            = null;
     this.txtConcepto.AValidar            = null;
     this.txtConcepto.CampoBusquedaID     = "";
     this.txtConcepto.CampoData           = "Concepto";
     this.txtConcepto.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtConcepto.ColumnasBusqGeneral = null;
     this.txtConcepto.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtConcepto.Decimales           = 0;
     this.txtConcepto.DSData              = this.DSDatos;
     this.txtConcepto.EsAutoGenerado      = false;
     this.txtConcepto.EsBusqueda          = false;
     this.txtConcepto.EsEditable          = true;
     this.txtConcepto.FiltroBusqueda      = "";
     this.txtConcepto.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.txtConcepto.Location            = new System.Drawing.Point(158, 235);
     this.txtConcepto.Multiline           = true;
     this.txtConcepto.Name                = "txtConcepto";
     this.txtConcepto.NombreTabla         = "";
     this.txtConcepto.SepDecimal          = '\0';
     this.txtConcepto.Size                = new System.Drawing.Size(500, 105);
     this.txtConcepto.TabIndex            = 10;
     this.txtConcepto.TablaOVistaBusqueda = "";
     this.txtConcepto.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtConcepto.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtConcepto.ValorPorDefecto     = "";
     //
     // panel1
     //
     this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
     this.panel1.Controls.Add(this.label1);
     this.panel1.Controls.Add(this.cboTipoTransaccion);
     this.panel1.Dock     = System.Windows.Forms.DockStyle.Top;
     this.panel1.Location = new System.Drawing.Point(0, 0);
     this.panel1.Name     = "panel1";
     this.panel1.Size     = new System.Drawing.Size(684, 55);
     this.panel1.TabIndex = 0;
     //
     // label1
     //
     this.label1.AutoSize = true;
     this.label1.Location = new System.Drawing.Point(24, 11);
     this.label1.Name     = "label1";
     this.label1.Size     = new System.Drawing.Size(126, 21);
     this.label1.TabIndex = 0;
     this.label1.Text     = "Tipo Transaccion";
     //
     // label2
     //
     this.label2.AutoSize = true;
     this.label2.Location = new System.Drawing.Point(49, 80);
     this.label2.Name     = "label2";
     this.label2.Size     = new System.Drawing.Size(96, 21);
     this.label2.TabIndex = 1;
     this.label2.Text     = "Cedula\\RNC";
     //
     // txtCedulaRNC
     //
     this.txtCedulaRNC.AMostrar            = null;
     this.txtCedulaRNC.AValidar            = null;
     this.txtCedulaRNC.CampoBusquedaID     = "";
     this.txtCedulaRNC.CampoData           = "CedulaRNC";
     this.txtCedulaRNC.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtCedulaRNC.ColumnasBusqGeneral = null;
     this.txtCedulaRNC.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtCedulaRNC.Decimales           = 0;
     this.txtCedulaRNC.DSData              = this.DSDatos;
     this.txtCedulaRNC.EsAutoGenerado      = false;
     this.txtCedulaRNC.EsBusqueda          = false;
     this.txtCedulaRNC.EsEditable          = true;
     this.txtCedulaRNC.FiltroBusqueda      = "";
     this.txtCedulaRNC.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.txtCedulaRNC.Location            = new System.Drawing.Point(158, 80);
     this.txtCedulaRNC.Name                = "txtCedulaRNC";
     this.txtCedulaRNC.NombreTabla         = "";
     this.txtCedulaRNC.SepDecimal          = '\0';
     this.txtCedulaRNC.Size                = new System.Drawing.Size(164, 29);
     this.txtCedulaRNC.TabIndex            = 2;
     this.txtCedulaRNC.TablaOVistaBusqueda = "";
     this.txtCedulaRNC.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtCedulaRNC.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtCedulaRNC.ValorPorDefecto     = "";
     //
     // btnBuscarEntidad
     //
     this.btnBuscarEntidad.AMostrar = null;
     myColumna1.Ancho               = 100;
     myColumna1.HeaderText          = "Id";
     myColumna1.NombreCampo         = "Entidad_Id";
     myColumna2.Ancho               = 150;
     myColumna2.HeaderText          = "Cedula\\RNC";
     myColumna2.NombreCampo         = "CedulaRNC";
     myColumna3.Ancho               = 250;
     myColumna3.HeaderText          = "Nombre";
     myColumna3.NombreCampo         = "Nombre_Completo";
     this.btnBuscarEntidad.columnas = new WinControl_ELR_NET.MyColumna[] {
         myColumna1,
         myColumna2,
         myColumna3
     };
     this.btnBuscarEntidad.CondicionABuscar  = "Campo_Busqueda Like \'%\' + @aBuscar + \'%\'";
     this.btnBuscarEntidad.CondicionOrderBY  = "";
     this.btnBuscarEntidad.EsAutoIncremental = true;
     this.btnBuscarEntidad.FiltroEstatico    = "EsActivo = 1";
     this.btnBuscarEntidad.Limite            = 100;
     this.btnBuscarEntidad.Location          = new System.Drawing.Point(328, 81);
     this.btnBuscarEntidad.Name                    = "btnBuscarEntidad";
     this.btnBuscarEntidad.Size                    = new System.Drawing.Size(70, 28);
     this.btnBuscarEntidad.TabIndex                = 3;
     this.btnBuscarEntidad.TablaOVista             = "VENTIDADES";
     this.btnBuscarEntidad.Text                    = "Buscar";
     this.btnBuscarEntidad.Titulo                  = "Busqueda General";
     this.btnBuscarEntidad.UseVisualStyleBackColor = true;
     this.btnBuscarEntidad.Click                  += new System.EventHandler(this.btnBuscarEntidad_Click);
     //
     // label3
     //
     this.label3.AutoSize = true;
     this.label3.Location = new System.Drawing.Point(21, 124);
     this.label3.Name     = "label3";
     this.label3.Size     = new System.Drawing.Size(124, 21);
     this.label3.TabIndex = 4;
     this.label3.Text     = "Nombre Entidad";
     //
     // txtNombreEntidad
     //
     this.txtNombreEntidad.AMostrar            = null;
     this.txtNombreEntidad.AValidar            = null;
     this.txtNombreEntidad.CampoBusquedaID     = "";
     this.txtNombreEntidad.CampoData           = "ANombre";
     this.txtNombreEntidad.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtNombreEntidad.ColumnasBusqGeneral = null;
     this.txtNombreEntidad.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtNombreEntidad.Decimales           = 0;
     this.txtNombreEntidad.DSData              = this.DSDatos;
     this.txtNombreEntidad.EsAutoGenerado      = false;
     this.txtNombreEntidad.EsBusqueda          = false;
     this.txtNombreEntidad.EsEditable          = true;
     this.txtNombreEntidad.FiltroBusqueda      = "";
     this.txtNombreEntidad.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.txtNombreEntidad.Location            = new System.Drawing.Point(158, 124);
     this.txtNombreEntidad.Name                = "txtNombreEntidad";
     this.txtNombreEntidad.NombreTabla         = "";
     this.txtNombreEntidad.SepDecimal          = '\0';
     this.txtNombreEntidad.Size                = new System.Drawing.Size(507, 29);
     this.txtNombreEntidad.TabIndex            = 5;
     this.txtNombreEntidad.TablaOVistaBusqueda = "";
     this.txtNombreEntidad.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtNombreEntidad.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtNombreEntidad.ValorPorDefecto     = "";
     //
     // label4
     //
     this.label4.AutoSize = true;
     this.label4.Location = new System.Drawing.Point(89, 163);
     this.label4.Name     = "label4";
     this.label4.Size     = new System.Drawing.Size(56, 21);
     this.label4.TabIndex = 6;
     this.label4.Text     = "Monto";
     //
     // lblMontoLetra
     //
     this.lblMontoLetra.AutoSize = true;
     this.lblMontoLetra.Font     = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Italic, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.lblMontoLetra.Location = new System.Drawing.Point(151, 199);
     this.lblMontoLetra.Name     = "lblMontoLetra";
     this.lblMontoLetra.Size     = new System.Drawing.Size(137, 21);
     this.lblMontoLetra.TabIndex = 8;
     this.lblMontoLetra.Text     = "MONTO EN LETRA";
     //
     // label5
     //
     this.label5.AutoSize = true;
     this.label5.Location = new System.Drawing.Point(69, 235);
     this.label5.Name     = "label5";
     this.label5.Size     = new System.Drawing.Size(76, 21);
     this.label5.TabIndex = 9;
     this.label5.Text     = "Concepto";
     //
     // FormCajaReciboOtrosIngresos
     //
     this.AutoScaleDimensions = new System.Drawing.SizeF(9F, 21F);
     this.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
     valida1.comtrol          = this.cboTipoTransaccion;
     valida1.Mensaje          = "Debe Indicar el Tipo de Transaccion";
     valida1.NombreCampo      = "Tipo_Trans";
     valida1.TipoValidacion   = WinControl_ELR_NET.tbTipoValidacion.NoVacio;
     valida1.Valor1           = null;
     valida1.Valor2           = null;
     valida2.comtrol          = this.txtMonto;
     valida2.Mensaje          = "El Monto Debe Ser Mayor a Cero";
     valida2.NombreCampo      = "Monto";
     valida2.TipoValidacion   = WinControl_ELR_NET.tbTipoValidacion.MayorOIgualA;
     valida2.Valor1           = "1";
     valida2.Valor2           = null;
     valida3.comtrol          = this.txtConcepto;
     valida3.Mensaje          = "Debe Indicar un Concepto Minimo 15 Caracteres";
     valida3.NombreCampo      = "Concepto";
     valida3.TipoValidacion   = WinControl_ELR_NET.tbTipoValidacion.LongitudMinima;
     valida3.Valor1           = "15";
     valida3.Valor2           = null;
     this.AValidar            = new WinControl_ELR_NET.Valida[] {
         valida1,
         valida2,
         valida3
     };
     this.ClientSize = new System.Drawing.Size(684, 398);
     this.Controls.Add(this.txtConcepto);
     this.Controls.Add(this.label5);
     this.Controls.Add(this.lblMontoLetra);
     this.Controls.Add(this.txtMonto);
     this.Controls.Add(this.label4);
     this.Controls.Add(this.txtNombreEntidad);
     this.Controls.Add(this.label3);
     this.Controls.Add(this.btnBuscarEntidad);
     this.Controls.Add(this.txtCedulaRNC);
     this.Controls.Add(this.label2);
     this.Controls.Add(this.panel1);
     this.Cursor              = System.Windows.Forms.Cursors.Default;
     this.EnEjecusion         = true;
     this.EsConTemporal       = true;
     this.FormaImprimir       = WinControl_ELR_NET.tbTipoImpresion.Ticket;
     this.ImprimirAlGrabar    = true;
     this.MostrarDesglosePago = true;
     this.Name                = "FormCajaReciboOtrosIngresos";
     this.NombreCampoID       = "Recibo_Id";
     this.NombreReporte       = "RptReciboCajaOtros";
     this.NombreVistaImprimir = "VCAJAS_RECIBOS";
     this.RequiereCajaAbierta = true;
     this.SPGraba             = "SP_CAJAS_GRABA_RECIBO_OTROS_INGRESOS";
     this.TablaEncabezado     = "TTEMPORAL_CAJAS_RECIBOS";
     this.Text                = "REGISTRAR RECIBO OTROS INGRESOS";
     this.Load               += new System.EventHandler(this.FormCajaReciboOtrosIngresos_Load);
     this.Controls.SetChildIndex(this.pnBotones, 0);
     this.Controls.SetChildIndex(this.panel1, 0);
     this.Controls.SetChildIndex(this.label2, 0);
     this.Controls.SetChildIndex(this.txtCedulaRNC, 0);
     this.Controls.SetChildIndex(this.btnBuscarEntidad, 0);
     this.Controls.SetChildIndex(this.label3, 0);
     this.Controls.SetChildIndex(this.txtNombreEntidad, 0);
     this.Controls.SetChildIndex(this.label4, 0);
     this.Controls.SetChildIndex(this.txtMonto, 0);
     this.Controls.SetChildIndex(this.lblMontoLetra, 0);
     this.Controls.SetChildIndex(this.label5, 0);
     this.Controls.SetChildIndex(this.txtConcepto, 0);
     this.pnBotones.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.DSDatos)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.MyErrorProvider)).EndInit();
     this.panel1.ResumeLayout(false);
     this.panel1.PerformLayout();
     this.ResumeLayout(false);
     this.PerformLayout();
 }
Ejemplo n.º 13
0
        public override void HandleCellKeyDown(object sender, KeyEventArgs e)
        {
            //base.HandleCellKeyDown(sender, e);
            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;
            bool esCol1 = false;

            try
            {
                if (COLUMNA_ACTUAL_GRID_DETALLE == "CUENTA_CONTABLE")
                {
                    esCol1 = true;

                    if (e.KeyCode == Keys.F9)
                    {
                        //Vamos a Buscar el Producto
                        frm.titulo         = @"CUENTAS CONTABLES";
                        frm.TablaOVista    = "TCONTA_CATALOGO";
                        frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString() + " And EsControl = 0 And EsMovimiento = 1";
                        frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                        col             = new WinControl_ELR_NET.MyColumna();
                        col.NombreCampo = "Cuenta_Contable";
                        col.HeaderText  = "Cuenta Contable";
                        col.Ancho       = 140;
                        frm.columnas[0] = col;

                        col             = new WinControl_ELR_NET.MyColumna();
                        col.NombreCampo = "Descripcion";
                        col.HeaderText  = "Descripcion";
                        col.Ancho       = -1;
                        frm.columnas[1] = col;

                        frm.ShowDialog();

                        if (frm.FilaSelecionada != null)
                        {
                            DRCuentasContables = frm.FilaSelecionada;
                            //Mandamos el Focus a la columna Cantidad
                            DataGridDetalle.CurrentCell = DataGridDetalle["Codigo_Auxiliar", DataGridDetalle.CurrentRow.Index];
                            DataGridDetalle.BeginEdit(true);
                        }
                    }
                }

                if ((COLUMNA_ACTUAL_GRID_DETALLE == "CODIGO_AUXILIAR") && (esCol1 == false))
                {
                    if (e.KeyCode == Keys.F9)
                    {
                        //Vamos a Buscar el Producto
                        frm.titulo         = @"0FICINA 0 CENTRO DE COSOTO";
                        frm.TablaOVista    = "VCONTA_AUXILIARES";
                        frm.FiltroEstatico = "Empresa_Id  = " + EMPRESA_ID.ToString();
                        frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                        col             = new WinControl_ELR_NET.MyColumna();
                        col.NombreCampo = "Codigo_Auxiliar";
                        col.HeaderText  = "Codigo";
                        col.Ancho       = 120;
                        frm.columnas[0] = col;

                        col             = new WinControl_ELR_NET.MyColumna();
                        col.NombreCampo = "Descripcion";
                        col.HeaderText  = "Descripcion";
                        col.Ancho       = -1;
                        frm.columnas[1] = col;

                        frm.ShowDialog();

                        if (frm.FilaSelecionada != null)
                        {
                            DRAuxiliares = frm.FilaSelecionada;
                            //Mandamos el Focus a la columna Cantidad
                            DataGridDetalle.CurrentCell = DataGridDetalle["Debito", DataGridDetalle.CurrentRow.Index];
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
            finally
            {
                frm.Dispose();
            }
        }
        void GetCuentaContable(string aBuscar = "")
        {
            DataTable DTData;
            DataRow   fila0 = null;

            WinControl_ELR_NET.ELRFormBusquedaGeneral frm = new WinControl_ELR_NET.ELRFormBusquedaGeneral();
            WinControl_ELR_NET.MyColumna col;

            try
            {
                if ((aBuscar.Trim() != "") && (aBuscar.Trim() != ""))
                {
                    objDB.LimpiarFiltros();
                    objDB.AddFiltroIgualA("Cuenta_Contable", aBuscar.Trim());
                    objDB.AddFiltroIgualA("Empresa_Id", EMPRESA_ID.ToString());
                    objDB.AddFiltroIgualA("EsControl", "0");
                    DTData = objDB.GetAll("TCONTA_CATALOGO", 1, objDB.Filtros);
                    if (DTData.Rows.Count > 0)
                    {
                        fila0 = DTData.Rows[0];
                    }
                }
                else
                {
                    //Realizamos una Busqueda General
                    frm.titulo         = @"CUENTAS CONTABLE";
                    frm.TablaOVista    = "TCONTA_CATALOGO";
                    frm.FiltroEstatico = "Empresa_Id = " + EMPRESA_ID.ToString() + " And EsControl = 0";
                    frm.columnas       = new WinControl_ELR_NET.MyColumna[2];


                    col             = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo = "Cuenta_Contable";
                    col.HeaderText  = "Cuenta Contable";
                    col.Ancho       = 150;
                    frm.columnas[0] = col;

                    col             = new WinControl_ELR_NET.MyColumna();
                    col.NombreCampo = "Descripcion";
                    col.HeaderText  = "Descripcion";
                    col.Ancho       = -1;
                    frm.columnas[1] = col;

                    frm.ShowDialog();

                    if (frm.FilaSelecionada != null)
                    {
                        fila0 = frm.FilaSelecionada;
                        txtCuentaContable.drFilaSel = fila0;
                    }
                }

                if (fila0 != null)
                {
                    txtCuentaContable.Text = objUtil.GetAsString("Cuenta_Contable", fila0);
                }
            }
            catch (Exception ex)
            {
                objUtil.MostrarMensajeError(ex.Message);
            }
        }
Ejemplo n.º 15
0
 /// <summary>
 /// Required method for Designer support - do not modify
 /// the contents of this method with the code editor.
 /// </summary>
 private void InitializeComponent()
 {
     WinControl_ELR_NET.ControlesMostrar controlesMostrar1 = new WinControl_ELR_NET.ControlesMostrar();
     WinControl_ELR_NET.ControlesMostrar controlesMostrar2 = new WinControl_ELR_NET.ControlesMostrar();
     WinControl_ELR_NET.MyColumna        myColumna1        = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna        myColumna2        = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.MyColumna        myColumna3        = new WinControl_ELR_NET.MyColumna();
     WinControl_ELR_NET.Valida           valida1           = new WinControl_ELR_NET.Valida();
     WinControl_ELR_NET.Valida           valida2           = new WinControl_ELR_NET.Valida();
     this.txtCedulaRNC = new WinControl_ELR_NET.ELRTextBox();
     this.txtNombre    = new WinControl_ELR_NET.ELRTextBox();
     this.txtTotal     = new WinControl_ELR_NET.ELRTextBox();
     this.txtConcepto  = new WinControl_ELR_NET.ELRTextBox();
     this.groupBox1    = new System.Windows.Forms.GroupBox();
     this.label3       = new System.Windows.Forms.Label();
     this.label2       = new System.Windows.Forms.Label();
     this.elrTextBox1  = new WinControl_ELR_NET.ELRTextBox();
     this.label1       = new System.Windows.Forms.Label();
     this.label4       = new System.Windows.Forms.Label();
     this.elrTextBox4  = new WinControl_ELR_NET.ELRTextBox();
     this.label5       = new System.Windows.Forms.Label();
     this.dtpFecha     = new WinControl_ELR_NET.ELRDatePicker();
     this.label6       = new System.Windows.Forms.Label();
     this.elrTextBox5  = new WinControl_ELR_NET.ELRTextBox();
     this.label7       = new System.Windows.Forms.Label();
     this.elrTextBox6  = new WinControl_ELR_NET.ELRTextBox();
     this.label8       = new System.Windows.Forms.Label();
     this.label9       = new System.Windows.Forms.Label();
     this.pnBotones.SuspendLayout();
     ((System.ComponentModel.ISupportInitialize)(this.DSDatos)).BeginInit();
     ((System.ComponentModel.ISupportInitialize)(this.MyErrorProvider)).BeginInit();
     this.groupBox1.SuspendLayout();
     this.SuspendLayout();
     //
     // pnBotones
     //
     this.pnBotones.Location = new System.Drawing.Point(0, 367);
     this.pnBotones.Size     = new System.Drawing.Size(712, 61);
     //
     // btnGrabar
     //
     this.btnGrabar.Location = new System.Drawing.Point(439, 0);
     this.btnGrabar.Size     = new System.Drawing.Size(141, 57);
     //
     // btnCancelar
     //
     this.btnCancelar.DialogResult = System.Windows.Forms.DialogResult.Cancel;
     this.btnCancelar.Location     = new System.Drawing.Point(580, 0);
     this.btnCancelar.Size         = new System.Drawing.Size(128, 57);
     //
     // btnAnterior
     //
     this.btnAnterior.Size = new System.Drawing.Size(95, 57);
     this.toolTip1.SetToolTip(this.btnAnterior, "CTRL + A = Anterior ");
     //
     // btnSiguientePage
     //
     this.btnSiguientePage.Location = new System.Drawing.Point(344, 0);
     this.btnSiguientePage.Size     = new System.Drawing.Size(95, 57);
     this.toolTip1.SetToolTip(this.btnSiguientePage, "CTRL + S = Siguiente ");
     //
     // lblNombreUsuario
     //
     this.lblNombreUsuario.Size = new System.Drawing.Size(249, 57);
     //
     // txtCedulaRNC
     //
     this.txtCedulaRNC.AMostrar            = null;
     this.txtCedulaRNC.autoSenTab          = true;
     this.txtCedulaRNC.AValidar            = null;
     this.txtCedulaRNC.CampoBusquedaID     = "";
     this.txtCedulaRNC.CampoData           = "CedulaRNC";
     this.txtCedulaRNC.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtCedulaRNC.ColumnasBusqGeneral = null;
     this.txtCedulaRNC.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtCedulaRNC.Decimales           = 0;
     this.txtCedulaRNC.DSData                    = this.DSDatos;
     this.txtCedulaRNC.EsAutoGenerado            = false;
     this.txtCedulaRNC.EsBusqueda                = false;
     this.txtCedulaRNC.EsBusquedaAutoIncremental = false;
     this.txtCedulaRNC.EsEditable                = true;
     this.txtCedulaRNC.FiltroBusqueda            = "";
     this.txtCedulaRNC.Formato                   = WinControl_ELR_NET.tbFormato.Default;
     this.txtCedulaRNC.Location                  = new System.Drawing.Point(510, 34);
     this.txtCedulaRNC.Name                = "txtCedulaRNC";
     this.txtCedulaRNC.NombreTabla         = "";
     this.txtCedulaRNC.SepDecimal          = '\0';
     this.txtCedulaRNC.Size                = new System.Drawing.Size(178, 29);
     this.txtCedulaRNC.TabIndex            = 10;
     this.txtCedulaRNC.TablaOVistaBusqueda = "";
     this.txtCedulaRNC.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtCedulaRNC.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtCedulaRNC.ValorPorDefecto     = "";
     //
     // txtNombre
     //
     this.txtNombre.AMostrar            = null;
     this.txtNombre.autoSenTab          = true;
     this.txtNombre.AValidar            = null;
     this.txtNombre.CampoBusquedaID     = "";
     this.txtNombre.CampoData           = "Nombre";
     this.txtNombre.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtNombre.ColumnasBusqGeneral = null;
     this.txtNombre.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtNombre.Decimales           = 0;
     this.txtNombre.DSData                    = this.DSDatos;
     this.txtNombre.EsAutoGenerado            = false;
     this.txtNombre.EsBusqueda                = false;
     this.txtNombre.EsBusquedaAutoIncremental = false;
     this.txtNombre.EsEditable                = true;
     this.txtNombre.FiltroBusqueda            = "";
     this.txtNombre.Formato                   = WinControl_ELR_NET.tbFormato.Default;
     this.txtNombre.Location                  = new System.Drawing.Point(113, 69);
     this.txtNombre.Name                = "txtNombre";
     this.txtNombre.NombreTabla         = "";
     this.txtNombre.SepDecimal          = '\0';
     this.txtNombre.Size                = new System.Drawing.Size(575, 29);
     this.txtNombre.TabIndex            = 12;
     this.txtNombre.TablaOVistaBusqueda = "";
     this.txtNombre.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtNombre.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtNombre.ValorPorDefecto     = "";
     //
     // txtTotal
     //
     this.txtTotal.AMostrar            = null;
     this.txtTotal.autoSenTab          = true;
     this.txtTotal.AValidar            = null;
     this.txtTotal.CampoBusquedaID     = "";
     this.txtTotal.CampoData           = "Total";
     this.txtTotal.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtTotal.ColumnasBusqGeneral = null;
     this.txtTotal.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtTotal.Decimales           = 0;
     this.txtTotal.DSData                    = this.DSDatos;
     this.txtTotal.EsAutoGenerado            = false;
     this.txtTotal.EsBusqueda                = false;
     this.txtTotal.EsBusquedaAutoIncremental = false;
     this.txtTotal.EsEditable                = true;
     this.txtTotal.FiltroBusqueda            = "";
     this.txtTotal.Font                = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.txtTotal.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.txtTotal.Location            = new System.Drawing.Point(510, 174);
     this.txtTotal.Name                = "txtTotal";
     this.txtTotal.NombreTabla         = "";
     this.txtTotal.SepDecimal          = '\0';
     this.txtTotal.Size                = new System.Drawing.Size(178, 29);
     this.txtTotal.TabIndex            = 17;
     this.txtTotal.TablaOVistaBusqueda = "";
     this.txtTotal.Text                = "0.00";
     this.txtTotal.TextAlign           = System.Windows.Forms.HorizontalAlignment.Right;
     this.txtTotal.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtTotal.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtTotal.ValorPorDefecto     = "0.00";
     //
     // txtConcepto
     //
     this.txtConcepto.AMostrar            = null;
     this.txtConcepto.autoSenTab          = true;
     this.txtConcepto.AValidar            = null;
     this.txtConcepto.CampoBusquedaID     = "";
     this.txtConcepto.CampoData           = "Concepto";
     this.txtConcepto.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.txtConcepto.ColumnasBusqGeneral = null;
     this.txtConcepto.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.txtConcepto.Decimales           = 0;
     this.txtConcepto.DSData                    = this.DSDatos;
     this.txtConcepto.EsAutoGenerado            = false;
     this.txtConcepto.EsBusqueda                = false;
     this.txtConcepto.EsBusquedaAutoIncremental = false;
     this.txtConcepto.EsEditable                = true;
     this.txtConcepto.FiltroBusqueda            = "";
     this.txtConcepto.Formato                   = WinControl_ELR_NET.tbFormato.Default;
     this.txtConcepto.Location                  = new System.Drawing.Point(135, 260);
     this.txtConcepto.Multiline                 = true;
     this.txtConcepto.Name                = "txtConcepto";
     this.txtConcepto.NombreTabla         = "";
     this.txtConcepto.ScrollBars          = System.Windows.Forms.ScrollBars.Both;
     this.txtConcepto.SepDecimal          = '\0';
     this.txtConcepto.Size                = new System.Drawing.Size(553, 101);
     this.txtConcepto.TabIndex            = 19;
     this.txtConcepto.TablaOVistaBusqueda = "";
     this.txtConcepto.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.txtConcepto.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.txtConcepto.ValorPorDefecto     = "";
     //
     // groupBox1
     //
     this.groupBox1.Controls.Add(this.txtNombre);
     this.groupBox1.Controls.Add(this.label3);
     this.groupBox1.Controls.Add(this.txtCedulaRNC);
     this.groupBox1.Controls.Add(this.label2);
     this.groupBox1.Controls.Add(this.elrTextBox1);
     this.groupBox1.Controls.Add(this.label1);
     this.groupBox1.Dock     = System.Windows.Forms.DockStyle.Top;
     this.groupBox1.Location = new System.Drawing.Point(0, 0);
     this.groupBox1.Name     = "groupBox1";
     this.groupBox1.Size     = new System.Drawing.Size(712, 116);
     this.groupBox1.TabIndex = 1;
     this.groupBox1.TabStop  = false;
     this.groupBox1.Text     = "Datos del Suplidor";
     //
     // label3
     //
     this.label3.AutoSize = true;
     this.label3.Location = new System.Drawing.Point(26, 69);
     this.label3.Name     = "label3";
     this.label3.Size     = new System.Drawing.Size(71, 21);
     this.label3.TabIndex = 11;
     this.label3.Text     = "Nombre:";
     //
     // label2
     //
     this.label2.AutoSize = true;
     this.label2.Location = new System.Drawing.Point(408, 34);
     this.label2.Name     = "label2";
     this.label2.Size     = new System.Drawing.Size(96, 21);
     this.label2.TabIndex = 9;
     this.label2.Text     = "Cedula\\RNC";
     //
     // elrTextBox1
     //
     controlesMostrar1.ComboBoxControl      = null;
     controlesMostrar1.EsHabilitar          = false;
     controlesMostrar1.Formato              = "";
     controlesMostrar1.LabelControl         = null;
     controlesMostrar1.NombreCampo          = "CedulaRNC";
     controlesMostrar1.NumericUpDownControl = null;
     controlesMostrar1.TextBoxControl       = this.txtCedulaRNC;
     controlesMostrar1.ValorPorDefecto      = "";
     controlesMostrar2.ComboBoxControl      = null;
     controlesMostrar2.EsHabilitar          = false;
     controlesMostrar2.Formato              = "";
     controlesMostrar2.LabelControl         = null;
     controlesMostrar2.NombreCampo          = "Nombre_Completo";
     controlesMostrar2.NumericUpDownControl = null;
     controlesMostrar2.TextBoxControl       = this.txtNombre;
     controlesMostrar2.ValorPorDefecto      = "";
     this.elrTextBox1.AMostrar              = new WinControl_ELR_NET.ControlesMostrar[] {
         controlesMostrar1,
         controlesMostrar2
     };
     this.elrTextBox1.autoSenTab      = true;
     this.elrTextBox1.AValidar        = null;
     this.elrTextBox1.CampoBusquedaID = "Entidad_Id";
     this.elrTextBox1.CampoData       = "Suplidor_Id";
     this.elrTextBox1.CharacterCasing = System.Windows.Forms.CharacterCasing.Upper;
     myColumna1.Ancho       = 100;
     myColumna1.Formato     = "";
     myColumna1.HeaderText  = "Codigo";
     myColumna1.NombreCampo = "Entidad_Id";
     myColumna2.Ancho       = 150;
     myColumna2.Formato     = "";
     myColumna2.HeaderText  = "CedulaRNC";
     myColumna2.NombreCampo = "CedulaRNC";
     myColumna3.Ancho       = 350;
     myColumna3.Formato     = "";
     myColumna3.HeaderText  = "Nombre_Completo";
     myColumna3.NombreCampo = "Nombre_Completo";
     this.elrTextBox1.ColumnasBusqGeneral = new WinControl_ELR_NET.MyColumna[] {
         myColumna1,
         myColumna2,
         myColumna3
     };
     this.elrTextBox1.CondicionABuscar          = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.elrTextBox1.Decimales                 = 0;
     this.elrTextBox1.DSData                    = this.DSDatos;
     this.elrTextBox1.EsAutoGenerado            = false;
     this.elrTextBox1.EsBusqueda                = true;
     this.elrTextBox1.EsBusquedaAutoIncremental = false;
     this.elrTextBox1.EsEditable                = true;
     this.elrTextBox1.FiltroBusqueda            = "EsSuplidor = 1 And EsActivo = 1";
     this.elrTextBox1.Formato                   = WinControl_ELR_NET.tbFormato.Default;
     this.elrTextBox1.Location                  = new System.Drawing.Point(113, 34);
     this.elrTextBox1.Name                = "elrTextBox1";
     this.elrTextBox1.NombreTabla         = "";
     this.elrTextBox1.SepDecimal          = '\0';
     this.elrTextBox1.Size                = new System.Drawing.Size(131, 29);
     this.elrTextBox1.TabIndex            = 8;
     this.elrTextBox1.TablaOVistaBusqueda = "VENTIDADES";
     this.elrTextBox1.Text                = "0";
     this.elrTextBox1.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.elrTextBox1.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.elrTextBox1.ValorPorDefecto     = "0";
     //
     // label1
     //
     this.label1.AutoSize = true;
     this.label1.Location = new System.Drawing.Point(26, 34);
     this.label1.Name     = "label1";
     this.label1.Size     = new System.Drawing.Size(72, 21);
     this.label1.TabIndex = 7;
     this.label1.Text     = "Suplidor:";
     //
     // label4
     //
     this.label4.AutoSize = true;
     this.label4.Font     = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.label4.Location = new System.Drawing.Point(25, 142);
     this.label4.Name     = "label4";
     this.label4.Size     = new System.Drawing.Size(101, 21);
     this.label4.TabIndex = 8;
     this.label4.Text     = "Factura No.:";
     //
     // elrTextBox4
     //
     this.elrTextBox4.AMostrar            = null;
     this.elrTextBox4.autoSenTab          = true;
     this.elrTextBox4.AValidar            = null;
     this.elrTextBox4.CampoBusquedaID     = "";
     this.elrTextBox4.CampoData           = "Factura_Numero";
     this.elrTextBox4.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.elrTextBox4.ColumnasBusqGeneral = null;
     this.elrTextBox4.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.elrTextBox4.Decimales           = 0;
     this.elrTextBox4.DSData                    = this.DSDatos;
     this.elrTextBox4.EsAutoGenerado            = false;
     this.elrTextBox4.EsBusqueda                = false;
     this.elrTextBox4.EsBusquedaAutoIncremental = false;
     this.elrTextBox4.EsEditable                = true;
     this.elrTextBox4.FiltroBusqueda            = "";
     this.elrTextBox4.Font                = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.elrTextBox4.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.elrTextBox4.Location            = new System.Drawing.Point(135, 142);
     this.elrTextBox4.Name                = "elrTextBox4";
     this.elrTextBox4.NombreTabla         = "";
     this.elrTextBox4.SepDecimal          = '\0';
     this.elrTextBox4.Size                = new System.Drawing.Size(194, 29);
     this.elrTextBox4.TabIndex            = 9;
     this.elrTextBox4.TablaOVistaBusqueda = "";
     this.elrTextBox4.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.elrTextBox4.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.elrTextBox4.ValorPorDefecto     = "";
     //
     // label5
     //
     this.label5.AutoSize = true;
     this.label5.Font     = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.label5.Location = new System.Drawing.Point(63, 214);
     this.label5.Name     = "label5";
     this.label5.Size     = new System.Drawing.Size(58, 21);
     this.label5.TabIndex = 10;
     this.label5.Text     = "Fecha:";
     //
     // dtpFecha
     //
     this.dtpFecha.AValidar        = null;
     this.dtpFecha.CampoData       = "Factura_Fecha";
     this.dtpFecha.DSData          = this.DSDatos;
     this.dtpFecha.EsEditable      = true;
     this.dtpFecha.FiltroBusqueda  = "";
     this.dtpFecha.Font            = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.dtpFecha.Format          = System.Windows.Forms.DateTimePickerFormat.Short;
     this.dtpFecha.Location        = new System.Drawing.Point(135, 212);
     this.dtpFecha.Name            = "dtpFecha";
     this.dtpFecha.NombreTabla     = "";
     this.dtpFecha.Size            = new System.Drawing.Size(194, 29);
     this.dtpFecha.TabIndex        = 11;
     this.dtpFecha.ValorPorDefecto = new System.DateTime(2016, 7, 9, 0, 0, 0, 0);
     //
     // label6
     //
     this.label6.AutoSize = true;
     this.label6.Font     = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.label6.Location = new System.Drawing.Point(74, 179);
     this.label6.Name     = "label6";
     this.label6.Size     = new System.Drawing.Size(45, 21);
     this.label6.TabIndex = 12;
     this.label6.Text     = "NCF:";
     //
     // elrTextBox5
     //
     this.elrTextBox5.AMostrar            = null;
     this.elrTextBox5.autoSenTab          = true;
     this.elrTextBox5.AValidar            = null;
     this.elrTextBox5.CampoBusquedaID     = "";
     this.elrTextBox5.CampoData           = "NCF";
     this.elrTextBox5.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.elrTextBox5.ColumnasBusqGeneral = null;
     this.elrTextBox5.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.elrTextBox5.Decimales           = 0;
     this.elrTextBox5.DSData                    = this.DSDatos;
     this.elrTextBox5.EsAutoGenerado            = false;
     this.elrTextBox5.EsBusqueda                = false;
     this.elrTextBox5.EsBusquedaAutoIncremental = false;
     this.elrTextBox5.EsEditable                = true;
     this.elrTextBox5.FiltroBusqueda            = "";
     this.elrTextBox5.Font                = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.elrTextBox5.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.elrTextBox5.Location            = new System.Drawing.Point(135, 177);
     this.elrTextBox5.MaxLength           = 19;
     this.elrTextBox5.Name                = "elrTextBox5";
     this.elrTextBox5.NombreTabla         = "";
     this.elrTextBox5.SepDecimal          = '\0';
     this.elrTextBox5.Size                = new System.Drawing.Size(194, 29);
     this.elrTextBox5.TabIndex            = 13;
     this.elrTextBox5.TablaOVistaBusqueda = "";
     this.elrTextBox5.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.elrTextBox5.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.elrTextBox5.ValorPorDefecto     = "";
     //
     // label7
     //
     this.label7.AutoSize = true;
     this.label7.Font     = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.label7.Location = new System.Drawing.Point(457, 139);
     this.label7.Name     = "label7";
     this.label7.Size     = new System.Drawing.Size(47, 21);
     this.label7.TabIndex = 14;
     this.label7.Text     = "Itbis:";
     //
     // elrTextBox6
     //
     this.elrTextBox6.AMostrar            = null;
     this.elrTextBox6.autoSenTab          = true;
     this.elrTextBox6.AValidar            = null;
     this.elrTextBox6.CampoBusquedaID     = "";
     this.elrTextBox6.CampoData           = "Itbis";
     this.elrTextBox6.CharacterCasing     = System.Windows.Forms.CharacterCasing.Upper;
     this.elrTextBox6.ColumnasBusqGeneral = null;
     this.elrTextBox6.CondicionABuscar    = " Campo_Busqueda Like \'%\' + @aBuscar + \'%\' ";
     this.elrTextBox6.Decimales           = 0;
     this.elrTextBox6.DSData                    = this.DSDatos;
     this.elrTextBox6.EsAutoGenerado            = false;
     this.elrTextBox6.EsBusqueda                = false;
     this.elrTextBox6.EsBusquedaAutoIncremental = false;
     this.elrTextBox6.EsEditable                = true;
     this.elrTextBox6.FiltroBusqueda            = "";
     this.elrTextBox6.Font                = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.elrTextBox6.Formato             = WinControl_ELR_NET.tbFormato.Default;
     this.elrTextBox6.Location            = new System.Drawing.Point(510, 139);
     this.elrTextBox6.Name                = "elrTextBox6";
     this.elrTextBox6.NombreTabla         = "";
     this.elrTextBox6.SepDecimal          = '\0';
     this.elrTextBox6.Size                = new System.Drawing.Size(178, 29);
     this.elrTextBox6.TabIndex            = 15;
     this.elrTextBox6.TablaOVistaBusqueda = "";
     this.elrTextBox6.Text                = "0.00";
     this.elrTextBox6.TextAlign           = System.Windows.Forms.HorizontalAlignment.Right;
     this.elrTextBox6.TipoCampoBusqueda   = WinControl_ELR_NET.tbTipoCampoBusqueda.Id;
     this.elrTextBox6.TituloBusqueda      = "BUSQUEDA GENERAL";
     this.elrTextBox6.ValorPorDefecto     = "0.00";
     //
     // label8
     //
     this.label8.AutoSize = true;
     this.label8.Font     = new System.Drawing.Font("Segoe UI", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
     this.label8.Location = new System.Drawing.Point(452, 174);
     this.label8.Name     = "label8";
     this.label8.Size     = new System.Drawing.Size(52, 21);
     this.label8.TabIndex = 16;
     this.label8.Text     = "Total:";
     //
     // label9
     //
     this.label9.AutoSize = true;
     this.label9.Location = new System.Drawing.Point(37, 260);
     this.label9.Name     = "label9";
     this.label9.Size     = new System.Drawing.Size(79, 21);
     this.label9.TabIndex = 18;
     this.label9.Text     = "Concepto:";
     //
     // FormOtrosGastosR
     //
     this.AcceptButton        = this.btnGrabar;
     this.AutoScaleDimensions = new System.Drawing.SizeF(9F, 21F);
     this.AutoScaleMode       = System.Windows.Forms.AutoScaleMode.Font;
     valida1.comtrol          = this.txtTotal;
     valida1.Mensaje          = "El Monto Debe Ser Mayor a Cero";
     valida1.NombreCampo      = "Total";
     valida1.TipoValidacion   = WinControl_ELR_NET.tbTipoValidacion.MayorOIgualA;
     valida1.Valor1           = "1";
     valida1.Valor2           = null;
     valida2.comtrol          = this.txtConcepto;
     valida2.Mensaje          = "Debe Indicar un Concepto Valido";
     valida2.NombreCampo      = "Concepto";
     valida2.TipoValidacion   = WinControl_ELR_NET.tbTipoValidacion.LongitudMinima;
     valida2.Valor1           = "5";
     valida2.Valor2           = null;
     this.AValidar            = new WinControl_ELR_NET.Valida[] {
         valida1,
         valida2
     };
     this.CancelButton = this.btnCancelar;
     this.ClientSize   = new System.Drawing.Size(712, 428);
     this.Controls.Add(this.txtConcepto);
     this.Controls.Add(this.label9);
     this.Controls.Add(this.txtTotal);
     this.Controls.Add(this.label8);
     this.Controls.Add(this.elrTextBox6);
     this.Controls.Add(this.label7);
     this.Controls.Add(this.elrTextBox5);
     this.Controls.Add(this.label6);
     this.Controls.Add(this.dtpFecha);
     this.Controls.Add(this.label5);
     this.Controls.Add(this.elrTextBox4);
     this.Controls.Add(this.label4);
     this.Controls.Add(this.groupBox1);
     this.Cursor          = System.Windows.Forms.Cursors.Default;
     this.EsConTemporal   = true;
     this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;
     this.MaximizeBox     = false;
     this.MensajePregunta = "¿Esta Seguro Que Desea Registrar Este Gasto?";
     this.MinimizeBox     = false;
     this.Name            = "FormOtrosGastosR";
     this.NombreCampoID   = "CXP_Id";
     this.SPGraba         = "SP_CXP_GRABA_GASTOS_OTROS";
     this.TablaEncabezado = "TTEMPORAL_CXP";
     this.Text            = "REGISTRAR OTROS GASTOS";
     this.Load           += new System.EventHandler(this.FormOtrosGastosR_Load);
     this.Controls.SetChildIndex(this.pnBotones, 0);
     this.Controls.SetChildIndex(this.groupBox1, 0);
     this.Controls.SetChildIndex(this.label4, 0);
     this.Controls.SetChildIndex(this.elrTextBox4, 0);
     this.Controls.SetChildIndex(this.label5, 0);
     this.Controls.SetChildIndex(this.dtpFecha, 0);
     this.Controls.SetChildIndex(this.label6, 0);
     this.Controls.SetChildIndex(this.elrTextBox5, 0);
     this.Controls.SetChildIndex(this.label7, 0);
     this.Controls.SetChildIndex(this.elrTextBox6, 0);
     this.Controls.SetChildIndex(this.label8, 0);
     this.Controls.SetChildIndex(this.txtTotal, 0);
     this.Controls.SetChildIndex(this.label9, 0);
     this.Controls.SetChildIndex(this.txtConcepto, 0);
     this.pnBotones.ResumeLayout(false);
     ((System.ComponentModel.ISupportInitialize)(this.DSDatos)).EndInit();
     ((System.ComponentModel.ISupportInitialize)(this.MyErrorProvider)).EndInit();
     this.groupBox1.ResumeLayout(false);
     this.groupBox1.PerformLayout();
     this.ResumeLayout(false);
     this.PerformLayout();
 }