/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME");
dt.Columns.Add("EVENT_NO");
dt.Columns.Add("EVENT_NAME");
dt.Columns.Add("DATE_FROM");
dt.Columns.Add("DATE_TO");
dt.Columns.Add("SALE_AMT", typeof(decimal));
dt.Columns.Add("SALE_AMT_1001", typeof(decimal));
dt.Columns.Add("SALE_AMT_6001", typeof(decimal));
dt.Columns.Add("SALE_AMT_6002", typeof(decimal));
dt.Columns.Add("SALE_AMT_7001", typeof(decimal));
dt.Columns.Add("SALE_AMT_3101", typeof(decimal));
dt.Columns.Add("SALE_AMT_ETC", typeof(decimal));
dt.Columns.Add("PAY_AMT", typeof(decimal));
dt.Columns.Add("DEPOSIT_CASH", typeof(decimal));
dt.Columns.Add("DEPOSIT_BANK", typeof(decimal));
dt.Columns.Add("DEPOSIT_CARD", 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("RECE_AMT", typeof(decimal));
dt.Columns.Add("ETC_AMT", typeof(decimal));
dt.Columns.Add("JAN_AMT", typeof(decimal));
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT_1001", "SALE_AMT_1001", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT_6001", "SALE_AMT_6001", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT_6002", "SALE_AMT_6002", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT_7001", "SALE_AMT_7001", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT_3101", "SALE_AMT_3101", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT_ETC", "SALE_AMT_ETC", 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, "DEPOSIT_CASH", "DEPOSIT_CASH", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEPOSIT_BANK", "DEPOSIT_BANK", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEPOSIT_CARD", "DEPOSIT_CARD", 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, "RECE_AMT", "RECE_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;
}
/// <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("RSV_NO");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("CHECKIN_DATE_VIEW");
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("CHECKOUT_DATE_VIEW");
dt.Columns.Add("DEPOSIT_RSV", typeof(decimal));
dt.Columns.Add("DEPOSIT_ROOM", typeof(decimal));
dt.Columns.Add("DEPOSIT_SUM", typeof(decimal));
dt.Columns.Add("MAECHUL", typeof(decimal));
dt.Columns.Add("DEFER", typeof(decimal));
dt.Columns.Add("TRANSFER", typeof(decimal));
dt.Columns.Add("MAECHUL_SUM", typeof(decimal));
dt.Columns.Add("CO_CASH", typeof(decimal));
dt.Columns.Add("CO_CARD", typeof(decimal));
dt.Columns.Add("CO_DEFER", typeof(decimal));
dt.Columns.Add("CO_ETC", typeof(decimal));
dt.Columns.Add("CO_SUM", typeof(decimal));
dt.Columns.Add("TOTAL_SUM", typeof(decimal));
dt.Columns.Add("OUT_CODE");
AdvBandedGrid.InitializeView(this.advBandedGridView, true);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEPOSIT_RSV", "DEPOSIT_RSV", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEPOSIT_ROOM", "DEPOSIT_ROOM", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEPOSIT_SUM", "DEPOSIT_SUM", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "MAECHUL", "MAECHUL", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "DEFER", "DEFER", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "TRANSFER", "TRANSFER", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "MAECHUL_SUM", "MAECHUL_SUM", 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, "CO_CARD", "CO_CARD", 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, "CO_ETC", "CO_ETC", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "CO_SUM", "CO_SUM", SummaryFormat.Sum);
Cls.Grid.Options.Footer(advBandedGridView, DevExpress.Data.SummaryItemType.Sum, "TOTAL_SUM", "TOTAL_SUM", SummaryFormat.Sum);
Cls.Grid.Options.SelectedRow(this.advBandedGridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.advBandedGridView, true);
this.grid.DataSource = dt;
}
/// <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;
}
