// @Override
public String queryCondition(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String domresult = "";
try {
domresult = buSpywCspsxkzsqDao.queryCondition(json, null, null);
LogManager.writeUserLog(
null,
ywlx,
Globals.OPERATION_TYPE_QUERY,
LogManager.RESULT_SUCCESS,
user.getName() + "查询<排水许可证申请>",
user,
"",
"");
} catch (DaoException e) {
logger.error("排水许可证申请{}", e.getMessage());
LogManager.writeUserLog(
null,
ywlx,
Globals.OPERATION_TYPE_QUERY,
LogManager.RESULT_FAILURE,
user.getName() + "排水许可证申请查询失败",
user,
"",
"");
SystemException.handleMessageException("排水许可证申请查询失败,请联系相关人员处理");
} finally {
}
return domresult;
}
public String insert(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVO = null;
BuSpywCspsxkzsqVO vo = new BuSpywCspsxkzsqVO();
try {
JSONArray list = vo.doInitJson(json);
vo.setValueFromJson((JSONObject) list.get(0));
// 设置主键
// vo.setId(new RandomGUID().toString()); // 主键
vo.setCspsxkzsq_uid(DBUtil.getSequenceValue("CSPSXKZSQ_UID"));
vo.setCreated_uid(user.getUserSN());
vo.setCreated_name(user.getName());
vo.setEvent_uid(new RandomGUID().toString());
// 插入
buSpywCspsxkzsqDao.save(vo);
resultVO = vo.getRowJson();
LogManager.writeUserLog(
vo.getEvent_uid(),
ywlx,
Globals.OPERATION_TYPE_INSERT,
LogManager.RESULT_SUCCESS,
user.getName() + "排水许可证申请新增成功",
user,
"",
"");
// String jsona="{querycondition: {conditions:
// [{\"value\":\""+vo.getId()+"\",\"fieldname\":\"t.id\",\"operation\":\"=\",\"logic\":\"and\"} ]}}";
// return queryCondition(jsona, user);
} catch (DaoException e) {
logger.error("排水许可证申请{}", e.getMessage());
LogManager.writeUserLog(
vo.getEvent_uid(),
ywlx,
Globals.OPERATION_TYPE_INSERT,
LogManager.RESULT_FAILURE,
user.getName() + "排水许可证申请新增失败",
user,
"",
"");
SystemException.handleMessageException("排水许可证申请新增失败,请联系相关人员处理");
} finally {
}
return resultVO;
}
public String update(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVO = null;
BuSpywCspsxkzsqVO vo = new BuSpywCspsxkzsqVO();
try {
JSONArray list = vo.doInitJson(json);
vo.setValueFromJson((JSONObject) list.get(0));
// 设置主键
/*
* vo.setId(new RandomGUID().toString()); // 主键
*/
/* vo.setId("20FC7EF9-696D-6398-15C8-A77F2C4DFC02"); */
vo.setEvent_uid(new RandomGUID().toString());
vo.setCreated_uid(user.getUserSN());
vo.setCreated_name(user.getName());
// 修改
buSpywCspsxkzsqDao.update(vo);
resultVO = vo.getRowJson();
LogManager.writeUserLog(
vo.getEvent_uid(),
ywlx,
Globals.OPERATION_TYPE_UPDATE,
LogManager.RESULT_SUCCESS,
user.getName() + "排水许可证申请修改成功",
user,
"",
"");
} catch (DaoException e) {
logger.error("排水许可证申请{}", e.getMessage());
LogManager.writeUserLog(
vo.getEvent_uid(),
ywlx,
Globals.OPERATION_TYPE_UPDATE,
LogManager.RESULT_FAILURE,
user.getName() + "排水许可证申请修改失败",
user,
"",
"");
SystemException.handleMessageException("排水许可证申请修改失败,请联系相关人员处理");
} finally {
}
return resultVO;
}
public String delete(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVo = null;
BuSpywCspsxkzsqVO vo = new BuSpywCspsxkzsqVO();
try {
JSONArray list = vo.doInitJson(json);
JSONObject jsonObj = (JSONObject) list.get(0);
vo.setValueFromJson(jsonObj);
vo.setEvent_uid(new RandomGUID().toString());
// 删除 根据据主键
buSpywCspsxkzsqDao.delete(BuSpywCspsxkzsqVO.class, vo.getCspsxkzsq_uid());
resultVo = vo.getRowJson();
LogManager.writeUserLog(
vo.getEvent_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_SUCCESS,
user.getName() + "排水许可证申请删除成功",
user,
"",
"");
} catch (DaoException e) {
logger.error("排水许可证申请{}", e.getMessage());
LogManager.writeUserLog(
vo.getEvent_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_FAILURE,
user.getName() + "排水许可证申请删除失败",
user,
"",
"");
SystemException.handleMessageException("排水许可证申请删除失败,请联系相关人员处理");
} finally {
}
return resultVo;
}
/** 材料核发调用获取MAP数据 */
public String ywlzclhf(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVO = null;
BuSpLzhfVO vo = new BuSpLzhfVO();
// obj.YWLZ_UID = data.YWLZ_UID;
// obj.YWCL_UID = data.YWCL_UID;
// obj.PIJIAN_CODE = codeid;
// obj.PIJIAN_NAME = nameid;
// obj.LINGJIAN_REN =ljr;
// obj.LINGJIAN_PHONE=ljrdh;
try {
JSONArray list = vo.doInitJson(json);
JSONObject object = (JSONObject) list.get(0);
String YWLZ_UID = (String) object.get("YWLZ_UID");
// 通过业务流转UID查询企业填报的数据，map类型
String id = buSpywCspsxkzsqDao.getIdByYwlzuid(YWLZ_UID);
BuSpywCspsxkzsqVO mapFtl = new BuSpywCspsxkzsqVO();
if (StringUtil.isNotBlankStr(id)) {
mapFtl = this.findById(id);
}
//
// //复选框的判断
// String Wszx_gyws=mapFtl.getWszx_gyws();
// String Wsxz_shws=mapFtl.getWsxz_shws();
// String Sfclml=mapFtl.getSfclml();
// if(StringUtils.isBlank(Wszx_gyws)){
// mapFtl.put("WSZX_GYWS", "");
// }
// if(StringUtils.isBlank(Wsxz_shws)){
// mapFtl.put("WSXZ_SHWS", "");
// }
// if(StringUtils.isBlank(Sfclml)){
// mapFtl.put("SFCLML", "");
// }
//
// 组装业务流转核发数据
Map mapVo = new HashMap();
mapVo.put("YWLZ_UID", YWLZ_UID);
mapVo.put("YWCL_UID", object.get("YWCL_UID"));
mapVo.put("PIJIAN_CODE", object.get("PIJIAN_CODE"));
mapVo.put("PIJIAN_NAME", object.get("PIJIAN_NAME"));
mapVo.put("LINGJIAN_PHONE", object.get("LINGJIAN_PHONE"));
mapVo.put("LINGJIAN_REN", object.get("LINGJIAN_REN"));
mapVo.put("CLK_UID", object.getString("CLK_UID"));
mapVo.put("FZ_DATE", object.getString("FZ_DATE"));
mapVo.put("YXQ_DATE", object.getString("YXQ_DATE"));
if (mapFtl != null) {
buSpLzhfService.saveBuSpLzhfVO(mapFtl, mapVo);
}
resultVO = vo.getRowJson();
} catch (DaoException e) {
logger.error("审批业务材料核发{}", e);
SystemException.handleMessageException("审批业务材料核发调用失败,请联系相关人员处理");
} finally {
}
return resultVO;
}