/// <summary> /// 获取病区 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetDeptName(out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = "select dictid_chr,dictname_vchr from t_aid_dict where trim(dictid_chr) <> '0' and dictkind_chr = '61'"; clsHRPTableService objHRPServ = null; try { objHRPServ = new clsHRPTableService(); lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
/// <summary> /// 取得样本类型 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetSamType(out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = " select sample_type_id_chr, sample_type_desc_vchr from t_aid_lis_sampletype order by sample_type_id_chr "; clsHRPTableService objHRPServ = null; try { objHRPServ = new clsHRPTableService(); lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
/// <summary> /// 获取所有抗生素 /// </summary> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetAllAnti(out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = @"select t.antiid as 抗生素ID,t.cname as 抗生素名称,t.ename as 英文名称 from t_atb_anti t order by antiid "; clsHRPTableService objHRPServ = null; try { objHRPServ = new clsHRPTableService(); lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbResult); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
public long m_lngQueryChcekItemCustomOrder(System.Security.Principal.IPrincipal p_objPrincipal, string p_strCheckItemID, out clsLisCheckItemCustomOrder p_objCheckItemCustomOrder) { p_objCheckItemCustomOrder = null; long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, strClassName, "m_lngQueryChcekItemCustomOrder"); if (lngRes <= 0) { return(lngRes); } string strSQL = null; clsHRPTableService objHRPSvc = null; try { strSQL = @"select t.air_blank_chr, t.jin_plate_way_chr, t.shock_speed_chr, t.shock_time_chr, t.wavelength_chr, t.filter_chr, t.deputy_filter_chr from t_bse_lis_check_item_cutomorde t where t.check_item_id_chr = ? "; IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strCheckItemID; DataTable dtResult = null; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = dtResult.Rows[0]; p_objCheckItemCustomOrder = new clsLisCheckItemCustomOrder(); p_objCheckItemCustomOrder.m_strAir_blank = drTemp["air_blank_chr"].ToString().Trim(); p_objCheckItemCustomOrder.m_strJin_plate_way_chr = drTemp["jin_plate_way_chr"].ToString().Trim(); p_objCheckItemCustomOrder.m_strShock_speed_chr = drTemp["shock_speed_chr"].ToString().Trim(); p_objCheckItemCustomOrder.m_strShock_time_chr = drTemp["shock_time_chr"].ToString().Trim(); p_objCheckItemCustomOrder.m_strWavelength_chr = drTemp["wavelength_chr"].ToString().Trim(); p_objCheckItemCustomOrder.m_strFilter_chr = drTemp["filter_chr"].ToString().Trim(); p_objCheckItemCustomOrder.m_strDeputy_filter_chr = drTemp["deputy_filter_chr"].ToString().Trim(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { strSQL = null; objPrivilege = null; objHRPSvc = null; } return(lngRes); }
public long m_lngInsertCheckItemCustomOrder(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckItemCustomOrder p_objCheckItemCustomOrderVO) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, strClassName, "m_lngInsertCheckItemCustomOrder"); if (lngRes <= 0) { return(lngRes); } string strSQL = null; clsHRPTableService objHRPSvc = null; try { strSQL = @"insert into t_bse_lis_check_item_cutomorde (check_item_id_chr, air_blank_chr, jin_plate_way_chr, shock_speed_chr, shock_time_chr, wavelength_chr, filter_chr, deputy_filter_chr) values (?, ?, ?, ?, ?, ?, ?, ?) "; IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(8, out objDPArr); objDPArr[0].Value = p_objCheckItemCustomOrderVO.m_strCheckItemID; objDPArr[1].Value = p_objCheckItemCustomOrderVO.m_strAir_blank; objDPArr[2].Value = p_objCheckItemCustomOrderVO.m_strJin_plate_way_chr; objDPArr[3].Value = p_objCheckItemCustomOrderVO.m_strShock_speed_chr; objDPArr[4].Value = p_objCheckItemCustomOrderVO.m_strShock_time_chr; objDPArr[5].Value = p_objCheckItemCustomOrderVO.m_strWavelength_chr; objDPArr[6].Value = p_objCheckItemCustomOrderVO.m_strFilter_chr; objDPArr[7].Value = p_objCheckItemCustomOrderVO.m_strDeputy_filter_chr; long lngEff = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { strSQL = null; objPrivilege = null; objHRPSvc = null; } return(lngRes); }
public long m_lngQueryAppUnitSeq(string[] p_strAppUnitArr, out string[] p_strOutAppUnitArr) { long lngRes = 0; p_strOutAppUnitArr = null; string strSQL = null; clsHRPTableService objHRPSvc = null; try { strSQL = @"select b.apply_unit_id_chr, a.print_seq_int from t_aid_lis_report_group_detail a, t_aid_lis_sample_group_unit b where a.sample_group_id_chr = b.sample_group_id_chr and b.apply_unit_id_chr in (? "; IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(p_strAppUnitArr.Length, out objDPArr); objDPArr[0].Value = p_strAppUnitArr[0]; for (int i = 1; i < p_strAppUnitArr.Length; i++) { objDPArr[i].Value = p_strAppUnitArr[i]; strSQL += ",?"; } strSQL += ")"; DataTable dtResult = null; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataView dtView = dtResult.DefaultView; dtView.Sort = "print_seq_int asc"; p_strOutAppUnitArr = new string[dtView.Count]; for (int i = 0; i < dtView.Count; i++) { p_strOutAppUnitArr[i] = dtView[i]["apply_unit_id_chr"].ToString().Trim(); } } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, false); } finally { objHRPSvc.Dispose(); objHRPSvc = null; strSQL = null; } return(lngRes); }
public long m_lngQuerySampleInfo(string p_strBarcode, out clsLisApplMainVO p_objMainVO) { long lngRes = 0; string strSQL = null; p_objMainVO = null; clsHRPTableService objHRPSvc = null; try { strSQL = @"select a.patient_name_vchr, b.application_form_no_chr, b.check_content_vchr, b.application_id_chr from t_opr_lis_sample a, t_opr_lis_application b where a.application_id_chr = b.application_id_chr and a.barcode_vchr = ? and a.status_int >=3 and b.pstatus_int = 2"; IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strBarcode; DataTable dtResult = null; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = dtResult.Rows[0]; p_objMainVO = new clsLisApplMainVO(); p_objMainVO.m_strPatient_Name = drTemp["patient_name_vchr"].ToString().Trim(); p_objMainVO.m_strApplication_Form_NO = drTemp["application_form_no_chr"].ToString().Trim(); p_objMainVO.m_strCheckContent = drTemp["check_content_vchr"].ToString().Trim(); p_objMainVO.m_strAPPLICATION_ID = drTemp["application_id_chr"].ToString().Trim(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, false); } finally { objHRPSvc.Dispose(); objHRPSvc = null; } return(lngRes); }
public long m_lngQueryPatientInfo(string p_strPatientCardID, out clsPatientBaseInfo_VO p_objPatientInfoVO) { p_objPatientInfoVO = null; long lngRes = 0; clsHRPTableService objHRPSvc = null; string strSQL = null; try { strSQL = @"select a.lastname_vchr, a.sex_chr, a.birth_dat from t_bse_patient a, t_bse_patientcard c where a.patientid_chr = c.patientid_chr and c.patientcardid_chr = ? "; IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strPatientCardID; DataTable dtResult = null; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = dtResult.Rows[0]; com.digitalwave.iCare.middletier.common.clsGetCurrentTime objSvc = new com.digitalwave.iCare.middletier.common.clsGetCurrentTime(); string strBirthDay = null; DateTime dtTime = objSvc.m_mthGetCurrentDateTime(); p_objPatientInfoVO = new clsPatientBaseInfo_VO(); p_objPatientInfoVO.m_strPatientCardNO = p_strPatientCardID; p_objPatientInfoVO.m_strName = drTemp["lastname_vchr"].ToString().Trim(); p_objPatientInfoVO.m_strSex = drTemp["sex_chr"].ToString().Trim(); strBirthDay = drTemp["birth_dat"].ToString().Trim(); p_objPatientInfoVO.m_strAge = com.digitalwave.Emr.StaticObject.clsConsts.m_strCalAge(strBirthDay, dtTime); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { p_strPatientCardID = null; strSQL = null; objHRPSvc = null; } return(lngRes); }
public long m_lngUpdateCheckNUM(clsLisApplMainVO[] p_objMainArr, string p_strOperator) { long lngRes = 0; string strSQL = null; clsHRPTableService objHRPSvc = null; DbType[] dbType = new DbType[] { DbType.String, DbType.String, DbType.String }; object[][] objValue = new object[3][]; for (int i = 0; i < objValue.Length; i++) { objValue[i] = new object[p_objMainArr.Length]; } try { strSQL = @"update t_opr_lis_application a set a.application_form_no_chr = ?, a.modify_dat = sysdate, a.operator_id_chr = ? where a.application_id_chr = ? and a.pstatus_int = 2 "; for (int i = 0; i < p_objMainArr.Length; i++) { objValue[0][i] = p_objMainArr[i].m_strApplication_Form_NO; objValue[1][i] = p_strOperator; objValue[2][i] = p_objMainArr[i].m_strAPPLICATION_ID; } objHRPSvc = new clsHRPTableService(); lngRes = objHRPSvc.m_lngSaveArrayWithParameters(strSQL, objValue, dbType); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objValue = null; objHRPSvc.Dispose(); objHRPSvc = null; } return(lngRes); }
/// <summary> /// 模糊查询细菌 /// </summary> /// <param name="micName"></param> /// <param name="IsEnglish"></param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetFuzzyQueryMic(string micName, bool IsEnglish, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = null; if (IsEnglish) { strSQL = @"select t.germid as 细菌ID,t.cname as 细菌名称,t.ename as 英文名称 from t_atb_germ t where instr(t.germid,?)> 0 order by germid "; } else { strSQL = @"select t.germid as 细菌ID,t.cname as 细菌名称,t.ename as 英文名称 from t_atb_germ t where instr(t.cname,?)> 0 order by germid "; } clsHRPTableService objHRPServ = null; try { objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].DbType = DbType.String; objDPArr[0].Value = micName; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
public long m_lngGetSysParm(string p_strParmCode, out string p_strParmValue) { p_strParmValue = ""; long lngRes = 0; if (string.IsNullOrEmpty(p_strParmCode)) { return(lngRes); } clsHRPTableService objHRPServ = null; try { string strSQL = @"select parmvalue_vchr from t_bse_sysparm where status_int = 1 and parmcode_chr = ?"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strParmCode; DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { p_strParmValue = dtResult.Rows[0]["parmvalue_vchr"].ToString().Trim(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; p_strParmCode = null; } return(lngRes); }
public long m_lngGetDeptMentInfo(System.Security.Principal.IPrincipal p_objPrincipal, out DataTable p_dtResult) { p_dtResult = null; long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsPublicSvc", "m_lngGetDeptMentInfo"); objPrivilege = null; if (lngRes <= 0) { return(lngRes); } try { string strSQL = @"select t.deptid_chr, t.createdate_dat, t.status_int, t.deactivate_dat, t.deptname_vchr, t.pycode_chr, t.shortno_chr from t_bse_deptdesc t where t.status_int = 1"; clsHRPTableService objHRPServ = new clsHRPTableService(); lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref p_dtResult); objHRPServ = null; } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } return(lngRes); }
public long m_lngDeleteCheckItemCustomOrder(System.Security.Principal.IPrincipal p_objPrincipal, string p_strCheckItemID) { long lngRes = 0; clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, strClassName, "m_lngDeleteCheckItemCustomOrder"); if (lngRes <= 0) { return(lngRes); } string strSQL = null; clsHRPTableService objHRPSvc = null; try { strSQL = @"delete t_bse_lis_check_item_cutomorde t where t.check_item_id_chr = ?"; IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strCheckItemID; long lngEff = 0; lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { strSQL = null; objPrivilege = null; objHRPSvc = null; } return(lngRes); }
/// <summary> /// 细菌分布 /// </summary> /// <param name="p_dtDateFrom">日期</param> /// <param name="p_dtDateTO">日期</param> /// <param name="SamtNo">样本类型</param> /// <param name="DisNo">病区号</param> /// <param name="Sex">性别</param> /// <param name="AgeFrom">年龄</param> /// <param name="AgeTo">年龄</param> /// <param name="TestMethod">实验方法</param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetMicdistributionTend(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string SamtNo, string DisNo, string Sex, string AgeFrom, string AgeTo, string TestMethod, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; bool flag = false; DateTime datefrom = DateTime.Parse(p_dtDateTO.AddMonths(-2).ToString("yyyy-MM-01 00:00:00")); string strSQL = @"select micname,count(*) as total, sum(case when trunc(a.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end) as month1, sum(case when trunc(a.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end) as month2, sum(case when trunc(a.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end) as month3 from t_atb_resultexe a where a.exedate between ? and ? "; if (!string.IsNullOrEmpty(micname)) { strSQL += " and a.micname=? "; flag = true; } strSQL += @" and a.reqno in( select t2.reqno from t_atb_AntiResultBill t2 where t2.samno in( select distinct trim(t3.device_sampleid_chr) from t_opr_lis_device_relation t3 ,t_opr_lis_app_sample t4,t_opr_lis_application t5 where t3.deviceid_chr='000032' and t3.sample_id_chr=t4.sample_id_chr and t4.application_id_chr=t5.application_id_chr "; clsHRPTableService objHRPServ = null; try { IDataParameter[] objDPArr = null; if (string.IsNullOrEmpty(SamtNo) && string.IsNullOrEmpty(DisNo) && string.IsNullOrEmpty(Sex) && string.IsNullOrEmpty(AgeFrom) && string.IsNullOrEmpty(AgeTo) && string.IsNullOrEmpty(TestMethod)) { //没有病人信息的查询 strSQL = @"select micname,count(*) as total, sum(case when trunc(a.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end) as month1, sum(case when trunc(a.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end) as month2, sum(case when trunc(a.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end) as month3 from t_atb_resultexe a where a.exedate between ? and ?"; if (!string.IsNullOrEmpty(micname)) { strSQL += " and a.micname= '" + micname + "'"; } strSQL += " group by micname order by micname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(5, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = p_dtDateTO.AddMonths(-2);; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateTO.AddMonths(-1);; objDPArr[2].DbType = DbType.DateTime; objDPArr[2].Value = p_dtDateTO; objDPArr[3].DbType = DbType.DateTime; objDPArr[3].Value = datefrom; objDPArr[4].DbType = DbType.DateTime; objDPArr[4].Value = p_dtDateTO; } else { ArrayList arrlParm = new ArrayList(); arrlParm.Add(datefrom); arrlParm.Add(datefrom.AddMonths(1)); arrlParm.Add(p_dtDateTO); arrlParm.Add(datefrom); arrlParm.Add(p_dtDateTO); if (flag) { arrlParm.Add(micname); } if (!string.IsNullOrEmpty(Sex)) { strSQL += " and trim(t5.sex_chr)=? "; arrlParm.Add(Sex); } if (!string.IsNullOrEmpty(AgeFrom) && !string.IsNullOrEmpty(AgeTo)) { strSQL += " and substr(regexp_replace(t5.age_chr,'[^0-9]'),1,3) between ? and ? "; arrlParm.Add(AgeFrom); arrlParm.Add(AgeTo); } if (!string.IsNullOrEmpty(DisNo)) { strSQL += " and t5.patient_type_id_chr=? "; arrlParm.Add(DisNo); } if (!string.IsNullOrEmpty(SamtNo)) { strSQL += " and t5.sample_type_vchr=? "; arrlParm.Add(SamtNo); } strSQL += " ))group by micname order by micname "; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(arrlParm.Count, out objDPArr); for (int i = 0; i < arrlParm.Count; i++) { objDPArr[i].Value = arrlParm[i]; } } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
public long m_lngQueryLISAppItemByDate(string p_strStartDate, string p_strEndDate, out clsLISApplItem_VO[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strStartDate) || string.IsNullOrEmpty(p_strEndDate)) { return(lngRes); } clsHRPTableService objHRPServ = null; //Hashtable objHsTable = new Hashtable(); try { string strSQL = @"--申请单明细表 select '' organcode, seq_ygyylis_id.nextval list_seq, t4.check_category_id_chr recordtype, --检验类别 t4.check_category_desc_vchr, --检验名称 t.application_id_chr observationid, --检验单号 t1.check_item_id_chr observationsubid, --检验项目代码 t2.check_item_english_name_vchr provename, --检验英文名称 t2.check_item_name_vchr observationsubname, --检验项目名称 t2.resulttype_chr resulttype, --结果类型 t.result_vchr observationvalue, --检验项目值 t2.unit_chr units, --单位 t2.ref_value_range_vchr referencesrange, --参考范围 '' observationresultstatus, --检验指标 t.summary_vchr demo, --备注 t6.devicename_vchr apparatus, --仪器名称 t.abnormal_flag_chr singularity --异常提示 from (select a.modify_dat,a.result_vchr,a1.application_id_chr,a1.sample_id_chr,a.groupid_chr,a.check_item_id_chr,a.summary_vchr,a.abnormal_flag_chr from t_opr_lis_check_result a left join t_opr_lis_app_sample a1 on a.sample_id_chr = a1.sample_id_chr and a.groupid_chr = a1.sample_group_id_chr where a.modify_dat between ? and ? and a.status_int = 1) t left outer join t_opr_lis_app_check_item t1 on t1.application_id_chr = t.application_id_chr and t1.sample_group_id_chr = t.groupid_chr and t1.check_item_id_chr = t.check_item_id_chr left outer join t_bse_lis_check_item t2 on t1.check_item_id_chr = t2.check_item_id_chr and t2.resulttype_chr <> 1 left outer join t_aid_lis_sample_group t3 on t3.sample_group_id_chr = t1.sample_group_id_chr left outer join t_bse_lis_check_category t4 on t4.check_category_id_chr = t3.check_category_id_chr left outer join t_opr_lis_device_relation t5 on t5.sample_id_chr = t.sample_id_chr and t5.status_int = 2 left outer join t_bse_lis_device t6 on t6.deviceid_chr = t5.deviceid_chr"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = Convert.ToDateTime(p_strStartDate); objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strEndDate); DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ.Dispose(); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; int iRowCount = dtResult.Rows.Count; clsLISApplItem_VO objTemp = null; p_objResultArr = new clsLISApplItem_VO[iRowCount]; List <clsLISApplItem_VO> objList = new List <clsLISApplItem_VO>(); for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISApplItem_VO(); DateTime dt = DateTime.MinValue; objTemp.m_strLIST_SEQ = drTemp["list_seq"].ToString().Trim(); objTemp.m_strRECORDTYPE = clsDataUpload_Svc.m_strConvertValue("checkcategory", drTemp["recordtype"].ToString().Trim(), ""); objTemp.m_strOBSERVATIONID = drTemp["observationid"].ToString().Trim(); objTemp.m_strOBSERVATIONSUBID = drTemp["observationsubid"].ToString().Trim(); objTemp.m_strPROVENAME = drTemp["provename"].ToString().Trim(); objTemp.m_strOBSERVATIONSUBNAME = drTemp["observationsubname"].ToString().Trim(); objTemp.m_strRESULTTYPE = clsDataUpload_Svc.m_strConvertValue("resulttype_chr", drTemp["resulttype"].ToString().Trim(), ""); objTemp.m_strOBSERVATIONVALUE = drTemp["observationvalue"].ToString().Trim(); objTemp.m_strUNITS = drTemp["units"].ToString().Trim(); objTemp.m_strREFERENCESRANGE = drTemp["referencesrange"].ToString().Trim(); objTemp.m_strOBSERVATIONRESULTSTATUS = drTemp["observationresultstatus"].ToString().Trim(); objTemp.m_strDEMO = drTemp["demo"].ToString().Trim(); objTemp.m_strAPPARATUS = drTemp["apparatus"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strAPPARATUS)) { objTemp.m_strAPPARATUS = "手工"; } objTemp.m_strSINGULARITY = drTemp["singularity"].ToString().Trim(); try { //objHsTable.Add(objTemp.m_strOBSERVATIONID + objTemp.m_strOBSERVATIONSUBID, ""); objList.Add(objTemp); } catch { } } p_objResultArr = objList.ToArray(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; p_strEndDate = null; p_strStartDate = null; } return(lngRes); }
/// <summary> /// 细菌分布报告统计报表 /// </summary> /// <param name="micname">细菌名称</param> /// <param name="p_dtDateFrom">日期</param> /// <param name="p_dtDateTO">日期</param> /// <param name="SamtNo">样本类型</param> /// <param name="DisNo">病区号</param> /// <param name="Sex">性别</param> /// <param name="AgeFrom">年龄</param> /// <param name="AgeTo">年龄</param> /// <param name="TestMethod">实验方法</param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetBacteriaDistribution(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string SamtNo, string DisNo, string Sex, string AgeFrom, string AgeTo, string TestMethod, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = @"select t1.micname,count(*) as miccount from t_atb_ResultExe t1 where t1.exedate between ? and ? "; if (!string.IsNullOrEmpty(micname)) { strSQL += " and t1.micname='" + micname + "' "; } strSQL += @" and t1.reqno in( select t2.reqno from t_atb_AntiResultBill t2 where t2.samno in( select distinct trim(t3.device_sampleid_chr) from t_opr_lis_device_relation t3 ,t_opr_lis_app_sample t4,t_opr_lis_application t5 where t3.deviceid_chr='000032' and t3.sample_id_chr=t4.sample_id_chr and t4.application_id_chr=t5.application_id_chr "; clsHRPTableService objHRPServ = null; try { IDataParameter[] objDPArr = null; if (string.IsNullOrEmpty(SamtNo) && string.IsNullOrEmpty(DisNo) && string.IsNullOrEmpty(Sex) && string.IsNullOrEmpty(AgeFrom) && string.IsNullOrEmpty(AgeTo) && string.IsNullOrEmpty(TestMethod)) { //没有病人信息的查询 strSQL = @"select t1.micname,count(*) as miccount from t_atb_ResultExe t1 where t1.exedate between ? and ? "; if (!string.IsNullOrEmpty(micname)) { strSQL += " and t1.micname='" + micname + "' "; } strSQL += @"group by micname order by micname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = p_dtDateFrom; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateTO; } else { ArrayList arrlParm = new ArrayList(); arrlParm.Add(p_dtDateFrom); arrlParm.Add(p_dtDateTO); if (!string.IsNullOrEmpty(Sex)) { strSQL += " and trim(t5.sex_chr)=? "; arrlParm.Add(Sex); } if (!string.IsNullOrEmpty(AgeFrom) && !string.IsNullOrEmpty(AgeTo)) { strSQL += " and substr(regexp_replace(t5.age_chr,'[^0-9]'),1,3) between ? and ? "; arrlParm.Add(AgeFrom); arrlParm.Add(AgeTo); } if (!string.IsNullOrEmpty(DisNo)) { strSQL += " and t5.patient_type_id_chr=? "; arrlParm.Add(DisNo); } if (!string.IsNullOrEmpty(SamtNo)) { strSQL += " and t5.sample_type_vchr=? "; arrlParm.Add(SamtNo); } strSQL += " ))group by micname order by micname "; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(arrlParm.Count, out objDPArr); for (int i = 0; i < arrlParm.Count; i++) { objDPArr[i].Value = arrlParm[i]; } } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } return(lngRes); }
public long m_lngGetDeviceQCDataBySampleID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strSampleID, string p_strStartDat, string p_strEndDat, int[] p_intBatchSeqArr, out clsLisQCDataVO[] p_objQCDataArr) { p_objQCDataArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strSampleID) || string.IsNullOrEmpty(p_strStartDat) || string.IsNullOrEmpty(p_strEndDat) || p_intBatchSeqArr == null || p_intBatchSeqArr.Length <= 0) { return(lngRes); } com.digitalwave.security.clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCLisServ", "m_lngGetDeviceQCDataBySampleID"); objPrivilege = null; if (lngRes <= 0) { return(lngRes); } try { StringBuilder strSQLBuilder = new StringBuilder(512); strSQLBuilder.Append(@"select t.result_vchr, t.check_dat, d.qcbatch_seq_int from t_opr_lis_result t inner join t_bse_lis_device_check_item a on a.device_check_item_name_vchr = t.device_check_item_name_vchr and a.is_qc_item_int = 1 and a.has_graph_result_int = 0 inner join t_bse_lis_check_item_dev_item b on b.device_check_item_id_chr = a.device_check_item_id_chr and b.device_model_id_chr = a.device_model_id_chr inner join t_bse_lis_device c on c.device_model_id_chr = b.device_model_id_chr inner join t_opr_lis_qcbatch d on d.check_item_id_chr = b.check_item_id_chr where t.device_sampleid_chr = ? and t.deviceid_chr = c.deviceid_chr and t.check_dat between ? and ? and (d.qcbatch_seq_int = ?"); for (int index = 1; index < p_intBatchSeqArr.Length; index++) { strSQLBuilder.Append(" or d.qcbatch_seq_int = ?"); } strSQLBuilder.Append(")"); clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(p_intBatchSeqArr.Length + 3, out objDPArr); objDPArr[0].Value = p_strSampleID; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strStartDat); objDPArr[2].DbType = DbType.DateTime; objDPArr[2].Value = Convert.ToDateTime(p_strEndDat); for (int index = 0; index < p_intBatchSeqArr.Length; index++) { objDPArr[3 + index].Value = p_intBatchSeqArr[index]; } DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQLBuilder.ToString(), ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { int iRowCount = dtResult.Rows.Count; List <clsLisQCDataVO> lstQCData = new List <clsLisQCDataVO>(); clsLisQCDataVO objTemp = null; DataRow drTemp = null; double dblTemp = 0d; for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; if (double.TryParse(drTemp["result_vchr"].ToString(), out dblTemp) && drTemp["check_dat"] != DBNull.Value) { objTemp = new clsLisQCDataVO(); objTemp.m_dlbResult = dblTemp; objTemp.m_datQCDate = Convert.ToDateTime(Convert.ToDateTime(drTemp["check_dat"]).ToString("yyyy-MM-dd")); objTemp.m_intSeq = -1; int.TryParse(drTemp["qcbatch_seq_int"].ToString(), out objTemp.m_intQCBatchSeq); objTemp.m_intConcentrationSeq = -1; lstQCData.Add(objTemp); } } if (lstQCData.Count > 0) { p_objQCDataArr = lstQCData.ToArray(); } } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); objLogger = null; } finally { p_intBatchSeqArr = null; p_strEndDat = null; p_strSampleID = null; p_strStartDat = null; } return(lngRes); }
/// <summary> /// 敏感率统计 /// </summary> /// <param name="p_dtDateFrom">日期</param> /// <param name="p_dtDateTO">日期</param> /// <param name="SamtNo">样本类型</param> /// <param name="DisNo">病区号</param> /// <param name="Sex">性别</param> /// <param name="AgeFrom">年龄</param> /// <param name="AgeTo">年龄</param> /// <param name="TestMethod">实验方法</param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetSensitiveRate(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string SamtNo, string DisNo, string Sex, string AgeFrom, string AgeTo, string TestMethod, string strTempAntiID, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = @"select antiname,micname, count(*) total,sum(case micexplain when 'S' then 1 else 0 end)as s_num from( SELECT a.antiname,a.micexplain,b.micname FROM t_atb_ResultMic a, t_atb_ResultExe b where a.reqno=b.reqno and a.exeno=b.exeno and a.antidate between ? and ? "; if (!string.IsNullOrEmpty(strTempAntiID)) { strSQL += " and a.antiid='" + strTempAntiID + "'"; } if (!string.IsNullOrEmpty(micname)) { strSQL += " and b.micname='" + micname + "'"; } strSQL += @" and a.reqno in( select t2.reqno from t_atb_AntiResultBill t2 where t2.samno in( select trim(t3.device_sampleid_chr) from t_opr_lis_device_relation t3 ,t_opr_lis_app_sample t4,t_opr_lis_application t5 where t3.deviceid_chr='000032' and t3.sample_id_chr=t4.sample_id_chr and t4.application_id_chr=t5.application_id_chr "; clsHRPTableService objHRPServ = null; try { IDataParameter[] objDPArr = null; if (string.IsNullOrEmpty(SamtNo) && string.IsNullOrEmpty(DisNo) && string.IsNullOrEmpty(Sex) && string.IsNullOrEmpty(AgeFrom) && string.IsNullOrEmpty(AgeTo) && string.IsNullOrEmpty(TestMethod)) { strSQL = @"select antiname,micname, count(*) total,sum(case micexplain when 'S' then 1 else 0 end)as s_num from( SELECT a.antiname,a.micexplain,b.micname FROM t_atb_ResultMic a, t_atb_ResultExe b where a.reqno=b.reqno and a.exeno=b.exeno and a.antidate between ? and ? "; if (!string.IsNullOrEmpty(strTempAntiID)) { strSQL += " and a.antiid='" + strTempAntiID + "'"; } if (!string.IsNullOrEmpty(micname)) { strSQL += " and b.micname='" + micname + "'"; } strSQL += @" ) group by antiname,micname order by antiname,micname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = p_dtDateFrom; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateTO; } else { ArrayList arrlParm = new ArrayList(); arrlParm.Add(p_dtDateFrom); arrlParm.Add(p_dtDateTO); if (!string.IsNullOrEmpty(Sex)) { strSQL += " and trim(t5.sex_chr)=? "; arrlParm.Add(Sex); } if (!string.IsNullOrEmpty(AgeFrom) && !string.IsNullOrEmpty(AgeTo)) { strSQL += " and substr(regexp_replace(t5.age_chr,'[^0-9]'),1,3) between ? and ? "; arrlParm.Add(AgeFrom); arrlParm.Add(AgeTo); } if (!string.IsNullOrEmpty(DisNo)) { strSQL += " and t5.patient_type_id_chr=? "; arrlParm.Add(DisNo); } if (!string.IsNullOrEmpty(SamtNo)) { strSQL += " and t5.sample_type_vchr=? "; arrlParm.Add(SamtNo); } strSQL += "))"; if (!string.IsNullOrEmpty(TestMethod) && !TestMethod.Contains("ALL")) { strSQL += " and a.testno=? "; arrlParm.Add(TestMethod); } strSQL += " )group by antiname,micname order by antiname,micname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(arrlParm.Count, out objDPArr); for (int i = 0; i < arrlParm.Count; i++) { objDPArr[i].Value = arrlParm[i]; } } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
public long m_lngQueryPatientCheckContent(string p_strPatientCardID, string p_strFromDate, string p_strToDate, out string p_strCheckContent, out clsLisApplMainVO[] p_objApplMainArr) { long lngRes = 0; string strSQL = null; p_strCheckContent = null; p_objApplMainArr = null; clsHRPTableService objHRPSvc = null; try { strSQL = @"select a.application_id_chr, a.check_content_vchr, a.sample_type_id_chr, a.printed_num, c.sample_type_desc_vchr, d.barcode_vchr from t_opr_lis_application a, t_aid_lis_sampletype c, t_opr_lis_sample d where a.sample_type_id_chr = c.sample_type_id_chr(+) and a.application_id_chr = d.application_id_chr and a.patient_type_id_chr = '2' and a.pstatus_int = 2 and a.patientcardid_chr = ? and a.application_dat between to_date(?, 'yyyy-mm-dd hh24:mi:ss') and to_date(?, 'yyyy-mm-dd hh24:mi:ss') and exists (select 1 from t_opr_attachrelation b where a.application_id_chr = b.attachid_vchr and b.status_int = 1) "; com.digitalwave.iCare.middletier.common.clsGetCurrentTime objSvc = new com.digitalwave.iCare.middletier.common.clsGetCurrentTime(); DateTime dtTime = objSvc.m_mthGetCurrentDateTime(); IDataParameter[] objDPArr = null; objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(3, out objDPArr); objDPArr[0].Value = p_strPatientCardID; objDPArr[1].Value = p_strFromDate; objDPArr[2].Value = p_strToDate; DataTable dtResult = null; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; List <clsLisApplMainVO> m_lstAppMain = new List <clsLisApplMainVO>(); clsLisApplMainVO objTemp = null; for (int i = 0; i < dtResult.Rows.Count; i++) { drTemp = dtResult.Rows[i]; p_strCheckContent += "[" + drTemp["check_content_vchr"].ToString().Trim() + " " + "样本:" + drTemp["sample_type_desc_vchr"].ToString().Trim() + "]" + ";" + "\r\n"; objTemp = new clsLisApplMainVO(); objTemp.m_strAPPLICATION_ID = drTemp["application_id_chr"].ToString().Trim(); objTemp.m_strSampleTypeID = drTemp["sample_type_id_chr"].ToString().Trim(); objTemp.m_intReportPrint = drTemp["printed_num"] != DBNull.Value ? Convert.ToInt32(drTemp["printed_num"].ToString().Trim()) : 0; objTemp.m_strBarcode = drTemp["barcode_vchr"].ToString(); m_lstAppMain.Add(objTemp); } if (m_lstAppMain.Count > 0) { p_objApplMainArr = m_lstAppMain.ToArray(); } } p_strFromDate = null; p_strToDate = null; dtResult.Dispose(); dtResult = null; } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { strSQL = null; objHRPSvc = null; p_strPatientCardID = null; } return(lngRes); }
public long m_lngQueryLISAppHISByDate(string p_strStartDate, string p_strEndDate, out clsLISAppl_VO[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strStartDate) || string.IsNullOrEmpty(p_strEndDate)) { return(lngRes); } clsHRPTableService objHRPServ = null; try { string strSQL = @"select '' as outrester, c.registerid_chr as inrester, t.application_id_chr,t.modify_dat, a.confirm_dat, t.application_dat, t.appl_empid_chr, d.lastname_vchr as applempname, a.confirmer_id_chr as checkerid, e.lastname_vchr as checkername, '' as checkmonth, t.appl_deptid_chr, f.deptname_vchr from t_opr_lis_application t inner join t_opr_lis_sample a on a.application_id_chr = t.application_id_chr and a.status_int = 6 inner join t_opr_attachrelation b on b.attarelaid_chr = t.application_id_chr and b.sysfrom_int = 2 and b.status_int = 1 and b.attachtype_int = 3 left outer join t_opr_bih_order c on c.orderid_chr = b.sourceitemid_vchr left outer join t_bse_employee d on t.appl_empid_chr = d.empid_chr left outer join t_bse_employee e on a.confirmer_id_chr = e.empid_chr left outer join t_bse_deptdesc f on f.deptid_chr = t.appl_deptid_chr where t.pstatus_int > 0 and a.confirm_dat between ? and ?"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = Convert.ToDateTime(p_strStartDate); objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strEndDate); DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ.Dispose(); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; int iRowCount = dtResult.Rows.Count; clsLISAppl_VO objTemp = null; p_objResultArr = new clsLISAppl_VO[iRowCount]; for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISAppl_VO(); objTemp.m_strVISITNO = drTemp["outrester"].ToString().Trim(); objTemp.m_strINHOSSEQNO = drTemp["inrester"].ToString().Trim(); objTemp.m_strOBSERVATIONID = drTemp["application_id_chr"].ToString().Trim(); objTemp.m_strOBSERVATIONDATETIM = drTemp["confirm_dat"] != DBNull.Value ? Convert.ToDateTime(drTemp["confirm_dat"]).ToString("yyyy-MM-dd HH:mm:ss") : ""; objTemp.m_strCREATEOBSERVATIONDATETIME = drTemp["application_dat"] != DBNull.Value ? Convert.ToDateTime(drTemp["application_dat"]).ToString("yyyy-MM-dd HH:mm:ss") : ""; objTemp.m_strCREATECLINICIANCODE = drTemp["appl_empid_chr"].ToString().Trim(); objTemp.m_strCREATECLINICIANNAME = drTemp["applempname"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTCODE = drTemp["checkerid"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTNAME = drTemp["checkername"].ToString().Trim(); objTemp.m_strOBSERVATIONWAY = drTemp["checkmonth"].ToString().Trim(); objTemp.m_strOBSERVATIONDEPTCODE = drTemp["appl_deptid_chr"].ToString().Trim(); objTemp.m_strOBSERVATIONDEPTNAME = drTemp["deptname_vchr"].ToString().Trim(); //// 执行科室代码 + 执行科室名称 //objTemp.m_strOBSERVATIONOPTDEPTCODE = drTemp[""].ToString().Trim(); //objTemp.m_strOBSERVATIONOPTDEPTNAME = drTemp[""].ToString().Trim(); p_objResultArr[iRow] = objTemp; } } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } return(lngRes); }
public long lngGetInstrumentSerialSetting2(string strData_Acquisition_Computer_IP, out clsLIS_Equip_Base[] objConfig_List) { objConfig_List = null; long lngRes = 0; if (string.IsNullOrEmpty(strData_Acquisition_Computer_IP)) { return(lngRes); } clsHRPTableService objHRPServ = null; try { string strSQL = @"select d.deviceid_chr, m.device_model_desc_vchr, s.comno_chr, s.baulrate_chr, s.databit_chr, s.stopbit_chr, s.parity_chr, s.flowcontrol_chr, s.receivebuffer_chr, s.sendbuffer_chr, s.sendcommand_chr, s.sendcommandinternal_chr, s.dataanalysisdll_vchr, s.dataanalysisnamespace_vchr, d.devicename_vchr, d.dataacquisitioncomputerip_chr, d.device_code_chr from t_bse_lis_serialsetup s, t_bse_lis_device d, t_bse_lis_device_model m where d.device_model_id_chr = s.device_model_id_chr and d.device_model_id_chr = m.device_model_id_chr and d.end_date_dat is null and trim(d.dataacquisitioncomputerip_chr) = ?"; DataTable dtResult = null; objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = strData_Acquisition_Computer_IP; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); //List<clsLIS_Equip_Base> lstEquip = new List<clsLIS_Equip_Base>(); List <clsLIS_Equip_Base> lstEquip = new List <clsLIS_Equip_Base>(); DataRow drTemp = null; if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { #region clsLIS_Equip_ConfigVO clsLIS_Equip_ConfigVO2 objTemp = null; for (int iRow = 0; iRow < dtResult.Rows.Count; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLIS_Equip_ConfigVO2(); if (drTemp["DEVICEID_CHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_ID = drTemp["DEVICEID_CHR"].ToString().Trim(); } if (drTemp["DEVICENAME_VCHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_Name = drTemp["DEVICENAME_VCHR"].ToString().Trim(); } if (drTemp["DEVICE_MODEL_DESC_VCHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_Model = drTemp["DEVICE_MODEL_DESC_VCHR"].ToString().Trim(); } if (drTemp["COMNO_CHR"] != System.DBNull.Value) { objTemp.strCOM_No = drTemp["COMNO_CHR"].ToString().Trim(); } if (drTemp["BAULRATE_CHR"] != System.DBNull.Value) { objTemp.strBaud_Rate = drTemp["BAULRATE_CHR"].ToString().Trim(); } if (drTemp["DATABIT_CHR"] != System.DBNull.Value) { objTemp.strData_Bit = drTemp["DATABIT_CHR"].ToString().Trim(); } if (drTemp["STOPBIT_CHR"] != System.DBNull.Value) { objTemp.strStop_Bit = drTemp["STOPBIT_CHR"].ToString().Trim(); } if (drTemp["PARITY_CHR"] != System.DBNull.Value) { objTemp.strParity = drTemp["PARITY_CHR"].ToString().Trim(); } if (drTemp["FLOWCONTROL_CHR"] != System.DBNull.Value) { objTemp.strFlow_Control = drTemp["FLOWCONTROL_CHR"].ToString().Trim(); } if (drTemp["RECEIVEBUFFER_CHR"] != System.DBNull.Value) { objTemp.strReceive_Buffer = drTemp["RECEIVEBUFFER_CHR"].ToString().Trim(); } if (drTemp["SENDBUFFER_CHR"] != System.DBNull.Value) { objTemp.strSend_Buffer = drTemp["SENDBUFFER_CHR"].ToString().Trim(); } if (drTemp["SENDCOMMAND_CHR"] != System.DBNull.Value) { objTemp.strSend_Command = drTemp["SENDCOMMAND_CHR"].ToString(); } if (drTemp["SENDCOMMANDINTERNAL_CHR"] != System.DBNull.Value) { objTemp.strSend_Command_Internal = drTemp["SENDCOMMANDINTERNAL_CHR"].ToString().Trim(); } if (drTemp["DATAANALYSISDLL_VCHR"] != System.DBNull.Value) { objTemp.strData_Analysis_DLL = drTemp["DATAANALYSISDLL_VCHR"].ToString().Trim(); } if (drTemp["DATAANALYSISNAMESPACE_VCHR"] != System.DBNull.Value) { objTemp.strData_Analysis_Namespace = drTemp["DATAANALYSISNAMESPACE_VCHR"].ToString().Trim(); } if (drTemp["DATAACQUISITIONCOMPUTERIP_CHR"] != System.DBNull.Value) { objTemp.strData_Acquisition_Computer_IP = drTemp["DATAACQUISITIONCOMPUTERIP_CHR"].ToString().Trim(); } objTemp.strLIS_Instrument_NO = drTemp["device_code_chr"].ToString().Trim(); lstEquip.Add(objTemp); } #endregion } strSQL = @"select a.device_model_id_chr, a.online_module_chr, a.online_dns_vchr, a.work_module_chr, a.work_auto_internal_vchr, a.pic_path_vchr, a.other_pram_vchr, a.dataanalysisdll_vchr, a.dataanalysisnamespace_vchr, b.deviceid_chr, b.devicename_vchr, b.device_code_chr, b.dataacquisitioncomputerip_chr, c.device_model_desc_vchr from t_bse_lis_interface_online a, t_bse_lis_device b, t_bse_lis_device_model c where a.device_model_id_chr = c.device_model_id_chr and b.device_model_id_chr = a.device_model_id_chr and b.end_date_dat is null and trim(b.dataacquisitioncomputerip_chr) = ?"; dtResult = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = strData_Acquisition_Computer_IP; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { #region clsLIS_Equip_DB_ConfigVO clsLIS_Equip_DB_ConfigVO objTempDB = null; for (int idx = 0; idx < dtResult.Rows.Count; idx++) { drTemp = dtResult.Rows[idx]; objTempDB = new clsLIS_Equip_DB_ConfigVO(); objTempDB.strLIS_Instrument_Model = drTemp["device_model_desc_vchr"].ToString().Trim(); objTempDB.strONLINE_MODULE_CHR = drTemp["online_module_chr"].ToString().Trim(); objTempDB.strONLINE_DNS_VCHR = drTemp["online_dns_vchr"].ToString().Trim(); objTempDB.strWORK_MODULE_CHR = drTemp["work_module_chr"].ToString().Trim(); objTempDB.strWORK_AUTO_INTERNAL_VCHR = drTemp["work_auto_internal_vchr"].ToString().Trim(); objTempDB.strPIC_PATH_VCHR = drTemp["pic_path_vchr"].ToString().Trim(); objTempDB.strOTHER_PRAM_VCHR = drTemp["other_pram_vchr"].ToString().Trim(); objTempDB.strData_Analysis_DLL = drTemp["dataanalysisdll_vchr"].ToString().Trim(); objTempDB.strData_Analysis_Namespace = drTemp["dataanalysisnamespace_vchr"].ToString().Trim(); objTempDB.strLIS_Instrument_ID = drTemp["deviceid_chr"].ToString().Trim(); objTempDB.strLIS_Instrument_Name = drTemp["devicename_vchr"].ToString().Trim(); objTempDB.strLIS_Instrument_NO = drTemp["device_code_chr"].ToString().Trim(); objTempDB.strData_Acquisition_Computer_IP = drTemp["dataacquisitioncomputerip_chr"].ToString().Trim(); lstEquip.Add(objTempDB); } #endregion } objConfig_List = lstEquip.ToArray(); } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; strData_Acquisition_Computer_IP = null; } return(lngRes); }
public long m_lngGetSampleCheckItems(string p_strCheckSampleNO, out string p_strCheckItemstring) { p_strCheckItemstring = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strCheckSampleNO)) { return(lngRes); } clsHRPTableService objHRPServ = null; try { string strSQL = @"select d.device_check_item_no_vchr from t_opr_lis_application a inner join t_opr_lis_app_check_item b on b.application_id_chr = a.application_id_chr inner join t_bse_lis_check_item_dev_item c on c.check_item_id_chr = b.check_item_id_chr inner join t_bse_lis_device_check_item d on d.device_check_item_id_chr = c.device_check_item_id_chr and d.device_model_id_chr = c.device_model_id_chr where a.pstatus_int = 2 and a.application_dat > ? and a.application_form_no_chr = ? order by d.device_check_item_no_vchr"; objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = DateTime.Now.Date; objDPArr[1].Value = p_strCheckSampleNO; DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { p_strCheckItemstring = ""; for (int idx = 0; idx < dtResult.Rows.Count; idx++) { p_strCheckItemstring += dtResult.Rows[idx]["device_check_item_no_vchr"].ToString().Trim(); } } } catch (Exception objEx) { lngRes = 0; p_strCheckItemstring = null; clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { p_strCheckSampleNO = null; objHRPServ = null; } return(lngRes); }
public long lngGetInstrumentSerialSetting(string strData_Acquisition_Computer_IP, out com.digitalwave.iCare.ValueObject.clsLIS_Equip_ConfigVO[] objConfig_List) { string strSQL = c_strGetInstrumentSerialSetting + " and lower(d.dataacquisitioncomputerip_chr) = lower(?)"; objConfig_List = null; long lngRes = 0; try { System.Data.DataTable objDT_LIS_Instrument_Info = null; IDataParameter[] objDPArr = null; com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService(); objHRPSvc.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].DbType = DbType.String; objDPArr[0].Value = strData_Acquisition_Computer_IP; lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref objDT_LIS_Instrument_Info, objDPArr); objHRPSvc.Dispose(); if (lngRes > 0) { int intRowCount = objDT_LIS_Instrument_Info.Rows.Count; if (intRowCount > 0) { objConfig_List = new com.digitalwave.iCare.ValueObject.clsLIS_Equip_ConfigVO[intRowCount]; clsLIS_Equip_ConfigVO objTemp = null; System.Data.DataRow objRow = null; for (int i = 0; i < intRowCount; i++) { objRow = objDT_LIS_Instrument_Info.Rows[i]; objTemp = new clsLIS_Equip_ConfigVO(); if (objRow["DEVICEID_CHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_ID = objRow["DEVICEID_CHR"].ToString().Trim(); } if (objRow["DEVICENAME_VCHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_Name = objRow["DEVICENAME_VCHR"].ToString().Trim(); } if (objRow["DEVICE_MODEL_DESC_VCHR"] != System.DBNull.Value) { objTemp.strLIS_Instrument_Model = objRow["DEVICE_MODEL_DESC_VCHR"].ToString().Trim(); } if (objRow["COMNO_CHR"] != System.DBNull.Value) { objTemp.strCOM_No = objRow["COMNO_CHR"].ToString().Trim(); } if (objRow["BAULRATE_CHR"] != System.DBNull.Value) { objTemp.strBaud_Rate = objRow["BAULRATE_CHR"].ToString().Trim(); } if (objRow["DATABIT_CHR"] != System.DBNull.Value) { objTemp.strData_Bit = objRow["DATABIT_CHR"].ToString().Trim(); } if (objRow["STOPBIT_CHR"] != System.DBNull.Value) { objTemp.strStop_Bit = objRow["STOPBIT_CHR"].ToString().Trim(); } if (objRow["PARITY_CHR"] != System.DBNull.Value) { objTemp.strParity = objRow["PARITY_CHR"].ToString().Trim(); } if (objRow["FLOWCONTROL_CHR"] != System.DBNull.Value) { objTemp.strFlow_Control = objRow["FLOWCONTROL_CHR"].ToString().Trim(); } if (objRow["RECEIVEBUFFER_CHR"] != System.DBNull.Value) { objTemp.strReceive_Buffer = objRow["RECEIVEBUFFER_CHR"].ToString().Trim(); } if (objRow["SENDBUFFER_CHR"] != System.DBNull.Value) { objTemp.strSend_Buffer = objRow["SENDBUFFER_CHR"].ToString().Trim(); } if (objRow["SENDCOMMAND_CHR"] != System.DBNull.Value) { objTemp.strSend_Command = objRow["SENDCOMMAND_CHR"].ToString(); } if (objRow["SENDCOMMANDINTERNAL_CHR"] != System.DBNull.Value) { objTemp.strSend_Command_Internal = objRow["SENDCOMMANDINTERNAL_CHR"].ToString().Trim(); } if (objRow["DATAANALYSISDLL_VCHR"] != System.DBNull.Value) { objTemp.strData_Analysis_DLL = objRow["DATAANALYSISDLL_VCHR"].ToString().Trim(); } if (objRow["DATAANALYSISNAMESPACE_VCHR"] != System.DBNull.Value) { objTemp.strData_Analysis_Namespace = objRow["DATAANALYSISNAMESPACE_VCHR"].ToString().Trim(); } if (objRow["DATAACQUISITIONCOMPUTERIP_CHR"] != System.DBNull.Value) { objTemp.strData_Acquisition_Computer_IP = objRow["DATAACQUISITIONCOMPUTERIP_CHR"].ToString().Trim(); } objTemp.strLIS_Instrument_NO = objRow["device_code_chr"].ToString().Trim(); objConfig_List[i] = objTemp; } } } } catch (System.Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } return(lngRes); }
/// <summary> /// 敏感率趋势报告 /// </summary> /// <param name="micname">细菌名称</param> /// <param name="p_dtDateFrom">日期</param> /// <param name="p_dtDateTO">日期</param> /// <param name="SamtNo">样本类型</param> /// <param name="DisNo">病区号</param> /// <param name="Sex">性别</param> /// <param name="AgeFrom">年龄</param> /// <param name="AgeTo">年龄</param> /// <param name="TestMethod">实验方法</param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetSensitiveTend(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string SamtNo, string DisNo, string Sex, string AgeFrom, string AgeTo, string TestMethod, string strTempAntiID, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; DateTime datefrom = DateTime.Parse(p_dtDateTO.AddMonths(-3).ToString("yyyy-MM-01 00:00:00")); string strSQL = @"select antiname, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end)else 0 end)as sen1, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num1, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end) else 0 end)as sen2, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num2, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end) else 0 end)as sen3, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num3, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end) else 0 end)as sen4, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num4 FROM t_atb_ResultMic a, t_atb_ResultExe b where "; if (!string.IsNullOrEmpty(strTempAntiID)) { strSQL += " a.antiid='" + strTempAntiID + "' and "; } strSQL += @" a.reqno=b.reqno and a.exeno=b.exeno and b.exedate between ? and ? and b.micname=? and a.reqno in( select t2.reqno from t_atb_AntiResultBill t2 where t2.samno in( select trim(t3.device_sampleid_chr) from t_opr_lis_device_relation t3 ,t_opr_lis_app_sample t4,t_opr_lis_application t5 where t3.deviceid_chr='000032' and t3.sample_id_chr=t4.sample_id_chr and t4.application_id_chr=t5.application_id_chr "; clsHRPTableService objHRPServ = null; try { IDataParameter[] objDPArr = null; if (string.IsNullOrEmpty(SamtNo) && string.IsNullOrEmpty(DisNo) && string.IsNullOrEmpty(Sex) && string.IsNullOrEmpty(AgeFrom) && string.IsNullOrEmpty(AgeTo) && string.IsNullOrEmpty(TestMethod)) { strSQL = @"select antiname, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end)else 0 end)as sen1, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num1, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end) else 0 end)as sen2, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num2, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end) else 0 end)as sen3, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num3, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then (case when a.micexplain='S' then 1 else 0 end) else 0 end)as sen4, sum(case when trunc(b.exedate, 'mm') = trunc(?, 'mm') then 1 else 0 end)as num4 FROM t_atb_ResultMic a, t_atb_ResultExe b where "; if (!string.IsNullOrEmpty(strTempAntiID)) { strSQL += " a.antiid='" + strTempAntiID + "' and "; } strSQL += @" a.reqno=b.reqno and a.exeno=b.exeno and b.exedate between ? and ? and b.micname=? group by antiname order by antiname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(11, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = p_dtDateTO.AddMonths(-3);; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateTO.AddMonths(-3);; objDPArr[2].DbType = DbType.DateTime; objDPArr[2].Value = p_dtDateTO.AddMonths(-2); objDPArr[3].DbType = DbType.DateTime; objDPArr[3].Value = p_dtDateTO.AddMonths(-2); objDPArr[4].DbType = DbType.DateTime; objDPArr[4].Value = p_dtDateTO.AddMonths(-1); objDPArr[5].DbType = DbType.DateTime; objDPArr[5].Value = p_dtDateTO.AddMonths(-1); objDPArr[6].DbType = DbType.DateTime; objDPArr[6].Value = p_dtDateTO; objDPArr[7].DbType = DbType.DateTime; objDPArr[7].Value = p_dtDateTO; objDPArr[8].DbType = DbType.DateTime; objDPArr[8].Value = datefrom; objDPArr[9].DbType = DbType.DateTime; objDPArr[9].Value = p_dtDateTO; objDPArr[10].DbType = DbType.String; objDPArr[10].Value = micname; } else { ArrayList arrlParm = new ArrayList(); arrlParm.Add(datefrom); arrlParm.Add(datefrom); arrlParm.Add(datefrom.AddMonths(1)); arrlParm.Add(datefrom.AddMonths(1)); arrlParm.Add(datefrom.AddMonths(2)); arrlParm.Add(datefrom.AddMonths(2)); arrlParm.Add(p_dtDateTO); arrlParm.Add(p_dtDateTO); arrlParm.Add(datefrom); arrlParm.Add(p_dtDateTO); arrlParm.Add(micname); if (!string.IsNullOrEmpty(Sex)) { strSQL += " and trim(t5.sex_chr)=? "; arrlParm.Add(Sex); } if (!string.IsNullOrEmpty(AgeFrom) && !string.IsNullOrEmpty(AgeTo)) { strSQL += " and substr(regexp_replace(t5.age_chr,'[^0-9]'),1,3) between ? and ? "; arrlParm.Add(AgeFrom); arrlParm.Add(AgeTo); } if (!string.IsNullOrEmpty(DisNo)) { strSQL += " and t5.patient_type_id_chr=? "; arrlParm.Add(DisNo); } if (!string.IsNullOrEmpty(SamtNo)) { strSQL += " and t5.sample_type_vchr=? "; arrlParm.Add(SamtNo); } strSQL += "))"; if (!string.IsNullOrEmpty(TestMethod) && !TestMethod.Contains("ALL")) { strSQL += " and a.testno=? "; arrlParm.Add(TestMethod); } strSQL += " group by antiname order by antiname "; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(arrlParm.Count, out objDPArr); for (int i = 0; i < arrlParm.Count; i++) { objDPArr[i].Value = arrlParm[i]; } } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
/// <summary> /// 累计MIC /// </summary> /// <param name="micname">细菌名称</param> /// <param name="p_dtDateFrom">日期</param> /// <param name="p_dtDateTO">日期</param> /// <param name="SamtNo">样本类型</param> /// <param name="DisNo">病区号</param> /// <param name="Sex">性别</param> /// <param name="AgeFrom">年龄</param> /// <param name="AgeTo">年龄</param> /// <param name="TestMethod">实验方法</param> /// <param name="dtbResult"></param> /// <returns></returns> public long lngGetMicCumulative(string micname, DateTime p_dtDateFrom, DateTime p_dtDateTO, string SamtNo, string DisNo, string Sex, string AgeFrom, string AgeTo, string TestMethod, string strTempAntiID, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strSQL = @"select antiname,count(*) as tested, sum(case when instr(a.resshow,'0.25')>0 then 1 else 0 end) as p_2, sum(case when instr(a.resshow,'0.5')>0 then 1 else 0 end)as p_3, sum(case when a.resshow='≤1' then 1 else(case when (substr(a.resshow,0,2)='1<') then 1 else 0 end) end) as p_4, sum(case when substr(a.resshow,0,2)='≤2' then 1 else(case when substr(a.resshow,0,2)='2<' then 1 else 0 end) end) as p_5, sum(case when substr(a.resshow,0,2)='≤4' then 1 else(case when substr(a.resshow,0,2)='4<' then 1 else 0 end ) end) as p_6, sum(case when substr(a.resshow,0,2)='≤8' then 1 else(case when substr(a.resshow,0,2)='8<' then 1 else 0 end ) end) as p_7, sum(case when instr(substr(a.resshow,0,3),'16')>0 then 1 else 0 end) as p_8, sum(case when instr(substr(a.resshow,0,3),'32')>0 then 1 else 0 end) as p_9, sum(case when instr(substr(a.resshow,0,3),'64')>0 then 1 else 0 end) as p_10, sum(case when instr(a.resshow,0,6,'128')>0 then 1 else 0 end) as p_11, sum(case when instr(a.resshow,0,6,'256')>0 then 1 else 0 end) as p_12 FROM t_atb_ResultMic a, t_atb_ResultExe b where a.reqno=b.reqno and a.exeno=b.exeno "; if (!string.IsNullOrEmpty(strTempAntiID)) { strSQL += " and a.antiid='" + strTempAntiID + "' "; } strSQL += @" and b.exedate between ? and ? and b.micname=? and b.reqno in( select t2.reqno from t_atb_AntiResultBill t2 where t2.samno in( select trim(t3.device_sampleid_chr) from t_opr_lis_device_relation t3 ,t_opr_lis_app_sample t4,t_opr_lis_application t5 where t3.deviceid_chr='000032' and t3.sample_id_chr=t4.sample_id_chr and t4.application_id_chr=t5.application_id_chr "; clsHRPTableService objHRPServ = null; try { IDataParameter[] objDPArr = null; if (string.IsNullOrEmpty(SamtNo) && string.IsNullOrEmpty(DisNo) && string.IsNullOrEmpty(Sex) && string.IsNullOrEmpty(AgeFrom) && string.IsNullOrEmpty(AgeTo) && string.IsNullOrEmpty(TestMethod)) { strSQL = @"select antiname,count(*) as tested, sum(case when instr(a.resshow,'0.25')>0 then 1 else 0 end) as p_2, sum(case when instr(a.resshow,'0.5')>0 then 1 else 0 end)as p_3, sum(case when a.resshow='≤1' then 1 else(case when (substr(a.resshow,0,2)='1<') then 1 else 0 end) end) as p_4, sum(case when substr(a.resshow,0,2)='≤2' then 1 else(case when substr(a.resshow,0,2)='2<' then 1 else 0 end) end) as p_5, sum(case when substr(a.resshow,0,2)='≤4' then 1 else(case when substr(a.resshow,0,2)='4<' then 1 else 0 end ) end) as p_6, sum(case when substr(a.resshow,0,2)='≤8' then 1 else(case when substr(a.resshow,0,2)='8<' then 1 else 0 end ) end) as p_7, sum(case when instr(substr(a.resshow,0,3),'16')>0 then 1 else 0 end) as p_8, sum(case when instr(substr(a.resshow,0,3),'32')>0 then 1 else 0 end) as p_9, sum(case when instr(substr(a.resshow,0,3),'64')>0 then 1 else 0 end) as p_10, sum(case when instr(a.resshow,0,6,'128')>0 then 1 else 0 end) as p_11, sum(case when instr(a.resshow,0,6,'256')>0 then 1 else 0 end) as p_12 FROM t_atb_ResultMic a, t_atb_ResultExe b where a.reqno=b.reqno and a.exeno=b.exeno "; if (!string.IsNullOrEmpty(strTempAntiID)) { strSQL += " and a.antiid='" + strTempAntiID + "' "; } strSQL += @" and b.exedate between ? and ? and b.micname=? group by antiname order by antiname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(3, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = p_dtDateFrom; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateTO; objDPArr[2].DbType = DbType.String; objDPArr[2].Value = micname; } else { ArrayList arrlParm = new ArrayList(); arrlParm.Add(p_dtDateFrom); arrlParm.Add(p_dtDateTO); arrlParm.Add(micname); if (!string.IsNullOrEmpty(Sex)) { strSQL += " and trim(t5.sex_chr)=? "; arrlParm.Add(Sex); } if (!string.IsNullOrEmpty(AgeFrom) && !string.IsNullOrEmpty(AgeTo)) { strSQL += " and substr(regexp_replace(t5.age_chr,'[^0-9]'),1,3) between ? and ? "; arrlParm.Add(AgeFrom); arrlParm.Add(AgeTo); } if (!string.IsNullOrEmpty(DisNo)) { strSQL += " and t5.patient_type_id_chr=? "; arrlParm.Add(DisNo); } if (!string.IsNullOrEmpty(SamtNo)) { strSQL += " and t5.sample_type_vchr=? "; arrlParm.Add(SamtNo); } strSQL += "))"; if (!string.IsNullOrEmpty(TestMethod) && !TestMethod.Contains("ALL")) { strSQL += " and a.testno=? "; arrlParm.Add(TestMethod); } strSQL += "group by antiname order by antiname"; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(arrlParm.Count, out objDPArr); for (int i = 0; i < arrlParm.Count; i++) { objDPArr[i].Value = arrlParm[i]; } } lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
public long m_lngQueryLISAppDetialByDate(string p_strStartDate, string p_strEndDate, out clsLISApplDetial_VO[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strStartDate) || string.IsNullOrEmpty(p_strEndDate)) { return(lngRes); } clsHRPTableService objHRPServ = null; //Hashtable objHsTable = new Hashtable(); try { string strSQL = @"select '' organcode,--organcode seq_ygyylis_idsub.nextval sublist_seq, t.application_id_chr observationid, --检验单号 '*' observationsub_id, --检验项目代码t1.apply_unit_id_chr t.check_item_id_chr observationcode, --检验子项目代码 t2.rptno_chr observationname, --检出子项目名称 t2.check_item_english_name_vchr observationenname, --检出子项目名称(英文) t.result_vchr observationvalue --检出结果 from (select a.modify_dat,a.result_vchr,a1.application_id_chr,a1.sample_id_chr,a.groupid_chr,a.check_item_id_chr,a.summary_vchr,a.abnormal_flag_chr,a.deviceid_chr from t_opr_lis_check_result a left join t_opr_lis_app_sample a1 on a.sample_id_chr = a1.sample_id_chr and a.groupid_chr = a1.sample_group_id_chr where a.modify_dat between ? and ? and a.status_int = 1) t left join t_bse_lis_check_item t2 on t2.check_item_id_chr = t.check_item_id_chr and t2.resulttype_chr <> 1"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = Convert.ToDateTime(p_strStartDate); objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strEndDate); DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ.Dispose(); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; int iRowCount = dtResult.Rows.Count; clsLISApplDetial_VO objTemp = null; p_objResultArr = new clsLISApplDetial_VO[iRowCount]; List <clsLISApplDetial_VO> objList = new List <clsLISApplDetial_VO>(); for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISApplDetial_VO(); objTemp.m_strOBSERVATIONID = drTemp["observationid"].ToString().Trim(); objTemp.m_strOBSERVATIONSUB_ID = drTemp["observationsub_id"].ToString().Trim(); objTemp.m_strOBSERVATIONCODE = drTemp["observationcode"].ToString().Trim(); objTemp.m_strOBSERVATIONNAME = drTemp["observationname"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONNAME)) { objTemp.m_strOBSERVATIONNAME = "*"; } objTemp.m_strOBSERVATIONENNAME = drTemp["observationenname"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONENNAME)) { objTemp.m_strOBSERVATIONENNAME = "*"; } objTemp.m_strOBSERVATIONVALUE = drTemp["observationvalue"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONVALUE)) { objTemp.m_strOBSERVATIONVALUE = "*"; } //objTemp.m_strSUBLIST_SEQ = drTemp["application_id_chr"].ToString().Trim() + "-" + objTemp.m_strOBSERVATIONSUB_ID + "-" + objTemp.m_strOBSERVATIONCODE; //临时传 objTemp.m_strSUBLIST_SEQ = drTemp["sublist_seq"].ToString().Trim(); try { //objHsTable.Add(objTemp.m_strOBSERVATIONID + objTemp.m_strOBSERVATIONSUB_ID + objTemp.m_strOBSERVATIONCODE, ""); objList.Add(objTemp); } catch { } } p_objResultArr = objList.ToArray(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; p_strEndDate = null; p_strStartDate = null; } return(lngRes); }
public long lngGetWorkStatstic(int p_intQueryType, DateTime p_dtDateFrom, DateTime p_dtDateTO, int p_strQuery, string p_strCondition, out DataTable dtbResult) { dtbResult = null; long lngRes = 0; string strDateTime = "dc.confirm_dat"; if (p_intQueryType == 1) { strDateTime = "db.application_dat"; } string strSQL = @"select b.check_category_desc_vchr, a.apply_unit_name_vchr, a.price_num, c.itemcount, d.appcount from t_aid_lis_apply_unit a, t_bse_lis_check_category b, (select ca.apply_unit_id_chr, count(ca.check_item_id_chr) as itemcount from t_aid_lis_apply_unit_detail ca group by ca.apply_unit_id_chr) c, (select da.apply_unit_id_chr, count(db.application_id_chr) as appcount from t_opr_lis_app_apply_unit da, t_opr_lis_application db, t_opr_lis_app_report dc where da.application_id_chr = db.application_id_chr and db.application_id_chr = dc.application_id_chr and db.pstatus_int = 2 "; if (p_intQueryType == 0) { strSQL += @" and dc.status_int = 2 "; } else { strSQL += @" and dc.status_int >= 1 "; } switch (p_strQuery) { case 0: strSQL += @" and db.appl_deptid_chr = ? and " + strDateTime + @" between ? and ? group by da.apply_unit_id_chr) d where a.check_category_id_chr = b.check_category_id_chr and a.apply_unit_id_chr = c.apply_unit_id_chr and a.apply_unit_id_chr = d.apply_unit_id_chr"; break; case 1: strSQL += @" and db.appl_empid_chr = ? and " + strDateTime + @" between ? and ? group by da.apply_unit_id_chr) d where a.check_category_id_chr = b.check_category_id_chr and a.apply_unit_id_chr = c.apply_unit_id_chr and a.apply_unit_id_chr = d.apply_unit_id_chr"; break; case 2: strSQL += @" and dc.reportor_id_chr = ? and " + strDateTime + @" between ? and ? group by da.apply_unit_id_chr) d where a.check_category_id_chr = b.check_category_id_chr and a.apply_unit_id_chr = c.apply_unit_id_chr and a.apply_unit_id_chr = d.apply_unit_id_chr"; break; case 3: strSQL += @" and " + strDateTime + @" between ? and ? group by da.apply_unit_id_chr) d where a.check_category_id_chr = b.check_category_id_chr and a.apply_unit_id_chr = c.apply_unit_id_chr and a.apply_unit_id_chr = d.apply_unit_id_chr"; break; default: break; } clsHRPTableService objHRPServ = null; try { IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); if (p_strQuery == 3) { objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = p_dtDateFrom; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateTO; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); } else { objHRPServ.CreateDatabaseParameter(3, out objDPArr); objDPArr[0].Value = p_strCondition; objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = p_dtDateFrom; objDPArr[2].DbType = DbType.DateTime; objDPArr[2].Value = p_dtDateTO; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtbResult, objDPArr); objHRPServ.Dispose(); } DataColumn dcTotalItems = new DataColumn("totalitem", typeof(decimal)); dcTotalItems.Expression = "itemcount * appcount"; DataColumn dcTotalMoney = new DataColumn("totalmoney", typeof(decimal)); dcTotalMoney.Expression = "appcount * price_num"; DataColumn[] dcArr = new DataColumn[] { dcTotalItems, dcTotalMoney }; dtbResult.Columns.AddRange(dcArr); dtbResult.DefaultView.Sort = "check_category_desc_vchr, apply_unit_name_vchr"; dtbResult = dtbResult.DefaultView.ToTable(); } catch (Exception objEx) { lngRes = 0; clsLogText objLogger = new clsLogText(); bool blnRes = objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; } return(lngRes); }
public long m_lngQueryLISAppByDate(string p_strStartDate, string p_strEndDate, out clsLISAppl_VO[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strStartDate) || string.IsNullOrEmpty(p_strEndDate)) { return(lngRes); } clsHRPTableService objHRPServ = null; //Hashtable objHsTable = new Hashtable(); try { string strSQL = @"select '' organcode, t.application_id_chr observationid,--检验单号 patientcardid_chr visitno, --就诊流水号 '' inhosseqno,--住院流水号 t3.paytypeid_chr kind, --病人性质代码 t1.sample_type_id_chr proveswatchcode,--检验样本编号 t1.sample_type_vchr proveswatchname, --检验样本名称 t1.sample_type_id_chr provetype, --检验类别代码 t.modify_dat observationdatetime,--检验日期 t1.application_dat createobservationdatetime,--开单时间 t1.appl_empid_chr createcliniciancode, --开单医生代码 f_getempnamebyid(t1.appl_empid_chr) createclinicianname, --开单医生姓名 t2.operator_id_chr observationoptcode, --检验人员代码 f_getempnamebyid(t2.operator_id_chr) observationoptname, --检验人员姓名 '' observationway, --检验方法 t1.appl_deptid_chr observationdeptcode, --开单科室代码 f_getdeptnamebyid(t1.appl_deptid_chr) observationdeptname, --开单科室名称 '' observationoptdeptcode, --执行科室代码 '' observationoptdeptname, --执行科室名称 '0' flag, --作废标志代码 t4.registerid_chr, t5.attarelaid_chr, --对应流水号 t5.sourceitemid_vchr, --源id (门诊) = 处方id; (住院) = 医嘱id t5.sysfrom_int --来源 1=门诊;2=住院 from (select a.modify_dat,a1.application_id_chr,a1.sample_id_chr from t_opr_lis_check_result a left join t_opr_lis_app_sample a1 on a.sample_id_chr = a1.sample_id_chr and a.groupid_chr = a1.sample_group_id_chr where a.modify_dat between ? and ? and a.status_int = 1) t left join t_opr_lis_application t1 on t.application_id_chr = t1.application_id_chr and t1.pstatus_int > 0 and t1.orderunitrelation_vchr in null left join t_opr_lis_app_report t2 on t1.application_id_chr = t2.application_id_chr and t2.status_int = 2 left outer join t_bse_patient t3 on t1.patientid_chr = t3.patientid_chr left outer join (select b.patientid_chr,max(b.registerid_chr) as registerid_chr from t_opr_bih_register b group by b.patientid_chr) t4 on t4.patientid_chr = t3.patientid_chr left outer join (select d.attarelaid_chr,d.sysfrom_int,d.sourceitemid_vchr,d.attachid_vchr from t_opr_attachrelation d where d.attarelaid_chr in (select max(c.attarelaid_chr) from t_opr_attachrelation c group by c.attachid_vchr)) t5 on t.application_id_chr = t5.attachid_vchr"; IDataParameter[] objDPArr = null; objHRPServ = new clsHRPTableService(); objHRPServ.CreateDatabaseParameter(2, out objDPArr); objDPArr[0].DbType = DbType.DateTime; objDPArr[0].Value = Convert.ToDateTime(p_strStartDate); objDPArr[1].DbType = DbType.DateTime; objDPArr[1].Value = Convert.ToDateTime(p_strEndDate); List <clsLISAppl_VO> objList = new List <clsLISAppl_VO>(); DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ.Dispose(); if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; int iRowCount = dtResult.Rows.Count; clsLISAppl_VO objTemp = null; p_objResultArr = new clsLISAppl_VO[iRowCount]; for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISAppl_VO(); objTemp.m_strOBSERVATIONID = drTemp["observationid"].ToString().Trim(); if (drTemp["sysfrom_int"].ToString().Trim() == "1") { objTemp.m_strVISITNO = drTemp["sourceitemid_vchr"].ToString().Trim(); } if (drTemp["sysfrom_int"].ToString().Trim() == "2") { objTemp.m_strINHOSSEQNO = drTemp["registerid_chr"].ToString().Trim(); } objTemp.m_strKIND = clsDataUpload_Svc.m_strConvertValue("kind", drTemp["paytypeid_chr"].ToString().Trim(), ""); objTemp.m_strPROVESWATCHCODE = drTemp["proveswatchcode"].ToString().Trim(); objTemp.m_strPROVESWATCHNAME = drTemp["proveswatchname"].ToString().Trim(); objTemp.m_strPROVETYPE = drTemp["proveswatchcode"].ToString().Trim(); objTemp.m_strOBSERVATIONDATETIM = Convert.ToDateTime(drTemp["modify_dat"]).ToString("yyyy-MM-dd HH:mm:ss"); objTemp.m_strCREATEOBSERVATIONDATETIME = drTemp["createobservationdatetime"] != DBNull.Value ? Convert.ToDateTime(drTemp["createobservationdatetime"]).ToString("yyyy-MM-dd HH:mm:ss") : ""; objTemp.m_strCREATECLINICIANCODE = drTemp["createcliniciancode"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strCREATECLINICIANCODE)) { objTemp.m_strCREATECLINICIANCODE = "*"; } objTemp.m_strCREATECLINICIANNAME = drTemp["createclinicianname"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strCREATECLINICIANNAME)) { objTemp.m_strCREATECLINICIANNAME = "*"; } objTemp.m_strOBSERVATIONOPTCODE = drTemp["observationoptcode"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTNAME = drTemp["observationoptname"].ToString().Trim(); objTemp.m_strOBSERVATIONWAY = drTemp["checkmonth"].ToString().Trim(); objTemp.m_strOBSERVATIONDEPTCODE = drTemp["observationdeptcode"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONDEPTCODE)) { objTemp.m_strOBSERVATIONDEPTCODE = "*"; } objTemp.m_strOBSERVATIONDEPTNAME = drTemp["observationdeptname"].ToString().Trim(); objTemp.m_strOBSERVATIONOPTDEPTCODE = "*"; objTemp.m_strOBSERVATIONOPTDEPTNAME = "*"; objTemp.m_strFLAG = drTemp["flag"].ToString().Trim(); if (string.IsNullOrEmpty(objTemp.m_strOBSERVATIONDEPTNAME)) { objTemp.m_strOBSERVATIONDEPTNAME = "*"; } try { //objHsTable.Add(objTemp.m_strVISITNO + objTemp.m_strINHOSSEQNO + objTemp.m_strOBSERVATIONID, ""); objList.Add(objTemp); } catch { } } p_objResultArr = objList.ToArray(); } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); } finally { objHRPServ = null; p_strEndDate = null; p_strStartDate = null; //objHsTable.Clear(); } return(lngRes); }
public long m_lngGetDeviceQCCheckItemByID(System.Security.Principal.IPrincipal p_objPrincipal, string p_strDeviceID, out clsLISCheckItemNode[] p_objResultArr) { p_objResultArr = null; long lngRes = 0; if (string.IsNullOrEmpty(p_strDeviceID)) { return(lngRes); } com.digitalwave.security.clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService(); lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCLisServ", "m_lngGetDeviceQCCheckItemByID"); objPrivilege = null; if (lngRes <= 0) { return(lngRes); } try { string strSQL = @"select a.check_item_id_chr, a.rptno_chr from t_bse_lis_check_item a inner join t_bse_lis_check_item_dev_item b on b.check_item_id_chr = a.check_item_id_chr inner join t_bse_lis_device_check_item c on c.device_check_item_id_chr = b.device_check_item_id_chr and c.device_model_id_chr = b.device_model_id_chr and c.is_qc_item_int = 1 inner join t_bse_lis_device d on d.device_model_id_chr = c.device_model_id_chr and d.deviceid_chr = ?"; clsHRPTableService objHRPServ = new clsHRPTableService(); IDataParameter[] objDPArr = null; objHRPServ.CreateDatabaseParameter(1, out objDPArr); objDPArr[0].Value = p_strDeviceID; DataTable dtResult = null; lngRes = objHRPServ.lngGetDataTableWithParameters(strSQL, ref dtResult, objDPArr); objHRPServ = null; objDPArr = null; if (lngRes > 0 && dtResult != null && dtResult.Rows.Count > 0) { DataRow drTemp = null; clsLISCheckItemNode objTemp = null; int iRowCount = dtResult.Rows.Count; p_objResultArr = new clsLISCheckItemNode[iRowCount]; for (int iRow = 0; iRow < iRowCount; iRow++) { drTemp = dtResult.Rows[iRow]; objTemp = new clsLISCheckItemNode(); objTemp.strID = drTemp["check_item_id_chr"].ToString().Trim(); objTemp.strName = drTemp["rptno_chr"].ToString().Trim(); p_objResultArr[iRow] = objTemp; } } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, true); objLogger = null; } finally { p_strDeviceID = null; } return(lngRes); }
private void m_mthGetBarcodeParm() { if (!m_blnHasInitBarcodeParm) { try { clsLisMainSmp.s_obj.m_lngGetSysParm("6006", out m_strBarcodeParm); m_blnHasInitBarcodeParm = true; if (!string.IsNullOrEmpty(m_strBarcodeParm)) { switch (m_strBarcodeParm) { case "Code39": m_BarcodeStyle = BarcodeXStyle.Code39; break; case "Code39Ext": m_BarcodeStyle = BarcodeXStyle.Code39Ext; break; case "Code128": m_BarcodeStyle = BarcodeXStyle.Code128; break; case "Code128A": m_BarcodeStyle = BarcodeXStyle.Code128A; break; case "Code128B": m_BarcodeStyle = BarcodeXStyle.Code128B; break; case "Code128C": m_BarcodeStyle = BarcodeXStyle.Code128C; break; case "ENA128": m_BarcodeStyle = BarcodeXStyle.EAN_128; break; case "ISSN": m_BarcodeStyle = BarcodeXStyle.ISSN; break; case "ISBN": m_BarcodeStyle = BarcodeXStyle.ISBN; break; case "Codebar": m_BarcodeStyle = BarcodeXStyle.Codebar; break; case "Custom": m_BarcodeStyle = BarcodeXStyle.Custom; break; default: m_BarcodeStyle = BarcodeXStyle.EAN_128; break; } } } catch (Exception objEx) { clsLogText objLogger = new clsLogText(); objLogger.LogDetailError(objEx, false); objLogger = null; m_blnHasInitBarcodeParm = false; } } }