bas_enter_balancetype.dfm

一个MRPII系统源代码版本

inherited Frm_Bas_Enter_BalanceType: TFrm_Bas_Enter_BalanceType
  Left = 104
  Top = 69
  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 = 72
      Caption = '结算方式代码'
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      Columns = <
        Item
          FieldName = 'BalanceTypeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '结算方式代码'
          Width = 89
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BalanceTypeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '结算方式描述'
          Width = 335
          KeyList.Strings = ()
        end
        Item
          FieldName = 'GatheringKMCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '回款科目代码'
          Width = 89
          KeyList.Strings = ()
        end
        Item
          FieldName = 'kmName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '科目名称'
          Width = 112
          KeyList.Strings = ()
        end
        Item
          FieldName = 'RemArk'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '备注'
          Width = 224
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 317
    Top = 291
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_kelong;Data Source=192.168' +
      '.0.100'
    CurSorType = ctStatic
    SQL.Strings = (
      
        ' Select Convert(varchAr(10),BalanceTypeID) as BalanceTypeID, Bal' +
        'anceTypeCode,BalanceTypeName,GatheringKMCode, kmName,RemArk  Fro' +
        'm BalanceType  Left join Gl_AccountSubject On  BalanceType.Gathe' +
        'ringKMCode=Gl_AccountSubject.KmCode ')
    Left = 312
    Top = 185
    object AdoQry_MainBalanceTypeID: TStringField
      FieldName = 'BalanceTypeID'
      ReadOnly = True
      Size = 10
    end
    object AdoQry_MainBalanceTypeCode: TStringField
      FieldName = 'BalanceTypeCode'
      Origin = 'BalanceType'
      Size = 3
    end
    object AdoQry_MainBalanceTypeName: TStringField
      FieldName = 'BalanceTypeName'
      Origin = 'BalanceType'
      Size = 30
    end
    object AdoQry_MainGatheringKMCode: TStringField
      FieldName = 'GatheringKMCode'
      Origin = 'BalanceType'
      Size = 15
    end
    object AdoQry_MainkmName: TStringField
      FieldName = 'kmName'
      Origin = 'Gl_AccountSubject'
      Size = 40
    end
    object AdoQry_MainRemArk: TStringField
      FieldName = 'RemArk'
      Origin = 'BalanceType'
      Size = 30
    end
  end
end