public boolean saveMtUsedStock(
String materialId,
String addressId,
String oldStock,
String newStock,
String seq,
String tid) {
// TODO Auto-generated method stub
boolean flag = false;
String sql = "insert into LP_MT_USED_DETAIL( ";
sql = sql + " ID,MTUSEDID,MATERIALID,ADDRESSID,OLD_STOCK,NEW_STOCK ";
sql = sql + " ) values( ";
sql = sql + " '" + seq + "','" + tid + "','" + materialId + "', ";
sql = sql + " '" + addressId + "','" + oldStock + "', ";
sql = sql + " '" + newStock + "')";
UpdateUtil util;
try {
logger.info("执行sql：" + sql);
util = new UpdateUtil();
util.executeUpdate(sql);
flag = true;
} catch (Exception e) {
// TODO Auto-generated catch block
logger.error("执行sql出错：", e);
}
return flag;
}
/**
* 删除批量计划
*
* @param id
* @return
*/
public boolean removeBatch(String id) {
UpdateUtil del = null;
String delbatch = "delete batchplan where id='" + id + "'";
String delbatch_plan = "delete batch_plan where batchid='" + id + "'";
String delplan =
"delete plan where id in(select planid from batch_plan where batchid='" + id + "')";
String delplan_task =
"delete plantasklist where planid in(select planid from batch_plan where batchid='"
+ id
+ "')";
String deltask =
"delete taskinfo where id in (select taskid from plantasklist where planid in(select planid from batch_plan where batchid='"
+ id
+ "'))";
String deltaskOp =
"delete taskoperationlist where taskid in(select taskid from plantasklist where planid in(select planid from batch_plan where batchid='"
+ id
+ "'))";
String deltaskpoint =
"delete subtaskinfo where taskid in(select taskid from plantasklist where planid in(select planid from batch_plan where batchid='"
+ id
+ "'))";
String deltasksubline =
"delete plantasksubline where taskid in(select taskid from plantasklist where planid in(select planid from batch_plan where batchid='"
+ id
+ "'))";
try {
del = new UpdateUtil();
del.setAutoCommitFalse();
del.executeUpdate(deltasksubline);
del.executeUpdate(deltaskpoint);
del.executeUpdate(deltaskOp);
del.executeUpdate(deltask);
del.executeUpdate(delplan_task);
del.executeUpdate(delplan);
del.executeUpdate(delbatch_plan);
del.executeUpdate(delbatch);
del.commit();
del.setAutoCommitTrue();
return true;
} catch (Exception e) {
del.rollback();
logger.error(e);
e.printStackTrace();
return false;
}
}
/**
* 废弃 批量创建计划 废弃
*
* @param deptname
* @param regionid
* @param batch
* @param batchpatrol
* @return
*/
public boolean createBatchPlan(
String deptname, String regionid, BatchBean batch, List batchpatrol) {
DBService dbs = new DBService();
/* 1.create batchPlan*/
batch.setId(dbs.getSeq("batchplan", 10));
String sql1 =
"insert into batchplan (id,batchname,startdate,enddate,contractorid,createdate) values ('"
+ batch.getId()
+ "','"
+ batch.getBatchname()
+ "',to_date('"
+ batch.getStartdate()
+ "','yyyy/mm/dd'),to_date('"
+ batch.getEnddate()
+ "','yyyy/mm/dd'),'"
+ batch.getContractorid()
+ "',sysdate)";
logger.info("BATCH_SQL" + sql1);
/* 2.create plan */
String nowdate = DateUtil.getNowDateString();
int index = batch.getBatchname().indexOf(nowdate.substring(0, 3));
String str = batch.getBatchname().substring(index, batch.getBatchname().length());
UpdateUtil update = null;
try {
update = new UpdateUtil();
} catch (Exception e1) {
logger.error(e1);
e1.printStackTrace();
return false;
}
try {
update.setAutoCommitFalse();
update.executeUpdate(sql1);
for (int i = 0; i < batchpatrol.size(); i++) {
PatrolManBean patrol = (PatrolManBean) batchpatrol.get(i);
// create plan
String id = dbs.getSeq("plan", 18);
String plan_sql =
"insert into plan(id,planname,executorid,creator,createdate,"
+ " begindate,enddate,regionid,ifinnercheck)"
+ " values ('"
+ id
+ "','"
+ deptname
+ patrol.getPatrolName()
+ str
+ "','"
+ patrol.getPatrolID()
+ "','"
+ deptname
+ "',sysdate"
+ ",to_date('"
+ batch.getStartdate()
+ "','yyyy/mm/dd'),to_date('"
+ batch.getEnddate()
+ "','yyyy/mm/dd'),'"
+ regionid
+ "','1')";
logger.info(plan_sql);
update.executeUpdate(plan_sql);
// 更新batchplan 、plan关联表
String batch_plan_sql =
"insert into batch_plan(id,planid,batchid) values('"
+ dbs.getSeq("batch_plan", 20)
+ "','"
+ id
+ "','"
+ batch.getId()
+ "')";
logger.info(batch_plan_sql);
update.executeUpdate(batch_plan_sql);
List level = (List) getLineLevel(patrol.getPatrolID());
// create taskinfo
for (int j = 0; j < level.size(); j++) {
String taskid = dbs.getSeq("taskinfo", 20);
String task_sql =
"insert into taskinfo (id,DESCRIBTION,REGIONID,EXCUTETIMES,LINELEVEL)values ('"
+ taskid
+ "','"
+ batch.getTaskopname()
+ "','"
+ regionid
+ "','1','"
+ level.get(j).toString()
+ "')";
String plan_task_sql =
"insert into plantasklist (id,planid,taskid) values('"
+ dbs.getSeq("plantasklist", 50)
+ "','"
+ id
+ "','"
+ taskid
+ "')";
logger.info(task_sql);
logger.info(plan_task_sql);
update.executeUpdate(task_sql);
update.executeUpdate(plan_task_sql);
// 巡检类型
String op_sql =
"insert into taskoperationlist (id,taskid,OPERATIONID) values ('"
+ dbs.getSeq("taskoperationlist", 20)
+ "','"
+ taskid
+ "','"
+ batch.getTaskoperation()
+ "')";
logger.info(op_sql);
update.executeUpdate(op_sql);
// 巡检线段
for (int k = 0; k < level.size(); k++) {
List subline = (List) getSublineID(patrol.getPatrolID(), level.get(k).toString());
for (int n = 0; n < subline.size(); n++) {
String subline_sql =
"insert into plantasksubline (tsblid,sublineid,taskid) values ('"
+ dbs.getSeq("plantasksubline", 10)
+ "','"
+ subline.get(n).toString()
+ "','"
+ taskid
+ "')";
logger.info(subline_sql);
update.executeUpdate(subline_sql);
}
}
// xunjian point
for (int l = 0; l < level.size(); l++) {
List point = (List) getPointID(patrol.getPatrolID(), level.get(l).toString());
for (int n = 0; n < point.size(); n++) {
String point_sql =
"insert into subtaskinfo (id,taskid,objectid) values (SEQ_SUBTASKINFO_ID.nextval,'"
+ taskid
+ "','"
+ point.get(n).toString()
+ "')";
logger.info(point_sql);
update.executeUpdate(point_sql);
}
}
}
}
update.commit();
update.setAutoCommitTrue();
return true;
} catch (Exception e) {
update.rollback();
update.setAutoCommitTrue();
logger.error(e);
e.printStackTrace();
return false;
}
}
/**
* 通过模板创建批量计划
*
* @param deptname
* @param regionid
* @param batch
* @param stencilList
* @return
*/
public boolean createBatchPlan4Stencil(
String deptname, String regionid, BatchBean batch, List stencilList, ExecuteLog log) {
TaskBO tbo = new TaskBO();
UpdateUtil update = null;
DBService dbs = new DBService();
String nowdate = DateUtil.getNowDateString();
int index = batch.getTaskopname().indexOf(batch.getStartdate().substring(0, 3));
String str = batch.getTaskopname().substring(index, batch.getTaskopname().length());
int seq = 0;
try {
update = new UpdateUtil();
update.setAutoCommitFalse();
batch.setId(dbs.getSeq("batchplan", 10));
String sql_batch =
"insert into batchplan (id,batchname,startdate,enddate,contractorid,createdate) values ('"
+ batch.getId()
+ "','"
+ batch.getBatchname()
+ "',to_date('"
+ batch.getStartdate()
+ "','yyyy/mm/dd'),to_date('"
+ batch.getEnddate()
+ "','yyyy/mm/dd'),'"
+ batch.getContractorid()
+ "',sysdate)";
update.executeUpdate(sql_batch);
logger.info("共有计划数：" + stencilList.size());
for (int i = 0; i < stencilList.size(); i++) {
StencilTask stencil = (StencilTask) stencilList.get(i);
List taskstencil = tbo.toLoad(stencil.getID());
// plan 计划
String id = dbs.getSeq("plan", 18);
String plan_sql =
"insert into plan(id,planname,executorid,creator,createdate,"
+ " begindate,enddate,regionid,ifinnercheck,patrolmode)"
+ " values ('"
+ id
+ "','"
+ deptname
+ stencil.getStencilname()
+ str
+ "','"
+ stencil.getPatrolid()
+ "','"
+ deptname
+ "',sysdate"
+ ",to_date('"
+ batch.getStartdate()
+ "','yyyy/mm/dd'),to_date('"
+ batch.getEnddate()
+ "','yyyy/mm/dd'),'"
+ regionid
+ "','1','"
+ batch.getPatrolmode()
+ "')";
update.executeUpdate(plan_sql);
// 更新batchplan 、plan关联表
String batch_plan_sql =
"insert into batch_plan(id,planid,batchid) values('"
+ dbs.getSeq("batch_plan", 20)
+ "','"
+ id
+ "','"
+ batch.getId()
+ "')";
logger.info(batch_plan_sql);
update.executeUpdate(batch_plan_sql);
// 子任务
for (int j = 0; j < taskstencil.size(); j++) {
// String taskid = dbs.getSeq("taskinfo",20);
String taskid = GeneratorJugUUID.getUUIDByRandomNumber();
TaskBean task = (TaskBean) taskstencil.get(j);
String task_sql =
"insert into taskinfo (id,DESCRIBTION,REGIONID,EXCUTETIMES,LINELEVEL,taskpoint, factpointsnum)values ('"
+ taskid
+ "','"
+ task.getDescribtion()
+ "','"
+ regionid
+ "','"
+ task.getExcutetimes()
+ "','"
+ task.getLinelevel()
+ "','"
+ task.getTaskPoint().size()
+ "', '"
+ task.getFactpointsnum()
+ "')";
// String plan_task_sql = "insert into plantasklist (id,planid,taskid)
// values('"+dbs.getSeq("plantasklist",50)+"','"+id+"','"+taskid+"')";
String plan_task_sql =
"insert into plantasklist (id,planid,taskid) values('"
+ GeneratorJugUUID.getUUIDByRandomNumber()
+ "','"
+ id
+ "','"
+ taskid
+ "')";
logger.info(task_sql);
logger.info(plan_task_sql);
update.executeUpdate(task_sql);
update.executeUpdate(plan_task_sql);
/// 巡检类型
for (int k = 0; k < task.getTaskOpList().size(); k++) {
String opId = GeneratorJugUUID.getUUIDByRandomNumber();
TaskOperationList taskop = (TaskOperationList) task.getTaskOpList().get(k);
// String op_sql = "insert into taskoperationlist (id,taskid,OPERATIONID) values
// ('"+dbs.getSeq("taskoperationlist",20)+"','"+taskid+"','"+taskop.getOperationid()+"')";
String op_sql =
"insert into taskoperationlist (id,taskid,OPERATIONID) values ('"
+ opId
+ "','"
+ taskid
+ "','"
+ taskop.getOperationid()
+ "')";
logger.info(op_sql);
update.executeUpdate(op_sql);
}
// xunjian point
for (int m = 0; m < task.getTaskPoint().size(); m++) {
String idStr = GeneratorJugUUID.getUUIDByRandomNumber();
SubTask taskpoint = (SubTask) task.getTaskPoint().get(m);
// String point_sql = "insert into subtaskinfo (id,taskid,objectid) values
// (SEQ_SUBTASKINFO_ID.nextval,'"+taskid+"','"+taskpoint.getObjectid()+"')";
String point_sql =
"insert into subtaskinfo (id,taskid,objectid) values ('"
+ idStr
+ "','"
+ taskid
+ "','"
+ taskpoint.getObjectid()
+ "')";
logger.info(point_sql);
update.executeUpdate(point_sql);
}
// 巡检线段
for (int n = 0; n < task.getTaskSubline().size(); n++) {
String tsblid = GeneratorJugUUID.getUUIDByRandomNumber();
PlanTaskSubline tasksubline = (PlanTaskSubline) task.getTaskSubline().get(n);
// String subline_sql = "insert into plantasksubline (tsblid,sublineid,taskid)
// values
// (SEQ_PLANTASKSUBLINE_ID.nextval,'"+tasksubline.getSublineid()+"','"+taskid+"')";
String subline_sql =
"insert into plantasksubline (tsblid,sublineid,taskid) values ('"
+ tsblid
+ "','"
+ tasksubline.getSublineid()
+ "','"
+ taskid
+ "')";
seq++;
logger.info(subline_sql);
update.executeUpdate(subline_sql);
}
}
}
logger.info("计划制定结束！");
log.setResult(log.getResult() + " 有" + stencilList.size() + "个巡检组的计划被创建成功。");
update.commit();
update.setAutoCommitTrue();
return true;
} catch (Exception e) {
logger.info("sq :" + seq);
log.setResult("批量计划创建失败。请与管理员联系!");
update = null;
update.rollback();
update.setAutoCommitTrue();
logger.error(e);
e.printStackTrace();
return false;
}
}
/**
* 清除此用户任何组内的信息，确保一个用户只属于一个用户组
*
* @param userid String
*/
public void clearUgUList(String userid) throws Exception {
String sql = "delete USERGOURPUSERLIST where userid='" + userid + "'";
logger.info("clearsql ：" + sql);
UpdateUtil del = new UpdateUtil();
del.executeUpdate(sql);
}