public PlantCompositeType GetPlantById(int iIdPlant) { var et = new PlantCompositeType(); param = new SqlParameter[1]; param[0] = new SqlParameter("@fiid_plant", SqlDbType.Int) { Value = iIdPlant }; DataTable dt = objDB.ExecStore("sp_getPlantById", param); et.iIdPlant = int.Parse(dt.Rows[0].ItemArray[0].ToString()); et.sDescription = dt.Rows[0].ItemArray[1].ToString(); et.bStatus = bool.Parse(dt.Rows[0].ItemArray[2].ToString()); return(et); }
/// <summary> /// Obtiene todos los Tipos de Cambio /// </summary> /// <returns></returns> public List <PlantCompositeType> getAll() { var lst = new List <PlantCompositeType>(); DataTable dt = objDB.Consult("sp_selectPlant"); foreach (DataRow dr in dt.Rows) { var et = new PlantCompositeType { iIdPlant = int.Parse(dr.ItemArray[0].ToString()), sDescription = dr.ItemArray[1].ToString(), bStatus = bool.Parse(dr.ItemArray[2].ToString()) }; lst.Add(et); } return(lst); }