public List<EpTaskInspection> listEpTaskInspection() { EpTaskInspectionExample example = new EpTaskInspectionExample(); String orderByClause = "type,seq"; example.setOrderByClause(orderByClause); EpTaskInspectionExample.Criteria criteria = example.createCriteria(); return epTaskInspectionDAO.selectByExample(example); }
public void operateEpTaskInspection(String jsonString) throws JSONException { EpTaskInspectionExample example = new EpTaskInspectionExample(); EpTaskInspectionExample.Criteria criteria = example.createCriteria(); epTaskInspectionDAO.deleteByExample(example); JSONArray jsonArray = new JSONArray(jsonString); if (jsonArray.length() > 0) { for (int i = 0; i < jsonArray.length(); i++) { JSONObject jsonObject = new JSONObject(jsonArray.get(i).toString()); EpTaskInspection epTaskInspection = new EpTaskInspection(); String id = sequenceDAO.getEpTaskInstanceSeq(); String item = jsonObject.getString("item"); String seq = jsonObject.getString("seq"); String standard = jsonObject.getString("standard"); String type = jsonObject.getString("type"); epTaskInspection.setId(id); epTaskInspection.setItem(item); epTaskInspection.setSeq(new BigDecimal(seq)); epTaskInspection.setStandard(standard); epTaskInspection.setType(type); epTaskInspectionDAO.insert(epTaskInspection); } } }