pm_buyer.dfm

一个MRPII系统源代码版本

inherited Frm_Pm_Buyer: TFrm_Pm_Buyer
  Left = 162
  Top = 44
  Caption = ''
  ClientHeight = 494
  ClientWidth = 460
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 460
  end
  inherited Pnl_Title: TPanel
    Width = 460
    Caption = '采购员'
    inherited Image2: TImage
      Width = 460
    end
  end
  inherited Pnl_Head: TPanel
    Width = 460
    inherited Image1: TImage
      Width = 460
    end
    inherited Lbl_Order: TLabel
      Width = 48
      Caption = '人员代码'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 468
    Width = 460
    inherited Image4: TImage
      Width = 460
    end
  end
  inherited Pnl_Body: TPanel
    Width = 460
    Height = 371
    inherited Image3: TImage
      Width = 460
      Height = 371
    end
    inherited DBGridEh: TDBGridEh
      Width = 460
      Height = 371
      Columns = <
        Item
          FieldName = 'EmployeeCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '人员代码'
          Width = 134
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '人员标识'
          Width = 119
          KeyList.Strings = ()
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'BUYERUsable'
          PickList.Strings = (
            '否'
            '是')
          Title.Alignment = taCenter
          Title.Caption = '是否可用'
          Width = 67
          KeyList.Strings = (
            '0'
            '1')
        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=192.168.0.8;Use procedure for PrepAr' +
      'e=1;Auto Translate=True;Packet Size=4096;Workstation ID=CABO'
    CurSorType = ctStatic
    SQL.Strings = (
      
        'select Buyer.*,Employee.EmployeeName, case buyer.buyerUsable whe' +
        'n 0 then '#39'??'#39
      'else '#39'???'#39
      
        '     end as isstop from Buyer  join Employee  ON Buyer.EmployeeC' +
        'ode=Employee.EmployeeCode')
    Left = 166
    Top = 163
    object AdoQry_MainEmployeeCode: TStringField
      FieldName = 'EmployeeCode'
      Origin = 'Buyer'
      Size = 30
    end
    object AdoQry_MainEmployeeName: TStringField
      FieldName = 'EmployeeName'
      Origin = 'Employee'
      Size = 60
    end
    object AdoQry_MainBUYERUsable: TIntegerField
      FieldName = 'BUYERUsable'
      Origin = 'buyer'
    end
  end
  inherited DataSource: TDataSource
    Left = 494
    Top = 41
  end
  inherited ExtPrintReport: TExtPrintReport
    Title1 = '采购员主文件'
  end
end