对比新文件 |
| | |
| | | package com.ld.igds.warn.service; |
| | | |
| | | import com.bstek.bdf2.core.orm.hibernate.HibernateDao; |
| | | import com.bstek.dorado.data.provider.Page; |
| | | import com.ld.igds.models.SecureManager; |
| | | import com.ld.igds.util.ContextUtil; |
| | | import com.ld.igds.util.DateUtil; |
| | | import org.apache.commons.lang3.time.DateFormatUtils; |
| | | import org.hibernate.Session; |
| | | import org.springframework.stereotype.Component; |
| | | import java.util.Date; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @author czt |
| | | * @date 2023/10/30 |
| | | **/ |
| | | @Component |
| | | public class HSecureManagerService extends HibernateDao { |
| | | |
| | | |
| | | public void listData(Page<SecureManager> page, Map<String, Object> param) throws Exception { |
| | | StringBuffer hql = new StringBuffer(); |
| | | hql.append(" from " + SecureManager.class.getName() + " where companyId =:companyId and deptId =:deptId "); |
| | | Map<String, Object> args = new HashMap<>(); |
| | | args.put("companyId", ContextUtil.getCompanyId()); |
| | | args.put("deptId", ContextUtil.subDeptId(null)); |
| | | |
| | | String count = "select count(*) " + hql.toString(); |
| | | hql.append(" order by updateTime desc"); |
| | | this.pagingQuery(page, hql.toString(), count, args); |
| | | |
| | | } |
| | | |
| | | public void saveData(SecureManager data) { |
| | | data.setUpdateTime(new Date()); |
| | | data.setDeptId(ContextUtil.subDeptId(null)); |
| | | data.setCompanyId(ContextUtil.getCompanyId()); |
| | | Session session = this.getSessionFactory().openSession(); |
| | | try { |
| | | if (null == data.getFxdbm()) { |
| | | data.setFxdbm(DateFormatUtils.format(new Date(), "yyyyMMdd") + getIndex(data.getCompanyId())); |
| | | |
| | | session.save(data); |
| | | } else { |
| | | session.update(data); |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } finally { |
| | | session.flush(); |
| | | session.close(); |
| | | } |
| | | } |
| | | |
| | | public String getIndex(String companyId) { |
| | | List<SecureManager> list = getDataByTime(companyId); |
| | | int index = 10000; |
| | | if (list != null && list.size() > 0) { |
| | | String id = list.get(0).getFxdbm().substring(8); |
| | | int temp = Integer.valueOf(id) + 1; |
| | | index += temp; |
| | | }else { |
| | | index ++; |
| | | } |
| | | return String.valueOf(index).substring(1); |
| | | } |
| | | |
| | | private List<SecureManager> getDataByTime(String companyId) { |
| | | String hql = " from " + SecureManager.class.getName() |
| | | + " where companyId =:companyId "; |
| | | |
| | | Map<String, Object> args = new HashMap<String, Object>(); |
| | | args.put("companyId", companyId); |
| | | |
| | | hql += " and updateTime >:startTime"; |
| | | args.put("startTime", DateUtil.getCurZero(new Date())); |
| | | |
| | | |
| | | hql += " and updateTime <:endTime"; |
| | | args.put("endTime", DateUtil.getNextZero(new Date())); |
| | | |
| | | |
| | | hql += " order by id desc"; |
| | | |
| | | return this.query(hql, args); |
| | | } |
| | | |
| | | public void delData(SecureManager data) { |
| | | Session session = this.getSessionFactory().openSession(); |
| | | try { |
| | | if (null != data.getFxdbm()) { |
| | | session.delete(data); |
| | | } |
| | | } catch (Exception e) { |
| | | e.printStackTrace(); |
| | | } finally { |
| | | session.flush(); |
| | | session.close(); |
| | | } |
| | | } |
| | | |
| | | } |