package com.fgkj.services;
|
|
import java.text.ParseException;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
|
import com.fgkj.controller.ActionUtil;
|
import com.fgkj.mapper.DAOHelper;
|
import com.fgkj.mapper.impl.BattInfMapper;
|
import com.fgkj.mapper.impl.User_battmaint_checkMapper;
|
import com.fgkj.mapper.impl.User_battmaint_check_processMapper;
|
import com.fgkj.db.DBUtil;
|
import com.fgkj.dto.BattInf;
|
import com.fgkj.dto.Page;
|
import com.fgkj.dto.ServiceModel;
|
import com.fgkj.dto.Task_Batt_Test;
|
import com.fgkj.dto.User_battmaint_check_process;
|
import com.fgkj.dto.User_inf;
|
|
import com.fgkj.dto.User_battmaint_check;
|
import com.fgkj.mapper.impl.User_infMapper;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
@Service
|
public class User_battmaint_checkService {
|
|
@Autowired
|
private User_battmaint_checkMapper mapper;
|
@Autowired
|
private User_battmaint_check_processMapper processMapper;
|
@Autowired
|
private User_infMapper userInfMapper;
|
@Autowired
|
private BattInfMapper battInfMapper;
|
|
//4.10作业抽查管理(新建)
|
public ServiceModel add(Object obj) {
|
ServiceModel model=new ServiceModel();
|
Boolean bl=mapper.add(obj);
|
if(bl){
|
model.setCode(1);
|
model.setMsg("添加成功!");
|
}
|
else{
|
model.setMsg("添加失败!");
|
}
|
return model;
|
|
}
|
//4.10作业抽查管理(编辑记录)
|
public ServiceModel update(Object obj) {
|
ServiceModel model=new ServiceModel();
|
Boolean bl=mapper.update(obj);
|
if(bl){
|
model.setCode(1);
|
model.setMsg("修改成功!");
|
}
|
else{
|
model.setMsg("修改失败!");
|
}
|
return model;
|
}
|
//4.10作业抽查管理(编辑记录)(user_battmaint_check表修改时User_battmaint_check_process表就新增一条记录)
|
public ServiceModel updatePro(Object obj1,Object obj2) {
|
ServiceModel model=new ServiceModel();
|
User_battmaint_check ucheck=(User_battmaint_check) obj1;
|
List<User_battmaint_check_process> list=(List<User_battmaint_check_process>) obj2;
|
ArrayList<String> str_sql=new ArrayList<String>();//存放所有的sql语句
|
//修改User_battmaint_check表
|
String sqlCheck=mapper.updatePro(ucheck);
|
str_sql.add(sqlCheck);
|
if(list!=null && list.size()>0){
|
for (int i = 0; i < list.size(); i++) {
|
//Date caption_time=new Date();
|
//System.out.println("caption_time:"+caption_time);
|
//list.get(i).setWork_caption_time(caption_time);
|
//新增User_battmaint_check_process表
|
String sqlProcess=processMapper.addPro(list.get(i));
|
str_sql.add(sqlProcess);
|
}
|
}
|
//System.out.println(str_sql);
|
Boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), str_sql);
|
if(bl){
|
model.setCode(1);
|
model.setMsg("修改成功!");
|
}
|
else{
|
model.setMsg("修改失败!");
|
}
|
return model;
|
}
|
//4.10作业抽查管理(删除记录)
|
public ServiceModel delete(Object obj) {
|
ServiceModel model=new ServiceModel();
|
Boolean bl=mapper.del(obj);
|
if(bl){
|
model.setCode(1);
|
model.setMsg("删除成功!");
|
}
|
else{
|
model.setMsg("删除失败!");
|
}
|
return model;
|
}
|
//4.10作业抽查管理(删除记录)
|
public ServiceModel deletePro(Object obj) {
|
ServiceModel model=new ServiceModel();
|
User_battmaint_check ucheck=(User_battmaint_check) obj;
|
//删除对应的User_battmaint_check_process
|
User_battmaint_check_process uprocess=new User_battmaint_check_process();
|
uprocess.setTask_rec_id(ucheck.getNum());
|
ArrayList<String> str_sql=new ArrayList<String>();//存放所有的sql语句
|
//删除User_battmaint_check表
|
String sqlCheck=mapper.delPro(ucheck);
|
str_sql.add(sqlCheck);
|
//删除User_battmaint_check_process表中task_rec_id对应的记录
|
String sqlProcess=processMapper.delPro(uprocess);
|
str_sql.add(sqlProcess);
|
Boolean bl= DAOHelper.makeManualCommit(DBUtil.getConn(), str_sql);
|
if(bl){
|
model.setCode(1);
|
model.setMsg("修改成功!");
|
}
|
else{
|
model.setMsg("修改失败!");
|
}
|
return model;
|
}
|
|
//4.10作业抽查管理
|
public ServiceModel serchByCondition(Object obj){
|
ServiceModel model=new ServiceModel();
|
List<Task_Batt_Test> list=mapper.serchByCondition(obj);
|
|
User_inf uinf=new User_inf();
|
int usr_id=0;//责任人
|
String usr_name="";
|
int master_id=0;//创建人
|
String master_name="";
|
int appoint_uid=0;//指派人
|
String appoint_name="";
|
String copy_ids="";//抄送人
|
int copy_id=0;
|
String copy_name="";
|
String[] copy_names;
|
for(int i=0;i<list.size();i++){
|
BattInf binf=new BattInf();
|
//电池组组数
|
binf.setStationName(list.get(i).getMcheck().getRemark());
|
binf.setStationName1("");
|
List listbinf=battInfMapper.serchByBattGroupName(binf);
|
list.get(i).getMcheck().setStationId(listbinf.size());
|
//责任人/创建人/指派人/抄送人
|
usr_id=list.get(i).getMcheck().getUsr_id();
|
uinf.setUId(usr_id);
|
usr_name=((User_inf)userInfMapper.serchUname(uinf).get(0)).getUName();
|
binf.setStationName6(usr_name);
|
|
master_id=list.get(i).getMcheck().getMaster_id();
|
uinf.setUId(master_id);
|
master_name=((User_inf)userInfMapper.serchUname(uinf).get(0)).getUName();
|
binf.setStationName7(master_name);
|
|
appoint_uid=list.get(i).getMcheck().getAppoint_uid();
|
uinf.setUId(appoint_uid);
|
appoint_name=((User_inf)userInfMapper.serchUname(uinf).get(0)).getUName();
|
binf.setStationName8(appoint_name);
|
//System.out.println(usr_name+" "+master_name+" "+appoint_name);
|
copy_ids=list.get(i).getMcheck().getCopy_uids();
|
copy_names=copy_ids.split(",");
|
for(int j=0;j<copy_names.length;j++){
|
copy_id=Integer.parseInt(copy_names[j]);
|
uinf.setUId(copy_id);
|
copy_name+=",";
|
copy_name+=((User_inf)userInfMapper.serchUname(uinf).get(0)).getUName();
|
}
|
binf.setStationName9(copy_name.substring(1, copy_name.length()));
|
//System.out.println(binf.getStationName9());
|
list.get(i).setBinf(binf);
|
copy_name="";
|
}
|
if(list!=null && list.size()>0){
|
model.setCode(1);
|
model.setData(list);
|
}
|
List<Task_Batt_Test> listt=(List<Task_Batt_Test>)model.getData();
|
// for (Task_Batt_Test t : listt) {
|
// System.out.println(t.getBinf().getStationName9()+" "+t.getMcheck().getCopy_uids());
|
// }
|
return model;
|
}
|
|
|
public ServiceModel searchAll() {
|
ServiceModel model=new ServiceModel();
|
List<User_battmaint_check> list = mapper.searchAll();
|
//System.out.println(list.size());
|
|
if (list != null && list.size() > 0) {
|
model.setCode(1);
|
model.setData(list);
|
}
|
return model;
|
}
|
|
}
|
