private void save() { if (u_Validate()) { tmpcursor = null; var BL = new tb_plla_tab0100BL(); var BE = new tb_plla_tab0100(); BE.norden = 0; tmpcursor = BL.TeleCredito_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; var ofila = tmpcursor.NewRow(); ofila = VariablesPublicas.INSERTINTOTABLE(tmpcursor); ofila["codigo"] = Examinar.Rows[Examinar.CurrentRow.Index].Cells["codigo"].Value; for (lc_cont = 0; lc_cont <= Examinar.ColumnCount - 1; lc_cont++) { xnomcampo = Examinar.Columns[lc_cont].Name; ofila[xnomcampo] = Examinar.Rows[Examinar.CurrentRow.Index].Cells[lc_cont].Value; } ofila["codigo"] = txtcodigo.Text.Trim(); ofila["descripcion"] = txtDescripcion.Text.Trim(); ofila["valor"] = txtvalor.Text.Trim(); tmpcursor.Rows.Add(ofila); if (BL.TeleCredito_InsertUpdate(VariablesPublicas.EmpresaID, BE, tmpcursor)) { 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_plla_tab0100BL(); var BE = new tb_plla_tab0100(); BE.norden = 0; Tabla = BL.TeleCredito_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; if (BL.Sql_Error.Length == 0) { Examinar.AutoGenerateColumns = false; Examinar.DataSource = Tabla; 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["codigo"], System.ComponentModel.ListSortDirection.Ascending); } } else { Sw_LOad = false; Frm_Class.ShowError(BL.Sql_Error, this); } VariablesPublicas.PintaEncabezados(Examinar); }