ad_qry_valuestructanalyse.dfm

来自「一个MRPII系统源代码版本」· DFM 代码 · 共 207 行

inherited Frm_Ad_Qry_ValueStructAnalyse: TFrm_Ad_Qry_ValueStructAnalyse
  Left = 47
  Top = 99
  Caption = '价值构成分析表'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '价值构成分析表'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Condition: TLabel
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Width = 174
      Caption = '固定资产类别代码/固定资产代码'
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      Columns = <
        Item
          FieldName = 'AssetTypeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '固定资产类别代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AssetTypeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '固定资产类别名称'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AssetB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '固定资产标识'
          Width = 220
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 59
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SomeFirstAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '原值'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DepreciationValue'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '累积折旧'
          Width = 62
          KeyList.Strings = ()
        end
        Item
          FieldName = 'NetValue'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '净值'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'OldRate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '累计折旧占原值%'
          Width = 102
          KeyList.Strings = ()
        end
        Item
          FieldName = 'NetRate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '净值率%'
          Width = 60
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 200
    Top = 24
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=192.1' +
      '68.0.151;Use procedure for Prepare=1;Auto Translate=True;Packet ' +
      'Size=4096;Workstation ID=XYB'
    CurSorType = ctStatic
    SQL.Strings = (
      'select  Ad_AssetCard.AssetTypeCode,'
      '                 Ad_AssetType.AssetTypeName,'
      '                 Ad_AssetCard.AssetCode,'
      '                 Ad_AssetCard.AssetName,'
      
        '                 Ad_AssetCard.AssetCode+'#39' '#39'+Ad_AssetCard.AssetNa' +
        'me as AssetB,'
      '                 Ad_AssetCard.UomCode,'
      '                 Uom.UomName,'
      '                 Ad_AssetCard.FirstAmount as SomeFirstAmount,'
      '                 Ad_AssetCard.DepreciationValue,'
      '                 Ad_AssetCard.NetValue,'
      
        '                 Ad_AssetCard.DepreciationValue/Ad_AssetCard.Fir' +
        'stAmount*100 as OldRate,'
      
        '                 Ad_AssetCard.NetValue/Ad_AssetCard.FirstAmount*' +
        '100 as NetRate,'
      '                 Sort=0'
      '--         into #Tmp_FirstTable'
      '         from  Ad_AssetCard'
      
        '         join Ad_AssetType on Ad_AssetCard.AssetTypeCode=Ad_Asse' +
        'tType.AssetTypeCode'
      '         join Uom on Ad_AssetCard.UomCode=Uom.UomCode')
    Left = 408
    Top = 265
    object AdoQry_MainAssetTypeCode: TStringField
      FieldName = 'AssetTypeCode'
      Origin = '#tmp_threetable_Value'
      Size = 4
    end
    object AdoQry_MainAssetTypeName: TStringField
      FieldName = 'AssetTypeName'
      Origin = '#tmp_threetable_Value'
      Size = 60
    end
    object AdoQry_MainAssetCode: TStringField
      FieldName = 'AssetCode'
      Origin = '#tmp_threetable_Value'
      Size = 16
    end
    object AdoQry_MainAssetName: TStringField
      FieldName = 'AssetName'
      Origin = '#tmp_threetable_Value'
      Size = 60
    end
    object AdoQry_MainAssetB: TStringField
      FieldName = 'AssetB'
      Origin = '#tmp_threetable_Value'
      ReadOnly = True
      Size = 77
    end
    object AdoQry_MainUomCode: TStringField
      FieldName = 'UomCode'
      Origin = '#tmp_threetable_Value'
      Size = 4
    end
    object AdoQry_MainUomName: TStringField
      FieldName = 'UomName'
      Origin = '#tmp_threetable_Value'
      Size = 10
    end
    object AdoQry_MainSomeFirstAmount: TFloatField
      FieldName = 'SomeFirstAmount'
      Origin = '#tmp_threetable_Value'
    end
    object AdoQry_MainDepreciationValue: TFloatField
      FieldName = 'DepreciationValue'
      Origin = '#tmp_threetable_Value'
    end
    object AdoQry_MainNetValue: TFloatField
      FieldName = 'NetValue'
      Origin = '#tmp_threetable_Value'
    end
    object AdoQry_MainOldRate: TFloatField
      FieldName = 'OldRate'
      Origin = '#tmp_threetable_Value'
      ReadOnly = True
    end
    object AdoQry_MainNetRate: TFloatField
      FieldName = 'NetRate'
      Origin = '#tmp_threetable_Value'
      ReadOnly = True
    end
    object AdoQry_MainSort: TIntegerField
      FieldName = 'Sort'
      Origin = '#tmp_threetable_Value'
      ReadOnly = True
    end
  end
  object AdoQry_tmp1: TAdoQuery
    EnableBCD = False
    Parameters = <>
    Left = 176
    Top = 209
  end
end