public void ConsultaLista(EntradasSalidasCentral Es, ref List <EntradasSalidasCentral> List, Sesion sesion)
{
try
{
CD_Datos cd_datos = new CD_Datos(sesion.Emp_Cnx);
SqlDataReader dr = null;
String[] Parametros =
{
"@Id_Alm",
"@Id_Tm",
"@Referencia",
"@Naturaleza",
"@Movini",
"@Movfin",
"@FechaIni",
"@FechaFin"
};
Object[] Valores =
{
Es.Alm,
Es.Tm,
Es.Ref,
Es.Nat,
Es.MovIni,
Es.MovFin,
DateTime.Parse(Es.Fechaini),
DateTime.Parse(Es.Fechafin)
};
SqlCommand sqlcmd = cd_datos.GenerarSqlCommandNulls("spCatMovimientosCentral_ConsultaLista", ref dr, Parametros, Valores);
EntradasSalidasCentral e;
while (dr.Read())
{
e = new EntradasSalidasCentral();
e.Id_Emp = Convert.ToInt32(dr["Id_Emp"]);
e.Id_Alm = Convert.ToInt32(dr["Id_Alm"]);
e.Id_Tm = Convert.ToInt32(dr["Id_Tm"]);
e.Id_MovC = Convert.ToInt32(dr["Id_MovC"]);
e.MovC_Naturaleza = Convert.ToBoolean(dr["MovC_Naturaleza"]);
e.Almacen = dr["Almacen"].ToString();
e.TipoMov = dr["TipoMov"].ToString();
e.MovC_Fecha = Convert.ToDateTime(dr["MovC_Fecha"]);
e.MovC_Referencia = dr["MovC_Referencia"].ToString();
e.TotalFac = dr["TotalFac"].ToString();
e.TotalCostoEst = dr["TotalCostoEst"].ToString();
e.Variacion = dr["Variacion"].ToString();
List.Add(e);
}
dr.Close();
cd_datos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
throw ex;
}
}