public override 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 [tblFormalParameter] WHERE [FunctionID]= " + this._FunctionID_tblFunction.FunctionID + " order by oIndex;";
myCommand.Connection = Common.Conn;
myReader = myCommand.ExecuteReader();
while (myReader.Read())
{
idlist.Add(myReader.GetInt64(myReader.GetOrdinal("PinID")));
}
myReader.Close();
myCommand.Dispose();
// _SqlConnectionConnection.Close();
for (int i = 0; i < idlist.Count; i++)
{
tblFormalParameter tblformalparameter = new tblFormalParameter();
tblformalparameter.PinID = idlist[i];
tblformalparameter.m_FunctionID_tblFunction = m_FunctionID_tblFunction;
tblformalparameter.Select();
this.Add(tblformalparameter);
}
}
catch (SQLiteException ae)
{
System.Windows.Forms.MessageBox.Show(ae.Message);
return(false);
}
return(ret);
}
public void funcsetorder()
{
string str;
int oIndex;
//acknowledge
tblFormalParameter tblformalparameter1;
foreach (tblFunction tblfunction in m_tblFunctionCollection)
{
if (!tblfunction.IsFunction)
{
oIndex = 10;
for (int i = 0; i < tblfunction.m_tblFormalParameterCollection.Count; i++)
{
str = tblfunction.m_tblFormalParameterCollection[i].PinName;
tblformalparameter1 = new tblFormalParameter();
switch (str)
{
case "Mode":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 0;
tblformalparameter1.Update();
break;
case "State":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 1;
tblformalparameter1.Update();
break;
case "ALS":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 2;
tblformalparameter1.Update();
break;
case "ALA":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 3;
tblformalparameter1.Update();
break;
case "ALB":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 4;
tblformalparameter1.Update();
break;
case "AEB":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 5;
tblformalparameter1.Update();
break;
case "OPN":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 6;
tblformalparameter1.Update();
break;
case "OPH":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 7;
tblformalparameter1.Update();
break;
case "OPM":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 8;
tblformalparameter1.Update();
break;
case "MNN":
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = 9;
tblformalparameter1.Update();
break;
default:
tblformalparameter1.PinID = tblfunction.m_tblFormalParameterCollection[i].PinID;
tblformalparameter1.Select();
tblformalparameter1.oIndex = oIndex++;
tblformalparameter1.Update();
break;
}
}
}
}
}