RIS与HIS数据导入方法-20120105.doc

一般使用 Aqua Data Studio工具，点击对应的表，右键工具——export导出数据——，图如下： 保存生csv文件，使用excel打开，然后使用拷贝粘贴到相关表中。 每条sql生成的都是一个表的数据，如果数据太多可以分开提交。 保存后要修改相关数据库序列号。 RIS/UIS/EIS M_MODALITY_TYPE_TBL 使用SQL SELECT cast([code] as int) as MODALITY_TYPE_LID, [name] as MODALITY_TYPE_NAME, null AS MODALITY_DESC, null MODALITY_MEMO, 0 DELETE_FLAG, [code] as TYPE_CODE FROM [dbo].[jc_zd_exam_type] --WHERE [code] IN ( ) 括号内添加放射科需要检查类型的code ORDER BY MODALITY_TYPE_LID asc 执行时可以使用WHERE MODALITY_TYPE_LID STUDY_ITEM_TBL 使用SQl： SELECT cast(([type_code]+[sub_code]) as varchar) as STUDY_ITEM_LID, --该项为主键，可以在excel中修改该值，不重复即可。 cast([type_code] as int) as MODALITY_TYPE_LID, [name] as BODY_PART, [name] as STUDY_ITEM_NAME, null as SHORT_CODE, null as EXAM_BW, null as UPDATE_USER_ID, null as UPDATE_DATE, [sub_code] as TYPE_CODE FROM [dbo].[jc_zd_exam_sub_type] -- WHERE [type_code] IN ( ) 括号内添加放射科需要检查类型的code ORDER BY STUDY_ITEM_LID asc M_DEPARTMENT_INFO_TBL SELECT [unit_sn] as DEPT_LID, [name] as DEPT_NAME, null DEPT_NAME_EN, [code] as DEPT_ID, null as PARENT_DEPT_LID, null as RADIATION_DEPT_FLAG, null as DEPT_LEADER_NAME, null as DEPT_PHONE, null as DEPT_DESC, 0 as DELETE_FLAG, null as UPDATE_USER_ID, null as UPDATETIME, [code] as TYPE_CODE, 0 as DEPT_IF_FLAG FROM [dbo].[zd_unit_code] PRICE_ITEM_TBL SELECT 1 AS PRICE_ITEM_LID , P AS ITEM_CLASS, i.[name] AS PRICE_ITEM_NAME, charge_unit AS UNITS, charge_price AS PRICE, 1 AS FEE_TYPE_MASK, C.[name] AS PRICE_TYPE, NULL AS START_DATE, NULL AS STOP_DATE , NULL AS SHORT_CODE, NULL AS ITEM_XW , admin AS UPDATE_USER_ID, NULL AS UPDATE_TIME, i.code AS CHARGE_CODE, NULL AS PRICE_ITEM_ID FROM [dbo].[zd_charge_item] AS i INNER JOIN [dbo].[zd_charge_class] AS C ON i.charge