Example #1
0
        public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisCheckMethodVO p_objCheckMethod, out int p_intSeq)
        {
            long lngRes = 0;

            p_intSeq = -1;
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdCheckMethodSvc", "m_lngInsert");
            if (lngRes <= 0)
            {
                return(-1);
            }
            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
            string strSQL = @"INSERT INTO T_BSE_LIS_CHECKMETHOD(
                                                                    METHOD_SEQ_INT,
                                                                    CHECKMETHOD_NAME_VCHR,
                                                                    PYCODE_VCHR,
                                                                    WBCODE_VCHR
                                                                )
                                                                VALUES
                                                                ( ?, ? ,? ,?)";

            try
            {
                lngRes = 0;
                lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_CHECKMETHOD", "METHOD_SEQ_INT", out p_intSeq);
                if (lngRes <= 0)
                {
                    return(-1);
                }
                lngRes = 0;


                System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
                    p_intSeq,
                    p_objCheckMethod.m_strName,
                    p_objCheckMethod.m_strPycode,
                    p_objCheckMethod.m_strWbcode
                    );

                long lngRecEff = -1;
                //往表增加记录
                lngRes = 0;
                lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
                objHRPSvc.Dispose();
                if (lngRes > 0)
                {
                    p_objCheckMethod.m_intSeq = p_intSeq;//给VO赋值ID
                }
                else
                {
                    p_intSeq = -1;
                }
            }
            catch (Exception objEx)
            {
                new clsLogText().LogError(objEx);
            }
            return(lngRes);
        }
Example #2
0
        public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCSamplelotVO p_objQCSamplelot, out int p_intSeq)
        {
            long lngRes = 0;

            p_intSeq = -1;
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert");
            if (lngRes <= 0)
            {
                return(-1);
            }
            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();

            try
            {
                lngRes = 0;
                lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq);
                if (lngRes <= 0)
                {
                    return(-1);
                }
                lngRes = 0;


                System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objQCSamplelot, p_intSeq);

                long lngRecEff = -1;
                //往表增加记录
                lngRes = 0;
                lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr);
                objHRPSvc.Dispose();
                if (lngRes > 0)
                {
                    p_objQCSamplelot.m_intSeq = p_intSeq;//给VO赋值ID
                }
                else
                {
                    p_intSeq = -1;
                }
            }
            catch (Exception objEx)
            {
                string strTmp = objEx.Message;
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRes);
        }
Example #3
0
        public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCReportVO p_objQCReport, out int p_intSeq)
        {
            long lngRes = 0;

            p_intSeq = -1;
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, m_strCurrentSvcDetailName, "m_lngInsert");
            if (lngRes <= 0)
            {
                return(-1);
            }
            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();

            try
            {
                lngRes = 0;
                lngRes = objHRPSvc.m_lngGenerateNewID(m_strTableName, m_strPrimaryKey, out p_intSeq);
                if (lngRes <= 0)
                {
                    return(-1);
                }
                lngRes = 0;

                p_objQCReport.m_dtModify = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                System.Data.IDataParameter[] objODPArr = GetInsertDataParameterArr(p_objQCReport, p_intSeq);

                long lngRecEff = -1;
                //往表增加记录
                lngRes = 0;
                lngRes = objHRPSvc.lngExecuteParameterSQL(m_strInsertSql, ref lngRecEff, objODPArr);
                objHRPSvc.Dispose();
                if (lngRes > 0)
                {
                    p_objQCReport.m_intSeq = p_intSeq;//给VO赋值ID
                }
                else
                {
                    p_intSeq = -1;
                }
            }
            catch (Exception objEx)
            {
                new clsLogText().LogError(objEx);
            }
            return(lngRes);
        }
