C# 클래스 Smrf.NodeXL.ExcelTemplate.DynamicFilterDialog

파일 보기 프로젝트 열기: 2014-sed-team3/term-project 1 사용 예제들

보호된 프로퍼티들

프로퍼티 타입 설명
m_bHandleControlEvents Boolean
m_oChangeEventDelayTimer Timer
m_oDynamicFilterDialogUserSettings DynamicFilterDialogUserSettings
m_oDynamicFilterSettings DynamicFilterSettings
m_oEdgeDynamicFilterColumnData Microsoft.Office.Interop.Excel.Range
m_oExcelCalculationRestorer ExcelCalculationRestorer
m_oVertexDynamicFilterColumnData Microsoft.Office.Interop.Excel.Range
m_oWorkbook Microsoft.Office.Interop.Excel.Workbook

공개 메소드들

메소드 설명
AssertValid ( ) : void
DynamicFilterDialog ( ) : System

Initializes a new instance of the class for the Visual Studio designer.

Do not use this constructor. It is for use by the Visual Studio designer only.

DynamicFilterDialog ( Microsoft workbook ) : System

Initializes a new instance of the class with a workbook.

GetDynamicFilterRangeTrackBars ( ICollection &edgeDynamicFilterRangeTrackBars, ICollection &vertexDynamicFilterRangeTrackBars ) : void

보호된 메소드들

메소드 설명
AddDynamicFilterFormulaToTable ( String sWorksheetName, String sTableName, String sDynamicFilterFormula ) : Microsoft.Office.Interop.Excel.Range
AddDynamicFilterTableColumn ( Microsoft oTable ) : Microsoft.Office.Interop.Excel.Range
AddHistogramImageToPictureBox ( String sWorksheetName, DynamicFilterParameters oDynamicFilterParameters, PictureBoxPlus oPictureBox ) : void
AddHistogramToGroupBox ( String sWorksheetName, DynamicFilterParameters oDynamicFilterParameters, GroupBox oGroupBox, Int32 iX, Int32 &iY ) : PictureBox
AddLabelToGroupBox ( DynamicFilterParameters oDynamicFilterParameters, GroupBox oGroupBox, Int32 iX, Int32 iY ) : Label
AddRangeTrackBarToGroupBox ( NumericFilterParameters oNumericFilterParameters, String sTableName, GroupBox oGroupBox, StringBuilder oDynamicFilterConditions, Int32 iX, Int32 &iY ) : IDynamicFilterRangeTrackBar
AppendConditions ( StringBuilder oDynamicFilterConditions, String sColumnName, String sSelectedMinimumAddress, String sSelectedMaximumAddress ) : void
Dispose ( bool disposing ) : void

Clean up any resources being used.

EscapeColumnName ( String sColumnName ) : String
FireDynamicFilterColumnsChanged ( DynamicFilterColumns eDynamicFilterColumns ) : void
FireFilteredAlphaChanged ( ) : void
GetRangeTrackBarRanges ( NumericFilterParameters oNumericFilterParameters, String sTableName, Decimal &decAvailableMinimum, Decimal &decAvailableMaximum, Decimal &decSelectedMinimum, Decimal &decSelectedMaximum, String &sSelectedMinimumAddress, String &sSelectedMaximumAddress ) : void
InitializeAndRecalculateDynamicFilterColumns ( ) : void
InitializeDynamicFilters ( ) : void
InitializeDynamicFiltersForOneTable ( String sWorksheetName, String sTableName, GroupBox oGroupBox ) : Microsoft.Office.Interop.Excel.Range
OnClosed ( EventArgs e ) : void
OnLoad ( EventArgs e ) : void
OnSelectedRangeChanged ( IDynamicFilterRangeTrackBar oDynamicFilterRangeTrackBar ) : void
RangeTrackBar_SelectedRangeChanged ( object sender, EventArgs e ) : void
RecalculateDynamicFilterColumns ( DynamicFilterColumns eDynamicFilterColumns ) : void
ResetAllDynamicFilters ( ) : void
SetManualCalculation ( ) : void
StartChangeEventDelayTimer ( Object oChangedControl ) : void
m_oChangeEventDelayTimer_Tick ( object sender, EventArgs e ) : void

비공개 메소드들

메소드 설명
InitializeComponent ( ) : void

Required method for Designer support - do not modify the contents of this method with the code editor.

