• 多条明细(绑定到一个字段)汇总


    procedure TdmlSBWXJL_R.qryDataBeforePost(DataSet: TDataSet);
    var
      BookMark: TBookmark;
      fYLJE, fYGJE : Extended;
    begin
      inherited;
      fYLJE := 0;
      fYGJE := 0;
      BookMark := qryJXYL.GetBookmark;
      qryJXYL.DisableControls;
      try
        qryJXYL.First;
        while not qryJXYL.Eof do
        begin
          fYLJE := fYLJE + tvDetailJXYLSBWXYL_SL.AsFloat * tvDetailJXYLSBWXYL_JG.AsFloat;
          qryJXYL.Next;
        end;
      finally
        qryJXYL.GotoBookmark(BookMark);
        qryJXYL.FreeBookmark(BookMark);
        qryJXYL.EnableControls;
      end;
      BookMark := qryJXYG.GetBookmark;
      qryJXYG.DisableControls;
      try
        qryJXYG.First;
        while not qryJXYG.Eof do
        begin
          fYLJE := fYLJE + tvSBJXYGSBWXYG_GS.AsFloat * tvSBJXYGSBWXYG_JG.AsFloat;
          qryJXYG.Next;
        end;
      finally
        qryJXYG.GotoBookmark(BookMark);
        qryJXYG.FreeBookmark(BookMark);
        qryJXYG.EnableControls;
      end;
      qryDataSBWX_FY.AsFloat := fYLJE + fYGJE;
      if (qryData.State in [dsInsert]) and bIsGZL then
        CallBackOwnerForm(cbWFNewInst,'','');
    end;

  • 相关阅读:
    leetcode--91--递归与动态规划
    Grunt体验
    JSON标准中引号是双引号,不是单引号!
    npm install
    正则-手机号隐藏中间四位及tips备忘
    node tips
    技术栈
    slice与remove
    substr、substring、slice
    springboot 取消post数据大小限制
  • 原文地址:https://www.cnblogs.com/FuYan/p/3195789.html
Copyright © 2020-2023  润新知