ar_enter_gatheringinvoice.dfm

一个MRPII系统源代码版本

inherited Frm_Ar_Enter_GatheringInvoice: TFrm_Ar_Enter_GatheringInvoice
  Left = 44
  Top = 66
  Caption = '收款票据--销售发票核销'
  ClientHeight = 467
  ClientWidth = 780
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 780
  end
  inherited Pnl_Title: TPanel
    Width = 780
    Caption = '收款票据--销售发票核销'
    inherited Image2: TImage
      Width = 780
    end
  end
  inherited Pnl_Head: TPanel
    Width = 780
    Height = 142
    inherited Image1: TImage
      Width = 780
      Height = 142
    end
    object Label1: TLabel
      Left = 16
      Top = 6
      Width = 60
      Height = 12
      Caption = '收款序号：'
      TransParent = True
    end
    object Label2: TLabel
      Left = 16
      Top = 51
      Width = 60
      Height = 12
      Caption = '结算方式：'
      TransParent = True
    end
    object Label4: TLabel
      Left = 247
      Top = 6
      Width = 60
      Height = 12
      Caption = '票据日期：'
      TransParent = True
    end
    object Label5: TLabel
      Left = 16
      Top = 29
      Width = 60
      Height = 12
      Caption = '销售客户：'
      TransParent = True
    end
    object Label3: TLabel
      Left = 583
      Top = 52
      Width = 60
      Height = 12
      Caption = '会计科目：'
      TransParent = True
    end
    object Label6: TLabel
      Left = 412
      Top = 6
      Width = 36
      Height = 12
      Caption = '货币：'
      TransParent = True
    end
    object Label7: TLabel
      Left = 607
      Top = 6
      Width = 36
      Height = 12
      Caption = '汇率：'
      TransParent = True
    end
    object Label8: TLabel
      Left = 400
      Top = 52
      Width = 48
      Height = 12
      Caption = '单据号：'
      TransParent = True
    end
    object Label9: TLabel
      Left = 412
      Top = 75
      Width = 36
      Height = 12
      Caption = '银行：'
      TransParent = True
    end
    object Label10: TLabel
      Left = 583
      Top = 75
      Width = 60
      Height = 12
      Caption = '银行帐号：'
      TransParent = True
    end
    object Label11: TLabel
      Left = 412
      Top = 29
      Width = 36
      Height = 12
      Caption = '金额：'
      TransParent = True
    end
    object Label12: TLabel
      Left = 16
      Top = 74
      Width = 60
      Height = 12
      Caption = '销售部门：'
      TransParent = True
    end
    object Label13: TLabel
      Left = 4
      Top = 96
      Width = 72
      Height = 12
      Caption = '营销业务员：'
      TransParent = True
    end
    object Label16: TLabel
      Left = 40
      Top = 119
      Width = 36
      Height = 12
      Caption = '备注：'
      TransParent = True
    end
    object Label17: TLabel
      Left = 583
      Top = 29
      Width = 60
      Height = 12
      Caption = '核销金额：'
      TransParent = True
    end
    object Label14: TLabel
      Left = 247
      Top = 98
      Width = 60
      Height = 12
      Caption = '入帐日期：'
      TransParent = True
    end
    object edt_gatherno: TEdit
      Left = 79
      Top = 0
      Width = 91
      Height = 20
      TabOrder = 0
    end
    object medt_gatherdate: TMaskEdit
      Left = 310
      Top = 0
      Width = 75
      Height = 20
      EditMask = '9999.99.99;1;_'
      MaxLength = 10
      TabOrder = 1
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object edt_actCode: TEdit
      Left = 645
      Top = 46
      Width = 121
      Height = 20
      TabOrder = 17
    end
    object edt_rate: TEdit
      Left = 645
      Top = 0
      Width = 121
      Height = 20
      TabOrder = 13
      OnExit = FloatCheck
    end
    object edt_Billno: TEdit
      Left = 452
      Top = 46
      Width = 121
      Height = 20
      TabOrder = 16
    end
    object edt_Bank: TEdit
      Left = 452
      Top = 69
      Width = 121
      Height = 20
      TabOrder = 18
    end
    object edt_Bankaccno: TEdit
      Left = 645
      Top = 69
      Width = 121
      Height = 20
      TabOrder = 19
    end
    object edt_Amount: TEdit
      Left = 452
      Top = 23
      Width = 121
      Height = 20
      TabOrder = 14
      OnExit = FloatCheck
    end
    object edt_remArk: TEdit
      Left = 79
      Top = 115
      Width = 489
      Height = 20
      TabOrder = 20
    end
    object edt_CancelAmount: TEdit
      Left = 645
      Top = 23
      Width = 121
      Height = 20
      TabOrder = 15
      OnExit = FloatCheck
    end
    object edt_CustomerName: TEdit
      Left = 131
      Top = 23
      Width = 254
      Height = 20
      Enabled = False
      TabOrder = 3
    end
    object edt_BalanceTypeName: TEdit
      Left = 131
      Top = 46
      Width = 254
      Height = 20
      Enabled = False
      TabOrder = 5
    end
    object edt_CurrencyName: TEdit
      Left = 503
      Top = 0
      Width = 69
      Height = 20
      Enabled = False
      TabOrder = 12
    end
    object edt_DeptName: TEdit
      Left = 131
      Top = 69
      Width = 254
      Height = 20
      Enabled = False
      TabOrder = 7
    end
    object edt_EmployeeName: TEdit
      Left = 131
      Top = 92
      Width = 72
      Height = 20
      Enabled = False
      TabOrder = 9
    end
    object edt_CustomerCode: TLinkEdit
      Left = 79
      Top = 23
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 2
      OnButtonClick = CustomerHint1
      OnExit = edt_CustomerCodeExit
      OnKeyDown = CustomerHint
    end
    object edt_BalanceTypeCode: TLinkEdit
      Left = 79
      Top = 46
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 4
      OnButtonClick = edt_BalanceTypeCodeButtonClick
      OnExit = edt_BalanceTypeCodeExit
      OnKeyDown = edt_BalanceTypeCodeKeyDown
    end
    object edt_DeptCode: TLinkEdit
      Left = 79
      Top = 69
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 6
      OnButtonClick = DeptHint1
      OnExit = edt_DeptCodeExit
      OnKeyDown = DeptHint
    end
    object edt_EmployeeCode: TLinkEdit
      Left = 79
      Top = 92
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 8
      OnButtonClick = EmployeeHint1
      OnExit = edt_EmployeeCodeExit
      OnKeyDown = EmployeeHint
    end
    object edt_CurrencyCode: TLinkEdit
      Left = 452
      Top = 0
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 11
      OnButtonClick = CurrencyHint1
      OnExit = edt_CurrencyCodeExit
      OnKeyDown = CurrencyHint
    end
    object Medt_InAccountDate: TMaskEdit
      Left = 310
      Top = 92
      Width = 75
      Height = 20
      EditMask = '9999.99.99;1;_'
      MaxLength = 10
      TabOrder = 10
      Text = '    .  .  '
      OnExit = Medt_InAccountDateExit
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 441
    Width = 780
    inherited Image4: TImage
      Width = 780
    end
  end
  inherited Pnl_Body: TPanel
    Top = 199
    Width = 780
    Height = 242
    inherited Image3: TImage
      Width = 780
      Height = 242
    end
    inherited DBGridEh: TDBGridEh
      Width = 780
      Height = 242
      Columns = <
        Item
          FieldName = 'BillNo'
          PickList.Strings = ()
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BillDate'
          PickList.Strings = ()
          Width = 63
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleDeptCode'
          PickList.Strings = ()
          Title.Caption = '销售部门代码'
          Width = 77
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Caption = '销售部门名称'
          Width = 122
          KeyList.Strings = ()
        end
        Item
          FieldName = 'SaleEmployeeCode'
          PickList.Strings = ()
          Title.Caption = '销售人员代码'
          Width = 76
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Title.Caption = '销售人员名称'
          Width = 88
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TotalAmount'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ReMainTotalAmount'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ThiSCancelAmount'
          PickList.Strings = ()
          Width = 80
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 261
    Top = 251
  end
  inherited ActionList: TActionList
    Left = 184
    Top = 304
    inherited Act_auto: TAction
      Caption = '自动核销'
      Hint = '自动核销'
      OnExecute = Act_autoExecute
    end
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=192.1' +
      '68.0.151;Use procedure for Prepare=1;Auto Translate=True;Packet ' +
      'Size=4096;Workstation ID=XYB'
    SQL.Strings = (
      'select Ar_Gatheringline.*,'
      '       Dept.DeptName,'
      '       SaleDeptCode+'#39' '#39'+DeptName as Deptflag,'
      '       Employee.EmployeeName,'
      '       SaleEmployeeCode+'#39' '#39'+EmployeeName as SaleEmployeeflag'
      ' from Ar_Gatheringline'
      ' left join Dept on Ar_Gatheringline.SaleDeptCode=Dept.DeptCode'
      
        ' left join Employee on Ar_Gatheringline.SaleEmployeeCode=employe' +
        'e.EmployeeCode')
    Left = 360
    Top = 345
    object AdoQry_BodyGatheringNo: TStringField
      FieldName = 'GatheringNo'
      Size = 16
    end
    object AdoQry_BodyBillNo: TStringField
      DisplayLabel = '发票号'
      FieldName = 'BillNo'
      Size = 16
    end
    object AdoQry_BodySaleDeptCode: TStringField
      FieldName = 'SaleDeptCode'
      Size = 8
    end
    object AdoQry_BodySaleEmployeeCode: TStringField
      FieldName = 'SaleEmployeeCode'
      Size = 30
    end
    object AdoQry_BodyBillDate: TDateTimeField
      DisplayLabel = '单据日期'
      FieldName = 'BillDate'
    end
    object AdoQry_BodyTotalAmount: TFloatField
      DisplayLabel = '金额'
      FieldName = 'TotalAmount'
    end
    object AdoQry_BodyThiSCancelAmount: TFloatField
      DisplayLabel = '本次核销金额'
      FieldName = 'ThiSCancelAmount'
    end
    object AdoQry_BodyReMainTotalAmount: TFloatField
      DisplayLabel = '余额'
      FieldName = 'ReMainTotalAmount'
    end
    object AdoQry_BodyDeptflag: TStringField
      DisplayLabel = '销售部门'
      FieldName = 'Deptflag'
      ReadOnly = True
      Size = 49
    end
    object AdoQry_BodySaleEmployeeflag: TStringField
      DisplayLabel = '销售人员'
      FieldName = 'SaleEmployeeflag'
      ReadOnly = True
      Size = 91
    end
    object AdoQry_BodyID: TAutoIncField
      FieldName = 'ID'
      ReadOnly = True
    end
    object AdoQry_BodyDeptName: TStringField
      FieldName = 'DeptName'
      Size = 40
    end
    object AdoQry_BodyEmployeeName: TStringField
      FieldName = 'EmployeeName'
      Size = 60
    end
  end
  inherited DataSource: TDataSource
    Left = 256
    Top = 313
  end
  inherited ExtPrintReport: TExtPrintReport
    Left = 112
    Top = 273
  end
end