DynamnicQuery for BAQ
来源:互联网 发布:迅龙数据恢复免费版 编辑:程序博客网 时间:2024/06/05 14:34
// DynamnicQuery for BAQ
}
//******************************************************************************************************
// 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
- Modifying BAQ to query with parameters
- VB.NET Epicor BAQ VS Connection to a Progress Server
- for
- for
- for
- for
- for
- for
- for
- for
- for
- for
- for(;;)
- for
- for
- for
- for
- 读 Effective java
- 多目标进化优化的Tchebycheff分解方法
- Android Support Library介绍
- Python 学习 基础篇
- [1-9]*匹配数字存在漏洞之解决办法
- DynamnicQuery for BAQ
- 数据库插入记录返回自增id
- ambari系列--报错问题
- 数据表_事物码(Transaction Code)信息
- 1041. 考试座位号(15)
- hbuilder项目总结:页面跳转
- 【机器学习算法】流形学习笔记一:Isomap
- android 编译类型
- 6.0权限如何一直提示