Example #4
0
        private long m_lngAddProperty(clsUnitProperty_VO p_objVO)
        {
            long   lngRes = 0;
            string strSQL = @"INSERT INTO t_aid_lis_unit_property(PROPERTY_ID_CHR,
							PROPERTY_NAME_VCHR,SUMMARY_VCHR,PROPERTY_PRIORITY_NUM,INUSE_FLAG_NUM) 
							VALUES (?, ?, ?, ?, ?)"                            ;

            try
            {
                System.Data.IDataParameter[] objDPArr = null;

                com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
                objHRPSvc.CreateDatabaseParameter(5, out objDPArr);

                string strNewID = null;
                objHRPSvc.m_lngGenerateNewID("t_aid_lis_unit_property", "PROPERTY_ID_CHR", out strNewID);
                if (strNewID == null || strNewID == "")
                {
                    throw new Exception("不能分配ID");
                }
                p_objVO.m_strPROPERTY_ID_CHR = strNewID;



                objDPArr[0].Value = p_objVO.m_strPROPERTY_ID_CHR;
                objDPArr[1].Value = p_objVO.m_strPROPERTY_NAME_VCHR;
                objDPArr[2].Value = p_objVO.m_strSUMMARY_VCHR;
                objDPArr[3].Value = p_objVO.m_intPROPERTY_PRIORITY_NUM;
                objDPArr[4].Value = p_objVO.m_intINUSE_FLAG_NUM;

                long lngRecEff = -1;

                lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objDPArr);
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
                throw objEx;
            }
            return(lngRes);
        }