btnClose_Click ( object sender, EventArgs e ) : void
btnReadWorkbook_Click ( object sender, EventArgs e ) : void
btnResetAllDynamicFilters_Click ( object sender, EventArgs e ) : void
chkDoNotFilterNonNumericCells_CheckedChanged ( object sender, EventArgs e ) : void
nudFilteredAlpha_ValueChanged ( object sender, EventArgs e ) : void

메소드 상세

AddDynamicFilterFormulaToTable() 보호된 메소드

protected AddDynamicFilterFormulaToTable ( String sWorksheetName, String sTableName, String sDynamicFilterFormula ) : Microsoft.Office.Interop.Excel.Range
sWorksheetName String
sTableName String
sDynamicFilterFormula String
리턴 Microsoft.Office.Interop.Excel.Range

AddDynamicFilterTableColumn() 보호된 메소드

protected AddDynamicFilterTableColumn ( Microsoft oTable ) : Microsoft.Office.Interop.Excel.Range
oTable Microsoft
리턴 Microsoft.Office.Interop.Excel.Range

AddHistogramImageToPictureBox() 보호된 메소드

protected AddHistogramImageToPictureBox ( String sWorksheetName, DynamicFilterParameters oDynamicFilterParameters, PictureBoxPlus oPictureBox ) : void
sWorksheetName String
oDynamicFilterParameters DynamicFilterParameters
oPictureBox PictureBoxPlus
리턴 void

AddHistogramToGroupBox() 보호된 메소드

protected AddHistogramToGroupBox ( String sWorksheetName, DynamicFilterParameters oDynamicFilterParameters, GroupBox oGroupBox, Int32 iX, Int32 &iY ) : PictureBox
sWorksheetName String
oDynamicFilterParameters DynamicFilterParameters
oGroupBox GroupBox
iX Int32
iY Int32
리턴 PictureBox

AddLabelToGroupBox() 보호된 메소드

protected AddLabelToGroupBox ( DynamicFilterParameters oDynamicFilterParameters, GroupBox oGroupBox, Int32 iX, Int32 iY ) : Label
oDynamicFilterParameters DynamicFilterParameters
oGroupBox GroupBox
iX Int32
iY Int32
리턴 Label

AddRangeTrackBarToGroupBox() 보호된 메소드

protected AddRangeTrackBarToGroupBox ( NumericFilterParameters oNumericFilterParameters, String sTableName, GroupBox oGroupBox, StringBuilder oDynamicFilterConditions, Int32 iX, Int32 &iY ) : IDynamicFilterRangeTrackBar
oNumericFilterParameters NumericFilterParameters
sTableName String
oGroupBox GroupBox
oDynamicFilterConditions StringBuilder
iX Int32
iY Int32
리턴 IDynamicFilterRangeTrackBar

AppendConditions() 보호된 메소드

protected AppendConditions ( StringBuilder oDynamicFilterConditions, String sColumnName, String sSelectedMinimumAddress, String sSelectedMaximumAddress ) : void
oDynamicFilterConditions StringBuilder
sColumnName String
sSelectedMinimumAddress String
sSelectedMaximumAddress String
리턴 void

AssertValid() 공개 메소드

public AssertValid ( ) : void
리턴 void

Dispose() 보호된 메소드

Clean up any resources being used.
protected Dispose ( bool disposing ) : void
disposing bool true if managed resources should be disposed; otherwise, false.
리턴 void

DynamicFilterDialog() 공개 메소드

Initializes a new instance of the class for the Visual Studio designer.
Do not use this constructor. It is for use by the Visual Studio designer only.
public DynamicFilterDialog ( ) : System
리턴 System

DynamicFilterDialog() 공개 메소드

Initializes a new instance of the class with a workbook.
public DynamicFilterDialog ( Microsoft workbook ) : System
workbook Microsoft /// Workbook containing the graph contents. ///
리턴 System

EscapeColumnName() 보호된 메소드

protected EscapeColumnName ( String sColumnName ) : String
sColumnName String
리턴 String

FireDynamicFilterColumnsChanged() 보호된 메소드

protected FireDynamicFilterColumnsChanged ( DynamicFilterColumns eDynamicFilterColumns ) : void
eDynamicFilterColumns DynamicFilterColumns
리턴 void

FireFilteredAlphaChanged() 보호된 메소드

protected FireFilteredAlphaChanged ( ) : void
리턴 void

GetDynamicFilterRangeTrackBars() 공개 메소드

public GetDynamicFilterRangeTrackBars ( ICollection &edgeDynamicFilterRangeTrackBars, ICollection &vertexDynamicFilterRangeTrackBars ) : void
edgeDynamicFilterRangeTrackBars ICollection
vertexDynamicFilterRangeTrackBars ICollection
리턴 void

