?? pm_qry_analyzeritemvendor.dfm
字號:
inherited Frm_Pm_Qry_AnalyzerItemVendor: TFrm_Pm_Qry_AnalyzerItemVendor
Left = 207
Top = 184
Caption = '物料-供應商價格對比分析'
PixelsPerInch = 96
TextHeight = 12
inherited ControlBar: TControlBar
inherited ToolBar: TToolBar
inherited TlBtn_Order: TToolButton
Visible = False
end
inherited TlBtn_SetColumn: TToolButton
Visible = False
end
end
end
inherited Pnl_Title: TPanel
Caption = '物料-供應商價格對比分析'
end
inherited Pnl_Head: TPanel
Height = 4
inherited Image1: TImage
Height = 4
end
inherited Lbl_Condition: TLabel
Width = 24
Caption = '全部'
end
inherited Lbl_Order: TLabel
Width = 114
Caption = '物料代碼/供應商代碼'
end
end
inherited Pnl_Hint: TPanel
Top = 390
Height = 39
inherited Image4: TImage
Height = 39
end
object Label2: TLabel
Left = 22
Top = 24
Width = 72
Height = 12
Caption = '供應商標識:'
end
object dbtxtVendorflag: TDBText
Left = 96
Top = 24
Width = 90
Height = 12
AutoSize = True
DataField = 'Vendorflag'
DataSource = DataSource
end
object dbtxtItemflag: TDBText
Left = 96
Top = 8
Width = 78
Height = 12
AutoSize = True
DataField = 'Itemflag'
DataSource = DataSource
end
object Label1: TLabel
Left = 34
Top = 8
Width = 60
Height = 12
Caption = '物料標識:'
end
end
inherited Pnl_Body: TPanel
Top = 61
Height = 329
inherited Image3: TImage
Height = 329
end
inherited DBGridEh: TDBGridEh
Height = 329
FrozenCols = 2
UseMultiTitle = True
Columns = <
Item
FieldName = 'Itemflag'
PickList.Strings = ()
Width = 200
KeyList.Strings = ()
end
Item
FieldName = 'ItemCode'
PickList.Strings = ()
Width = 99
Visible = False
KeyList.Strings = ()
end
Item
FieldName = 'ItemName'
PickList.Strings = ()
Width = 192
Visible = False
KeyList.Strings = ()
end
Item
FieldName = 'Vendorflag'
PickList.Strings = ()
Width = 200
KeyList.Strings = ()
end
Item
FieldName = 'VendorCode'
PickList.Strings = ()
Width = 70
Visible = False
KeyList.Strings = ()
end
Item
FieldName = 'VendorName'
PickList.Strings = ()
Width = 153
Visible = False
KeyList.Strings = ()
end
Item
FieldName = 'CountBillqty'
PickList.Strings = ()
Width = 65
KeyList.Strings = ()
end
Item
FieldName = 'CountBillAmount'
PickList.Strings = ()
Width = 67
KeyList.Strings = ()
end
Item
FieldName = 'avgBillPrice'
PickList.Strings = ()
Width = 55
KeyList.Strings = ()
end
Item
FieldName = 'Pricesec'
PickList.Strings = ()
Width = 65
KeyList.Strings = ()
end
Item
FieldName = 'secrate'
PickList.Strings = ()
Width = 42
KeyList.Strings = ()
end>
end
end
inherited ActionList: TActionList
Left = 248
Top = 176
end
inherited AdoQry_Main: TAdoQuery
ConnectionString =
'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=NT2'
CurSorType = ctStatic
SQL.Strings = (
'select ItemCode='#39'aaaaaaaaassd'#39','
' ItemName='#39'aaaaaaaasfdfds'#39','
' Itemflag='#39'aaaaaaaaassd'#39'+'#39' '#39'+'#39'aaaaaaaaassd'#39','
' VendorCode='#39'aaaaaaaaaafddfs'#39','
' VendorName='#39'aaaaaaaaaaaaasdf'#39','
' Vendorflag='#39'aaaaaaaaassd'#39'+'#39' '#39'+'#39'aaaaaaaaassd'#39','
' CountBillqty=569999.565,'
' CountBillAmount=439999.45,'
' avgBillPrice=59999.44,'
' Pricesec=99999.433,'
' secrate='#39'dffd'#39','
' flag=0 '
'from Item')
Left = 296
Top = 153
object AdoQry_MainItemCode: TStringField
DisplayLabel = '物料代碼'
FieldName = 'ItemCode'
Origin = '#tmpres'
ReadOnly = True
Size = 16
end
object AdoQry_MainItemName: TStringField
DisplayLabel = '物料描述'
FieldName = 'ItemName'
Origin = '#tmpres'
ReadOnly = True
Size = 200
end
object AdoQry_MaInvendorCode: TStringField
DisplayLabel = '供應商代碼'
FieldName = 'VendorCode'
Origin = '#tmpres'
ReadOnly = True
Size = 10
end
object AdoQry_MaInvendorName: TStringField
DisplayLabel = '供應商名稱'
FieldName = 'VendorName'
Origin = '#tmpres'
ReadOnly = True
Size = 30
end
object AdoQry_MainCountBillqty: TBCDField
DisplayLabel = '采購入庫量'
FieldName = 'CountBillqty'
Origin = '#tmpres'
ReadOnly = True
Precision = 5
Size = 15
end
object AdoQry_MainCountBillAmount: TBCDField
DisplayLabel = '采購入庫額'
FieldName = 'CountBillAmount'
Origin = '#tmpres'
ReadOnly = True
Precision = 4
Size = 15
end
object AdoQry_MainavgBillPrice: TBCDField
DisplayLabel = '采購均價'
FieldName = 'avgBillPrice'
Origin = '#tmpres'
ReadOnly = True
Precision = 3
Size = 15
end
object AdoQry_MainPricesec: TBCDField
DisplayLabel = '價格差異'
FieldName = 'Pricesec'
Origin = '#tmpres'
ReadOnly = True
Precision = 4
Size = 15
end
object AdoQry_Mainsecrate: TStringField
DisplayLabel = '差異率'
FieldName = 'secrate'
Origin = '#tmpres'
ReadOnly = True
Size = 15
end
object AdoQry_MainItemflag: TStringField
DisplayLabel = '物料標識'
FieldName = 'Itemflag'
ReadOnly = True
Size = 60
end
object AdoQry_MaInvendorflag: TStringField
DisplayLabel = '供應商標識'
FieldName = 'Vendorflag'
ReadOnly = True
Size = 70
end
object AdoQry_Mainflag: TIntegerField
FieldName = 'flag'
end
end
inherited DataSource: TDataSource
Left = 336
Top = 145
end
inherited PopuPmenu: TPopuPmenu
Left = 296
Top = 209
end
end
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -