1、绑定工作流:
INSERT INTO `base_codeclass` VALUES (null, 'PM_CGSQ', '采购申请', null, null, null, '2018-09-14 09:19:22', '0', null, null, null, '1');
2、界面显示:
(1)加载:
var loadMask = new Ext.LoadMask({target:Ext.getBody()});
loadMask.show();
loadMask.hide();
(2)提示:
Ext.extmdmmsg.msg(OperTip.ERROR, '该条记录已完成审核!');
Ext.extmdmmsg.msg(OperTip.WARN, '请添加附件后提交');
Ext.extmdmmsg.msg(OperTip.SUCCESS, i18n['common.message.uploadsuccess'] || '上传成功');
3、ext.js
(1)获取baseParams:
var baseParams = Ext.getCmp('grid_cggcInfos').getBaseParams();
var v_querytype = baseParams['cond.querytype'];
(2)获取选择的grid记录并返回
var records = Ext.getCmp('grid_cggcInfos').getSelectionModel().getSelection();
var vdata = records[0].getData();
var record = {
'cggccode':vdata.cggccode,
}
WIN.returnValue(record);
<1>数据返回到form:
var win = WIN.showModalDialog('/pm/cgglx/cggc/cggc_list_multi.exml',null,function(record){
if(record){
var v_form = Ext.getCmp('form_cghtInfo');
v_form.getField('cggccode').setValue(record.cggccode);
}
});
<2>数据返回到grid:
var win = WIN.showModalDialog('/pm/cgglx/cgsq/cgsq_select_multi.exml?'+args,null,function(vrecords){
if(vrecords){
var cggcmxGrid = Ext.getCmp('grid_cggcmxInfos');
var index = cggcmxGrid.getAllRecords();
for ( var i = index.length; vrecords && i < vrecords.length + index.length; i++) {
cggcmxGrid.insertRow(i);
cggcmxGrid.getRecordByIndex(i).set('cgsqcode',vrecords[i - index.length].cgsqcode);
}
}
});
(3)获取所有的grid数据:
var v_grid_cggcmxInfos = Ext.getCmp('grid_cggcmxInfos').getAllRecords();
(4)得到form表单某个Field的值:
var cggcid = Ext.getCmp('form_cggcInfo').getField('cggcid').getValue();
(5)得到表中某个grid的值:
var info = Ext.getCmp('grid_cggcmxInfos').getLastSelected();
var sl = info.get('sl');
(6)对Float型数据保留两位小数
parseFloat(sl*dj).toFixed(2)
4、拼装ajax中的params
var vroot = "cggcInfos";
var vjson = Ext.JSON.encode(Ext.getCmp('form_cggcInfo').getValues());
var vparams = { jsonString : "{\"" + vroot + "\":" + vjson + "}" };
5、触发器
CREATE TRIGGER `new_cghtinfo` AFTER INSERT ON `pm_cggc` FOR EACH ROW begin
if NEW.cghtflag ='否' then
INSERT INTO pm.pm_cght (cghtcode,cggccode, cggcmc, cglx, cgygje, gysmc, cgxs, recordercorp, recordercode, recorderdesc,
recordtime, mobile, workflowid, submitcorp, auditflag, auditorcode, audittime, auditordesc, auditlevel, auditlevelname)
VALUES ( NEW.cggccode, NEW.cggccode, NEW.cggcmc, NEW.cglx, NEW.cgygje, NEW.gysmc, NEW.cgxs, NEW.recordercorp, NEW.recordercode, NEW.recorderdesc,
NEW.recordtime, NEW.mobile, NEW.workflowid, NEW.submitcorp, NEW.auditflag, NEW.auditorcode, NEW.audittime, NEW.auditordesc, NEW.auditlevel, NEW.auditlevelname);
end if;
end;
6、grid根据行号清除数据
var ds = grid.getStore();
var selectedRow = ds.getAt(v);
if (selectedRow){
ds.remove(selectedRow);
}
转载于:https://www.cnblogs.com/manu24/p/10190360.html