1:服务端反写付款单【付款日期】
//服务端反写付款单【付款日期】
var imp = JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.util.app);
with(imp){
//时间日期转换成 string
var formatDate = function (date) {
var y = date.getFullYear();
var m = date.getMonth() + 1;
m = m < 10 ? ('0' + m) : m;
var d = date.getDate();
d = d < 10 ? ('0' + d) : d;
var h = date.getHours();
var minute = date.getMinutes();
minute = minute < 10 ? ('0' + minute) : minute;
var second= date.getSeconds();
second = minute < 10 ? ('0' + second) : second;
return y + '-' + m + '-' + d+' '+h+':'+minute+':'+ second;
};
var date=new Date();
date=formatDate(date);
var tblMain = pluginCtx.getKDTable("tblMain");
var row=null,block=null;
if(tblMain.getRowCount() != 0 || tblMain.getSelectManager().size() != 0){
var size=tblMain.getSelectManager().size();//获取选中总块数
for(var k=0;k<size;k++){
block=tblMain.getSelectManager().get(k);//获取第 i 个块
for (var j=block.getTop();j<=block.getBottom();j++){
//JUIAAABMAp1AKE6B','JUIAAABMAplAKE6B','JUIAAABMApVAKE6B'
row=tblMain.getRow(j);
var billId= row.getCell("id").getValue();
var sql = "update T_CAS_PaymentBill SET fpayDate={ts