package com.fgkj.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.text.ParseException; import java.util.ArrayList; import java.util.List; import com.fgkj.dao.BaseDAO; import com.fgkj.dao.CallBack; import com.fgkj.dao.DAOHelper; import com.fgkj.db.DBUtil; import com.fgkj.db.IDatabaseName; import com.fgkj.dto.BattInf; import com.fgkj.dto.Task_Batt_Test; import com.fgkj.dto.User_task; import com.fgkj.dto.User_task_batt_check; public class User_task_batt_checkImpl implements BaseDAO,CallBack{ public List getResults(ResultSet rs) { List list=new ArrayList(); try { while(rs.next()){ Task_Batt_Test tbt=new Task_Batt_Test(); User_task_batt_check ucheck=new User_task_batt_check(); ucheck.setNum(rs.getInt("num")); ucheck.setTask_id(rs.getInt("task_id")); ucheck.setTask_usr_ids(rs.getString("task_usr_ids")); ucheck.setBattGroupId(rs.getInt("BattGroupId")); ucheck.setTask_enabled(rs.getInt("task_enabled")); ucheck.setTask_exe_date(rs.getTimestamp("task_exe_date")); ucheck.setTask_close_date(rs.getTimestamp("task_close_date")); ucheck.setTest_complete(rs.getInt("test_complete")); ucheck.setTest_completetime(rs.getTimestamp("test_completetime")); ucheck.setBatt_clean_done(rs.getInt("batt_clean_done")); ucheck.setBatt_clean_done_result(rs.getString("batt_clean_done_result")); ucheck.setBatt_clean_done_recheck(rs.getInt("batt_clean_done_recheck")); ucheck.setBatt_clean_done_recheck_result(rs.getString("batt_clean_done_recheck_result")); ucheck.setBatt_clean_done_recheck_check(rs.getInt("batt_clean_done_recheck_check")); ucheck.setBatt_clean_done_recheck_check_result(rs.getString("batt_clean_done_recheck_check_result")); ucheck.setBattvol_tempe_done(rs.getInt("battvol_tempe_done")); ucheck.setBattvol_tempe_done_result(rs.getString("battvol_tempe_done_result")); ucheck.setBattvol_tempe_done_recheck(rs.getInt("battvol_tempe_done_recheck")); ucheck.setBattvol_tempe_done_recheck_result(rs.getString("battvol_tempe_done_recheck_result")); ucheck.setBattvol_tempe_done_recheck_check(rs.getInt("battvol_tempe_done_recheck_check")); ucheck.setBattvol_tempe_done_recheck_check_result(rs.getString("battvol_tempe_done_recheck_check_result")); ucheck.setBattfault_check_done(rs.getInt("battfault_check_done")); ucheck.setBattfault_check_done_result(rs.getString("battfault_check_done_result")); ucheck.setBattfault_check_done_recheck(rs.getInt("battfault_check_done_recheck")); ucheck.setBattfault_check_done_recheck_result(rs.getString("battfault_check_done_recheck_result")); ucheck.setBattfault_check_done_recheck_check(rs.getInt("battfault_check_done_recheck_check")); ucheck.setBattfault_check_done_recheck_check_result(rs.getString("battfault_check_done_recheck_check_result")); BattInf binf=new BattInf(); binf.setBattGroupId(rs.getInt("battGroupId")); binf.setStationName(rs.getString("stationName")); binf.setBattGroupName(rs.getString("battGroupName")); tbt.setBinf(binf); tbt.setUcheck(ucheck); list.add(tbt); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public boolean add(Object obj) { User_task_batt_check ucheck=(User_task_batt_check) obj; String sql="insert into db_user.tb_user_task_batt_check(task_id,task_usr_ids,BattGroupId,task_enabled,task_exe_date,test_complete,test_completetime,batt_clean_done," + "batt_clean_done_result,batt_clean_done_recheck,batt_clean_done_recheck_result,batt_clean_done_recheck_check," + "batt_clean_done_recheck_check_result,battvol_tempe_done,battvol_tempe_done_result,battvol_tempe_done_recheck,battvol_tempe_done_recheck_result,"+ "battvol_tempe_done_recheck_check,battvol_tempe_done_recheck_check_result,battfault_check_done,battfault_check_done_result,battfault_check_done_recheck_result," + "battfault_check_done_recheck_result,battfault_check_done_recheck_check,battfault_check_done_recheck_check_result) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ucheck.getTask_id(),ucheck.getTask_usr_ids(),ucheck.getBattGroupId(),ucheck.getTask_enabled(), ucheck.getTask_exe_date(),ucheck.getTask_close_date(),ucheck.getTest_complete(),ucheck.getTest_completetime(),ucheck.getBatt_clean_done(),ucheck.getBatt_clean_done_result(), ucheck.getBatt_clean_done_recheck(),ucheck.getBatt_clean_done_recheck_result(),ucheck.getBatt_clean_done_recheck_check(),ucheck.getBatt_clean_done_recheck_check_result(), ucheck.getBattvol_tempe_done(),ucheck.getBattvol_tempe_done_result(),ucheck.getBattvol_tempe_done_recheck(),ucheck.getBattvol_tempe_done_recheck_result(), ucheck.getBattvol_tempe_done_recheck_check(),ucheck.getBattvol_tempe_done_recheck_check_result(),ucheck.getBattfault_check_done(),ucheck.getBattfault_check_done_result(), ucheck.getBattfault_check_done_recheck(),ucheck.getBattfault_check_done_recheck_result(),ucheck.getBattfault_check_done_recheck_check(),ucheck.getBattfault_check_done_recheck_check_result()}); return bl; } //4.1添加作业并确定 public String addPro(Object obj) { User_task_batt_check ucheck=(User_task_batt_check) obj; String sql="insert into db_user.tb_user_task_batt_check(task_id,task_usr_ids,BattGroupId,task_enabled,task_exe_date,task_close_date,test_complete,test_completetime,batt_clean_done," + "batt_clean_done_result,batt_clean_done_recheck,batt_clean_done_recheck_result,batt_clean_done_recheck_check," + "batt_clean_done_recheck_check_result,battvol_tempe_done,battvol_tempe_done_result,battvol_tempe_done_recheck,battvol_tempe_done_recheck_result,"+ "battvol_tempe_done_recheck_check,battvol_tempe_done_recheck_check_result,battfault_check_done,battfault_check_done_result,battfault_check_done_recheck,battfault_check_done_recheck_result," + "battfault_check_done_recheck_check,battfault_check_done_recheck_check_result) values("+ucheck.getTask_id()+",'"+ucheck.getTask_usr_ids()+"',"+ucheck.getBattGroupId()+","+ucheck.getTask_enabled()+",'"+ DAOHelper.sdf.format(ucheck.getTask_exe_date())+"','"+DAOHelper.sdf.format(ucheck.getTask_close_date())+"',"+ucheck.getTest_complete()+",'"+DAOHelper.sdf.format(ucheck.getTest_completetime())+"',"+ucheck.getBatt_clean_done()+",'"+ucheck.getBatt_clean_done_result()+"',"+ ucheck.getBatt_clean_done_recheck()+",'"+ucheck.getBatt_clean_done_recheck_result()+"',"+ucheck.getBatt_clean_done_recheck_check()+",'"+ucheck.getBatt_clean_done_recheck_check_result()+"',"+ ucheck.getBattvol_tempe_done()+",'"+ucheck.getBattvol_tempe_done_result()+"',"+ucheck.getBattvol_tempe_done_recheck()+",'"+ucheck.getBattvol_tempe_done_recheck_result()+"',"+ ucheck.getBattvol_tempe_done_recheck_check()+",'"+ucheck.getBattvol_tempe_done_recheck_check_result()+"',"+ucheck.getBattfault_check_done()+",'"+ucheck.getBattfault_check_done_result()+"',"+ ucheck.getBattfault_check_done_recheck()+",'"+ucheck.getBattfault_check_done_recheck_result()+"',"+ucheck.getBattfault_check_done_recheck_check()+",'"+ucheck.getBattfault_check_done_recheck_check_result()+"')"; return sql; } //4.1作业管理(提交/复查作业) public boolean update(Object obj) { User_task_batt_check ucheck=(User_task_batt_check) obj; String sql="update db_user.tb_user_task_batt_check set batt_clean_done=?,batt_clean_done_result=?,batt_clean_done_recheck=?,batt_clean_done_recheck_result=?,batt_clean_done_recheck_check=?," + "batt_clean_done_recheck_check_result=?,battvol_tempe_done=?,battvol_tempe_done_result=?,battvol_tempe_done_recheck=?,battvol_tempe_done_recheck_result=?,"+ "battvol_tempe_done_recheck_check=?,battvol_tempe_done_recheck_check_result=?,battfault_check_done=?,battfault_check_done_result=?,battfault_check_done_recheck_result=?," + "battfault_check_done_recheck_result=?,battfault_check_done_recheck_check=?,battfault_check_done_recheck_check_result=? where num=?"; Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ucheck.getBatt_clean_done(),ucheck.getBatt_clean_done_result(), ucheck.getBatt_clean_done_recheck(),ucheck.getBatt_clean_done_recheck_result(),ucheck.getBatt_clean_done_recheck_check(),ucheck.getBatt_clean_done_recheck_check_result(), ucheck.getBattvol_tempe_done(),ucheck.getBattvol_tempe_done_result(),ucheck.getBattvol_tempe_done_recheck(),ucheck.getBattvol_tempe_done_recheck_result(), ucheck.getBattvol_tempe_done_recheck_check(),ucheck.getBattvol_tempe_done_recheck_check_result(),ucheck.getBattfault_check_done(),ucheck.getBattfault_check_done_result(), ucheck.getBattfault_check_done_recheck(),ucheck.getBattfault_check_done_recheck_result(),ucheck.getBattfault_check_done_recheck_check(),ucheck.getBattfault_check_done_recheck_check_result(),ucheck.getNum()}); return bl; } public boolean del(Object obj) { User_task_batt_check ucheck=(User_task_batt_check) obj; String sql="delete from db_user.tb_user_task_batt_check where num=?"; Boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{ucheck.getNum()}); return bl; } public List searchAll() { String sql="select * from db_user.tb_user_task_batt_check"; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new User_task_batt_checkImpl()); return list; } //4.1根据task_id查询user_task_batt_check信息 public List serchByCondition(Object obj) { User_task utask=(User_task) obj; String sql="select distinct(task_id),tb_user_task_batt_check.num,task_usr_ids,tb_user_task_batt_check.BattGroupId,task_enabled,task_exe_date,task_close_date,test_complete,test_completetime,batt_clean_done," + "batt_clean_done_result,batt_clean_done_recheck,batt_clean_done_recheck_result,batt_clean_done_recheck_check," + "batt_clean_done_recheck_check_result,battvol_tempe_done,battvol_tempe_done_result,battvol_tempe_done_recheck,battvol_tempe_done_recheck_result,"+ "battvol_tempe_done_recheck_check,battvol_tempe_done_recheck_check_result,battfault_check_done,battfault_check_done_result,battfault_check_done_recheck," + "battfault_check_done_recheck_result,battfault_check_done_recheck_check,battfault_check_done_recheck_check_result," + "stationname ,battgroupname " + "from db_user.tb_user_task_batt_check,db_battinf.tb_battinf " + "where tb_user_task_batt_check.battgroupid=db_battinf.tb_battinf.battgroupid and task_id=? " + "order by task_id "; List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{utask.getTask_id()}, new User_task_batt_checkImpl()); return list; } public List serchByInfo(Object obj) { // TODO Auto-generated method stub return null; } public static void main(String[] args) { User_task_batt_checkImpl uc=new User_task_batt_checkImpl(); User_task utask=new User_task(); utask.setTask_id(1000004); List list=uc.serchByCondition(utask); for(Task_Batt_Test t:list){ System.out.println(t); } } }