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<Task_Batt_Test> list=uc.serchByCondition(utask);
|
for(Task_Batt_Test t:list){
|
System.out.println(t);
|
}
|
}
|
}
|
