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