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

package thyyxxk.wxservice_server.dao;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import thyyxxk.wxservice_server.entity.paymzfee.MedinsSettle;

import java.util.List;
import java.util.Map;

@Mapper
public interface PayMzFeeDao {
    @Select("select * from t_si_setlinfo where pat_no=#{patNo} and times=#{times} and revoked=0")
    MedinsSettle selectSettleinfo(String patNo, int times);

    @Insert("insert into t_wx_file2del (id,path,type) values (#{id},#{path},'DZFP')")
    void insertWx2del(String id, String path);

    @Select("select id,path from t_wx_file2del where type='DZFP' and " +
            "datediff(hour,create_time,getdate())>=72")
    List<Map<String, String>> getDzfp2del();

    @Delete("<script>" +
            "delete from t_wx_file2del where id in (" +
            "<foreach collection='list' item='id' separator=','>" +
            "#{id}" +
            "</foreach>)" +
            "</script>")
    void deleteWx2del(List<String> list);
}