以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  If....End IF与IF....ElseIf...End那个效率更高  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=114037)
--  作者：cd_tdh
--  发布时间：2018/1/26 22:37:00
--  If....End IF与IF....ElseIf...End那个效率更高
If....End IF与IF....ElseIf...End If那个效率更高？
当DataColChanged事件用Select Case运行多个计算时，判断较多，会有卡顿、表格闪烁情况怎么解决？
--  作者：有点蓝
--  发布时间：2018/1/26 22:44:00
--  
正常是判断少的效率高。实际还要看数据和完整的代码逻辑才能判断

减少判断，减少事件的关联触发。避免在表事件里进行批量操作
--  作者：cd_tdh
--  发布时间：2018/2/2 15:38:00
--  

这个代码怎么简化能提高效率呢？

 

 下载信息  [文件大小：   下载次数： ]
图片点击可在新窗口打开查看点击浏览该文件:新建文本文档 (2).txt
--  作者：有点甜
--  发布时间：2018/2/2 15:44:00
--  

这种代码，不要写太多列，影响计算的列，才需要写，不然别的列修改会触发代码。而且流水账代码本身就是比较耗时的。

 

    Case "成本基数","项目名称","合同金额","合同工期","开工日期","竣工日期","计量期数","管理费费率","申请金额","个人所得税率","手续费","安全保证金","质量保证金","应急保证金","资料保证金","所属机构","合同编码","建设单位","外经证","自营证明","完税凭证","发票号码","发票金额","到账金额","其他费用","现金补税","是否是退扣款","履约保证金","民工保证金","意外伤害保险","预交增值税","计费基数","管理费","企业所得税基数","个人所得税基数","企业所得税","个人所得税","是否预付款","新老项目","应缴增值税基数","成本差额税","增值税征收方式","应缴增值税","计量金额","累计统计人工工资","本期统计人工工资","本期需要人工工资","累计统计成本发票","本期统计成本发票","本期需要成本发票","是否扣税","成本差额税率","企业所得税率","成本差额","本期统计增值税","累计统计增值税","本期需要增值税","应扣费用明细_小计","本期_累计扣款","扣税明细_小计","本期剩余成本发票","本期使用成本发票","本期使用人工工资","本期剩余人工工资","应补增值税","本期剩余增值税","抵扣增值税"