/// <summary>
/// Autor: jlucero
/// Fecha: 2015-06-14
/// </summary>
/// <param name="oRq"></param>
/// <returns></returns>
public List <Local> NLista(Request_Local_Select oRq)
{
try
{
return(new DLocal().DLista(oRq));
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Autor: jlucero
/// Fecha: 2015-06-14
/// </summary>
/// <param name="oRq"></param>
/// <returns></returns>
public List <Local> DLista(Request_Local_Select oRq)
{
try
{
List <Local> lSe = new List <Local>();
using (IDataReader iDr = DatabaseFactory.CreateDatabase().ExecuteReader("dsige_local_select", oRq.emp_id))
{
if (iDr != null)
{
while (iDr.Read())
{
lSe.Add(
new Local()
{
loc_id = Convert.ToInt32(iDr["loc_id"]),
emp_id = Convert.ToInt32(iDr["emp_id"]),
loc_nombre = Convert.ToString(iDr["loc_nombre"]),
loc_direccion = Convert.ToString(iDr["loc_direccion"]),
loc_orden = Convert.ToInt32(iDr["loc_orden"]),
loc_latitud = Convert.ToString(iDr["loc_latitud"]),
loc_longitud = Convert.ToString(iDr["loc_longitud"]),
loc_estado = Convert.ToInt32(iDr["loc_estado"])
}
);
}
}
}
return(lSe);
}
catch (Exception e)
{
throw e;
}
}
