C# Activity.ManagedQuery方法代码示例

        public static int getNoteIdByGUID(Activity activity, string guid)
        {
            int id = 0;

            // get the notes ids
            string[] whereArgs = { guid };
            ICursor cursor = activity.ManagedQuery(Tomdroid.CONTENT_URI, ID_PROJECTION, Note.GUID+"=?", whereArgs, null);

            // cursor must not be null and must return more than 0 entry
            if (!(cursor == null || cursor.Count == 0)) {

                cursor.MoveToFirst();
                id = cursor.GetInt(cursor.GetColumnIndexOrThrow(Note.ID));
            }
            else {
                // TODO send an error to the user
                TLog.d(TAG, "Cursor returned null or 0 notes");
            }

            return id;
        }

 // gets the titles of the notes present in the db, used in ViewNote.buildLinkifyPattern()
 public static ICursor getTitles(Activity activity)
 {
     string where = Note.TAGS + " NOT LIKE '%system:deleted%'";
     // get a cursor containing the notes titles
     return activity.ManagedQuery(Tomdroid.CONTENT_URI, TITLE_PROJECTION, where, null, null);
 }

        // gets a note from the content provider
        public static Note getNote(Activity activity, Uri uri)
        {
            Note note = null;

            // can we find a matching note?
            ICursor cursor = activity.ManagedQuery(uri, FULL_PROJECTION, null, null, null);
            // cursor must not be null and must return more than 0 entry
            if (!(cursor == null || cursor.Count == 0)) {

                // create the note from the cursor
                cursor.MoveToFirst();
                string noteContent = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.NOTE_CONTENT));
                string noteTitle = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TITLE));
                string noteChangeDate = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.MODIFIED_DATE));
                string noteTags = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TAGS));
                string noteGUID = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.GUID));
                int noteDbid = cursor.GetInt(cursor.GetColumnIndexOrThrow(Note.ID));

                note = new Note();
                note.setTitle(noteTitle);
                note.setXmlContent(stripTitleFromContent(noteContent, noteTitle));
                note.setLastChangeDate(noteChangeDate);
                note.setTags(noteTags);
                note.setGuid(noteGUID);
                note.setDbId(noteDbid);
            }
            cursor.Close();
            return note;
        }

        /**
         * getNewNotes
         * get a guid list of notes that are newer than latest sync date
         * @param activity
         */
        public static ICursor getNewNotes(Activity activity)
        {
            ICursor cursor = activity.ManagedQuery(Tomdroid.CONTENT_URI, DATE_PROJECTION, "strftime('%s', "+Note.MODIFIED_DATE+") > strftime('%s', '"+Preferences.GetString(Preferences.Key.LATEST_SYNC_DATE)+"')", null, null);

            return cursor;
        }

 // gets the ids of the notes present in the db, used in SyncService.deleteNotes()
 public static ICursor getGuids(Activity activity)
 {
     // get a cursor containing the notes guids
     return activity.ManagedQuery(Tomdroid.CONTENT_URI, GUID_PROJECTION, null, null, null);
 }

        // this function gets all non-deleted notes as notes in an array
        public static Note[] getAllNotesAsNotes(Activity activity, bool includeNotebookTemplates)
        {
            Uri uri = Tomdroid.CONTENT_URI;
            string where = "("+Note.TAGS + " NOT LIKE '%" + "system:deleted" + "%')";
            string orderBy;
            if (!includeNotebookTemplates) {
                where += " AND (" + Note.TAGS + " NOT LIKE '%" + "system:template" + "%')";
            }
            orderBy = Note.MODIFIED_DATE + " DESC";
            ICursor cursor = activity.ManagedQuery(uri, FULL_PROJECTION, where, null, orderBy);
            if (cursor == null || cursor.Count == 0) {
                TLog.d(TAG, "no notes in cursor");
                return null;
            }
            TLog.d(TAG, "{0} notes in cursor",cursor.Count);
            Note[] notes = new Note[cursor.Count];
            cursor.MoveToFirst();
            int key = 0;

            while(!cursor.IsAfterLast) {
                string noteContent = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.NOTE_CONTENT));
                string noteTitle = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TITLE));
                string noteChangeDate = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.MODIFIED_DATE));
                string noteTags = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.TAGS));
                string noteGUID = cursor.GetString(cursor.GetColumnIndexOrThrow(Note.GUID));
                int noteDbid = cursor.GetInt(cursor.GetColumnIndexOrThrow(Note.ID));

                Note note = new Note();
                note.setTitle(noteTitle);
                note.setXmlContent(stripTitleFromContent(noteContent, noteTitle));
                note.setLastChangeDate(noteChangeDate);
                note.addTag(noteTags);
                note.setGuid(noteGUID);
                note.setDbId(noteDbid);
                notes[key++] = note;
                cursor.MoveToNext();
            }
            cursor.Close();
            return notes;
        }

 public static ICursor getAllNotes(Activity activity, bool includeNotebookTemplates)
 {
     // get a cursor representing all notes from the NoteProvider
     Uri notes = Tomdroid.CONTENT_URI;
     string where = "("+Note.TAGS + " NOT LIKE '%" + "system:deleted" + "%')";
     if (!includeNotebookTemplates) {
         where += " AND (" + Note.TAGS + " NOT LIKE '%" + "system:template" + "%')";
     }
     return activity.ManagedQuery(notes, LIST_PROJECTION, where, null, sortOrder);
 }