Пример #1
0
        public long m_lngGetAllReportGroupDetail(System.Security.Principal.IPrincipal p_objPrincipal, out clsReportGroupDetail_VO[] objReportGroupVOList)
        {
            long lngRes = 0;

            objReportGroupVOList = null;

            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngGetAllReportGroupDetail");
            if (lngRes < 0)
            {
                return(-1);
            }

            string    strSQL          = @"SELECT * FROM t_aid_lis_report_group_detail";
            DataTable dtbReportDetail = null;

            try
            {
                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                lngRes = objHRPSvc.lngGetDataTableWithoutParameters(strSQL, ref dtbReportDetail);
                objHRPSvc.Dispose();
                if (dtbReportDetail != null && dtbReportDetail.Rows.Count > 0)
                {
                    objReportGroupVOList = new clsReportGroupDetail_VO[dtbReportDetail.Rows.Count];
                    for (int i = 0; i < dtbReportDetail.Rows.Count; i++)
                    {
                        objReportGroupVOList[i] = new clsReportGroupDetail_VO();
                        ConstructReportGroupDetail(dtbReportDetail.Rows[i], ref objReportGroupVOList[i]);
                    }
                }
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRes);
        }
Пример #2
0
 private void ConstructReportGroupDetailVO(System.Data.DataRow objRow, ref clsReportGroupDetail_VO objReportGroupDetail)
 {
     objReportGroupDetail.strReportGroupID = objRow["REPORT_GROUP_ID_CHR"].ToString().Trim();
     objReportGroupDetail.strSampleGroupID = objRow["SAMPLE_GROUP_ID_CHR"].ToString().Trim();
     objReportGroupDetail.strPrintSeq      = objRow["PRINT_SEQ_INT"].ToString().Trim();
 }
Пример #3
0
        public long m_lngAddReportGroupDetail(System.Security.Principal.IPrincipal p_objPrincipal, ref clsReportGroupDetail_VO objReportGroupDetailVO)
        {
            long lngRes = 0;

            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsCheckGroupSvc", "m_lngAddReportGroupDetail");
            if (lngRes < 0)
            {
                return(-1);
            }

            string strSQL = @"INSERT INTO t_aid_lis_report_group_detail
										  (sample_group_id_chr, report_group_id_chr, print_seq_int
										  )
								   VALUES (?, ?, ?)"                                ;

            try
            {
                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                System.Data.IDataParameter[] objReportGroupDetailArr = null;
                objHRPSvc.CreateDatabaseParameter(3, out objReportGroupDetailArr);

                objReportGroupDetailArr[0].Value = objReportGroupDetailVO.strSampleGroupID;
                objReportGroupDetailArr[1].Value = objReportGroupDetailVO.strReportGroupID;
                objReportGroupDetailArr[2].Value = objReportGroupDetailVO.strPrintSeq;

                long lngRecEff = -1;

                lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objReportGroupDetailArr);
                objHRPSvc.Dispose();
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRes);
        }