外部程序读取Powerbuilder的数据窗口数据的方法

最新推荐文章于 2020-12-04 10:35:31 发布

原创最新推荐文章于 2020-12-04 10:35:31 发布 · 9k 阅读

5 ·

CC 4.0 BY-SA版权

文章标签：

#powerbuilder #exception #dialog #api #button #filter

WINDOWS API 编程专栏收录该内容

1 篇文章

订阅专栏

本文介绍了如何通过调用Powerbuilder数据窗口的API来实现数据的导出。首先，需要获取数据窗口的句柄，这可以通过工具如Spy++或SpyLite24完成。接着，利用SendMessage函数发送特定消息1305，即可触发数据窗口的导出文件功能。在C#中，可以创建Win32API类并调用其SendMessage方法来实现这一操作。若句柄不正确，操作将失败并提示错误信息。

一、原理

PB数据窗口有一个导出文件的函数，通过调用API向数据窗口传递特定的消息，它就乖乖的弹出一个导出数据文件的窗口了。

二、实现步骤

1、获取数据窗口的句柄。使用spy++工具获取，或者使用工具SpyLite24（http://www.asanscape.com/可以免费下载）

2、调用让数据窗口导出文件的消息。SendMessage(pbdw_handle, 1305, 0, 0)

三、C#代码

    public class Win32API
    {
        [DllImport("user32.dll", CharSet=CharSet.Auto)]
        public static extern int SendMessage(IntPtr hWnd, int msg, int wParam, int lParam);
    }

调用示例：

           private void button_Click(object sender, EventArgs e)
        {
            try
            {

IntPtr mwh = (IntPtr)Convert.ToInt32(tbPBDWHandle.Text);
int result = Win32API.SendMessage(mwh, 1305, 0, 0);

                if (result == 0)
                {
                    MessageBox.Show("操作失败！请确定数据窗口句柄是否正确！");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }

四、PBDW的其他函数和查看资料

How to manipulate Datawindow without using datawindow functions.

// I test only on PowerBuilder 6.5 build 444

long ll_dw_handle
ll_dw_handle = handle(dw_1)

Function	Power script
Retrieve	Post(ll_dw_handle, 1306, 0, 0) Post(ll_dw_handle, 1320, 0, 0)
ScrollNextPage	Post(ll_dw_handle, 1318, 0, 0)
ScrollPriorPage	Post(ll_dw_handle, 1319, 0, 0)
ScrollToFirstPage	Post(ll_dw_handle, 1315, 0, 1) // 1 = first row?
ScrollToLastPage	Post(ll_dw_handle, 1315, 0, 99999999) // 99999999 = last page ? pb6 programmer don't know how to get the last page :)
Sort Dialog	Post(ll_dw_handle, 1309, 0, 0)
Filter Dialog	Post(ll_dw_handle, 1311, 0, 0)
DeleteRow	Post(ll_dw_handle, 1357, 0, 0) Post(ll_dw_handle, 1307, 0, 0)
Append Row	Post(ll_dw_handle, 1357, 0, 0) Post(ll_dw_handle, 1312, 0, 0) Post(ll_dw_handle, 1315, 0, dw_1.rowcount() + 1) Post(ll_dw_handle, 1325, 0, 0)
InsertRow	Post(ll_dw_handle, 1357, 0, 0) Post(ll_dw_handle, 1313, 0, 0) Post(ll_dw_handle, 1312, 0, dw_1.getrow()) Post(ll_dw_handle, 1315, 0, dw_1.getrow()) Post(ll_dw_handle, 1325, 0, 0)
Update	Post(ll_dw_handle, 1357, 0, 0) Post(ll_dw_handle, 1338, 0, 0) Post(ll_dw_handle, 1304, 0, 0)
SaveAs Dialog	Post(ll_dw_handle, 1338, 0, 0) Post(ll_dw_handle, 1305, 0, 0)
Print	Post(ll_dw_handle, 1303, 0, 0)
Retrieve (yield)	Post(ll_dw_handle, 1306, 1, 0) Post(ll_dw_handle, 1320, 0, 0)
Cancel	Post(ll_dw_handle, 1320, 0, 0)