퇴근5분전


테이블형태의 데이타를 표시해주는 데이타 그리드뷰.
2년 내내 이것뿐이 써본게 없다. 

모든 그리드뷰를 동일한 설정을 주고자 한다면 UI디자인상에서 하는건
오마이갓!! 이될것이다.

이를 DataGridViewManager 라는것으로 만들어서 처리한다.
코드가 많아보인다라면.. 우리에겐 카피앤패스트가 있기 때문에 주저하지 않고 적용이 가능해진다.

  private void InitReportDestinationGrid()
        {
            try
            {
                #region  그리드 뷰 셋팅!
// 컬럼추가
                DataGridViewManager.ColumnAdd(ReportDestinationGrid, "NO", "전송타입", DataGridViewManager.ColumnType.TextBox, true);
                DataGridViewManager.ColumnAdd(ReportDestinationGrid, "USERYN0", "자연지진", DataGridViewManager.ColumnType.CheckBox, false);
                DataGridViewManager.ColumnAdd(ReportDestinationGrid, "TARGET", "전송매체", DataGridViewManager.ColumnType.TextBox, true);
                DataGridViewManager.ColumnAdd(ReportDestinationGrid, "MEMBER", "등록자수", DataGridViewManager.ColumnType.TextBox, true);
                DataGridViewManager.ColumnAdd(ReportDestinationGrid, "USERYN1", "인공지진", DataGridViewManager.ColumnType.CheckBox, false);

                Color columnBackGroundColor = Color.White; // 백그라운드컬러
// 컬럼셋팅
                DataGridViewManager.ColumnsConfig(ReportDestinationGrid, "NO", columnBackGroundColor, false,
                    null, 1, DataGridViewColumnSortMode.NotSortable,
                    new DataGridViewManager.DgvContentAlignment(DataGridViewContentAlignment.MiddleCenter));
                DataGridViewManager.ColumnsConfig(ReportDestinationGrid, "USERYN0", columnBackGroundColor, null,
                    null, 20, DataGridViewColumnSortMode.NotSortable,
                    new DataGridViewManager.DgvContentAlignment(DataGridViewContentAlignment.MiddleCenter));
                DataGridViewManager.ColumnsConfig(ReportDestinationGrid, "TARGET", columnBackGroundColor, null,
                    null, 40, DataGridViewColumnSortMode.NotSortable,
                    new DataGridViewManager.DgvContentAlignment(DataGridViewContentAlignment.MiddleLeft));
                DataGridViewManager.ColumnsConfig(ReportDestinationGrid, "MEMBER", columnBackGroundColor, null,
                    null, 40, DataGridViewColumnSortMode.NotSortable,
                    new DataGridViewManager.DgvContentAlignment(DataGridViewContentAlignment.MiddleCenter));
                DataGridViewManager.ColumnsConfig(ReportDestinationGrid, "USERYN1", columnBackGroundColor, null,
                    null, 20, DataGridViewColumnSortMode.NotSortable,
                    new DataGridViewManager.DgvContentAlignment(DataGridViewContentAlignment.MiddleCenter));
// 그리드뷰 셋팅
                DataGridViewManager.Config(ReportDestinationGrid, false, false, false, false, null, false,
                    new DataGridViewManager.DgvSelectionMode(DataGridViewSelectionMode.FullRowSelect),
                    new DataGridViewManager.DgvCellBorderStyle(DataGridViewCellBorderStyle.Sunken),
                    new DataGridViewManager.DgvAutoSizeColumnsMode(DataGridViewAutoSizeColumnsMode.Fill)
                    );
// 그리드뷰 컬러 설정
                DataGridViewManager.SetRowColor(ReportDestinationGrid, columnBackGroundColor, columnBackGroundColor);
                #endregion
                #region 그리드 뷰 데이타 바인딩
// 그리드뷰 데이타 바인딩
                StringBuilder sb = new StringBuilder();
                {
                    sb.AppendFormat(" Select SendType");
                    sb.AppendFormat("       ,Send_YN");
                    sb.AppendFormat("       ,SendList");
                    sb.AppendFormat("       ,User_Count");
                    sb.AppendFormat("       ,Send_YN1");
                    sb.AppendFormat(" From   {테이블명}");
                    sb.AppendFormat(" Order by SendList ASC");

                    DataSet ds = msDB.GetDataSet(sb.ToString());

                    if (DataSetCheck.HasTable(ds) && DataSetCheck.HasTableRow(ds, 0))
                    {
                        DataGridViewManager.RowsAdd(ReportDestinationGrid, ds.Tables[0], false);
                       //데이타 그리드를 선택하고 데이타를 바인딩 시킴

        }
         else
        {
             Alert("검색된 데이타가 없습니다.");
         }
     }
      sb = null; 
      #endregion
 }
 catch (Exception ex)
 {
         Alert(ex.Message);
 }

}

'# 2) .Net ( Vs 2005 ) > WinForm' 카테고리의 다른 글

처음 만든 이미지 뷰어  (0) 2009.05.02
폼간 데이타 전달  (0) 2009.05.02
SMS TextLength 비교  (0) 2009.05.01
Excel Export  (0) 2009.05.01
판넬 슬라이드 애니메이션  (0) 2009.05.01