/// <summary> /// 사용자 정보 데이타 그리드를 설정합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("USE_DATE"); dt.Columns.Add("DAY_NAME"); dt.Columns.Add("MENU_ITEM1"); dt.Columns.Add("SEASON_NAME"); dt.Columns.Add("MENU_CODE"); dt.Columns.Add("MENU_ITEM11"); dt.Columns.Add("MENU_ITEM2"); dt.Columns.Add("MENU_ITEM3"); dt.Columns.Add("MENU_ITEM4"); dt.Columns.Add("MENU_ITEM5"); dt.Columns.Add("MENU_DATE"); dt.Columns.Add("STND_AMT", typeof(decimal)); dt.Columns.Add("DC_RATE", typeof(decimal)); dt.Columns.Add("UNIT_AMT", typeof(decimal)); dt.Columns.Add("FNB_AMT", typeof(decimal)); dt.Columns.Add("CONFIRM"); dt.Columns.Add("M_DC_RATE"); dt.Columns.Add("DC_STND_AMT", typeof(decimal)); dt.Columns.Add("DC_STND_AMT_DC", typeof(decimal)); //리턴될때 해당 필드는 제외 됩니다. dt.PrimaryKey = new DataColumn[] { dt.Columns["USE_DATE"] }; Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.grid, this.gridView); gs.AddColumn("영업일자", "USE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("요일", "DAY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("시즌명", "SEASON_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("고객유형", "MENU_ITEM2", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실유형", "MENU_ITEM3", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("정상요금", "STND_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("할인요금", "DC_STND_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true, true); gs.AddColumn("확정여부", "CONFIRM", _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; }
private void JIAAI09_Load(object sender, EventArgs e) { try { Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.grid, this.gridView); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true, true); gs.AddColumn("중복횟수", "CARD_NO_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true, true); gs.AddColumn("승인번호중복", "AGREE_NO_CNT", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("설명", "MEMO", _ColumnType.Default, 100, _ColumnAlign.Center, true); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); this.gridView.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridView.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridView.OptionsSelection.EnableAppearanceHideSelection = true; } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
/// <summary> /// 데이터 테이블을 정의합니다. /// </summary> private void SetDataTable() { try { dt.Columns.Add("CHK"); dt.Columns.Add("SALE_DATE"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); dt.Columns.Add("SALE_YN"); dt.Columns.Add("PAY_SEQ", typeof(decimal)); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("VALID_THRU_NAME"); dt.Columns.Add("VALID_THRU"); dt.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dt.Columns.Add("AGREE_YN"); dt.Columns.Add("AGREE_NO"); dt.Columns.Add("ORG_AGREE_NO"); dt.Columns.Add("AGREE_TIME"); dt.Columns.Add("EASY_YN"); dt.Columns.Add("CARD_CO_CODE"); dt.Columns.Add("CARD_CO_NAME"); dt.Columns.Add("ISSU_CO_CODE"); dt.Columns.Add("ISSU_CO_NAME"); dt.Columns.Add("CARD_JOIN_NO"); dt.Columns.Add("KEYIN_YN"); dt.Columns.Add("VAN_ID"); dt.Columns.Add("COMPANY_ID"); dt.Columns.Add("TRACK_TWO"); dt.Columns.Add("KIND"); dt.Columns.Add("SALE_AMT_ABS"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridData, this.gridViewData); gs.AddColumn("재청구", "CHK", _ColumnType.CheckBox, 80, _ColumnAlign.Center, true, true, DevExpress.Utils.DefaultBoolean.False); gs.AddColumn("데이터구분", "KIND", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("코드", "FACILITY_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("이지체크", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("승인일시", "AGREE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("포스", "POS_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("판매", "SALE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Numbers, 40, _ColumnAlign.Right, true, false); gs.AddColumn("유효기간", "VALID_THRU", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true, false); gs.AddColumn("승인", "AGREE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("키인", "KEYIN_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("유효기간", "VALID_THRU_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("가맹번호", "CARD_JOIN_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("밴사업자번호", "VAN_ID", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("매입사사업자번호", "COMPANY_ID", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("트랙2정보", "TRACK_TWO", _ColumnType.Default, 80, _ColumnAlign.Center, false); this.gridViewData.OptionsView.ShowGroupPanel = true; Cls.Grid.Options.SelectedRow(this.gridViewData); Cls.Grid.Options.EmbeddedNavigater(this.gridData); Cls.Grid.Options.FilterRow(this.gridViewData, true); Cls.Grid.Options.Footer(this.gridViewData, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.gridData.DataSource = dt; this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewData.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewData.OptionsSelection.EnableAppearanceHideSelection = true; ContextMenu popUpMenus; MenuItem chkAlls; MenuItem checkClears; MenuItem checConvert; popUpMenus = new ContextMenu(); popUpMenus.MenuItems.Add("전체선택", new EventHandler(popup_Res)); popUpMenus.MenuItems.Add("전체해제", new EventHandler(popup_Res)); popUpMenus.MenuItems.Add("선택반전", new EventHandler(popup_Res)); this.gridData.ContextMenu = popUpMenus; chkAlls = gridData.ContextMenu.MenuItems[0]; checkClears = gridData.ContextMenu.MenuItems[1]; checConvert = gridData.ContextMenu.MenuItems[2]; } catch (Exception ex) { throw ex; } }
/****************************************/ #endregion #region 사용자 정의함수 #region 데이터 테이블을 정의합니다. /// <summary> /// 데이터 테이블을 정의합니다. /// </summary> private void SetDataTable() { try { dt.Columns.Add("CHK"); dt.Columns.Add("SALE_DATE"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); dt.Columns.Add("SALE_YN"); dt.Columns.Add("PAY_SEQ", typeof(decimal)); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("VALID_THRU_NAME"); dt.Columns.Add("VALID_THRU"); dt.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dt.Columns.Add("AGREE_YN"); dt.Columns.Add("AGREE_NO"); dt.Columns.Add("ORG_AGREE_NO"); dt.Columns.Add("AGREE_TIME"); dt.Columns.Add("EASY_YN"); dt.Columns.Add("CARD_CO_CODE"); dt.Columns.Add("CARD_CO_NAME"); dt.Columns.Add("ISSU_CO_CODE"); dt.Columns.Add("ISSU_CO_NAME"); dt.Columns.Add("CARD_JOIN_NO"); dt.Columns.Add("KEYIN_YN"); dt.Columns.Add("VAN_ID"); dt.Columns.Add("COMPANY_ID"); dt.Columns.Add("TRACK_TWO"); dt.Columns.Add("KIND"); dt.Columns.Add("SALE_AMT_ABS"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridData, this.gridViewData); gs.AddColumn("청구선택", "CHK", _ColumnType.CheckBox, 80, _ColumnAlign.Center, true, true, DevExpress.Utils.DefaultBoolean.False); gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("코드", "FACILITY_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("이지체크", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("유효기간-YYMM", "VALID_THRU", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("승인일시", "AGREE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("포스", "POS_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("판매", "SALE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Numbers, 40, _ColumnAlign.Right, true, false); gs.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true, false); gs.AddColumn("승인", "AGREE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("키인", "KEYIN_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("데이터구분", "KIND", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("유효기간", "VALID_THRU_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("가맹번호", "CARD_JOIN_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("밴사업자번호", "VAN_ID", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("매입사사업자번호", "COMPANY_ID", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("트랙2정보", "TRACK_TWO", _ColumnType.Default, 80, _ColumnAlign.Center, false); this.gridViewData.OptionsView.ShowGroupPanel = true; //Cls.Grid.Options.SelectedRow(this.gridViewData); Cls.Grid.Options.EmbeddedNavigater(this.gridData); Cls.Grid.Options.FilterRow(this.gridViewData, true); Cls.Grid.Options.Footer(this.gridViewData, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.gridData.DataSource = dt; this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = true; this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewData.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewData.OptionsSelection.EnableAppearanceHideSelection = true; StyleFormatCondition condition2 = new DevExpress.XtraGrid.StyleFormatCondition(); condition2.Column = gridViewData.Columns["AGREE_DATE"]; condition2.ApplyToRow = true; condition2.Appearance.BackColor = Color.Red; condition2.Appearance.Options.UseBackColor = true; condition2.Condition = FormatConditionEnum.Expression; condition2.Expression = "LEN(ISNULL(AGREE_DATE,'')) <> 10 "; //OR SUBSTRING(VALID_THRU, 3, 2) > 12 gridViewData.FormatConditions.Add(condition2); StyleFormatCondition condition3 = new DevExpress.XtraGrid.StyleFormatCondition(); condition3.Column = gridViewData.Columns["VALID_THRU"]; condition3.ApplyToRow = true; condition3.Appearance.BackColor = Color.Red; condition3.Appearance.Options.UseBackColor = true; condition3.Condition = FormatConditionEnum.Expression; condition3.Expression = "SUBSTRING(VALID_THRU, 3, 2) > 12 "; //OR gridViewData.FormatConditions.Add(condition3); StyleFormatCondition condition9 = new DevExpress.XtraGrid.StyleFormatCondition(); condition9.Column = gridViewData.Columns["KIND"]; condition9.ApplyToRow = true; condition9.Appearance.BackColor = Color.LightBlue; condition9.Appearance.Options.UseBackColor = true; condition9.Condition = FormatConditionEnum.Expression; condition9.Expression = "KIND = '청구제외'"; //OR SUBSTRING(VALID_THRU, 3, 2) > 12 gridViewData.FormatConditions.Add(condition9); ContextMenu popUpMenus; MenuItem chkAlls; MenuItem checkClears; MenuItem checConvert; popUpMenus = new ContextMenu(); popUpMenus.MenuItems.Add("전체선택", new EventHandler(popup_Res)); popUpMenus.MenuItems.Add("전체해제", new EventHandler(popup_Res)); popUpMenus.MenuItems.Add("선택반전", new EventHandler(popup_Res)); this.gridData.ContextMenu = popUpMenus; chkAlls = gridData.ContextMenu.MenuItems[0]; checkClears = gridData.ContextMenu.MenuItems[1]; checConvert = gridData.ContextMenu.MenuItems[2]; } catch (Exception ex) { throw ex; } }
/// <summary> /// 데이터 테이블을 정의합니다. /// </summary> private void SetDataTable() { try { dtDetail.Columns.Add("SALE_DATE"); dtDetail.Columns.Add("FACILITY_CODE"); dtDetail.Columns.Add("FACILITY_NAME"); dtDetail.Columns.Add("POS_NO"); dtDetail.Columns.Add("BILL_NO"); dtDetail.Columns.Add("SALE_YN"); dtDetail.Columns.Add("PAY_SEQ", typeof(decimal)); dtDetail.Columns.Add("SALE_AMT", typeof(decimal)); dtDetail.Columns.Add("CARD_NO"); dtDetail.Columns.Add("AGREE_DATE"); dtDetail.Columns.Add("VALID_THRU"); dtDetail.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dtDetail.Columns.Add("AGREE_NO"); dtDetail.Columns.Add("ORG_AGREE_NO"); dtDetail.Columns.Add("CARD_CO_CODE"); dtDetail.Columns.Add("CARD_CO_NAME"); dtDetail.Columns.Add("ISSU_CO_CODE"); dtDetail.Columns.Add("ISSU_CO_NAME"); dtDetail.Columns.Add("CARD_JOIN_NO"); dtDetail.Columns.Add("TID"); this.gridDetail.DataSource = dtDetail; GridStyle gsDetail = new GridStyle(this.gridDetail, this.gridViewDetail); gsDetail.AddColumn("영업일자", "SALE_DATE", _ColumnType.DateTime, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("POS", "POS_NO", _ColumnType.Default, 60, _ColumnAlign.Center, true); gsDetail.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("입금순번", "PAY_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsDetail.AddColumn("판매총계", "SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsDetail.AddColumn("승인일자", "AGREE_DATE", _ColumnType.TextEdit, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true); gsDetail.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsDetail.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("EDI", "TID", _ColumnType.Default, 80, _ColumnAlign.Center); this.gridViewDetail.Columns["CARD_NO"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridViewDetail.Columns["AGREE_NO"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridViewDetail.Columns["ORG_AGREE_NO"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridViewDetail.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewDetail.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewDetail.OptionsSelection.EnableAppearanceHideSelection = true; dt.Columns.Add("CHK"); dt.Columns.Add("EDIT_DATE"); dt.Columns.Add("SALE_DATE"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); dt.Columns.Add("SALE_YN"); dt.Columns.Add("PAY_SEQ", typeof(decimal)); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("VALID_THRU_NAME"); dt.Columns.Add("VALID_THRU"); dt.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dt.Columns.Add("AGREE_YN"); dt.Columns.Add("AGREE_NO"); dt.Columns.Add("ORG_AGREE_NO"); dt.Columns.Add("AGREE_TIME"); dt.Columns.Add("EASY_YN"); dt.Columns.Add("CARD_CO_CODE"); dt.Columns.Add("CARD_CO_NAME"); dt.Columns.Add("ISSU_CO_CODE"); dt.Columns.Add("ISSU_CO_NAME"); dt.Columns.Add("KIND"); dt.Columns.Add("MSG"); dt.Columns.Add("RETURN_DATE"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridData, this.gridViewData); gs.AddColumn("완료처리", "CHK", _ColumnType.CheckBox, 90, _ColumnAlign.Center, true, true, DevExpress.Utils.DefaultBoolean.False); gs.AddColumn("구분", "KIND", _ColumnType.Default, 80, _ColumnAlign.Right, true); gs.AddColumn("반송일시", "RETURN_DATE", _ColumnType.Default, 80, _ColumnAlign.Right, true); gs.AddColumn("수정일시", "EDIT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("내용", "MSG", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("이지체크", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("코드", "FACILITY_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("유효기간-YYMM", "VALID_THRU", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일시", "AGREE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("포스", "POS_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("판매", "SALE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Numbers, 40, _ColumnAlign.Right, true, false); gs.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true, false); gs.AddColumn("승인", "AGREE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); Options.SetColumnColor(this.gridViewData, StyleFormatConditionType.Column, this.gridViewData.Columns["AGREE_DATE"], FormatConditionEnum.GreaterOrEqual, Color.Pink, null); Options.SetColumnColor(this.gridViewData, StyleFormatConditionType.Column, this.gridViewData.Columns["CARD_NO"], FormatConditionEnum.GreaterOrEqual, Color.LightBlue, null); Options.SetColumnColor(this.gridViewData, StyleFormatConditionType.Column, this.gridViewData.Columns["AGREE_NO"], FormatConditionEnum.GreaterOrEqual, Color.LightBlue, null); Options.SetColumnColor(this.gridViewData, StyleFormatConditionType.Column, this.gridViewData.Columns["ORG_AGREE_NO"], FormatConditionEnum.GreaterOrEqual, Color.LightBlue, null); Options.SetColumnColor(this.gridViewData, StyleFormatConditionType.Column, this.gridViewData.Columns["SALE_AMT"], FormatConditionEnum.GreaterOrEqual, Color.Pink, null); this.gridViewData.Columns["CARD_NO"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridViewData.Columns["AGREE_NO"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridViewData.Columns["ORG_AGREE_NO"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridViewData.OptionsView.ShowGroupPanel = true; //Cls.Grid.Options.SelectedRow(this.gridViewData); Cls.Grid.Options.EmbeddedNavigater(this.gridData); Cls.Grid.Options.FilterRow(this.gridViewData, true); Cls.Grid.Options.Footer(this.gridViewData, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.gridData.DataSource = dt; ; } catch (Exception ex) { throw ex; } }
private void JIAAI10_Load(object sender, EventArgs e) { try { dt.Columns.Add("SALE_DATE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); dt.Columns.Add("SALE_YN"); dt.Columns.Add("PAY_SEQ", typeof(decimal)); dt.Columns.Add("AGREE_YN"); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("AGREE_NO"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("AGREE_TIME"); dt.Columns.Add("ORG_AGREE_NO"); dt.Columns.Add("CARD_CO_CODE"); dt.Columns.Add("CARD_CO_NAME"); dt.Columns.Add("ISSU_CO_CODE"); dt.Columns.Add("ISSU_CO_NAME"); dt.Columns.Add("EASY_YN"); dt.Columns.Add("TID"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.grid, this.gridView); gs.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("업장이름", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("판매여부", "SALE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true, false); gs.AddColumn("승인구분", "AGREE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("판매액", "SALE_AMT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일시", "AGREE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("키인여부", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("구분", "TID", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.Options.SetColumnColor(this.gridView, StyleFormatConditionType.Column, this.gridView.Columns["CARD_NO"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.LightBlue, null); Cls.Grid.Options.SetColumnColor(this.gridView, StyleFormatConditionType.Column, this.gridView.Columns["AGREE_NO"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.Pink, null); Cls.Grid.Options.SetColumnColor(this.gridView, StyleFormatConditionType.Column, this.gridView.Columns["ORG_AGREE_NO"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.Pink, null); this.grid.DataSource = dt; this.gridView.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridView.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridView.OptionsSelection.EnableAppearanceHideSelection = true; DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParm.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); dtParm.Rows.Add(new object[] { "V_CARD_NO", _CardNo }); dtParm.Rows.Add(new object[] { "V_AGREE_NO", _AgreeNo }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_JIAAI10.PR_01", dtParm, DataLayer.MessageEncoding.Default); dt.Clear(); dt.Load(ds.Tables[0].CreateDataReader()); } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
/****************************************/ /// <summary> /// dt 에 대한 집계 테이블 입니다. /// </summary> #endregion #region 사용자 정의함수 #region 데이터 테이블을 정의합니다. /// <summary> /// 데이터 테이블을 정의합니다. /// </summary> private void SetDataTable() { try { dt.Columns.Add("REG_DATE"); dt.Columns.Add("SALE_DATE"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); dt.Columns.Add("SALE_YN"); dt.Columns.Add("PAY_SEQ", typeof(decimal)); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("VALID_THRU_NAME"); dt.Columns.Add("VALID_THRU"); dt.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dt.Columns.Add("AGREE_YN"); dt.Columns.Add("AGREE_NO"); dt.Columns.Add("ORG_AGREE_NO"); dt.Columns.Add("AGREE_TIME"); dt.Columns.Add("EASY_YN"); dt.Columns.Add("CARD_CO_CODE"); dt.Columns.Add("CARD_CO_NAME"); dt.Columns.Add("ISSU_CO_CODE"); dt.Columns.Add("ISSU_CO_NAME"); dt.Columns.Add("CARD_JOIN_NO"); dt.Columns.Add("KEYIN_YN"); dt.Columns.Add("VAN_ID"); dt.Columns.Add("COMPANY_ID"); dt.Columns.Add("TRACK_TWO"); dt.Columns.Add("KIND"); dt.Columns.Add("SALE_AMT_ABS"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridData, this.gridViewData); gs.AddColumn("청구일자", "REG_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("코드", "FACILITY_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("이지체크", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("유효기간-YYMM", "VALID_THRU", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("승인일시", "AGREE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("포스", "POS_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("판매", "SALE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Numbers, 40, _ColumnAlign.Right, true, false); gs.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("승인", "AGREE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("키인", "KEYIN_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("데이터구분", "KIND", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("유효기간", "VALID_THRU_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("가맹번호", "CARD_JOIN_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("밴사업자번호", "VAN_ID", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("매입사사업자번호", "COMPANY_ID", _ColumnType.Default, 80, _ColumnAlign.Center, false); this.gridViewData.OptionsView.ShowGroupPanel = true; //Cls.Grid.Options.SelectedRow(this.gridViewData); Cls.Grid.Options.EmbeddedNavigater(this.gridData); Cls.Grid.Options.FilterRow(this.gridViewData, true); Cls.Grid.Options.Footer(this.gridViewData, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.gridData.DataSource = dt; this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewData.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewData.OptionsSelection.EnableAppearanceHideSelection = true; } catch (Exception ex) { throw ex; } }
/// <summary> /// 데이터 테이블의 스키마를 설정합니다. /// </summary> private void SetDataTable() { try { //전체객실 [가용객실] dt_Tot.Columns.Add("ROOM_NO"); dt_Tot.Columns.Add("FACI_PART"); dt_Tot.Columns.Add("EXCLUSIVE_CODE"); dt_Tot.Columns.Add("EXCLUSIVE_YN"); dt_Tot.Columns.Add("ROOM_TYPE"); dt_Tot.Columns.Add("ROOM_VIEW"); dt_Tot.Columns.Add("CLEAN_STAT"); dt_Tot.Columns.Add("ROOM_STAT"); dt_Tot.Columns.Add("GUEST_NAME"); dt_Tot.Columns.Add("MAIN_YN"); dt_Tot.Columns.Add("POS"); dt_Tot.Columns.Add("CHK"); dt_Tot.PrimaryKey = new DataColumn[] { dt_Tot.Columns["ROOM_NO"] }; Cls.Grid.GridStyle gsTot = new Cls.Grid.GridStyle(this.grid_Tot, this.gridView_Tot); gsTot.AddColumn("객실", "ROOM_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsTot.AddColumn("전용", "EXCLUSIVE_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsTot.AddColumn("유형", "ROOM_TYPE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsTot.AddColumn("전망", "ROOM_VIEW", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsTot.AddColumn("청소", "CLEAN_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsTot.AddColumn("상태", "ROOM_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsTot.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gsTot.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true); Cls.Grid.Options.SelectedRow(this.gridView_Tot); Cls.Grid.Options.EmbeddedNavigater(this.grid_Tot); Cls.Grid.Options.FilterRow(this.gridView_Tot, true); this.grid_Tot.DataSource = dt_Tot; ///////////////////////////////////////////////////////////////////////////////////////////////////////// //RoomAssign dt_Assign.Columns.Add("ROOM_NO"); dt_Assign.Columns.Add("FACI_PART"); dt_Assign.Columns.Add("EXCLUSIVE_CODE"); dt_Assign.Columns.Add("EXCLUSIVE_YN"); dt_Assign.Columns.Add("ROOM_TYPE"); dt_Assign.Columns.Add("ROOM_VIEW"); dt_Assign.Columns.Add("CLEAN_STAT"); dt_Assign.Columns.Add("ROOM_STAT"); dt_Assign.Columns.Add("GUEST_NAME"); dt_Assign.Columns.Add("MAIN_YN"); dt_Assign.Columns.Add("POS"); dt_Assign.Columns.Add("CHK"); dt_Assign.PrimaryKey = new DataColumn[] { dt_Assign.Columns["ROOM_NO"] }; Cls.Grid.GridStyle gsAssign = new Cls.Grid.GridStyle(this.grid_Assign, this.gridView_Assign); gsAssign.AddColumn("객실", "ROOM_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAssign.AddColumn("전용", "EXCLUSIVE_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAssign.AddColumn("유형", "ROOM_TYPE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAssign.AddColumn("전망", "ROOM_VIEW", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAssign.AddColumn("청소", "CLEAN_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAssign.AddColumn("상태", "ROOM_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAssign.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsAssign.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true); Cls.Grid.Options.SelectedRow(this.gridView_Assign); Cls.Grid.Options.EmbeddedNavigater(this.grid_Assign); Cls.Grid.Options.FilterRow(this.gridView_Assign, true); this.grid_Assign.DataSource = dt_Assign; ///////////////////////////////////////////////////////////////////////////////////////////////////////// dt_Added.Columns.Add("ROOM_NO"); dt_Added.Columns.Add("FACI_PART"); dt_Added.Columns.Add("EXCLUSIVE_CODE"); dt_Added.Columns.Add("EXCLUSIVE_YN"); dt_Added.Columns.Add("ROOM_TYPE"); dt_Added.Columns.Add("ROOM_VIEW"); dt_Added.Columns.Add("CLEAN_STAT"); dt_Added.Columns.Add("ROOM_STAT"); dt_Added.Columns.Add("GUEST_NAME"); dt_Added.Columns.Add("MAIN_YN"); dt_Added.PrimaryKey = new DataColumn[] { dt_Added.Columns["ROOM_NO"] }; Cls.Grid.GridStyle gsAdded = new Cls.Grid.GridStyle(this.grid_Added, this.gridView_Added); gsAdded.AddColumn("객실", "ROOM_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAdded.AddColumn("전용", "EXCLUSIVE_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAdded.AddColumn("유형", "ROOM_TYPE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAdded.AddColumn("전망", "ROOM_VIEW", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAdded.AddColumn("청소", "CLEAN_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAdded.AddColumn("상태", "ROOM_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsAdded.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsAdded.AddColumn("메인", "MAIN_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridView_Added); Cls.Grid.Options.EmbeddedNavigater(this.grid_Added); Cls.Grid.Options.FilterRow(this.gridView_Added, true); this.grid_Added.DataSource = dt_Added; dt_New = dt_Assign.Clone(); Cls.Grid.GridStyle gsNew = new Cls.Grid.GridStyle(this.grid_New, this.gridView_New); gsNew.AddColumn("객실", "ROOM_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsNew.AddColumn("전용", "EXCLUSIVE_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsNew.AddColumn("유형", "ROOM_TYPE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsNew.AddColumn("전망", "ROOM_VIEW", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsNew.AddColumn("청소", "CLEAN_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsNew.AddColumn("상태", "ROOM_STAT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsNew.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsNew.AddColumn("메인", "MAIN_YN", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true); gsNew.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true); RepositoryItemCheckEdit chkNewMainYn = (RepositoryItemCheckEdit)gridView_New.Columns["MAIN_YN"].ColumnEdit; chkNewMainYn.CheckedChanged += new EventHandler(chkNewMainYn_CheckedChanged); Cls.Grid.Options.SelectedRow(this.gridView_New); Cls.Grid.Options.EmbeddedNavigater(this.grid_New); Cls.Grid.Options.FilterRow(this.gridView_New, true); this.grid_New.DataSource = dt_New; ContextMenu popUpMenu; ContextMenu popUpMenu1; ContextMenu popUpMenu2; MenuItem checked_Tot; MenuItem uncheckedr_Tot; MenuItem checked_Assign; MenuItem unchecked_Assign; MenuItem checked_new; MenuItem unchecked_new; popUpMenu = new ContextMenu(); popUpMenu.MenuItems.Add("전체선택", new EventHandler(popup)); popUpMenu.MenuItems.Add("선택해제", new EventHandler(popup)); popUpMenu1 = new ContextMenu(); popUpMenu1.MenuItems.Add("전체선택", new EventHandler(popup)); popUpMenu1.MenuItems.Add("선택해제", new EventHandler(popup)); popUpMenu2 = new ContextMenu(); popUpMenu2.MenuItems.Add("전체선택", new EventHandler(popup)); popUpMenu2.MenuItems.Add("선택해제", new EventHandler(popup)); grid_Tot.ContextMenu = popUpMenu; grid_Assign.ContextMenu = popUpMenu1; grid_New.ContextMenu = popUpMenu2; checked_Tot = grid_Tot.ContextMenu.MenuItems[0]; uncheckedr_Tot = grid_Tot.ContextMenu.MenuItems[1]; checked_Assign = grid_Assign.ContextMenu.MenuItems[0]; unchecked_Assign = grid_Assign.ContextMenu.MenuItems[1]; checked_new = grid_New.ContextMenu.MenuItems[0]; unchecked_new = grid_New.ContextMenu.MenuItems[1]; checked_Tot.Name = "TOT"; uncheckedr_Tot.Name = "TOT"; checked_Assign.Name = "ASSIGN"; unchecked_Assign.Name = "ASSIGN"; checked_new.Name = "NEW"; unchecked_new.Name = "NEW"; } catch (Exception ex) { throw ex; } }
private void Columns_Load(object sender, EventArgs e) { try { Cls.DataLayer.mService.ServiceURI = "http://www.scosystem.co.kr:51004/WCF_SCOS_BIZ/DataService.svc"; Cls.DataLayer.mService.AuthPwd = "SCOS"; Cls.DataLayer.mService.AuthId = "PROJECT"; //DataTable dt = new DataTable(); ////dt.Columns.Add("DATE", typeof(System.DateTime)); //dt.Columns.Add("DATE" ); //Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1); //gs.AddColumn("DATE" , "DATE" , Cls.Grid._ColumnType.Dates , 100, Cls.Grid._ColumnAlign.Center, true); //this.gridControl1.DataSource = dt; //DataSet ds = Cls.DataLayer.DataLayer.ExecuteSpDataset("PKG_TEST.PR_01" , Cls.DataLayer.DataLayer.MessageEncoding.Default); //dt.Load(ds.Tables[0].CreateDataReader()); // int I = dt.Rows.Count; DataTable dt = new DataTable(); dt.Columns.Add("C1", typeof(decimal)); dt.Columns.Add("C2"); dt.Columns.Add("C3"); for (int i = 1; i <= 100; i++) { dt.Rows.Add(i, System.DateTime.Now, "Btn"); } this.gridControl1.DataSource = dt; Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1); gs.AddColumn("C1", "C1", Cls.Grid._ColumnType.Numbers, 80, Cls.Grid._ColumnAlign.Center, true, false, DevExpress.Utils.DefaultBoolean.True, DevExpress.XtraGrid.Columns.AutoFilterCondition.Contains); gs.AddColumn("C2", "C2", Cls.Grid._ColumnType.DateTime, 80, Cls.Grid._ColumnAlign.Center); gs.AddColumn("C3", "C3", Cls.Grid._ColumnType.Button, 80, Cls.Grid._ColumnAlign.Center, true, true); Cls.Grid.Options.FilterRow(this.gridView1, true); //StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition(); //condition1.Appearance.BackColor = Color.SeaShell; //condition1.Appearance.Options.UseBackColor = true; //condition1.Condition = FormatConditionEnum.Expression; //condition1.Expression = "[C1] > 1"; //gridView1.FormatConditions.Add(condition1); Cls.Grid.Options.SetColumnColor(this.gridView1, Cls.Grid.StyleFormatConditionType.Row, this.gridView1.Columns["C1"], DevExpress.XtraGrid.FormatConditionEnum.Expression, Color.Red, "[C1] > 1"); } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { try{ dtlupFacility.Columns.Add("FACILITY_CODE"); dtlupFacility.Columns.Add("FACILITY_NAME"); //dtlupFacility.AcceptChanges(); DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParm.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_COMM.PR_25", dtParm, DataLayer.MessageEncoding.Default); dtlupFacility.Load(ds.Tables[0].CreateDataReader()); ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// dtMaster.Columns.Add("FACILITY_CODE"); dtMaster.Columns.Add("MNG_NO"); dtMaster.Columns.Add("MNG_SEQ", typeof(decimal)); dtMaster.Columns.Add("FACI_PART"); dtMaster.Columns.Add("ROOM_NO"); dtMaster.Columns.Add("GUEST_NAME"); dtMaster.Columns.Add("ROOM_TYPE"); dtMaster.Columns.Add("MAIN_YN"); dtMaster.Columns.Add("MEMBER_NO"); dtMaster.Columns.Add("MEMBER_NAME"); dtMaster.Columns.Add("CHECKIN_DATE"); dtMaster.Columns.Add("NIGHTS", typeof(decimal)); dtMaster.Columns.Add("CHECKOUT_DATE"); dtMaster.Columns.Add("DEPOSIT"); dtMaster.Columns.Add("STND_AMT", typeof(decimal)); dtMaster.Columns.Add("DC_RATE", typeof(decimal)); dtMaster.Columns.Add("APP_AMT", typeof(decimal)); dtMaster.Columns.Add("SECRET_YN"); dtMaster.Columns.Add("MASTER_NO"); // Cls.Grid.GridStyle gsMaster = new Cls.Grid.GridStyle(this.grid_Master, gridView_Master); gsMaster.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("메인객실", "MAIN_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("회원명", "MEMBER_NAME", _ColumnType.Default, 60, _ColumnAlign.Center, true); gsMaster.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 40, _ColumnAlign.Right, true); gsMaster.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsMaster.AddColumn("선수금", "DEPOSIT", _ColumnType.Default, 60, _ColumnAlign.Center, true); gsMaster.AddColumn("기준요금", "STND_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsMaster.AddColumn("할인율", "DC_RATE", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gsMaster.AddColumn("객실요금", "APP_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsMaster.AddColumn("사생활보호", "SECRET_YN", _ColumnType.Default, 90, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridView_Master); Cls.Grid.Options.EmbeddedNavigater(this.grid_Master); Cls.Grid.Options.FilterRow(this.gridView_Master, true); this.grid_Master.DataSource = dtMaster; ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// dtCondition.Columns.Add("FACILITY_CODE"); dtCondition.Columns.Add("FACILITY_NAME"); dtCondition.Columns.Add("MNG_NO"); dtCondition.Columns.Add("MNG_SEQ", typeof(decimal)); dtCondition.Columns.Add("FACI_PART"); dtCondition.Columns.Add("ROOM_NO"); dtCondition.Columns.Add("ROOM_TYPE"); dtCondition.Columns.Add("ROOM_VIEW"); dtCondition.Columns.Add("GUEST_NAME"); dtCondition.Columns.Add("CHECKIN_DATE"); dtCondition.Columns.Add("NIGHTS", typeof(decimal)); dtCondition.Columns.Add("CHECKOUT_DATE"); dtCondition.Columns.Add("MAIN_ROOM"); dtCondition.Columns.Add("MASTER_NO"); dtCondition.Columns.Add("POS"); dtCondition.Columns.Add("CHK"); dtCondition.PrimaryKey = new DataColumn[] { dtCondition.Columns["FACILITY_CODE"], dtCondition.Columns["MNG_NO"], dtCondition.Columns["MNG_SEQ"] }; dtConditionAll = dtCondition.Clone(); Cls.Grid.GridStyle gsCondition = new Cls.Grid.GridStyle(this.grid_Condition, gridView_Condition); gsCondition.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsCondition.AddColumn("유형", "ROOM_TYPE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsCondition.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsCondition.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsCondition.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 40, _ColumnAlign.Right, true); gsCondition.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsCondition.AddColumn("G.M/Main", "MAIN_ROOM", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsCondition.AddColumn("확인", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true); Cls.Grid.Options.SelectedRow(this.gridView_Condition); Cls.Grid.Options.EmbeddedNavigater(this.grid_Condition); Cls.Grid.Options.FilterRow(this.gridView_Condition, true); this.grid_Condition.DataSource = dtCondition; ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// dtDetail.Columns.Add("FACILITY_CODE"); dtDetail.Columns.Add("FACILITY_NAME"); dtDetail.Columns.Add("MNG_NO"); dtDetail.Columns.Add("MNG_SEQ", typeof(decimal)); dtDetail.Columns.Add("FACI_PART"); dtDetail.Columns.Add("ROOM_NO"); dtDetail.Columns.Add("ROOM_TYPE"); dtDetail.Columns.Add("ROOM_VIEW"); dtDetail.Columns.Add("GUEST_NAME"); dtDetail.Columns.Add("CHECKIN_DATE"); dtDetail.Columns.Add("NIGHTS", typeof(decimal)); dtDetail.Columns.Add("CHECKOUT_DATE"); dtDetail.Columns.Add("MAIN_ROOM"); dtDetail.Columns.Add("MASTER_NO"); dtDetail.Columns.Add("POS"); dtDetail.Columns.Add("CHK"); dtDetail.PrimaryKey = new DataColumn[] { dtDetail.Columns["FACILITY_CODE"], dtDetail.Columns["MNG_NO"], dtDetail.Columns["MNG_SEQ"] }; Cls.Grid.GridStyle gsdtDetail = new Cls.Grid.GridStyle(this.grid_Detail, gridView_Detail); gsdtDetail.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsdtDetail.AddColumn("유형", "ROOM_TYPE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsdtDetail.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsdtDetail.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsdtDetail.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 40, _ColumnAlign.Right, true); gsdtDetail.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsdtDetail.AddColumn("G.M/Main", "MAIN_ROOM", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsdtDetail.AddColumn("확인", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true); Cls.Grid.Options.SelectedRow(this.gridView_Detail); Cls.Grid.Options.EmbeddedNavigater(this.grid_Detail); Cls.Grid.Options.FilterRow(this.gridView_Detail, true); this.grid_Detail.DataSource = dtDetail; ContextMenu popUpMenu; ContextMenu popUpMenu1; MenuItem chkAll_Condition; MenuItem checkClear_Condition; MenuItem chkAll_Detail; MenuItem checkClear_Detail; popUpMenu = new ContextMenu(); popUpMenu.MenuItems.Add("전체선택", new EventHandler(popup)); popUpMenu.MenuItems.Add("선택해제", new EventHandler(popup)); popUpMenu1 = new ContextMenu(); popUpMenu1.MenuItems.Add("전체선택", new EventHandler(popup)); popUpMenu1.MenuItems.Add("선택해제", new EventHandler(popup)); grid_Condition.ContextMenu = popUpMenu; grid_Detail.ContextMenu = popUpMenu1; chkAll_Condition = grid_Condition.ContextMenu.MenuItems[0]; checkClear_Condition = grid_Condition.ContextMenu.MenuItems[1]; chkAll_Detail = grid_Detail.ContextMenu.MenuItems[0]; checkClear_Detail = grid_Detail.ContextMenu.MenuItems[1]; chkAll_Condition.Name = "Condition"; checkClear_Condition.Name = "Condition"; chkAll_Detail.Name = "Detail"; checkClear_Detail.Name = "Detail"; LookUp.SetFillCode(lupFacility, dtlupFacility, "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None); this.lupFacility.ItemIndex = 0; } catch (Exception ex) { throw ex; } }
/// <summary> /// 데이터 테이블을 정의합니다. /// </summary> private void SetDataTable() { try { dtMaster.Columns.Add("BIZ_CODE"); dtMaster.Columns.Add("REG_DATE"); dtMaster.Columns.Add("REG_SEQ", typeof(decimal)); dtMaster.Columns.Add("CARD_CO_CODE"); dtMaster.Columns.Add("CARD_CO_CODE_NAME"); dtMaster.Columns.Add("FILE_MAKE_DATE"); dtMaster.Columns.Add("CHARGE_DATE"); dtMaster.Columns.Add("CARD_REG_DATE"); dtMaster.Columns.Add("TOT_CNT", typeof(decimal)); dtMaster.Columns.Add("TOT_AMT", typeof(decimal)); dtMaster.Columns.Add("RETURN_CNT", typeof(decimal)); dtMaster.Columns.Add("RETURN_AMT", typeof(decimal)); dtMaster.Columns.Add("WAIT_CNT", typeof(decimal)); dtMaster.Columns.Add("WAIT_AMT", typeof(decimal)); dtMaster.Columns.Add("WIAT_COMPLATE_CNT", typeof(decimal)); dtMaster.Columns.Add("WAIT_COMPLATE_AMT", typeof(decimal)); dtMaster.Columns.Add("SUM_TOT_CNT", typeof(decimal)); dtMaster.Columns.Add("SUM_TOT_AMT", typeof(decimal)); dtMaster.Columns.Add("CHARGE_AMT", typeof(decimal)); dtMaster.Columns.Add("IN_AMOUNT", typeof(decimal)); dtMaster.Columns.Add("ACCOUNT_NUMBER"); dtMaster.Columns.Add("MEMO"); dtMaster.Columns.Add("U_EMP_NO"); dtMaster.Columns.Add("U_DATE"); dtMaster.Columns.Add("U_IP"); dtMaster.Columns.Add("CONTRACT_NUMBER"); dtMaster.Columns.Add("VAN_NAME"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridMaster, this.gridViewMaster); gs.AddColumn("청구일자", "REG_DATE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("VAN", "VAN_NAME", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("가맹점번호", "CONTRACT_NUMBER", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("매입사명", "CARD_CO_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("코드", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("지급예정일", "CHARGE_DATE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("청구건수", "TOT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("청구접수금액", "TOT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("반송건수", "RETURN_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("반송접수금액", "RETURN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("보류건수", "WAIT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("보류접수금액", "WAIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("보류해제건수", "WIAT_COMPLATE_CNT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("보류해제금액", "WAIT_COMPLATE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true); gs.AddColumn("합계건수", "SUM_TOT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("합계접수금액", "SUM_TOT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); //합계건수 = 접수건수 - 반송건수 - 보류건수 + 보류해제건수 //합계금액 = 접수금액 - 반송금액 - 보류금액 + 보류해제금액 gs.AddColumn("수수료합계", "CHARGE_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("입금액 ", "IN_AMOUNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); //입금액 = 합계금액 - 수수료합계 gs.AddColumn("결제계좌번호", "ACCOUNT_NUMBER", _ColumnType.Default, 100, _ColumnAlign.Center, true); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "TOT_CNT", "TOT_CNT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "TOT_AMT", "TOT_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "RETURN_CNT", "RETURN_CNT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "RETURN_AMT", "RETURN_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "WAIT_CNT", "WAIT_CNT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "WAIT_AMT", "WAIT_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "WIAT_COMPLATE_CNT", "WIAT_COMPLATE_CNT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "WAIT_COMPLATE_AMT", "WAIT_COMPLATE_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "SUM_TOT_CNT", "SUM_TOT_CNT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "SUM_TOT_AMT", "SUM_TOT_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "CHARGE_AMT", "CHARGE_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(this.gridViewMaster, DevExpress.Data.SummaryItemType.Sum, "IN_AMOUNT", "IN_AMOUNT", SummaryFormat.Sum); Cls.Grid.Options.FixedColumn(this.gridViewMaster, new string[] { "IN_AMOUNT", "CHARGE_AMT", "SUM_TOT_AMT" }, PositionStyle.Right); //Cls.Grid.Options.SelectedRow(this.gridViewData); Cls.Grid.Options.EmbeddedNavigater(this.gridMaster); //Cls.Grid.Options.FilterRow(this.gridViewMaster, true); this.gridViewMaster.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewMaster.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewMaster.OptionsSelection.EnableAppearanceHideSelection = true; Cls.Grid.Options.SetColumnColor(this.gridViewMaster, StyleFormatConditionType.Column, gridViewMaster.Columns["IN_AMOUNT"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.LightBlue, null); Cls.Grid.Options.SetColumnColor(this.gridViewMaster, StyleFormatConditionType.Column, gridViewMaster.Columns["CHARGE_AMT"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.Pink, null); Cls.Grid.Options.SetColumnColor(this.gridViewMaster, StyleFormatConditionType.Column, gridViewMaster.Columns["SUM_TOT_AMT"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.Pink, null); Cls.Grid.Options.SetColumnColor(this.gridViewMaster, StyleFormatConditionType.Column, gridViewMaster.Columns["CHARGE_DATE"], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.Pink, null); dtDetail.Columns.Add("BIZ_CODE"); dtDetail.Columns.Add("REG_DATE"); dtDetail.Columns.Add("REG_SEQ", typeof(decimal)); dtDetail.Columns.Add("CARD_CO_CODE"); dtDetail.Columns.Add("CARD_CO_CODE_NAME"); dtDetail.Columns.Add("SALE_DATE"); dtDetail.Columns.Add("FACILITY_CODE"); dtDetail.Columns.Add("FACILITY_NAME"); dtDetail.Columns.Add("POS_NO"); dtDetail.Columns.Add("BILL_NO"); dtDetail.Columns.Add("SALE_YN"); dtDetail.Columns.Add("PAY_SEQ", typeof(decimal)); dtDetail.Columns.Add("EDI_SALE_DATE"); dtDetail.Columns.Add("EDI_REG_DATE"); dtDetail.Columns.Add("EDI_CARD_NO"); dtDetail.Columns.Add("EDI_INSTALLMENT_CNT", typeof(decimal)); dtDetail.Columns.Add("EDI_SALE_AMT", typeof(decimal)); dtDetail.Columns.Add("EDI_POS_NO"); dtDetail.Columns.Add("CARD_RETURN_CODE"); dtDetail.Columns.Add("CARD_RETURN_CODE_NAME"); dtDetail.Columns.Add("VAN_RETURN_CODE"); dtDetail.Columns.Add("ID_NO"); dtDetail.Columns.Add("NAME_KOR"); dtDetail.Columns.Add("NAME_ENG"); dtDetail.Columns.Add("CUST_INFO"); dtDetail.Columns.Add("MEMO"); dtDetail.Columns.Add("U_EMP_NO"); dtDetail.Columns.Add("U_DATE"); dtDetail.Columns.Add("U_IP"); dtDetail.Columns.Add("CONTRACT_NUMBER"); dtDetail.Columns.Add("VAN_NAME"); Cls.Grid.GridStyle gs1 = new Cls.Grid.GridStyle(this.gridDetail, this.gridViewDetail); gs1.AddColumn("매출일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("VAN", "VAN_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("가맹점번호", "CONTRACT_NUMBER", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("업장이름", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("POS", "POS_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs1.AddColumn("BILL", "BILL_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs1.AddColumn("판매구분", "SALE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs1.AddColumn("순번", "PAY_SEQ", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs1.AddColumn("매입사코드", "CARD_CO_CODE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs1.AddColumn("매입사명", "CARD_CO_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("카드번호", "EDI_CARD_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true, true); gs1.AddColumn("할부", "EDI_INSTALLMENT_CNT", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs1.AddColumn("금액", "EDI_SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Center, true); gs1.AddColumn("리턴코드", "CARD_RETURN_CODE", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs1.AddColumn("리턴코드명", "CARD_RETURN_CODE_NAME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs1.AddColumn("매입구분", "MEMO", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridViewDetail); Cls.Grid.Options.EmbeddedNavigater(this.gridDetail); Cls.Grid.Options.FilterRow(this.gridViewDetail, true); Cls.Grid.Options.Footer(this.gridViewDetail, DevExpress.Data.SummaryItemType.Sum, "EDI_SALE_AMT", "EDI_SALE_AMT", SummaryFormat.Sum); this.gridViewDetail.OptionsSelection.EnableAppearanceFocusedCell = true; dtMaster_Grid = dtMaster.Clone(); dtDetail_Grid = dtDetail.Clone(); this.gridMaster.DataSource = dtMaster_Grid; this.gridDetail.DataSource = dtDetail_Grid; StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition(); condition1.Column = gridViewDetail.Columns["목록"]; condition1.ApplyToRow = true; condition1.Appearance.BackColor = Color.Pink; condition1.Appearance.Options.UseBackColor = true; condition1.Condition = FormatConditionEnum.Expression; condition1.Expression = "목록 Like '%재청구%'"; gridViewDetail.FormatConditions.Add(condition1); } catch (Exception ex) { throw ex; } }
/// <summary> /// 데이터 테이블을 정의합니다. /// </summary> private void SetDataTable() { try { dt.Columns.Add("CHK"); dt.Columns.Add("SALE_DATE"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); dt.Columns.Add("SALE_YN"); dt.Columns.Add("PAY_SEQ", typeof(decimal)); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("VALID_THRU_NAME"); dt.Columns.Add("VALID_THRU"); dt.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dt.Columns.Add("AGREE_YN"); dt.Columns.Add("AGREE_NO"); dt.Columns.Add("ORG_AGREE_NO"); dt.Columns.Add("AGREE_TIME"); dt.Columns.Add("EASY_YN"); dt.Columns.Add("CARD_CO_CODE"); dt.Columns.Add("CARD_CO_NAME"); dt.Columns.Add("ISSU_CO_CODE"); dt.Columns.Add("ISSU_CO_NAME"); dt.Columns.Add("CARD_JOIN_NO"); dt.Columns.Add("KEYIN_YN"); dt.Columns.Add("VAN_ID"); dt.Columns.Add("COMPANY_ID"); dt.Columns.Add("TRACK_TWO"); dt.Columns.Add("KIND"); dt.Columns.Add("SALE_AMT_ABS"); Cls.Grid.GridStyle gs = new Cls.Grid.GridStyle(this.gridData, this.gridViewData); gs.AddColumn("제외건선택", "CHK", _ColumnType.CheckBox, 90, _ColumnAlign.Center, true, true, DevExpress.Utils.DefaultBoolean.False); gs.AddColumn("가맹번호", "VAN_ID", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("코드", "FACILITY_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("이지체크", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("유효기간", "VALID_THRU", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("승인일시", "AGREE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("포스", "POS_NO", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("판매", "SALE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Numbers, 40, _ColumnAlign.Right, true, false); gs.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true, false); gs.AddColumn("승인", "AGREE_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true, false); gs.AddColumn("키인", "KEYIN_YN", _ColumnType.Default, 40, _ColumnAlign.Center, true, false); gs.AddColumn("데이터구분", "KIND", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("유효기간", "VALID_THRU_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("가맹번호", "CARD_JOIN_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("매입사사업자번호", "COMPANY_ID", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("트랙2정보", "TRACK_TWO", _ColumnType.Default, 80, _ColumnAlign.Center, false); this.gridViewData.OptionsView.ShowGroupPanel = true; //Cls.Grid.Options.SelectedRow(this.gridViewData); Cls.Grid.Options.EmbeddedNavigater(this.gridData); Cls.Grid.Options.FilterRow(this.gridViewData, true); Cls.Grid.Options.Footer(this.gridViewData, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.gridData.DataSource = dt; this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewData.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewData.OptionsSelection.EnableAppearanceHideSelection = true; DataRow[] r = Parm.mDataTable.dtZx010ms.Select("HEAD = 'Z0021' AND DETAIL <> ' ' AND USE_YN = 'Y' ", "USE_SORT"); rr = r; string exp = ""; dtSumery.Columns.Add("목록"); Cls.Grid.GridStyle gs1 = new Cls.Grid.GridStyle(this.gridSummery, this.gridViewSummery); gs1.AddColumn("목록", "목록", _ColumnType.Default, 130, _ColumnAlign.Center, true); for (int j = 0; j < rr.Length; j++) { string str = rr[j]["DETAIL_NAME"].ToString().Replace("(", "_").Replace(")", ""); dtSumery.Columns.Add(str, typeof(decimal)); exp += j == 0 ? str : " + " + str; gs1.AddColumn(str, str, _ColumnType.Numbers, 80, _ColumnAlign.Right, true); Cls.Grid.Options.Footer(this.gridViewSummery, DevExpress.Data.SummaryItemType.Sum, str, str, SummaryFormat.Sum); } gs1.AddColumn("합계", "TOT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); dtSumery.Columns.Add("TOT", typeof(decimal), exp); Cls.Grid.Options.Footer(this.gridViewSummery, DevExpress.Data.SummaryItemType.Sum, "TOT", "TOT", SummaryFormat.Sum); this.gridViewSummery.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridViewSummery.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridViewSummery.OptionsSelection.EnableAppearanceHideSelection = true; this.gridSummery.DataSource = dtSumery; Cls.Grid.Options.SetColumnColor(gridViewData, Cls.Grid.StyleFormatConditionType.Row, gridViewData.Columns["KIND"], FormatConditionEnum.Equal, Color.Pink, "재청구"); StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition(); condition1.Column = gridViewSummery.Columns["목록"]; condition1.ApplyToRow = true; condition1.Appearance.BackColor = Color.Pink; condition1.Appearance.Options.UseBackColor = true; condition1.Condition = FormatConditionEnum.Expression; condition1.Expression = "목록 Like '%재청구%'"; gridViewSummery.FormatConditions.Add(condition1); StyleFormatCondition condition2 = new DevExpress.XtraGrid.StyleFormatCondition(); condition2.Column = gridViewData.Columns["AGREE_DATE"]; condition2.ApplyToRow = true; condition2.Appearance.BackColor = Color.Red; condition2.Appearance.Options.UseBackColor = true; condition2.Condition = FormatConditionEnum.Expression; condition2.Expression = "LEN(ISNULL(AGREE_DATE,'')) <> 10 "; //OR SUBSTRING(VALID_THRU, 3, 2) > 12 gridViewData.FormatConditions.Add(condition2); //StyleFormatCondition condition3 = new DevExpress.XtraGrid.StyleFormatCondition(); //condition3.Column = gridViewData.Columns["VALID_THRU"]; //condition3.ApplyToRow = true; //condition3.Appearance.BackColor = Color.Red; //condition3.Appearance.Options.UseBackColor = true; //condition3.Condition = FormatConditionEnum.Expression; //condition3.Expression = "SUBSTRING(VALID_THRU, 3, 2) > 12 "; //OR //gridViewData.FormatConditions.Add(condition3); //this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = true; StyleFormatCondition condition4 = new DevExpress.XtraGrid.StyleFormatCondition(); condition4.Column = gridViewData.Columns["VAN_ID"]; condition4.ApplyToRow = true; condition4.Appearance.BackColor = Color.Red; condition4.Appearance.Options.UseBackColor = true; condition4.Condition = FormatConditionEnum.Expression; condition4.Expression = "ISNULL(VAN_ID,'')='' "; //OR gridViewData.FormatConditions.Add(condition4); this.gridViewData.OptionsSelection.EnableAppearanceFocusedCell = true; ContextMenu popUpMenus; MenuItem chkAlls; MenuItem checkClears; MenuItem checConvert; popUpMenus = new ContextMenu(); popUpMenus.MenuItems.Add("전체선택", new EventHandler(popup_Res)); popUpMenus.MenuItems.Add("전체해제", new EventHandler(popup_Res)); popUpMenus.MenuItems.Add("선택반전", new EventHandler(popup_Res)); this.gridData.ContextMenu = popUpMenus; chkAlls = gridData.ContextMenu.MenuItems[0]; checkClears = gridData.ContextMenu.MenuItems[1]; checConvert = gridData.ContextMenu.MenuItems[2]; } catch (Exception ex) { throw ex; } }
private void JIAAI12_Load(object sender, EventArgs e) { try { Cls.Grid.GridStyle st = new Cls.Grid.GridStyle(this.gridControl1, this.gridView1); st.AddColumn("청구구분", "TID", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("판매여부", "SALE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("입금순번", "PAY_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st.AddColumn("승인여부", "AGREE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("판매총계", "SALE_AMT", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("매입사명", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); st.AddColumn("키인여부", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.GridStyle st1 = new Cls.Grid.GridStyle(this.gridControl2, this.gridView2); st1.AddColumn("청구구분", "TID", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("청구일자", "REG_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("청구순번", "REG_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st1.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("판매여부", "SALE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("입금순번", "PAY_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st1.AddColumn("판매총계", "SALE_AMT", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("유효기간", "VALID_THRU", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st1.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("매입사명", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); st1.AddColumn("키인여부", "EASY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.GridStyle st2 = new Cls.Grid.GridStyle(this.gridControl3, this.gridView3); st2.AddColumn("파일", "FILE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("청구구분", "MEMO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("청구일자", "REG_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("청구순번", "REG_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st2.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("판매여부", "SALE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("입금순번", "PAY_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st2.AddColumn("매출일자", "EDI_SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("접수일자", "EDI_REG_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("카드번호", "EDI_CARD_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("할부기간", "EDI_INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st2.AddColumn("판매금액", "EDI_SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); st2.AddColumn("반송-카드사별", "EDI_POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("반송-KICC", "CARD_RETURN_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("승인번호", "CUST_INFO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("수정자", "U_EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); st2.AddColumn("수정일시", "U_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.Options.EmbeddedNavigater(this.gridControl1); Cls.Grid.Options.FilterRow(this.gridView1, true); Cls.Grid.Options.EmbeddedNavigater(this.gridControl2); Cls.Grid.Options.FilterRow(this.gridView2, true); Cls.Grid.Options.EmbeddedNavigater(this.gridControl3); Cls.Grid.Options.FilterRow(this.gridView3, true); this.gridControl1.DataSource = dt1; this.gridControl2.DataSource = dt2; this.gridControl3.DataSource = dt3; } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }