sfc_wipwaster.dfm

一个MRPII系统源代码版本

inherited Frm_Sfc_WipWaster: TFrm_Sfc_WipWaster
  Left = 18
  Top = 96
  Caption = '车间工废统计'
  ClientWidth = 731
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 731
  end
  inherited Pnl_Title: TPanel
    Width = 731
    Caption = '车间工废记录'
    inherited Image2: TImage
      Width = 731
    end
  end
  inherited Pnl_Head: TPanel
    Width = 731
    inherited Image1: TImage
      Width = 731
    end
    inherited Lbl_Condition: TLabel
      Left = 82
      Width = 48
      Caption = '本月记录'
    end
    inherited Lbl_Order: TLabel
      Left = 81
      Top = 22
      Width = 78
      Caption = '日期,物料代码'
    end
  end
  inherited Pnl_Hint: TPanel
    Width = 731
    inherited Image4: TImage
      Width = 731
    end
  end
  inherited Pnl_Body: TPanel
    Width = 731
    inherited Image3: TImage
      Width = 731
    end
    inherited DBGridEh: TDBGridEh
      Width = 731
      Options = [dgEditing, dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit]
      Columns = <
        Item
          FieldName = 'DeptCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门代码'
          Width = 57
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门名称'
          Width = 83
          KeyList.Strings = ()
        end
        Item
          FieldName = 'shiftType'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '班别'
          Width = 50
          KeyList.Strings = ()
        end
        Item
          FieldName = 'wipdate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '日期'
          Width = 75
          KeyList.Strings = ()
        end
        Item
          FieldName = 'mono'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '生产订单号'
          Width = 88
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineno'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '行号'
          Width = 26
          KeyList.Strings = ()
        end
        Item
          FieldName = 'WasterType'
          PickList.Strings = (
            '1 料废'
            '2 工废')
          Title.Alignment = taCenter
          Title.Caption = '报废类型'
          KeyList.Strings = (
            '1'
            '2')
        end
        Item
          FieldName = 'BillNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '记录单号'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 115
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 203
          KeyList.Strings = ()
        end
        Item
          FieldName = 'wipqty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '工废数量'
          Width = 57
          KeyList.Strings = ()
        end
        Item
          FieldName = 'wipAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '金额'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'WasterCause'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '报废原因'
          Width = 191
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeCode_Create'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '建档人员代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '建档人员姓名'
          Width = 54
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Date_Create'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '建档日期'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeCode_Edit'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '改档人员代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EdItEmployeeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '改档人员姓名'
          Width = 58
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Date_Edit'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '改档日期'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'RemArk'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '备注'
          Width = 143
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Top = 219
  end
  inherited ActionList: TActionList
    Top = 168
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = ''
    CurSorType = ctStatic
    SQL.Strings = (
      'select WipWaster.*,Dept.DeptName,'
      '                 i.ItemName as ite_ItemName,'
      '                 Item.ItemName,'
      '                 Employee.EmployeeName,'
      '                 E1.EmployeeName As EdItEmployeeName'
      '                 from WipWaster '
      '                 join Item on Item.ItemCode=WipWaster.ItemCode '
      
        '                 join Item i on i.ItemCode=WipWaster.ite_Itemcod' +
        'e '
      
        '                 left join Dept on Dept.DeptCode=WipWaster.Deptc' +
        'ode '
      
        '                 Left Join Employee On Employee.EmployeeCode=Wip' +
        'Waster.EmployeeCode_Create'
      
        '                 Left Join Employee E1 On E1.EmployeeCode=WipWas' +
        'ter.EmployeeCode_Edit'
      ''
      '               ')
    Left = 136
    Top = 209
    object AdoQry_Mainmono: TStringField
      FieldName = 'mono'
      Origin = 'WipWaster'
      Size = 16
    end
    object AdoQry_MainMoLineno: TIntegerField
      FieldName = 'MoLineno'
      Origin = 'WipWaster'
    end
    object AdoQry_Mainwipdate: TDateTimeField
      FieldName = 'wipdate'
      Origin = 'WipWaster'
      DisplayFormat = 'yyyy.mm.dd'
    end
    object AdoQry_Mainite_ItemCode: TStringField
      FieldName = 'ite_ItemCode'
      Origin = 'WipWaster'
      Size = 16
    end
    object AdoQry_MainItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = 'WipWaster'
      Size = 16
    end
    object AdoQry_MainDeptCode: TStringField
      FieldName = 'DeptCode'
      Origin = 'WipWaster'
      Size = 8
    end
    object AdoQry_MainshiftType: TStringField
      FieldName = 'shiftType'
      Origin = 'WipWaster'
    end
    object AdoQry_Mainwipqty: TFloatField
      FieldName = 'wipqty'
      Origin = 'WipWaster'
    end
    object AdoQry_MainwipAmount: TFloatField
      FieldName = 'wipAmount'
      Origin = 'WipWaster'
    end
    object AdoQry_MaInBillNo: TStringField
      FieldName = 'BillNo'
      Origin = 'WipWaster'
      Size = 16
    end
    object AdoQry_MainWasterType: TIntegerField
      FieldName = 'WasterType'
      Origin = 'WipWaster'
    end
    object AdoQry_MainWasterCause: TStringField
      FieldName = 'WasterCause'
      Origin = 'WipWaster'
      Size = 120
    end
    object AdoQry_MainRemArk: TStringField
      FieldName = 'RemArk'
      Origin = 'WipWaster'
      Size = 60
    end
    object AdoQry_MainDate_Create: TDateTimeField
      FieldName = 'Date_Create'
      Origin = 'WipWaster'
    end
    object AdoQry_MainDate_Edit: TDateTimeField
      FieldName = 'Date_Edit'
      Origin = 'WipWaster'
    end
    object AdoQry_MainEmployeeCode_Create: TStringField
      FieldName = 'EmployeeCode_Create'
      Origin = 'WipWaster'
      Size = 30
    end
    object AdoQry_MainEmployeeCode_Edit: TStringField
      FieldName = 'EmployeeCode_Edit'
      Origin = 'WipWaster'
      Size = 30
    end
    object AdoQry_MainDeptName: TStringField
      FieldName = 'DeptName'
      Origin = 'Dept'
      Size = 40
    end
    object AdoQry_Mainite_ItemName: TStringField
      FieldName = 'ite_ItemName'
      Size = 80
    end
    object AdoQry_MainItemName: TStringField
      FieldName = 'ItemName'
      Origin = 'Item'
      Size = 80
    end
    object AdoQry_MainEmployeeName: TStringField
      FieldName = 'EmployeeName'
      Origin = 'Employee'
      Size = 60
    end
    object AdoQry_MainEdItEmployeeName: TStringField
      FieldName = 'EdItEmployeeName'
      Size = 60
    end
  end
  inherited DataSource: TDataSource
    Left = 304
    Top = 225
  end
end