/// <summary>
/// 查找质控样本结果数据
/// </summary>
/// <param name="p_intQCBatchSeqArr"></param>
/// <param name="p_datBegin"></param>
/// <param name="p_datEnd"></param>
/// <param name="p_status"></param>
/// <param name="p_objQCReportArr"></param>
/// <returns></returns>
public long m_lngFind(int[] p_intQCBatchSeqArr, DateTime p_datBegin,
DateTime p_datEnd, enmQCStatus p_status, out clsLisQCReportVO[] p_objQCReportArr)
{
long lngRes = 0;
p_objQCReportArr = null;
try
{
lngRes = m_objSvc.m_lngFind(m_objPrincipal, p_intQCBatchSeqArr, p_datBegin,
p_datEnd, p_status, out p_objQCReportArr);
}
catch { lngRes = 0; }
return(lngRes);
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int p_intQCBatchSeq, DateTime p_datBegin, DateTime p_datEnd, enmQCStatus p_status, out clsLisQCReportVO[] p_objQCReportArr)
{
long lngRes = 0;
p_objQCReportArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCBatchConcentrationSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
try
{
string strSQL = m_strFindExtSql;
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objODPArr = null;
if (p_status == enmQCStatus.Delete || p_status == enmQCStatus.Natrural)
{
objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
(int)p_status, p_intQCBatchSeq, p_datBegin, p_datEnd);
}
else
{
strSQL = strSQL.Replace("AND t1.status_int = ?", "AND 3 = ?");
objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
3, p_intQCBatchSeq, p_datBegin, p_datEnd);
}
DataTable dtbResult = null;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objODPArr);
objHRPSvc.Dispose();
if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objQCReportArr = new clsLisQCReportVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objQCReportArr.Length; i++)
{
p_objQCReportArr[i] = new clsLisQCReportVO();
this.ConstructVO(dtbResult.Rows[i], ref p_objQCReportArr[i]);
p_objQCReportArr[i].m_strReportorName = dtbResult.Rows[i]["reportor_name"].ToString().Trim();
}
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}
public long m_lngFindQCReport(int p_intQCBatchSeq, DateTime p_datBegin, DateTime p_datEnd, enmQCStatus p_status, out clsLisQCReportVO[] p_objQCReportArr)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCReport(this.objPrincipal, p_intQCBatchSeq, p_datBegin, p_datEnd, p_status, out p_objQCReportArr));
}
}
public long m_lngFind(System.Security.Principal.IPrincipal p_objPrincipal, int[] p_intQCBatchSeqArr, DateTime p_datBegin, DateTime p_datEnd, enmQCStatus p_status, out clsLisQCReportVO[] p_objQCReportArr)
{
long lngRes = 0;
p_objQCReportArr = null;
if (p_intQCBatchSeqArr == null || p_intQCBatchSeqArr.Length <= 0)
{
return(lngRes);
}
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCBatchConcentrationSvc", "m_lngFind");
if (lngRes <= 0)
{
return(-1);
}
try
{
string strSQL = @"select t1.qcreport_seq_int,
t1.qcbatch_seq_int,
t1.qcstatus_int,
t1.unmatchedrule_vchr,
t1.reason_vchr,
t1.process_vchr,
t1.summary_vchr,
t1.report_dat,
t1.reportor_id_chr,
t1.status_int,
t1.modify_dat,
t2.lastname_vchr as reportor_name
from t_opr_lis_qcreport t1, t_bse_employee t2
where t1.reportor_id_chr = t2.empid_chr(+)
and t1.status_int = ?
and t1.report_dat >= ?
and t1.report_dat <= ?
and (t1.qcbatch_seq_int = ?";
ArrayList arParams = new ArrayList();
if (p_status == enmQCStatus.Delete || p_status == enmQCStatus.Natrural)
{
arParams.Add((int)p_status);
}
else
{
strSQL = strSQL.Replace("and t1.status_int = ?", "and 3 = ?");
arParams.Add(3);
}
arParams.Add(p_datBegin);
arParams.Add(p_datEnd);
arParams.AddRange(p_intQCBatchSeqArr);
for (int index = 1; index < p_intQCBatchSeqArr.Length; index++)
{
strSQL += " or t1.qcreport_seq_int = ?";
}
strSQL += ")";
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
System.Data.IDataParameter[] objODPArr = null;
objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(arParams.ToArray());
DataTable dtbResult = null;
lngRes = 0;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objODPArr);
objHRPSvc.Dispose();
if (lngRes == 1 && dtbResult != null && dtbResult.Rows.Count > 0)
{
p_objQCReportArr = new clsLisQCReportVO[dtbResult.Rows.Count];
for (int i = 0; i < p_objQCReportArr.Length; i++)
{
p_objQCReportArr[i] = new clsLisQCReportVO();
this.ConstructVO(dtbResult.Rows[i], ref p_objQCReportArr[i]);
p_objQCReportArr[i].m_strReportorName = dtbResult.Rows[i]["reportor_name"].ToString().Trim();
}
}
}
catch (Exception objEx)
{
new clsLogText().LogError(objEx);
}
return(lngRes);
}