首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >如何在syncfusion vue js数据网格中使用计算字段

问如何在syncfusion vue js数据网格中使用计算字段
EN

Stack Overflow用户
提问于 2020-05-12 22:28:54
回答 2查看 692关注 0票数 1

如何在syncfusion vue js数据网格中使用计算值?

例如

假设我有5列:数量、物料需求计划、折扣、折扣价格、合计。我想从给定的值MRP和折扣中计算折扣价格。并且还想从给定的价值数量和折扣价格计算总金额。

我如何在syncfusion vue js databgrid中实现这一点呢?提前感谢您的帮助。

EN

回答 2

Stack Overflow用户

发布于 2020-05-12 22:34:48

您可以阅读有关默认vue计算值的信息,并将v-bind:value='computedProperty'添加到需要计算的单元格中。如果您在代码中提供了沙箱,我将尝试为您提供更多帮助。

票数 0
EN

Stack Overflow用户

发布于 2020-06-01 12:25:11

我们了解到,在初始页面加载中,您喜欢根据其他三个字段的值来计算总价格和折扣价格。根据您的查询,我们准备了一个样例,并使用queryCellInfo event实现了您的要求。

代码语言:javascript
复制
var templateGrid = Vue.component('ShowerTemplateList', { 
        template: ` 
                <ejs-grid ref='grid' id='grid' :dataSource="data" :columns='columns' 
                    :editSettings='editSettings' :toolbar='toolbar' :queryCellInfo='queryCellInfo' :actionComplete='actionComplete'> 
                </ejs-grid> 
            `, 
        `data: function () { 
            return { 
                data: new ej.data.DataManager({ 
                    url: "/Home/UrlDatasourceone", 
                    updateUrl: "Home/Updateone", 
                    insertUrl: "Home/Insertone", 
                    removeUrl: "Home/Removeone", 
                    adaptor: new ejs.data.UrlAdaptor() 
                }), 
                columns: [ 
                    { field: 'OrderID', headerText: 'ID', isPrimaryKey: true, width: 100 }, 
                    { field: 'Quantity', headerText: 'Quantity', width: 100 }, 
                    { field: 'MRP', headerText: 'MRP', width: 100 }, 
                    { field: 'Discount', headerText: 'Discount', width: 100 }, 
                    { field: 'Discountprice', headerText: 'Discount price', width: 100 }, 
                    { field: 'Total', headerText: 'Total', width: 100 } 
                ], 
                editSettings: { 
                    allowEditing: true, 
                    allowAdding: true, 
                    allowDeleting: true, 
                    mode: "Normal" 
                }, 
                toolbar: ["Add", "Edit", "Delete", "Update", "Cancel"] 
            } 
        }, 
        methods: { 
            actionComplete: function (args) { 
                if (args.requestType === "beginEdit") { 
                    var grid = document.getElementsByClassName("e-grid")[0] 
                        .ej2_instances[0]; 
                    grid.editModule.formObj.element[1].addEventListener("keyup", function ( 
                        e 
                    ) { 
                       var grid = document.getElementsByClassName("e-grid")[0] 
                            .ej2_instances[0]; 
                        var Totalquantity = +e.target.value; 
                        var GivenMrp = +grid.editModule.formObj.element[2].value; 
                        var Discount = +grid.editModule.formObj.element[3].value; 
                        var offerprice = (GivenMrp * Discount) / 100; 
                        var Res = GivenMrp - offerprice; 
                        grid.editModule.formObj.element[5].value = Res * Totalquantity; 
                    }); 
                    grid.editModule.formObj.element[2].addEventListener("keyup", function ( 
                        e 
                    ) { 
                        //For calculating price 
                        var grid = document.getElementsByClassName("e-grid")[0] 
                            .ej2_instances[0]; 
                        var GivenMrp = +e.target.value; 
                        var Totalquantity = grid.editModule.formObj.element[1].value; 
                        var Discount = +grid.editModule.formObj.element[3].value; 
                        var offerprice = (GivenMrp * Discount) / 100; 
                        var discountprice = GivenMrp - offerprice; 
                        grid.editModule.formObj.element[4].value = discountprice; 
                        grid.editModule.formObj.element[5].value = 
                            Totalquantity * discountprice; 
                    }); 
                    grid.editModule.formObj.element[3].addEventListener("keyup", function ( 
                        e 
                    ) { 
                       var grid = document.getElementsByClassName("e-grid")[0] 
                            .ej2_instances[0]; 
                        var discount = +e.target.value; 
                        var GivenMrp = +grid.editModule.formObj.element[2].value; 
                        var Totalquantity = grid.editModule.formObj.element[1].value; 
                        var offerprice = (GivenMrp * discount) / 100; 
                        var prc = GivenMrp - offerprice; 
                        grid.editModule.formObj.element[4].value = prc; 
                        grid.editModule.formObj.element[5].value = Totalquantity * prc; 
                    }); 
                } 
            }, 
            queryCellInfo: function (args) { 
                if (args.column.field === "Discountprice") {          //the querycellinfo triggers for every cell rendering 
                    var discount = (args.data.MRP * args.data.Discount) / 100; 
                    var discountprice = args.data.MRP - discount; 
                    args.data.Discountprice = discountprice;  //here we have calculated the discount price and updated the value to datasource 
                    args.cell.innerText = discountprice;     //here we have set the discount price to the cell value for UI changes 
                } 
                if (args.column.field === "Total") { 
                    var discountprice = (args.data.Discountprice * args.data.Quantity); 
                    args.data.Total = discountprice;          //here we have calculated the Total price and updated the value to datasource 
                    args.cell.innerText = discountprice;      //here we have set the Total price to the cell value for UI changes 
                } 
            } 
        } 
    }); `

示例:https://www.syncfusion.com/downloads/support/forum/154221/ze/1542211673557847.zip

文档:https://ej2.syncfusion.com/documentation/api/grid/#querycellinfo

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/61754340

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档