日常杂事记录

1.停医嘱的类方法:w ##class(appcom.OEOrdItem).UnUseMultir("77067||13",127,"N","N") 作废医嘱处理

2.推送健康码至区里 的任务: d ##class(web.DHCResidentHealthCard).PushUseCardInfo(+$h-1)

3.推送检验报告:w ##class(web.DHCENS.EnsWebService).GetLISReportByRegNum("<Request><RegNo>0000509999</RegNo><AdmType>I</AdmType><StDate>2019-08-01</StDate><EndDate>2019-08-31</EndDate></Request>")

4.四舍五入需求门诊改表:SELECT * FROM SQLUser.DHC_SOPFConfig

5.呼吸科叫号1分钟左右才呼叫-----换盒子

6.摆药机患者0004638628 推送不到包药机上-----患者住院号取值为空 病案管理--查到点接诊

7.更新了手指点穴单次剂量需求

8.0004650634胸部正位片 检查医生变成了洪景娇 查因

9.等候队列显示复诊患者(客服的等候队列是按照排队号从小到大排序的;医生的患者队列是按照就诊号排队的)

10.流水线条码识别率低;仪器厂商提供打印机和驱动 我们调用(咨询护理组)

11.医保卡读卡慢;已经关闭杀毒软件观察

12.科利尔打印机打出来的检验结果是空的

喻枫打电话

1.通知技术中心和项目上的人员和赵红军开会

2.整理出来回款合同及回款状况

3.提出建议和自己想法

 

10.血透的获取检验报告的平台调his换成ecp226.9

 

DHC.LIS.WXSOAP.EnsWebServiceSoap

 

10.检查ris调用his主web从226.1改为226.9(DHC.RIS.BS.SOAP.EnsWebServiceSoap)

 

11.ping -s 2000 192.168.1.88 

d ##class(web.DHCResidentHealthCard).PushUseCardInfo(+$h-1)

1.上传药监平台不成(没有下载价格)

02:GoodsPrice.js-->//下载药品信息

var url = "dhcst.idruginfoaction.csp?action=DownGoodsPrice";

03:dhcst.idruginfoaction.csp --action=DownGoodsPrice

 

04:w ##class(web.DHCST.ISZDrugInterface.IGoodsPrice).IDrugDownPrice(1)

SELECT * FROM SQLUser.DHC_frComGoodsPrice WHERE COMGP_Product_DR->COMPD_ypbm=112082

 

SELECT * FROM SQLUser.DHC_frComProduct WHERE

 

SELECT * FROM SQLUser.DHC_frComProduct WHERE COMPD_RowId=12309 AND COMPD_ypbm

 

SELECT * FROM SQLUser.DHC_HisRefereCom WHERE HisRefCom_INCI_DR->INCI_Code=3656

 

2.中药录入界面开不了中药(web.DHCDocOrderEntryCM)

屏蔽如下代码

/*

if LUCategoryDesc'=1 {

s CMSubCategory="^"_CMSubCategory_"^"

}else{

s CMSubCategory="^"_CMKLSubCategory_"^"

}*/

/*

if LUCategoryDesc=1 {

;s CMSubCategory="^"_CMSubCategory_"^"

s CMSubCategory="^"_CMKLSubCategory_"^"

}elseif(LUCategoryDesc=2){

s CMSubCategory="^"_CMJPSubCategory_"^"

}else{

;s CMSubCategory="^"_CMKLSubCategory_"^"

s CMSubCategory="^"_CMSubCategory_"^"

}

*/

if $D(^DHCDocConfig("CNMedNormKL")) {

Set RecLoc=$o(^DHCDocConfig("CNMedNormKL",LUCategoryDesc+1,0))

Set CMSubCategory=^DHCDocConfig("CNMedNormKL",LUCategoryDesc+1,RecLoc)

s CMSubCategory="^"_CMSubCategory_"^"

}

把这个Global改成和这个是库的一样的^DHCDocConfig("CNMedNormKL")

3.开医嘱控制类web.DHCOEOrdItem和生成条码和处方号的规则(DHCaOET1.mac)

4.检验科条码补打的功能及条码布局的M

DHCLtkPrintBarcode

01)拷贝BarCode.exe到trak—>ActiveX下然后拷贝新的exe出来

barCode.exe在14上的(C:\Trak\ActiveX\LabTrak下)

02)barcode.exe和barcode.dll(在本机注册)拷贝到C:\Trak\ActiveX\LabTrak下

