wijgrid 数据单元格内数据发生改变

收藏

{ dataKey: "AMOUNT", headerText: "金额(不含税)", dataType: "number", readOnly: true, width: 110, aggregate: "sum", footerText: "{0}" },
金额在数据库中查询值为676.90，显示为676.92
烦请指导，谢谢

李军 · 李军

[{"MYINDEX":"1","CHECKED":"false",&quot

R_BATCH_NO":"","BATCH_NO":"14120100000006",&quot

AY_MODE":"","GOODS_NO":"16900S84G01","GOODS_NAME":"燃油滤清器","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"29942","LOCATION_NAME":"C-09-04-04","UNIT":"","QTY":"1","IN_PRICE":"162.74","AMOUNT":"162.74","TAX_PRICE":"190.41","TAX_AMT":"190.41","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"16900-S84-G01"},{"MYINDEX":"2","CHECKED":"false",&quot

R_BATCH_NO":"","BATCH_NO":"14120100000005",&quot

AY_MODE":"","GOODS_NO":"90682SEA003","GOODS_NAME":"螺纹垫圈 ","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"29453","LOCATION_NAME":"N-01-03-02","UNIT":"","QTY":"20","IN_PRICE":"1.37","AMOUNT":"27.40","TAX_PRICE":"1.60","TAX_AMT":"32","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"90682-SEA-003"},{"MYINDEX":"3","CHECKED":"false",&quot

R_BATCH_NO":"","BATCH_NO":"14120100000007",&quot

AY_MODE":"","GOODS_NO":"172205A2A00","GOODS_NAME":"空气滤清器","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"29934","LOCATION_NAME":"C-01-03-03","UNIT":"个","QTY":"10","IN_PRICE":"67.69","AMOUNT":"676.90","TAX_PRICE":"79.20","TAX_AMT":"792","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"17220-5A2-A00"},{"MYINDEX":"4","CHECKED":"false",&quot

R_BATCH_NO":"","BATCH_NO":"14120100000008",&quot

AY_MODE":"","GOODS_NO":"31500SFJW03","GOODS_NAME":"电瓶 ","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"29892","LOCATION_NAME":"B-02-01-01","UNIT":"个","QTY":"1","IN_PRICE":"306.32","AMOUNT":"306.32","TAX_PRICE":"358.39","TAX_AMT":"358.39","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"31500-SFJ-W03"},{"MYINDEX":"5","CHECKED":"false",&quot

R_BATCH_NO":"","BATCH_NO":"14120100000009",&quot

AY_MODE":"","GOODS_NO":"15400R5GH01","GOODS_NAME":"机油滤清器","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"30050","LOCATION_NAME":"N-01-03-01","UNIT":"","QTY":"180","IN_PRICE":"26.67","AMOUNT":"4800.60","TAX_PRICE":"31.20","TAX_AMT":"5616","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"15400-R5G-H01"},{"MYINDEX":"6","CHECKED":"false","PR_BATCH_NO":"","BATCH_NO":"14120100000010","PAY_MODE":"","GOODS_NO":"04641TM2P00ZZ","GOODS_NAME":"左侧下车身骨架","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"30063","LOCATION_NAME":"待发区","UNIT":"","QTY":"1","IN_PRICE":"564.12","AMOUNT":"564.12","TAX_PRICE":"660.02","TAX_AMT":"660.02","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"04641-TM2-P00ZZ"},{"MYINDEX":"7","CHECKED":"false","PR_BATCH_NO":"","BATCH_NO":"14120100000011","PAY_MODE":"","GOODS_NO":"80115TM0T00","GOODS_NAME":"支架","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"30063","LOCATION_NAME":"待发区","UNIT":"","QTY":"1","IN_PRICE":"8.21","AMOUNT":"8.21","TAX_PRICE":"9.61","TAX_AMT":"9.61","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"80115-TM0-T00"},{"MYINDEX":"8","CHECKED":"false","PR_BATCH_NO":"","BATCH_NO":"14120100000012","PAY_MODE":"","GOODS_NO":"80116TM0T00","GOODS_NAME":"支架","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"30063","LOCATION_NAME":"待发区","UNIT":"","QTY":"1","IN_PRICE":"8.89","AMOUNT":"8.89","TAX_PRICE":"10.40","TAX_AMT":"10.40","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"80116-TM0-T00"},{"MYINDEX":"9","CHECKED":"false","PR_BATCH_NO":"","BATCH_NO":"14120100000013","PAY_MODE":"","GOODS_NO":"32120TM0G50","GOODS_NAME":"左机舱线束","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"30063","LOCATION_NAME":"待发区","UNIT":"","QTY":"1","IN_PRICE":"687.86","AMOUNT":"687.86","TAX_PRICE":"804.80","TAX_AMT":"804.80","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"32120-TM0-G50"},{"MYINDEX":"10","CHECKED":"false","PR_BATCH_NO":"","BATCH_NO":"14120100000014","PAY_MODE":"","GOODS_NO":"38150SFJH01","GOODS_NAME":"高音喇叭总成","GOODS_LARGECLASS":"2013","GOODS_INCLASS":"2013","GOODS_SMALLCLASS":"2150","GOODS_SUBCLASS":"0","WAVEHOUSE_ID":"616","LOCATION_ID":"30063","LOCATION_NAME":"待发区","UNIT":"","QTY":"1","IN_PRICE":"51.28","AMOUNT":"51.28","TAX_PRICE":"60","TAX_AMT":"60","REMARK":"","GOODS_SMALLCLASS_TEXT":"一般零配件","GOODSVENDOR_NO":"38150-SFJ-H01"}]

李军 · 李军

$("#gvData").wijgrid({
 data: json_data,
 showFooter: true,
 allowPaging: false,
 afterCellEdit: onAfterCellEdit,
 rowHeight: 100,
 editingMode: "cell",
 scrollMode: "auto",
 rowHeight: 20,
 ensureColumnsPxWidth: true,
 allowKeyboardNavigation: true,
 allowVirtualScrolling:true,
 columnsAutogenerationMode: "none",
 selectionMode: "singleCell",
 columns: [
 { dataKey: "CHECKED", headerText: "选择", dataType: "boolean", width: 60, textAlignment: "center" },
 { dataKey: "MYINDEX", headerText: "序号", readOnly: true, width: 60, textAlignment: "center" },
 { dataKey: "GOODS_NO", headerText: "商品编码", readOnly: true, width: 100 },
 { dataKey: "GOODS_NAME", headerText: "商品名称", readOnly: true, width: 150, footerText: "合计:" },
 { dataKey: "UNIT", headerText: "单位", width: 80, readOnly: true, textAlignment: "center" },
 { dataKey: "QTY", headerText: "数量", dataType: "number", width: 80,aggregate: "sum", footerText: "{0}",
 cellFormatter: function (args) {
 if (args.row.type & $.wijmo.wijgrid.rowType.data) { // data row (not group header)
 args.$cell.css("background-color", "#FFFF80");
 }
 }
 },
 { dataKey: "TAX_PRICE", headerText: "单价(含税)", dataType: "number", width: 100,
 cellFormatter: function (args) {
 if (args.row.type & $.wijmo.wijgrid.rowType.data) { // data row (not group header)
 args.$cell.css("background-color", "#FFFF80");
 }
 }
 },
 { dataKey: "TAX_AMT", headerText: "金额(含税)", dataType: "number", readOnly: true, width: 100, aggregate: "sum", footerText: "{0}" },
 { dataKey: "IN_PRICE", headerText: "单价(不含税)", dataType: "number", readOnly: true, width: 110 },
 { dataKey: "AMOUNT", headerText: "金额(不含税)", dataType: "number", readOnly: true, width: 110, aggregate: "sum", footerText: "{0}" },
 { dataKey: "GOODS_SMALLCLASS_TEXT", headerText: "三级类别", readOnly: true, width: 100 },
 { dataKey: "LOCATION_NAME", headerText: "库位", width: 100,
 cellFormatter: function (args) {
 if (args.row.type & $.wijmo.wijgrid.rowType.data) { // data row (not group header)
 args.$cell.css("background-color", "#99CCFF");
 }
 }
 },
 { dataKey: "GOODSVENDOR_NO", headerText: "厂家编码", readOnly: true, width: 100 },
 { dataKey: "GOODS_LARGECLASS", visible: false },
 { dataKey: "GOODS_INCLASS", visible: false },
 { dataKey: "GOODS_SMALLCLASS", visible: false },
 { dataKey: "GOODS_SUBCLASS", visible: false },
 { dataKey: "LOCATION_ID", visible: false },
 { dataKey: "WAVEHOUSE_ID", visible: false },
 { dataKey: "

R_BATCH_NO", visible: false },
{ dataKey: "BATCH_NO", visible: false },
{ dataKey: "

AY_MODE", visible: false },
                  { dataKey: "REMARK", visible: false }
            ]
         });

Alice · Alice

回复 3楼李军的帖子

你好。
我们使用了你给的数据源进行测试，该问题我们没有重现。
我们使用wijmo3进行测试，测试的页面上传到附件，你可以看看。

测试页面中，数据都和数据源一致。
或者我们在使用的版本号或是有其他代码因素的影响。如有不同，还望指出。
如果有什么问题，请及时联系我们。

李军 · 李军

附件是wijimo包

Alice · Alice

回复 5楼李军的帖子

wijmo包已经收到。
我们会尽快测试给您回复。

Alice · Alice

回复 5楼李军的帖子

由于你的附件里是amd第三方的js包，所以我们根据你之前的代码，使用2014 V2版本（即你使用的版本），做的测试demo，具体如附件。

经过测试，依然没有重现你的问题。页面能够正常数据，没有你提到的错误数据。
测试页面效果：

请问，使用我们的两次的Demo，在你那里数据显示是否正常？

iceman · iceman

回复 7楼Alice的帖子

另外，针对楼上 Demo 做了修改。以下Demo 可以直接点击html页面运行了：

李军 · 李军

http://cdn.wijmo.com/themes/rocket/jquery-wijmo.css这些资源都无法访问，所以一直在等待中

iceman · iceman

回复 9楼李军的帖子

请下载 8# Demo 进行测试。谢谢

		自动登录	找回密码
密码			立即注册

wijgrid 数据单元格内数据发生改变

13 个回复

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

活字格认证

微信认证勋章

元老葡萄