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\技师