8wDlpd.png
8wDFp9.png
8wDEOx.png
8wDMfH.png
8wDKte.png
关于ExtJS和V8的的一些方法 V8
admin 2023-2-19

以下在V8中试验可行

SELECT a.* ,B.BOOK_CODE,B.BANK_CODE_XY
FROM LMCONFIG.T_BANK_BRANCH_INFO A
LEFT JOIN LMCONFIG.T_BANK_INFO B
ON A.BANK_ID = B.BANK_ID
WHERE A.BANK_BRANCH_ID={?I_BANK_BRANCH_ID?}
app.run("{call LMCONFIG.P_LM108150_A({?ENTITY_ID?},{?BUSI_DATE?},{?DEPT_ID?},{?ORDERDATE?},{?CONTRACT_ID?},{?CONTRACT_CODE?},{?CONTRACT_TYPE?},{?CONTRACT_NAME?},{?CONTRACT_DESC?},{?FUND_ID?},{?BUSI_SUM?},{?MONEY_TYPE?},{?RECEIVE_ACCOUNT_ID?},{?RECEIVE_ACCOUNT_CODE?},{?RECEIVE_ACCOUNT_BANK?},{?RECEIVE_ACCOUNT_NAME?},{?RESERVE_AMOUNT?},{?RESERVE_PURPOSE?},{?PROCESS_ID?},{?I_HANDLE_STATUS?},{?SOURCE_CODE?},{?COMMENT_TEXT?},{?sys.username?},{?REPAY_DATE?},{?ASS_ID?},{?EVENT_ID?},{?PK_ID?},{?@O_RETURN_MSG?},{?@O_RETURN_CODE?})}");
    Ext.Msg.show({
      title:'大额资金预约事项待处理',
      icon:Ext.Msg.INFO,
      msg:'test',
      buttons: Ext.Msg.OKCANCEL,
      modal:false,
      fn:function(id){
        if ( id == 'ok'){
        Wb.open({url:'m?xwl=liquidity_fxgl/capital_transfer/LM108150',inframe:true,title:'大额资金预约'});
      }
      }
    });

{#sys.username#}

  Wb.request({
    url: 'm?xwl=liquidity_fxgl/account_management/bank_account/P_LM403500_Q/branch_bank_name',
    params: {
      I_BANK_BRANCH_ID: newValue
    },
    success: function(resp) {
      var row = Wb.decode(resp.responseText).rows[0];
 
      if (row)
        Wb.setValue(app.addWin, {
          I_BANK_BRANCH_PHONE_NO: row.BANK_BRANCH_PHONE_NO,
          I_BANK_BRANCH_CONTACT_INFO: row.BANK_BRANCH_CONTACT_INFO,
          I_LARGE_PAYMENT_NO: row.LARGE_PAYMENT_NO
        });
    }
  });



//  每5分钟提示一次有大额资金预约事项待处理
    var task = {
      run: function() {
        Wb.request({
          url: 'm?xwl=liquidity_fxgl/capital_transfer/LM108150/select_task',
          params: {
            I_USER_ID: '{#sys.username#}'
          },
          showMask: false,
          success: function(resp) {
           var data = Wb.decode(resp.responseText);
            if (data.total > 0) {
    Ext.Msg.show({
      title:'大额资金预约事项待处理',
      icon:Ext.Msg.INFO,
      msg:'<div style="font-size:14px;line-height:20px; letter-spacing:2px; padding:4px 0 4px 5px;">' + data.rows[0].NAME + "您有大额资金预约事项待处理!",
      buttons: Ext.Msg.OKCANCEL,
      modal:false,
      fn:function(id){
        if ( id == 'ok'){
        Wb.open({url:'m?xwl=liquidity_fxgl/capital_transfer/LM108150',inframe:true,title:'大额资金预约'});
      }
      }
    });
	// Ext.Msg.setXY([Ext.Element.getViewportWidth() - 360,Ext.Element.getViewportHeight() - 150]);
    }
	}
    });
	},
	interval: 1000 * 60 * 5 //5分钟定时执行一次
    };
    var taskRunner = new Ext.util.TaskRunner();
    taskRunner.start(task);

加载数据有回调

var rec, recs = app.dataGrid.getSelection();
Cs.info(recs);
if (recs.length != 1) {
    
    app.dataStore1.load({params:{
      I_BEGIN_DATE:Wb.getVal(app.panel1,'I_BEGIN_DATE'),
      I_END_DATE:Wb.getVal(app.panel1,'I_END_DATE'),
      I_ACCOUNT_CODE:''
    },
     callback:function(records,operation,success){
        var data = {};
        data.params1 = Wb.getData(app.dataGrid1);
        Wb.mask(null, '处理中,请稍候...');
        Wb.getExcel(data, 'dx_export/银行存款收益明细导出.xlsx', '', ' 银行存款收益明细');
        setTimeout(function() {
          Wb.unmask(null, '处理中,请稍候...');
        }, 3000);

      }
    });
}

grad点击效果

修改 renderer
if (record.data.IS_EXIST == '1')
  return '<button type="button" method="hrefMethod" onclick="Wb.invoke(this,\'' + record.data.PK_ID + '\');">划拨</a>';
else
  return '';

[["a","b"],["c","d"]]

计划任务

Packages.cn.hutool.http.HttpUtil.createPost("http://10.xxx.xxx.xxx:8080/ks/m?xwl=xxx/sms_task").charset("UTF-8").execute();

非空字段校验

if(Wb.verify(app.addWin)){

// 。。。逻辑部分

}
最后于 2023-10-26 被admin编辑 ,原因: 增加非空校验
最新回复 (1)
    • 朕弟分享 | 专注小众,乐于分享!
      3
          
返回
发新帖 搜索 反馈 回顶部