Beispiel #1
0
 public void deleteFav(MainPageItem qy) {
   Cursor cursor = null;
   String where =
       FavTable.USER_ID
           + " = '"
           + MyApplication.getInstance().getCurrentUser().getObjectId()
           + "' AND "
           + FavTable.OBJECT_ID
           + " = '"
           + qy.getObjectId()
           + "'";
   cursor = dbHelper.query(DBHelper.TABLE_NAME, null, where, null, null, null, null);
   if (cursor != null && cursor.getCount() > 0) {
     cursor.moveToFirst();
     int isLove = cursor.getInt(cursor.getColumnIndex(FavTable.IS_LOVE));
     if (isLove == 0) {
       dbHelper.delete(DBHelper.TABLE_NAME, where, null);
     } else {
       ContentValues cv = new ContentValues();
       cv.put(FavTable.IS_FAV, 0);
       dbHelper.update(DBHelper.TABLE_NAME, cv, where, null);
     }
   }
   if (cursor != null) {
     cursor.close();
     dbHelper.close();
   }
 }
Beispiel #2
0
 public boolean updateStatus(int ID, String status) {
   // TODO Auto-generated method stub
   ContentValues values = new ContentValues();
   values.put(GTDSTATUS, status);
   helper.update(TABLE_NAME, values, "smsID=?", new String[] {String.valueOf(ID)});
   return false;
 }
Beispiel #3
0
 public long insertFav(MainPageItem qy) {
   long uri = 0;
   Cursor cursor = null;
   String where =
       FavTable.USER_ID
           + " = '"
           + MyApplication.getInstance().getCurrentUser().getObjectId()
           + "' AND "
           + FavTable.OBJECT_ID
           + " = '"
           + qy.getObjectId()
           + "'";
   cursor = dbHelper.query(DBHelper.TABLE_NAME, null, where, null, null, null, null);
   if (cursor != null && cursor.getCount() > 0) {
     cursor.moveToFirst();
     ContentValues conv = new ContentValues();
     conv.put(FavTable.IS_FAV, 1);
     conv.put(FavTable.IS_LOVE, 1);
     dbHelper.update(DBHelper.TABLE_NAME, conv, where, null);
   } else {
     ContentValues cv = new ContentValues();
     cv.put(FavTable.USER_ID, MyApplication.getInstance().getCurrentUser().getObjectId());
     cv.put(FavTable.OBJECT_ID, qy.getObjectId());
     cv.put(FavTable.IS_LOVE, qy.getMyLove() == true ? 1 : 0);
     cv.put(FavTable.IS_FAV, qy.getMyFav() == true ? 1 : 0);
     uri = dbHelper.insert(DBHelper.TABLE_NAME, null, cv);
   }
   if (cursor != null) {
     cursor.close();
     dbHelper.close();
   }
   return uri;
 }