Example #5
0
        private long m_lngAddNewAppl(clsLisApplMainVO applMain, out clsLisApplMainVO applMainOut)
        {
            #region == SQL ==

            string sql = @"insert into t_opr_lis_application
                                      ( application_id_chr      , modify_dat, 
							            patientid_chr           , application_dat, 
							            sex_chr                 , patient_name_vchr, 
							            patient_subno_chr       , age_chr, 
							            patient_type_id_chr     , diagnose_vchr, 
							            bedno_chr               , icdcode_chr, 
							            patientcardid_chr       , application_form_no_chr, 
							            operator_id_chr         , appl_empid_chr, 
							            appl_deptid_chr         , summary_vchr, 
							            pstatus_int             , emergency_int,
							            special_int             , form_int,
							            patient_inhospitalno_chr, sample_type_id_chr,
							            sample_type_vchr        , check_content_vchr,
							            oringin_dat             , charge_info_vchr,   orderunitrelation_vchr  )
								values(      ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?   )"                                ;


            #endregion

            applMainOut = applMain;
            long lngRes = 0;
            try
            {
                IDataParameter[]   objLisApplArr = null;
                clsHRPTableService objHRPSvc     = new clsHRPTableService();
                objHRPSvc.CreateDatabaseParameter(29, out objLisApplArr);

                DateTime CurTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                if (!IsNullOrEmptyOrSpace(applMain.m_strMODIFY_DAT))
                {
                    try
                    {
                        DateTime dtmPreModify = DateTime.Parse(applMain.m_strMODIFY_DAT);
                        TimeSpan ts           = CurTime - dtmPreModify;
                        if (ts.TotalMilliseconds < 1000)
                        {
                            CurTime = CurTime.AddSeconds(1f);
                        }
                    }
                    catch { }
                }

                if (IsNullOrEmptyOrSpace(applMain.m_strAPPLICATION_ID))
                {
                    string strNewApplID = null;
                    objHRPSvc.m_lngGenerateNewID("t_opr_lis_application", "APPLICATION_ID_CHR", out strNewApplID);
                    if (string.IsNullOrEmpty(strNewApplID))
                    {
                        throw new Exception("不能分配申请单ID");
                    }
                    applMain.m_strAPPLICATION_ID = strNewApplID;
                }


                objLisApplArr[0].Value   = applMain.m_strAPPLICATION_ID;
                applMain.m_strMODIFY_DAT = CurTime.ToString("yyyy-MM-dd HH:mm:ss");
                objLisApplArr[1].Value   = CurTime;
                if (IsNullOrEmptyOrSpace(applMain.m_strPatientID))
                {
                    applMain.m_strPatientID = "-1";
                }
                objLisApplArr[2].Value  = applMain.m_strPatientID;
                objLisApplArr[2].DbType = DbType.String;

                if (Microsoft.VisualBasic.Information.IsDate(applMain.m_strAppl_Dat))
                {
                    objLisApplArr[3].Value = System.DateTime.Parse(applMain.m_strAppl_Dat);
                }
                else
                {
                    applMain.m_strAppl_Dat = null;
                }
                objLisApplArr[4].Value  = applMain.m_strSex;
                objLisApplArr[5].Value  = applMain.m_strPatient_Name;
                objLisApplArr[6].Value  = applMain.m_strPatient_SubNO;
                objLisApplArr[7].Value  = applMain.m_strAge;
                objLisApplArr[8].Value  = applMain.m_strPatientType;
                objLisApplArr[9].Value  = applMain.m_strDiagnose;
                objLisApplArr[10].Value = applMain.m_strBedNO;
                objLisApplArr[11].Value = applMain.m_strICD;

                if (IsNullOrEmptyOrSpace(applMain.m_strPatientcardID))
                {
                    objLisApplArr[12].Value = System.DBNull.Value;
                }
                else
                {
                    objLisApplArr[12].Value = applMain.m_strPatientcardID;
                }

                objLisApplArr[13].Value = applMain.m_strApplication_Form_NO;
                objLisApplArr[14].Value = applMain.m_strOperator_ID;
                objLisApplArr[15].Value = applMain.m_strAppl_EmpID;
                objLisApplArr[16].Value = applMain.m_strAppl_DeptID;
                objLisApplArr[17].Value = applMain.m_strSummary;
                objLisApplArr[18].Value = applMain.m_intPStatus_int;
                objLisApplArr[19].Value = applMain.m_intEmergency;
                objLisApplArr[20].Value = applMain.m_intSpecial;
                objLisApplArr[21].Value = applMain.m_intForm_int;
                objLisApplArr[22].Value = applMain.m_strPatient_inhospitalno_chr;
                objLisApplArr[23].Value = applMain.m_strSampleTypeID;
                objLisApplArr[24].Value = applMain.m_strSampleType;
                objLisApplArr[25].Value = applMain.m_strCheckContent;
                try
                {
                    DateTime.Parse(applMain.m_strOriginDate);
                }
                catch
                {
                    applMain.m_strOriginDate = CurTime.ToString("yyyy-MM-dd HH:mm:ss");
                }

                objLisApplArr[26].Value = DateTime.Parse(applMain.m_strOriginDate);
                objLisApplArr[27].Value = applMain.m_strChargeInfo;
                objLisApplArr[28].Value = applMain.m_strOrderunitrelation;

                long lngRecEff = -1;

                lngRes = objHRPSvc.lngExecuteParameterSQL(sql, ref lngRecEff, objLisApplArr);
                objHRPSvc.Dispose();
            }
            catch (Exception objEx)
            {
                new clsLogText().LogError(objEx);
                throw objEx;
            }
            return(lngRes);
        }
Example #6
0
        public long m_lngInsertQCReport(IPrincipal p_objPrincipal, clsLisQCReportVO p_objQCReport, out int p_intSeq)
        {
            long num = 0L;

            p_intSeq = -1;
            clsPrivilegeHandleService handSvc = new clsPrivilegeHandleService();

            num = handSvc.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsQCBusiness_Serv", "m_lngInsertQCReport");
            long result;
            clsHRPTableService svc = new clsHRPTableService();

            if (num <= 0L)
            {
                result = -1L;
            }
            else
            {
                try
                {
                    num = 0L;
                    num = svc.m_lngGenerateNewID("T_OPR_LIS_QCREPORT", "QCREPORT_SEQ_INT", out p_intSeq);
                    if (num <= 0L)
                    {
                        result = -1L;
                        return(result);
                    }
                    num = 0L;

                    p_objQCReport.m_dtModify = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                    IDataParameter[] insertDataParameterArr = this.GetInsertDataParameterArr(p_objQCReport, p_intSeq);

                    long num2 = -1L;
                    num = 0L;
                    string Sql = @"insert into t_opr_lis_qcreport
                                                  (qcreport_seq_int,
                                                   qcbatch_seq_int,
                                                   qcstatus_int,
                                                   unmatchedrule_vchr,
                                                   reason_vchr,
                                                   process_vchr,
                                                   summary_vchr,
                                                   report_dat,
                                                   reportor_id_chr,
                                                   status_int,
                                                   modify_dat,
                                                   report_stats_int)
                                                values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ";

                    num = svc.lngExecuteParameterSQL(Sql, ref num2, insertDataParameterArr);

                    if (num > 0L)
                    {
                        p_objQCReport.m_intSeq = p_intSeq;
                    }
                    else
                    {
                        p_intSeq = -1;
                    }
                }
                catch (Exception objEx)
                {
                    new clsLogText().LogError(objEx);
                }
                finally
                {
                    svc.Dispose();
                }
                result = num;
            }
            return(result);
        }
