/** * 查找包含会议材料的列表 * * @param context * @param pageSize * @param pageIndex * @return */ public static HashMap<String, Object> selectDateList( Context context, int pageSize, int pageIndex) { HashMap<String, Object> hm = new HashMap<String, Object>(); SQLiteDatabase db = new DatabaseHelper(context, SaveData.getInstance().getUserCode()).getWritableDatabase(); // 查找总条数 int RecordCount = db.rawQuery("select * from NoticeList where DataSum <> '0'", null).getCount(); hm.put("RecordCount", RecordCount); int from = pageSize * (pageIndex - 1); // System.out.println("from = " + from + "->to:" + pageSize); Cursor mCursor = db.rawQuery( "select * from NoticeList where DataSum <> '0' LIMIT " + from + "," + pageSize, null); ArrayList<HashMap<String, String>> list = new ArrayList<HashMap<String, String>>(); int count = mCursor.getColumnCount(); while (mCursor.moveToNext()) { HashMap<String, String> map = new HashMap<String, String>(); for (int i = 0; i < count; i++) { map.put(mCursor.getColumnName(i), mCursor.getString(i)); } list.add(map); } hm.put("List", list); return hm; }
/** * 查询所有需要提醒开会的通知 * * @param context */ public static ArrayList<HashMap<String, String>> selectIsWarn(Context context) { SQLiteDatabase db = new DatabaseHelper(context, SaveData.getInstance().getUserCode()).getWritableDatabase(); Cursor mCursor = db.rawQuery("select * from NoticeList where IsWarn = 'true'", null); ArrayList<HashMap<String, String>> list = new ArrayList<HashMap<String, String>>(); int count = mCursor.getColumnCount(); while (mCursor.moveToNext()) { HashMap<String, String> map = new HashMap<String, String>(); for (int i = 0; i < count; i++) { map.put(mCursor.getColumnName(i), mCursor.getString(i)); } list.add(map); } return list; }
/** * 根据ReceiverID删除单个记录 * * @param context * @param ReceiverID */ public static void delete(Context context, String ReceiverID) { SQLiteDatabase localSQLiteDatabase = new DatabaseHelper(context, SaveData.getInstance().getUserCode()).getWritableDatabase(); localSQLiteDatabase.delete("NoticeList", "ReceiverID = ?", new String[] {ReceiverID}); localSQLiteDatabase.close(); }
/** * 清空表数据 * * @param paramContext */ public static void truncate(Context context) { SQLiteDatabase db = new DatabaseHelper(context, SaveData.getInstance().getUserCode()).getWritableDatabase(); db.execSQL("delete from NoticeList"); db.close(); }
/** * 设置为不再提醒 * * @param context * @param ReceiverID */ public static void setIsWarn(Context context, String ReceiverID) { SQLiteDatabase db = new DatabaseHelper(context, SaveData.getInstance().getUserCode()).getWritableDatabase(); db.execSQL("update NoticeList set IsWarn='false' where ReceiverID='" + ReceiverID + "'"); }