private static List<Usage> List(string Number, int From, int To) { List<Usage> result = new List<Usage> (); QueryBuilder qb = new QueryBuilder (QueryBuilderType.Select); qb.Table (DatabaseTableName); qb.Columns ("id"); if ((From > 0) && (To > 0)) { qb.AddWhere ("'"+ From +"' <= createtimestamp"); qb.AddWhereAND (); qb.AddWhere ("createtimestamp <= '"+ To +"'"); if (Number != string.Empty) { qb.AddWhereAND (); } } if (Number != string.Empty) { // A:004588334660|B:004550460609|45|2|1307363676|1: qb.AddWhere ("type", "=", "1"); qb.AddWhereAND (); qb.AddWhere ("data", "like", "%|A:"+ Number +"|%"); } Query query = Runtime.DBConnection.Query (qb.QueryString); if (query.Success) { while (query.NextRow ()) { try { result.Add (Load (query.GetGuid (qb.ColumnPos ("id")))); } catch {} } } query.Dispose (); query = null; qb = null; return result; }