GetRangeTrackBarRanges() 보호된 메소드

protected GetRangeTrackBarRanges ( NumericFilterParameters oNumericFilterParameters, String sTableName, Decimal &decAvailableMinimum, Decimal &decAvailableMaximum, Decimal &decSelectedMinimum, Decimal &decSelectedMaximum, String &sSelectedMinimumAddress, String &sSelectedMaximumAddress ) : void
oNumericFilterParameters NumericFilterParameters
sTableName String
decAvailableMinimum Decimal
decAvailableMaximum Decimal
decSelectedMinimum Decimal
decSelectedMaximum Decimal
sSelectedMinimumAddress String
sSelectedMaximumAddress String
리턴 void

InitializeAndRecalculateDynamicFilterColumns() 보호된 메소드

protected InitializeAndRecalculateDynamicFilterColumns ( ) : void
리턴 void

InitializeDynamicFilters() 보호된 메소드

protected InitializeDynamicFilters ( ) : void
리턴 void

InitializeDynamicFiltersForOneTable() 보호된 메소드

protected InitializeDynamicFiltersForOneTable ( String sWorksheetName, String sTableName, GroupBox oGroupBox ) : Microsoft.Office.Interop.Excel.Range
sWorksheetName String
sTableName String
oGroupBox GroupBox
리턴 Microsoft.Office.Interop.Excel.Range

OnClosed() 보호된 메소드

protected OnClosed ( EventArgs e ) : void
e EventArgs
리턴 void

OnLoad() 보호된 메소드

protected OnLoad ( EventArgs e ) : void
e EventArgs
리턴 void

OnSelectedRangeChanged() 보호된 메소드

protected OnSelectedRangeChanged ( IDynamicFilterRangeTrackBar oDynamicFilterRangeTrackBar ) : void
oDynamicFilterRangeTrackBar IDynamicFilterRangeTrackBar
리턴 void

RangeTrackBar_SelectedRangeChanged() 보호된 메소드

protected RangeTrackBar_SelectedRangeChanged ( object sender, EventArgs e ) : void
sender object
e EventArgs
리턴 void

RecalculateDynamicFilterColumns() 보호된 메소드

protected RecalculateDynamicFilterColumns ( DynamicFilterColumns eDynamicFilterColumns ) : void
eDynamicFilterColumns DynamicFilterColumns
리턴 void

ResetAllDynamicFilters() 보호된 메소드

protected ResetAllDynamicFilters ( ) : void
리턴 void

SetManualCalculation() 보호된 메소드

protected SetManualCalculation ( ) : void
리턴 void

StartChangeEventDelayTimer() 보호된 메소드

protected StartChangeEventDelayTimer ( Object oChangedControl ) : void
oChangedControl Object
리턴 void

m_oChangeEventDelayTimer_Tick() 보호된 메소드

protected m_oChangeEventDelayTimer_Tick ( object sender, EventArgs e ) : void
sender object
e EventArgs
리턴 void

프로퍼티 상세

m_bHandleControlEvents 보호되어 있는 프로퍼티

protected Boolean m_bHandleControlEvents
리턴 Boolean

m_oChangeEventDelayTimer 보호되어 있는 프로퍼티

protected Timer m_oChangeEventDelayTimer
리턴 Timer

m_oDynamicFilterDialogUserSettings 보호되어 있는 프로퍼티

protected DynamicFilterDialogUserSettings m_oDynamicFilterDialogUserSettings
리턴 DynamicFilterDialogUserSettings

m_oDynamicFilterSettings 보호되어 있는 프로퍼티

protected DynamicFilterSettings m_oDynamicFilterSettings
리턴 DynamicFilterSettings

m_oEdgeDynamicFilterColumnData 보호되어 있는 프로퍼티

protected Microsoft.Office.Interop.Excel.Range m_oEdgeDynamicFilterColumnData
리턴 Microsoft.Office.Interop.Excel.Range

m_oExcelCalculationRestorer 보호되어 있는 프로퍼티

protected ExcelCalculationRestorer m_oExcelCalculationRestorer
리턴 ExcelCalculationRestorer

m_oVertexDynamicFilterColumnData 보호되어 있는 프로퍼티

protected Microsoft.Office.Interop.Excel.Range m_oVertexDynamicFilterColumnData
리턴 Microsoft.Office.Interop.Excel.Range

m_oWorkbook 보호되어 있는 프로퍼티

protected Microsoft.Office.Interop.Excel.Workbook m_oWorkbook
리턴 Microsoft.Office.Interop.Excel.Workbook