webbuilder搜索

module.initialize下

qryData:function(){
//获取toolbar1下的remark和date
   remark = Wb.getVal(app.toolbar1, "remark");
    date = Wb.getVal(app.toolbar1, "date");
   console.log(remark + date + "dd");
   var req = {
//服务器端传参数
      params: {remark:remark }
    };
    //更新到store中
    app.grid1.store.load(req);
  }

然后写一个store,指定到xwl
然后再module下加一个dataprovider
sql语句写

{#sql#}

然后再module的serverScript中写运行代码

获取到整个app
var params = app.get();
//定义数组
var whereArray = [];
//定义查询条件
var where = "";
//语句查询
var sql = "select * from tab_auto_watch_import";
//如果不为空
if(!Wb.isEmpty(params['remark'])){
  //把(remark)写成参数,等待传递
  whereArray.push(" remark like concat('%',{?remark?},'%') ");
}

if (whereArray.length > 0) {
  where =" where "+ whereArray.join(" and ");
}else{
  where = " where  1=1 ";
}

//运行sql语句
request.setAttribute('sql', sql + where );