#include "apdefap.h"

void OnClick(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName)

{





__object *cn, *rs;

char cquery[200];

cn = __object_create("ADODB.Connection");

rs = __object_create("ADODB.RecordSet");

if(NULL==cn)

MessageBox(NULL,"创建连接失败","失败",MB_OK);

cn->Open("DSN=WinCCs cripting");

if (cn->State==0)

MessageBox(NULL,"连接数据库失败","失败!",MB_OK);

else {

sprintf(cquery,"select * from table1 where weihao='%s'",GetTagChar("sousuo_weihao"));//格式化查询字符串

rs->Open(cquery, cn,1);



if (!rs->eof)

{

SetPictureName("主画面.Pdl","画面窗口1",rs->Fields(1)); //rs->Fields(1)获取的是相应的画面名称

}

else

{

MessageBox(NULL,"你输入的位号不对","请重新检查",MB_OKMB_ICONQUESTION);

}



}

rs->Close;

cn->Close;


}