skycwbb1.dfm
来自「日昌餐饮管理系统是用Delphi7+SQL写的管理系统」· DFM 代码 · 共 1,020 行 · 第 1/3 页
DFM
1,020 行
object skyForm1: TskyForm1
Left = 75
Top = 93
Width = 617
Height = 335
BorderIcons = [biSystemMenu]
Caption = #25910#27454#21592#36130#21153#25253#34920'('#31364#34892')'
Color = clBtnFace
Font.Charset = GB2312_CHARSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = #23435#20307
Font.Style = []
OldCreateOrder = False
Position = poDesktopCenter
Scaled = False
OnActivate = FormActivate
OnClose = FormClose
PixelsPerInch = 96
TextHeight = 12
object Label2: TLabel
Left = 3
Top = 15
Width = 36
Height = 12
Caption = #26085#26399#65306
end
object Label7: TLabel
Left = 136
Top = 155
Width = 48
Height = 12
Caption = #38144#21806#26126#32454
Font.Charset = GB2312_CHARSET
Font.Color = clBlue
Font.Height = -12
Font.Name = #23435#20307
Font.Style = []
ParentFont = False
end
object Label1: TLabel
Left = 160
Top = 4
Width = 36
Height = 12
Caption = #25910#38134#21592
end
object DateTimePicker1: TDateTimePicker
Left = 35
Top = 2
Width = 84
Height = 20
CalAlignment = dtaLeft
Date = 37574.3727972222
Time = 37574.3727972222
DateFormat = dfShort
DateMode = dmComboBox
Kind = dtkDate
ParseInput = False
TabOrder = 0
end
object DateTimePicker2: TDateTimePicker
Left = 35
Top = 21
Width = 84
Height = 20
CalAlignment = dtaLeft
Date = 37574.3727972222
Time = 37574.3727972222
DateFormat = dfShort
DateMode = dmComboBox
Kind = dtkDate
ParseInput = False
TabOrder = 1
end
object BitBtn1: TBitBtn
Left = 266
Top = 7
Width = 75
Height = 25
Caption = #29983#25104
TabOrder = 2
OnClick = BitBtn1Click
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000130B0000130B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333303
333333333333337FF3333333333333903333333333333377FF33333333333399
03333FFFFFFFFF777FF3000000999999903377777777777777FF0FFFF0999999
99037F3337777777777F0FFFF099999999907F3FF777777777770F00F0999999
99037F773777777777730FFFF099999990337F3FF777777777330F00FFFFF099
03337F773333377773330FFFFFFFF09033337F3FF3FFF77733330F00F0000003
33337F773777777333330FFFF0FF033333337F3FF7F3733333330F08F0F03333
33337F7737F7333333330FFFF003333333337FFFF77333333333000000333333
3333777777333333333333333333333333333333333333333333}
NumGlyphs = 2
end
object BitBtn2: TBitBtn
Left = 348
Top = 7
Width = 75
Height = 25
Caption = #25171#21360
TabOrder = 3
OnClick = BitBtn2Click
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000120B0000120B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00300000000000
0003377777777777777308888888888888807F33333333333337088888888888
88807FFFFFFFFFFFFFF7000000000000000077777777777777770F8F8F8F8F8F
8F807F333333333333F708F8F8F8F8F8F9F07F333333333337370F8F8F8F8F8F
8F807FFFFFFFFFFFFFF7000000000000000077777777777777773330FFFFFFFF
03333337F3FFFF3F7F333330F0000F0F03333337F77773737F333330FFFFFFFF
03333337F3FF3FFF7F333330F00F000003333337F773777773333330FFFF0FF0
33333337F3F37F3733333330F08F0F0333333337F7337F7333333330FFFF0033
33333337FFFF7733333333300000033333333337777773333333}
NumGlyphs = 2
end
object BitBtn3: TBitBtn
Left = 514
Top = 7
Width = 75
Height = 25
Caption = #36864#20986
TabOrder = 4
OnClick = BitBtn3Click
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000C40E0000C40E00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00330000000000
03333377777777777F333301BBBBBBBB033333773F3333337F3333011BBBBBBB
0333337F73F333337F33330111BBBBBB0333337F373F33337F333301110BBBBB
0333337F337F33337F333301110BBBBB0333337F337F33337F333301110BBBBB
0333337F337F33337F333301110BBBBB0333337F337F33337F333301110BBBBB
0333337F337F33337F333301110BBBBB0333337F337FF3337F33330111B0BBBB
0333337F337733337F333301110BBBBB0333337F337F33337F333301110BBBBB
0333337F3F7F33337F333301E10BBBBB0333337F7F7F33337F333301EE0BBBBB
0333337F777FFFFF7F3333000000000003333377777777777333}
NumGlyphs = 2
end
object DBGrid3: TDBGrid
Left = 0
Top = 43
Width = 609
Height = 265
DataSource = DataSource1
ReadOnly = True
TabOrder = 5
TitleFont.Charset = GB2312_CHARSET
TitleFont.Color = clWindowText
TitleFont.Height = -12
TitleFont.Name = #23435#20307
TitleFont.Style = []
end
object BitBtn4: TBitBtn
Left = 431
Top = 7
Width = 75
Height = 25
Caption = 'Excel'
TabOrder = 6
OnClick = BitBtn4Click
Glyph.Data = {
360C0000424D360C000000000000360000002800000020000000200000000100
180000000000000C000000000000000000000000000000000000FFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF80000080000080000080000080
0000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF80000080000080000080000080000080
0000800000800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF800000800000800000FFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000000
0000000000000000000000000000000000000000000000000000000000000000
0000000000000000000080808080000080000080000080808000000000000000
0000000000000000808080FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
8080808080808080808080808080808080808080808080808080808080808080
8080808080808080808080808080000080000080000080808080808080808080
8080808080808080800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0800000800000800000800000800000800000800000800000800000FF
FFFFFFFFFF800000800000800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFF800000800000800000800000800000800000800000FFFFFFFF
FFFF800000800000800000800000800000FFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFF800000800000800000800000800000C0C0C0FFFFFF80
0000800000800000800000800000800000800000FFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0C0C0C0C0C0C0C0C0C0800000800000800000C0C0C0C0C0C080000080
0000800000800000800000800000800000800000800000FFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0800000FFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFF800000800000800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFF800000800000800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFF800000800000800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C080000080000080000080000080
0000800000800000800000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFF80000080000080
0000800000800000808080FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000080000080000080C0C0C0C0C0C0C0
C0C0C0C0C0C0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFF000080C0C0C0FFFFFFC0C0C0000080FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFF000080FFFFFFFFFFFFFFFFFF000080FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFF
FFC0C0C0FFFFFFFFFFFFFFFFFF000080C0C0C0FFFFFFC0C0C0000080FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0000080000080000080C0C0C0C0C0C0C0
C0C0C0C0C0C0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0C0
C0C0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFFFFFFFFFFFFC0C0C0FFFFFFFF
FFFFFFFFFFC0C0C0000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
8080808080808080808080808080808080808080808080808080808080808080
8080808080808080808080808080808080808080808080808080808080808080
8080808080808080000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
8000008000008000008000008000008000008000008000008000008000008000
0080000080808080808080808080808080808080808080808080808080808080
8080808080808080000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
8000008000008000008000008000008000008000008000008000008000008000
0080000080808080808080808080808080808080808080808080808080808080
8080808080808080000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF808080
8080808080808080808080808080808080808080808080808080808080808080
8080808080808080808080808080808080808080808080808080808080808080
8080808080808080000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF}
end
object ComboBox1: TComboBox
Left = 132
Top = 16
Width = 92
Height = 20
ItemHeight = 12
TabOrder = 7
Text = 'ComboBox1'
end
object DataSource1: TDataSource
DataSet = ADODataSet1
Left = 336
Top = 53
end
object ADODataSet1: TADODataSet
Connection = mainForm.RJSADO
CursorType = ctStatic
OnFilterRecord = ADODataSet1FilterRecord
CommandText =
'select a.yhm as '#21495#30721','#13#10'"'#25910#38134#21592'" =(select yhmc from userwj where a' +
'.yhm=yhm),'#13#10'"'#27880#20876#38144#21806'" = (select sum(je) from dcd where a.yhm=yhh an' +
'd rq>=:cs5 and rq <=:cs6 and fkbz=1),'#13#10'"'#20248#24800#25968#37327'" = (select count(dj' +
'h) from dcd where je<>dj and yhh=a.yhm and zfbz=0 and fkbz=1 and' +
' rq>=:cs7 and rq <=:cs8),'#13#10'"'#20248#24800#37329#39069'" = (select sum(dj - je ) from d' +
'cd where je<>dj and yhh=a.yhm and zfbz=0 and fkbz=1 and rq>=:cs9' +
' and rq <=:cs10),'#13#10'"'#31614#21333#25968#37327'" = 0,'#13#10'"'#31614#21333#37329#39069'" = 0,'#13#10'"'#24223#21333#25968#37327'" = (select co' +
'unt(distinct djh) from dcd where yhh=a.yhm and zfbz=1 and fkbz=' +
'0 and rq>=:cs11 and rq <=:cs12),'#13#10'"'#24223#21333#37329#39069'" = (select sum( je ) fro' +
'm dcd where yhh=a.yhm and zfbz=1 and fkbz=0 and rq>=:cs13 and r' +
'q <=:cs14),'#13#10'"'#36864#21333#25968#37327'" = (select count(distinct djh) from dcd where' +
' yhh=a.yhm and zfbz=1 and fkbz=1 and rq>=:cs15 and rq <=:cs16),' +
#13#10'"'#36864#21333#37329#39069'" = (select sum( je ) from dcd where yhh=a.yhm and zfbz=' +
'1 and fkbz=1 and rq>=:cs17 and rq <=:cs18),'#13#10'"'#20854#20182'" = (sele' +
'ct sum(mlje) from new_djh,dcd where new_djh.djh=dcd.djh and a.y' +
'hm=dcd.yhh and dcd.rq>=:cs19 and dcd.rq <=:cs20),'#13#10'"'#23454#25910#37329#39069'" =(sele' +
'ct sum( fkje) from fkwj where yhh=a.yhm and rq>=:cs21 and rq <=' +
':cs22),'#13#10'"'#22530#39135#25968#37327'" = (select count(djh) from dcd where yhh=a.yhm a' +
'nd zfbz=0 and fkbz=1 and wmbz=0 and rq>=:cs23 and rq <=:cs24),'#13 +
#10'"'#22530#39135#37329#39069'" = (select sum( je ) from dcd where yhh=a.yhm and zfbz=0' +
' and fkbz=1 and wmbz=0 and rq>=:cs25 and rq <=:cs26),'#13#10'"'#22806#21334#25968#37327'" =' +
' (select count(djh) from dcd where yhh=a.yhm and zfbz=0 and fkb' +
'z=1 and wmbz=1 and rq>=:cs27 and rq <=:cs28),'#13#10'"'#22806#21334#37329#39069'" = (select' +
' sum( je ) from dcd where yhh=a.yhm and zfbz=0 and fkbz=1 and w' +
'mbz=1 and rq>=:cs29 and rq <=:cs30),'#13#10'"'#21333#22343#20132#26131#39069'" = (select sum( je' +
' ) / count(distinct djh ) from dcd where yhh=a.yhm and zfbz=0 ' +
'and fkbz=1 and rq>=:cs31 and rq <=:cs32),'#13#10'"'#20154#22343#20132#26131#39069'" = (select su' +
'm( dcd.je ) / sum(distinct new_djh.xfrs ) from dcd, new_djh wh' +
'ere new_djh.djh=dcd..djh and dcd.yhh=a.yhm and dcd.zfbz=0 and d' +
'cd.fkbz=1 and dcd.rq>=:cs33 and dcd.rq <=:cs34)'#13#10#13#10'from userwj ' +
'a'#13#10'group by a.yhm'#13#10'having (select sum(je) from dcd where a.yhm=' +
'yhh and rq>=:cs1 and rq <=:cs2 and fkbz=1) >0'#13#10
Parameters = <
item
Name = 'cs5'
Size = -1
Value = Null
end
item
Name = 'cs6'
Size = -1
Value = Null
end
item
Name = 'cs7'
Size = -1
Value = Null
end
item
Name = 'cs8'
Size = -1
Value = Null
end
item
Name = 'cs9'
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?