DynamnicQuery for BAQ

全栈程序员-站长 • 2022年6月16日下午2:46 • 未分类 • 阅读 23

大家好，又见面了，我是你们的朋友全栈君。

文章转自:https://pastebin.com/9CsF6uEC

// DynamnicQuery for BAQ

Epicor.Mfg.Core.Session epiSession = default(Epicor.Mfg.Core.Session);

epiSession = (Epicor.Mfg.Core.Session)POEntryForm.Session;

DynamicQuery dynamicQuery = new Epicor.Mfg.BO.DynamicQuery(epiSession.ConnectionPool);

//Build Data Set

QueryExecutionDataSet executionDS = new QueryExecutionDataSet();

//Build parametors

QueryExecutionDataSet parameters = new QueryExecutionDataSet();

DataRow paramRow = parameters.ExecutionParameter.NewRow();

paramRow[“ParameterName”] = “POSuggestionsView.PartNum”;

paramRow[“ParameterValue”] = “10050886”;

paramRow[“ValueType”] = “nvarchar(50)”;

paramRow[“IsEmpty”] = “False”;

paramRow[“RowIdent”] = “”;

paramRow[“RowMod”] = “”;

paramRow[“DBRowIdent”] = new byte[0];

parameters.ExecutionParameter.Rows.Add(paramRow);

// Out variable which indicates if more results are available (likely for use with topNRecords)

bool hasMoreRecords = false;

//Executed named BAQ with parameter…

DataSet results = dynamicQuery.ExecuteByIDParametrized(“AD-999-SB_POSuggestion”, parameters, “”, 0, out hasMoreRecords);

//Message Each Description….

MessageBox.Show(“Number of rows in Results = ” + results.Tables[“Results”].Rows.Count.ToString());

foreach (DataRow item in results.Tables[“Results”].Rows)

{

MessageBox.Show(“Row Value = ” + item[“POSuggestionsView.PartNum”].ToString());

}

//******************************************************************************************************

// DynamnicQuery for BAQ
        Epicor.Mfg.Core.Session epiSession = default(Epicor.Mfg.Core.Session);
        epiSession = (Epicor.Mfg.Core.Session)POEntryForm.Session;
        DynamicQuery dynamicQuery = new Epicor.Mfg.BO.DynamicQuery(epiSession.ConnectionPool);
        //Build Data Set
        QueryExecutionDataSet executionDS = new QueryExecutionDataSet();
        //Build parametors
        QueryExecutionDataSet parameters = new QueryExecutionDataSet();
        DataRow paramRow = parameters.ExecutionParameter.NewRow();
        paramRow[“ParameterName”] = “POSuggestionsView.PartNum”;
        paramRow[“ParameterValue”] = “10050886”;
        paramRow[“ValueType”] = “nvarchar(50)”;
        paramRow[“IsEmpty”] = “False”;
        paramRow[“RowIdent”] = “”;
        paramRow[“RowMod”] = “”;
        paramRow[“DBRowIdent”] = new byte[0];
        parameters.ExecutionParameter.Rows.Add(paramRow);
        // Out variable which indicates if more results are available (likely for use with topNRecords)
        bool hasMoreRecords = false;
        //Executed named BAQ with parameter…
        DataSet results = dynamicQuery.ExecuteByIDParametrized(“AD-999-SB_POSuggestion”, parameters, “”, 0, out hasMoreRecords);
        //Message Each Description….
        MessageBox.Show(“Number of rows in Results = ” + results.Tables[“Results”].Rows.Count.ToString());
        foreach (DataRow item in results.Tables[“Results”].Rows)
        {

            MessageBox.Show(“Row Value = ” + item[“POSuggestionsView.PartNum”].ToString());
    }