ar_qry_ardetailbill.dfm

一个MRPII系统源代码版本

inherited Frm_Ar_Qry_ArDetailBill: TFrm_Ar_Qry_ArDetailBill
  Caption = '应收帐款明细表'
  ClientWidth = 729
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 729
  end
  inherited Pnl_Title: TPanel
    Width = 729
    Caption = '应收帐款明细表'
    inherited Image2: TImage
      Width = 729
    end
  end
  inherited Pnl_Head: TPanel
    Width = 729
    inherited Image1: TImage
      Width = 729
    end
    inherited Lbl_Order: TLabel
      Width = 24
      Caption = '日期'
    end
  end
  inherited Pnl_Hint: TPanel
    Width = 729
    inherited Image4: TImage
      Width = 729
    end
  end
  inherited Pnl_Body: TPanel
    Width = 729
    inherited Image3: TImage
      Width = 729
    end
    inherited DBGridEh: TDBGridEh
      Width = 729
      Columns = <
        Item
          FieldName = 'Ardate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '日期'
          Width = 99
          KeyList.Strings = ()
        end
        Item
          FieldName = 'conect'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '摘要'
          Width = 267
          KeyList.Strings = ()
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvInAmountC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '借方金额'
          Width = 128
          KeyList.Strings = ()
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvoutAmountC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '贷方金额'
          Width = 87
          KeyList.Strings = ()
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvBLNCAmountC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '余额'
          Width = 77
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 717
    Top = 3
  end
  inherited ActionList: TActionList
    Left = 552
    Top = 0
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_kl;Data Source=ExtDATASERVE' +
      'R;Use procedure for Prepare=1;Auto Translate=True;Packet Size=40' +
      '96;Workstation ID=XYB'
    SQL.Strings = (
      'create table #TmpArMonth '
      ' ('
      '    Ardate varchAr(10) ,'
      '    conect varchAr(250),'
      '    InvInAmountC decimal(20,2) null,'
      '    InvoutAmountC decimal(20,2) null ,'
      '    InvBLNCAmountC decimal(20,2) null'
      '  )'
      'select * from #TmpArMonth ')
    Left = 584
    Top = 1
  end
  inherited DataSource: TDataSource
    Left = 616
    Top = 1
  end
  inherited ExtPrintReport: TExtPrintReport
    Left = 680
    Top = 1
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 648
    Top = 1
  end
end