|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sap-business-one-coding-with-sdk-blazor-visual-studio-22/
课程评论：没有评论
**课程总结：SAP Business One: 使用 SDK 和 Blazor 进行编码 (Visual Studio 2022)** 本课程专注于利用 Visual Studio 2022 和 Razor 技术进行下一代 Web 开发，将开发工作划分为服务器端和客户端。 **核心内容：** * **Razor 架构：** 服务器端使用 C# 代码执行数据库查询，并将结果存储在对象列表中。客户端 Razor HTML 页面则遍历此列表，以表格形式展示查询结果。 * **SAP Business One SDK 集成：** 课程涵盖如何在 Visual Studio IDE 中添加 SAP Business One SDK 库。 * **数据库连接：** 详细解释连接到 SAP Business One 数据库的参数，并以 HANA 数据库为例进行演示（也提及 SQL Server 和 Sybase）。 * **数据呈现：** 强调 Razor 架构要求将查询结果存储在对象列表中，并通过 Razor HTML 循环遍历以表格形式（包含表头和详细信息）展示。 * **跨页面参数传递：** 演示如何将参数传递到另一个 Razor 页面，以动态值执行新的查询。具体例子包括传递发票的单据编号和客户往来的应收账款信息，以获取最新的付款记录。 * **SDK 查询注意事项：** 强调在 SAP Business One SDK 查询中，“撇号”（'）需要使用转义字符（"）进行处理，因为表名和字段名需要指定，而字段名是用撇号括起来的。
This course is in the next generation of web development using Visual Studio 2022 with Razor technology. Razor separates the development into the server and client tiers. The server C# code executes the query and stores results in a list type of objects. The client Razor HTML page loop thru this list to display the query results in table elements. We will cover the addition of the Business One SDK library to the Visual Studio IDE. Explanation of the parameters to connect to the database. In this exercise, we are using a Hana-type database for Business One. B1 can use SQL server and Sybase as databases. Razor architecture requires storing the query database results in a list type of objects. This list is looping in the Razor HTML side to present the results in table elements with headings and details. Pass parameter to another Razor page to run another query with a dynamic value. In this example, we pass the document number of an invoice and account receivable from a client to get the payments done up to date. It is important to keep in mind that the queries in B1 SDK must have an escape character of the apostrophes ("). That is because we have to specify the table name and the field name. The field name is enclosed in apostrophes.