x\y\con1\fontsize\font

x横坐标

y纵坐标

con...内容(其中con1只能是条码)

fontsize

font

 

电子健康码线上支付

记录人:杨小牛

记录时间:2019-10-08

(1) 添加支付方式

 

(2) 添加权限

(3) 查看第三支付方式表、支付方式表

SELECT * FROM Dhc_ctpaymodeexp --第三支付方式表

SELECT * FROM SQLUser.CT_PayMode ---支付方式

--INSERT INTO SQLUser.DHC_CTPayModeExp (PME_AppRefundPM_DR, PME_ClassName, PME_HardCom_DR, PME_IFMode, PME_IOType, PME_MethodName, PME_PayMode_DR, PME_RefundFlag)

--VALUES (NULL, NULL, 1, 'WS', 'OP', NULL, '42', NULL);

(4) 修改Global

zw ^DHCRegInterfaceCodeRelate("PayMode","His")

------------------------

1.上传药监平台不成(没有下载价格)

02:GoodsPrice.js-->//下载药品信息

var url = "dhcst.idruginfoaction.csp?action=DownGoodsPrice";

03:dhcst.idruginfoaction.csp --action=DownGoodsPrice

 

04:w ##class(web.DHCST.ISZDrugInterface.IGoodsPrice).IDrugDownPrice(1)

SELECT * FROM SQLUser.DHC_frComGoodsPrice WHERE COMGP_Product_DR->COMPD_ypbm=112082

 

SELECT * FROM SQLUser.DHC_frComProduct WHERE

 

SELECT * FROM SQLUser.DHC_frComProduct WHERE COMPD_RowId=12309 AND COMPD_ypbm

 

SELECT * FROM SQLUser.DHC_HisRefereCom WHERE HisRefCom_INCI_DR->INCI_Code=3656

 

2.中药录入界面开不了中药(web.DHCDocOrderEntryCM)

屏蔽如下代码

/*

if LUCategoryDesc'=1 {

s CMSubCategory="^"_CMSubCategory_"^"

}else{

s CMSubCategory="^"_CMKLSubCategory_"^"

}*/

/*

if LUCategoryDesc=1 {

;s CMSubCategory="^"_CMSubCategory_"^"

s CMSubCategory="^"_CMKLSubCategory_"^"

}elseif(LUCategoryDesc=2){

s CMSubCategory="^"_CMJPSubCategory_"^"

}else{

;s CMSubCategory="^"_CMKLSubCategory_"^"

s CMSubCategory="^"_CMSubCategory_"^"

}

*/

if $D(^DHCDocConfig("CNMedNormKL")) {

Set RecLoc=$o(^DHCDocConfig("CNMedNormKL",LUCategoryDesc+1,0))

Set CMSubCategory=^DHCDocConfig("CNMedNormKL",LUCategoryDesc+1,RecLoc)

s CMSubCategory="^"_CMSubCategory_"^"

}

把这个Global改成和这个是库的一样的^DHCDocConfig("CNMedNormKL")

3.开医嘱控制类web.DHCOEOrdItem和生成条码和处方号的规则(DHCaOET1.mac)

4.检验科条码补打的功能及条码布局的M

DHCLtkPrintBarcode

01)拷贝BarCode.exe到trak—>ActiveX下然后拷贝新的exe出来

barCode.exe在14上的(C:\Trak\ActiveX\LabTrak下)

02)barcode.exe和barcode.dll(在本机注册)拷贝到C:\Trak\ActiveX\LabTrak下

1.

2.增加判断上次就诊没有交诊查费的患者

-----------------------------------------------------------------

1.增加配药确认后扫码不能上屏幕

2.三号窗口上打出来的条码 不能扫上屏

-----------------------------------

周五开会三点:

1.人员问题:黄智,杨小牛,周政华(去广州妇幼上线支持)

2.回款合同:2017DHC0714HCQ深圳市宝安区中医院移动临床信息系统项目 34.5w,回款60%

2018DHC0316HCQ02351深圳市宝安区中医院(集团)迎三甲复审新增工作项目合同 111.82w 回款60%

一台尿基(BH2101S型原子吸收光谱仪)

一台微量元素(BOHUI博晖全血七袁旭分析仪检验仪器双通连接);小闹钟

东区连的uf1000 已经在用了 未回款

-------------

 

3.当前项目的困难:1.产品组需求响应慢

