stk_enter_checkinvbill.dfm

一个MRPII系统源代码版本

inherited Frm_Stk_Enter_CheckInvBill: TFrm_Stk_Enter_CheckInvBill
  Left = 16
  Top = 115
  Caption = '盘点单'
  ClientHeight = 507
  ClientWidth = 804
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 804
  end
  inherited Pnl_Title: TPanel
    Width = 804
    Caption = '盘点单'
    inherited Image2: TImage
      Width = 804
    end
  end
  inherited Pnl_Head: TPanel
    Width = 804
    Height = 80
    inherited Image1: TImage
      Width = 804
      Height = 80
    end
    object Label1: TLabel
      Left = 17
      Top = 5
      Width = 60
      Height = 12
      Caption = '盘点仓库：'
      TransParent = True
    end
    object Label4: TLabel
      Left = 17
      Top = 31
      Width = 60
      Height = 12
      Caption = '盘点部门：'
      TransParent = True
    end
    object Label7: TLabel
      Left = 589
      Top = 5
      Width = 60
      Height = 12
      Caption = '盘点单号：'
      TransParent = True
    end
    object Label8: TLabel
      Left = 17
      Top = 58
      Width = 60
      Height = 12
      Caption = '盘点日期：'
      TransParent = True
    end
    object Label3: TLabel
      Left = 210
      Top = 58
      Width = 36
      Height = 12
      Caption = '备注：'
      TransParent = True
    end
    object Label5: TLabel
      Left = 300
      Top = 5
      Width = 60
      Height = 12
      Caption = '盘点货位：'
      TransParent = True
    end
    object Label2: TLabel
      Left = 588
      Top = 31
      Width = 60
      Height = 12
      Caption = '单据日期：'
      TransParent = True
    end
    object Label6: TLabel
      Left = 300
      Top = 31
      Width = 60
      Height = 12
      Caption = '盘点人员：'
      TransParent = True
    end
    object CmBx_Warehouse: TComboBox
      Left = 74
      Top = 1
      Width = 169
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      TabOrder = 0
      OnChange = CmBx_WarehouseChange
    end
    object Edt_BillNo: TEdit
      Left = 646
      Top = 1
      Width = 100
      Height = 20
      TabStop = False
      ReadOnly = True
      TabOrder = 2
    end
    object MEdt_BillDate: TMaskEdit
      Left = 74
      Top = 54
      Width = 84
      Height = 20
      EditMask = '0000\.00\.00;1;_'
      MaxLength = 10
      TabOrder = 6
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object CmBx_WhPosition: TComboBox
      Left = 358
      Top = 1
      Width = 177
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      TabOrder = 1
      OnChange = CmBx_WhPositionChange
    end
    object Edt_RemArk: TEdit
      Left = 244
      Top = 54
      Width = 401
      Height = 20
      MaxLength = 120
      TabOrder = 7
    end
    object MEdt_InAccountDate: TMaskEdit
      Left = 646
      Top = 27
      Width = 100
      Height = 20
      EditMask = '0000\.00\.00;1;_'
      MaxLength = 10
      TabOrder = 5
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object LEdt_CheckEmployeeCode: TLinkEdit
      Left = 358
      Top = 27
      Width = 69
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 4
      OnButtonClick = LEdt_CheckEmployeeCodeButtonClick
      OnExit = LEdt_CheckEmployeeCodeExit
      OnKeyDown = LEdt_CheckEmployeeCodeKeyDown
    end
    object Edt_CheckEmployeeName: TEdit
      Left = 429
      Top = 27
      Width = 105
      Height = 20
      TabStop = False
      Enabled = False
      TabOrder = 8
    end
    object ExtEdt_VendorCode: TLinkEdit
      Left = 74
      Top = 27
      Width = 68
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 3
      OnButtonClick = ExtEdt_VendorCodeButtonClick
      OnExit = ExtEdt_VendorCodeExit
      OnKeyDown = ExtEdt_VendorCodeKeyDown
    end
    object Lbl_VendorName: TEdit
      Left = 142
      Top = 27
      Width = 100
      Height = 20
      TabStop = False
      Enabled = False
      TabOrder = 9
    end
    object Button1: TButton
      Left = 682
      Top = 54
      Width = 65
      Height = 20
      Caption = '盘点'
      TabOrder = 10
      OnClick = Button1Click
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 504
    Width = 804
    Height = 3
    inherited Image4: TImage
      Width = 804
      Height = 3
    end
  end
  inherited Pnl_Body: TPanel
    Top = 137
    Width = 804
    Height = 367
    inherited Image3: TImage
      Width = 804
      Height = 367
    end
    inherited DBGridEh: TDBGridEh
      Width = 804
      Height = 367
      ReadOnly = False
      OnColEnter = DBGridEhColEnter
      OnColExit = DBGridEhColExit
      OnExit = DBGridEhExit
      OnKeyPress = DBGridEhKeyPress
      Columns = <
        Item
          FieldName = 'InvBillLineNo'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '盘点单行号'
          Width = 48
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 95
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 234
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 35
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BatchNo'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '批次号'
          Width = 82
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AccountQty'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '帐面数'
          Width = 78
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CheckQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '盘点数'
          Width = 72
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ProfitLossQty'
          PickList.Strings = ()
          ReadOnly = True
          Title.Alignment = taCenter
          Title.Caption = '盈亏数量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PLCause'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '盈亏原因'
          Width = 150
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 709
    Top = 3
  end
  inherited ActionList: TActionList
    Left = 560
    Top = 0
  end
  inherited AdoQry_Body: TAdoQuery
    CacheSize = 100
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_kelong;Data Source=ExtDATAS' +
      'ERVER'
    BeforeEdit = AdoQry_BodyBeforeEdit
    SQL.Strings = (
      
        'Select Inv_CheckInvBillLine.InvBillLineNo    ,Inv_CheckInvBillLi' +
        'ne.ItemCode'
      '    ,Inv_CheckInvBillLine.BatchNo'
      '    ,Item.ItemName'
      '    ,Uom.UomName'
      '    ,Inv_CheckInvBillLine.AccountQty'
      '    ,Inv_CheckInvBillLine.CheckQty'
      '    ,Inv_CheckInvBillLine.ProfitLossQty'
      '    ,Inv_CheckInvBillLine.PLCause '
      '     From Inv_CheckInvBillLine'
      
        '     left Join Item On Inv_CheckInvBillLine.ItemCode=Item.ItemCo' +
        'de'
      '     left Join Uom On Item.UomCode=Uom.UomCode')
    Left = 592
    Top = 1
    object AdoQry_BodyInvBillLineNo: TIntegerField
      FieldName = 'InvBillLineNo'
    end
    object AdoQry_BodyItemCode: TStringField
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_BodyBatchNo: TStringField
      FieldName = 'BatchNo'
      Size = 16
    end
    object AdoQry_BodyItemName: TStringField
      FieldName = 'ItemName'
      Size = 80
    end
    object AdoQry_BodyUomName: TStringField
      FieldName = 'UomName'
      Size = 10
    end
    object AdoQry_BodyAccountQty: TFloatField
      FieldName = 'AccountQty'
    end
    object AdoQry_BodyCheckQty: TFloatField
      FieldName = 'CheckQty'
      OnChange = AdoQry_BodyCheckQtyChange
    end
    object AdoQry_BodyProfitLossQty: TFloatField
      FieldName = 'ProfitLossQty'
    end
    object AdoQry_BodyPLCause: TStringField
      FieldName = 'PLCause'
      Size = 200
    end
  end
  inherited DataSource: TDataSource
    Left = 632
    Top = 1
  end
  inherited ExtPrintReport: TExtPrintReport
    PAperSet = [ptA4]
    Left = 672
    Top = 1
  end
end