public bool Load() { bool ret = true; List <long> idlist = new List <long>(); SQLiteConnection _SqlConnectionConnection = new SQLiteConnection(Common.ConnectionString); SQLiteDataReader myReader = null; SQLiteCommand myCommand = new SQLiteCommand(); if (_SqlConnectionConnection.State == System.Data.ConnectionState.Open) { _SqlConnectionConnection.Close(); } _SqlConnectionConnection.ConnectionString = Common.ConnectionString; _SqlConnectionConnection.Open(); try { myReader = null; myCommand.CommandText = @"SELECT * FROM [tblPointsPolyline] WHERE [ID]= " + m_ID_tblPolyline.ID + " order by oIndex;"; myCommand.Connection = _SqlConnectionConnection; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { idlist.Add(myReader.GetInt64(myReader.GetOrdinal("PointsPolylineID"))); } myReader.Close(); myCommand.Dispose(); _SqlConnectionConnection.Close(); foreach (long id in idlist)// (int i = 0; i < count ; i++) { tblPointsPolyline tblPointsPolyline = new tblPointsPolyline(); tblPointsPolyline.PointsPolylineID = id; tblPointsPolyline.m_ID_tblPolyline = this.m_ID_tblPolyline; tblPointsPolyline.Select(); Add(tblPointsPolyline); } } catch (SQLiteException ae) { System.Windows.Forms.MessageBox.Show(ae.Message); return(false); } return(ret); }
public bool Contains(tblPointsPolyline item) { return(List.Contains(item)); }
public int IndexOf(tblPointsPolyline item) { return(List.IndexOf(item)); }
public void Insert(int index, tblPointsPolyline item) { List.Insert(index, item); this.OntblPointsPolylineChanged(EventArgs.Empty); }
public void Remove(tblPointsPolyline item) { List.Remove(item); this.OntblPointsPolylineChanged(EventArgs.Empty); }
public void Add(tblPointsPolyline item) { List.Add(item); this.OntblPointsPolylineChanged(EventArgs.Empty); }