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);
}
