[DevExpress] GridContol, GridView 사용방법

1. DevExpress GRIDCONTROL 데이터 바인딩후 COLUMN VIEW 바인딩은 어떻게?
 -> Grid Designer -> Columns -> FieldName 설정하면됨

2. 가로 스크롤바 생성방법?
optionView -> ColunmAutoWidth -> False

3. checkbox 설정방법
->Columns -> ColumnEdit 에서 설정 하위 항목 NullText, VlaueChecked, 설정해주면된다

4. 선택된 rowdata 받아오는법
DataRow dr = this.gridView1.GetFocusedDataRow();

5. click 이벤트
 -> 클릭이벤트는 따로 없는거 같고  gridView1_FocusedRowObjectChanged 로 그냥 값뿌려줌

6. column Font 변경
 상세모드 들어가서 각컬럼마다 별도러 설정해줌

7.FocusRectStyle
 ->cell에 선택되어있으면 cell 주면에 점선이 생기고 
row선택하면 row전체 주변에 점선

8. Column 의 Display 값 변경하려면 
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
        {
            if(e.Column.FieldName == "WC_PROSTAT") {
                if(e.Value.ToString() == "01")
                {
                    e.DisplayText = "완료";
                }else if(e.Value.ToString() == "02")
                {
                    e.DisplayText = "진행중";
                }
                else
                {
                    e.DisplayText = "보류";
                }

            }

9 컬럼의 데이터 형식이 YYYY-MM-DD 가 기본형식인데 다른 형식으로 바꾸기 위해서는
columns -> 바꿀 컬럼 선택후 format 으로 검색 
1. FormatType = DateTime
2. FormatString = yyyy-MM-dd hh:mm 소문자로 써야된다. 월은 대문자.

10. GridView value값이랑 view값이랑 매칭은 어떻게?
private void gridView1_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
        {
            if(e.Column.FieldName == "WC_PROSTAT") {
                if(e.Value.ToString() == "01")
                {
                    e.DisplayText = "완료";
                }else if(e.Value.ToString() == "02")
                {
                    e.DisplayText = "진행중";
                }
                else
                {
                    e.DisplayText = "보류";
                }

           }
메서드 생성해서 만들어주면 된다.


11. 바인딩하고 처음 셀 선택 해제 방법
dataGridView.ClearSelection();

12. GridControl Header, row 폰트 바꾸는 방법
 - Row 폰트
 GridView.Appearance.Row.Font 변경
 - header폰트
GridView.Appearance.HeaderPanel.Font 속성변경해주고
UseTextOption 을 False 로 지정해주면 Font 속성 바꿀수 있다. 

13. 열 넓이 자동 조종
this.gridView1.BestFitColumns();

14. 셀 선택시 셀 색 바뀌는 옵션
EnableAppearanceFocusedCell = False 로 변경

15. GridView 선택시 셀선택하면 이벤트 발생하는 로직
private void gridView1_FocusedColumnChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedColumnChangedEventArgs e)
        {
                if (e.FocusedColumn.FieldName == "INSP_RESULT")
                {
                int i = 0;
                }
        }

16. GridControl Group 화 Row 제거방법
GridView.OptionsView.ShowGroupPanel 속성 False