jQuery MiniUI › 论坛 › MiniUI › 技术交流 › CellEdit的一个问题，求指教

12 下一页

返回列表

查看: 4004|回复: 13

CellEdit的一个问题，求指教 [复制链接]

yangfei_wow

新手上路

Rank: 1

电梯直达

楼主

发表于 2014-4-23 11:32:45 |只看该作者 |倒序浏览

需求是这样的首先每个单元格的值都是数字编辑  列1  列2 然后跟据自定义的算法自动填充  列3  列4  列5
此时没有问题  然后修改列3 需要列4 列5 的值根据算法改变值
这时问题出现  进去到列4 列5 的编辑器中时显示的是已经改变的值按下回车进入下一个单元格编辑时  列4 列5 中的值却显示计算前的值
这是怎么回事呢？

收藏0

felt

超级版主

Rank: 8 Rank: 8

沙发

发表于 2014-4-23 11:40:09 |只看该作者

本帖最后由 felt 于 2014-4-23 11:41 编辑

列4列5你既然是自动填充的，为什么还要修改
修改完还是会触发drawcell绘制的

yangfei_wow

新手上路

Rank: 1

板凳

发表于 2014-4-23 12:11:38 |只看该作者

felt 发表于 2014-4-23 11:40
列4列5你既然是自动填充的，为什么还要修改
修改完还是会触发drawcell绘制的
...

可能会差个零点零几或者零点几的就需要调整一下

那么怎么解决这个问题呢？

yangfei_wow

新手上路

Rank: 1

地板

发表于 2014-4-23 12:13:45 |只看该作者

felt 发表于 2014-4-23 11:40
列4列5你既然是自动填充的，为什么还要修改
修改完还是会触发drawcell绘制的
...

而且在里面没有用到drawcell事件呀

felt

超级版主

Rank: 8 Rank: 8

5^#

发表于 2014-4-23 13:12:49 |只看该作者

yangfei_wow 发表于 2014-4-23 12:13
而且在里面没有用到drawcell事件呀

那你列4，列5怎么计算的

yangfei_wow

新手上路

Rank: 1

6^#

发表于 2014-4-23 13:23:24 |只看该作者

felt 发表于 2014-4-23 13:12
那你列4，列5怎么计算的

在CellBeginEdit事件里
if(field==='列4'){
e.editor.setValue(列1/列2); //假设是这种简单的算法
row.列5＝列1*列2;
}

felt

超级版主

Rank: 8 Rank: 8

7^#

发表于 2014-4-23 15:29:14 |只看该作者

