public int Add(tblFBDBlockPin item)
{
int newindex = List.Add(item);
this.OntblFBDBlockPinChanged(EventArgs.Empty);
return(newindex);
}
public bool Load()
{
bool ret = true;
List <long> idlist = new List <long>();
if (Common.Conn == null)
{
Common.Conn = new SQLiteConnection(Common.ConnectionString);
Common.Conn.Open();
}
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 [tblFBDBlockPin] WHERE [FBDBlockID]= " + this.m_FBDBlockID_tblFBDBlock.FBDBlockID + ";"; // " order by oIndex;";
myCommand.Connection = Common.Conn;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
idlist.Add(myReader.GetInt64(myReader.GetOrdinal("FBDBlockPinID")));
}
myReader.Close();
myCommand.Dispose();
//_SqlConnectionConnection.Close();
for (int i = 0; i < idlist.Count; i++)
{
tblFBDBlockPin tblfbdblockpin = new tblFBDBlockPin();
tblfbdblockpin.FBDBlockPinID = idlist[i];
tblfbdblockpin.m_FBDBlockID_tblFBDBlock = this._FBDBlockID_tblFBDBlock;
tblfbdblockpin.Select();
this.Add(tblfbdblockpin);
}
}
catch (SQLiteException ae)
{
return(false);
// MessageBox.Show(ae.Message.ToString());
}
return(ret);
}
public bool Contains(tblFBDBlockPin item)
{
return(List.Contains(item));
}
public int IndexOf(tblFBDBlockPin item)
{
return(List.IndexOf(item));
}
public void Insert(int index, tblFBDBlockPin item)
{
List.Insert(index, item);
this.OntblFBDBlockPinChanged(EventArgs.Empty);
}
public void Remove(tblFBDBlockPin item)
{
List.Remove(item);
this.OntblFBDBlockPinChanged(EventArgs.Empty);
}
