是以个trigger按钮 触发同步A表数据到B表页面
mainActivity.trigger9Click = function(event){
if(""==staticygh){alert("请选择人员"+staticygh);
return;
}
var table=null;
// 查询出计划表里面的所有数据
var actionParam = new justep.Request.ActionParam();
actionParam.setString("ygh",staticygh);
justep.Request.sendBizRequest2({
action:"findjhxxAction",
dataType: "json",
parameters :actionParam,
callback: function(result){
if(result.state){
table =result.response;
// alert(table.rows[0].IDS.value);
}
}
});
var xxsum=0;
var actionParam2 = new justep.Request.ActionParam();
actionParam2.setString("ygh",staticygh);
justep.Request.sendBizRequest2({
action:"findjhxxSumAction",
dataType: "json",
parameters :actionParam2,
callback: function(result){
if(result.state){
xxsum =result.response;
//alert(xxsum);
}
}
});
if(xxsum==0){
alert("该员工本周无工作计划");
return;
}
//获取查询的信息数量
var now = new Date();
var month= now.getMonth()+1;
var date = now.getDate()-1;
var nowtime = now.getFullYear()+'-'+month+'-'+date;
var data=justep.xbl('bizData1');
for(var i=0;i<xxsum;i++){
//alert(table.rows[i].IDS.value);
//获取数据源
var options = {
//index : data.getCount(),
//插入行数据
defaultValues : [
{fXXSSTD:table.rows[i].JHSSTD.value,fXXJHRQ:table.rows[i].JHJSSJ.value,fXXNR:table.rows[i].JHNR.value,fXXLB:table.rows[i].JHLX.value,fXXQZ:table.rows[i].JHQZ.value,fXXYGH:table.rows[i].JHYGH.value,fXXYGXM:table.rows[i].JHYGXM.value,fXXSJSJ:nowtime,fXXJHSJID:table.rows[i].IDS.value},
]
};
data.newData(options);
// data.refreshData();
//设置生成计划的数据的2列和3列为只读 //设置的是rowid这行的第3列的type为ro为只读,ed为可编辑
var grid = justep.xbl('grid2');
var data = justep.xbl('bizData1');
var rowid = data.getCurrentID();
grid.grid.setCellExcellType(rowid,1,"ro");
grid.grid.setCellExcellType(rowid,2,"ro");
}
};
对应的后台java方法代码
public static Table findjhxx(String ygh) {
String zhouqujians = finweek7day();
String[] zhouqujian = zhouqujians.split(",");
//System.out.println(zhouqujian[0]+"===="+zhouqujian[1]);
//and a.fJHJSSJ >= stringToDate('" + zhouqujian[0] + "') and a.fJHJSSJ <= stringToDate('" + zhouqujian[1] + "')
String sql = "select a.fID as IDS, a.fJHJSSJ as JHJSSJ, a.fJHNR as JHNR,a.fJHYGH as JHYGH,a.fJHYGXM as JHYGXM,a.fJHLX as JHLX ,a.fJHQZ as JHQZ,a.fJHSSTD as JHSSTD from yt_tdkb_jhb a where a.fJHYGH = '"
+ ygh + "' ";
sql += "and a.fJHJSSJ >= to_date('" + zhouqujian[0] + "','yyyy-mm-dd') and a.fJHJSSJ <= to_date('" + zhouqujian[1] + "','yyyy-mm-dd') ";
HashMap<String, String> sqlMap = new HashMap<String, String>();
sqlMap.put(DatabaseProduct.ORACLE.name(), sql);
Table table = SQL.select(sqlMap, null, dataModel);
//Iterator<Row> rows2 = table.iterator();
System.out.println(sql + "我的数是多少");
// rs2.setInt("xxsum", xxsum);
// System.out.println(findjhxxSum(ygxm)+"我的数是多少");
return table;
}