| | |
| | | <result property="orderId" column="order_id"/> |
| | | <result property="fileData" column="file_data"/> |
| | | <result property="payTime" column="pay_time"/> |
| | | <result property="govPayStatus" column="gov_pay_status"/> |
| | | </resultMap> |
| | | |
| | | <sql id="selectNonCoalPayStudentVo"> |
| | |
| | | order_no, |
| | | order_id, |
| | | file_data, |
| | | pay_time |
| | | pay_time, |
| | | gov_pay_status |
| | | from non_coal_pay_student |
| | | </sql> |
| | | |
| | |
| | | <if test="idCard != null and idCard != ''">id_card,</if> |
| | | <if test="phone != null and phone != ''">phone,</if> |
| | | <if test="sex != null">sex,</if> |
| | | <if test="govPayStatus!=null">gov_pay_status,</if> |
| | | <if test="payCode != null">pay_code,</if> |
| | | <if test="payType != null">pay_type,</if> |
| | | <if test="orderNo != null and orderNo != '' ">order_no,</if> |
| | |
| | | <if test="idCard != null and idCard != ''">#{idCard},</if> |
| | | <if test="phone != null and phone != ''">#{phone},</if> |
| | | <if test="sex != null">#{sex},</if> |
| | | <if test="govPayStatus!=null">#{govPayStatus},</if> |
| | | <if test="payCode != null">#{payCode},</if> |
| | | <if test="payType != null">#{payType},</if> |
| | | <if test="orderNo != null and orderNo != '' ">#{orderNo},</if> |
| | |
| | | <if test="sex != null">sex = #{sex},</if> |
| | | <if test="orderNo != null and orderNo != ''">order_no = #{orderNo},</if> |
| | | <if test="orderId != null and orderId != ''">order_id = #{orderId},</if> |
| | | <if test="govPayStatus!=null">gov_pay_status=#{govPayStatus},</if> |
| | | <if test="fileData != null and fileData != ''">file_data = #{fileData},</if> |
| | | <if test="payTime != null">pay_time = #{payTime},</if> |
| | | <if test="payType != null">pay_type = #{payType},</if> |