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

本文介绍了如何通过调用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
RetrievePost(ll_dw_handle, 1306, 0, 0)
Post(ll_dw_handle, 1320, 0, 0)
ScrollNextPagePost(ll_dw_handle, 1318, 0, 0)
ScrollPriorPagePost(ll_dw_handle, 1319, 0, 0)
ScrollToFirstPagePost(ll_dw_handle, 1315, 0, 1) // 1 = first row?
ScrollToLastPagePost(ll_dw_handle, 1315, 0, 99999999) // 99999999 = last page ? pb6 programmer don't know how to get the last page :)
Sort DialogPost(ll_dw_handle, 1309, 0, 0)
Filter DialogPost(ll_dw_handle, 1311, 0, 0)
DeleteRowPost(ll_dw_handle, 1357, 0, 0)
Post(ll_dw_handle, 1307, 0, 0)
Append RowPost(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)
InsertRowPost(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)
UpdatePost(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)
PrintPost(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)

 

 

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值