private BindingSource NewMethoBcoC() { var BL = new tb_co_tabla03_bancoBL(); var BE = new tb_co_tabla03_banco(); var table = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; var rows = table.Rows; object[] cell; var dic = new Dictionary<string, string>(); var binding = new BindingSource(); foreach (DataRow item in rows) { cell = item.ItemArray; dic.Add(cell[0].ToString(), cell[0].ToString() + " - " + cell[1].ToString()); cell = null; } binding.DataSource = dic; return binding; }
private void Accion(int naccion) { switch (naccion) { case 1: u_n_opsel = 1; U_RefrescaControles(); Blanquear(); var BL = new tb_co_tabla03_bancoBL(); var BE = new tb_co_tabla03_banco(); txtcodigo.Text = BL.GetAllMaxCodigo(VariablesPublicas.EmpresaID, BE).Tables[0].Rows[0]["maximo_codigo"].ToString(); if (Examinar.CurrentRow != null) { Examinar.CurrentRow.Selected = false; } break; case 2: POnedatos(); u_n_opsel = 2; U_RefrescaControles(); Examinar.CurrentRow.Selected = true; break; case 3: xnomcampo = ""; if (xnomcampo.Length == 0) { if (MessageBox.Show("Desea Eliminar Registro ..?", "Mensaje del Sistema", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { var BLCO = new tb_co_tabla03_bancoBL(); var BECO = new tb_co_tabla03_banco(); BECO.codigoid = Examinar.Rows[Examinar.CurrentRow.Index].Cells["codigoid"].Value.ToString(); tmpcursor = BLCO.GetAll(VariablesPublicas.EmpresaID, BECO).Tables[0]; if (BLCO.Sql_Error.Length == 0) { if (BLCO.Delete(VariablesPublicas.EmpresaID, BECO)) { for (lc_cont = 0; lc_cont <= Tabla.Rows.Count - 1; lc_cont++) { if (Tabla.Rows[lc_cont]["codigoid"] == Examinar.Rows[Examinar.CurrentRow.Index].Cells["codigoid"].Value) { Tabla.Rows[lc_cont].Delete(); Tabla.AcceptChanges(); break; } } Examinar.Refresh(); } else { Frm_Class.ShowError(BLCO.Sql_Error, this); } } else { Frm_Class.ShowError(BLCO.Sql_Error, this); } } } else { MessageBox.Show(xnomcampo, "Imposible Eliminar Registro"); } break; } }
private void save() { if (u_Validate()) { tmpcursor = null; var BL = new tb_co_tabla03_bancoBL(); var BE = new tb_co_tabla03_banco(); BE.codigoid = txtcodigo.Text.Trim(); if (u_n_opsel == 1) { tmptabla = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0]; if (tmptabla.Rows.Count > 0) { txtcodigo.Text = BL.GetAllMaxCodigo(VariablesPublicas.EmpresaID, BE).Tables[0].Rows[0]["maximo_codigo"].ToString(); } BE.codigoid = txtcodigo.Text.Trim(); BE.descripcion = txtDescripcion.Text.Trim(); BE.sigla = txtSigla.Text.Trim(); BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Insert(VariablesPublicas.EmpresaID, BE)) { U_CancelarEdicion(0); } else { Frm_Class.ShowError(BL.Sql_Error, this); } } else { BE.codigoid = txtcodigo.Text.Trim(); BE.descripcion = txtDescripcion.Text.Trim(); BE.sigla = txtSigla.Text.Trim(); BE.usuar = VariablesPublicas.Usuar.Trim(); if (BL.Update(VariablesPublicas.EmpresaID, BE)) { U_CancelarEdicion(0); } else { Frm_Class.ShowError(BL.Sql_Error, this); } } } }
private void CargaDatos() { var sorted = default(SortOrder); var xnomcolumna = string.Empty; if (Examinar.SortedColumn != null) { xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name; sorted = Examinar.SortOrder; } var BL = new tb_co_tabla03_bancoBL(); var BE = new tb_co_tabla03_banco(); BE.descripcion = txtBuscar.Text.Trim(); Tabla = BL.GetAll(VariablesPublicas.EmpresaID, BE).Tables[0]; Examinar.AutoGenerateColumns = false; Examinar.DataSource = Tabla; VariablesPublicas.PintaEncabezados(Examinar); if (xnomcolumna.Trim().Length > 0) { if (sorted == SortOrder.Ascending) { Examinar.Sort(Examinar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending); } else { Examinar.Sort(Examinar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending); } } else { Examinar.Sort(Examinar.Columns["codigoid"], System.ComponentModel.ListSortDirection.Ascending); } }
public void U_CargaDatos() { var xpalabra1 = string.Empty; var xpalabra2 = string.Empty; var xpalabra3 = string.Empty; if (txtFilter.Enabled) { xpalabra1 = VariablesPublicas.Palabras(txtFilter.Text.Trim(), 1); xpalabra2 = VariablesPublicas.Palabras(txtFilter.Text.Trim(), 2); xpalabra3 = VariablesPublicas.Palabras(txtFilter.Text.Trim(), 3); } try { var BL = new tb_co_tabla03_bancoBL(); var BE = new tb_co_tabla03_banco(); switch (cboFiltro.SelectedItem.ToString()) { case "Nombre": BE.descripcion = txtFilter.Text.Trim().ToUpper(); break; case "Código": BE.codigoid = txtFilter.Text.Trim().ToUpper(); break; default: BE.codigoid = txtFilter.Text.Trim().ToUpper(); break; } tabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } btnBuscar.Enabled = true; var sorted = default(SortOrder); var xnomcolumna = string.Empty; if ((gridExaminar.SortedColumn != null)) { xnomcolumna = gridExaminar.Columns[gridExaminar.SortedColumn.Index].Name; sorted = gridExaminar.SortOrder; } gridExaminar.AutoGenerateColumns = false; gridExaminar.DataSource = tabla; gridExaminar.AllowUserToResizeRows = false; if (xnomcolumna.Trim().Length > 0) { if (sorted == SortOrder.Ascending) { gridExaminar.Sort(gridExaminar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending); } else { gridExaminar.Sort(gridExaminar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending); } } else { gridExaminar.Sort(gridExaminar.Columns["codigoid"], System.ComponentModel.ListSortDirection.Ascending); } if (gridExaminar.Rows.Count > 0) { gridExaminar.CurrentCell = gridExaminar.Rows[0].Cells["descripcion"]; gridExaminar.Focus(); gridExaminar.BeginEdit(true); } }
internal void ValidaBancos() { Int16 lc_cont; var zhallado = false; var VMNROITEM = gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value.ToString(); var xcodartic = ".."; if (!(gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value == DBNull.Value)) { xcodartic = gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value.ToString(); } if (xcodartic.Trim().Length == 0) { zhallado = true; } else { var BL = new tb_co_tabla03_bancoBL(); var BE = new tb_co_tabla03_banco(); BE.codigoid = xcodartic; tmptabla = BL.GetAll(VariablesPublicas.EmpresaID.ToString(), BE).Tables[0]; for (lc_cont = 0; lc_cont < TablaBancos.Rows.Count; lc_cont++) { if (TablaBancos.Rows[lc_cont]["bancoid"].ToString() == VMNROITEM) { if (tmptabla.Rows.Count > 0) { TablaBancos.Rows[lc_cont]["bancoid"] = tmptabla.Rows[0]["codigoid"]; TablaBancos.Rows[lc_cont]["banconame"] = tmptabla.Rows[0]["descripcion"]; zhallado = true; break; } } } } if (!zhallado) { gridBancos.Rows[gridBancos.CurrentRow.Index].Cells["bancoid"].Value = j_CodBanco; } gridBancos.Refresh(); }