大家好,又见面了,我是你们的朋友全栈君。
// 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()); } 转自:https://stackoverflow.com/questions/17566099/modifying-baq-to-query-with-parameters?answertab=oldest#tab-top
发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/149959.html原文链接:https://javaforall.cn
【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛
【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...