sfc_wipprice.dfm

一个MRPII系统源代码版本

inherited Frm_Sfc_WipPrice: TFrm_Sfc_WipPrice
  Left = -14
  Top = 2
  Caption = '车间结存物料价格定义'
  ClientHeight = 553
  ClientWidth = 800
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 800
  end
  inherited Pnl_Title: TPanel
    Width = 800
    Caption = '车间结存物料价格定义'
  end
  inherited Pnl_Head: TPanel
    Width = 800
    inherited Lbl_Order: TLabel
      Width = 6
      Caption = ''
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 527
    Width = 800
  end
  inherited Pnl_Body: TPanel
    Width = 800
    Height = 430
    inherited DBGridEh: TDBGridEh
      Width = 800
      Height = 430
      Columns = <
        Item
          FieldName = 'wiPMonth'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '月份'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门名称'
          Width = 148
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 125
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 250
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 51
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Itemprice'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '价格'
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 208
    Top = 200
  end
  inherited AdoQry_Main: 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 wipPrice.wiPMonth,wipPrice.DeptCode,Dept.DeptName,wippric' +
        'e.ItemCode,Item.ItemName,Uom.UomName,wipPrice.Itemprice '
      '     From WipPrice '
      '     left Join Item On Item.ItemCode=WipPrice.ItemCode '
      'left join Dept on Dept.DeptCode=wipPrice.DeptCode '
      '     left join Uom on Uom.UomCode=Item.UomCode ')
    Top = 161
    object AdoQry_MainItemCode: TStringField
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_MainItemName: TStringField
      FieldName = 'ItemName'
      Size = 80
    end
    object AdoQry_MainUomName: TStringField
      FieldName = 'UomName'
      Size = 10
    end
    object AdoQry_MainItemprice: TFloatField
      FieldName = 'Itemprice'
    end
    object AdoQry_MainwiPMonth: TStringField
      FieldName = 'wiPMonth'
      Size = 7
    end
    object AdoQry_MainDeptCode: TStringField
      FieldName = 'DeptCode'
      Size = 8
    end
    object AdoQry_MainDeptName: TStringField
      FieldName = 'DeptName'
      Size = 40
    end
  end
end