📄 inv_purchasein_pw.dfm
字号:
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QRShApe4: TQRShApe
Left = -1
Top = -22
Width = 3
Height = 60
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
158.75
-2.64583333333333
-58.2083333333333
7.9375)
ShApe = qrsVertLine
end
object QRShApe5: TQRShApe
Left = 716
Top = -22
Width = 3
Height = 60
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
158.75
1894.41666666667
-58.2083333333333
7.9375)
ShApe = qrsVertLine
end
object QRLabel11: TQRLabel
Left = 175
Top = 1
Width = 28
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
463.020833333333
2.64583333333333
74.0833333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '税额:'
Color = clWhite
Font.ChArset = DEFAULT_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = 'Arial'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLtot: TQRLabel
Left = 629
Top = 1
Width = 88
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
1664.22916666667
2.64583333333333
232.833333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = False
AutoStretch = False
Caption = 'QLtot'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QRLabel12: TQRLabel
Left = 319
Top = 1
Width = 37
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
844.020833333333
2.64583333333333
97.8958333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = ' 总计:'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLBillColorDESC: TQRLabel
Left = 190
Top = 66
Width = 91
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
502.708333333333
174.625
240.770833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = 'QLBillColorDESC'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '楷体_GB2312'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLInvBillnotaxAmount: TQRLabel
Left = 59
Top = 1
Width = 110
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
156.104166666667
2.64583333333333
291.041666666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = False
AutoStretch = False
Caption = 'QLInvBillnotaxAmount'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLInvBillAmount: TQRLabel
Left = 203
Top = 1
Width = 110
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
537.104166666667
2.64583333333333
291.041666666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = False
AutoStretch = False
Caption = 'QLInvBillAmount'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLWH_EmployeeCode: TQRLabel
Left = 56
Top = 39
Width = 103
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
148.166666666667
103.1875
272.520833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = 'QLWH_EmployeeCode'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLEmployeeCode: TQRLabel
Left = 592
Top = 39
Width = 1
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
1566.33333333333
103.1875
2.64583333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = 'QLEmployeeCode'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QLInvBillRemArk: TQRLabel
Left = 53
Top = 22
Width = 661
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
140.229166666667
58.2083333333333
1748.89583333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = False
AutoStretch = False
Caption = 'QLInvBillRemArk'
Color = clWhite
Font.ChArset = ANSI_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
end
object TitleBand1: TQRBand
Left = 38
Top = 0
Width = 718
Height = 31
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = '宋体'
Font.Style = [fsBold]
ForceNewColumn = False
ForceNewPage = False
ParentFont = False
Size.Values = (
82.0208333333333
1899.70833333333)
BandType = rbTitle
object QLSysParamValueC: TQRLabel
Left = 160
Top = 9
Width = 177
Height = 20
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
52.9166666666667
423.333333333333
23.8125
468.3125)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = 'QLSysParamValueC'
Color = clWhite
Font.ChArset = GB2312_CHArSET
Font.Color = clWindowText
Font.Height = -19
Font.Name = '楷体_GB2312'
Font.Style = [fsBold]
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 14
end
object QLBillCtrlCode: TQRLabel
Left = 36
Top = 9
Width = 83
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
95.25
23.8125
219.604166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = 'QLBillCtrlCode'
Color = clWhite
Font.ChArset = DEFAULT_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = 'Arial'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
object QRLabel22: TQRLabel
Left = 7
Top = 9
Width = 28
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
42.3333333333333
18.5208333333333
23.8125
74.0833333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '表号:'
Color = clWhite
Font.ChArset = DEFAULT_CHArSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = 'Arial'
Font.Style = []
ParentFont = False
TransParent = False
WordWrAp = True
FontSize = 9
end
end
end
inherited AdoQry_Tmp: TAdoQuery
Left = 144
Top = 240
end
object AdoQry_Head: TAdoQuery
Connection = Frm_Main.AdoConnectMain
CurSorType = ctStatic
Parameters = <>
SQL.Strings = (
' select B.WHCode,W.WHName,B.WhPositionCode,P.WhPositionName,'
' B.InvBillTaxRate,B.InvBillNo,B.VendorCode,V.VendorNa' +
'me,'
' B.InvBillDate,B.InvBillId,'
' E.EmployeeName,F.EmployeeName as EmployeeName1,'
' B.Pono'
' from InvInBill B'
' left join Employee E on B.WH_EmployeeCode=E.EmployeeCo' +
'de'
' left join Employee F on B.EmployeeCode=f.EmployeeCode,'
' Warehouse W,WhPosition P,Vendor V'
' where B.WHCode=W.WHCode and'
' B.WhPositionCode=P.WhPositionCode and'
' B.VendorCode=V.VendorCode '
' ')
Left = 102
Top = 237
end
object AdoQry_Line: TAdoQuery
ConnectionString =
'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
'User ID=mdrcmrm;Data Source=NT2'
CurSorType = ctStatic
Parameters = <>
SQL.Strings = (
' select top 5 L.InvBillLineno,L.ItemCode,I.ItemName,L.POLine' +
'No,U.UomName,'
' L.InvBillQty,L.InvBillNoTaxPrice,L.InvBillNoTaxAmou' +
'nt,'
' L.InvBillAmount,L.InvBillAmount-InvBillNoTaxAmount ' +
'as InvBillTot'
' from InvInBillLine L,Item I,Uom U'
' where L.ItemCode=I.ItemCode and'
' I.UomCode=U.UomCode '
' '
' ')
Left = 52
Top = 238
end
object DataSource1: TDataSource
DataSet = AdoQry_Head
Left = 14
Top = 86
end
object DataSource2: TDataSource
DataSet = AdoQry_Line
Left = 302
Top = 329
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -