From cbe1226ae82f1818e13b7a4faa965b591d631633 Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期三, 11 十月 2023 12:24:18 +0800
Subject: [PATCH] 更新油罐页面
---
igds-recir/src/main/java/com/ld/igds/drug/service/HDrugLogApplyService.java | 64 +++++++++----------------------
1 files changed, 19 insertions(+), 45 deletions(-)
diff --git a/igds-recir/src/main/java/com/ld/igds/drug/service/HDrugLogApplyService.java b/igds-recir/src/main/java/com/ld/igds/drug/service/HDrugLogApplyService.java
index 79420de..ec6db94 100644
--- a/igds-recir/src/main/java/com/ld/igds/drug/service/HDrugLogApplyService.java
+++ b/igds-recir/src/main/java/com/ld/igds/drug/service/HDrugLogApplyService.java
@@ -1,5 +1,6 @@
package com.ld.igds.drug.service;
+import com.bstek.bdf2.core.model.RoleMember;
import com.bstek.bdf2.core.orm.hibernate.HibernateDao;
import com.bstek.dorado.data.provider.Page;
import com.ld.igds.constant.RedisConst;
@@ -8,6 +9,7 @@
import com.ld.igds.util.RedisUtil;
import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.time.DateFormatUtils;
+import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
@@ -95,7 +97,7 @@
session.saveOrUpdate(way);
DrugLogDtl dtl = new DrugLogDtl();
BeanUtils.copyProperties(data, dtl);
- way.setDrugLogId(data.getXzbm());
+ dtl.setDrugLogId(data.getXzbm());
session.saveOrUpdate(dtl);
} catch (Exception e) {
e.printStackTrace();
@@ -104,41 +106,6 @@
session.close();
}
return null;
- }
-
- private void saveWay(DrugLogApply data) {
- Session session = this.getSessionFactory().openSession();
-
- try {
- DrugLogWay way = new DrugLogWay();
- BeanUtils.copyProperties(data, way);
- way.setWayId(ContextUtil.getUUID());
- session.saveOrUpdate(way);
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- session.flush();
- session.close();
- }
- }
-
- /**
- * 鏍规嵁涓昏〃淇℃伅娣诲姞绮儏瀛楄〃
- *
- * @param data
- */
- private void saveDtl(DrugLogApply data) {
- Session session = this.getSessionFactory().openSession();
- try {
- DrugLogDtl dtl = new DrugLogDtl();
- BeanUtils.copyProperties(data, dtl);
- session.saveOrUpdate(dtl);
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- session.flush();
- session.close();
- }
}
/**
@@ -152,9 +119,20 @@
try {
if (null != data.getXzbm()) {
session.delete(data);
- for (DrugLogPeople drugLogPeople : data.getDrugLogPeople()) {
- session.delete(drugLogPeople);
- }
+ String hqlPeople = "delete from " + DrugLogPeople.class.getName() + " where DRUG_LOG_ID_=:drugLogId";
+ Query queryPeople = session.createQuery(hqlPeople);
+ queryPeople.setString("drugLogId", data.getXzbm());
+ queryPeople.executeUpdate();
+
+ String hqlDtl = "delete from " + DrugLogDtl.class.getName() + " where DRUG_LOG_ID_=:drugLogId";
+ Query queryDtl = session.createQuery(hqlDtl);
+ queryDtl.setString("drugLogId", data.getXzbm());
+ queryDtl.executeUpdate();
+
+ String hqlWay = "delete from " + DrugLogWay.class.getName() + " where DRUG_LOG_ID_=:drugLogId";
+ Query queryWay = session.createQuery(hqlWay);
+ queryWay.setString("drugLogId", data.getXzbm());
+ queryWay.executeUpdate();
}
} catch (Exception e) {
e.printStackTrace();
@@ -257,13 +235,9 @@
Map<String, Object> args = new HashMap<>();
if (null != param) {
-
String xzbm = (String) param.get("xzbm");
- String deptId = (String) param.get("deptId");
- String tbrq = DateFormatUtils.format((Date) param.get("tbrq"), "yyyyMMdd");
- String id = xzbm + deptId + tbrq;
- hql.append(" from " + DrugLogPeople.class.getName() + " where id=:id");
- args.put("id", id);
+ hql.append(" from " + DrugLogPeople.class.getName() + " where DRUG_LOG_ID_=:id");
+ args.put("id", xzbm);
buildHql(hql, param, args);
}
return this.query(String.valueOf(hql), args);
--
Gitblit v1.9.3