📄 findsellproductfrm.dfm
字号:
object FindSellProductForm: TFindSellProductForm
Left = 65
Top = 78
Width = 693
Height = 449
Caption = '产品销售统计'
Color = clBtnFace
Font.Charset = GB2312_CHARSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
FormStyle = fsMDIChild
OldCreateOrder = False
Position = poDefault
Visible = True
WindowState = wsMaximized
OnActivate = FormActivate
OnClose = FormClose
OnCreate = FormCreate
OnDestroy = FormDestroy
PixelsPerInch = 96
TextHeight = 12
object Panel3: TPanel
Left = 0
Top = 47
Width = 685
Height = 375
Align = alClient
BorderWidth = 5
Caption = 'Panel3'
TabOrder = 0
object DBGridEh1: TDBGridEh
Left = 6
Top = 6
Width = 673
Height = 363
Align = alClient
DataSource = DataSource1
Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
TabOrder = 0
TitleFont.Charset = GB2312_CHARSET
TitleFont.Color = clWindowText
TitleFont.Height = -12
TitleFont.Name = '宋体'
TitleFont.Style = []
FooterRowCount = 1
FooterFont.Charset = GB2312_CHARSET
FooterFont.Color = clWindowText
FooterFont.Height = -12
FooterFont.Name = '宋体'
FooterFont.Style = []
FooterColor = clBackground
SumList.Active = True
OptionsEh = [dghFixed3D, dghHighlightFocus, dghClearSelection, dghAutoSortMarking, dghMultiSortMarking]
OnTitleBtnClick = DBGridEh1TitleBtnClick
OnSortMarkingChanged = DBGridEh1SortMarkingChanged
Columns = <
item
Alignment = taCenter
FieldName = '日报编码'
Title.Alignment = taCenter
Title.TitleButton = True
Title.SortMarker = smUpEh
Title.SortIndex = 1
Width = 98
Footer.Font.Charset = DEFAULT_CHARSET
Footer.Font.Color = clWindow
Footer.Font.Height = -11
Footer.Font.Name = 'MS Sans Serif'
Footer.Font.Style = []
Footer.ValueType = fvtStaticText
Footer.Value = '合计：'
Footers = <>
end
item
Alignment = taCenter
FieldName = '分销店名称'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 104
Footers = <>
end
item
Alignment = taCenter
FieldName = '上报时间'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 90
Footers = <>
end
item
Alignment = taCenter
FieldName = '产品编码'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 110
Footers = <>
end
item
Alignment = taCenter
FieldName = '样式'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 60
Footers = <>
end
item
Alignment = taCenter
FieldName = '鞋别'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 57
Footers = <>
end
item
Alignment = taCenter
FieldName = '数量'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 73
Footer.Font.Charset = DEFAULT_CHARSET
Footer.Font.Color = clWindow
Footer.Font.Height = -11
Footer.Font.Name = 'MS Sans Serif'
Footer.Font.Style = []
Footer.ValueType = fvtSum
Footer.FieldName = '数量'
Footers = <>
end
item
Alignment = taCenter
FieldName = '金额'
Title.Alignment = taCenter
Title.TitleButton = True
Width = 76
Footer.Font.Charset = DEFAULT_CHARSET
Footer.Font.Color = clWindow
Footer.Font.Height = -11
Footer.Font.Name = 'MS Sans Serif'
Footer.Font.Style = []
Footer.ValueType = fvtSum
Footer.FieldName = '金额'
Footers = <>
end>
end
end
object Panel1: TPanel
Left = 0
Top = 0
Width = 685
Height = 47
Align = alTop
TabOrder = 1
object Label1: TLabel
Left = 24
Top = 19
Width = 48
Height = 12
Caption = '开始时间'
end
object Label2: TLabel
Left = 216
Top = 19
Width = 48
Height = 12
Caption = '结束时间'
end
object Label3: TLabel
Left = 408
Top = 19
Width = 48
Height = 12
Caption = '产品编码'
end
object DTPBegin: TDateTimePicker
Left = 78
Top = 16
Width = 90
Height = 20
CalAlignment = dtaLeft
Date = 37253.4432231366
Time = 37253.4432231366
DateFormat = dfShort
DateMode = dmComboBox
Kind = dtkDate
ParseInput = False
TabOrder = 0
OnCloseUp = DTPBeginCloseUp
OnChange = DTPBeginChange
end
object DTPEnd: TDateTimePicker
Left = 270
Top = 16
Width = 90
Height = 20
CalAlignment = dtaLeft
Date = 37253.4432859491
Time = 37253.4432859491
DateFormat = dfShort
DateMode = dmComboBox
Kind = dtkDate
ParseInput = False
TabOrder = 1
OnCloseUp = DTPEndCloseUp
OnChange = DTPEndChange
end
object ComboBox1: TComboBox
Left = 464
Top = 16
Width = 106
Height = 20
Style = csDropDownList
ItemHeight = 12
TabOrder = 2
end
object BitBtn1: TBitBtn
Left = 648
Top = 4
Width = 40
Height = 40
Caption = '查询'
TabOrder = 3
OnClick = BitBtn1Click
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000120B0000120B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
333333333333333333333333333333333333333333FFFFF3333333333CCCCC33
33333FFFF77777FFFFFFCCCCCC808CCCCCC377777737F777777F008888070888
8003773FFF7773FFF77F0F0770F7F0770F037F777737F777737F70FFFFF7FFFF
F07373F3FFF7F3FFF37F70F000F7F000F07337F77737F777373330FFFFF7FFFF
F03337FF3FF7F3FF37F3370F00F7F00F0733373F7737F77337F3370FFFF7FFFF
0733337F33373F337333330FFF030FFF03333373FF7373FF7333333000333000
3333333777333777333333333333333333333333333333333333333333333333
3333333333333333333333333333333333333333333333333333}
Layout = blGlyphTop
NumGlyphs = 2
end
object BitBtn2: TBitBtn
Left = 728
Top = 4
Width = 40
Height = 40
Caption = '退出'
TabOrder = 4
Glyph.Data = {
36030000424D3603000000000000360000002800000010000000100000000100
18000000000000030000120B0000120B00000000000000000000BFBFBFBFBFBF
BFBFBFBFBFBF000000000000BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF0000007F7F00000000BFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
0000007F7F007F7F00000000BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBF0000000000007F7F007F7F007F7F0000000000000000
0000000000000000000000000000000000BFBFBFBFBFBFBFBFBFBFBFBF000000
7F7F007F7F007F7F00000000FFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBF0000007F7F007F7F00000000000000FFFFFFFF
FFFF000000BFBFBFBFBFBFBFBFBFBFBFBF7F0000BFBFBFBFBFBFBFBFBF000000
7F7F007F7F007F7F00000000FFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBF7F00
007F0000BFBFBFBFBFBFBFBFBF0000007F7F007F7F007F7F00000000FFFFFFFF
FFFF000000BFBFBFBFBFBF7F00007F00007F00007F00007F0000BFBFBF000000
7F7F007F7F007F7F00000000FFFFFFFFFFFF000000BFBFBF7F00007F00007F00
007F00007F00007F0000BFBFBF0000007F7F007F7F007F7F00000000FFFFFFFF
FFFF000000BFBFBFBFBFBF7F00007F00007F00007F00007F0000BFBFBF000000
7F7F007F7F00000000FFFFFFFFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBF7F00
007F0000BFBFBFBFBFBFBFBFBF0000007F7F00000000FFFFFFFFFFFFFFFFFFFF
FFFF000000BFBFBFBFBFBFBFBFBFBFBFBF7F0000BFBFBFBFBFBFBFBFBF000000
000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBF00000000000000000000000000000000000000
0000000000BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF}
Layout = blGlyphTop
end
object BitBtn3: TBitBtn
Left = 688
Top = 4
Width = 40
Height = 40
Caption = '打印'
TabOrder = 5
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000130B0000130B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00300000000000
00033FFFFFFFFFFFFFFF0888888888888880777777777777777F088888888888
8880777777777777777F0000000000000000FFFFFFFFFFFFFFFF0F8F8F8F8F8F
8F80777777777777777F08F8F8F8F8F8F9F0777777777777777F0F8F8F8F8F8F
8F807777777777777F7F0000000000000000777777777777777F3330FFFFFFFF
03333337F3FFFF3F7F333330F0000F0F03333337F77773737F333330FFFFFFFF
03333337F3FF3FFF7F333330F00F000003333337F773777773333330FFFF0FF0
33333337F3FF7F3733333330F08F0F0333333337F7737F7333333330FFFF0033
33333337FFFF7733333333300000033333333337777773333333}
Layout = blGlyphTop
NumGlyphs = 2
end
end
object ADOQuery1: TADOQuery
Active = True
Connection = DM.ADOConnection
CursorType = ctStatic
Parameters = <>
SQL.Strings = (
'select xs_dailyMaster.dailyCode '#39'日报编码'#39', '
'xs_store.storeName '#39'分销店名称'#39', '
'xs_dailyMaster.DateTime '#39'上报时间'#39', '
'xs_dailyDetail.productCode '#39'产品编码'#39', '
'js_shoeskind1.s_name '#39'样式'#39', '
'js_shoeskind2.s_name '#39'鞋别'#39', '
'xs_dailyDetail.Total '#39'数量'#39', '
'xs_dailyDetail.Amount '#39'金额'#39' '
'from xs_dailyMaster inner join xs_dailyDetail '
'on Xs_dailyMaster.DailyCode = Xs_dailyDetail.DailyCode'
'Left outer join xs_store on '
'xs_dailyMaster.StoreCode = xs_store.StoreCode '
'inner join js_product1 on '
'js_product1.shoes_num = xs_dailyDetail.productCode '
'inner join js_shoeskind1 on '
'js_product1.shoes1_num = js_shoeskind1.s_number '
'inner join js_shoeskind2 on '
'js_product1.shoes2_num = js_shoeskind2.s_number ')
Left = 384
Top = 263
object ADOQuery1DSDesigner: TWideStringField
FieldName = '日报编码'
Size = 50
end
object ADOQuery1DSDesigner2: TWideStringField
FieldName = '分销店名称'
Size = 50
end
object ADOQuery1DSDesigner3: TDateTimeField
FieldName = '上报时间'
end
object ADOQuery1DSDesigner4: TWideStringField
FieldName = '产品编码'
Size = 50
end
object ADOQuery1DSDesigner5: TWideStringField
FieldName = '样式'
Size = 16
end
object ADOQuery1DSDesigner6: TWideStringField
FieldName = '鞋别'
Size = 16
end
object ADOQuery1DSDesigner7: TFloatField
FieldName = '数量'
DisplayFormat = '#0 双'
end
object ADOQuery1DSDesigner8: TFloatField
FieldName = '金额'
DisplayFormat = '￥ #0.00'
end
end
object DataSource1: TDataSource
DataSet = ADOQuery1
Left = 352
Top = 263
end
object ADOQuery2: TADOQuery
Connection = DM.ADOConnection
CursorType = ctStatic
Parameters = <>
SQL.Strings = (
'select xs_dailyMaster.dailyCode '#39'日报编码'#39','
' xs_store.storeName '#39'分销店名称'#39','
' xs_dailyMaster.DateTime '#39'上报时间'#39','
' xs_dailyDetail.productCode '#39'产品编码'#39','
' js_shoeskind1.s_name '#39'样式'#39','
' js_shoeskind2.s_name '#39'鞋别'#39','
' xs_dailyDetail.Total '#39'数量'#39','
' xs_dailyDetail.Amount '#39'金额'#39
' '
' '
'from xs_dailyMaster inner join xs_dailyDetail '
' on Xs_dailyMaster.DailyCode = Xs_dailyDetail.DailyCode '
' Left outer join xs_store on'
' xs_dailyMaster.StoreCode = xs_store.StoreCode'
' inner join js_product1 on'
' js_product1.shoes_num = xs_dailyDetail.productCode'
' inner join js_shoeskind1 on'
' js_product1.shoes1_num = js_shoeskind1.s_number'
' inner join js_shoeskind2 on'
' js_product1.shoes2_num = js_shoeskind2.s_number'
'')
Left = 584
Top = 7
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -