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