国家电网设备资源管理系统.zip_jsp_sqlserver_国家电网_国家电网系统_电网管理系统

package com.sar.elec.service.impl.equipment; import java.io.File; import java.util.ArrayList; import java.util.Calendar; import java.util.Date; import java.util.Iterator; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import org.apache.struts.upload.FormFile; import com.sar.elec.dao.SarDeviceXJDAO; import com.sar.elec.domain.SarDevice; import com.sar.elec.domain.SarFileUpload; import com.sar.elec.domain.SarOverhaulRecord; import com.sar.elec.domain.SarUser; import com.sar.elec.exception.business.BusinessException; import com.sar.elec.service.equipment.SarDeviceXJManage; import com.sar.elec.service.impl.BaseService; import com.sar.elec.util.Constants; import com.sar.elec.util.PageInfo; import com.sar.elec.util.StringHelper; import com.sar.elec.util.UploadBean; import com.sar.elec.webapp.form.equipment.AddDeviceJForm; import com.sar.elec.webapp.form.equipment.AddDeviceXForm; import com.sar.elec.webapp.form.equipment.ChangePageDeviceJForm; import com.sar.elec.webapp.form.equipment.ChangePageDeviceXForm; import com.sar.elec.webapp.form.equipment.MoreUpdateDeviceJForm; import com.sar.elec.webapp.form.equipment.MoreUpdateDeviceXForm; import com.sar.elec.webapp.form.equipment.SearchDeviceJBean; import com.sar.elec.webapp.form.equipment.SearchDeviceJForm; import com.sar.elec.webapp.form.equipment.SearchDeviceXBean; import com.sar.elec.webapp.form.equipment.SearchDeviceXForm; import com.sar.elec.webapp.form.equipment.ShowDeviceXJBean; import com.sar.elec.webapp.form.equipment.TypeDeviceXForm; import com.sar.elec.webapp.form.equipment.UploadForm; public class SarDeviceXJManageImpl extends BaseService implements SarDeviceXJManage { private SarDeviceXJDAO sarDeviceXJDao; public void setSarDeviceXJDao(SarDeviceXJDAO sarDeviceXJDao) { this.sarDeviceXJDao = sarDeviceXJDao; } // add by liu on 2007-06-05 start public String getJctIdByDevId(String devId) { String jctId = sarDeviceXJDao.getJctIdByDevId(devId); return jctId; } // add by liu on 2007-06-05 end // add by liu on 2007-06-05 start public String getJctIdDdlNameByDdlCode(String jctId) { String jctIdDdlName = sarDeviceXJDao.getJctIdDdlNameByDdlCode(jctId); return jctIdDdlName; } // add by liu on 2007-06-05 end /** * 数据字典 * * @param HttpServletRequest * request * @return List null */ public List getSystemDLL(HttpServletRequest request) throws BusinessException { String operstr=(String)request.getSession().getAttribute("GLOBAL_RIGHTS"); List listTS=new ArrayList(); if(!operstr.contains("o")){ //如果不包含这个权限 listTS = sarDeviceXJDao.getSystemDLL("所属单位",(String)request.getSession().getAttribute("GLOBAL_USER_JCTID")); }else{ listTS = sarDeviceXJDao.getSystemDLL("所属单位"); } List list = sarDeviceXJDao.getSystemDLL("设备类型"); List listZT = sarDeviceXJDao.getSystemDLL("设备状态"); HttpSession session = request.getSession(); if (list == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } if (listTS == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } if (listZT == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } session.setAttribute("DT", list); session.setAttribute("TS", listTS); session.setAttribute("ZT", listZT); return null; } /** * 删除[设备校准记录] * * @param SarOverhaulRecord * sarOverhaulRecord */ public void delDeviceX(SarOverhaulRecord sarOverhaulRecord) throws BusinessException { // dao.removeObject(SarDevicePlan.class,sarDevice.getDevPlanId()); if (sarOverhaulRecord.getSeqId() == null || sarOverhaulRecord.getSeqId().equals("")) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } /* SarOverhaulRecord sor = (SarOverhaulRecord) dao.getObject( SarOverhaulRecord.class, sarOverhaulRecord.getSeqId()); */ //add by shijiandong on 2007-4-28 start 目的：查询所有此设备的检修记录 SarOverhaulRecord sor=new SarOverhaulRecord(); sor.setDevId(sarOverhaulRecord.getDevId()); sor.setIsAdjust("0"); List list=sarDeviceXJDao.getObjectsByExample(sor); //add by shijiandong on 2007-4-28 end if (sor == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } /* sor.setIsDelete("1"); dao.saveOrUpdateObject(sor); */ //add by shijiandong on 2007-4-28 start 目的：批量删除 sarDeviceXJDao.deleteList(list); //add by shijiandong on 2007-4-28 end SarDevice sarDevice = (SarDevice) dao.getObject(SarDevice.class, sarOverhaulRecord.getDevId()); sarDevice.setApstate("0"); dao.saveOrUpdateObject(sarDevice); } /** * 批量添加[设备校准记录] * * @param MoreUpdateDeviceXForm * moreUpdateDeviceXForm * @param HttpServletRequest * request */ public void saveMoreUpdateDeviceX(MoreUpdateDeviceXForm moreUpdateDeviceXForm, HttpServletRequest request) throws BusinessException { List devIdList = StringHelper.split(moreUpdateDeviceXForm.getDevId(),","); HttpSession session = request.getSession(); Date date = new Date(); SarUser sarUser = (SarUser) session.getAttribute(Constants.GLOBAL_USER); if (sarUser == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } if (devIdList == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } /*List sorlist=new ArrayList();*/ List sdlist=new ArrayList(); SarOverhaulRecord sor = null; Iterator iterator = devIdList.iterator(); while (iterator.hasNext()) { String str = (String) iterator.next(); sor = new SarOverhaulRecord(); sor.setDevId(str); sor.setIsAdjust("0"); sor.setRecord(moreUpdateDeviceXForm.getRecord()); sor.setComment(moreUpdateDeviceXForm.getComment()); sor.setCreateDate(date); sor.setLastDate(date); sor.setCreateEmpId(sarUser.getUserId()); sor.setLastEmpId(sarUser.getUserId()); sor.setIsDelete("0"); sor.setStartDate(StringHelper.converStringToDate(moreUpdateDeviceXForm.getStartDate()+ " 00:00:00")); if (moreUpdateDeviceXForm.getIsHaving().equals("1")) { sor.setIsHaving("1"); } else { sor.setIsHaving("0"); } // 自动取得校准日期+周期 if (str == null || str.equals("")) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } SarDevice SD = (SarDevice) dao.getObject(SarDevice.class, str); if (SD == null) { throw new BusinessException(Constants.ERRORMSG_NULLDATAERROR); } int margin = 0; Calendar calendar = null; calendar = Calendar.getInstance(); calendar.setTime(StringHelper.converStringToDate(moreUpdateDeviceXForm.getStartDate()+ " 00:00:00")); if (SD.getApunit().equals("年")) { margin = Integer.parseInt(SD.getAdjustPeriod()); int year = calendar.get(Calendar.YEAR); calendar.set(Calendar.YEAR, year + margin); } else { margin = Integer.parseInt(SD.getAdjustPeriod()); int month = calendar.get(Calendar.MONTH); calendar.set(Calendar.MONTH, month + margin); } // getTime()方法是取得当前的日期，其返回值是一个java.util.Date类的对象 Date date1 = calendar.getTime(); sor.setEndDate(date1); // 自动取得校准日期+周期 /*sorlist.add(sor);*/ // add by shijiandong on 2007-4-28 start 目的：在添加新记录之前。将该设备的所有记录改为历史记录（isDelete=1） SarOverhaulRecord updateSors=new SarOverhaulRecord(); updateSors.setDevId(str); updateSors.setIsAdjust("0"); List sorList=dao.getObjectsByExample(updateSors); List updateSorList=new ArrayList(); if (sorList.size()>0) { Iterator iter=sorList.iterator(); while (iter.hasNext()) { SarOverhaulRecord updateSor = (SarOverhaulRecord) iter.next(); updateS