| | |
| | | <result column="statusId" property="statusId" jdbcType="VARCHAR" /> |
| | | </resultMap> |
| | | <update id="updateMaxNum" > |
| | | update ICMaxNum set fmaxnum =#{finterid,jdbcType=INTEGER} |
| | | update ICMaxNum set fmaxnum =#{FInterID,jdbcType=INTEGER} |
| | | where FTableName =#{tableName,jdbcType=VARCHAR} |
| | | </update> |
| | | |
| | |
| | | </delete> |
| | | <update id="updateZjMain" parameterType="com.zy.asrs.entity.POInStock"> |
| | | update xtyasrs_dual.dbo.InStockbill set fsupplyid =#{fsupplyid, jdbcType=INTEGER} |
| | | where finterid= #{finterid,jdbcType=INTEGER} |
| | | where finterid= #{FInterID,jdbcType=INTEGER} |
| | | </update> |
| | | <update id="updateZjQty" parameterType="com.zy.asrs.entity.POInStockEntry"> |
| | | update xtyasrs_dual.dbo.InStockbillEntry set fqtypass =#{fqty, jdbcType=DECIMAL}, fqty =#{fqty, jdbcType=DECIMAL}, fauxqty =#{fqty, jdbcType=DECIMAL}, fauxqtypass =#{fqty, jdbcType=DECIMAL} |