stk_enter_passcheckinvbill.dfm

一个MRPII系统源代码版本

inherited Frm_Stk_Enter_PassCheckInvBill: TFrm_Stk_Enter_PassCheckInvBill
  Left = 11
  Top = 110
  Caption = '盘点单批准'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '盘点单批准'
  end
  inherited Pnl_Head: TPanel
    Height = 80
    inherited Image1: TImage
      Height = 80
    end
    object Label1: TLabel
      Left = 17
      Top = 5
      Width = 60
      Height = 12
      Caption = '盘点仓库：'
      TransParent = True
    end
    object Label5: TLabel
      Left = 300
      Top = 5
      Width = 60
      Height = 12
      Caption = '盘点货位：'
      TransParent = True
    end
    object Label7: TLabel
      Left = 589
      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 Label8: TLabel
      Left = 17
      Top = 58
      Width = 60
      Height = 12
      Caption = '盘点日期：'
      TransParent = True
    end
    object Label3: TLabel
      Left = 324
      Top = 58
      Width = 36
      Height = 12
      Caption = '备注：'
      TransParent = True
    end
    object Label6: TLabel
      Left = 300
      Top = 31
      Width = 60
      Height = 12
      Caption = '盘点人员：'
      TransParent = True
    end
    object Label2: TLabel
      Left = 588
      Top = 31
      Width = 60
      Height = 12
      Caption = '单据日期：'
      TransParent = True
    end
    object Label9: TLabel
      Left = 167
      Top = 58
      Width = 48
      Height = 12
      Caption = '批准人：'
      TransParent = True
      Visible = False
    end
    object CmBx_Warehouse: TComboBox
      Left = 74
      Top = 1
      Width = 169
      Height = 20
      Style = csSimple
      Enabled = False
      ItemHeight = 12
      TabOrder = 0
    end
    object CmBx_WhPosition: TComboBox
      Left = 358
      Top = 1
      Width = 177
      Height = 20
      Style = csSimple
      Enabled = False
      ItemHeight = 12
      TabOrder = 1
    end
    object Edt_BillNo: TEdit
      Left = 646
      Top = 1
      Width = 100
      Height = 20
      TabStop = False
      Enabled = False
      ReadOnly = True
      TabOrder = 2
    end
    object MEdt_InAccountDate: TMaskEdit
      Left = 646
      Top = 27
      Width = 100
      Height = 20
      Enabled = False
      EditMask = '0000\.00\.00;1;_'
      MaxLength = 10
      TabOrder = 3
      Text = '    .  .  '
    end
    object Edt_CheckEmployeeName: TEdit
      Left = 429
      Top = 27
      Width = 105
      Height = 20
      TabStop = False
      Enabled = False
      TabOrder = 4
    end
    object LEdt_CheckEmployeeCode: TLinkEdit
      Left = 358
      Top = 27
      Width = 69
      Height = 20
      Enabled = False
      LinkStyle = lsEllipsis
      TabOrder = 5
    end
    object Lbl_VendorName: TEdit
      Left = 142
      Top = 27
      Width = 100
      Height = 20
      TabStop = False
      Enabled = False
      TabOrder = 6
    end
    object ExtEdt_VendorCode: TLinkEdit
      Left = 74
      Top = 27
      Width = 68
      Height = 20
      Enabled = False
      LinkStyle = lsEllipsis
      TabOrder = 7
    end
    object MEdt_BillDate: TMaskEdit
      Left = 74
      Top = 54
      Width = 84
      Height = 20
      Enabled = False
      EditMask = '0000\.00\.00;1;_'
      MaxLength = 10
      TabOrder = 8
      Text = '    .  .  '
    end
    object Edt_RemArk: TEdit
      Left = 358
      Top = 54
      Width = 388
      Height = 20
      MaxLength = 120
      TabOrder = 9
    end
    object Edt_PassEmployeeName: TEdit
      Left = 231
      Top = 54
      Width = 9
      Height = 20
      TabStop = False
      Enabled = False
      TabOrder = 10
      Visible = False
    end
    object LEdt_PassEmployeeCode: TLinkEdit
      Left = 214
      Top = 54
      Width = 18
      Height = 20
      TabStop = False
      Enabled = False
      LinkStyle = lsEllipsis
      TabOrder = 11
      Visible = False
      OnButtonClick = LEdt_PassEmployeeCodeButtonClick
      OnExit = LEdt_PassEmployeeCodeExit
      OnKeyDown = LEdt_PassEmployeeCodeKeyDown
    end
  end
  inherited Pnl_Body: TPanel
    Top = 137
    Height = 305
    inherited Image3: TImage
      Height = 305
    end
    inherited DBGridEh: TDBGridEh
      Height = 305
      Columns = <
        Item
          Alignment = taLeftJustify
          FieldName = 'InvBillLineNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '盘点单行号'
          Width = 39
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 69
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 193
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BatchNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '批次号'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AccountQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '账面数'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CheckQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '盘点数'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ProfitLossQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '盈亏数量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PLCause'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '盈亏原因'
          Width = 179
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 693
    Top = 65531
  end
  inherited ActionList: TActionList
    Left = 576
    Top = 0
    inherited Act_Check: TAction
      OnExecute = Act_CheckExecute
    end
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_kl;Data Source=ExtDATASERVE' +
      'R;Use procedure for Prepare=1;Auto Translate=True;Packet Size=40' +
      '96;Workstation ID=XYB'
    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 = 608
    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'
    end
    object AdoQry_BodyProfitLossQty: TFloatField
      FieldName = 'ProfitLossQty'
    end
    object AdoQry_BodyPLCause: TStringField
      FieldName = 'PLCause'
      Size = 200
    end
  end
  inherited DataSource: TDataSource
    Left = 640
    Top = 1
  end
end