public Entradas()
{
factura = WarehouseManager.ListFactura.facturaGlobal;
InitializeComponent();
ArticuloNuevo = new Entrada();
ArticuloNuevo.IdFactura = factura.IdFactura;
agregar = false;
Update();
}
public List<FacturaProvedor> readFactura(string query)
{
List<FacturaProvedor> facturaList = new List<FacturaProvedor>();
using (SqlConnection con = new SqlConnection(Info.sqlSet()))
{
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
// Loop through each record.
while (reader.Read())
{
FacturaProvedor tmp = new FacturaProvedor();
tmp.IdFactura = (reader.GetValue(0) != DBNull.Value) ? Convert.ToInt32(reader.GetValue(0)) : tmp.IdFactura;
tmp.Provedor = (reader.GetValue(1) != DBNull.Value) ? Convert.ToString(reader.GetValue(1)) : tmp.Provedor;
tmp.NoFactura = (reader.GetValue(2) != DBNull.Value) ? Convert.ToString(reader.GetValue(2)) : tmp.NoFactura;
tmp.Fecha = (reader.GetValue(3) != DBNull.Value) ? Convert.ToDateTime(reader.GetValue(3)) : tmp.Fecha;
facturaList.Add(tmp);
}
}
con.Close();
}
return facturaList;
}
