// @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;
}
// @Override
public String queryCondition(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
SgPersonLibraryVO vo = new SgPersonLibraryVO();
String domresult = null;
try {
domresult = sgPersonLibraryDao.queryCondition(json);
LogManager.writeUserLog(
null,
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_SUCCESS,
user.getName() + "施工人员信息-数据查询成功",
user,
"",
"");
} catch (DaoException e) {
logger.error("表单信息{}", e.getMessage());
LogManager.writeUserLog(
null,
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_FAILURE,
user.getName() + "施工人员信息-数据查询失败",
user,
"",
"");
SystemException.handleMessageException("施工人员信息-数据查询失败,请联系相关人员处理");
} finally {
}
return domresult;
}
public String update(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVO = null;
WxyWjGcVO vo = new WxyWjGcVO();
try {
JSONArray list = vo.doInitJson(json);
vo.setValueFromJson((JSONObject) list.get(0));
// 设置主键
/*
* vo.setId(new RandomGUID().toString()); // 主键
*/
/* vo.setId("20FC7EF9-696D-6398-15C8-A77F2C4DFC02"); */
JSONObject obj = (JSONObject) list.get(0);
String ywid = obj.getString("ywid");
if (ywid != null && !"".equals(ywid)) {
FileUploadOldService.updateFjztOrYwidByYwid(
ywid, vo.getWxy_wj_gc_uid(), Constants.FS_FILEUPLOAD_FJLB_WXY_WJGC);
}
// 修改
wxyWjGcDao.update(vo);
resultVO = vo.getRowJson();
} catch (DaoException e) {
logger.error("危险源网架构过程管理{}", e.getMessage());
SystemException.handleMessageException("危险源网架构过程管理修改失败,请联系相关人员处理");
} finally {
}
return resultVO;
}
public String updateStatusOne(String u_id, String js) throws Exception {
User user = ActionContext.getCurrentUserInThread();
SgPersonLibraryVO vo = new SgPersonLibraryVO();
String domresult = null;
try {
domresult = sgPersonLibraryDao.updatePass(u_id, js);
LogManager.writeUserLog(
vo.getSg_person_library_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_SUCCESS,
user.getName() + "施工人员信息-入库-数据更改成功",
user,
"",
"");
} catch (DaoException e) {
logger.error("表单信息{}", e.getMessage());
LogManager.writeUserLog(
vo.getSg_person_library_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_FAILURE,
user.getName() + "施工人员信息-入库-数据更改成功",
user,
"",
"");
SystemException.handleMessageException("施工人员信息-入库-数据更改成功,请联系相关人员处理");
} finally {
}
return domresult;
}
public String delete(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
BuSpywJsgcsgxkzsqMxVO vo = new BuSpywJsgcsgxkzsqMxVO();
String domresult = null;
try {
domresult = null;
LogManager.writeUserLog(
vo.getSgxkzsqmx_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_SUCCESS,
user.getName() + "建设工程施工许可证申请-子表—数据删除成功",
user,
"",
"");
} catch (DaoException e) {
logger.error("表单信息{}", e.getMessage());
LogManager.writeUserLog(
vo.getSgxkzsqmx_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
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 queryCondition(String json) {
User user = ActionContext.getCurrentUserInThread();
Connection conn = DBUtil.getConnection();
String domresult = "";
try {
// 组织查询条件
PageManager page = RequestUtil.getPageManager(json);
String condition = RequestUtil.getConditionList(json).getConditionWhere();
String orderFilter = RequestUtil.getOrderFilter(json);
condition += orderFilter;
if (page == null) page = new PageManager();
page.setFilter(condition);
String sql = "SELECT * FROM " + "BU_SPYW_CBFASP_GCJSXMZJFBHTBAB t";
BaseResultSet bs = DBUtil.query(conn, sql, page);
domresult = bs.getJson();
} catch (Exception e) {
DaoException.handleMessageException("*********查询出错!*********");
} finally {
DBUtil.closeConnetion(conn);
}
return domresult;
}
// @Override
public String queryCondition(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String domresult = "";
try {
domresult = wxyWjGcDao.queryCondition(json, null, null);
} catch (DaoException e) {
logger.error("危险源网架构过程管理{}", e.getMessage());
SystemException.handleMessageException("危险源网架构过程管理查询失败,请联系相关人员处理");
} finally {
}
return domresult;
}
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;
}
public String insert(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVO = null;
WxyWjGcVO vo = new WxyWjGcVO();
try {
JSONArray list = vo.doInitJson(json);
vo.setValueFromJson((JSONObject) list.get(0));
// 设置主键
// vo.setId(new RandomGUID().toString()); // 主键
vo.setWxy_wj_gc_uid(DBUtil.getSequenceValue("WXY_WJ_GC_UID"));
// 设置主键
// vo.setId(new RandomGUID().toString()); // 主键
JSONObject obj = (JSONObject) list.get(0);
String ywid = obj.getString("ywid");
if (ywid != null && !"".equals(ywid)) {
FileUploadOldService.updateFjztOrYwidByYwid(
ywid, vo.getWxy_wj_gc_uid(), Constants.FS_FILEUPLOAD_FJLB_WXY_WJGC);
}
// 插入
wxyWjGcDao.save(vo);
resultVO = vo.getRowJson();
// String jsona="{querycondition: {conditions:
// [{\"value\":\""+vo.getId()+"\",\"fieldname\":\"t.id\",\"operation\":\"=\",\"logic\":\"and\"} ]}}";
// return queryCondition(jsona, user);
} catch (DaoException e) {
logger.error("危险源网架构过程管理{}", e.getMessage());
SystemException.handleMessageException("危险源网架构过程管理新增失败,请联系相关人员处理");
} finally {
}
return resultVO;
}
public String delete(String json) throws Exception {
User user = ActionContext.getCurrentUserInThread();
String resultVo = null;
WxyWjGcVO vo = new WxyWjGcVO();
try {
JSONArray list = vo.doInitJson(json);
JSONObject jsonObj = (JSONObject) list.get(0);
vo.setValueFromJson(jsonObj);
// 删除 根据据主键
wxyWjGcDao.delete(WxyWjGcVO.class, vo.getWxy_wj_gc_uid());
resultVo = vo.getRowJson();
} catch (DaoException e) {
logger.error("危险源网架构过程管理{}", e.getMessage());
SystemException.handleMessageException("危险源网架构过程管理删除失败,请联系相关人员处理");
} finally {
}
return resultVo;
}
public String queryCondition(String json, JxsbDsjjVO vo, Map map) {
User user = ActionContext.getCurrentUserInThread();
Connection conn = DBUtil.getConnection();
String domresult = "";
try {
// 组织查询条件
PageManager page = RequestUtil.getPageManager(json);
String condition = RequestUtil.getConditionList(json).getConditionWhere();
String orderFilter = RequestUtil.getOrderFilter(json);
condition += BusinessUtil.getCommonCondition(user, null);
condition += orderFilter;
if (page == null) page = new PageManager();
page.setFilter(condition);
String sql =
"select * from jxsb_dsjj d "
+ "left join JXSB_SYGL s on d.jxsb_sygl_uid=s.jxsb_sygl_uid "
+ "left join JXSB_SYDJ j on s.jxsb_sygl_uid=j.jxsb_sygl_uid "
+ "left join JXSB_JCYS c on s.jxsb_sygl_uid=c.jxsb_sygl_uid "
+ "left join JXSB_AZGC g on s.jxsb_sygl_uid=g.jxsb_sygl_uid "
+ "left join az_company a on d.BY_COMPANY_DL_UID=a.AZ_COMPANY_UID "
+ "left join jxsb b on b.jxsb_uid=s.jxsb_uid ";
BaseResultSet bs = DBUtil.query(conn, sql, page);
// 合同表
// bs.setFieldTranslater("HTID", "合同表", "ID", "NAME");
// 项目下达库
// bs.setFieldTranslater("XDKID", "GC_TCJH_XMXDK", "ID", "XMMC");
// 标段表
// bs.setFieldTranslater("BDID", "GC_XMBD", "GC_XMBD_ID", "BDMC");
// 设置字典
// 设置查询条件
// bs.setFieldDateFormat("JLRQ", "yyyy-MM");// 计量月份
// bs.setFieldThousand("DYJLSDZ");
domresult = bs.getJson();
} catch (Exception e) {
DaoException.handleMessageException("*********查询出错!*********");
} finally {
DBUtil.closeConnetion(conn);
}
return domresult;
}
public String updateShenhe(String json, Map fils, String u_id, String status, String t_id)
throws Exception {
User user = ActionContext.getCurrentUserInThread();
SgPersonLibraryVO vo = new SgPersonLibraryVO();
String domresult = null;
try {
JSONArray list = vo.doInitJson(json);
JSONObject object = (JSONObject) list.get(0);
String companyname = object.getString("COMPANY_NAME");
String companycode = object.getString("COMPANY_DENGLU_CODE");
String companyuid = object.getString("SG_COMPANY_UID");
String personUid = object.getString("SG_PERSON_LIBRARY_UID");
String personName = object.getString("PERSON_NAME");
domresult = sgPersonLibraryDao.updateShenhe(json, fils, u_id, status, t_id);
if ("10".equals(status)) { // 人员审核通过
// ****************************消息添加
Map messageMap = new HashMap();
messageMap.put("TITLE", "施工人员审核");
messageMap.put(
"CONTENT",
"人员<a href='javascript:void(0)' onclick=\"zxdtView('"
+ personUid
+ "','sgrysh')\">"
+ personName
+ "</a>信息<span style='color:blue;'>审核通过</span>");
messageMap.put("USERTO", companycode); // 企业的登录Code
messageMap.put("USERTONAME", companyname); // 企业的名称
messageMap.put("SYSTEM_TYPE", "SG"); // 系统类型
messageMap.put("COMPANY_UID", companyuid); // 对应的施工企业编号
messageMap.put("MSG_TYPE", Constants.FS_MESSAGE_INFO_MSG_TYPE_SGQYRY); // 消息类型
messageMap.put("QUANXIAN_UID", Constants.QUANXIAN_SG_RYGL); // 涉及的权限点
fsMessageInfoService.insertVo(messageMap);
} else if ("20".equals(status)) { // 人员审核未通过
// ****************************消息添加
Map messageMap = new HashMap();
messageMap.put("TITLE", "施工人员审核");
messageMap.put(
"CONTENT",
"人员<a href='javascript:void(0)' onclick=\"zxdtView('"
+ personUid
+ "','sgrysh')\">"
+ personName
+ "</a>信息<span style='color:red;'>审核未通过</span>");
messageMap.put("USERTO", companycode); // 人员的登录Code
messageMap.put("USERTONAME", companyname); // 企业的名称
messageMap.put("SYSTEM_TYPE", "SG"); // 系统类型
messageMap.put("COMPANY_UID", companyuid); // 对应的施工企业编号
messageMap.put("MSG_TYPE", Constants.FS_MESSAGE_INFO_MSG_TYPE_SGQYRY); // 消息类型
messageMap.put("QUANXIAN_UID", Constants.QUANXIAN_SG_RYGL); // 涉及的权限点
fsMessageInfoService.insertVo(messageMap);
}
LogManager.writeUserLog(
vo.getSg_person_library_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_SUCCESS,
user.getName() + "施工人员信息-提交-数据更改成功",
user,
"",
"");
} catch (DaoException e) {
logger.error("表单信息{}", e.getMessage());
LogManager.writeUserLog(
vo.getSg_person_library_uid(),
ywlx,
Globals.OPERATION_TYPE_DELETE,
LogManager.RESULT_FAILURE,
user.getName() + "施工人员信息-提交-数据更改成功",
user,
"",
"");
SystemException.handleMessageException("施工人员信息-提交-数据更改成功,请联系相关人员处理");
} finally {
}
return domresult;
}
