物料供应商谈判编辑不可编辑问题（治标我，治本黄博伦老师）

— 原理：修改报价单表体自定义项的define20，全部改成true即可（这样的话就是全部可编辑，也就是统谈了）

第一步：找实施拿到询价单号

辅助查询的SQL:

select * from cpu_sourcing.cpu_qtoffer_detail WHERE cpuofferid in
(
select id from cpu_sourcing.cpu_qtoffer where vbuyoffer_billcode = ‘XJ2207070056’
)

select id,define20 from cpu_sourcing.cpu_price_body_define where id in (
select id from cpu_sourcing.cpu_qtoffer_detail WHERE cpuofferid in
(
select id from cpu_sourcing.cpu_qtoffer where vbuyoffer_billcode = ‘XJ2207070056’
)
)

真正修改的SQL:
update cpu_sourcing.cpu_price_body_define set define20 = ‘true’where id in (
select id from cpu_sourcing.cpu_qtoffer_detail WHERE cpuofferid in
(
select id from cpu_sourcing.cpu_qtoffer where vbuyoffer_billcode = ‘XJ2207070056’
)
)