inv_opadjustbill.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_OpAdjustBill: TFrm_Inv_OpAdjustBill
  Left = 110
  Top = 109
  Caption = '委外加工材料结存调整'
  ClientHeight = 359
  ClientWidth = 556
  Position = poDefault
  Windowstate = wsMaximized
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 556
    inherited ToolBar: TToolBar
      inherited TlBtn_Modify: TToolButton
        Visible = False
      end
      inherited TlBtn_Delete: TToolButton
        Visible = False
      end
    end
  end
  inherited Pnl_Title: TPanel
    Width = 556
  end
  inherited Pnl_Head: TPanel
    Width = 556
  end
  inherited Pnl_Hint: TPanel
    Top = 347
    Width = 556
    Height = 12
  end
  inherited Pnl_Body: TPanel
    Width = 556
    Height = 250
    inherited DBGridEh: TDBGridEh
      Width = 556
      Height = 250
      OnDblClick = Act_LookExecute
      Columns = <
        Item
          FieldName = 'opBillno'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单据号'
          Width = 68
          KeyList.Strings = ()
        end
        Item
          FieldName = 'opBillDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单据日期'
          Width = 75
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Caption = '供应商代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorName1'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商描述'
          Width = 235
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '操作员'
          Width = 71
          KeyList.Strings = ()
        end
        Item
          FieldName = 'opBillRemArk'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '备注'
          Width = 122
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Head: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=192.168.0.15' +
      '1;Use procedure for Prepare=1;Auto Translate=True;Packet Size=40' +
      '96;Workstation ID=XYB'
    SQL.Strings = (
      
        'select o.opBillid,v.VendorName as VendorName1,o.VendorCode,o.ven' +
        'dorCode+'#39' '#39'+v.VendorName as VendorName,'
      
        '              o.opBillno,v.Vendortaxrate_Percent,v.currencyCode+' +
        #39' '#39'+c.currencyName as currencyName,'
      '              o.opBillDate,'
      '              o.EmployeeCode+'#39' '#39'+e.EmployeeName as EmployeeName,'
      '              o.opBillRemArk '
      '              from opAdjustBill o '
      '              left join Vendor v on o.VendorCode=v.VendorCode '
      
        '              left join Employee e on o.EmployeeCode=e.Employeec' +
        'ode '
      
        '              left join currency c on c.currencyCode=v.currencyc' +
        'ode ')
  end
end