@Override
public boolean add(HThread model) {
mDatabase = mDbOpenHelper.getWritableDatabase();
ContentValues cv = getValue(model);
mDatabase.insert(TABLE_NAME, null, cv);
mDatabase.close();
return super.add(model);
}
@Override
public void add(int location, HThread model) {
mDatabase = mDbOpenHelper.getWritableDatabase();
ContentValues cv = getValue(model);
mDatabase.insert(TABLE_NAME, ID, cv);
mDatabase.close();
super.add(location, model);
}
public void updataDB(HSms sms, HSmsApplication application) {
HLog.i("updata buffer list--------------------->>>");
mDatabase = mDbOpenHelper.getWritableDatabase();
// String where = ADDRESS + "=" + sms.address;
String where = ID + "=" + sms.threadid;
Cursor cursor = mDatabase.query(TABLE_NAME, null, where, null, null, null, null);
int len = sms.address.split(",").length;
if (cursor.getCount() > 0) { // 旧信息
cursor.moveToFirst();
String where1 = ID + "=" + sms.threadid;
HThread model = getHThread(cursor);
String count = cursor.getString(cursor.getColumnIndex(COUNT));
String noReadSmsCount = cursor.getString(cursor.getColumnIndex(NOREADCOUNT));
String type = model.type;
mDatabase.delete(TABLE_NAME, where1, null);
ContentValues values = getValue(model);
if (!sms.type.equals("3")) {
values.put(TYPE, type);
} else {
values.put(TYPE, sms.type);
}
values.put(ADDRESS, sms.address);
values.put(READ, sms.read);
values.put(BODY, sms.body);
values.put(NOREADCOUNT, String.valueOf(Integer.parseInt(noReadSmsCount) + 1));
if (!sms.type.equals("3")) {
values.put(COUNT, String.valueOf(Integer.parseInt(count) + len));
}
values.put(TIME, Long.parseLong(sms.time));
mDatabase.insert(TABLE_NAME, null, values);
} else { // 新信息
HAddressBookManager abm = new HAddressBookManager(application);
HThread thread = new HThread(application);
thread.address = sms.address;
thread.sms.body = sms.body;
thread.count = "1";
thread.sms.threadid = sms.threadid;
thread.name = abm.getNameByNumber(sms.address);
thread.type = sms.type;
thread.sms.read = sms.read;
if (!thread.type.equals("3")) {
thread.count = String.valueOf(len);
}
Bitmap headBp = null;
if (thread.name.split(",").length == 1) {
headBp = abm.getContactPhoto(thread.name, thread.address);
}
thread.headbm = headBp;
thread.mark = "0";
thread.sms.time = sms.time;
ContentValues cv = getValue(thread);
mDatabase.insert(TABLE_NAME, null, cv);
}
cursor.close();
mDatabase.close();
}
/** * 反的进来需要单独更新 */
public void updataName(String name, String address) {
mDatabase = mDbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(NAME, name);
values.put(HEADBM, "1");
String where = ADDRESS + "=" + address;
mDatabase.update(TABLE_NAME, values, where, null);
mDatabase.close();
}
/** 未读改成已读 */
public void updataBufferList(HSms sms) {
if (sms.threadid.equals("")) {
return;
}
mDatabase = mDbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(READ, "1"); // 修改短信为已读模式
String where = ID + "=" + sms.threadid;
mDatabase.update(TABLE_NAME, values, where, null);
mDatabase.close();
}
public boolean cxBuffeListIsNull() {
mDatabase = mDbOpenHelper.getWritableDatabase();
Cursor cur = mDatabase.query(TABLE_NAME, null, null, null, null, null, null);
if (cur.getCount() != 0) {
cur.close();
mDatabase.close();
return false;
}
cur.close();
mDatabase.close();
return true;
}
@Override
public HThread set(int index, HThread model) {
if (mDatabase == null || !mDatabase.isOpen()) {
mDatabase = mDbOpenHelper.getWritableDatabase();
}
ContentValues cv = getValue(model);
String id = model.sms.threadid;
if (id == null || id.equals("")) {
mDatabase.update(TABLE_NAME, cv, ADDRESS + "='" + model.address + "'", null);
} else {
mDatabase.update(TABLE_NAME, cv, ID + "=" + id, null);
}
mDatabase.close();
return super.set(index, model);
}
public void updataSms(String time, String nr, String threadID, String type) {
mDatabase = mDbOpenHelper.getWritableDatabase();
ContentValues values = new ContentValues();
String where = ID + "=" + threadID;
Cursor cursor = mDatabase.query(TABLE_NAME, null, where, null, null, null, null);
cursor.moveToFirst();
String count = cursor.getString(cursor.getColumnIndex(COUNT));
values.put(BODY, nr);
values.put(TIME, Long.parseLong(time));
if (!type.equals("3")) {
values.put(COUNT, String.valueOf(Integer.parseInt(count) - 1));
}
mDatabase.update(TABLE_NAME, values, where, null);
mDatabase.close();
cursor.close();
}
@Override
public HThread remove(int location) {
mDatabase = mDbOpenHelper.getWritableDatabase();
String id = null;
String address = null;
id = mApplication.adapter.get(location).sms.threadid;
address = mApplication.adapter.get(location).sms.address;
if (id != null && !id.equals("")) {
mDatabase.delete(TABLE_NAME, ID + " = " + id, null);
} else {
if (address == null) {
address = mApplication.adapter.get(location).address;
}
mDatabase.delete(TABLE_NAME, ADDRESS + " = '" + address + "'", null);
}
mDatabase.close();
return super.remove(location);
}
public void deleteBufferItem(String threadId) {
mDatabase = mDbOpenHelper.getWritableDatabase();
String where = ID + "=" + threadId;
mDatabase.delete(TABLE_NAME, where, null);
mDatabase.close();
}
public void deleteBufferList() {
mDatabase = mDbOpenHelper.getWritableDatabase();
mDatabase.delete(TABLE_NAME, null, null);
mDatabase.close();
}
public Cursor queryBufferList() {
Cursor cursor = null;
mDatabase = mDbOpenHelper.getWritableDatabase();
cursor = mDatabase.query(TABLE_NAME, null, null, null, null, null, "time desc");
return cursor;
}
