From 69cd9f59a0fabf12f8c9147fcba7f69817a870b3 Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期一, 06 十一月 2023 23:40:59 +0800
Subject: [PATCH] 更新仓内抓拍2
---
igds-security/src/main/java/com/ld/igds/sec/service/SecSnapDepotService.java | 98 +++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 98 insertions(+), 0 deletions(-)
diff --git a/igds-security/src/main/java/com/ld/igds/sec/service/SecSnapDepotService.java b/igds-security/src/main/java/com/ld/igds/sec/service/SecSnapDepotService.java
index dc525f6..f5e606b 100644
--- a/igds-security/src/main/java/com/ld/igds/sec/service/SecSnapDepotService.java
+++ b/igds-security/src/main/java/com/ld/igds/sec/service/SecSnapDepotService.java
@@ -2,13 +2,19 @@
import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
import com.bstek.dorado.data.provider.Page;
+import com.ld.igds.models.SecSnapConf;
import com.ld.igds.models.SecSnapDepot;
+import com.ld.igds.util.ContextUtil;
import com.ld.igds.util.DateUtil;
+
import org.apache.commons.lang3.StringUtils;
+import org.hibernate.Query;
+import org.hibernate.Session;
import org.springframework.stereotype.Repository;
import java.util.Date;
import java.util.HashMap;
+import java.util.List;
import java.util.Map;
@Repository
@@ -48,4 +54,96 @@
this.pagingQuery(page, hql, countHql, args);
}
+
+
+ /**
+ * 鏍规嵁鏉′欢鑾峰彇閰嶇疆绫诲埆
+ *
+ * @param companyId 缁勭粐缂栫爜锛屼笉鍙负绌�
+ * @param deptId 鎵�灞炲垎搴擄紝鍙负绌�
+ * @return 鏌ヨ缁撴灉
+ */
+ public List<SecSnapConf> listSnapConf(String companyId, String deptId) {
+ String hql = " from " + SecSnapConf.class.getName()
+ + " where companyId=:companyId";
+
+ Map<String, Object> 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.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();
+ }
+ }
+
+
+ public void addConf(SecSnapConf conf) {
+ Session session = this.getSessionFactory().openSession();
+ try {
+ conf.setId(ContextUtil.getUUID());
+ conf.setUpdateTime(new Date());
+ session.save(conf);
+ } catch (Exception e) {
+ e.printStackTrace();
+ } finally {
+ session.flush();
+ session.close();
+ }
+ }
+
+
+ public void updateConf(SecSnapConf conf) {
+ Session session = this.getSessionFactory().openSession();
+ try {
+ conf.setUpdateTime(new Date());
+ session.save(conf);
+ } catch (Exception e) {
+ e.printStackTrace();
+ } finally {
+ session.flush();
+ session.close();
+ }
+ }
+
+
+ public void updateActHour(SecSnapConf conf) {
+ String hql = " update "+SecSnapConf.class.getName()+" set actHour1=:actHour1,actHour2=:actHour2,actHour3=:actHour3 where companyId=:companyId and deptId=:deptId";
+
+ Session session = this.getSessionFactory().openSession();
+ try {
+ Query q = session.createQuery(hql);
+ q.setInteger("actHour1", conf.getActHour1());
+ q.setInteger("actHour2", conf.getActHour2());
+ q.setInteger("actHour3", conf.getActHour3());
+ q.setString("companyId", conf.getCompanyId());
+ q.setString("deptId", conf.getDeptId());
+ q.executeUpdate();
+ } catch (Exception e) {
+ e.printStackTrace();
+ } finally {
+ session.flush();
+ session.close();
+ }
+ }
}
--
Gitblit v1.9.3