单据表CHITTY
chitty_id chitty_sort chitty_code
1 1 od_001
2 2 pv_001
3 3 SS_001
...
单据明细表proitem
id chitty_id chitty_sort pro_id pro_amount pro_pamount asso_id asso_sort asso_code
1 1 1 1 10 0
2 1 1 2 5 0
3 2 2 1 3 0 1 1 od_001
4 2 2 2 2 0 1 1 od_001
5 3 3 1 8 0
6 3 3 2 6 0
--
如何根据PROITEM中的字段asso_id,asso_sort更新关联单据中的pro_pamount中的值。得到
id chitty_id chitty_sort pro_id pro_amount pro_pamount asso_id asso_sort asso_code
1 1 1 1 10 3
2 1 1 2 5 2
3 2 2 1 3 0 1 1 od_001
4 2 2 2 2 0 1 1 od_001
5 3 3 1 8 0
6 3 3 2 6 0
--
谢谢大家了
chitty_id chitty_sort chitty_code
1 1 od_001
2 2 pv_001
3 3 SS_001
...
单据明细表proitem
id chitty_id chitty_sort pro_id pro_amount pro_pamount asso_id asso_sort asso_code
1 1 1 1 10 0
2 1 1 2 5 0
3 2 2 1 3 0 1 1 od_001
4 2 2 2 2 0 1 1 od_001
5 3 3 1 8 0
6 3 3 2 6 0
--
如何根据PROITEM中的字段asso_id,asso_sort更新关联单据中的pro_pamount中的值。得到
id chitty_id chitty_sort pro_id pro_amount pro_pamount asso_id asso_sort asso_code
1 1 1 1 10 3
2 1 1 2 5 2
3 2 2 1 3 0 1 1 od_001
4 2 2 2 2 0 1 1 od_001
5 3 3 1 8 0
6 3 3 2 6 0
--
谢谢大家了
在表proitecm中,asso_id表示关联的单据ID,asso_sort表示关联单据的类型,asso_code表示关联单据的编号。所对应的表为chitty
chitty_sort=1表示订单,chitty_sort=2表示出货单
当出货单审核时,更新订单已发货的商品数量PRO_pamount.