问题描述
假设我有一个名为LocalDB的微软访问数据库，只有一个名为Items的表。
，我还有预订管理软件。软件总是插入，更新和删除项目中的记录。
现在，除了该软件，我有一个外部软件，我们将其命名为smsCenter。
smsCenter等待更改为LocalDB \Items中的佣人，并且该特定更改由sms发送给用户。这是一个例子：
用户获得一个界面，通过该界面他可以选择要跟踪更改的类别。让我们假设他选择价格。
我现在将我的商品价格从0.99 $更新为1.99 $。 项目中的价格字段从0.99更改为1.99。 smsCenter捕捉到了这一变化并将下一个短信发送给用户：亲爱的用户，产品编号552356的价格从0.99更新到1.99。
所以，我需要听听项目表。为此，我需要构建一个界面，用户可以通过该界面选择要遵循的类别和要选择的参数（例如：如果价格低于x或更高，则获取短信？）。
现在，最重要的是我不能对我的预订软件做任何改动。我们的软件包含150万个代码行，改变它是不可能的（同样，它用vb6编写）。所以，我需要构建一个接口，该接口将在我的LocalDB中创建datamacro。数据宏将侦听选择字段中的更改，并将更改写入名为TempTriggers的特定表。 smsCenter将收听TempTriggers并发送短信。我的一个大问题是如何使用vb.net编写的界面编写数据宏来访问数据库？
我知道我的问题并不是关注一件事，而是一个大话题但我需要知道从哪里开始。任何人都可以告诉我是否有办法使用vb.net生成宏代码？
希望我足够清楚：）
assuming i have microsoft access database called "LocalDB" with just one table called "Items".
also, i have software for booking managment. the software always insert, update and delete records from "Items".
Now, beside that software, i have an external software and we name it "smsCenter".
the "smsCenter" wait for changes to be maid in "LocalDB\Items", and that specific change is sent by sms to the user. here's an example:
the user gets an interface through which he can choose the category to follow changes. lets assume he choose "Price".
i just now update my item price from 0.99$ to 1.99$. the field "Price" in "Items" changed its value from 0.99 to 1.99. "smsCenter" catches that change and send the next sms to the user: "Dear user, the price for item no. 552356 updated from 0.99 to 1.99".
so, i need to listen to changes in the "Items" table. for that, i need to build an interface through which the user could choose the category to follow and the parameter to choose (e.g: get sms if price lower then x or higher?).
Now, the most important thing is that i can not do any changes in my booking software. our software include 1.5 milion code lines and it is immposible to change it (also, its written in vb6). so, i need to build an interface and that interface will create datamacro in my "LocalDB". the data macro will listen to changes in the choosen field and write the change to specific table called "TempTriggers". the "smsCenter" will listen to "TempTriggers" and send the sms. my big question is how can i write data macro to access database using an interface written in vb.net?
I am aware that my question is not focused on one thing certain and that a big topic but I need to know where to start. Can anyone tell me if there is a way to generate macro code using vb.net?
hope i was clear enough :)
推荐答案
这篇关于如何使用vb.net生成datamacro？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！