WEB端脚本

℡♡℡

已于 2023-06-09 15:04:11 修改

阅读量709

点赞数

文章标签： java servlet 开发语言

于 2022-09-08 11:08:49 首次发布

本文链接：https://blog.csdn.net/qq_44730233/article/details/126758574

版权

//弹框
_self.showWarning("请先填写实付金额");
console.log("跳转的id:"+billIds);

//弹选择框
waf.msgBox.showConfirm({
    title: "信息提示",
    summaryMsg: "是否删除",
    buttonType: "yes-no",
    buttonCallBack: [
        function () {
            console.log("是");
        },
        function () {
            console.log("否");
        }]
});


//脚本中方法之间调用 
_private.selectSourceBillId();

//获取id
var model = _self.getCurrentModel();

//设置值
1、var su = $("#list2").wafGrid('addRow',{data:datarow});
2、waf("#id").wafText("setValue", "this is a demo!");
//设置值：分录指定行
1、$("#entrys").wafGrid("setCell",rowid,"ywy",ywy2[0]);
2、分录指定行清空
$("#editGrid2").wafGrid("setCell",rowid2,"fundFlowItem",null);
//获取Model值
var sourceBillId =_self.getCurrentModel().entrys[0].sourceBillId;
//获取控件值
var text = waf("#text").wafText("getValue");
//获取分录所有数据
var ret = waf("#ext_editgrid1").wafGrid("getAllRowData"); 
//获取行id
var rowId = waf("#entrys").wafGrid("getRowId", 0);

//隐藏按钮
waf("#synchronousApprove_btn").wafLinkButton("option","disabled",true);
document.getElementById('labelaccountCussentTypeEnum').style.visibility = 'visible';
document.getElementById('labelaccountCussentTypeEnum').style.visibility = 'hidden';

//隐藏复选框
waf("#ext_isFgs").wafCheckbox("option","hidden",true); 

//批量隐藏分录
 $("#list2").wafGrid("hideColumn","amount",true);
//批量显示分录
 $("#list2").wafGrid("showColumn ","amount",true);


//控件不可编辑
waf("#id").wafLinkButton("option","editable ",false);

//不可编辑，指定某行不可编辑
var rowId = waf("#entrys").wafGrid("getRowId", (i + 1));
var claimAmountConfig = waf("#entrys").wafGrid("getCellConfig", "claimAmount", rowId);
claimAmountConfig.editable = false;
waf("#entrys").wafGrid("changeCellConfig", rowId, "claimAmount", claimAmountConfig);

//刷新表格
var cuGridDom = waf("#queryGrid");
cuGridDom.dataGrid("reloadGrid");  

//清空分录
  var ret = waf("#list2").wafGrid("clearGridData",true);

//关闭窗口
waf.window.close();

//分录过滤
        //自定义辅助项目过滤非“其他应付项目”
        var ret = waf("#ext_editgrid1").wafGrid("getAllRowData");
        var colConfig = waf("#entrys").wafGrid("getCellConfig", "qtyfxm", rowid).editoptions;
        for (var i = 0; i < ret; i++) {
            var rowId = waf("#entrys").wafGrid("getRowId", i);
            colConfig.subTagJson.filteritem = waf.parseSql.getFilter("group.number", "=", "14");
            waf("#entrys").wafGrid("setCellConfig", "qtyfxm", "editoptions", colConfig, rowId);
        }

//分录某字段统一过滤PS：收款认领单编辑界面
查询过滤条件：group.number='14'


//值改变，分录值改变见下图在该文档最下面

获取分录数据

var allRowData = waf("#ext_editgrid").wafGrid('getAllRowData');
var endorseno = "";
var amount = 0;
for(var i = 0; i < allRowData.length; i++){
	endorseno = endorseno+allRowData[i].endorseno+",";
	amount = amount+allRowData[i].amount;
}

获取当前选中行数据

var gridCol = waf("#editgrid").getSelectedRows();
var ret = jQuery('#editgrid').wafGrid('getRowRealData', gridCol);
alert("当前选中的是："+ret);

后台GetBillEntryAmount，访问数据库

var imp=JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.custom);
imp.importPackage(Packages.java.lang);
imp.importPackage(Packages.org.apache.commons.lang3);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.webframework.context);
imp.importPackage(Packages.com.kingdee.eas.base.permission);
imp.importPackage(Packages.com.kingdee.eas.common);
imp.importPackage(Packages.com.kingdee.eas.basedata.org);
imp.importPackage(Packages.javax.servlet.http);
imp.importPackage(Packages.com.kingdee.eas.util.app);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.dao.ormapping);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.eas.ep);
imp.importPackage(Packages.com.kingdee.bos.metadata);
imp.importPackage(Packages.com.kingdee.bos.util);
imp.importPackage(Packages.com.kingdee.eas.basedata.person);
imp.importPackage(Packages.com.kingdee.bos.webframework.exception);
imp.importPackage(Packages.com.kingdee.bos.webframework.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.application);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.event.view);
imp.importPackage(Packages.com.kingdee.bos.webframework.json);
imp.importPackage(Packages.java.util);
imp.importPackage(Packages.com.alibaba.fastjson);
imp.importPackage(Packages.java.math);
imp.importPackage(Packages.org.apache.log4j);

