From 0839b96dce23c1e53934dfd1f0ae8c1720ca8dfd Mon Sep 17 00:00:00 2001
From: qianxj <qianxj15@sina.com>
Date: 星期四, 23 二月 2023 20:35:08 +0800
Subject: [PATCH] smartor update
---
smartor/src/main/java/com/smartor/domain/PatArchive.java | 276 +++++++++++++++
smartor/src/main/java/com/smartor/domain/PatMedOuthosp.java | 326 ++++++++++++++++++
smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml | 190 ++++++++++
smartor/src/main/java/com/smartor/mapper/PatArchiveMapper.java | 87 ++++
smartor/src/main/java/com/smartor/service/impl/PatArchiveServiceImpl.java | 134 +++++++
smartor/src/main/java/com/smartor/service/IPatArchiveService.java | 61 +++
6 files changed, 1,074 insertions(+), 0 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/domain/PatArchive.java b/smartor/src/main/java/com/smartor/domain/PatArchive.java
new file mode 100644
index 0000000..5adfe8f
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/domain/PatArchive.java
@@ -0,0 +1,276 @@
+package com.smartor.domain;
+
+import java.util.List;
+import java.util.Date;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.common.core.domain.BaseEntity;
+
+/**
+ * 鎮ｈ�呮。妗堝璞� pat_archive
+ *
+ * @author ruoyi
+ * @date 2023-02-22
+ */
+public class PatArchive extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** 鑷ID */
+ private Long PatID;
+
+ /** 濮撳悕 */
+ @Excel(name = " 濮撳悕 ")
+ private String Name;
+
+ /** 鎬у埆 */
+ @Excel(name = " 鎬у埆 ")
+ private Long Gender;
+
+ /** 璇佷欢鍙风爜 */
+ @Excel(name = " 璇佷欢鍙风爜 ")
+ private String PapersNumber;
+
+ /** 鐢熸棩 */
+ private Date BirthDate;
+
+ /** 鏉ユ簮 */
+ @Excel(name = " 鏉ユ簮 ")
+ private Long Source;
+
+ /** 寤烘。鏃堕棿 */
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = " 寤烘。鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date MakeArchiveTime;
+
+ /** 寤烘。浜� */
+ private String MakeArchivePeople;
+
+ /** 鎵嬫満鍙风爜 */
+ @Excel(name = " 鎵嬫満鍙风爜 ")
+ private String MobileNumberCode;
+
+ /** 浜插睘鍙风爜 */
+ private String RelativesNumber;
+
+ /** 璇佷欢绫诲瀷 */
+ private String PapersType;
+
+ /** 鏈烘瀯ID */
+ @Excel(name = " 鏈烘瀯ID ")
+ private String OrgID;
+
+ /** 鍒犻櫎鏍囪 */
+ @Excel(name = " 鍒犻櫎鏍囪 ")
+ private String delFlag;
+
+ /** 涓婁紶鏍囪 */
+ private Long IsUpload;
+
+ /** 涓婁紶鏃堕棿 */
+ private Date uploadTime;
+
+ /** 骞撮緞 */
+ @Excel(name = " 骞撮緞 ")
+ private Long Age;
+
+ /** 寰俊openid */
+ private String OpenId;
+
+ /** 鎮ｈ�呴棬璇婅褰曚俊鎭� */
+ private List<PatMedOuthosp> patMedOuthospList;
+
+ public void setPatID(Long PatID)
+ {
+ this.PatID = PatID;
+ }
+
+ public Long getPatID()
+ {
+ return PatID;
+ }
+ public void setName(String Name)
+ {
+ this.Name = Name;
+ }
+
+ public String getName()
+ {
+ return Name;
+ }
+ public void setGender(Long Gender)
+ {
+ this.Gender = Gender;
+ }
+
+ public Long getGender()
+ {
+ return Gender;
+ }
+ public void setPapersNumber(String PapersNumber)
+ {
+ this.PapersNumber = PapersNumber;
+ }
+
+ public String getPapersNumber()
+ {
+ return PapersNumber;
+ }
+ public void setBirthDate(Date BirthDate)
+ {
+ this.BirthDate = BirthDate;
+ }
+
+ public Date getBirthDate()
+ {
+ return BirthDate;
+ }
+ public void setSource(Long Source)
+ {
+ this.Source = Source;
+ }
+
+ public Long getSource()
+ {
+ return Source;
+ }
+ public void setMakeArchiveTime(Date MakeArchiveTime)
+ {
+ this.MakeArchiveTime = MakeArchiveTime;
+ }
+
+ public Date getMakeArchiveTime()
+ {
+ return MakeArchiveTime;
+ }
+ public void setMakeArchivePeople(String MakeArchivePeople)
+ {
+ this.MakeArchivePeople = MakeArchivePeople;
+ }
+
+ public String getMakeArchivePeople()
+ {
+ return MakeArchivePeople;
+ }
+ public void setMobileNumberCode(String MobileNumberCode)
+ {
+ this.MobileNumberCode = MobileNumberCode;
+ }
+
+ public String getMobileNumberCode()
+ {
+ return MobileNumberCode;
+ }
+ public void setRelativesNumber(String RelativesNumber)
+ {
+ this.RelativesNumber = RelativesNumber;
+ }
+
+ public String getRelativesNumber()
+ {
+ return RelativesNumber;
+ }
+ public void setPapersType(String PapersType)
+ {
+ this.PapersType = PapersType;
+ }
+
+ public String getPapersType()
+ {
+ return PapersType;
+ }
+ public void setOrgID(String OrgID)
+ {
+ this.OrgID = OrgID;
+ }
+
+ public String getOrgID()
+ {
+ return OrgID;
+ }
+ public void setDelFlag(String delFlag)
+ {
+ this.delFlag = delFlag;
+ }
+
+ public String getDelFlag()
+ {
+ return delFlag;
+ }
+ public void setIsUpload(Long IsUpload)
+ {
+ this.IsUpload = IsUpload;
+ }
+
+ public Long getIsUpload()
+ {
+ return IsUpload;
+ }
+ public void setUploadTime(Date uploadTime)
+ {
+ this.uploadTime = uploadTime;
+ }
+
+ public Date getUploadTime()
+ {
+ return uploadTime;
+ }
+ public void setAge(Long Age)
+ {
+ this.Age = Age;
+ }
+
+ public Long getAge()
+ {
+ return Age;
+ }
+ public void setOpenId(String OpenId)
+ {
+ this.OpenId = OpenId;
+ }
+
+ public String getOpenId()
+ {
+ return OpenId;
+ }
+
+ public List<PatMedOuthosp> getPatMedOuthospList()
+ {
+ return patMedOuthospList;
+ }
+
+ public void setPatMedOuthospList(List<PatMedOuthosp> patMedOuthospList)
+ {
+ this.patMedOuthospList = patMedOuthospList;
+ }
+
+ @Override
+ public String toString() {
+ return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+ .append("PatID", getPatID())
+ .append("Name", getName())
+ .append("Gender", getGender())
+ .append("PapersNumber", getPapersNumber())
+ .append("BirthDate", getBirthDate())
+ .append("Source", getSource())
+ .append("MakeArchiveTime", getMakeArchiveTime())
+ .append("MakeArchivePeople", getMakeArchivePeople())
+ .append("MobileNumberCode", getMobileNumberCode())
+ .append("RelativesNumber", getRelativesNumber())
+ .append("PapersType", getPapersType())
+ .append("OrgID", getOrgID())
+ .append("delFlag", getDelFlag())
+ .append("updateBy", getUpdateBy())
+ .append("updateTime", getUpdateTime())
+ .append("createBy", getCreateBy())
+ .append("createTime", getCreateTime())
+ .append("IsUpload", getIsUpload())
+ .append("uploadTime", getUploadTime())
+ .append("Age", getAge())
+ .append("OpenId", getOpenId())
+ .append("patMedOuthospList", getPatMedOuthospList())
+ .toString();
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/domain/PatMedOuthosp.java b/smartor/src/main/java/com/smartor/domain/PatMedOuthosp.java
new file mode 100644
index 0000000..3234bca
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/domain/PatMedOuthosp.java
@@ -0,0 +1,326 @@
+package com.smartor.domain;
+
+import java.util.Date;
+import com.fasterxml.jackson.annotation.JsonFormat;
+import org.apache.commons.lang3.builder.ToStringBuilder;
+import org.apache.commons.lang3.builder.ToStringStyle;
+import com.ruoyi.common.annotation.Excel;
+import com.ruoyi.common.core.domain.BaseEntity;
+
+/**
+ * 鎮ｈ�呴棬璇婅褰曞璞� pat_med_outhosp
+ *
+ * @author ruoyi
+ * @date 2023-02-22
+ */
+public class PatMedOuthosp extends BaseEntity
+{
+ private static final long serialVersionUID = 1L;
+
+ /** 鑷ID */
+ private Long ID;
+
+ /** 娴佹按鍙� */
+ @Excel(name = " 娴佹按鍙� ")
+ private String SerialNum;
+
+ /** 妗ｆID */
+ @Excel(name = " 妗ｆID ")
+ private Long PatID;
+
+ /** 鍖婚櫌鍚嶇О */
+ @Excel(name = " 鍖婚櫌鍚嶇О ")
+ private String HospitalName;
+
+ /** 鍖婚櫌缂栧彿 */
+ @Excel(name = " 鍖婚櫌缂栧彿 ")
+ private String HospitalCode;
+
+ /** 璇婃柇ICD鍊� */
+ @Excel(name = " 璇婃柇ICD鍊� ")
+ private String Icd10Code;
+
+ /** 璇婃柇鍚嶇О */
+ @Excel(name = " 璇婃柇鍚嶇О ")
+ private String DiagName;
+
+ /** 绉戝浠ｇ爜 */
+ @Excel(name = " 绉戝浠ｇ爜 ")
+ private String DeptCode;
+
+ /** 绉戝鍚嶇О */
+ @Excel(name = " 绉戝鍚嶇О ")
+ private String DeptName;
+
+ /** 鍖荤敓宸ュ彿 */
+ @Excel(name = " 鍖荤敓宸ュ彿 ")
+ private String DrCode;
+
+ /** 鍖荤敓鍚嶇О */
+ @Excel(name = " 鍖荤敓鍚嶇О ")
+ private String DrName;
+
+ /** 灏辫瘖鏃ユ湡 */
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = " 灏辫瘖鏃ユ湡 ", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date AdmitDate;
+
+ /** 鏈烘瀯ID */
+ @Excel(name = " 鏈烘瀯ID ")
+ private String OrgID;
+
+ /** 鍒犻櫎鏍囪 */
+ @Excel(name = " 鍒犻櫎鏍囪 ")
+ private String delFlag;
+
+ /** 涓婁紶鏍囪 */
+ @Excel(name = " 涓婁紶鏍囪 ")
+ private Long IsUpload;
+
+ /** 涓婁紶鏃堕棿 */
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = " 涓婁紶鏃堕棿 ", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date uploadTime;
+
+ /** 鏄惁鐢熸垚鏂规鐘舵��;0鏈敓鎴� 1鐢熸垚灏辫瘖 9鏃犲尮閰嶆柟妗� */
+ @Excel(name = " 鏄惁鐢熸垚鏂规鐘舵��;0鏈敓鎴� 1鐢熸垚灏辫瘖 9鏃犲尮閰嶆柟妗� ")
+ private Long SchemeStatus;
+
+ /** 绉戝ID */
+ @Excel(name = " 绉戝ID ")
+ private Long DeptID;
+
+ /** 鏂规鐘舵�佹搷浣滄椂闂� */
+ @JsonFormat(pattern = "yyyy-MM-dd")
+ @Excel(name = " 鏂规鐘舵�佹搷浣滄椂闂� ", width = 30, dateFormat = "yyyy-MM-dd")
+ private Date SchemeTime;
+
+ /** 鐜扮梾鍙� */
+ @Excel(name = " 鐜扮梾鍙� ")
+ private String HPI;
+
+ /** 涓昏堪 */
+ @Excel(name = " 涓昏堪 ")
+ private String MainSuit;
+
+ public void setID(Long ID)
+ {
+ this.ID = ID;
+ }
+
+ public Long getID()
+ {
+ return ID;
+ }
+ public void setSerialNum(String SerialNum)
+ {
+ this.SerialNum = SerialNum;
+ }
+
+ public String getSerialNum()
+ {
+ return SerialNum;
+ }
+ public void setPatID(Long PatID)
+ {
+ this.PatID = PatID;
+ }
+
+ public Long getPatID()
+ {
+ return PatID;
+ }
+ public void setHospitalName(String HospitalName)
+ {
+ this.HospitalName = HospitalName;
+ }
+
+ public String getHospitalName()
+ {
+ return HospitalName;
+ }
+ public void setHospitalCode(String HospitalCode)
+ {
+ this.HospitalCode = HospitalCode;
+ }
+
+ public String getHospitalCode()
+ {
+ return HospitalCode;
+ }
+ public void setIcd10Code(String Icd10Code)
+ {
+ this.Icd10Code = Icd10Code;
+ }
+
+ public String getIcd10Code()
+ {
+ return Icd10Code;
+ }
+ public void setDiagName(String DiagName)
+ {
+ this.DiagName = DiagName;
+ }
+
+ public String getDiagName()
+ {
+ return DiagName;
+ }
+ public void setDeptCode(String DeptCode)
+ {
+ this.DeptCode = DeptCode;
+ }
+
+ public String getDeptCode()
+ {
+ return DeptCode;
+ }
+ public void setDeptName(String DeptName)
+ {
+ this.DeptName = DeptName;
+ }
+
+ public String getDeptName()
+ {
+ return DeptName;
+ }
+ public void setDrCode(String DrCode)
+ {
+ this.DrCode = DrCode;
+ }
+
+ public String getDrCode()
+ {
+ return DrCode;
+ }
+ public void setDrName(String DrName)
+ {
+ this.DrName = DrName;
+ }
+
+ public String getDrName()
+ {
+ return DrName;
+ }
+ public void setAdmitDate(Date AdmitDate)
+ {
+ this.AdmitDate = AdmitDate;
+ }
+
+ public Date getAdmitDate()
+ {
+ return AdmitDate;
+ }
+ public void setOrgID(String OrgID)
+ {
+ this.OrgID = OrgID;
+ }
+
+ public String getOrgID()
+ {
+ return OrgID;
+ }
+ public void setDelFlag(String delFlag)
+ {
+ this.delFlag = delFlag;
+ }
+
+ public String getDelFlag()
+ {
+ return delFlag;
+ }
+ public void setIsUpload(Long IsUpload)
+ {
+ this.IsUpload = IsUpload;
+ }
+
+ public Long getIsUpload()
+ {
+ return IsUpload;
+ }
+ public void setUploadTime(Date uploadTime)
+ {
+ this.uploadTime = uploadTime;
+ }
+
+ public Date getUploadTime()
+ {
+ return uploadTime;
+ }
+ public void setSchemeStatus(Long SchemeStatus)
+ {
+ this.SchemeStatus = SchemeStatus;
+ }
+
+ public Long getSchemeStatus()
+ {
+ return SchemeStatus;
+ }
+ public void setDeptID(Long DeptID)
+ {
+ this.DeptID = DeptID;
+ }
+
+ public Long getDeptID()
+ {
+ return DeptID;
+ }
+ public void setSchemeTime(Date SchemeTime)
+ {
+ this.SchemeTime = SchemeTime;
+ }
+
+ public Date getSchemeTime()
+ {
+ return SchemeTime;
+ }
+ public void setHPI(String HPI)
+ {
+ this.HPI = HPI;
+ }
+
+ public String getHPI()
+ {
+ return HPI;
+ }
+ public void setMainSuit(String MainSuit)
+ {
+ this.MainSuit = MainSuit;
+ }
+
+ public String getMainSuit()
+ {
+ return MainSuit;
+ }
+
+ @Override
+ public String toString() {
+ return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
+ .append("ID", getID())
+ .append("SerialNum", getSerialNum())
+ .append("PatID", getPatID())
+ .append("HospitalName", getHospitalName())
+ .append("HospitalCode", getHospitalCode())
+ .append("Icd10Code", getIcd10Code())
+ .append("DiagName", getDiagName())
+ .append("DeptCode", getDeptCode())
+ .append("DeptName", getDeptName())
+ .append("DrCode", getDrCode())
+ .append("DrName", getDrName())
+ .append("AdmitDate", getAdmitDate())
+ .append("OrgID", getOrgID())
+ .append("delFlag", getDelFlag())
+ .append("updateBy", getUpdateBy())
+ .append("updateTime", getUpdateTime())
+ .append("createBy", getCreateBy())
+ .append("createTime", getCreateTime())
+ .append("IsUpload", getIsUpload())
+ .append("uploadTime", getUploadTime())
+ .append("SchemeStatus", getSchemeStatus())
+ .append("DeptID", getDeptID())
+ .append("SchemeTime", getSchemeTime())
+ .append("HPI", getHPI())
+ .append("MainSuit", getMainSuit())
+ .toString();
+ }
+}
diff --git a/smartor/src/main/java/com/smartor/mapper/PatArchiveMapper.java b/smartor/src/main/java/com/smartor/mapper/PatArchiveMapper.java
new file mode 100644
index 0000000..e8eada3
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/mapper/PatArchiveMapper.java
@@ -0,0 +1,87 @@
+package com.smartor.mapper;
+
+import java.util.List;
+import com.smartor.domain.PatArchive;
+import com.smartor.domain.PatMedOuthosp;
+
+/**
+ * 鎮ｈ�呮。妗圡apper鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2023-02-22
+ */
+public interface PatArchiveMapper
+{
+ /**
+ * 鏌ヨ鎮ｈ�呮。妗�
+ *
+ * @param PatID 鎮ｈ�呮。妗堜富閿�
+ * @return 鎮ｈ�呮。妗�
+ */
+ public PatArchive selectPatArchiveByPatID(Long PatID);
+
+ /**
+ * 鏌ヨ鎮ｈ�呮。妗堝垪琛�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 鎮ｈ�呮。妗堥泦鍚�
+ */
+ public List<PatArchive> selectPatArchiveList(PatArchive patArchive);
+
+ /**
+ * 鏂板鎮ｈ�呮。妗�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 缁撴灉
+ */
+ public int insertPatArchive(PatArchive patArchive);
+
+ /**
+ * 淇敼鎮ｈ�呮。妗�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 缁撴灉
+ */
+ public int updatePatArchive(PatArchive patArchive);
+
+ /**
+ * 鍒犻櫎鎮ｈ�呮。妗�
+ *
+ * @param PatID 鎮ｈ�呮。妗堜富閿�
+ * @return 缁撴灉
+ */
+ public int deletePatArchiveByPatID(Long PatID);
+
+ /**
+ * 鎵归噺鍒犻櫎鎮ｈ�呮。妗�
+ *
+ * @param PatIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deletePatArchiveByPatIDs(Long[] PatIDs);
+
+ /**
+ * 鎵归噺鍒犻櫎鎮ｈ�呴棬璇婅褰�
+ *
+ * @param PatIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎
+ * @return 缁撴灉
+ */
+ public int deletePatMedOuthospByPatIDs(Long[] PatIDs);
+
+ /**
+ * 鎵归噺鏂板鎮ｈ�呴棬璇婅褰�
+ *
+ * @param patMedOuthospList 鎮ｈ�呴棬璇婅褰曞垪琛�
+ * @return 缁撴灉
+ */
+ public int batchPatMedOuthosp(List<PatMedOuthosp> patMedOuthospList);
+
+
+ /**
+ * 閫氳繃鎮ｈ�呮。妗堜富閿垹闄ゆ偅鑰呴棬璇婅褰曚俊鎭�
+ *
+ * @param PatID 鎮ｈ�呮。妗圛D
+ * @return 缁撴灉
+ */
+ public int deletePatMedOuthospByPatID(Long PatID);
+}
diff --git a/smartor/src/main/java/com/smartor/service/IPatArchiveService.java b/smartor/src/main/java/com/smartor/service/IPatArchiveService.java
new file mode 100644
index 0000000..dbcb798
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/IPatArchiveService.java
@@ -0,0 +1,61 @@
+package com.smartor.service;
+
+import java.util.List;
+import com.smartor.domain.PatArchive;
+
+/**
+ * 鎮ｈ�呮。妗圫ervice鎺ュ彛
+ *
+ * @author ruoyi
+ * @date 2023-02-22
+ */
+public interface IPatArchiveService
+{
+ /**
+ * 鏌ヨ鎮ｈ�呮。妗�
+ *
+ * @param PatID 鎮ｈ�呮。妗堜富閿�
+ * @return 鎮ｈ�呮。妗�
+ */
+ public PatArchive selectPatArchiveByPatID(Long PatID);
+
+ /**
+ * 鏌ヨ鎮ｈ�呮。妗堝垪琛�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 鎮ｈ�呮。妗堥泦鍚�
+ */
+ public List<PatArchive> selectPatArchiveList(PatArchive patArchive);
+
+ /**
+ * 鏂板鎮ｈ�呮。妗�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 缁撴灉
+ */
+ public int insertPatArchive(PatArchive patArchive);
+
+ /**
+ * 淇敼鎮ｈ�呮。妗�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 缁撴灉
+ */
+ public int updatePatArchive(PatArchive patArchive);
+
+ /**
+ * 鎵归噺鍒犻櫎鎮ｈ�呮。妗�
+ *
+ * @param PatIDs 闇�瑕佸垹闄ょ殑鎮ｈ�呮。妗堜富閿泦鍚�
+ * @return 缁撴灉
+ */
+ public int deletePatArchiveByPatIDs(Long[] PatIDs);
+
+ /**
+ * 鍒犻櫎鎮ｈ�呮。妗堜俊鎭�
+ *
+ * @param PatID 鎮ｈ�呮。妗堜富閿�
+ * @return 缁撴灉
+ */
+ public int deletePatArchiveByPatID(Long PatID);
+}
diff --git a/smartor/src/main/java/com/smartor/service/impl/PatArchiveServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/PatArchiveServiceImpl.java
new file mode 100644
index 0000000..59996fc
--- /dev/null
+++ b/smartor/src/main/java/com/smartor/service/impl/PatArchiveServiceImpl.java
@@ -0,0 +1,134 @@
+package com.smartor.service.impl;
+
+import java.util.List;
+import com.ruoyi.common.utils.DateUtils;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import java.util.ArrayList;
+import com.ruoyi.common.utils.StringUtils;
+import org.springframework.transaction.annotation.Transactional;
+import com.smartor.domain.PatMedOuthosp;
+import com.smartor.mapper.PatArchiveMapper;
+import com.smartor.domain.PatArchive;
+import com.smartor.service.IPatArchiveService;
+
+/**
+ * 鎮ｈ�呮。妗圫ervice涓氬姟灞傚鐞�
+ *
+ * @author ruoyi
+ * @date 2023-02-22
+ */
+@Service
+public class PatArchiveServiceImpl implements IPatArchiveService
+{
+ @Autowired
+ private PatArchiveMapper patArchiveMapper;
+
+ /**
+ * 鏌ヨ鎮ｈ�呮。妗�
+ *
+ * @param PatID 鎮ｈ�呮。妗堜富閿�
+ * @return 鎮ｈ�呮。妗�
+ */
+ @Override
+ public PatArchive selectPatArchiveByPatID(Long PatID)
+ {
+ return patArchiveMapper.selectPatArchiveByPatID(PatID);
+ }
+
+ /**
+ * 鏌ヨ鎮ｈ�呮。妗堝垪琛�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 鎮ｈ�呮。妗�
+ */
+ @Override
+ public List<PatArchive> selectPatArchiveList(PatArchive patArchive)
+ {
+ return patArchiveMapper.selectPatArchiveList(patArchive);
+ }
+
+ /**
+ * 鏂板鎮ｈ�呮。妗�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 缁撴灉
+ */
+ @Transactional
+ @Override
+ public int insertPatArchive(PatArchive patArchive)
+ {
+ patArchive.setCreateTime(DateUtils.getNowDate());
+ int rows = patArchiveMapper.insertPatArchive(patArchive);
+ insertPatMedOuthosp(patArchive);
+ return rows;
+ }
+
+ /**
+ * 淇敼鎮ｈ�呮。妗�
+ *
+ * @param patArchive 鎮ｈ�呮。妗�
+ * @return 缁撴灉
+ */
+ @Transactional
+ @Override
+ public int updatePatArchive(PatArchive patArchive)
+ {
+ patArchive.setUpdateTime(DateUtils.getNowDate());
+ patArchiveMapper.deletePatMedOuthospByPatID(patArchive.getPatID());
+ insertPatMedOuthosp(patArchive);
+ return patArchiveMapper.updatePatArchive(patArchive);
+ }
+
+ /**
+ * 鎵归噺鍒犻櫎鎮ｈ�呮。妗�
+ *
+ * @param PatIDs 闇�瑕佸垹闄ょ殑鎮ｈ�呮。妗堜富閿�
+ * @return 缁撴灉
+ */
+ @Transactional
+ @Override
+ public int deletePatArchiveByPatIDs(Long[] PatIDs)
+ {
+ patArchiveMapper.deletePatMedOuthospByPatIDs(PatIDs);
+ return patArchiveMapper.deletePatArchiveByPatIDs(PatIDs);
+ }
+
+ /**
+ * 鍒犻櫎鎮ｈ�呮。妗堜俊鎭�
+ *
+ * @param PatID 鎮ｈ�呮。妗堜富閿�
+ * @return 缁撴灉
+ */
+ @Transactional
+ @Override
+ public int deletePatArchiveByPatID(Long PatID)
+ {
+ patArchiveMapper.deletePatMedOuthospByPatID(PatID);
+ return patArchiveMapper.deletePatArchiveByPatID(PatID);
+ }
+
+ /**
+ * 鏂板鎮ｈ�呴棬璇婅褰曚俊鎭�
+ *
+ * @param patArchive 鎮ｈ�呮。妗堝璞�
+ */
+ public void insertPatMedOuthosp(PatArchive patArchive)
+ {
+ List<PatMedOuthosp> patMedOuthospList = patArchive.getPatMedOuthospList();
+ Long PatID = patArchive.getPatID();
+ if (StringUtils.isNotNull(patMedOuthospList))
+ {
+ List<PatMedOuthosp> list = new ArrayList<PatMedOuthosp>();
+ for (PatMedOuthosp patMedOuthosp : patMedOuthospList)
+ {
+ patMedOuthosp.setPatID(PatID);
+ list.add(patMedOuthosp);
+ }
+ if (list.size() > 0)
+ {
+ patArchiveMapper.batchPatMedOuthosp(list);
+ }
+ }
+ }
+}
diff --git a/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml b/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml
new file mode 100644
index 0000000..970e1ba
--- /dev/null
+++ b/smartor/src/main/resources/mapper/smartor/PatArchiveMapper.xml
@@ -0,0 +1,190 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<!DOCTYPE mapper
+PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
+"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.smartor.mapper.PatArchiveMapper">
+
+ <resultMap type="PatArchive" id="PatArchiveResult">
+ <result property="PatID" column="PatID" />
+ <result property="Name" column="Name" />
+ <result property="Gender" column="Gender" />
+ <result property="PapersNumber" column="PapersNumber" />
+ <result property="BirthDate" column="BirthDate" />
+ <result property="Source" column="Source" />
+ <result property="MakeArchiveTime" column="MakeArchiveTime" />
+ <result property="MakeArchivePeople" column="MakeArchivePeople" />
+ <result property="MobileNumberCode" column="MobileNumberCode" />
+ <result property="RelativesNumber" column="RelativesNumber" />
+ <result property="PapersType" column="PapersType" />
+ <result property="OrgID" column="OrgID" />
+ <result property="delFlag" column="Del_Flag" />
+ <result property="updateBy" column="Update_By" />
+ <result property="updateTime" column="Update_Time" />
+ <result property="createBy" column="Create_By" />
+ <result property="createTime" column="Create_Time" />
+ <result property="IsUpload" column="IsUpload" />
+ <result property="uploadTime" column="Upload_Time" />
+ <result property="Age" column="Age" />
+ <result property="OpenId" column="OpenId" />
+ </resultMap>
+
+ <resultMap id="PatArchivePatMedOuthospResult" type="PatArchive" extends="PatArchiveResult">
+ <collection property="patMedOuthospList" notNullColumn="sub_ID" javaType="java.util.List" resultMap="PatMedOuthospResult" />
+ </resultMap>
+
+ <resultMap type="PatMedOuthosp" id="PatMedOuthospResult">
+ <result property="ID" column="sub_ID" />
+ <result property="SerialNum" column="sub_SerialNum" />
+ <result property="PatID" column="sub_PatID" />
+ <result property="HospitalName" column="sub_HospitalName" />
+ <result property="HospitalCode" column="sub_HospitalCode" />
+ <result property="Icd10Code" column="sub_Icd10Code" />
+ <result property="DiagName" column="sub_DiagName" />
+ <result property="DeptCode" column="sub_DeptCode" />
+ <result property="DeptName" column="sub_DeptName" />
+ <result property="DrCode" column="sub_DrCode" />
+ <result property="DrName" column="sub_DrName" />
+ <result property="AdmitDate" column="sub_AdmitDate" />
+ <result property="OrgID" column="sub_OrgID" />
+ <result property="delFlag" column="sub_Del_Flag" />
+ <result property="updateBy" column="sub_Update_By" />
+ <result property="updateTime" column="sub_Update_Time" />
+ <result property="createBy" column="sub_Create_By" />
+ <result property="createTime" column="sub_Create_Time" />
+ <result property="IsUpload" column="sub_IsUpload" />
+ <result property="uploadTime" column="sub_Upload_Time" />
+ <result property="SchemeStatus" column="sub_SchemeStatus" />
+ <result property="DeptID" column="sub_DeptID" />
+ <result property="SchemeTime" column="sub_SchemeTime" />
+ <result property="HPI" column="sub_HPI" />
+ <result property="MainSuit" column="sub_MainSuit" />
+ </resultMap>
+
+ <sql id="selectPatArchiveVo">
+ select PatID, Name, Gender, PapersNumber, BirthDate, Source, MakeArchiveTime, MakeArchivePeople, MobileNumberCode, RelativesNumber, PapersType, OrgID, Del_Flag, Update_By, Update_Time, Create_By, Create_Time, IsUpload, Upload_Time, Age, OpenId from pat_archive
+ </sql>
+
+ <select id="selectPatArchiveList" parameterType="PatArchive" resultMap="PatArchiveResult">
+ <include refid="selectPatArchiveVo"/>
+ <where>
+ <if test="Name != null and Name != ''"> and Name like concat('%', #{Name}, '%')</if>
+ <if test="PapersNumber != null and PapersNumber != ''"> and PapersNumber = #{PapersNumber}</if>
+ <if test="Source != null "> and Source = #{Source}</if>
+ <if test="MobileNumberCode != null and MobileNumberCode != ''"> and MobileNumberCode = #{MobileNumberCode}</if>
+ <if test="OrgID != null and OrgID != ''"> and OrgID = #{OrgID}</if>
+ <if test="delFlag != null and delFlag != ''"> and Del_Flag = #{delFlag}</if>
+ </where>
+ </select>
+
+ <select id="selectPatArchiveByPatID" parameterType="Long" resultMap="PatArchivePatMedOuthospResult">
+ select a.PatID, a.Name, a.Gender, a.PapersNumber, a.BirthDate, a.Source, a.MakeArchiveTime, a.MakeArchivePeople, a.MobileNumberCode, a.RelativesNumber, a.PapersType, a.OrgID, a.Del_Flag, a.Update_By, a.Update_Time, a.Create_By, a.Create_Time, a.IsUpload, a.Upload_Time, a.Age, a.OpenId,
+ b.ID as sub_ID, b.SerialNum as sub_SerialNum, b.PatID as sub_PatID, b.HospitalName as sub_HospitalName, b.HospitalCode as sub_HospitalCode, b.Icd10Code as sub_Icd10Code, b.DiagName as sub_DiagName, b.DeptCode as sub_DeptCode, b.DeptName as sub_DeptName, b.DrCode as sub_DrCode, b.DrName as sub_DrName, b.AdmitDate as sub_AdmitDate, b.OrgID as sub_OrgID, b.Del_Flag as sub_Del_Flag, b.Update_By as sub_Update_By, b.Update_Time as sub_Update_Time, b.Create_By as sub_Create_By, b.Create_Time as sub_Create_Time, b.IsUpload as sub_IsUpload, b.Upload_Time as sub_Upload_Time, b.SchemeStatus as sub_SchemeStatus, b.DeptID as sub_DeptID, b.SchemeTime as sub_SchemeTime, b.HPI as sub_HPI, b.MainSuit as sub_MainSuit
+ from pat_archive a
+ left join pat_med_outhosp b on b.PatID = a.PatID
+ where a.PatID = #{PatID}
+ </select>
+
+ <insert id="insertPatArchive" parameterType="PatArchive" useGeneratedKeys="true" keyProperty="PatID">
+ insert into pat_archive
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="Name != null">Name,</if>
+ <if test="Gender != null">Gender,</if>
+ <if test="PapersNumber != null">PapersNumber,</if>
+ <if test="BirthDate != null">BirthDate,</if>
+ <if test="Source != null">Source,</if>
+ <if test="MakeArchiveTime != null">MakeArchiveTime,</if>
+ <if test="MakeArchivePeople != null">MakeArchivePeople,</if>
+ <if test="MobileNumberCode != null">MobileNumberCode,</if>
+ <if test="RelativesNumber != null">RelativesNumber,</if>
+ <if test="PapersType != null">PapersType,</if>
+ <if test="OrgID != null">OrgID,</if>
+ <if test="delFlag != null and delFlag != ''">Del_Flag,</if>
+ <if test="updateBy != null">Update_By,</if>
+ <if test="updateTime != null">Update_Time,</if>
+ <if test="createBy != null">Create_By,</if>
+ <if test="createTime != null">Create_Time,</if>
+ <if test="IsUpload != null">IsUpload,</if>
+ <if test="uploadTime != null">Upload_Time,</if>
+ <if test="Age != null">Age,</if>
+ <if test="OpenId != null">OpenId,</if>
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="Name != null">#{Name},</if>
+ <if test="Gender != null">#{Gender},</if>
+ <if test="PapersNumber != null">#{PapersNumber},</if>
+ <if test="BirthDate != null">#{BirthDate},</if>
+ <if test="Source != null">#{Source},</if>
+ <if test="MakeArchiveTime != null">#{MakeArchiveTime},</if>
+ <if test="MakeArchivePeople != null">#{MakeArchivePeople},</if>
+ <if test="MobileNumberCode != null">#{MobileNumberCode},</if>
+ <if test="RelativesNumber != null">#{RelativesNumber},</if>
+ <if test="PapersType != null">#{PapersType},</if>
+ <if test="OrgID != null">#{OrgID},</if>
+ <if test="delFlag != null and delFlag != ''">#{delFlag},</if>
+ <if test="updateBy != null">#{updateBy},</if>
+ <if test="updateTime != null">#{updateTime},</if>
+ <if test="createBy != null">#{createBy},</if>
+ <if test="createTime != null">#{createTime},</if>
+ <if test="IsUpload != null">#{IsUpload},</if>
+ <if test="uploadTime != null">#{uploadTime},</if>
+ <if test="Age != null">#{Age},</if>
+ <if test="OpenId != null">#{OpenId},</if>
+ </trim>
+ </insert>
+
+ <update id="updatePatArchive" parameterType="PatArchive">
+ update pat_archive
+ <trim prefix="SET" suffixOverrides=",">
+ <if test="Name != null">Name = #{Name},</if>
+ <if test="Gender != null">Gender = #{Gender},</if>
+ <if test="PapersNumber != null">PapersNumber = #{PapersNumber},</if>
+ <if test="BirthDate != null">BirthDate = #{BirthDate},</if>
+ <if test="Source != null">Source = #{Source},</if>
+ <if test="MakeArchiveTime != null">MakeArchiveTime = #{MakeArchiveTime},</if>
+ <if test="MakeArchivePeople != null">MakeArchivePeople = #{MakeArchivePeople},</if>
+ <if test="MobileNumberCode != null">MobileNumberCode = #{MobileNumberCode},</if>
+ <if test="RelativesNumber != null">RelativesNumber = #{RelativesNumber},</if>
+ <if test="PapersType != null">PapersType = #{PapersType},</if>
+ <if test="OrgID != null">OrgID = #{OrgID},</if>
+ <if test="delFlag != null and delFlag != ''">Del_Flag = #{delFlag},</if>
+ <if test="updateBy != null">Update_By = #{updateBy},</if>
+ <if test="updateTime != null">Update_Time = #{updateTime},</if>
+ <if test="createBy != null">Create_By = #{createBy},</if>
+ <if test="createTime != null">Create_Time = #{createTime},</if>
+ <if test="IsUpload != null">IsUpload = #{IsUpload},</if>
+ <if test="uploadTime != null">Upload_Time = #{uploadTime},</if>
+ <if test="Age != null">Age = #{Age},</if>
+ <if test="OpenId != null">OpenId = #{OpenId},</if>
+ </trim>
+ where PatID = #{PatID}
+ </update>
+
+ <delete id="deletePatArchiveByPatID" parameterType="Long">
+ delete from pat_archive where PatID = #{PatID}
+ </delete>
+
+ <delete id="deletePatArchiveByPatIDs" parameterType="String">
+ delete from pat_archive where PatID in
+ <foreach item="PatID" collection="array" open="(" separator="," close=")">
+ #{PatID}
+ </foreach>
+ </delete>
+
+ <delete id="deletePatMedOuthospByPatIDs" parameterType="String">
+ delete from pat_med_outhosp where PatID in
+ <foreach item="patID" collection="array" open="(" separator="," close=")">
+ #{patID}
+ </foreach>
+ </delete>
+
+ <delete id="deletePatMedOuthospByPatID" parameterType="Long">
+ delete from pat_med_outhosp where PatID = #{patID}
+ </delete>
+
+ <insert id="batchPatMedOuthosp">
+ insert into pat_med_outhosp( ID, SerialNum, PatID, HospitalName, HospitalCode, Icd10Code, DiagName, DeptCode, DeptName, DrCode, DrName, AdmitDate, OrgID, Del_Flag, Update_By, Update_Time, Create_By, Create_Time, IsUpload, Upload_Time, SchemeStatus, DeptID, SchemeTime, HPI, MainSuit) values
+ <foreach item="item" index="index" collection="list" separator=",">
+ ( #{item.ID}, #{item.SerialNum}, #{item.PatID}, #{item.HospitalName}, #{item.HospitalCode}, #{item.Icd10Code}, #{item.DiagName}, #{item.DeptCode}, #{item.DeptName}, #{item.DrCode}, #{item.DrName}, #{item.AdmitDate}, #{item.OrgID}, #{item.delFlag}, #{item.updateBy}, #{item.updateTime}, #{item.createBy}, #{item.createTime}, #{item.IsUpload}, #{item.uploadTime}, #{item.SchemeStatus}, #{item.DeptID}, #{item.SchemeTime}, #{item.HPI}, #{item.MainSuit})
+ </foreach>
+ </insert>
+</mapper>
\ No newline at end of file
--
Gitblit v1.9.3