/// <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;
}
}
}
