/// <summary>
/// Obtiene el docEntry
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public string ObtenerDocEntry(RangoCAE rangoCAE)
{
string salida = "", consulta = "";
Recordset registro = null;
try
{
registro = ProcConexion.Comp.GetBusinessObject(BoObjectTypes.BoRecordset);
consulta = "SELECT DocEntry FROM [@TFERANGO] WHERE U_TipoDoc = '" + rangoCAE.TipoDocumento +
"' AND U_NumIni = '" + rangoCAE.NumeroInicial + "' AND U_NumFin = '" + rangoCAE.NumeroFinal +
"' AND U_NumAct = '" + rangoCAE.NumeroActual + "' AND U_Serie = '" + rangoCAE.Serie + "'";
registro.DoQuery(consulta);
if (registro.RecordCount > 0)
{
salida = registro.Fields.Item("DocEntry").Value + "";
}
}
catch (Exception)
{
}
finally
{
if (registro != null)
{
//Libera de memoria el objeto registro
System.Runtime.InteropServices.Marshal.ReleaseComObject(registro);
GC.Collect();
}
}
return(salida);
}
/// <summary>
/// Actualiza los rangos activos
/// </summary>
/// <returns></returns>
public bool ActualizarRangosActivos(string nombreGrid, string estado)
{
bool salida = true, salidaTemporal = false;
int i = 0;
string docEntry = "";
Grid gridRango = (Grid)Formulario.Items.Item(nombreGrid).Specific;
while (i < gridRango.DataTable.Rows.Count)
{
RangoCAE rangoCAE = new RangoCAE();
rangoCAE.TipoDocumento = gridRango.DataTable.Columns.Item(0).Cells.Item(i).Value + "";
rangoCAE.Serie = gridRango.DataTable.Columns.Item(2).Cells.Item(i).Value + "";
rangoCAE.NumeroInicial = gridRango.DataTable.Columns.Item(3).Cells.Item(i).Value + "";
rangoCAE.NumeroFinal = gridRango.DataTable.Columns.Item(4).Cells.Item(i).Value + "";
rangoCAE.NumeroActual = gridRango.DataTable.Columns.Item(5).Cells.Item(i).Value + "";
rangoCAE.FechaVencimiento = gridRango.DataTable.Columns.Item(6).Cells.Item(i).Value + "";
ManteUdoRango manteUdoRango = new ManteUdoRango();
docEntry = manteUdoRango.ObtenerDocEntry(rangoCAE);
if (!docEntry.Equals(""))
{
salidaTemporal = manteUdoRango.ActivarRango(docEntry, estado);
if (!salidaTemporal)
{
salida = false;
}
}
else
{
salida = false;
}
i++;
}
return(salida);
}
