Dim t As TimeSpan = Date.Today - # 02/20/2010 # 'CDate(e.datarow("入库日期"))
If e.DataRow.IsNull("期初余额") = False Then
e.datarow("期初天元") = t.TotalDays*e.datarow("期初余额")
End If
if e.datacol.name="供应商" then
e.datarow("供应商") = e.datarow("供应商").Trim()
Dim ys As Long
dim sk as long
dim qf as long
ys = DataTables("材料入库").Compute("sum(金额)", "[供应商] = '" & e.datarow("供应商") & "'")
sk = DataTables("付款记录").Compute("sum(付款金额)","[供应商] = '" & e.datarow("供应商") & "'")
qf = datatables("应付金额").compute("sum(期初余额)","[供应商] = '" & e.datarow("供应商") & "'")
e.datarow("应付金额")=ys-sk+qf
dim qt,ft,st as double
qt = datatables("应付金额").compute("sum(期初天元)","[供应商]='" & e.datarow("供应商") & "'")
ft = datatables("材料入库").compute("sum(天元)","[供应商]='" & e.datarow("供应商") & "'")
st = datatables("付款记录").compute("sum(天元)","[供应商]='" & e.datarow("供应商") & "'")
e.datarow("天元")=(qt+0.5*(ft-st))/(ft+qt)*t.totaldays
end if
DataTables("应付金额").DeleteFor("[供应商] is null ")
只有一个人在编辑,编辑完后,都锁定行,并保存。
[此贴子已经被作者于2010-5-15 13:32:41编辑过]