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