internal long m_lngInsertQCData(clsLisQCDataVO p_objQCData, out int p_intSeq)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngInsertQCData(this.objPrincipal, p_objQCData, out p_intSeq));
}
}
internal long m_lngSaveAllQCData(clsLisQCDataVO[] p_objInsertArr, clsLisQCDataVO[] p_objUpdateArr, int[] p_intDelArr, out int[] p_intISeqArr)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngSaveAllQCData(this.objPrincipal, p_objInsertArr, p_objUpdateArr, p_intDelArr, out p_intISeqArr));
}
}
public long m_lngFindQCData(out clsLisQCDataVO[] p_objResultArr, int p_intQCBatchSeq, DateTime p_datBegin, DateTime p_datEnd)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCData(this.objPrincipal, out p_objResultArr, p_intQCBatchSeq, p_datBegin, p_datEnd));
}
}
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_lngFindQCConcentration(int p_intQCBatchSeq, out clsLisQCConcentrationVO[] p_objResultArr)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCConcentration(this.objPrincipal, p_intQCBatchSeq, out p_objResultArr));
}
}
public long m_lngFindQCBatch(int p_intSeq, bool p_blnExtFind, out clsLisQCBatchVO p_objQCBatch)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCBatch(this.objPrincipal, p_intSeq, p_blnExtFind, out p_objQCBatch));
}
}
public clsTmdQCBatchSmp()
{
m_objSvc = (clsTmdQCBatchSvc)
com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(
typeof(clsTmdQCBatchSvc));
m_objPrincipal = new clsGetPrincipal().m_objPrincipal;
}
public long m_lngReceiveDeviceQCData(string p_strStartDat, string p_strEndDat, int[] p_intBatchSeqArr, out clsLisQCDataVO[] p_objQCDataArr)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngReceiveDeviceQCData(this.objPrincipal, p_strStartDat, p_strEndDat, p_intBatchSeqArr, out p_objQCDataArr));
}
}
public long m_lngUpdateSDXCV(clsLisQCConcentrationVO p_objQCConcentration)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngUpdateSDXCV(this.objPrincipal, p_objQCConcentration));
}
}
/// <summary>
/// m_lngInsertBatchSet
/// </summary>
/// <param name="p_lstResult"></param>
/// <param name="p_lstContion"></param>
/// <returns></returns>
public long m_lngInsertBatchSet(List <clsLisQCBatchVO> p_lstResult, List <clsLisQCConcentrationVO> p_lstContion)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngInsertBatchSet(this.objPrincipal, p_lstResult, p_lstContion));
}
}
/// <summary>
/// m_lngUpdateQCBatch
/// </summary>
/// <param name="QCBatch"></param>
/// <returns></returns>
public long m_lngUpdateQCBatch(clsLisQCBatchVO QCBatch)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngUpdateQCBatch(this.objPrincipal, QCBatch));
}
}
/// <summary>
/// m_lngDeleteQCBatch
/// </summary>
/// <param name="p_intSeq"></param>
/// <returns></returns>
public long m_lngDeleteQCBatch(int p_intSeq)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngDeleteQCBatch(this.objPrincipal, p_intSeq));
}
}
/// <summary>
/// m_lngInsertQCBatch
/// </summary>
/// <param name="p_objQCBatch"></param>
/// <param name="p_intSeq"></param>
/// <returns></returns>
public long m_lngInsertQCBatch(clsLisQCBatchVO p_objQCBatch, out int p_intSeq)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngInsertQCBatch(this.objPrincipal, p_objQCBatch, out p_intSeq));
}
}
/// <summary>
/// m_lngInsertQCBatchByArr
/// </summary>
/// <param name="p_objQCBatchArr"></param>
/// <param name="p_intSeqArr"></param>
/// <returns></returns>
public long m_lngInsertQCBatchByArr(clsLisQCBatchVO[] p_objQCBatchArr, out int[] p_intSeqArr)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngInsertQCBatchByArr(this.objPrincipal, p_objQCBatchArr, out p_intSeqArr));
}
}
/// <summary>
/// m_lngFindQCRule
/// </summary>
/// <param name="p_objResultArr"></param>
/// <returns></returns>
public long m_lngFindQCRule(out clsLisQCRuleVO[] p_objResultArr)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCRule(this.objPrincipal, out p_objResultArr));
}
}
/// <summary>
/// m_lngFindQCRule
/// </summary>
/// <param name="p_intSeq"></param>
/// <param name="p_objRule"></param>
/// <returns></returns>
public long m_lngFindQCRule(int p_intSeq, out clsLisQCRuleVO p_objRule)
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngFindQCRule(this.objPrincipal, p_intSeq, out p_objRule));
}
}
/// <summary>
///
/// </summary>
/// <param name="p_intBatchSeq"></param>
/// <param name="p_strSampleId"></param>
/// <returns></returns>
public long m_lngQueryDeviceSampleID(int p_intBatchSeq, out string p_strSampleId)
{
p_strSampleId = null;
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
return(svc.m_lngQueryDeviceSampleID(this.objPrincipal, p_intBatchSeq, out p_strSampleId));
}
}
public string m_strGetSysParam(string p_strParam)
{
string result = "";
try
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
svc.m_lngGetSysParam(p_strParam, out result);
}
}
catch
{
result = "";
}
return(result);
}
/// <summary>
/// m_lngGetDeviceQCCheckItemByID
/// </summary>
/// <param name="p_strDeviceID"></param>
/// <param name="p_objResultArr"></param>
/// <returns></returns>
public long m_lngGetDeviceQCCheckItemByID(string p_strDeviceID, out clsLISCheckItemNode[] p_objResultArr)
{
p_objResultArr = null;
long num = 0L;
long result;
if (string.IsNullOrEmpty(p_strDeviceID))
{
result = num;
}
else
{
using (clsTmdQCBatchSvc svc = new clsTmdQCBatchSvc())
{
result = svc.m_lngGetDeviceQCCheckItemByID(this.objPrincipal, p_strDeviceID, out p_objResultArr);
}
}
return(result);
}
public long m_lngFindQCBatchCombinatorial(System.Security.Principal.IPrincipal p_objPrincipal,
clsLisQCBatchSchVO p_objCondition, out clsLisQCBatchVO[] p_objRecordArr)
{
long lngRes = 0;
p_objRecordArr = null;
clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();
lngRes = objPrivilege.m_lngCheckCallPrivilege
(p_objPrincipal, "com.digitalwave.iCare.middletier.clsSchQCBatchSvc", "m_lngFindQCBatchCombinatorial");
if (lngRes <= 0)
{
return(-1);
}
#region SQL
// string strSQL = @"SELECT t1.*, t2.workgroup_name_vchr, t3.devicename_vchr,
// t3.device_model_desc_vchr, t4.check_item_name_vchr,t6.lastname_vchr as operator_name
// FROM t_opr_lis_qcbatch t1,
// t_bse_lis_workgroup t2,
// (SELECT *
// FROM t_bse_lis_device t31, t_bse_lis_device_model t32
// WHERE t31.device_model_id_chr = t32.device_model_id_chr) t3,
// t_bse_lis_check_item t4,
// t_bse_employee t6
// WHERE t1.status_int = 1
// AND t1.workgroup_seq_int = t2.workgroup_seq_int(+)
// AND t1.deviceid_chr = t3.deviceid_chr(+)
// AND t1.check_item_id_chr = t4.check_item_id_chr(+)
// AND t1.operator_id_chr = t6.empid_chr(+)";
string strSQL = @"select t1.qcbatch_seq_int,
t1.sort_num_int,
t1.workgroup_seq_int,
t1.deviceid_chr,
t1.check_item_id_chr,
t1.qcsample_lotno_vchr,
t1.qcsample_source_vchr,
t1.qcsample_vendor_vchr,
t1.reagent_vchr,
t1.reagent_batch_vchr,
t1.checkmethod_name_vchr,
t1.wavelength_num,
t1.qcrules_vchr,
t1.resultunit_vchr,
t1.begin_dat,
t1.end_dat,
t1.summary_vchr,
t1.operator_id_chr,
t1.modify_dat,
t1.status_int,
t1.sort_num_int,
t2.workgroup_name_vchr,
t3.devicename_vchr,
t3.device_model_desc_vchr,
t4.device_check_item_name_vchr,
t6.lastname_vchr as operator_name
from t_opr_lis_qcbatch t1,
t_bse_lis_workgroup t2,
(select t31.deviceid_chr,
t31.devicename_vchr,
t32.device_model_desc_vchr,
t31.device_model_id_chr
from t_bse_lis_device t31, t_bse_lis_device_model t32
where t31.device_model_id_chr = t32.device_model_id_chr) t3,
t_bse_lis_device_check_item t4,
t_bse_employee t6
where t1.status_int = 1
and t1.workgroup_seq_int = t2.workgroup_seq_int(+)
and t1.deviceid_chr = t3.deviceid_chr(+)
and t3.device_model_id_chr = t4.device_model_id_chr
and t1.check_item_id_chr = t4.device_check_item_id_chr(+)
and t1.operator_id_chr = t6.empid_chr(+) ";
string strSQL_BatchSeq = " AND t1.qcbatch_seq_int = ?";
string strSQL_WorkGroup = " AND t1.workgroup_seq_int = ?";
string strSQL_Device = " AND t1.deviceid_chr = ?";
string strSQL_CheckItem = " AND t1.check_item_id_chr = ?";
string strSQL_QCSampleLot = " AND t1.qcsample_lotno_vchr = ?";
string strSQL_FromDat = " AND t1.begin_dat < ?";
string strSQL_ToDat = " AND t1.end_dat > ?";
#endregion
com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
#region 构造SQL
ArrayList arlSQL = new ArrayList();
ArrayList arlPara = new ArrayList();
arlSQL.Add(strSQL_FromDat);
arlPara.Add(p_objCondition.m_datQueryEnd);
arlSQL.Add(strSQL_ToDat);
arlPara.Add(p_objCondition.m_datQueryBegin);
if (p_objCondition.m_intQCBatchSeq >= 0)
{
arlSQL.Add(strSQL_BatchSeq);
arlPara.Add(p_objCondition.m_intQCBatchSeq);
}
if (p_objCondition.m_intWorkGroupSeq >= 0)
{
arlSQL.Add(strSQL_WorkGroup);
arlPara.Add(p_objCondition.m_intWorkGroupSeq);
}
if (p_objCondition.m_strQCDevice != null && p_objCondition.m_strQCDevice.Trim() != "")
{
arlSQL.Add(strSQL_Device);
arlPara.Add(p_objCondition.m_strQCDevice);
}
if (p_objCondition.m_strQCCheckItem != null && p_objCondition.m_strQCCheckItem.Trim() != "")
{
arlSQL.Add(strSQL_CheckItem);
arlPara.Add(p_objCondition.m_strQCCheckItem);
}
if (p_objCondition.m_strQCSampleLotNO != null && p_objCondition.m_strQCSampleLotNO.Trim() != "")
{
arlSQL.Add(strSQL_QCSampleLot);
arlPara.Add(p_objCondition.m_strQCSampleLotNO);
}
#endregion
foreach (object obj in arlSQL)
{
strSQL += obj.ToString();
}
System.Data.IDataParameter[] objIDPArr = null;
objHRPSvc.CreateDatabaseParameter(arlPara.Count, out objIDPArr);
for (int i = 0; i < arlPara.Count; i++)
{
objIDPArr[i].Value = arlPara[i];
}
try
{
DataTable dtbResult = null;
lngRes = objHRPSvc.lngGetDataTableWithParameters(strSQL, ref dtbResult, objIDPArr);
if (lngRes > 0 && dtbResult != null && dtbResult.Rows.Count > 0)
{
clsTmdQCBatchSvc objSvc = new clsTmdQCBatchSvc();
p_objRecordArr = new clsLisQCBatchVO[dtbResult.Rows.Count];
for (int i = 0; i < dtbResult.Rows.Count; i++)
{
p_objRecordArr[i] = new clsLisQCBatchVO();
this.ConstructVO(dtbResult.Rows[i], ref p_objRecordArr[i]);
p_objRecordArr[i].m_strWorkGroupName = dtbResult.Rows[i]["workgroup_name_vchr"].ToString();
p_objRecordArr[i].m_strDeviceName = dtbResult.Rows[i]["devicename_vchr"].ToString();
p_objRecordArr[i].m_strCheckItemName = dtbResult.Rows[i]["device_check_item_name_vchr"].ToString();
p_objRecordArr[i].m_strOperatorName = dtbResult.Rows[i]["operator_name"].ToString();
p_objRecordArr[i].m_strSortNum = dtbResult.Rows[i]["sort_num_int"].ToString();
}
}
objHRPSvc.Dispose();
}
catch (Exception objEx)
{
string strTmp = objEx.Message;
com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
