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();
}
}
public boolean delData(int ID) {
StringBuilder bd = new StringBuilder();
bd.append(GtdTable.SMS_ID).append(" = ?");
return helper.delete(GtdTable.TABLE_NAME, bd.toString(), new String[] {String.valueOf(ID)});
}