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); }