质量信息档案记录修改

医贸质量信息档案修改

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'

本文转自 qvodnet 51CTO博客，原文链接:http://blog.51cto.com/bks2015/1902377