Example #7
0
        public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisQCRuleVO p_objRule, out int p_intSeq)
        {
            long lngRes = 0;

            p_intSeq = -1;
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdQCRulesSvc", "m_lngInsert");
            if (lngRes <= 0)
            {
                return(-1);
            }
            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
            string strSQL = @"
                            INSERT INTO T_BSE_LIS_QCRULES      (
                                                                    RULE_SEQ_INT,
                                                                    RULE_NAME_VCHR,
                                                                    RULE_ALIAS_VCHR,
                                                                    RULE_DESC_VCHR,
                                                                    RULE_FORMULA_VCHR,
                                                                    RULE_SUMMARY_VCHR,
                                                                    RULE_DEFAULTFLAG_INT,
                                                                    RULE_TYPEFLAG_INT
                                                                )
                                                                VALUES
                                                                ( ?, ? ,? , ?, ?, ?, ?, ?)";

            try
            {
                lngRes = 0;
                lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_QCRULES", "RULE_SEQ_INT", out p_intSeq);
                if (lngRes <= 0)
                {
                    return(-1);
                }
                lngRes = 0;


                System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
                    p_intSeq,
                    p_objRule.m_strName,
                    p_objRule.m_strAlias,
                    p_objRule.m_strDesc,
                    p_objRule.m_strFormula,
                    p_objRule.m_strSummary,
                    (int)p_objRule.m_enmDefaultflag,
                    (int)p_objRule.m_enmWarnType
                    );

                long lngRecEff = -1;
                //往表增加记录
                lngRes = 0;
                lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
                objHRPSvc.Dispose();
                if (lngRes > 0)
                {
                    p_objRule.m_intSeq = p_intSeq;//给VO赋值ID
                }
                else
                {
                    p_intSeq = -1;
                }
            }
            catch (Exception objEx)
            {
                new clsLogText().LogError(objEx);
            }
            return(lngRes);
        }
