C# devexpress 관련 자료 정리

DataTable 클래스에 insertAt 메소드 사용법

https://gent.tistory.com/316

https://stackoverflow.com/questions/20636398/add-data-row-to-datatable-at-predefined-index

 

LINQ 사용해서 index 값 가져오기

https://stackoverflow.com/questions/2471588/how-to-get-index-using-linq

 

devexpress gridlookupedit 기본값 설정법

https://supportcenter.devexpress.com/ticket/details/t395350/set-default-value-in-gridlookupedit

 

셀 값이 특정 셀값과 비교했을 때 다른 경우 색칠하기 (RowCellStyle 이벤트 사용)

https://supportcenter.devexpress.com/ticket/details/t676894/how-to-change-the-back-color-of-a-cell-in-on-cellvaluechanged-event

if (e.RowHandle >= 0)
            {
                if (e.Column.FieldName.Equals("PERSONQTY")) 
                {
                    string value = xgDetailView.GetRowCellValue(e.RowHandle, "PERSONQTY") == null ? "" : xgDetailView.GetRowCellValue(e.RowHandle, "PERSONQTY").ToString();
                    string value2 = xgDetailView.GetRowCellValue(e.RowHandle, "ERFMG") == null ? "" : xgDetailView.GetRowCellValue(e.RowHandle, "ERFMG").ToString();
                    int v_validity_lv = 0;
                    int v_validity_lv2 = 0;
                    if (value != "")
                    {
                        v_validity_lv = Convert.ToInt32(value);
                    }
                    if (value2 != "")
                    {
                        v_validity_lv2 = Convert.ToInt32(value2);
                    }
                    //int v_validity_lv = Convert.ToInt32(xgDetailView.GetRowCellValue(xgDetailView.FocusedRowHandle, "ERFMG") == null ? "" : xgDetailView.GetRowCellValue(xgDetailView.FocusedRowHandle, "ERFMG").ToString());                    
                    if (v_validity_lv != v_validity_lv2)
                    {
                        e.Appearance.BackColor = Color.Red;
                    }
                }
            }
        }

 

gridLookupEdit 에 row 추가 방법

https://docs.devexpress.com/WindowsForms/DevExpress.XtraGrid.Views.Base.ColumnView.AddNewRow?utm_source=SupportCenter&utm_medium=website&utm_campaign=docs-feedback&utm_content=T464923

DataTable cc = (DataTable)cboLine.Properties.DataSource;
            DataRow dr = cc.NewRow();
            dr["LINECODE"] = "ALL";
            dr["LINENAME"] = clsLangHelper.Ins.GetCaptionString("ALL");
            dr["PROD_PLAN_YN"] = "N";
            
            cc.Rows.InsertAt(dr, 0);

            cboLine.Properties.DataSource = cc;
            cboLine.Properties.NullText = "[" + clsLangHelper.Ins.GetCaptionString("ALL") + "]";
            cboLine.EditValue = cboLine.Properties.GetKeyValue(0);

 

dateEdit 기본 날짜 오늘로 지정하기

https://supportcenter.devexpress.com/ticket/details/t823229/dateedit-how-to-set-a-default-date

또는 Designer.cs 에서 dateEdit1.DateTime = DateTime.Now 로 값 세팅

 

RadioButton 사용법

https://todamfather.tistory.com/96

 

DataRow 컬럼 이름 변경방법 -> DataTable 통해서 변경해야 함

 

하나의 dataRow 만을 DataTable로 변경하는 방법 -> new DataRow[] { myDataRow }.CopyToDataTable()

https://stackoverflow.com/questions/2122511/simple-way-to-convert-datarow-array-to-datatable