sclld.dfm

产品标签管理系统：delphi+sql实现了产品标签、包装箱麦的自动生成等功能

object lld: Tlld
  Left = -31
  Top = 81
  Width = 805
  Height = 437
  Caption = #38936#26009#21934
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poDesktopCenter
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object Label3: TLabel
    Left = 648
    Top = 168
    Width = 32
    Height = 13
    Caption = 'Label3'
  end
  object GroupBox1: TGroupBox
    Left = 0
    Top = 0
    Width = 797
    Height = 49
    Align = alTop
    Caption = #38936#26009#21934#34920#38957
    TabOrder = 0
    object Label11: TLabel
      Left = 236
      Top = 21
      Width = 50
      Height = 13
      Caption = #38936#26009#20154
      Constraints.MaxWidth = 50
      Constraints.MinWidth = 50
    end
    object Label12: TLabel
      Left = 1
      Top = 21
      Width = 50
      Height = 13
      Caption = #26085#26399
      Constraints.MaxWidth = 50
      Constraints.MinWidth = 50
    end
    object Label14: TLabel
      Left = 352
      Top = 21
      Width = 60
      Height = 13
      Caption = #30332#26009#20154
      Constraints.MaxWidth = 60
      Constraints.MinWidth = 60
    end
    object Label2: TLabel
      Left = 106
      Top = 21
      Width = 60
      Height = 13
      Caption = #30332#26009#37096#38272
      Constraints.MaxWidth = 60
      Constraints.MinWidth = 60
    end
    object SpeedButton2: TSpeedButton
      Left = 767
      Top = 16
      Width = 25
      Height = 21
      Hint = #20154#21729#35373#23450
      Glyph.Data = {
        F6000000424DF600000000000000760000002800000010000000100000000100
        04000000000080000000C40E0000C40E00001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00AC000090DC00
        0000EE0000FBBF0000EEEEE00FADBAF00EEEEEEEAE9BABAEEEEEEEEEABB9B9BA
        EEEEEEEEEFBFCBBDEEEEEEEEBFBBBBBDAEEEAEEE9BEBBEABAEEEEEEAFB0AB00B
        EEEAEEEE9BFBFBB90EEAEEEE0EFF99C0AEEEEEEEE09B9099EEEAEEEEECB0090E
        EEEEAEEEEEEC0AEEEEEEEEEEEEEEEEEEEEEAEEEEAEEEEEAEAEAE}
      ParentShowHint = False
      ShowHint = True
      OnClick = SpeedButton2Click
    end
    object Label1: TLabel
      Left = 467
      Top = 20
      Width = 48
      Height = 13
      Caption = #38936#26009#37096#38272
    end
    object Label4: TLabel
      Left = 536
      Top = 8
      Width = 32
      Height = 13
      Caption = 'Label4'
    end
    object Label5: TLabel
      Left = 595
      Top = 21
      Width = 48
      Height = 13
      Caption = #38936#26009#32232#34399
    end
    object Label6: TLabel
      Left = 368
      Top = 8
      Width = 32
      Height = 13
      Caption = 'Label6'
    end
    object me1: TMaskEdit
      Left = 25
      Top = 16
      Width = 80
      Height = 21
      TabOrder = 0
      OnKeyDown = me1KeyDown
    end
    object cb2: TComboBox
      Left = 155
      Top = 16
      Width = 80
      Height = 21
      ItemHeight = 13
      TabOrder = 1
      Text = #29289#20489
      OnKeyDown = cb2KeyDown
      Items.Strings = (
        #29289#20489
        #25104#20489)
    end
    object BitBtn1: TBitBtn
      Left = 726
      Top = 15
      Width = 40
      Height = 25
      TabOrder = 2
      OnClick = BitBtn1Click
      Glyph.Data = {
        66010000424D6601000000000000760000002800000014000000140000000100
        040000000000F000000000000000000000001000000000000000000000000000
        8000008000000080800080000000800080008080000080808000C0C0C0000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00FFFFFFFFFFFF
        FFFFFFFF0202FFFFFFFFFFFFFFFFFFFF0400FFFFFFFFFFFFFFFFFFFF0282FFFF
        00000000000FFFFF1110FFF0777777777070FFFF0022FF000000000000070FFF
        02A9FF07777777FFF77070FF0000FF0777777700077000FF4415FF0777777777
        777070FF0046FF00000000000000770F8008FFF0777777777708070F88AAFFFF
        000000000070800F108DFFFFF0FFFFFFF077080F0001FFFFFF0F0000FF0000FF
        0055FFFFFF0FFFFFFF0FFFFF200AFFFFFFF0F0000FF0FFFF0000FFFFFFF0FFFF
        FFF0FFFF0000FFFFFFFF00000000FFFF0440FFFFFFFFFFFFFFFFFFFF2020FFFF
        FFFFFFFFFFFFFFFF2001}
    end
    object e2: TComboBox
      Left = 272
      Top = 16
      Width = 80
      Height = 21
      ItemHeight = 13
      TabOrder = 3
      OnKeyDown = e2KeyDown
    end
    object e4: TComboBox
      Left = 388
      Top = 16
      Width = 80
      Height = 21
      ItemHeight = 13
      TabOrder = 4
      OnKeyDown = e4KeyDown
    end
    object ComboBox1: TComboBox
      Left = 515
      Top = 16
      Width = 80
      Height = 21
      ItemHeight = 13
      TabOrder = 5
      Text = 'ComboBox1'
      OnKeyDown = ComboBox1KeyDown
    end
    object Edit1: TEdit
      Left = 643
      Top = 16
      Width = 80
      Height = 21
      TabOrder = 6
      Text = 'Edit1'
      OnKeyDown = Edit1KeyDown
    end
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 49
    Width = 797
    Height = 361
    Align = alClient
    DataSource = DataSource1
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit, dgMultiSelect]
    ReadOnly = True
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    OnCellClick = DBGrid1CellClick
    Columns = <
      item
        Expanded = False
        FieldName = 'Zdh'
        Title.Alignment = taCenter
        Title.Caption = #35069#20316#21934#34399
        Width = 60
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Epartno'
        Title.Alignment = taCenter
        Title.Caption = #29289#26009#32232#34399
        Width = 80
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Epartname'
        Title.Alignment = taCenter
        Title.Caption = #29289#26009#21517#31281
        Width = 80
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Egg'
        Title.Alignment = taCenter
        Title.Caption = #35215#26684
        Width = 100
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Edw'
        Title.Alignment = taCenter
        Title.Caption = #21934#20301
        Width = 40
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'Estdqty'
        Title.Alignment = taCenter
        Title.Caption = #35531#38936#25976#37327
        Width = 60
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'bu_men'
        Title.Alignment = taCenter
        Title.Caption = #38936#26009#37096#38272
        Width = 80
        Visible = True
      end>
  end
  object Query1: TQuery
    CachedUpdates = True
    DatabaseName = 'oy'
    SQL.Strings = (
      'insert into sclld select Zdh,'
      
        #39'L'#39'+convert(char(6),getdate(),12)+substring(convert(char(6),getd' +
        'ate(),8),1,2)+substring(convert(char(6),getdate(),8),4,2)+conver' +
        't(char(3),gxh,0),'
      
        'Gxh,Gxm,:rq,:flbm,:llr,:ckjb,Epartno,Epartname,Edw,Egg,Estdqty,'#39 +
        #39' from EM where Zdh=:zdh and  len(Epartno)>3'
      
        'update EM set Efctqty=0 where Zdh=:zdh and len(Epartno)>3 and Ef' +
        'ctqty is null'
      
        'update EM set Efctqty=Efctqty+Estdqty where Zdh=:zdh and len(Epa' +
        'rtno)>3')
    Left = 116
    Top = 104
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'rq'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'flbm'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'llr'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'ckjb'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'zdh'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'zdh'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'zdh'
        ParamType = ptUnknown
      end>
  end
  object DataSource1: TDataSource
    DataSet = Query3
    Left = 216
    Top = 104
  end
  object Query2: TQuery
    DatabaseName = 'oy'
    Left = 316
    Top = 128
  end
  object Query3: TQuery
    Active = True
    DatabaseName = 'oy'
    SQL.Strings = (
      'select * from EM')
    Left = 200
    Top = 176
  end
  object Table1: TTable
    Active = True
    DatabaseName = 'oy'
    TableName = 'dbo.EM'
    Left = 296
    Top = 192
  end
end