Example #8
0
        public long lngInsert(IPrincipal p_objPrincipal, clsBill_VO p_objEntity, out int p_intBillid_int)
        {
            long lngRes = -1;

            p_intBillid_int = -1;
            clsHRPTableService        HRPSvc       = new clsHRPTableService();
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.HIS.clsBillSvc", "lngInsert");
            if (lngRes < 0)
            {
                return(-1);
            }
            string strSQL = string.Format(
                "INSERT INTO t_bse_bill( "
                + "billid_int,billtype_chr,billno_vchr,status_int,inempid_chr,indatetime_dat,inoprid_chr,inoprdatetime_dat,outempid_chr,outdatetime_dat,outoprid_chr,outoprdatetime_dat,returnempid_chr,returndatetime_dat,returnoprid_chr,returnoprdatetime_dat,useempid_chr,usedatetime_dat,cancelempid_chr,canceldatetime_dat,refempid_chr,refdatetime_dat,note_vchr,totalsum_mny,acctsum_mny,sbsum_mny"
                + ") VALUES ( "
                + "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?"
                + ")");

            try
            {
                int strRecordID = -1;
                lngRes = HRPSvc.m_lngGenerateNewID("t_bse_bill", "billid_int", out strRecordID);
                if (lngRes > 0)
                {
                    IDataParameter[] paramArr = null;
                    HRPSvc.CreateDatabaseParameter(26, out paramArr);
                    paramArr[0].Value  = strRecordID;
                    paramArr[1].Value  = p_objEntity.Billtype_chr;
                    paramArr[2].Value  = p_objEntity.Billno_vchr;
                    paramArr[3].Value  = p_objEntity.Status_int;
                    paramArr[4].Value  = p_objEntity.Inempid_chr;
                    paramArr[5].Value  = p_objEntity.Indatetime_dat;
                    paramArr[6].Value  = p_objEntity.Inoprid_chr;
                    paramArr[7].Value  = p_objEntity.Inoprdatetime_dat;
                    paramArr[8].Value  = p_objEntity.Outempid_chr;
                    paramArr[9].Value  = p_objEntity.Outdatetime_dat;
                    paramArr[10].Value = p_objEntity.Outoprid_chr;
                    paramArr[11].Value = p_objEntity.Outoprdatetime_dat;
                    paramArr[12].Value = p_objEntity.Returnempid_chr;
                    paramArr[13].Value = p_objEntity.Returndatetime_dat;
                    paramArr[14].Value = p_objEntity.Returnoprid_chr;
                    paramArr[15].Value = p_objEntity.Returnoprdatetime_dat;
                    paramArr[16].Value = p_objEntity.Useempid_chr;
                    paramArr[17].Value = p_objEntity.Usedatetime_dat;
                    paramArr[18].Value = p_objEntity.Cancelempid_chr;
                    paramArr[19].Value = p_objEntity.Canceldatetime_dat;
                    paramArr[20].Value = p_objEntity.Refempid_chr;
                    paramArr[21].Value = p_objEntity.Refdatetime_dat;
                    paramArr[22].Value = p_objEntity.Note_vchr;
                    paramArr[23].Value = p_objEntity.Totalsum_mny;
                    paramArr[24].Value = p_objEntity.Acctsum_mny;
                    paramArr[25].Value = p_objEntity.Sbsum_mny;
                    long lngRecordsAffected = -1;
                    lngRes = HRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecordsAffected, paramArr);
                    HRPSvc.Dispose();
                }
            }
            catch (Exception objEx)
            {
                string     strTmp    = objEx.Message;
                clsLogText objLogger = new clsLogText();
                bool       blnRes    = objLogger.LogError(objEx);
            }
            return(lngRes);
        }
Example #9
0
        public long m_lngInsert(System.Security.Principal.IPrincipal p_objPrincipal, clsLisWorkGroupVO p_objWorkGroup, out int p_intSeq)
        {
            long lngRes = 0;

            p_intSeq = -1;
            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

            lngRes = objPrivilege.m_lngCheckCallPrivilege(p_objPrincipal, "com.digitalwave.iCare.middletier.LIS.clsTmdWorkGroupSvc", "m_lngInsert");
            if (lngRes <= 0)
            {
                return(-1);
            }
            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();
            string strSQL = @"
                            INSERT INTO T_BSE_LIS_WORKGROUP      (
                                                                    WORKGROUP_SEQ_INT,
                                                                    WORKGROUP_NAME_VCHR,
                                                                    SUMMARY_VCHR,
                                                                    STATUS_INT
                                                                )
                                                                VALUES
                                                                ( ?, ? ,? , ?)";


            try
            {
                lngRes = 0;
                lngRes = objHRPSvc.m_lngGenerateNewID("T_BSE_LIS_WORKGROUP", "WORKGROUP_SEQ_INT", out p_intSeq);
                if (lngRes <= 0)
                {
                    return(-1);
                }
                lngRes = 0;


                System.Data.IDataParameter[] objODPArr = clsPublicSvc.m_objConstructIDataParameterArr(
                    p_intSeq,
                    p_objWorkGroup.m_strName,
                    p_objWorkGroup.m_strSummary,
                    (int)p_objWorkGroup.m_enmStatus
                    );

                long lngRecEff = -1;
                //往表增加记录
                lngRes = 0;
                lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL, ref lngRecEff, objODPArr);
                objHRPSvc.Dispose();
                if (lngRes > 0)
                {
                    p_objWorkGroup.m_intSeq = p_intSeq;//给VO赋值ID
                }
                else
                {
                    p_intSeq = -1;
                }
            }
            catch (Exception objEx)
            {
                string strTmp = objEx.Message;
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);
            }
            return(lngRes);
        }
