广东省2012版病案首页HIS项目归类语句(参考).doc

1、比一比商城真情奉献，欢迎访问： http:/ 及http:/ 广东省 2012 版病案 HIS 项目归类语句（参考） 这里比较有用的应该是归类的省代码区间， 语句内容只是作参考用， 在更改前要大概查看下所要更改的内容是符合，如符 合 就从 update 选择 到语句尾部 开始执行 语句即可。 http:/ -中成药 SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsR

2、pType -update BsItemFirstPage set psfeename=41 FROM BsItemFirstPage INNER JOIN BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID WHERE (BsItemFirstPage.PsFeeName

3、 IS NULL) OR (BsItemFirstPage.PsFeeName = 0) AND (BsItem.LsRpType IN (1) -西药 SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -update BsItemFirstPage set psfeename=40 FROM BsItemFirstPage INNER JOIN BsI

4、tem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID WHERE (BsItemFirstPage.PsFeeName IS NULL) OR (BsItemFirstPage.PsFeeName = 0) AND (BsItem.LsRpType IN (2) -中草药 SELE

5、CT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -update BsItemFirstPage set psfeename=26 FROM BsItemFirstPage INNER JOIN BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId

6、= BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID WHERE (BsItemFirstPage.PsFeeName IS NULL) OR (BsItemFirstPage.PsFeeName = 0) AND (BsItem.LsRpType IN (3) 比一比商城真情奉献，欢迎访问： http:/ 及http:/ -诊查费 (110200001-110200005) SELECT BsItem.Name AS Expr1, BsZ

7、yFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType -update BsItemFirstPage set psfeename=1 FROM BsItemFirstPage INNER JOIN BsItem ON BsItemFirstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOI

8、N BsItemFirstPageType ON BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id FROM BsItem where f1=110200001 and f1=110100001 and f1=120200001 and f1=120100001 and f1=130100001 and f1=270100001 and f1=250101001 and f1=210101001 and f1=310607001 and f1=311503001 and f1=240

9、100001 and f1=310100001 and f1=330100001 and f1=320100001 and f1=330100001 and f1=340100001 and f1=410000001 and f1=420000001 and f1=430000001 and f1=450000001 and f1=460000001 and f1=470000001 and f1=480000003 and f1=480000005) and (BsItemFirstPage.PsFeeName 比一比商城真情奉献，欢迎访问： http:/ 及http:/ IS NULL)

10、OR (BsItemFirstPage.PsFeeName = 0) -辩证施膳 (480000001) SELECT BsItem.Name AS Expr1, BsZyFeety.Name AS Expr2, BsItemFirstPage.ItemId, BsItemFirstPage.PsFeeName, BsItemFirstPageType.Name, BsItem.LsRpType,BsItem.f1 -update BsItemFirstPage set psfeename=23 FROM BsItemFirstPage INNER JOIN BsItem ON BsItemF

11、irstPage.ItemId = BsItem.ID INNER JOIN BsZyFeety ON BsItem.FeeZyId = BsZyFeety.ID LEFT OUTER JOIN BsItemFirstPageType ON BsItemFirstPage.PsFeeName = BsItemFirstPageType.ID where BsItem.id in (SELECT id FROM BsItem where f1=480000001) and (BsItemFirstPage.PsFeeName IS NULL) OR (BsItemFirstPage.PsFeeName = 0)