Exemple #1
0
    private DataTable GetReportData()
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = RptObj.Local_GetDataSetSP1("SP_BalancesSummaryOfAgents_rpt");

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string date)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[2];
        parm[0]  = RptObj.OracleDBParameter("p_date", date, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_other_bank_trans_report", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string Month)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[2];
        parm[0]  = RptObj.OracleDBParameter("p_month", Month, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_ins_status_sumry_rpt", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #4
0
    private DataTable GetData(string month)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[2];
        parm[0]  = RptObj.OracleDBParameter("p_month", month, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_sbp_claim", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    private DataTable GetReportData(string[] whereFilter)
    {
        MCBReportClass RptObj = new MCBReportClass();

        OracleParameter[] spParams = new OracleParameter[3];

        spParams[0] = RptObj.OracleDBParameter("p_company_code", whereFilter[0], "String", "In");
        spParams[1] = RptObj.OracleDBParameter("p_file", whereFilter[1], "String", "In");
        spParams[2] = RptObj.OracleDBParameter("data_resultset", "", "Cursor", "Out");
        DataSet dsReport = RptObj.Oracle_GetDataSetSP("SP_DraftTransaction_rpt", spParams);

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string date, string CompanyCode)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[3];
        parm[0]  = RptObj.OracleDBParameter("p_company_code", CompanyCode, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_date", date, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("data_set", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_NON_RES_ACCOUNTS", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string PinCode)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[2];
        parm[0]  = RptObj.OracleDBParameter("p_pin_id", PinCode, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_ws_auditlog_rpt", parm);

        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #8
0
    public string GetBankName()
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[1];
        parm[0]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("SP_System_setup", parm);
        if (dsReport.Tables[0].Rows.Count > 0)
        {
            return(dsReport.Tables[0].Rows[0][0].ToString());
        }
        return("");
    }
    private DataTable GetData(string fromdate, string todate)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[3];
        parm[0]  = RptObj.OracleDBParameter("p_fromdate", fromdate, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_todate", todate, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_DD_EXE_SUMMARY_REPORT", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string month, string company_code)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[3];
        parm[0]  = RptObj.OracleDBParameter("p_month", month, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_company_code", company_code, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_home_rem_sum_Rpt", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #11
0
    private DataTable GetData(string p_account_no, string p_ref_no, string from_date, string to_date)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[5];
        parm[0]  = RptObj.OracleDBParameter("p_account_no", p_account_no, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_ref_no", p_ref_no, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_from_dt", from_date, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("p_to_dt", to_date, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("p_dataset", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_payment_prc_rpt", parm);
        return(dsReport.Tables[0]);
    }
Exemple #12
0
    public string GetReportName()
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[2];
        parm[0]  = RptObj.OracleDBParameter("v_Report_Code", "R12", "String", "In");
        parm[1]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("SP_REPORT_HEADER", parm);
        if (dsReport.Tables[0].Rows.Count > 0)
        {
            return(dsReport.Tables[0].Rows[0][1].ToString());
        }
        return("");
    }
Exemple #13
0
    private DataTable GetData(string p_usr_name, string fromDate, string toDate)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[4];
        parm[0]  = RptObj.OracleDBParameter("p_usr_name", p_usr_name, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_from_dt", fromDate, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_to_dt", toDate, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("data_set", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_core_nr_ac_satmnt_rpt", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #14
0
    private DataTable GetData(string companycode, string companyType, string fromDate, string toDate)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[5];
        parm[0]  = RptObj.OracleDBParameter("p_from_date", fromDate, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_to_date", toDate, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_company_code", companycode, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("p_company_type", companyType, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_dd_branchwise_report", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #15
0
    private DataTable GetData(string FromDate, string ToDate, string CompanyName)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[4];
        parm[0] = RptObj.OracleDBParameter("p_from_date", FromDate, "String", "In");
        parm[1] = RptObj.OracleDBParameter("p_to_date", ToDate, "String", "In");
        parm[2] = RptObj.OracleDBParameter("p_company_name", CompanyName, "String", "In");
        // parm[3] = RptObj.OracleDBParameter("P_commission", commission, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_rpt_rda", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #16
0
    private DataTable GetData(string FromDate, string ToDate, string USRate, string fc_saudiRiyal, string CompanyName)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[6];
        parm[0]  = RptObj.OracleDBParameter("p_from_date", Convert.ToDateTime(FromDate).ToString("dd-MM-yyyy"), "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_to_date", ToDate, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_us_rate", USRate, "Double", "In");
        parm[3]  = RptObj.OracleDBParameter("P_fc_saudi_riyal", fc_saudiRiyal, "Double", "In");
        parm[4]  = RptObj.OracleDBParameter("p_company_name", CompanyName, "String", "In");
        parm[5]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_rptstatebankrebate_summary", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #17
0
    private DataTable GetData(string companycode, string fromDate, string toDate)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[4];
        parm[0] = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
        // parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
        parm[1] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
        parm[2] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
        // parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("SP_CUSTOMER_FUNDING", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #18
0
    private DataTable GetData(string companycode, string fromDate, string toDate, string companytype)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[6];
        parm[0]  = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("p_companytype", companytype, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("p_user_id", Session["U_NAME"].ToString(), "String", "In");
        parm[5]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_filelog_report", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string CompanyName, string TransType, string AgentType, string FromDate, string ToDate)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[6];
        parm[0]  = RptObj.OracleDBParameter("p_company_code", CompanyName, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_trans_type", TransType, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_COMPANY_TYPE", AgentType, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("p_from_dt", FromDate, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("p_to_dt", ToDate, "String", "In");
        parm[5]  = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_daily_post_summ_rpt", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    private DataTable GetData(string company_code, string status, string fromDate, string toDate, string trans_type, string selecttype, string p_companytype)
    {
        MCBReportClass RptObj = new MCBReportClass();

        OracleParameter[] parm = new OracleParameter[9];
        parm[0] = RptObj.OracleDBParameter("p_companycode", company_code, "String", "In");
        parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
        parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
        parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
        parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
        parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
        parm[6] = RptObj.OracleDBParameter("p_companytype", p_companytype, "String", "In");
        parm[7] = RptObj.OracleDBParameter("p_usr_name", Session["U_NAME"].ToString(), "String", "In");
        parm[8] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dt      = RptObj.Oracle_GetDataSetSP("sp_mispayment", parm).Tables[0];
        return(dt);
    }
Exemple #21
0
    //= new DatabaseConnection_Util();

    //public DataSet BalancesSummaryOfAgents()
    //{
    //    OracleParameter[] PR = new OracleParameter[1];
    //    //PR[0] = DataTransform.Oracle_Param("v_FromDate", OracleType.VarChar, ParameterDirection.Input, FromDate);
    //    //PR[1] = DataTransform.Oracle_Param("v_ToDate", OracleType.VarChar, ParameterDirection.Input, ToDate);
    //    PR[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
    //    DataSet DS = DataTransform.Oracle_GetDataSetSP("SP_BalancesSummaryOfAgents_rpt", PR);
    //    return DS;
    //}

    //public DataSet CompanyBalance()
    //{
    //    DataSet dsResult = null;
    //    OracleParameter[] param = new OracleParameter[1];
    //    try
    //    {
    //        param[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
    //        dsResult=  DataTransform.Oracle_GetDataSetSP("PAY_SP_RPTCOMPANYBALANCE", param);
    //    }
    //    catch (Exception ex) { }

    //    return dsResult;
    //}

    public static string GetOrgName()
    {
        string companyName = "";

        try
        {
            MCBReportClass RptObj   = new MCBReportClass();
            DataSet        dsReport = RptObj.Local_GetDataSetSP1("SP_SYSTEM_SETUP");
            if (dsReport.Tables[0].Rows.Count > 0)
            {
                companyName = dsReport.Tables[0].Rows[0]["company_name"].ToString();
            }
        }
        catch (Exception ex)
        { }
        return(companyName);
    }
    private DataTable GetData(string branch_id, string status, string fromDate, string toDate, string selecttype)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[5];
        parm[0] = RptObj.OracleDBParameter("p_branch_id", branch_id, "String", "In");
        parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
        parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
        parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
        //parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
        //parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_mispayment_branchwise", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
    public void Get_BusinessNature()
    {
        ddl_BusinessNature.Items.Clear();
        MCBReportClass RptObj = new MCBReportClass();
        DataTable      dt     = new DataTable();

        OracleParameter[] parm = new OracleParameter[2];
        parm[0] = RptObj.OracleDBParameter("p_type", "", "String", "In");
        parm[1] = RptObj.OracleDBParameter("p_dataset", "", "Cursor", "Out");
        dt      = RptObj.Oracle_GetDataSetSP("sp_get_companyType", parm).Tables[0];
        if (dt.Rows.Count > 0)
        {
            ddl_BusinessNature.DataSource     = dt;
            ddl_BusinessNature.DataValueField = "business_nature";
            ddl_BusinessNature.DataTextField  = "business_desc";
            ddl_BusinessNature.DataBind();
        }
        ddl_BusinessNature.Items.Insert(0, new ListItem("All", ""));
    }
    private DataTable GetData(string companycode, string status, string fromDate, string toDate, string trans_type, string selecttype, string Branchid, string Userid)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[9];
        parm[0]  = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_status", status, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
        parm[5]  = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
        parm[6]  = RptObj.OracleDBParameter("p_BRANCHID", Branchid, "String", "In");
        parm[7]  = RptObj.OracleDBParameter("p_USERID", Userid, "String", "In");
        parm[8]  = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dsReport = RptObj.Oracle_GetDataSetSP("sp_mispayment_CPD", parm);
        string totalstub = dsReport.Tables[0].Rows.Count.ToString();

        return(dsReport.Tables[0]);
    }
Exemple #25
0
    public static string GetReportHeader(string reportCode)
    {
        string headingName = "";

        try
        {
            MCBReportClass   RptObj = new MCBReportClass();
            OleDbParameter[] param  = new OleDbParameter[1];

            param[0] = RptObj.OleDbParameter("@v_Report_Code", reportCode, "String", "In");

            DataSet dsReport = RptObj.Local_GetDataSetSP1("SP_REPORT_HEADER", param);
            if (dsReport.Tables[0].Rows.Count > 0)
            {
                headingName = dsReport.Tables[0].Rows[0]["HEADING1"].ToString();
            }
        }
        catch (Exception ex)
        { }
        return(headingName);
    }
Exemple #26
0
    //private DataTable GetData(string company_code, string status, string fromDate, string toDate,
    //string trans_type, string selecttype)
    //{
    //    MCBReportClass RptObj = new MCBReportClass();
    //    OracleParameter[] parm = new OracleParameter[8];
    //    parm[0] = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
    //    parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
    //    parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
    //    parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
    //    parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
    //    parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
    //    parm[6] = RptObj.OracleDBParameter("p_usr_name", Session["U_NAME"].ToString(), "String", "In");
    //    parm[7] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
    //    dt = RptObj.Oracle_GetDataSetSP("sp_mispayment", parm).Tables[0];
    //    return dt;
    //}
    private DataTable GetData(string companycode, string status, string fromDate, string toDate, string trans_type, string selecttype, string beneAddress, string RemitterName, string FileName)
    {
        MCBReportClass RptObj   = new MCBReportClass();
        DataSet        dsReport = new DataSet();

        OracleParameter[] parm = new OracleParameter[11];
        parm[0]  = RptObj.OracleDBParameter("p_companycode", "WHO", "String", "In");
        parm[1]  = RptObj.OracleDBParameter("p_status", status, "String", "In");
        parm[2]  = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
        parm[3]  = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
        parm[4]  = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
        parm[5]  = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
        parm[6]  = RptObj.OracleDBParameter("p_usr_name", Session["U_NAME"].ToString(), "String", "In");
        parm[7]  = RptObj.OracleDBParameter("p_remitter_name", RemitterName, "String", "In");
        parm[8]  = RptObj.OracleDBParameter("p_bene_address", beneAddress, "String", "In");
        parm[9]  = RptObj.OracleDBParameter("p_file_name", FileName, "String", "In");
        parm[10] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
        dt       = RptObj.Oracle_GetDataSetSP("sp_mispayment_who", parm).Tables[0];
        string totalstub = dt.Rows.Count.ToString();

        return(dt);
    }