给你成果,经测试有效。
- Forguncy.Page.ready(function () {
- var withoutTAXColIndex = 10; //未含税价
- var TAXColIndex = 14; //税率
- var withTAXColIndex = 11; //含税价
- var isSettingValue = false;
- var listview = Forguncy.Page.getListView("table1");
- //注意,这里把表格名称改成了table1,我测试用中文名称,浏览器报错
- var updateTAX = function (row) {
- var withTAX = listview.getValue(row, withTAXColIndex);
- if (withTAX == null) {
- return false
- }
- var withoutTAX = listview.getValue(row, withoutTAXColIndex);
- if (withoutTAX == null) {
- return false
- }
- var TAX = (withTAX - withoutTAX) / withoutTAX;
- isSettingValue = true;
- listview.setValue(row, TAXColIndex, TAX);
- isSettingValue = false;
- return true;
- }
- var updatewithoutTAX = function (row) {
- var withTAX = listview.getValue(row, withTAXColIndex);
- if (withTAX == null) {
- return false
- }
- var TAX = listview.getValue(row, TAXColIndex);
- if (TAX == null) {
- return false
- }
- var withoutTAX = withTAX / (1 + TAX);
- isSettingValue = true;
- listview.setValue(row, withoutTAXColIndex, withoutTAX);
- isSettingValue = false;
- return true;
- }
- var updatewithTAX = function (row) {
- var withoutTAX = listview.getValue(row, withoutTAXColIndex);
- if (withoutTAX == null) {
- return false
- }
- var TAX = listview.getValue(row, TAXColIndex);
- if (TAX == null) {
- return false
- }
- var withTAX = withoutTAX * (1 + TAX);
- isSettingValue = true;
- listview.setValue(row, withTAXColIndex, withTAX);
- isSettingValue = false;
- return true;
- }
- listview.bind(Forguncy.ListViewEvents.ValueChanged, function (arg1, arg2) {
- if (isSettingValue) {
- return;
- }
- var row = arg2.CellRanges[0].Row;
- var col = arg2.CellRanges[0].Column;
- if (row >= 0 && col >= 0) {
- if (col === withoutTAXColIndex) {
- if (!updatewithTAX(row)) {
- updateTAX(row);
- }
- }
- else if (col === TAXColIndex) {
- if (!updatewithTAX(row)) {
- updatewithoutTAX(row);
- }
- }
- else if (col === withTAXColIndex) {
- if (!updatewithoutTAX(row)) {
- updateTAX(row);
- }
- }
- }
- });
- });
复制代码 为什么我粘贴的代码格式没有了,都左对齐了。。。
|