Example #10
0
        public long m_lngAddNewInputGroup(System.Security.Principal.IPrincipal p_objPrincipal,
                                          clsInputGroupBaseInfo_VO p_objBaseInfo, clsInputGroupDetail_VO[] p_objResults, out string strID)
        {
            long lngRes = 0;

            strID = null;
            if (p_objBaseInfo == null)
            {
                return(lngRes);
            }

            clsPrivilegeHandleService objPrivilege = new clsPrivilegeHandleService();

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

            com.digitalwave.iCare.middletier.HRPService.clsHRPTableService objHRPSvc = new clsHRPTableService();

            string strSQL1 = @"INSERT INTO t_bse_lis_input_group
     VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
            string strSQL2 = @"INSERT INTO t_bse_lis_input_group_detail
     VALUES (?, ?, ?)";

            try
            {
                objHRPSvc.m_lngGenerateNewID("t_bse_lis_input_group", "input_group_id_chr", out strID);
                if (strID == null || strID.Trim() == "")
                {
                    return(-1);
                }
                p_objBaseInfo.m_strINPUT_GROUP_ID_CHR = strID;

                IDataParameter[] objParamArr1 = null;
                objHRPSvc.CreateDatabaseParameter(9, out objParamArr1);
                objParamArr1[0].Value = p_objBaseInfo.m_strAPPLY_UNIT_ID_CHR;
                objParamArr1[1].Value = p_objBaseInfo.m_strINPUT_GROUP_ID_CHR;
                objParamArr1[2].Value = p_objBaseInfo.m_strINPUT_GROUP_NAME_VCHR;
                objParamArr1[3].Value = p_objBaseInfo.m_strSUMMARY_VCHR;
                objParamArr1[4].Value = p_objBaseInfo.m_strPYCODE_VCHR;
                objParamArr1[5].Value = p_objBaseInfo.m_strWBCODE_VCHR;
                objParamArr1[6].Value = p_objBaseInfo.m_strASCODE_VCHR;
                objParamArr1[7].Value = p_objBaseInfo.m_intSEQUENCE_NUM;
                objParamArr1[8].Value = p_objBaseInfo.m_intINUSEFLAG_NUM;

                long lngEff = 0;
                lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL1, ref lngEff, objParamArr1);
                if (lngRes > 0 && p_objResults != null)
                {
                    for (int i = 0; i < p_objResults.Length; i++)
                    {
                        IDataParameter[] objParamArr2 = null;
                        objHRPSvc.CreateDatabaseParameter(3, out objParamArr2);
                        objParamArr2[0].Value = strID;
                        objParamArr2[1].Value = p_objResults[i].m_strCHECK_ITEM_ID_CHR;
                        objParamArr2[2].Value = p_objResults[i].m_intSEQUENCE_NUM;

                        lngRes = 0;
                        lngRes = objHRPSvc.lngExecuteParameterSQL(strSQL2, ref lngEff, objParamArr2);
                        if (lngRes <= 0)
                        {
                            break;
                        }
                    }
                }
                if (lngRes <= 0)
                {
                    System.EnterpriseServices.ContextUtil.SetAbort();
                }
            }
            catch (Exception objEx)
            {
                com.digitalwave.Utility.clsLogText objLogger = new clsLogText();
                bool blnRes = objLogger.LogError(objEx);//要在LogError方法中抛出异常。
                lngRes = 0;
            }
            return(lngRes);
        }