如何设定 PO不自动UPDATE INFO RECORD

本文分享了在没有信息记录(INFORECORD)的情况下创建采购订单(PURCHASEORDER)的方法。系统将自动创建信息记录,但可能缺失交货时间、价格等基本信息。文中提供了一个PDF附件,详细介绍了如何正确处理这种情况。
有很多人问到同一问题,因此我就做成PDF给大家看看. 一是自己保留笔记(我有这么个习惯),二是SHARE给大家.

当没有INFO RECORD的情况下,如果你建立一个PURCHASE ORDER,系统会自动建立INFO RECORD,但是在此会缺少一些基本资料,如Planned delivery Time and Price and so on..

参考资源:

http://download.youkuaiyun.com/source/340777


附件就是模拟如何去处理的.

 
 
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.example.springboot_test.dao.CardDao"> <!-- 根据卡号和密码查询用户 --> <select id="check" resultType="com.example.springboot_test.po.Card"> SELECT id, name, password, id_card AS idCard, card_number AS cardNumber, balance, create_time AS createTime, status FROM bank_card WHERE card_number = #{cardNumber} </select> <!--扣款方 --> <update id="transferOut"> update bank_card set balance=balance - #{amount} where card_number = #{cardNumber} and balance >= #{amount} </update> <update id="transferIn"> update bank_card set balance=balance + #{amount} where card_number = #{targetAccount} </update> <select id="findTarget" resultType="int"> select count(*) from bank_card where card_number=#{targetAccount} </select> <insert id="insertRecord" > INSERT INTO transaction_record ( operate_account, operation_type, transaction_amount, target_account, operation_time ) VALUES ( #{operateAccount}, #{operationType}, #{transactionAmount}, #{targetAccount}, #{operationTime} ) </insert> </mapper> package com.example.springboot_test.service; import com.example.springboot_test.dao.CardDao; import com.example.springboot_test.po.Card; import com.example.springboot_test.po.Record; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import javax.annotation.Resource; import java.math.BigDecimal; import java.util.Date; @Service public class BankService<T> { @Resource private CardDao cardDao; public Card check(String cardNumber) { return cardDao.check(cardNumber); } @Transactional(rollbackFor = Exception.class) public boolean transfer(String cardNumber, String targetAccount, BigDecimal amount) { Card payer = cardDao.check(cardNumber); Integer count = cardDao.findTarget(targetAccount); if (count==0) { System.out.println("对方账号存在!"); } if (targetAccount == null || targetAccount.equals("")) { System.out.println("请输入目标账号"); } if (cardNumber.equals(targetAccount)) { System.out.println("无法向自己转账"); } //判断接受账号数据库中是否存在 if (payer.getBalance().compareTo(amount) < 0) { System.out.println("用户余额足"); } int a=cardDao.transferIn(targetAccount, amount); int b=cardDao.transferOut(cardNumber, amount); //向转账记录表插入数据 Record record=new Record(); record.setOperateAccount(cardNumber); record.setOperationType("transfer"); record.setTransactionAmount(amount); record.setTargetAccount(targetAccount); record.setOperationTime(new Date()); return true; } } package com.example.springboot_test.dao; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository; @Repository @Mapper public interface RecordDao { int insertRecord(RecordDao record); } package com.example.springboot_test.po; import java.math.BigDecimal; import java.util.Date; public class Record { private Integer id; private String operateAccount; private String operationType; private BigDecimal transactionAmount; private String targetAccount; private Date operationTime; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getOperateAccount() { return operateAccount; } public void setOperateAccount(String operateAccount) { this.operateAccount = operateAccount; } public String getOperationType() { return operationType; } public void setOperationType(String operationType) { this.operationType = operationType; } public BigDecimal getTransactionAmount() { return transactionAmount; } public void setTransactionAmount(BigDecimal transactionAmount) { this.transactionAmount = transactionAmount; } public String getTargetAccount() { return targetAccount; } public void setTargetAccount(String targetAccount) { this.targetAccount = targetAccount; } public Date getOperationTime() { return operationTime; } public void setOperationTime(Date operationTime) { this.operationTime = operationTime; } } 可以正常转账,但是没有添加转账记录,我怀疑是驼峰命名法
10-30
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值