bas_enter_customershipadd.dfm

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

inherited Frm_Bas_Enter_CustomerShipAdd: TFrm_Bas_Enter_CustomerShipAdd
  Left = 96
  Top = 134
  Caption = '客户送货地址主文件'
  ClientHeight = 494
  ClientWidth = 588
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 588
  end
  inherited Pnl_Title: TPanel
    Width = 588
    Caption = ' 客户收货地址'
    inherited Image2: TImage
      Width = 588
    end
  end
  inherited Pnl_Head: TPanel
    Width = 588
    inherited Image1: TImage
      Width = 588
    end
    inherited Lbl_Order: TLabel
      Width = 114
      Caption = ' 客户收货地址主文件'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 468
    Width = 588
    inherited Image4: TImage
      Width = 588
    end
  end
  inherited Pnl_Body: TPanel
    Width = 588
    Height = 371
    inherited Image3: TImage
      Width = 588
      Height = 371
    end
    inherited DBGridEh: TDBGridEh
      Width = 588
      Height = 371
      Columns = <
        Item
          FieldName = 'CustomerCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '客户代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'customerName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '客户名称'
          Width = 127
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipAddresSCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '客户收货地址代码'
          Width = 111
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShipAddressName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '客户收货地址名称'
          Width = 234
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 533
    Top = 49
  end
  inherited ActionList: TActionList
    Left = 398
    Top = 59
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Data Source=ExtDATASERVER;Use procedure for Prepa' +
      're=1;Auto Translate=True;Packet Size=4096;Workstation ID=CABO'
    CurSorType = ctStatic
    SQL.Strings = (
      'select CustomerShipAddress.CustomerCode,'
      #9'customer.customerName , '
      #9'CustomerShipAddress.ShipAddresSCode,'
      #9'CustomerShipAddress.ShipAddressName'
      'from CustomerShipAddress'
      
        'left join customer on CustomerShipAddress.customerCode=customer.' +
        'customerCode')
    Left = 442
    Top = 36
    object AdoQry_MainCustomerCode: TStringField
      FieldName = 'CustomerCode'
      Origin = 'CustomerShipAddress'
      Size = 12
    end
    object AdoQry_MaincustomerName: TStringField
      FieldName = 'customerName'
      Origin = 'Customer'
      Size = 60
    end
    object AdoQry_MainShipAddresSCode: TStringField
      FieldName = 'ShipAddresSCode'
      Origin = 'CustomerShipAddress'
      Size = 6
    end
    object AdoQry_MainShipAddressName: TStringField
      FieldName = 'ShipAddressName'
      Origin = 'CustomerShipAddress'
      Size = 60
    end
  end
  inherited DataSource: TDataSource
    Left = 494
    Top = 41
  end
  inherited ExtPrintReport: TExtPrintReport
    DataSet = AdoQry_Main
    Title1 = '计量单位主文件'
  end
end