Foxtable(狐表)用户栏目专家坐堂 → If....End IF与IF....ElseIf...End那个效率更高


  共有2159人关注过本帖树形打印复制链接

主题:If....End IF与IF....ElseIf...End那个效率更高

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/2/2 15:44:00 [显示全部帖子]

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

 

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


 回到顶部