public List <Ent_Orce_Inter_Art> get_articulos_atributo(string atributo) { List <Ent_Orce_Inter_Art> list = null; string sqlquery = "USP_ORCE_GET_ART_ATRIBUTOS"; try { using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion)) { if (cn.State == 0) { cn.Open(); } using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@COD_ATR", atributo); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { list = new List <Ent_Orce_Inter_Art>(); while (dr.Read()) { Ent_Orce_Inter_Art ART = new Ent_Orce_Inter_Art(); ART.ARTICULO = dr["ARTICULO"].ToString(); ART.ATRIBUTO = dr["ATRIBUTO"].ToString(); ART.VALOR = Convert.ToBoolean(dr["VALOR"].ToString()); ART.GENERAR = true; list.Add(ART); } } } } } catch (Exception) { list = null; } return(list); }
public List <Ent_Orce_Inter_Art> get_lista_det_art(string cod_orce) { List <Ent_Orce_Inter_Art> list = null; string sqlquery = "[USP_ORCE_GET_INTERFACE_DET_ART]"; try { using (SqlConnection cn = new SqlConnection(Ent_Conexion.conexion)) { if (cn.State == 0) { cn.Open(); } using (SqlCommand cmd = new SqlCommand(sqlquery, cn)) { cmd.CommandTimeout = 0; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@COD_ORCE", cod_orce); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { list = new List <Ent_Orce_Inter_Art>(); while (dr.Read()) { Ent_Orce_Inter_Art ART = new Ent_Orce_Inter_Art(); ART.ARTICULO = dr["ORC_DET_ART"].ToString(); ART.ORC_DET_ART_COD = Convert.ToInt32(dr["ORC_DET_ART_COD"].ToString()); ART.VALOR = Convert.ToBoolean(dr["ORC_DET_EST"].ToString()); ART.GENERAR = (dr["ORC_DET_GEN"].ToString() == "" ? false : Convert.ToBoolean(dr["ORC_DET_GEN"].ToString())); list.Add(ART); } } } } } catch (Exception) { list = null; } return(list); }