wxservice-server/src/main/java/thyyxxk/wxservice_server/dao/InpatientDao.java

package thyyxxk.wxservice_server.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import thyyxxk.wxservice_server.entity.inpatient.*;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author dj
 */
@Mapper
public interface InpatientDao {
    @Select("select rtrim(a.inpatient_no) inpatientNo, " +
            "rtrim(a.name) as name,rtrim(a.bed_no) as bedNo, " +
            "a.admiss_times, " +
            "convert(varchar(10), admiss_date, 21) admissDate, " +
            "rtrim(d.name) deptName, " +
            "doctorName=(select rtrim(name) from a_employee_mi with(nolock) " +
            "where code=isnull(a.refer_physician,a.admiss_physician)), " +
            "rtrim(c.total_charge) totalCharge, " +
            "rtrim(c.charge_yb) fundPay, " +
            "lastBalance=c.balance " +
            "from zy_actpatient a with(nolock), zy_ledger_file c with(nolock), zd_unit_code d with(nolock) " +
            "where a.inpatient_no=#{inpatientNo} and " +
            "a.inpatient_no=c.inpatient_no and " +
            "a.admiss_times=c.admiss_times and " +
            "c.ledger_sn=(select max(ledger_sn) from zy_ledger_file with(nolock) where " +
            "inpatient_no=a.inpatient_no and admiss_times=a.admiss_times) and " +
            "d.code=a.small_dept")
    InpatientInfo getInpatientInfo(@Param("inpatientNo") String inpatientNo);

    @Select("select rtrim(inpatient_no) from a_patient_mi where social_no=" +
            "(select social_no from mz_patient_mi where patient_id=#{patientId})")
    String selectInpatientNoBySocialNo(@Param("patientId") String patientId);

    @Select("select social_no from a_patient_mi where inpatient_no=#{inpatientNo}")
    String selectSocialNoByInpatientNo(@Param("inpatientNo") String inpatientNo);

    @Select("select top 1 rtrim(patient_id) from mz_patient_mi where " +
            "social_no=#{socialNo} order by lv_date desc ")
    String selectPatientIdBySocialNo(@Param("socialNo") String socialNo);

    @Select("select rtrim(inpatient_no) from a_patient_mi where mz_no=#{patientId}")
    String selectInpatientNoByPatientId(@Param("patientId") String patientId);

    @Update("execute zy_receive_drug #{inpatientNo} , #{admissTimes} , 1 , '0'")
    void receiveMedicineFees(@Param("inpatientNo") String inpatientNo,
                             @Param("admissTimes") Integer admissTimes);

    @Update("execute zy_receive_one #{inpatientNo} , #{admissTimes} , 1 , '0' ")
    void receiveProjectFees(@Param("inpatientNo") String inpatientNo,
                            @Param("admissTimes") Integer admissTimes);

    @Select("exec p_zz_zyfy_cx #{inpatientNo}, #{admissTimes}, null, 1, '', #{start}, #{end}")
    List<ZyFee> selectZyFees(GetZyFeeParam param);

    @Select("select depo_times, convert(varchar(19), depo_date, 21) depoDate, rtrim(depo_amount) depoAmount  " +
            "from zy_deposit_file with(nolock) where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes}")
    List<Prepaid> selectPrepaidHistory(@Param("inpatientNo") String inpatientNo,
                                       @Param("admissTimes") Integer admissTimes);

    @Update("exec p_zz_zyyjj #{inpatientNo},#{admissTimes},'E', #{totalFee}, " +
            "'99999', #{payDatetime}, 1, #{tradeNo}, #{serialNo}, #{returnTxt}")
    void payZyYjjSuccessful(@Param("inpatientNo") String inpatientNo,
                                        @Param("admissTimes") Integer admissTimes,
                                        @Param("totalFee") BigDecimal totalFee,
                                        @Param("payDatetime") String payDatetime,
                                        @Param("tradeNo") String tradeNo,
                                        @Param("serialNo") String serialNo,
                                        @Param("returnTxt") String returnTxt);

    @Select("select top 1 ic_card_no from t_wechat_patient_bind with(nolock) where patient_id=#{patientId} and del_flag=0")
    String selectCardNoByPatientId(@Param("patientId") String patientId);

    @Select("select count(1) from zy_deposit_file with(nolock) where psordnum=#{tradeNo} and agtordnum=#{serialNo}")
    int selectSavedCount(@Param("tradeNo") String tradeNo, @Param("serialNo") String serialNo);
}