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); } }
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(); } }
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(); } }
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(); } }
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); }
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(); }
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); } }
/// <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(); }