调价相关

调价表ds_modiprice 及ds_modipriceDetail 表中

获取调价数据
select *from ds_modipricedetail where tiaoJiaDh in
(select tiaojiaDH from ds_modiprice where serialno>=serialno )
prambyname ('serialno').asstrig

//修改药品价格
update Dict_list set
Pijia =b.xianpijia ,shoujia=b.shoujia,menzhensj=b.xianshoujia/a.dabao
from dict_list a,ds_modipricedetail b

YuanPiJia YUanShouJIa,XianPiJia,XianShouJia

dict_list 中
JInJia,Pijia,ShouJia,MenZhenSj,Zhuyuansj