<update id="updateScKsjs" parameterType="com.pty.sal.entity.SalPayData">
UPDATE sal_pay_data SET ksjs = ynsze - (mo * 5000)
WHERE agy_code=#{agyCode,jdbcType=VARCHAR} and fiscal = #{fiscal,jdbcType=INTEGER}
and emp_code = #{empCode,jdbcType=VARCHAR}
</update>
<update id="updateStudentKsjs" parameterType="com.pty.sal.entity.SalPayData">
UPDATE sal_pay_data SET ksjs = ynsze - (mo * 5000)
WHERE agy_code=#{agyCode,jdbcType=VARCHAR} and fiscal = #{fiscal,jdbcType=INTEGER}
and emp_code = #{empCode,jdbcType=VARCHAR}
</update>
/*
* 首次发放工资人员,扣税基数 当前月份 * 5000
* */
int updateScKsjs(SalPayData salPayData);
//实习生计税更新扣税基数
int updateStudentKsjs(SalPayData salPayData);