internal List <LogicItem> SelectAllLogicItemsByLogicId(string id)
{
SQLiteConnection conn = ConnectionToDB();
SQLiteDataReader reader = SelectExecuteSQL(string.Format("select {0} from {1} where logicId = '{2}' order by CAST(sequence AS INTEGER) asc", LogicItem.Column, LogicItem.TableName, id), conn);
List <LogicItem> logicItems = LogicItem.MakeResultSet(reader);
DisconnectionToDB(conn);
return(logicItems);
}
internal List <LogicItem> SelectAllLogicItemsBySlotId(string slotId)
{
SQLiteConnection conn = ConnectionToDB();
SQLiteDataReader reader = SelectExecuteSQL(string.Format("select {0} from {1} l, {2} s where l.logicid = s.logicid and s.oid = '{3}' order by CAST(sequence AS INTEGER) asc", LogicItem.GetPrepixColumn("l"), LogicItem.TableName, Slot.TableName, slotId), conn);
List <LogicItem> logicItems = LogicItem.MakeResultSet(reader);
DisconnectionToDB(conn);
return(logicItems);
}