private Inv_in buildInv_in(MySqlDataReader data)
{
Inv_in item = new Inv_in(
data.GetInt16("id"),
data.GetString("fecha"),
data.GetString("notas"),
data.GetDouble("total"),
data.GetString("Estado")
);
return(item);
}
public List <Inv_in> getListabyId(string id)
{
string query = maq_query + " where id='" + id + "'";
MySqlDataReader data = runQuery(query);
List <Inv_in> result = new List <Inv_in>();
if (data.HasRows)
{
while (data.Read())
{
Inv_in item = buildInv_in(data);
result.Add(item);
}
}
return(result);
}
public List <Inv_in> getListabyAll(string fecha, double total)
{
string query = maq_query + " where fecha='" + fecha + "' and total='" + total.ToString() + "'";
MySqlDataReader data = runQuery(query);
List <Inv_in> result = new List <Inv_in>();
if (data.HasRows)
{
while (data.Read())
{
Inv_in item = buildInv_in(data);
result.Add(item);
}
}
return(result);
}