private RabNamesList getNamesForExport() { RabNamesList result = new RabNamesList(); foreach (ListViewItem lvi in lvNames.Items) { result.Add(lvi.Tag as RabName); } return(result); }
protected EPasportForm() { InitializeComponent(); Client c = new Client(int.MaxValue, "ферма", "Here"); _rabExport = new RabExporter(c, Engine.get().GetDBGuid()); _breeds = Engine.db().GetBreeds(); _names = Engine.db().GetNames(); lvAscendants.ListViewItemSorter = lvNames.ListViewItemSorter = lvBreeds.ListViewItemSorter = new LVSorter(); }
public static RabNamesList GetNames(MySqlConnection sql) { RabNamesList result = new RabNamesList(); MySqlCommand cmd = new MySqlCommand("SELECT n_id, n_sex, n_name, n_surname, n_use, n_block_date FROM names ORDER BY n_name;", sql); MySqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { result.Add(fillName(rd)); } rd.Close(); return(result); }