📄 frmdxunit.~dfm

📁 根据客户对销售人员回款返利和业绩返利的功能需求所开发
💻 ~DFM
📖 第 1 页 / 共 2 页
字号:
上一页 12
      Selected.Strings = (
        'SAL_NO'#9'12'#9#19994#21153#21592#32534#21495#9'F'
        'NAME'#9'40'#9#19994#21153#21592#21517#31216#9'F')
      LookupTable = qrySAL_NAME2
      LookupField = 'SAL_NO'
      TabOrder = 1
      AutoDropDown = False
      ShowButton = True
      AllowClearKey = False
    end
    object ww4: TwwDBLookupComboDlg
      Left = 248
      Top = 43
      Width = 121
      Height = 21
      GridOptions = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgPerfectRowFit]
      GridColor = clWhite
      GridTitleAlignment = taLeftJustify
      Caption = 'Lookup'
      MaxWidth = 0
      MaxHeight = 209
      Selected.Strings = (
        'SAL_NO'#9'12'#9#19994#21153#21592#32534#21495#9'F'
        'NAME'#9'40'#9#19994#21153#21592#21517#31216#9'F')
      LookupTable = qrySAL_NAME2
      LookupField = 'SAL_NO'
      TabOrder = 2
      AutoDropDown = False
      ShowButton = True
      AllowClearKey = False
    end
    object ww5: TwwDBLookupComboDlg
      Left = 112
      Top = 70
      Width = 121
      Height = 21
      GridOptions = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgPerfectRowFit]
      GridColor = clWhite
      GridTitleAlignment = taLeftJustify
      Caption = 'Lookup'
      MaxWidth = 0
      MaxHeight = 209
      Selected.Strings = (
        'oS_NO'#9'20'#9#35746#21333#32534#21495#9'F'
        'OS_DD'#9'18'#9#35746#21333#26085#26399#9'F'
        'CUS_NO'#9'12'#9#23458#25143#32534#21495#9'F'
        'SAL_NO'#9'12'#9#19994#21153#21592#32534#21495#9'F')
      LookupTable = qrySO2
      LookupField = 'oS_NO'
      TabOrder = 3
      AutoDropDown = False
      ShowButton = True
      AllowClearKey = False
      OnChange = wwDBLookupComboDlg1Change
    end
    object ww6: TwwDBLookupComboDlg
      Left = 248
      Top = 68
      Width = 121
      Height = 21
      GridOptions = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgPerfectRowFit]
      GridColor = clWhite
      GridTitleAlignment = taLeftJustify
      Caption = 'Lookup'
      MaxWidth = 0
      MaxHeight = 209
      Selected.Strings = (
        'oS_NO'#9'20'#9#35746#21333#32534#21495#9'F'
        'OS_DD'#9'18'#9#35746#21333#26085#26399#9'F'
        'CUS_NO'#9'12'#9#23458#25143#32534#21495#9'F'
        'SAL_NO'#9'12'#9#19994#21153#21592#32534#21495#9'F')
      LookupTable = qrySO2
      LookupField = 'oS_NO'
      TabOrder = 4
      AutoDropDown = False
      ShowButton = True
      AllowClearKey = False
      OnChange = wwDBLookupComboDlg1Change
    end
    object Button1: TButton
      Left = 400
      Top = 64
      Width = 75
      Height = 25
      Caption = #36895#26597
      TabOrder = 5
      OnClick = Button1Click
    end
    object ww2: TwwDBLookupComboDlg
      Left = 248
      Top = 16
      Width = 121
      Height = 21
      GridOptions = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgPerfectRowFit]
      GridColor = clWhite
      GridTitleAlignment = taLeftJustify
      Caption = 'Lookup'
      MaxWidth = 0
      MaxHeight = 209
      Selected.Strings = (
        'cus_no'#9'12'#9#23458#25143#32534#21495#9'F'
        'name'#9'50'#9#23458#25143#21517#31216#9'F')
      LookupTable = qryCUS_NO
      LookupField = 'cus_no'
      TabOrder = 6
      AutoDropDown = False
      ShowButton = True
      AllowClearKey = False
    end
  end
  object wwDBGrid1: TwwDBGrid [4]
    Left = 0
    Top = 241
    Width = 688
    Height = 180
    Selected.Strings = (
      'DXDH'#9'9'#9#20817#29616#21333#21495
      'SAL_NO'#9'9'#9#38144#21806#20154#21592
      'SAL_NAME'#9'13'#9#20154#21592#21517#31216
      'DXDATE'#9'12'#9#20817#29616#26085#26399
      'OS_NO'#9'12'#9#21463#35746#21333#21495
      'YQTY'#9'14'#9#26412#27425#24212#20817#25442#37329#39069
      'Rate'#9'12'#9#20817#25442#27604#20363'%'#9'F'
      'QTY'#9'11'#9#20817#25442#37329#39069)
    IniAttributes.Delimiter = ';;'
    ExportOptions.ExportType = wwgetSYLK
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    Align = alClient
    DataSource = dsMaster
    ReadOnly = True
    TabOrder = 3
    TitleAlignment = taLeftJustify
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
  end
  inherited dsMaster: TDataSource
    DataSet = qryDX
    Left = 488
    Top = 184
  end
  inherited fSave: TSaveDialog
    Left = 600
    Top = 256
  end
  object qryDX: TADOQuery
    AutoCalcFields = False
    Connection = dm.ADOConnection2
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from dx where 1=2')
    Left = 544
    Top = 152
    object qryDXDXDH: TStringField
      DisplayLabel = #20817#29616#21333#21495
      DisplayWidth = 9
      FieldName = 'DXDH'
      Size = 30
    end
    object qryDXSAL_NO: TStringField
      DisplayLabel = #38144#21806#20154#21592
      DisplayWidth = 9
      FieldName = 'SAL_NO'
      Size = 30
    end
    object qryDXSAL_NAME: TStringField
      DisplayLabel = #20154#21592#21517#31216
      DisplayWidth = 13
      FieldKind = fkLookup
      FieldName = 'SAL_NAME'
      LookupDataSet = qrySAL_NAME
      LookupKeyFields = 'SAL_NO'
      LookupResultField = 'NAME'
      KeyFields = 'SAL_NO'
      Size = 30
      Lookup = True
    end
    object qryDXDXDATE: TDateTimeField
      DisplayLabel = #20817#29616#26085#26399
      DisplayWidth = 12
      FieldName = 'DXDATE'
    end
    object qryDXOS_NO: TStringField
      DisplayLabel = #21463#35746#21333#21495
      DisplayWidth = 12
      FieldName = 'OS_NO'
      Size = 30
    end
    object qryDXYQTY: TBCDField
      DisplayLabel = #26412#27425#24212#20817#25442#37329#39069
      DisplayWidth = 14
      FieldName = 'YQTY'
      Precision = 28
      Size = 8
    end
    object qryDXRate: TBCDField
      DisplayLabel = #20817#25442#27604#20363'%'
      DisplayWidth = 12
      FieldName = 'Rate'
      Precision = 28
      Size = 8
    end
    object qryDXQTY: TBCDField
      DisplayLabel = #20817#25442#37329#39069
      DisplayWidth = 11
      FieldName = 'QTY'
      DisplayFormat = '0.00'
      Precision = 28
      Size = 8
    end
    object qryDXQTY1: TBCDField
      FieldName = 'QTY1'
      Precision = 28
      Size = 8
    end
    object qryDXQTY2: TBCDField
      FieldName = 'QTY2'
      Precision = 28
      Size = 8
    end
    object qryDXQTY3: TBCDField
      FieldName = 'QTY3'
      Precision = 28
      Size = 8
    end
    object qryDXQTY4: TBCDField
      FieldName = 'QTY4'
      Precision = 28
      Size = 8
    end
  end
  object qrySO: TADOQuery
    Connection = dm.ADOConnection2
    Parameters = <>
    SQL.Strings = (
      ''
      'select oS_NO,OS_DD,CUS_NO,SAL_NO from MF_POS where OS_ID='#39'SO'#39' ')
    Left = 368
    Top = 184
    object qrySOoS_NO: TStringField
      DisplayLabel = #35746#21333#32534#21495
      DisplayWidth = 20
      FieldName = 'oS_NO'
    end
    object qrySOOS_DD: TDateTimeField
      DisplayLabel = #35746#21333#26085#26399
      DisplayWidth = 18
      FieldName = 'OS_DD'
    end
    object qrySOCUS_NO: TStringField
      DisplayLabel = #23458#25143#32534#21495
      DisplayWidth = 12
      FieldName = 'CUS_NO'
      Size = 12
    end
    object qrySOSAL_NO: TStringField
      DisplayLabel = #19994#21153#21592#32534#21495
      DisplayWidth = 12
      FieldName = 'SAL_NO'
      Size = 12
    end
  end
  object qrySAL_NAME: TADOQuery
    Active = True
    Connection = dm.ADOConnection2
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select SAL_NO,NAME from salm')
    Left = 432
    Top = 256
    object qrySAL_NAMESAL_NO: TStringField
      DisplayLabel = #19994#21153#21592#32534#21495
      DisplayWidth = 12
      FieldName = 'SAL_NO'
      Size = 12
    end
    object qrySAL_NAMENAME: TStringField
      DisplayLabel = #19994#21153#21592#21517#31216
      DisplayWidth = 40
      FieldName = 'NAME'
      Size = 40
    end
  end
  object qryCUS_NO: TADOQuery
    Connection = dm.ADOConnection2
    Parameters = <>
    SQL.Strings = (
      'select cus_no,name from cust where obj_id in ('#39'1'#39','#39'3'#39')')
    Left = 528
    Top = 280
    object qryCUS_NOcus_no: TStringField
      DisplayLabel = #23458#25143#32534#21495
      DisplayWidth = 12
      FieldName = 'cus_no'
      Size = 12
    end
    object qryCUS_NOname: TStringField
      DisplayLabel = #23458#25143#21517#31216
      DisplayWidth = 50
      FieldName = 'name'
      Size = 50
    end
  end
  object qrySAL_NAME2: TADOQuery
    Connection = dm.ADOConnection2
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select SAL_NO,NAME from salm')
    Left = 456
    Top = 352
    object StringField1: TStringField
      DisplayLabel = #19994#21153#21592#32534#21495
      DisplayWidth = 12
      FieldName = 'SAL_NO'
      Size = 12
    end
    object StringField2: TStringField
      DisplayLabel = #19994#21153#21592#21517#31216
      DisplayWidth = 40
      FieldName = 'NAME'
      Size = 40
    end
  end
  object qrySO2: TADOQuery
    Connection = dm.ADOConnection2
    Parameters = <>
    SQL.Strings = (
      ''
      'select oS_NO,OS_DD,CUS_NO,SAL_NO from MF_POS where OS_ID='#39'SO'#39' ')
    Left = 368
    Top = 288
    object StringField3: TStringField
      DisplayLabel = #35746#21333#32534#21495
      DisplayWidth = 20
      FieldName = 'oS_NO'
    end
    object DateTimeField1: TDateTimeField
      DisplayLabel = #35746#21333#26085#26399
      DisplayWidth = 18
      FieldName = 'OS_DD'
    end
    object StringField4: TStringField
      DisplayLabel = #23458#25143#32534#21495
      DisplayWidth = 12
      FieldName = 'CUS_NO'
      Size = 12
    end
    object StringField5: TStringField
      DisplayLabel = #19994#21153#21592#32534#21495
      DisplayWidth = 12
      FieldName = 'SAL_NO'
      Size = 12
    end
  end
end
上一页 12
💿 文件大小 3255 K
👤 上传用户 magicchange
📂 所属分类 Delphi/CppBuilder
🏷️ 相关标签

#销售
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -