系统设置方法 - 用前请认真看完这个文档.doc

贵州省新农合万能接口系统 SQL语句配置和简单实用说明 首次进入系统，需要配置连接参数连接到HIS的数据库 服务器名：HIS数据库所在服务器的IP地址或计算机名 数据库名：HIS数据库名字 登录名：SqlServer登录名一般用sa 登录口令：SqlServer登录口令 其他不用设置，设置完成后点【保存】按钮，然后点【退出】，重新进系统 连接好以后，进入登录页面 点，退出重新登录进【新农合接口系统】 第一次用超级用户登陆： 登录工号：czsa 密码：czhis2010 进入 系统维护-接入SQL设置：按下表和软件中的名字一一对应拷贝绿色部分设置上，然后保存，退出系统，如下图所示： 员工列表 第一列 员工代码，第二列 员工姓名 第三列 密码 select cast(RecordSN as varchar(50)) as UserCode,UserName,Password from GLOBAL_UserLib 科室列表 select cast(RecordSN as varchar(50)) as KSBH,SectionName from GLOBAL_SectionLib 医生列表 第一列 医生代码，第二列 医生姓名 select cast(RecordSN as varchar(50)) as UserCode,UserName,Password from GLOBAL_UserLib 药品信息（药品类型： 1西药 2中药 根据HIS药品库实际情况对应） select cast(RecordSN as varchar(100)) as 编码, cast(name as varchar(100)) as 名称, solid as 规格, sellunit as 单位, type as 剂型, outprice as 售价, productfactory as 厂家, fileid as 批准文号, pinyin as 拼音码, wubi as 五笔编码, 1 as 药品类型, ( Select NH_BM from XNH_HIS_XMDZ where LX= 1 and HIS_BM= cast(RecordSN as varchar(100)) ) as 农合编码 from SQYDYX_XY_DrugLibrary 治疗项目（类型必须设置为3） select cast(RecordSN as varchar(100)) as 编码, cast(name as varchar(100)) as 名称, as 规格, unit as 单位, as 剂型, defaultvalue as 售价, as 厂家, as 批准文号, pinyin as 拼音码, as 五笔编码, 3 as 类型, ( Select NH_BM from XNH_HIS_XMDZ where LX= 3 and HIS_BM= cast(RecordSN as varchar(100)) ) as 农合编码 from SQMZBL_FeeTypeTable 门诊收费列表 select cast(CheckNotesSN as varchar(50)) 发票号 ,cast(CheckNotesSN as varchar(50)) 处方单号,PatientName 病人姓名,DoctorSN 医生代码,SectionSN 科室代码,[DATE] 收费日期, 就诊号,settletype 收费类型, cast(OperatorSN as varchar(20)) 操作员, Money_AfterProfit 总金额, isnull((select InsureCardNo from SQMZBL_CaseLibrary where CaseSN=SQMZBL_FeeNoteLibrary.PatientID),SettleAttachCreditID) 医疗证号,J00.02 as 疾病编码 from SQMZBL_FeeNoteLibrary where settletype=新农合 order by [date] desc 门诊结算明细(药品) {mzdjh}是门诊结算的唯一关联发票号在接口软件中会自动替换 select a.FeeItemType as 费用类型, a.RecordSN 收费明细主键, b.InsureInterfaceID_3 as 农合编码, a.FeeTypeSN as HIS编码, a.FeeName as HIS名称, a.GG as HIS规格, a.DW as HIS单位, a.Count as