医贸质量信息档案修改
update wyf_zlxxfxb set shenhrq1=‘2016-12-21‘,shenhrq6=‘2016-12-21‘,shenhrq7=‘2016-12-21‘,shenhrq8=‘2016-12-21‘,shenhrq9=‘2016-12-21‘,shenhrq5=‘2016-12-21‘ where djbh=‘XXCYMA00000018‘
update wyf_zlxxfxb set shenhrq1=‘2016-10-10‘,shenhrq6=‘2016-10-10‘,shenhrq7=‘2016-10-10‘ where djbh=‘XXCYMA00000019‘
update wyf_zlxxfxb set shenhrq1=‘2016-10-23‘,shenhrq6=‘2016-10-23‘,shenhrq7=‘2016-10-23‘ where djbh=‘XXCYMA00000020‘
update wyf_zlxxfxb set shenhrq1=‘2016-08-04‘,shenhrq6=‘2016-08-04‘,shenhrq7=‘2016-08-04‘ where djbh=‘XXCYMA00000021‘
update wyf_zlxxfxb set shenhrq1=‘2016-12-23‘,shenhrq6=‘2016-12-23‘,shenhrq7=‘2016-12-23‘ where djbh=‘XXCYMA00000022‘
update wyf_zlxxfxb set shenhrq1=‘2016-11-25‘,shenhrq6=‘2016-11-25‘,shenhrq7=‘2016-11-25‘ where djbh=‘XXCYMA00000023‘
update wyf_zlxxfxb set shenhrq1=‘2017-01-16‘,shenhrq6=‘2017-01-16‘,shenhrq7=‘2017-01-16‘,shenhrq8=‘2017-01-16‘,shenhrq9=‘2017-01-16‘,shenhrq5=‘2017-01-16‘ where djbh=‘XXCYMA00000027‘
物流质量信息档案修改
update wyf_zlxxfxb set shenhrq1=‘2016-12-10‘,shenhrq6=‘2016-12-10‘,shenhrq7=‘2016-12-10‘,shenhrq8=‘2016-12-10‘ where djbh=‘XXCZDW00000031‘
update wyf_zlxxfxb set shenhrq1=‘2016-12-21‘,shenhrq6=‘2016-12-21‘,shenhrq7=‘2016-12-21‘,shenhrq8=‘2016-12-21‘,shenhrq9=‘2016-12-21‘,shenhrq5=‘2016-12-21‘ where djbh=‘XXCZDW00000032‘
update wyf_zlxxfxb set shenhrq1=‘2016-10-10‘,shenhrq6=‘2016-10-10‘,shenhrq7=‘2016-10-10‘ where djbh=‘XXCZDW00000033‘
update wyf_zlxxfxb set shenhrq1=‘2016-12-23‘,shenhrq6=‘2016-12-23‘,shenhrq7=‘2016-12-23‘ where djbh=‘XXCZDW00000034‘
update wyf_zlxxfxb set shenhrq1=‘2016-08-04‘,shenhrq6=‘2016-08-04‘,shenhrq7=‘2016-08-04‘ where djbh=‘XXCZDW00000035‘
update wyf_zlxxfxb set shenhrq1=‘2016-08-26‘,shenhrq6=‘2016-08-26‘,shenhrq7=‘2016-08-26‘ where djbh=‘XXCZDW00000036‘
update wyf_zlxxfxb set shenhrq1=‘2016-11-25‘,shenhrq6=‘2016-11-25‘,shenhrq7=‘2016-11-25‘ where djbh=‘XXCZDW00000037‘
update wyf_zlxxfxb set shenhrq1=‘2017-01-16‘,shenhrq6=‘2017-01-16‘,shenhrq7=‘2017-01-16‘,shenhrq8=‘2017-01-16‘,shenhrq9=‘2017-01-16‘,shenhrq5=‘2017-01-16‘ where djbh=‘XXCZDW00000041‘
原文：http://bks2015.blog.51cto.com/9847303/1902377