From 1eb2adeb0eae4cd96c9856d009103e705a6cf92a Mon Sep 17 00:00:00 2001 From: qianxj <qianxj15@sina.com> Date: 星期四, 23 二月 2023 20:35:27 +0800 Subject: [PATCH] smartor update --- /dev/null | 190 ----------------------------------------------- 1 files changed, 0 insertions(+), 190 deletions(-) diff --git a/smartor/main/src/java/com/smartor/domain/PatArchive.java b/smartor/main/src/java/com/smartor/domain/PatArchive.java deleted file mode 100644 index 5adfe8f..0000000 --- a/smartor/main/src/java/com/smartor/domain/PatArchive.java +++ /dev/null @@ -1,276 +0,0 @@ -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; - -/** - * 鎮h�呮。妗堝璞� 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; - - /** 鎮h�呴棬璇婅褰曚俊鎭� */ - 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/main/src/java/com/smartor/domain/PatMedOuthosp.java b/smartor/main/src/java/com/smartor/domain/PatMedOuthosp.java deleted file mode 100644 index 3234bca..0000000 --- a/smartor/main/src/java/com/smartor/domain/PatMedOuthosp.java +++ /dev/null @@ -1,326 +0,0 @@ -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; - -/** - * 鎮h�呴棬璇婅褰曞璞� 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; - - /** 妗fID */ - @Excel(name = " 妗fID ") - 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; - - /** 绉戝浠g爜 */ - @Excel(name = " 绉戝浠g爜 ") - 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/main/src/java/com/smartor/mapper/PatArchiveMapper.java b/smartor/main/src/java/com/smartor/mapper/PatArchiveMapper.java deleted file mode 100644 index e8eada3..0000000 --- a/smartor/main/src/java/com/smartor/mapper/PatArchiveMapper.java +++ /dev/null @@ -1,87 +0,0 @@ -package com.smartor.mapper; - -import java.util.List; -import com.smartor.domain.PatArchive; -import com.smartor.domain.PatMedOuthosp; - -/** - * 鎮h�呮。妗圡apper鎺ュ彛 - * - * @author ruoyi - * @date 2023-02-22 - */ -public interface PatArchiveMapper -{ - /** - * 鏌ヨ鎮h�呮。妗� - * - * @param PatID 鎮h�呮。妗堜富閿� - * @return 鎮h�呮。妗� - */ - public PatArchive selectPatArchiveByPatID(Long PatID); - - /** - * 鏌ヨ鎮h�呮。妗堝垪琛� - * - * @param patArchive 鎮h�呮。妗� - * @return 鎮h�呮。妗堥泦鍚� - */ - public List<PatArchive> selectPatArchiveList(PatArchive patArchive); - - /** - * 鏂板鎮h�呮。妗� - * - * @param patArchive 鎮h�呮。妗� - * @return 缁撴灉 - */ - public int insertPatArchive(PatArchive patArchive); - - /** - * 淇敼鎮h�呮。妗� - * - * @param patArchive 鎮h�呮。妗� - * @return 缁撴灉 - */ - public int updatePatArchive(PatArchive patArchive); - - /** - * 鍒犻櫎鎮h�呮。妗� - * - * @param PatID 鎮h�呮。妗堜富閿� - * @return 缁撴灉 - */ - public int deletePatArchiveByPatID(Long PatID); - - /** - * 鎵归噺鍒犻櫎鎮h�呮。妗� - * - * @param PatIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 - * @return 缁撴灉 - */ - public int deletePatArchiveByPatIDs(Long[] PatIDs); - - /** - * 鎵归噺鍒犻櫎鎮h�呴棬璇婅褰� - * - * @param PatIDs 闇�瑕佸垹闄ょ殑鏁版嵁涓婚敭闆嗗悎 - * @return 缁撴灉 - */ - public int deletePatMedOuthospByPatIDs(Long[] PatIDs); - - /** - * 鎵归噺鏂板鎮h�呴棬璇婅褰� - * - * @param patMedOuthospList 鎮h�呴棬璇婅褰曞垪琛� - * @return 缁撴灉 - */ - public int batchPatMedOuthosp(List<PatMedOuthosp> patMedOuthospList); - - - /** - * 閫氳繃鎮h�呮。妗堜富閿垹闄ゆ偅鑰呴棬璇婅褰曚俊鎭� - * - * @param PatID 鎮h�呮。妗圛D - * @return 缁撴灉 - */ - public int deletePatMedOuthospByPatID(Long PatID); -} diff --git a/smartor/main/src/java/com/smartor/service/IPatArchiveService.java b/smartor/main/src/java/com/smartor/service/IPatArchiveService.java deleted file mode 100644 index dbcb798..0000000 --- a/smartor/main/src/java/com/smartor/service/IPatArchiveService.java +++ /dev/null @@ -1,61 +0,0 @@ -package com.smartor.service; - -import java.util.List; -import com.smartor.domain.PatArchive; - -/** - * 鎮h�呮。妗圫ervice鎺ュ彛 - * - * @author ruoyi - * @date 2023-02-22 - */ -public interface IPatArchiveService -{ - /** - * 鏌ヨ鎮h�呮。妗� - * - * @param PatID 鎮h�呮。妗堜富閿� - * @return 鎮h�呮。妗� - */ - public PatArchive selectPatArchiveByPatID(Long PatID); - - /** - * 鏌ヨ鎮h�呮。妗堝垪琛� - * - * @param patArchive 鎮h�呮。妗� - * @return 鎮h�呮。妗堥泦鍚� - */ - public List<PatArchive> selectPatArchiveList(PatArchive patArchive); - - /** - * 鏂板鎮h�呮。妗� - * - * @param patArchive 鎮h�呮。妗� - * @return 缁撴灉 - */ - public int insertPatArchive(PatArchive patArchive); - - /** - * 淇敼鎮h�呮。妗� - * - * @param patArchive 鎮h�呮。妗� - * @return 缁撴灉 - */ - public int updatePatArchive(PatArchive patArchive); - - /** - * 鎵归噺鍒犻櫎鎮h�呮。妗� - * - * @param PatIDs 闇�瑕佸垹闄ょ殑鎮h�呮。妗堜富閿泦鍚� - * @return 缁撴灉 - */ - public int deletePatArchiveByPatIDs(Long[] PatIDs); - - /** - * 鍒犻櫎鎮h�呮。妗堜俊鎭� - * - * @param PatID 鎮h�呮。妗堜富閿� - * @return 缁撴灉 - */ - public int deletePatArchiveByPatID(Long PatID); -} diff --git a/smartor/main/src/java/com/smartor/service/impl/PatArchiveServiceImpl.java b/smartor/main/src/java/com/smartor/service/impl/PatArchiveServiceImpl.java deleted file mode 100644 index 59996fc..0000000 --- a/smartor/main/src/java/com/smartor/service/impl/PatArchiveServiceImpl.java +++ /dev/null @@ -1,134 +0,0 @@ -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; - -/** - * 鎮h�呮。妗圫ervice涓氬姟灞傚鐞� - * - * @author ruoyi - * @date 2023-02-22 - */ -@Service -public class PatArchiveServiceImpl implements IPatArchiveService -{ - @Autowired - private PatArchiveMapper patArchiveMapper; - - /** - * 鏌ヨ鎮h�呮。妗� - * - * @param PatID 鎮h�呮。妗堜富閿� - * @return 鎮h�呮。妗� - */ - @Override - public PatArchive selectPatArchiveByPatID(Long PatID) - { - return patArchiveMapper.selectPatArchiveByPatID(PatID); - } - - /** - * 鏌ヨ鎮h�呮。妗堝垪琛� - * - * @param patArchive 鎮h�呮。妗� - * @return 鎮h�呮。妗� - */ - @Override - public List<PatArchive> selectPatArchiveList(PatArchive patArchive) - { - return patArchiveMapper.selectPatArchiveList(patArchive); - } - - /** - * 鏂板鎮h�呮。妗� - * - * @param patArchive 鎮h�呮。妗� - * @return 缁撴灉 - */ - @Transactional - @Override - public int insertPatArchive(PatArchive patArchive) - { - patArchive.setCreateTime(DateUtils.getNowDate()); - int rows = patArchiveMapper.insertPatArchive(patArchive); - insertPatMedOuthosp(patArchive); - return rows; - } - - /** - * 淇敼鎮h�呮。妗� - * - * @param patArchive 鎮h�呮。妗� - * @return 缁撴灉 - */ - @Transactional - @Override - public int updatePatArchive(PatArchive patArchive) - { - patArchive.setUpdateTime(DateUtils.getNowDate()); - patArchiveMapper.deletePatMedOuthospByPatID(patArchive.getPatID()); - insertPatMedOuthosp(patArchive); - return patArchiveMapper.updatePatArchive(patArchive); - } - - /** - * 鎵归噺鍒犻櫎鎮h�呮。妗� - * - * @param PatIDs 闇�瑕佸垹闄ょ殑鎮h�呮。妗堜富閿� - * @return 缁撴灉 - */ - @Transactional - @Override - public int deletePatArchiveByPatIDs(Long[] PatIDs) - { - patArchiveMapper.deletePatMedOuthospByPatIDs(PatIDs); - return patArchiveMapper.deletePatArchiveByPatIDs(PatIDs); - } - - /** - * 鍒犻櫎鎮h�呮。妗堜俊鎭� - * - * @param PatID 鎮h�呮。妗堜富閿� - * @return 缁撴灉 - */ - @Transactional - @Override - public int deletePatArchiveByPatID(Long PatID) - { - patArchiveMapper.deletePatMedOuthospByPatID(PatID); - return patArchiveMapper.deletePatArchiveByPatID(PatID); - } - - /** - * 鏂板鎮h�呴棬璇婅褰曚俊鎭� - * - * @param patArchive 鎮h�呮。妗堝璞� - */ - 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/main/src/resources/mapper/smartor/PatArchiveMapper.xml b/smartor/main/src/resources/mapper/smartor/PatArchiveMapper.xml deleted file mode 100644 index 970e1ba..0000000 --- a/smartor/main/src/resources/mapper/smartor/PatArchiveMapper.xml +++ /dev/null @@ -1,190 +0,0 @@ -<?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