yangfei_wow 发表于 2014-4-23 13:23
在CellBeginEdit事件里
if(field==='列4'){
e.editor.setValue(列1/列2); //假设是这种简单的算法

你做个重现的简单html页面上来，我们看下

yangfei_wow

新手上路

Rank: 1

8^#

发表于 2014-4-23 16:15:53 |只看该作者

<body>
<div>
<div id="datagrid1" class="mini-datagrid" style="width: 100%; height: 500px;" editnextonenterkey="true" autoselect="true" idfield="ID" allowcelledit="true" allowcellvalid="true" showpager="false" oncellendedit="onCellEndEdit" allowcellselect="true" oncellbeginedit="onCellBeginEdit">
<div property="columns">
<div name="Name" field="Name" width="35%" vtype="required" headeralign="center" align="center" align="center">
产品
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="Qty" field="Qty" width="35%" vtype="required" headeralign="center" align="center" align="center" summarytype="sum">
数量*
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="TaxPrice" field="TaxPrice" width="35%" vtype="required" headeralign="center" align="right">
含税单价*
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="Price" field="Price" width="35%" vtype="required" align="right" headeralign="center">
不含税单价
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="DiscountRate" field="DiscountRate" width="35%" vtype="required" headeralign="center" align="center">
折扣率(%)*
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="RealTaxPrice" field="RealTaxPrice" width="35%" vtype="required" headeralign="center" align="right">
实际含税单价
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="RealPrice" field="RealPrice" width="35%" vtype="required" align="right" headeralign="center">
实际不含税单价
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="Amount" field="Amount" width="35%" vtype="required" headeralign="center" align="right" summarytype="sum">
不含税金额
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="Deduction" field="Deduction" width="35%" vtype="required" headeralign="center" align="right" summarytype="sum">
折扣额
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="TaxRate" field="TaxRate" width="25%" vtype="required" headeralign="center" align="center">
税率(%)*
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="Tax" field="Tax" width="35%" vtype="required" headeralign="center" align="center">
税额
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" />
</div>
<div name="TaxAmount" field="TaxAmount" width="35%" vtype="required" headeralign="center" align="center">
价税合计
<input property="editor" class="mini-textbox" onbuttonclick="" style="width: 100%;" onenter="EnterAdd" />
</div>
</div>
</div>
</div>
</body>

复制代码

yangfei_wow

新手上路

Rank: 1

9^#

发表于 2014-4-23 16:16:33 |只看该作者

<script type="text/javascript">
mini.parse();
var grid = mini.get("datagrid1");
function addGridRow() {
var newRow = {Name: "", Qty: "", TaxPrice: "", Price: "", DiscountRate: "", RealTaxPrice: "", RealPrice: "", Amount: "", Deduction: "", TaxRate: 17, Tax: "", TaxAmount: "", Amount: "", Description: "", gCode: "" };
grid.addRow(newRow);
}
$(document).ready(function () {
for (var i = 0; i < 5; i++) {
addGridRow();
}
});
function onCellBeginEdit(e) {
var row = grid.getSelected();
//不含税单价
if (e.field === "Price") {
$.ajax({
url: "?",
success: function (data) {
var taxPrice = row["TaxPrice"];
var taxRate = row["TaxRate"];
if (taxPrice === "")
taxPrice = 0;
if (taxRate === "")
taxRate = 0;
var price = taxPrice / (1 + taxRate / 100);
e.editor.setValue(price.toFixed(4));
}
})
//row.Price = (row["TaxPrice"] / (1 + row["TaxRate"] / 100)).toFixed(4);
//grid.getCellEditor(grid.getColumn("Price"), row).setValue(row.Price);
if (row["DiscountRate"] === "")
row["DiscountRate"] = 0;
row.RealTaxPrice = (row["TaxPrice"] * (1 - row["DiscountRate"] / 100)).toFixed(4);
if (row["TaxRate"] === "")
row["TaxRate"] = 0;
row.RealPrice = (row["RealTaxPrice"] / (1 + row["TaxRate"] / 100)).toFixed(4);
row.Amount = (row["RealPrice"] * row["Qty"]).toFixed(2);
row.Deduction = (row["TaxPrice"] * row["Qty"] * (row["DiscountRate"] / 100)).toFixed(2);
row.TaxAmount = (row["Qty"] * row["RealTaxPrice"]).toFixed(2);
if (row["TaxRate"] === "")
row["TaxRate"] = 0;
row.Tax = (row["TaxAmount"] - row["Amount"]).toFixed(2);
}
//实际含税单价
if (e.field === "RealTaxPrice") {
$.ajax({
url: "?",
success: function (data) {
row.Price = (row["TaxPrice"] / (1 + row["TaxRate"] / 100)).toFixed(4);
var taxPrice = row["TaxPrice"];
var discountRate = row["DiscountRate"];
if (taxPrice === "")
taxPrice = 0;
if (discountRate === "")
discountRate = 0;
var price = taxPrice * (1 - discountRate / 100);
e.editor.setValue(price.toFixed(4));
row.RealTaxPrice = price.toFixed(4);
if (row["TaxRate"] === "")
row["TaxRate"] = 0;
row.RealPrice = (row["RealTaxPrice"] / (1 + row["TaxRate"] / 100)).toFixed(4);
row.Amount = (row["RealPrice"] * row["Qty"]).toFixed(2);
row.Deduction = (row["TaxPrice"] * row["Qty"] * (row["DiscountRate"] / 100)).toFixed(2);
row.TaxAmount = (row["Qty"] * row["RealTaxPrice"]).toFixed(2);
if (row["TaxRate"] === "")
row["TaxRate"] = 0;
row.Tax = (row["TaxAmount"] - row["Amount"]).toFixed(2);
}
})
}
//折扣额
if (e.field === "Deduction") {
$.ajax({
async: false,
url: "?",
success: function (data) {
var taxPrice = row["TaxPrice"];
var dRate = row["DiscountRate"];
var qty = row["Qty"];
if (taxPrice === "")
taxPrice = 0;
if (dRate === "")
dRate = 0;
if (qty === "")
qty = 0;
var price = taxPrice * qty * (dRate / 100);
e.editor.setValue("");
e.editor.setValue(price.toFixed(2));
row.Deduction = price.toFixed(2);
}
})
}
//税额
if (e.field === "Tax") {
//Price
row.Price = (row["TaxPrice"] / (1 + row["TaxRate"] / 100)).toFixed(4);
if (row["DiscountRate"] === "")
row["DiscountRate"] = 0;
row.RealTaxPrice = (row["TaxPrice"] * (1 - row["DiscountRate"] / 100)).toFixed(4);
if (row["TaxRate"] === "")
row["TaxRate"] = 0;
row.RealPrice = (row["RealTaxPrice"] / (1 + row["TaxRate"] / 100)).toFixed(4);
row.Amount = (row["RealPrice"] * row["Qty"]).toFixed(2);
row.Deduction = ((row["TaxPrice"] - row["RealTaxPrice"]) * row["Qty"]).toFixed(2);
if (row["TaxRate"] === "")
row["TaxRate"] = 0;
row.TaxAmount = (row["Qty"] * row["RealTaxPrice"]).toFixed(2);
$.ajax({
url: "?",
success: function (data) {
var amount = row["Amount"];
var taxAmount = row["TaxAmount"];
if (amount === "")
amount = 0;
if (taxAmount === "")
taxAmount = 0;
var price = taxAmount - amount;
e.editor.setValue(price.toFixed(2));
}
})
}
//价税合计
if (e.field === "TaxAmount") {
$.ajax({
url: "?",
success: function (data) {
var qty = row["Qty"];
var rtp = row["RealTaxPrice"];
if (qty === "")
qty = 0;
if (rtp === "")
rtp = 0;
var taxAmount = (rtp * qty).toFixed(2);
e.editor.setValue(taxAmount);
}
})
}
}
function onCellEndEdit(e) {
var row = grid.getSelected();
if (e.field === "TaxRate") {
if (e.value !== 17) {
}
}
}
function EnterAdd(e) {
if (e.source.ownerRowID == grid.getData().length - 1) {
addGridRow();
}
}
</script>

复制代码

yangfei_wow

新手上路

Rank: 1

10^#

发表于 2014-4-23 16:17:26 |只看该作者

felt 发表于 2014-4-23 15:29
你做个重现的简单html页面上来，我们看下

发到楼下了您看下字数原因分成两个贴了

12 下一页

返回列表

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