public static List <BE_Mangueras> Listar_Mangueras_x_ID(BE_Mangueras pBE_Mangueras)
{
IDataReader DataReader = null;
List <BE_Mangueras> oBE_Mangueras = new List <BE_Mangueras>();
try
{
SqlCommand cmd = (SqlCommand)db.GetStoredProcCommand("USP_SEL_MANGUERAS_X_ID");
db.AddInParameter(cmd, "@ID", DbType.String, pBE_Mangueras.ID);
cmd.CommandTimeout = Convert.ToInt32(DuracionConexion.corta);
using (DataReader = db.ExecuteReader(cmd))
{
while (DataReader.Read())
{
oBE_Mangueras.Add(new BE_Mangueras(DataReader, 2));
}
}
return(oBE_Mangueras);
}
catch (Exception ex)
{
throw ex;
}
finally { if (!DataReader.IsClosed)
{
DataReader.Close();
}
}
}
public static List <BE_Mangueras> Listar_Mangueras_x_ID(BE_Mangueras pBE_manguera)
{
try
{
return(DA_Mangueras.Listar_Mangueras_x_ID(pBE_manguera));
}
catch (Exception ex)
{
throw ex;
}
}
private void Listar_Mangueras()
{
List <BE_Mangueras> Listar_Mangueras = new List <BE_Mangueras>();
pBE_mangueras = new BE_Mangueras();
pBL_mangueras = new BL_Mangueras();
Listar_Mangueras = BL_Mangueras.Listar_Mangueras(new BE_Mangueras());
this.cboMang.DataSource = Listar_Mangueras;
this.cboMang.ValueMember = "Str_cod_mangueras";
this.cboMang.DisplayMember = "Str_cod_mangueras";
}
