/**
* 从数据库查询信息供写文件使用
*
* @return JSONArray
*/
public JSONArray loadInfo() {
JSONArray jsonArray = new JSONArray();
try {
List<Asset> assetList = assetService.findAllAssetList();
for (int i = 0; i < assetList.size(); i++) {
JSONObject jsonObject = new JSONObject();
Asset asset = new Asset();
asset = assetList.get(i);
jsonObject.put("number", asset.getNumber());
jsonObject.put("name", asset.getName());
jsonObject.put("uses", asset.getUses());
jsonObject.put("category", asset.getCategory());
jsonObject.put(
"entryTime", new SimpleDateFormat("yyyy-MM-dd").format(asset.getEntryTime()));
jsonObject.put("status", asset.getStatus());
jsonObject.put("remarks", asset.getRemarks());
jsonObject.put(
"edit",
"<a href='javascript:void(0)' onclick='editAsset("
+ '"'
+ asset.getId()
+ '"'
+ ")'>编辑</>/<a href='javascript:void(0)' onclick='deleteAsset("
+ '"'
+ asset.getId()
+ '"'
+ ")'>删除</>");
jsonArray.add(jsonObject);
}
} catch (Exception e) {
e.printStackTrace();
}
return jsonArray;
}