4.收费时 按叫号状态,和是否有诊断,来判断

5.判断上次就诊的诊查费是否已缴纳,如果没有缴纳在通过叫号状态和是否有诊断来弹框提示收费员,并在收费界面显示上次的诊查费让收费员可以结上次的诊查费

6--------------------------------------------------------------------------------------------------------------------------

新员工日常内容:

1、一篇会议纪要

2、一篇需求实例

3、一篇客户关系心得

4、周报,新员工独立完成,指导老师监督及时完成

5、培养计划 (xls)、月报,指导老师和新员工共同完成,每月一次 指导老师每月初参考《新员工培训计划.doc》和本项目情况制定本月培养计划,月底新员工和指导老师完成总结

6、转正考题可提前下发和提前学习准备 《新员工培训计划考核表.doc》《转正试题 20160114》,机试题请截图 新员工转正时完成: 1、安全考试(打印出来手写,扫描成电子档) 2、完成转正考题,笔试+机试 3、转正申请书(协同上完成) 

4、准备转正答辩ppt

 

---------------------------------------------------------------------------------------------------------------------------------

SELECT * FROM SQLUser.ARC_ItemCat WHERE ARCIC_Desc="诊查费"

SELECT * FROM SQLUser.RB_Resource

SELECT * FROM RB_Appointment WHERE APPT_BookIDCard="440883199410153593"

SELECT * FROM SQLUser.SS_User WHERE SSUSR_RowId="1516"

SELECT OEORD_Adm_DR *FROM SQLUser.OE_Order

SELECT OSTAT_Code *FROM SQLUser.OEC_OrderStatus

SELECT ARCIC_Code *FROM ARC_ItemCat

 

SELECT ARCIM_ItemCat_DR *FROM SQLUser.ARC_ItmMast

SELECT OEORI_RowId *FROM SQLUser.OE_OrdItem WHERE OEORI_OEORD_ParRef->OEORD_Adm_DR=''

AND OEORI_ItmMast_DR->ARCIM_ItemCat_DR->ARCIC_Code='诊查费'

AND OEORI_ItemStat_DR->OSTAT_Code='D' OR OEORI_ItemStat_DR->OSTAT_Code='C'

 

 

SELECT OEORI_PRN, * FROM SQLUser.OE_ORDITEM WHERE OEORI_OEORD_ParRef=4725762

SELECT * FROM DHC_PE_OrderDetail WHERE OD_Desc LIKE "%胸部%"

---------------------------------------------------------------------------------------------------------------------------------------------

SELECT ad.PAADM_Type AS 就诊类型,ad.PAADM_AdmDate AS 开单时间,ad.PAADM_RowID,re.Rlt_ADM_DR,

pe.PAPER_Name AS 姓名,pa.PAPMI_ID AS 身份证,pa.PAPMI_Sex_DR->CTSEX_Desc AS 性别,pe.PAPER_Dob AS 出生日期,pa.PAPMI_SecondPhone AS 工作单位,

pe.PAPER_Nation_DR->CTNAT_Desc AS 民族,

pa.PAPMI_MobPhone AS 手机,pe.PAPER_ForeignId AS 联系人,pe.PAPER_ForeignPhone AS 联系人电话,pe.PAPER_StNameLine1 AS 居住地址,

(SELECT PAPER_HouseAddress FROM DHC_Person WHERE PAPER_PaPerson_dr=pe.PAPER_RowId) AS 户籍地址,

pe.PAPER_Education_DR->EDU_Desc AS 学历,pe.PAPER_Occupation_DR->CTOCC_Desc AS 职业,pe.PAPER_Marital_DR->CTMAR_Desc AS 婚姻状况,

pa.PAPMI_Name3 AS 医保卡号,

pe.PAPER_Province_Birth_DR->PROV_Desc AS 户籍省,pe.PAPER_Province_Birth_DR->PROV_Code AS 户籍省代码,

pe.PAPER_CityBirth_DR->CTCIT_Desc AS 户籍市,pe.PAPER_CityBirth_DR->CTCIT_Code AS 户籍市代码,

(SELECT PROV_Code FROM CT_Province WHERE PROV_RowId=(SELECT PAPER_HouseProvince_DR FROM DHC_Person WHERE

PAPER_PaPerson_dr=pe.PAPER_RowId)) AS 居住地省代码,

(SELECT PROV_Desc FROM CT_Province WHERE PROV_RowId=(SELECT PAPER_HouseProvince_DR FROM DHC_Person WHERE

PAPER_PaPerson_dr=pe.PAPER_RowId)) AS 居住地省,

