gl_qry_changeexchangerate.dfm

一个MRPII系统源代码版本

inherited Frm_Gl_Qry_ChangeExchangeRate: TFrm_Gl_Qry_ChangeExchangeRate
  Left = 123
  Top = 89
  Caption = #26399#26411#35843#27719#21015#34920#26597#35810
  ClientWidth = 749
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 749
  end
  inherited Pnl_Title: TPanel
    Width = 749
    Caption = #26399#26411#35843#27719#21015#34920#26597#35810
    inherited Image2: TImage
      Width = 749
    end
    inherited PnlTitleLabel: TLabel
      Left = 352
      Width = 112
      Caption = #26399#26411#35843#27719#21015#34920#26597#35810
    end
  end
  inherited Pnl_Head: TPanel
    Width = 749
    inherited Image1: TImage
      Width = 749
    end
    inherited Lbl_Condition: TLabel
      Width = 72
      Caption = #24403#21069#20250#35745#26376#20221
    end
    inherited Lbl_Order: TLabel
      Width = 48
      Caption = #35760#36134#26376#20221
    end
  end
  inherited Pnl_Hint: TPanel
    Width = 749
    inherited Image4: TImage
      Width = 749
    end
  end
  inherited Pnl_Body: TPanel
    Width = 749
    inherited Image3: TImage
      Width = 749
    end
    inherited DBGridEh: TDBGridEh
      Width = 749
      FrozenCols = 3
      UseMultiTitle = True
      Columns = <
        item
          EditButtons = <>
          FieldName = 'InvMonth'
          Footers = <>
          Width = 54
        end
        item
          EditButtons = <>
          FieldName = 'KmCode'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'KmName'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'FCurrecy'
          Footers = <>
          Width = 63
        end
        item
          EditButtons = <>
          FieldName = 'CurrencyName'
          Footers = <>
          Width = 82
        end
        item
          EditButtons = <>
          FieldName = 'FirstFBalance'
          Footers = <>
          Width = 80
        end
        item
          EditButtons = <>
          FieldName = 'FirstBalance'
          Footers = <>
          Width = 90
        end
        item
          EditButtons = <>
          FieldName = 'FCurrencyRate'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'FCurrencyRate_End'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'FirstBalance_End'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'DiverSity'
          Footers = <>
        end
        item
          EditButtons = <>
          FieldName = 'EmployeeCode_Create'
          Footers = <>
          Width = 88
        end
        item
          EditButtons = <>
          FieldName = 'EmployeeName'
          Footers = <>
          Width = 81
        end
        item
          EditButtons = <>
          FieldName = 'Date_Create'
          Footers = <>
          Width = 78
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 232
    Top = 64
    inherited Act_New: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Modify: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Delete: TAction
      Enabled = False
      Visible = False
    end
  end
  inherited AdoQry_Main: TADOQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_kl;Data Source=ExtDATASE' +
      'RVER'
    CursorType = ctStatic
    SQL.Strings = (
      'select InvMonth,'
      '       ChArgeExchangeRate.KmId,'
      '       Gl_AccountSubject.KmCode,'
      '       Gl_AccountSubject.KmName,'
      '       ChArgeExchangeRate.FCurrecy,'
      '       Currency.CurrencyName,'
      '       FirstFBalance,'
      '       FirstBalance,'
      '       FCurrencyRate,'
      '       FCurrencyRate_End,'
      '       FirstBalance_End,'
      '       DiverSity,'
      '       EmployeeCode_Create,'
      '       EmployeeName,'
      '       Date_Create'
      'from ChArgeExchangeRate'
      
        'join Gl_AccountSubject on ChArgeExchangeRate.KmId=Gl_AccountSubj' +
        'ect.KmId'
      
        'left join Currency on ChArgeExchangeRate.FCurrecy=Currency.Curre' +
        'ncyCode'
      
        'left join Employee on ChArgeExchangeRate.EmployeeCode_Create=Emp' +
        'loyee.EmployeeCode')
    Left = 360
    object AdoQry_MainInvMonth: TStringField
      DisplayLabel = #35760#36134#26376#20221
      FieldName = 'InvMonth'
      Origin = 'ChArgeExchangeRate'
      Size = 7
    end
    object AdoQry_MainKmId: TIntegerField
      FieldName = 'KmId'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainKmCode: TStringField
      DisplayLabel = #31185#30446#20195#30721
      FieldName = 'KmCode'
      Size = 15
    end
    object AdoQry_MainKmName: TStringField
      DisplayLabel = #31185#30446#21517#31216
      FieldName = 'KmName'
      Size = 40
    end
    object AdoQry_MainFCurrecy: TStringField
      DisplayLabel = #35760#36134#36135#24065#20195#30721
      FieldName = 'FCurrecy'
      Origin = 'ChArgeExchangeRate'
      Size = 3
    end
    object AdoQry_MainCurrencyName: TStringField
      DisplayLabel = #35760#36134#36135#24065#21517#31216
      FieldName = 'CurrencyName'
      Size = 30
    end
    object AdoQry_MainFirstFBalance: TFloatField
      DisplayLabel = #21407#24065#26399#26411#20313#39069
      FieldName = 'FirstFBalance'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainFirstBalance: TFloatField
      DisplayLabel = #26412#20301#24065#26399#26411#20313#39069
      FieldName = 'FirstBalance'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainFCurrencyRate: TFloatField
      DisplayLabel = #26399#21021#27719#29575
      FieldName = 'FCurrencyRate'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainFCurrencyRate_End: TFloatField
      DisplayLabel = #26399#26411#27719#29575
      FieldName = 'FCurrencyRate_End'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainFirstBalance_End: TFloatField
      DisplayLabel = #35843#25972#21518#26412#20301#24065#26399#26411#20313#39069
      FieldName = 'FirstBalance_End'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainDiverSity: TFloatField
      DisplayLabel = #24046#24322
      FieldName = 'DiverSity'
      Origin = 'ChArgeExchangeRate'
    end
    object AdoQry_MainEmployeeCode_Create: TStringField
      DisplayLabel = #35843#27719#20154#21592#20195#30721
      FieldName = 'EmployeeCode_Create'
      Origin = 'ChArgeExchangeRate'
      Size = 30
    end
    object AdoQry_MainEmployeeName: TStringField
      DisplayLabel = #35843#27719#20154#21592#21517#31216
      FieldName = 'EmployeeName'
      Size = 60
    end
    object AdoQry_MainDate_Create: TDateTimeField
      DisplayLabel = #35843#27719#26085#26399
      FieldName = 'Date_Create'
      Origin = 'ChArgeExchangeRate'
    end
  end
  inherited DataSource: TDataSource
    Left = 288
    Top = 145
  end
end