package com.ld.igds.sec.service; import com.bstek.bdf2.core.orm.hibernate.HibernateDao; import com.ld.igds.models.SecSnapConf; import com.ld.igds.models.SecSnapDepot; import com.ld.igds.util.ContextUtil; import org.apache.commons.lang3.StringUtils; 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; @Component public class SecSnapService extends HibernateDao { /** * 根据条件获取配置类别 * * @param companyId 组织编码,不可为空 * @param deptId 所属分库,可为空 * @return 查询结果 */ public List listSnapConf(String companyId, String deptId) { String hql = " from " + SecSnapConf.class.getName() + " where companyId=:companyId"; Map args = new HashMap<>(); args.put("companyId", companyId); if (StringUtils.isNotEmpty(deptId)) { hql += " and deptId =:deptId"; args.put("deptId", deptId); } return this.query(hql, args); } public void addData(SecSnapConf snapConf, String fileName, String result) { Session session = this.getSessionFactory().openSession(); try { SecSnapDepot data = new SecSnapDepot(); data.setId(ContextUtil.getUUID()); data.setCompanyId(snapConf.getCompanyId()); data.setDeptId(snapConf.getDeptId()); data.setCameraId(snapConf.getCameraId()); data.setResult(result); data.setUpdateTime(new Date()); data.setFileSuffix("jpg"); data.setFileName(fileName); session.save(data); } catch (Exception e) { e.printStackTrace(); } finally { session.flush(); session.close(); } } }