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