/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACI_PART"); dt.Columns.Add("TASK_DATE"); dt.Columns.Add("FROM_ROOM"); dt.Columns.Add("ROOM_TYPE"); dt.Columns.Add("TO_ROOM"); dt.Columns.Add("KEY_SEQ", typeof(decimal)); dt.Columns.Add("START_DATE"); dt.Columns.Add("START_DAY"); dt.Columns.Add("END_DATE"); dt.Columns.Add("END_DAY"); dt.Columns.Add("DEPT_SID"); dt.Columns.Add("DEPT_NAME"); dt.Columns.Add("BROKEN_CODE"); dt.Columns.Add("BROKEN_CODE_NAME"); dt.Columns.Add("BROKEN_STATE"); dt.Columns.Add("BROKEN_STATE_NAME"); dt.Columns.Add("I_DATE"); dt.Columns.Add("I_EMP_NO"); dt.Columns.Add("BROKEN_RMRK"); dt.Columns.Add("U_DATE"); dt.Columns.Add("U_DAY"); dt.Columns.Add("U_EMP_NO"); dt.Columns.Add("REPAIE_REMARKS"); //dt.Columns.Add("FORCASTING_YN"); AdvBandedGrid.InitializeView(this.advBandedGridView1, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "FROM_ROOM", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "ROOM_TYPE", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "START_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "END_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "DEPT_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "BROKEN_CODE_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "BROKEN_STATE_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "I_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "U_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "I_EMP_NO", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "U_EMP_NO", _ColumnType.Default, _ColumnAlign.Center, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "BROKEN_RMRK", _ColumnType.Default, _ColumnAlign.Left, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "REPAIE_REMARKS", _ColumnType.Default, _ColumnAlign.Left, true, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "FACI_PART", _ColumnType.Default, _ColumnAlign.Center, false, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "DEPT_SID", _ColumnType.Default, _ColumnAlign.Center, false, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "KEY_SEQ", _ColumnType.Default, _ColumnAlign.Center, false, false); AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "BROKEN_STATE", _ColumnType.Default, _ColumnAlign.Center, false, false); //AdvBandedGrid.InitializeColumn(this.advBandedGridView1, "FORCASTING_YN" , _ColumnType.Default, _ColumnAlign.Center, false, false); Cls.Grid.Options.SelectedRow(this.advBandedGridView1); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.advBandedGridView1, true); this.grid.DataSource = dt; }
//DxReport 추가 #region 데이터 테이블을 정의 합니다. /// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("LOCATE_CODE_FROM"); dt.Columns.Add("LOCATE_NAME_FROM"); dt.Columns.Add("SEX_CODE_FROM"); dt.Columns.Add("SEX_NAME_FROM"); dt.Columns.Add("LOCK_NO_FROM"); dt.Columns.Add("LOCATE_CODE_TO"); dt.Columns.Add("LOCATE_NAME_TO"); dt.Columns.Add("SEX_CODE_TO"); dt.Columns.Add("SEX_NAME_TO"); dt.Columns.Add("LOCK_NO_TO"); dt.Columns.Add("RMRK"); dt.Columns.Add("U_EMP_NO"); dt.Columns.Add("SALES_EMP_NAME"); dt.Columns.Add("U_SYS_DATE"); AdvBandedGrid.InitializeView(this.advBandedGridView, true); //GridStyle gs = new GridStyle(this.grid, this.gridView); //gs.AddColumn("영업장코드 [JA010DT]", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); //gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카위치이동전코드", "LOCATE_CODE_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카위치이동전명", "LOCATE_NAME_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카성별이동전", "SEX_CODE_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카성별이동전명", "SEX_NAME_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카번호이동전", "LOCK_NO_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카위치이동후코드", "LOCATE_CODE_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카위치이동후명", "LOCATE_NAME_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카성별이동후", "SEX_CODE_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카성별이동후명", "SEX_NAME_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("락카번호이동후", "LOCK_NO_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("수정일시", "RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("최종수정자사번", "U_EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("처리자", "SALES_EMP_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); //gs.AddColumn("처리일시", "U_SYS_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); //Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); //Cls.Grid.Options.FilterRow(this.gridView, true); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("CHECKOUT_DATE"); dt.Columns.Add("CHECKOUT_DATE_VIEW"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("MNG_NO"); dt.Columns.Add("MNG_SEQ", typeof(decimal)); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("GUEST_NAME"); dt.Columns.Add("ROOM_TYPE"); dt.Columns.Add("CHECKIN_DATE_VIEW"); dt.Columns.Add("NIGHTS", typeof(decimal)); dt.Columns.Add("CHECKOUT_TIME"); dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("GUEST_TYPE_NM"); dt.Columns.Add("ROOM_AMT", typeof(decimal)); dt.Columns.Add("OVER_AMT", typeof(decimal)); dt.Columns.Add("BED_AMT", typeof(decimal)); dt.Columns.Add("RENTAL_AMT", typeof(decimal)); //dt.Columns.Add("TEL_AMT", typeof(decimal)); //dt.Columns.Add("MINIBAR_AMT", typeof(decimal)); //dt.Columns.Add("LAUNDRY_AMT", typeof(decimal)); dt.Columns.Add("ROOM_DEFER", typeof(decimal)); dt.Columns.Add("ETC_AMT", typeof(decimal)); dt.Columns.Add("MAECHUL_TOTAL", typeof(decimal)); dt.Columns.Add("CO_DEPOSIT", typeof(decimal)); dt.Columns.Add("CO_CASH", typeof(decimal)); dt.Columns.Add("CO_CARD", typeof(decimal)); dt.Columns.Add("CO_EASY", typeof(decimal)); //dt.Columns.Add("CO_DEFER", typeof(decimal)); dt.Columns.Add("CO_TRUST", typeof(decimal)); dt.Columns.Add("CO_ETC", typeof(decimal)); dt.Columns.Add("IPGUM_TOTAL", typeof(decimal)); dt.Columns.Add("U_EMP_NO"); dt.Columns.Add("RMRK"); AdvBandedGrid.InitializeView(this.advBandedGridView, false); Cls.Grid.Options.SelectedRow(this.advBandedGridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.advBandedGridView, true); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "ROOM_AMT", "ROOM_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_DEPOSIT", "CO_DEPOSIT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "OVER_AMT", "OVER_AMT", SummaryFormat.Sum); //Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "TEL_AMT", "TEL_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_CASH", "CO_CASH", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "BED_AMT", "BED_AMT", SummaryFormat.Sum); //Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "MINIBAR_AMT", "MINIBAR_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_CARD", "CO_CARD", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "RENTAL_AMT", "RENTAL_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_EASY", "CO_EASY", SummaryFormat.Sum); //Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "LAUNDRY_AMT", "LAUNDRY_AMT", SummaryFormat.Sum); //Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_DEFER", "CO_DEFER", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "ROOM_DEFER", "ROOM_DEFER", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_TRUST", "CO_TRUST", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "ETC_AMT", "ETC_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_ETC", "CO_ETC", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "MAECHUL_TOTAL", "MAECHUL_TOTAL", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "IPGUM_TOTAL", "IPGUM_TOTAL", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("MNG_NO"); dt.Columns.Add("MNG_SEQ", typeof(decimal)); dt.Columns.Add("TEMP_MNG_NO"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("GUEST_NAME"); dt.Columns.Add("ROOM_TYPE"); dt.Columns.Add("CHECKIN_DATE"); dt.Columns.Add("CHECKIN_DATE_VIEW"); dt.Columns.Add("NIGHTS", typeof(decimal)); dt.Columns.Add("CHECKOUT_DATE"); dt.Columns.Add("CHECKOUT_DATE_VIEW"); dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("MEMBER_NAME"); dt.Columns.Add("JUN_AMT", typeof(decimal)); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("ROOM_AMT", typeof(decimal)); dt.Columns.Add("BED_AMT", typeof(decimal)); dt.Columns.Add("PER_AMT", typeof(decimal)); dt.Columns.Add("LOSS_AMT", typeof(decimal)); dt.Columns.Add("TEL_AMT", typeof(decimal)); dt.Columns.Add("ROOM_ETC_AMT", typeof(decimal)); dt.Columns.Add("LATER_AMT", typeof(decimal)); //dt.Columns.Add("TR_AMT", typeof(decimal)); dt.Columns.Add("PAY_AMT", typeof(decimal)); dt.Columns.Add("CASH_AMT", typeof(decimal)); dt.Columns.Add("BANK_AMT", typeof(decimal)); dt.Columns.Add("CARD_AMT", typeof(decimal)); dt.Columns.Add("EVENT_AMT", typeof(decimal)); dt.Columns.Add("RECE_AMT", typeof(decimal)); dt.Columns.Add("RSV_AMT", typeof(decimal)); dt.Columns.Add("TRANS_AMT", typeof(decimal)); dt.Columns.Add("DEPOSIT_AMT", typeof(decimal)); dt.Columns.Add("ETC_AMT", typeof(decimal)); dt.Columns.Add("JAN_AMT", typeof(decimal)); dt.Columns.Add("OUT_CODE"); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "JUN_AMT", "JUN_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "ROOM_AMT", "ROOM_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "BED_AMT", "BED_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "PER_AMT", "PER_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "LOSS_AMT", "LOSS_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "TEL_AMT", "TEL_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "ROOM_ETC_AMT", "ROOM_ETC_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "LATER_AMT", "LATER_AMT", SummaryFormat.Sum); //Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "TR_AMT", "TR_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "PAY_AMT", "PAY_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CASH_AMT", "CASH_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "BANK_AMT", "BANK_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CARD_AMT", "CARD_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "EVENT_AMT", "EVENT_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "RECE_AMT", "RECE_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "TRANS_AMT", "TRANS_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEPOSIT_AMT", "DEPOSIT_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "ETC_AMT", "ETC_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "JAN_AMT", "JAN_AMT", SummaryFormat.Sum); AdvBandedGrid.InitializeView(this.advBandedGridView, true); Cls.Grid.Options.SelectedRow(this.advBandedGridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.advBandedGridView, true); this.grid.DataSource = dt; }