(SELECT CTCIT_Code FROM CT_City WHERE CTCIT_RowId=(SELECT PAPER_HouseCity_DR FROM DHC_Person WHERE PAPER_PaPerson_dr=pe.PAPER_RowId)) AS

居住地市代码,

(SELECT CTCIT_Desc FROM CT_City WHERE CTCIT_RowId=(SELECT PAPER_HouseCity_DR FROM DHC_Person WHERE PAPER_PaPerson_dr=pe.PAPER_RowId)) AS

居住地市,

pe.PAPER_Nation_DR->CTNAT_Desc,re.RLT_OEORI_DR AS 医嘱ID,

(SELECT ARCIM_Desc FROM ARC_ItmMast WHERE ARCIM_RowId=re.RLT_ARCIM_DR ) AS 体检项目,

(SELECT OD_Desc FROM DHC_PE_OrderDetail WHERE OD_RowId=re.RLT_OD_DR) AS 体检细项,re.RLT_Result 体检结果,re.RLT_UpdateDate AS 报告更新

from SQLUser.PA_Adm ad,SQLUser.PA_Person pe,SQLUser.PA_PatMas pa,DHC_PE_Result re WHERE

ad.PAADM_PAPMI_DR =pe.PAPER_RowId

AND ad.PAADM_PAPMI_DR =pa.PAPMI_RowId1

and re.RLT_ADM_DR =ad.PAADM_RowID

AND ad.PAADM_AdmDate BETWEEN '2017-05-02' AND '2017-10-01'

AND ad.PAADM_RowID IN (

SELECT RLT_ADM_DR FROM DHC_PE_Result WHERE (OR RLT_OD_DR ='8||2134' OR RLT_OD_DR ='8||2183'

OR RLT_OD_DR ='8||2184' OR RLT_OD_DR ='8||2185' OR RLT_OD_DR ='8||2186' OR RLT_OD_DR ='8||2187'

OR RLT_OD_DR ='8||2188' OR RLT_OD_DR ='8||2190' OR RLT_OD_DR ='8||2191' OR RLT_OD_DR ='8||2192' OR RLT_OD_DR ='8||2193'

OR RLT_OD_DR ='8||2194' OR RLT_OD_DR ='8||2195' OR RLT_OD_DR ='8||2303' OR RLT_OD_DR ='8||2362' OR RLT_OD_DR ='8||2363' OR RLT_OD_DR='13||798'

OR RLT_OD_DR='13||798' OR RLT_OD_DR='13||799' OR RLT_OD_DR='13||800' OR RLT_OD_DR='13||802' OR RLT_OD_DR='13||804' OR RLT_OD_DR='13||940'

) )

258892

 

-----------------------------------------------------

SELECT OEORI_RowId into:OEOID FROM SQLUser.OE_OrdItem WHERE ( OEORI_OEORD_ParRef->OEORD_Adm_DR=:Adm AND OEORI_ItmMast_DR->ARCIM_ItemCat_DR->ARCIC_Code="诊查费" AND (OEORI_ItemStat_DR->OSTAT_Code!="D" and OEORI_ItemStat_DR->OSTAT_Code!="C"

 

------------------------------------------------------------------------------------------

1.慢病院需要的his和体检的数据导出

2.抽血室扫健康码获取不到医嘱信息跟程序处理

3.自助机取号密码生成10位改为6位

4.门诊收费提示上次未交诊查费的更新

5. 自助机通过省份证获取患者信息接口修改

-----------------------------------------------------------------------------------------------

排班扩展表:RB_ApptSchedule中的AS_QueueNo字段中的26:1:1中的第一位代表号源,第二位数代表(0:未取号1:正常取号2:已预约,3:预约取号,4.已退号,5:加号,6:诊间预约取号),第三位数代表预约机构1:3:1=序号:预约方式:占用情况(0-未占用,1占用)

1------------------------------------------------------------------------------------------------

1.个别患者入院后病案组生成了病案号 但是电子病历里面没有取到病案号和护理病历;在打开病历时日过pa_patmas为空时重新插入

2.断电后检验科客户端用户凭据丢失查因

3.E:\LC\测试库程序更新\宝安中医院检验源码20171212\检验源码20170803\宝安中医院检验源码\宝安中医院检验源码\宝安中医院\dthealth\技师

 

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值