SAP B1 addon stored procedure is not calling-CodePudding

I have created a module that is not calling the stored procedure please see below code.
Recordset lrec_DepDetails = (Recordset)SAP.G_DI_Company.GetBusinessObject(BoObjectTypes.BoRecordset);
string fs_DepDetails;
//fs_DepDetails = "exec [MLD_SALARY_PROCESS] 'S','9','2019-02','10'";



if (sPrsnCtg != "" && sTimeCtg != "" && sPeriod != "")
{
    if (sPrsnCtg == "S" && sTimeCtg == "9")
    {
        if (sUnit == "2" || sUnit == "7")
        {
            fs_DepDetails = "exec [MLD_SALARY_PROCESS_UPDATED] '"   sPrsnCtg   "','"   sTimeCtg   "','"   sPeriod   "' , '"   sUnit   "' ";
            lrec_DepDetails.DoQuery(fs_DepDetails);
        }
        else
        {
            fs_DepDetails = "exec [MLD_SALARY_PROCESS] '"   sPrsnCtg   "','"   sTimeCtg   "','"   sPeriod   "' , '"   sUnit   "' ";
            lrec_DepDetails.DoQuery(fs_DepDetails);
        }       
    }

    if (sPrsnCtg == "S" && sTimeCtg == "12")
    {

        if (sUnit == "2" || sUnit == "7")
        {
            fs_DepDetails = "exec [MLD_SALARY_PROCESS_S12_UPDATED] '"   sPrsnCtg   "','"   sTimeCtg   "','"   sPeriod   "' , '"   sUnit   "' ";
            lrec_DepDetails.DoQuery(fs_DepDetails);
        }
        else
        {
            fs_DepDetails = "exec [MLD_SALARY_PROCESS_S12] '"   sPrsnCtg   "','"   sTimeCtg   "','"   sPeriod   "' , '"   sUnit   "' ";
            lrec_DepDetails.DoQuery(fs_DepDetails);

        }

    }

    if (sPrsnCtg == "W" && sTimeCtg == "12")
    {


        if (sUnit == "2" || sUnit == "7")
        {

            fs_DepDetails = "exec [MLD_SALARY_PROCESS_W12_UPDATED] '"   sPrsnCtg   "','"   sTimeCtg   "','"   sPeriod   "' , '"   sUnit   "' ";
            lrec_DepDetails.DoQuery(fs_DepDetails);

        }
        else
        {
            fs_DepDetails = "exec [MLD_SALARY_PROCESS_W12] '"   sPrsnCtg   "','"   sTimeCtg   "','"   sPeriod   "' , '"   sUnit   "' ";
            lrec_DepDetails.DoQuery(fs_DepDetails);
        }
    }
CodePudding user response：