单据表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
--
谢谢大家了
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
--
谢谢大家了
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
--
谢谢大家了
http://topic.csdn.net/u/20091130/21/fb718680-98ff-4afb-98d8-cff2f8293ed5.html?24281