/// <summary> /// 根据读卡信息查询His接口信息 /// 2017-12-05 cc /// </summary> /// <param name="PAT_INDEX_NO">病人ID</param> /// <param name="CARD_NO">就诊卡号</param> /// <param name="isNowDay">是否查询当天</param> /// <returns></returns> public static IList <HisPatientInfo> GetListHisPatientInfo(string PAT_INDEX_NO, string CARD_NO, bool isNowDay) { YHRequest YHReq = new YHRequest(YHRequest.fid_get_hisregist); if (isNowDay) { YHReq.addQuery(YHRequest.item_date, YHRequest.compy_gt, "to_date('" + DateTime.Now.Date.ToString("yyyy-MM-dd") + "','yyyy-MM-dd')", YHRequest.splice_and); } if (!string.IsNullOrEmpty(PAT_INDEX_NO)) { YHReq.addQuery(YHRequest.item_patient, YHRequest.compy_equals, "'" + PAT_INDEX_NO + "'", YHRequest.splice_and); } if (!string.IsNullOrEmpty(CARD_NO)) { YHReq.addQuery(YHRequest.item_visit_no, YHRequest.compy_equals, "'" + CARD_NO + "'", YHRequest.splice_and); } var result = YHMQUtil <HisPatientInfo> .get(YHReq); if (result.success) { return(result.dataList); } else { return(null); } }
/// <summary> /// 根据条件查询 /// 2017-11-14 cc /// </summary> /// <param name="txtPatientId">病人ID</param> /// <param name="txtPatientName">姓名</param> /// <param name="txtSex">性别</param> /// <param name="txtBirth">出生日期</param> /// <param name="txtStartTime">开始时间</param> /// <param name="txtEbdTime">结束时间</param> /// <returns></returns> public IList <HisPatientInfo> GetListRequest(string txtPatientId, string txtPatientName, string txtSex, string txtBirth, string txtStartTime, string txtEbdTime) { YHRequest YHReq = new YHRequest(YHRequest.fid_get_hisregist); if (!string.IsNullOrEmpty(txtPatientId)) { YHReq.addQuery(YHRequest.item_patient, YHRequest.compy_equals, "'" + txtPatientId + "'", YHRequest.splice_and); } if (!string.IsNullOrEmpty(txtPatientName)) { YHReq.addQuery(YHRequest.item_name, YHRequest.compy_like, "'%" + txtPatientName + "%'", YHRequest.splice_and); } if (!string.IsNullOrEmpty(txtSex)) { YHReq.addQuery(YHRequest.item_sex, YHRequest.compy_equals, "'" + txtSex + "'", YHRequest.splice_and); } if (txtStartTime != "") { if (_hospital.Contains("礼嘉")) { YHReq.addQuery(YHRequest.item_date, YHRequest.compy_gt, "to_date('" + txtStartTime + "','yyyy-MM-dd')", YHRequest.splice_and); YHReq.addQuery(YHRequest.item_date, YHRequest.compy_lt, "to_date('" + ((Convert.ToDateTime(txtEbdTime)).AddDays(1)).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and (REGIST_DEPT_NAME ='礼嘉儿保科' or REGIST_DEPT_NAME = '礼嘉心理科')", YHRequest.splice_and); } else { YHReq.addQuery(YHRequest.item_date, YHRequest.compy_gt, "to_date('" + txtStartTime + "','yyyy-MM-dd')", YHRequest.splice_and); YHReq.addQuery(YHRequest.item_date, YHRequest.compy_lt, "to_date('" + ((Convert.ToDateTime(txtEbdTime)).AddDays(1)).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and (REGIST_DEPT_NAME ='儿保科' or REGIST_DEPT_NAME = '心理科')", YHRequest.splice_and); } } else { if (_hospital.Contains("礼嘉")) { YHReq.addQuery(YHRequest.item_date, YHRequest.compy_gt_equals, "to_date('" + DateTime.Now.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and (REGIST_DEPT_NAME ='礼嘉儿保科' or REGIST_DEPT_NAME = '礼嘉心理科')", YHRequest.splice_and); } else { YHReq.addQuery(YHRequest.item_date, YHRequest.compy_gt_equals, "to_date('" + DateTime.Now.ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and (REGIST_DEPT_NAME ='儿保科' or REGIST_DEPT_NAME = '心理科')", YHRequest.splice_and); } } if (!string.IsNullOrEmpty(txtBirth)) { YHReq.addQuery(YHRequest.item_birth, YHRequest.compy_equals, "to_date('" + txtBirth + "','yyyy-MM-dd')", YHRequest.splice_and); } var result = YHMQUtil <HisPatientInfo> .get(YHReq); if (result.success) { return(result.dataList); } else { return(null); } }
/// <summary> /// 获取读芯片号对象 /// 2017-11-29 cc /// </summary> /// <returns></returns> public static HisChipInfo GetChipObj() { if (IsSuccess()) { string chipnum = GetChipNum(); YHRequest YHReq = new YHRequest(YHRequest.fid_get_hischip); YHReq.addQuery(YHRequest.item_chip, YHRequest.compy_equals, "'" + chipnum + "'", YHRequest.splice_and); var result = YHMQUtil <HisChipInfo> .get(YHReq); HisChipInfo hisobj = result.data; return(hisobj); } else { return(null); } }