with(imp){
	var logger = Logger.getLogger("getPaymentBillEntryAmount");
	var request = kdevent.getReqeustContext().getHttpServletRequest();
	var billNumber = request.getParameter("billNumber");
	var sumAmount = request.getParameter("sumAmount");
	var id = request.getParameter("mode");
	var zero = new BigDecimal("0");
	var ctx = WafContext.getInstance().getContext();
	var sqlTwo="";
	var sql ="";
	//查询
	var rowSet = DbUtil.executeQuery(ctx, sql);
	var array = new JSONArray();
	while(rowSet.next()){
		var corebillNumber = rowSet.getString("FCOREBILLNUMBER");
		var bgctrlamt = rowSet.getBigDecimal("sum(b.FAMOUNT)");

	}
	JSONUtils.SUCCESS(array.toJSONString());
	//修改
	if(id != null && id != ""){
    var sql ="DELETE FROM CT_CAS_endorseEntry WHERE  FPARENTID ='"+id+"' and CFAMOUNT is null  and CFENDORSENO is null and CFTICKETID is null and CFTICKETSTYLE is null and CFTICKETDATE is null and CFTICKETUSER is null and CFTICKETBANK is null";
		DbUtil.execute(ctx, sql);  
	}  

}

脚本调用上面后台GetBillEntryAmount

waf.doPost({
	action: "GetBillEntryAmount",
	data:{billNumber:billNumber,sumAmount:sumAmount,mode:mode},
	async: false,
	success:function(result){
		for(var i = 0; i < result.length; i++){
			var coreBillEntryId = result[i].coreBillEntryId;
			var corebillNumber = result[i].corebillNumber;
			var bgctrlamt = result[i].bgctrlamt;
		}
	}
});

var imp=JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.custom);
imp.importPackage(Packages.java.lang);
imp.importPackage(Packages.org.apache.commons.lang3);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.webframework.context);
imp.importPackage(Packages.com.kingdee.eas.base.permission);
imp.importPackage(Packages.com.kingdee.eas.common);
imp.importPackage(Packages.com.kingdee.eas.basedata.org);
imp.importPackage(Packages.javax.servlet.http);
imp.importPackage(Packages.com.kingdee.eas.util.app);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.dao.ormapping);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.metadata);
imp.importPackage(Packages.com.kingdee.bos.util);
imp.importPackage(Packages.com.kingdee.bos.metadata.query.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.exception);
imp.importPackage(Packages.com.kingdee.bos.webframework.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.application);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.event.view);
imp.importPackage(Packages.java.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.json);
imp.importPackage(Packages.com.alibaba.fastjson);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.metadata.entity);


with(imp){
 var ctx = WafContext.getInstance().getContext();
 var view = new  EntityViewInfo();
 var coll=new SelectorItemCollection();
 coll.add(new SelectorItemInfo("id"));
 coll.add(new SelectorItemInfo("name"));
 coll.add(new SelectorItemInfo("number"));
 view.setSelector(coll);
 var filterInfo = new FilterInfo();
 var filterItemInfo = new FilterItemInfo("name","费用共享类型",CompareType.EQUALS);
 filterInfo.getFilterItems().add(filterItemInfo);
 view.setFilter(filterInfo);
 var col = com.kingdee.eas.custom.prpayment.PaymentTypeFactory.getLocalInstance(ctx).getPaymentTypeCollection(view);
 JSONUtils.SUCCESS(col);
}

var imp=JavaImporter();
imp.importPackage(Packages.com.kingdee.eas.custom);
imp.importPackage(Packages.java.lang);
imp.importPackage(Packages.org.apache.commons.lang3);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.webframework.context);
imp.importPackage(Packages.com.kingdee.eas.base.permission);
imp.importPackage(Packages.com.kingdee.eas.common);
imp.importPackage(Packages.com.kingdee.eas.basedata.org);
imp.importPackage(Packages.javax.servlet.http);
imp.importPackage(Packages.com.kingdee.eas.util.app);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.dao.ormapping);
imp.importPackage(Packages.com.kingdee.bos);
imp.importPackage(Packages.com.kingdee.bos.metadata);
imp.importPackage(Packages.com.kingdee.bos.util);
imp.importPackage(Packages.com.kingdee.bos.metadata.query.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.exception);
imp.importPackage(Packages.com.kingdee.bos.webframework.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.application);
imp.importPackage(Packages.com.kingdee.bos.webframework.dynamic.event.view);
imp.importPackage(Packages.java.util);
imp.importPackage(Packages.com.kingdee.bos.webframework.json);
imp.importPackage(Packages.com.alibaba.fastjson);
imp.importPackage(Packages.com.kingdee.eas.basedata.assistant);
imp.importPackage(Packages.com.kingdee.bos.metadata.entity);


with(imp){
 var ctx = WafContext.getInstance().getContext();
 var request = kdevent.getReqeustContext().getHttpServletRequest();
 var paymentId = request.getParameter("paymentId");
 var paymentBillInfo =com.kingdee.eas.fi.cas.PaymentBillFactory.getLocalInstance(ctx).
     getPaymentBillInfo(new com.kingdee.bos.dao.ormapping.ObjectUuidPK(paymentId));
 var req = com.kingdee.eas.custom.fundplan.FundplanFacadeFactory.getLocalInstance(ctx).
    closingRemindPaymentBill(paymentBillInfo);
 JSONUtils.SUCCESS(req);
}

web监听（值改变）