| | |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="updateHospitalUserinfo" parameterType="HospitalUserinfo"> |
| | | <update id="updateHospitalUserinfo" parameterType="com.smartor.domain.HospitalUserinfo"> |
| | | update hospital_userinfo |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="SourceSystem != null">SourceSystem = #{SourceSystem},</if> |
| | |
| | | where ID = #{ID} |
| | | </update> |
| | | |
| | | <update id="updateHospitalUserinfoByPatientID" parameterType="com.smartor.domain.HospitalUserinfo"> |
| | | update hospital_userinfo |
| | | <trim prefix="SET" suffixOverrides=","> |
| | | <if test="SourceSystem != null">SourceSystem = #{SourceSystem},</if> |
| | | <if test="MessageID != null">MessageID = #{MessageID},</if> |
| | | <if test="CreateTime != null">CreateTime = #{CreateTime},</if> |
| | | <if test="MethodName != null">MethodName = #{MethodName},</if> |
| | | <if test="ReqIimRules != null">ReqIimRules = #{ReqIimRules},</if> |
| | | <if test="PatientID != null">PatientID = #{PatientID},</if> |
| | | <if test="VisitNum != null">VisitNum = #{VisitNum},</if> |
| | | <if test="RegDate != null">RegDate = #{RegDate},</if> |
| | | <if test="IdentityID != null">IdentityID = #{IdentityID},</if> |
| | | <if test="PatName != null">PatName = #{PatName},</if> |
| | | <if test="Phone != null">Phone = #{Phone},</if> |
| | | <if test="PatSex != null">PatSex = #{PatSex},</if> |
| | | <if test="BirthDate != null">BirthDate = #{BirthDate},</if> |
| | | <if test="Address != null">Address = #{Address},</if> |
| | | <if test="AddProvince != null">AddProvince = #{AddProvince},</if> |
| | | <if test="AddCity != null">AddCity = #{AddCity},</if> |
| | | <if test="AddCounty != null">AddCounty = #{AddCounty},</if> |
| | | <if test="AddTown != null">AddTown = #{AddTown},</if> |
| | | <if test="AddVillage != null">AddVillage = #{AddVillage},</if> |
| | | <if test="AddHouseNo != null">AddHouseNo = #{AddHouseNo},</if> |
| | | <if test="HouseAddress != null">HouseAddress = #{HouseAddress},</if> |
| | | <if test="HouseAddProvince != null">HouseAddProvince = #{HouseAddProvince},</if> |
| | | <if test="HouseAddCity != null">HouseAddCity = #{HouseAddCity},</if> |
| | | <if test="HouseAddCounty != null">HouseAddCounty = #{HouseAddCounty},</if> |
| | | <if test="HouseAddTown != null">HouseAddTown = #{HouseAddTown},</if> |
| | | <if test="HouseAddVillage != null">HouseAddVillage = #{HouseAddVillage},</if> |
| | | <if test="HouseAddHouseNo != null">HouseAddHouseNo = #{HouseAddHouseNo},</if> |
| | | <if test="BirthAddress != null">BirthAddress = #{BirthAddress},</if> |
| | | <if test="BirthAddProvince != null">BirthAddProvince = #{BirthAddProvince},</if> |
| | | <if test="BirthAddCity != null">BirthAddCity = #{BirthAddCity},</if> |
| | | <if test="BirthAddCounty != null">BirthAddCounty = #{BirthAddCounty},</if> |
| | | <if test="BirthAddTown != null">BirthAddTown = #{BirthAddTown},</if> |
| | | <if test="BirthAddVillage != null">BirthAddVillage = #{BirthAddVillage},</if> |
| | | <if test="BirthAddHouseNo != null">BirthAddHouseNo = #{BirthAddHouseNo},</if> |
| | | <if test="ContactsAddress != null">ContactsAddress = #{ContactsAddress},</if> |
| | | <if test="ContactsAddProvince != null">ContactsAddProvince = #{ContactsAddProvince},</if> |
| | | <if test="ContactsAddCity != null">ContactsAddCity = #{ContactsAddCity},</if> |
| | | <if test="ContactsAddCounty != null">ContactsAddCounty = #{ContactsAddCounty},</if> |
| | | <if test="ContactsAddTown != null">ContactsAddTown = #{ContactsAddTown},</if> |
| | | <if test="ContactsAddVillage != null">ContactsAddVillage = #{ContactsAddVillage},</if> |
| | | <if test="ContactsAddHouseNo != null">ContactsAddHouseNo = #{ContactsAddHouseNo},</if> |
| | | <if test="NativeAddress != null">NativeAddress = #{NativeAddress},</if> |
| | | <if test="NativeAddProvince != null">NativeAddProvince = #{NativeAddProvince},</if> |
| | | <if test="NativeAddCity != null">NativeAddCity = #{NativeAddCity},</if> |
| | | <if test="NativeAddCounty != null">NativeAddCounty = #{NativeAddCounty},</if> |
| | | <if test="NativeAddTown != null">NativeAddTown = #{NativeAddTown},</if> |
| | | <if test="NativeAddVillage != null">NativeAddVillage = #{NativeAddVillage},</if> |
| | | <if test="NativeAddHouseNo != null">NativeAddHouseNo = #{NativeAddHouseNo},</if> |
| | | <if test="PostalCode != null">PostalCode = #{PostalCode},</if> |
| | | <if test="HouseCode != null">HouseCode = #{HouseCode},</if> |
| | | <if test="WorkCode != null">WorkCode = #{WorkCode},</if> |
| | | <if test="MaritalStatus != null">MaritalStatus = #{MaritalStatus},</if> |
| | | <if test="Country != null">Country = #{Country},</if> |
| | | <if test="Nation != null">Nation = #{Nation},</if> |
| | | <if test="NationCode != null">NationCode = #{NationCode},</if> |
| | | <if test="OccupType != null">OccupType = #{OccupType},</if> |
| | | <if test="OccupTypeCode != null">OccupTypeCode = #{OccupTypeCode},</if> |
| | | <if test="WorkUnit != null">WorkUnit = #{WorkUnit},</if> |
| | | <if test="WorkPhone != null">WorkPhone = #{WorkPhone},</if> |
| | | <if test="HCardNo != null">HCardNo = #{HCardNo},</if> |
| | | <if test="HCIssuersCode != null">HCIssuersCode = #{HCIssuersCode},</if> |
| | | <if test="HUrbanCode != null">HUrbanCode = #{HUrbanCode},</if> |
| | | <if test="MedOrgCode != null">MedOrgCode = #{MedOrgCode},</if> |
| | | <if test="paycode != null">paycode = #{paycode},</if> |
| | | <if test="payname != null">payname = #{payname},</if> |
| | | <if test="ConRelShip != null">ConRelShip = #{ConRelShip},</if> |
| | | <if test="ConPerPhone != null">ConPerPhone = #{ConPerPhone},</if> |
| | | <if test="ConPerName != null">ConPerName = #{ConPerName},</if> |
| | | <if test="RegOrgCode != null">RegOrgCode = #{RegOrgCode},</if> |
| | | <if test="RegOrgDesc != null">RegOrgDesc = #{RegOrgDesc},</if> |
| | | <if test="InsureOrgName != null">InsureOrgName = #{InsureOrgName},</if> |
| | | <if test="InsureOrgCode != null">InsureOrgCode = #{InsureOrgCode},</if> |
| | | <if test="RegEmpCode != null">RegEmpCode = #{RegEmpCode},</if> |
| | | <if test="RegEmpName != null">RegEmpName = #{RegEmpName},</if> |
| | | <if test="INEnroomno != null">INEnroomno = #{INEnroomno},</if> |
| | | <if test="OUTEnroomno != null">OUTEnroomno = #{OUTEnroomno},</if> |
| | | <if test="EncAdmSource != null">EncAdmSource = #{EncAdmSource},</if> |
| | | <if test="Directordoc != null">Directordoc = #{Directordoc},</if> |
| | | <if test="Attenddoc != null">Attenddoc = #{Attenddoc},</if> |
| | | <if test="Beddoc != null">Beddoc = #{Beddoc},</if> |
| | | <if test="Bednur != null">Bednur = #{Bednur},</if> |
| | | <if test="Regdoc != null">Regdoc = #{Regdoc},</if> |
| | | </trim> |
| | | where PatientID = #{PatientID} |
| | | </update> |
| | | |
| | | <delete id="deleteHospitalUserinfoByID" parameterType="Long"> |
| | | delete |
| | | from hospital_userinfo |