Пример #1
0
    //gets current mids from the stat_module_constant table
    public bool GetCurrentMIDS(BaseMaster BaseMstr,
                               out int nReasonForReferralMID,
                               out int nSuicideMID,
                               out int nMSEMID,
                               out int nSubsequentEventMID)
    {
        //status info
        long   lStatusCode      = -1;
        string strStatusComment = "";

        //init the outs
        nReasonForReferralMID = -1;
        nSuicideMID           = -1;
        nMSEMID             = -1;
        nSubsequentEventMID = -1;

        //create a new parameter list with standard params from basemstr
        CDataParameterList plist = new CDataParameterList(BaseMstr);

        CDataSet cds = new CDataSet();
        DataSet  ds  = cds.GetOracleDataSet(BaseMstr.DBConn,
                                            "PCK_INTAKE.GetStatModuleConstantRS",
                                            plist,
                                            out lStatusCode,
                                            out strStatusComment);

        //set the base master status code and status for display
        BaseMstr.StatusCode    = lStatusCode;
        BaseMstr.StatusComment = strStatusComment;
        if (lStatusCode == 0)
        {
            CDataUtils util = new CDataUtils();

            nReasonForReferralMID = util.GetIntValueFromDS(ds, "RFR_MODULE");
            nMSEMID             = util.GetIntValueFromDS(ds, "MSE_MODULE");
            nSuicideMID         = util.GetIntValueFromDS(ds, "SUICIDE_MODULE");
            nSubsequentEventMID = util.GetIntValueFromDS(ds, "RFR_SE_MODULE");

            return(true);
        }

        return(false);
    }