//private tblSolution _SolutionID_tblSolution;
//[Description("Represents the foreign key object of the type SolutionID")]
//public tblSolution m_SolutionID_tblSolution
//{
// get
// {
// return _SolutionID_tblSolution;
// }
// set
// {
// _SolutionID_tblSolution = value;
// }
//}
public void LoadSymbolFiles()
{
string path = Common.ProjectPath + "Blocks" + this.FullPath;
string nostr;
byte no = 0;;
string symbloname;
string[] filePaths = Directory.GetFiles(path, "*.blk");
foreach (string str in filePaths)
{
symbloname = str.Substring(0, str.Length - 4);
nostr = str.Substring(str.Length - 7, 3);
try
{
no = byte.Parse(nostr);
}
catch (FormatException e)
{
Trace.WriteLine(e.Message);
}
tblSymbolStatus tblsymbolstatus = new tblSymbolStatus();
tblsymbolstatus.m_SymbolID_tblSymbols = this;
tblsymbolstatus.SymbolID = this.SymbolID;
tblsymbolstatus.StatusNo = no;
tblsymbolstatus.Insert();
tblsymbolstatus.LoadSymbolFile(str);
this.m_tblSymbolStatusCollection.Add(tblsymbolstatus);
}
}
public override 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 [tblSymbolStatus] WHERE [SymbolID]= " + this.m_SymbolID_tblSymbols.SymbolID + " order by StatusNo;";
myCommand.Connection = _SqlConnectionConnection;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
idlist.Add(myReader.GetInt64(myReader.GetOrdinal("SymbolStatusID")));
}
myReader.Close();
myCommand.Dispose();
_SqlConnectionConnection.Close();
foreach (long id in idlist)// (int i = 0; i < count ; i++)
{
tblSymbolStatus tblsymbolstatus = new tblSymbolStatus();
tblsymbolstatus.SymbolStatusID = id;
tblsymbolstatus.m_SymbolID_tblSymbols = this.m_SymbolID_tblSymbols;
tblsymbolstatus.Select();
this.Add(tblsymbolstatus);
}
}
catch (SQLiteException ae)
{
System.Windows.Forms.MessageBox.Show(ae.Message);
return(false);
}
return(ret);
}
public tblSymbolBitmapCollection(tblSymbolStatus _parent)
{
_SymbolStatusID_tblSymbolStatus = _parent;
}
public bool Contains(tblSymbolStatus item)
{
return(List.Contains(item));
}
public int IndexOf(tblSymbolStatus item)
{
return(List.IndexOf(item));
}
public void Insert(int index, tblSymbolStatus item)
{
List.Insert(index, item);
this.OntblSymbolStatusChanged(EventArgs.Empty);
}
public void Remove(tblSymbolStatus item)
{
List.Remove(item);
this.OntblSymbolStatusChanged(EventArgs.Empty);
}
public void Add(tblSymbolStatus item)
{
List.Add(item);
this.OntblSymbolStatusChanged(EventArgs.Empty);
}
public tblSymbolADTextCollection(tblSymbolStatus _parent)
{
_SymbolStatusID_tblSymbolStatus = _parent;
}
public tblSymbolLineCollection(tblSymbolStatus _parent)
{
_SymbolStatusID_tblSymbolStatus = _parent;
}
