📄 selectgoods.dfm
字号:
EditButtons = <>
FieldName = 'Price'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #38144#21806#20215
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
end>
end
object dbgGoods: TDBGridEh
Left = 0
Top = 0
Width = 448
Height = 244
Align = alClient
Ctl3D = False
DataSource = DataE2.dsTmp
Flat = True
Font.Charset = GB2312_CHARSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = #23435#20307
Font.Style = []
FooterColor = clWindow
FooterFont.Charset = DEFAULT_CHARSET
FooterFont.Color = clWindowText
FooterFont.Height = -11
FooterFont.Name = 'MS Sans Serif'
FooterFont.Style = []
Options = [dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
ParentCtl3D = False
ParentFont = False
ReadOnly = True
TabOrder = 1
TitleFont.Charset = GB2312_CHARSET
TitleFont.Color = clBlack
TitleFont.Height = -12
TitleFont.Name = #23435#20307
TitleFont.Style = []
VertScrollBar.VisibleMode = sbAlwaysShowEh
OnDblClick = dbgGoodsDblClick
OnKeyDown = dbgGoodsKeyDown
Columns = <
item
EditButtons = <>
FieldName = 'Code'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #32534#30721
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 84
end
item
EditButtons = <>
FieldName = 'Name'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #21517#31216
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 174
end
item
EditButtons = <>
FieldName = 'PerQty'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #35268#26684
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 35
end
item
EditButtons = <>
FieldName = 'Qty'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #21253#35013#25968
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 43
end
item
Alignment = taCenter
EditButtons = <>
FieldName = 'Units'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #21333#20301
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 31
end
item
EditButtons = <>
FieldName = 'Qty1'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #38646#25968
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 43
end
item
EditButtons = <>
FieldName = 'Unit2'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #21333#20301
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 31
end
item
EditButtons = <>
FieldName = 'SpePrice'
Footers = <>
Title.Alignment = taCenter
Title.Caption = #38144#21806#20215'1'
Title.Color = clWindow
Title.Font.Charset = GB2312_CHARSET
Title.Font.Color = clNavy
Title.Font.Height = -12
Title.Font.Name = #23435#20307
Title.Font.Style = []
Width = 56
end>
end
end
object qrySelGoods: TADOQuery
Connection = connectTmp
OnNewRecord = qrySelGoodsNewRecord
Parameters = <>
SQL.Strings = (
'select * from Goods')
Left = 256
Top = 352
end
object connectTmp: TADOConnection
LoginPrompt = False
Left = 208
Top = 352
end
object dsSelGoods: TDataSource
DataSet = qrySelGoods
Left = 296
Top = 352
end
object qryTmp: TADOQuery
Connection = connectTmp
Parameters = <
item
Name = 'nStoreid'
Size = -1
Value = Null
end
item
Name = 'STOREID'
Size = -1
Value = Null
end>
SQL.Strings = (
'select g.code,g.barcode,g.name,g.units,g.SpePrice,g.SalePrice,'
'g.SpePrice2,g.SalePrice2,isnull(h.qty,0) as qty,'
'isnull(h.storeid,:nStoreid) as storeid from goods g full outer j' +
'oinNHAND h on g.GOODSID=h.GOODSID'
'where STOREID = :STOREID')
Left = 256
Top = 392
end
object ILinfo: TImageList
Left = 176
Top = 72
Bitmap = {
494C010102000400040010001000FFFFFFFFFF10FFFFFFFFFFFFFFFF424D3600
0000000000003600000028000000400000001000000001002000000000000010
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000FFFF00FFFF
FF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF000000
00000000000000000000000000000000000000000000000000000000000000FF
FF00C0C0C00000FFFF00C0C0C00000FFFF00C0C0C00000FFFF00000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000FFFFFF0000FF
FF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF000000
000000000000000000000000000000000000000000000000000000FFFF000000
000000FFFF00C0C0C00000FFFF00C0C0C00000FFFF00C0C0C00000FFFF000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000FFFF00FFFF
FF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF000000
000000000000000000000000000000000000000000000000000000FFFF0000FF
FF000000000000FFFF00C0C0C00000FFFF00C0C0C00000FFFF00C0C0C00000FF
FF00000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000FFFFFF0000FF
FF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF000000
0000000000000000000000000000000000000000000000000000FFFFFF0000FF
FF0000FFFF000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000FFFF00FFFF
FF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF000000
000000000000000000000000000000000000000000000000000000FFFF00FFFF
FF0000FFFF000000000000FFFF000000000000FFFF000000000000FFFF000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000FFFFFF0000FF
FF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF000000
0000000000000000000000000000000000000000000000000000FFFFFF0000FF
FF00FFFFFF0000FFFF00FFFFFF0000FFFF00FFFFFF0000FFFF00000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000FFFF00FFFF
FF0000FFFF00FFFFFF0000FFFF00FFFFFF000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000000000000000000000000000FFFF
FF0000FFFF00FFFFFF0000FFFF00000000000000000000000000000000000000
00000000000000000000000000000000000000000000000000000000000000FF
FF00FFFFFF0000FFFF00FFFFFF00000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000808080000000
0000000000000000000000000000808080000000000000000000000000000000
0000000000000000000000000000000000000000000000000000808080000000
0000000000000000000000000000808080000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000000000000000000000000000000000000000000000000
000000000000000000000000000000000000424D3E000000000000003E000000
2800000040000000100000000100010000000000800000000000000000000000
000000000000000000000000FFFFFF00FFFFFFFF00000000FFFFFFFF00000000
FFFFFFFF00000000C00FC03F00000000800F801F00000000800F800F00000000
800F800700000000800F800700000000800F800F00000000800F800F00000000
801F801F00000000C0FFC0FF00000000C0FFC0FF00000000FFFFFFFF00000000
FFFFFFFF00000000FFFFFFFF0000000000000000000000000000000000000000
000000000000}
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -