/**
* 查找包含会议材料的列表
*
* @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 + "'");
}
