public static Purchase jsonToObject(JSONObject jsonObject) {
Purchase model = new Purchase();
if (jsonObject.containsKey("purchaseid")) {
model.setPurchaseid(jsonObject.getLong("purchaseid"));
}
if (jsonObject.containsKey("purchaseno")) {
model.setPurchaseno(jsonObject.getString("purchaseno"));
}
if (jsonObject.containsKey("area")) {
model.setArea(jsonObject.getString("area"));
}
if (jsonObject.containsKey("company")) {
model.setCompany(jsonObject.getString("company"));
}
if (jsonObject.containsKey("dept")) {
model.setDept(jsonObject.getString("dept"));
}
if (jsonObject.containsKey("post")) {
model.setPost(jsonObject.getString("post"));
}
if (jsonObject.containsKey("appuser")) {
model.setAppuser(jsonObject.getString("appuser"));
}
if (jsonObject.containsKey("appdate")) {
model.setAppdate(jsonObject.getDate("appdate"));
}
if (jsonObject.containsKey("purchasesum")) {
model.setPurchasesum(jsonObject.getDouble("purchasesum"));
}
if (jsonObject.containsKey("status")) {
model.setStatus(jsonObject.getInteger("status"));
}
if (jsonObject.containsKey("processname")) {
model.setProcessname(jsonObject.getString("processname"));
}
if (jsonObject.containsKey("processinstanceid")) {
model.setProcessinstanceid(jsonObject.getLong("processinstanceid"));
}
if (jsonObject.containsKey("wfstatus")) {
model.setWfstatus(jsonObject.getLong("wfstatus"));
}
if (jsonObject.containsKey("createBy")) {
model.setCreateBy(jsonObject.getString("createBy"));
}
if (jsonObject.containsKey("createDate")) {
model.setCreateDate(jsonObject.getDate("createDate"));
}
if (jsonObject.containsKey("updateDate")) {
model.setUpdateDate(jsonObject.getDate("updateDate"));
}
if (jsonObject.containsKey("updateBy")) {
model.setUpdateBy(jsonObject.getString("updateBy"));
}
return model;
}
public void saveCourse(JSONObject jsonObject) {
// Cursor cursor = null;
String sql = "delete from course;";
JSONArray jsonArray = jsonObject.getJSONArray("result");
// Object[] obj = jsonArray.toArray();
int length = jsonArray.size();
JSONObject obj;
ContentValues cv = new ContentValues();
SQLiteDatabase database = DatabaseUtil.this.getWritableDatabase();
database.execSQL(sql);
for (int i = 0; i < length; i++) {
obj = (JSONObject) jsonArray.get(i);
cv.put("courseId", obj.getString("courseId"));
cv.put("credit", obj.getDouble("credit"));
cv.put("teacherId", obj.getString("teacherId"));
cv.put("studentId", obj.getString("studentId"));
cv.put("courseName", obj.getString("courseName"));
cv.put("courseTime", obj.getString("courseTime"));
cv.put("courseDate", obj.getString("courseDate"));
cv.put("test1", obj.getDouble("test1"));
cv.put("test2", obj.getDouble("test2"));
cv.put("test3", obj.getDouble("test3"));
cv.put("exercises1", obj.getDouble("exercises1"));
cv.put("exercises2", obj.getDouble("exercises2"));
cv.put("exercises3", obj.getDouble("exercises3"));
cv.put("exercises4", obj.getDouble("exercises4"));
cv.put("exercises5", obj.getDouble("exercises5"));
cv.put("finalTest", obj.getDouble("finalTest"));
cv.put("dailyMark", obj.getDouble("dailyMark"));
cv.put("sum", obj.getDouble("sum"));
Object t = database.insert("course", null, cv);
Log.i(
"devouty",
"insert into course:" + i + " Name:" + obj.getString("courseName") + "----" + t);
//
// Log.i("devouty","count:"+database.query("course",null,null,null,null,null,null).getCount());
}
// cursor = database.query("course",null,null,null,null,null,null);
database.close();
// database = DatabaseUtil.this.getReadableDatabase();
// cursor = database.query("course",null,null,null,null,null,null);
// return cursor;
}