/// <summary> /// Initialize a new instance of the DataGridViewStyles class. /// </summary> /// <param name="dataGridView">Reference to owning control.</param> public DataGridViewStyles(KryptonDataGridView dataGridView) { Debug.Assert(dataGridView != null); _dataGridView = dataGridView; _gridStyle = DataGridViewStyle.List; _columnStyle = GridStyle.List; _rowStyle = GridStyle.List; _dataCellStyle = GridStyle.List; _backgroundStyle = PaletteBackStyle.GridBackgroundList; }
/// <summary> /// Initialize a new instance of the KryptonPaletteGrid class. /// </summary> /// <param name="redirect">Redirector to inherit values from.</param> /// <param name="gridStyle">Grid style.</param> /// <param name="needPaint">Delegate for notifying paint requests.</param> public KryptonPaletteGrid(PaletteRedirect redirect, GridStyle gridStyle, NeedPaintHandler needPaint) { // Create the storage objects _stateCommon = new PaletteDataGridViewRedirect(redirect, needPaint); _stateDisabled = new PaletteDataGridViewAll(_stateCommon, needPaint); _stateNormal = new PaletteDataGridViewAll(_stateCommon, needPaint); _stateTracking = new PaletteDataGridViewHeaders(_stateCommon, needPaint); _statePressed = new PaletteDataGridViewHeaders(_stateCommon, needPaint); _stateSelected = new PaletteDataGridViewCells(_stateCommon, needPaint); }
/// <summary> /// Populate values from the base palette. /// </summary> /// <param name="state">The palette state to populate with.</param> /// <param name="common">Reference to common settings.</param> /// <param name="gridStyle">Grid style to use for populating.</param> public virtual void PopulateFromBase(KryptonPaletteCommon common, PaletteState state, GridStyle gridStyle) { if (gridStyle == GridStyle.List) { common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderColumnList, PaletteBorderStyle.GridHeaderColumnList, PaletteContentStyle.GridHeaderColumnList); } else { common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderColumnSheet, PaletteBorderStyle.GridHeaderColumnSheet, PaletteContentStyle.GridHeaderColumnSheet); } _headerColumn.PopulateFromBase(state); if (gridStyle == GridStyle.List) { common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderRowList, PaletteBorderStyle.GridHeaderRowList, PaletteContentStyle.GridHeaderRowList); } else { common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderRowSheet, PaletteBorderStyle.GridHeaderRowSheet, PaletteContentStyle.GridHeaderRowSheet); } _headerRow.PopulateFromBase(state); }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("CH_CODE"); dt.Columns.Add("CH_CODE_NAME"); dt.Columns.Add("GUBUN"); dt.Columns.Add("CH_NO"); dt.Columns.Add("CH_NAME"); dt.Columns.Add("SEND_CNT", typeof(decimal)); dt.Columns.Add("CUST_NO"); dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("SMS_NO"); dt.Columns.Add("SEND_DATE"); dt.Columns.Add("SMS_RSLTDATE"); dt.Columns.Add("SEND_RMRK"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("채널구분", "CH_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("채널구분", "CH_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("상태", "GUBUN", _ColumnType.Default, 50, _ColumnAlign.Center, true); gs.AddColumn("채널번호", "CH_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("채널명", "CH_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회차", "SEND_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gs.AddColumn("고객번호", "CUST_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 60, _ColumnAlign.Center, true); gs.AddColumn("SMS번호", "SMS_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("SMS예약일시/출력일시", "SEND_DATE", _ColumnType.Default, 180, _ColumnAlign.Center, true); gs.AddColumn("SMS전송일시", "SMS_RSLTDATE", _ColumnType.Default, 180, _ColumnAlign.Center, true); gs.AddColumn("문자메세지", "SEND_RMRK", _ColumnType.Default, 340, _ColumnAlign.Left, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); //Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("GUEST_TYPE"); dt.Columns.Add("GUEST_TYPE_NAME"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("MENU_ITEM1"); dt.Columns.Add("MENU_ITEM1_NAME"); dt.Columns.Add("MENU_ITEM2"); dt.Columns.Add("MENU_ITEM2_NAME"); dt.Columns.Add("DC_RATE", typeof(decimal)); dt.Columns.Add("ONCE_QTY", typeof(decimal)); dt.Columns.Add("DAY_QTY", typeof(decimal)); dt.Columns.Add("YEAR_QTY", typeof(decimal)); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("우대구분", "GUEST_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("시즌구분", "MENU_ITEM1", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("시즌구분", "MENU_ITEM1_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("휴일구분", "MENU_ITEM2", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("휴일구분", "MENU_ITEM2_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("할인율", "DC_RATE", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("일회 사용횟수", "ONCE_QTY", _ColumnType.Numbers, 140, _ColumnAlign.Right, true); gs.AddColumn("일사용횟수", "DAY_QTY", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("년사용횟수", "YEAR_QTY", _ColumnType.Numbers, 100, _ColumnAlign.Right, 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("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("CALL_TYPE"); dt.Columns.Add("CALL_TYPE_NAME"); dt.Columns.Add("CNT", typeof(decimal)); dt.Columns.Add("AMOUNT", typeof(decimal)); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("CALL TYPE", "CALL_TYPE", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("CALL TYPE 명", "CALL_TYPE_NAME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("발생건수", "CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("발생금액", "AMOUNT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMOUNT", "AMOUNT", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("AMT_DATE"); dt.Columns.Add("DETAIL_NAME"); dt.Columns.Add("RSV_AMT", typeof(decimal)); dt.Columns.Add("AMT_NAME"); dt.Columns.Add("RSV_NO"); dt.Columns.Add("FRONT_USE_YN"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("입금일자", "AMT_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("입금방법", "DETAIL_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("예약금", "RSV_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("입금자명", "AMT_NAME", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("사용여부", "FRONT_USE_YN", _ColumnType.Default, 70, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { 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("SALE_AMT", typeof(decimal)); dt.Columns.Add("CARD_NO"); dt.Columns.Add("AGREE_DATE"); dt.Columns.Add("VALID_THRU"); dt.Columns.Add("INSTALLMENT_CNT", typeof(decimal)); dt.Columns.Add("AGREE_NO"); 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("CARD_JOIN_NO"); dt.Columns.Add("TID"); //그리드 스타일을 구성합니다. GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.DateTime, 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("POS", "POS_NO", _ColumnType.Default, 60, _ColumnAlign.Center, true); gs.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("판매여부", "SALE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("입금순번", "PAY_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("판매총계", "SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("카드번호", "CARD_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true, true); gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.TextEdit, 80, _ColumnAlign.Center, true); gs.AddColumn("유효기간", "VALID_THRU", _ColumnType.TextEdit, 80, _ColumnAlign.Center, true); gs.AddColumn("할부기간", "INSTALLMENT_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("원승인번호", "ORG_AGREE_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true, true); gs.AddColumn("매입사", "CARD_CO_CODE", _ColumnType.LookUp, 80, _ColumnAlign.Center, true); gs.AddColumn("매입사명", "CARD_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("발급사", "ISSU_CO_CODE", _ColumnType.LookUp, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사명", "ISSU_CO_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("가맹번호", "CARD_JOIN_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("EDI", "TID", _ColumnType.Default, 80, _ColumnAlign.Center); RepositoryItemTextEdit date = (RepositoryItemTextEdit)gridView.Columns["AGREE_DATE"].ColumnEdit; date.Mask.EditMask = Parm.mMask.DATE; date.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; RepositoryItemTextEdit validthru = (RepositoryItemTextEdit)gridView.Columns["VALID_THRU"].ColumnEdit; validthru.Mask.EditMask = "\\d\\d-\\d\\d"; validthru.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; //매입사 RepositoryItemLookUpEdit LookupCard = (RepositoryItemLookUpEdit)gridView.Columns["CARD_CO_CODE"].ColumnEdit; BizCommon.BasicCode.FillBasicCode(LookupCard, "Z0021", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); LookupCard.EditValueChanged += new EventHandler(LookupCard_EditValueChanged); //발급사(공급사) RepositoryItemLookUpEdit LookupIssu = (RepositoryItemLookUpEdit)gridView.Columns["ISSU_CO_CODE"].ColumnEdit; BizCommon.BasicCode.FillBasicCode(LookupIssu, "Z0022", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); LookupIssu.EditValueChanged += new EventHandler(LookupIssu_EditValueChanged); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.grid.DataSource = dt; //수정가능 컬럼 색상지정 //gridView.Columns["SALE_AMT"].OptionsColumn.AllowEdit = true; //gridView.Columns["SALE_AMT"].OptionsColumn.ReadOnly = false; //gridView.Columns["SALE_AMT"].AppearanceHeader.ForeColor = Color.DarkOrange; //gridView.Columns["SALE_AMT"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["CARD_NO"].OptionsColumn.AllowEdit = true; gridView.Columns["CARD_NO"].OptionsColumn.ReadOnly = false; gridView.Columns["CARD_NO"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["CARD_NO"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["AGREE_DATE"].OptionsColumn.AllowEdit = true; gridView.Columns["AGREE_DATE"].OptionsColumn.ReadOnly = false; gridView.Columns["AGREE_DATE"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["AGREE_DATE"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["VALID_THRU"].OptionsColumn.AllowEdit = true; gridView.Columns["VALID_THRU"].OptionsColumn.ReadOnly = false; gridView.Columns["VALID_THRU"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["VALID_THRU"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["INSTALLMENT_CNT"].OptionsColumn.AllowEdit = true; gridView.Columns["INSTALLMENT_CNT"].OptionsColumn.ReadOnly = false; gridView.Columns["INSTALLMENT_CNT"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["INSTALLMENT_CNT"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["AGREE_NO"].OptionsColumn.AllowEdit = true; gridView.Columns["AGREE_NO"].OptionsColumn.ReadOnly = false; gridView.Columns["AGREE_NO"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["AGREE_NO"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["ORG_AGREE_NO"].OptionsColumn.AllowEdit = true; gridView.Columns["ORG_AGREE_NO"].OptionsColumn.ReadOnly = false; gridView.Columns["ORG_AGREE_NO"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["ORG_AGREE_NO"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["CARD_CO_CODE"].OptionsColumn.AllowEdit = true; gridView.Columns["CARD_CO_CODE"].OptionsColumn.ReadOnly = false; gridView.Columns["CARD_CO_CODE"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["CARD_CO_CODE"].AppearanceHeader.Options.UseForeColor = true; gridView.Columns["ISSU_CO_CODE"].OptionsColumn.AllowEdit = true; gridView.Columns["ISSU_CO_CODE"].OptionsColumn.ReadOnly = false; gridView.Columns["ISSU_CO_CODE"].AppearanceHeader.ForeColor = Color.DarkOrange; gridView.Columns["ISSU_CO_CODE"].AppearanceHeader.Options.UseForeColor = true; StyleFormatCondition condition = new DevExpress.XtraGrid.StyleFormatCondition(); condition.Column = this.gridView.Columns["TID"]; condition.ApplyToRow = true; condition.Appearance.Options.UseBackColor = true; condition.Appearance.BackColor = Color.Pink; condition.Condition = FormatConditionEnum.Expression; //condition.Expression = "SUBSTRING(VALID_THRU, 3, 2) > 12"; condition.Expression = "TID = '승인요청'"; gridView.FormatConditions.Add(condition); StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition(); condition1.Column = this.gridView.Columns["AGREE_DATE"]; condition1.ApplyToRow = false; condition1.Appearance.Options.UseBackColor = true; condition1.Appearance.BackColor = Color.Red; condition1.Condition = FormatConditionEnum.Expression; condition1.Expression = "LEN(ISNULL(AGREE_DATE,'')) <> 10"; gridView.FormatConditions.Add(condition1); }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("ID_NO"); dt.Columns.Add("IDNO_MASK"); dt.Columns.Add("COMMODITY_CODE"); dt.Columns.Add("COMMODITY_CODE_NAME"); dt.Columns.Add("MEMBER_CNT"); dt.Columns.Add("CAP_MEMBER_YN"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 120, _ColumnAlign.Left, true); gs.AddColumn("주민/사업", "ID_NO", _ColumnType.Default, 100, _ColumnAlign.Center, false); gs.AddColumn("주민/사업", "IDNO_MASK", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("회원타입", "COMMODITY_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, false); gs.AddColumn("회원타입", "COMMODITY_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("대상구좌", "MEMBER_CNT", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("관리여부", "CAP_MEMBER_YN", _ColumnType.Default, 70, _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; dtDetail.Columns.Add("CHECK_YN"); dtDetail.Columns.Add("CAP_MEMBER_NO"); dtDetail.Columns.Add("MEMBER_SEQ"); dtDetail.Columns.Add("MEMBER_NO"); dtDetail.Columns.Add("MEMBER_NAME_KOR"); dtDetail.Columns.Add("ID_NO"); dtDetail.Columns.Add("IDNO_MASK"); dtDetail.Columns.Add("SALEINLOT_CNT"); dtDetail.Columns.Add("SALEINLOT_CODE_NAME"); dtDetail.Columns.Add("COMMODITY_CODE"); dtDetail.Columns.Add("COMMODITY_CODE_NAME"); GridStyle dgs = new GridStyle(this.gridDetail, this.DetailgridView); dgs.AddColumn("대표선택", "CHECK_YN", _ColumnType.CheckBox, 70, _ColumnAlign.Center, true, true); dgs.AddColumn("대표번호", "CAP_MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); dgs.AddColumn("회원번호", "MEMBER_SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, false); dgs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); dgs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 100, _ColumnAlign.Left, true); dgs.AddColumn("주민/사업", "ID_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); dgs.AddColumn("주민/사업", "IDNO_MASK", _ColumnType.Default, 100, _ColumnAlign.Center, true); dgs.AddColumn("분양차수", "SALEINLOT_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, false); dgs.AddColumn("분양차수", "SALEINLOT_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); dgs.AddColumn("회원타입", "COMMODITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); dgs.AddColumn("회원타입", "COMMODITY_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.DetailgridView); Cls.Grid.Options.EmbeddedNavigater(this.gridDetail); Cls.Grid.Options.FilterRow(this.DetailgridView, true); this.gridDetail.DataSource = dtDetail; GridStyle gsExc = new GridStyle(this.gcEXCLUSIVE, this.gvEXCLUSIVE); gsExc.AddColumn("사업자", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gsExc.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("회원순번", "MEMBER_SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, false); gsExc.AddColumn("객실타입", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("사용일수", "USE_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("사용시작일", "DATE_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("사용종료일", "DATE_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("사용여부", "USE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsExc.AddColumn("적용여부", "APPLY_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gvEXCLUSIVE); Cls.Grid.Options.EmbeddedNavigater(this.gcEXCLUSIVE); Cls.Grid.Options.FilterRow(this.gvEXCLUSIVE, true); this.gcEXCLUSIVE.DataSource = dtExclusive; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("SALE_DATE"); dt.Columns.Add("BIZ_CODE"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("POS_NO"); dt.Columns.Add("BILL_NO"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("사업장", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true); gs.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("빌 번호", "BILL_NO", _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; /**************************************************************************************************/ dtIAA010MS.Columns.Add("SALE_DATE"); dtIAA010MS.Columns.Add("BIZ_CODE"); dtIAA010MS.Columns.Add("FACILITY_CODE"); dtIAA010MS.Columns.Add("FACILITY_NAME"); dtIAA010MS.Columns.Add("POS_NO"); dtIAA010MS.Columns.Add("BILL_NO"); dtIAA010MS.Columns.Add("MEMBER_NO"); dtIAA010MS.Columns.Add("MEMBER_NAME"); GridStyle gs2 = new GridStyle(this.gridIAA010MS, this.gridViewIAA010MS); gs2.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs2.AddColumn("사업장", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs2.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs2.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true); gs2.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs2.AddColumn("빌 번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs2.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs2.AddColumn("회원명", "MEMBER_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true); Cls.Grid.Options.SelectedRow(this.gridViewIAA010MS); Cls.Grid.Options.EmbeddedNavigater(this.gridIAA010MS); Cls.Grid.Options.FilterRow(this.gridViewIAA010MS, true); this.gridIAA010MS.DataSource = dtIAA010MS; /**************************************************************************************************/ dtIAA020MS.Columns.Add("SALE_DATE"); dtIAA020MS.Columns.Add("BIZ_CODE"); dtIAA020MS.Columns.Add("FACILITY_CODE"); dtIAA020MS.Columns.Add("FACILITY_NAME"); dtIAA020MS.Columns.Add("POS_NO"); dtIAA020MS.Columns.Add("BILL_NO"); dtIAA020MS.Columns.Add("MEMBER_NO"); dtIAA020MS.Columns.Add("MEMBER_NAME"); GridStyle gs3 = new GridStyle(this.gridIAA020MS, this.gridViewIAA020MS); gs3.AddColumn("판매일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("사업장", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs3.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs3.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true); gs3.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("빌 번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("회원명", "MEMBER_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true); Cls.Grid.Options.SelectedRow(this.gridViewIAA020MS); Cls.Grid.Options.EmbeddedNavigater(this.gridIAA020MS); Cls.Grid.Options.FilterRow(this.gridViewIAA020MS, true); this.gridIAA020MS.DataSource = dtIAA020MS; /**************************************************************************************************/ }
static extern bool gimp_image_grid_set_style(Int32 image_ID, GridStyle style);
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACI_PART"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("ROOM_STAT"); dt.Columns.Add("ROOM_STAT_NAME"); dt.Columns.Add("CLEAN_STAT"); dt.Columns.Add("CLEAN_STAT_NAME"); dt.Columns.Add("EXCLUSIVE_YN"); dt.Columns.Add("ROOM_TYPE_NAME"); dt.Columns.Add("ROOM_VIEW_NAME"); dt.Columns.Add("CHECKIN_DATE"); dt.Columns.Add("NIGHTS", typeof(decimal)); dt.Columns.Add("CHECKOUT_DATE"); dt.Columns.Add("GUEST_NAME"); dt.Columns.Add("APP_DATE"); dt.Columns.Add("RSV_NO"); dt.Columns.Add("TEMP_GUEST_NAME"); dt.Columns.Add("BLOCK_NAME"); GridStyle gs = new GridStyle(this.grid, this.gridView); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "FACILITY_CODE", _ColumnType.Default, _ColumnAlign.Center, false, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "FACI_PART", _ColumnType.Default, _ColumnAlign.Center, false, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "ROOM_NO", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "ROOM_STAT", _ColumnType.Default, _ColumnAlign.Center, false, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "ROOM_STAT_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); //Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "CLEAN_STAT_INPUT", _ColumnType.Default, _ColumnAlign.Center, true, true); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "CLEAN_STAT", _ColumnType.LookUp, _ColumnAlign.Center, true, false); RepositoryItemLookUpEdit Lookup = (RepositoryItemLookUpEdit)advBandedGridView.Columns["CLEAN_STAT"].ColumnEdit; BasicCode.FillBasicCode(Lookup, "DA002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "CLEAN_STAT_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); Lookup.EditValueChanged += new EventHandler(LookupUser_EditValueChanged); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "EXCLUSIVE_YN", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "ROOM_TYPE_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "ROOM_VIEW_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "CHECKIN_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "NIGHTS", _ColumnType.Numbers, _ColumnAlign.Right, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "CHECKOUT_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "GUEST_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "APP_DATE", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "RSV_NO", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "TEMP_GUEST_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridView, "BLOCK_NAME", _ColumnType.Default, _ColumnAlign.Center, true, false); //Cls.Grid.Options.SetColumnColor(this.gridView, // StyleFormatConditionType.Column, // gridView.Columns["ROOM_STAT_NAME"], // DevExpress.XtraGrid.FormatConditionEnum.Equal, // room_bgcolor, // room_fgcolor, // strRoom); Cls.Grid.Options.SetColumnColor(this.advBandedGridView, Cls.Grid.StyleFormatConditionType.Column, advBandedGridView.Columns["CLEAN_STAT"], DevExpress.XtraGrid.FormatConditionEnum.Equal, Color.Red, Color.White, BizCommon.Parm_D.CLEAN_STAT_DIRTY); Cls.Grid.Options.SetColumnColor(this.advBandedGridView, Cls.Grid.StyleFormatConditionType.Column, advBandedGridView.Columns["CLEAN_STAT"], DevExpress.XtraGrid.FormatConditionEnum.Equal, Color.Yellow, Color.Black, BizCommon.Parm_D.CLEAN_STAT_CLEAN); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.advBandedGridView, true); //Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("APPLICATION_NO"); dt.Columns.Add("CONTRACT_NO"); dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("ID_NO"); dt.Columns.Add("PROD_GROUP_CODE_NAME"); dt.Columns.Add("SALE_PROD_NAME"); dt.Columns.Add("PLAN_AMT", typeof(decimal)); dt.Columns.Add("AMT", typeof(decimal)); dt.Columns.Add("NO_AMT", typeof(decimal)); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACI_PART"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("CONTRACT_DATE"); dt.Columns.Add("FULL_PAYMENT_DATE"); dt.Columns.Add("CANCEL_DATE"); dt.Columns.Add("CHANGE_CODE"); dt.Columns.Add("CHANGE_CODE_NAME"); dt.Columns.Add("ADDRESS"); dt.Columns.Add("HOME_TEL"); dt.Columns.Add("OFFICE_TEL"); dt.Columns.Add("HOME_FAX"); dt.Columns.Add("OFFICE_FAX"); dt.Columns.Add("PURCHASE_CODE_NAME"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("신청번호", "APPLICATION_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("계약번호", "CONTRACT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("계약자명", "MEMBER_NAME_KOR", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("주민/사업", "ID_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("상품구분", "PROD_GROUP_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("상품명", "SALE_PROD_NAME", _ColumnType.Default, 190, _ColumnAlign.Left, true); gs.AddColumn("영업장", "FACILITY_CODE", _ColumnType.Default, 60, _ColumnAlign.Center, false); gs.AddColumn("동", "FACI_PART", _ColumnType.Default, 30, _ColumnAlign.Center, false); gs.AddColumn("호수", "ROOM_NO", _ColumnType.Default, 40, _ColumnAlign.Center, false); gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("계약일자", "CONTRACT_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("완납일자", "FULL_PAYMENT_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("해약일자", "CANCEL_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("개서구분", "CHANGE_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("개서일자", "CHANGE_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("총분양금", "PLAN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("총입금액", "AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("총미납금", "NO_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("자택전화", "HOME_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("직장전화", "OFFICE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("자택팩스", "HOME_FAX", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("직장팩스", "OFFICE_FAX", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("주소", "ADDRESS", _ColumnType.Default, 250, _ColumnAlign.Left, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "PLAN_AMT", "PLAN_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT", "AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "NO_AMT", "NO_AMT", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 테이터 테이블을 설정합니다. /// </summary> private void SetDataTable() { try { dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("MEMBER_NAME"); dt.Columns.Add("SEX_CODE"); dt.Columns.Add("SEX_NAME"); dt.Columns.Add("ID_NO"); dt.Columns.Add("MEMBER_GROUP_CODE"); dt.Columns.Add("MEMBER_GROUP_CODE_NAME"); dt.Columns.Add("GUEST_TYPE"); dt.Columns.Add("GUEST_TYPE_NAME"); dt.Columns.Add("MEMBER_INFO"); dt.Columns.Add("MAIN_MEMBER_NAME"); dt.Columns.Add("HOME_TEL"); dt.Columns.Add("OFFICE_TEL"); dt.Columns.Add("MOBILE_TEL"); dt.Columns.Add("HOME_POST"); dt.Columns.Add("HOME_ADDRESS1"); dt.Columns.Add("HOME_ADDRESS2"); dt.Columns.Add("OFFICE_POST"); dt.Columns.Add("OFFICE_ADDRESS1"); dt.Columns.Add("OFFICE_ADDRESS2"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("CANCEL_DATE"); dt.Columns.Add("COMMODITY_CODE"); dt.Columns.Add("COMMODITY_CODE_NAME"); dt.Columns.Add("COL"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원명", "MEMBER_NAME", _ColumnType.Default, 60, _ColumnAlign.Center, true); //gs.AddColumn("성별코드", "SEX_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("성별", "SEX_NAME", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("주민사업자", "ID_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true); //gs.AddColumn("회원구분", "MEMBER_GROUP_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원구분", "MEMBER_GROUP_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("우대구분", "GUEST_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원정보", "MEMBER_INFO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("주회원명", "MAIN_MEMBER_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("전화번호", "HOME_TEL", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("직장전화번호", "OFFICE_TEL", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("휴대폰번호", "MOBILE_TEL", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("자택우편번호", "HOME_POST", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("자택주소1", "HOME_ADDRESS1", _ColumnType.Default, 160, _ColumnAlign.Center, true); gs.AddColumn("자택주소2", "HOME_ADDRESS2", _ColumnType.Default, 160, _ColumnAlign.Center, true); gs.AddColumn("직장우편번호", "OFFICE_POST", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("직장기본주소", "OFFICE_ADDRESS1", _ColumnType.Default, 160, _ColumnAlign.Center, true); gs.AddColumn("직장상세주소", "OFFICE_ADDRESS2", _ColumnType.Default, 160, _ColumnAlign.Center, true); gs.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("해지일자", "CANCEL_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("평형구분", "COMMODITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("평형구분", "COMMODITY_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.Options.SetColumnColor(this.gridView, Cls.Grid.StyleFormatConditionType.Row, gridView.Columns["COL"], DevExpress.XtraGrid.FormatConditionEnum.Equal, BizCommon.Parm.mColor.CHECK_IN_TYPE_AFTER, "1"); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); //그리드 Footer 사용시 //Cls.Grid.Options.Footer(this.gridView, DevExpress.Data.SummaryItemType.Sum, "ROOM_CNT", "ROOM_CNT", SummaryFormat.Sum); this.grid.DataSource = dt; } catch (Exception ex) { throw ex; } }
private void ResetStyleRow() { StyleRow = GridStyle.List; }
/// <summary> /// 创建矩形笔刷 /// </summary> /// <param name="x">起点X坐标</param> /// <param name="y">起点Y坐标</param> /// <param name="gridSizeNumW">宽</param> /// <param name="gridSizeNumH">高</param> /// <returns></returns> public static TextureBrush DrawRectangle(int x, int y, int gridSizeNumW, int gridSizeNumH, GridStyle gridStyle) { Bitmap bit = new Bitmap(gridSizeNumW, gridSizeNumH); Graphics g = Graphics.FromImage(bit); g.Clear(gridStyle.BgColor); g.DrawRectangle(new Pen(gridStyle.ShowGrid ? gridStyle.LineColor : gridStyle.BgColor, gridStyle.LineWidth), new Rectangle(-1, -1, gridSizeNumW, gridSizeNumH)); g.Dispose(); TextureBrush textureBrush = new TextureBrush(bit); textureBrush.TranslateTransform(x, y); return(textureBrush); }
/// <summary> /// Populate values from the base palette. /// </summary> /// <param name="state">The palette state to populate with.</param> /// <param name="common">Reference to common settings.</param> /// <param name="gridStyle">Grid style to use for populating.</param> public virtual void PopulateFromBase(KryptonPaletteCommon common, PaletteState state, GridStyle gridStyle) { if (gridStyle == GridStyle.List) common.StateCommon.SetStyles(PaletteBackStyle.GridDataCellList, PaletteBorderStyle.GridDataCellList, PaletteContentStyle.GridDataCellList); else common.StateCommon.SetStyles(PaletteBackStyle.GridDataCellSheet, PaletteBorderStyle.GridDataCellSheet, PaletteContentStyle.GridDataCellSheet); _dataCell.PopulateFromBase(state); if (gridStyle == GridStyle.List) common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderColumnList, PaletteBorderStyle.GridHeaderColumnList, PaletteContentStyle.GridHeaderColumnList); else common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderColumnSheet, PaletteBorderStyle.GridHeaderColumnSheet, PaletteContentStyle.GridHeaderColumnSheet); _headerColumn.PopulateFromBase(state); if (gridStyle == GridStyle.List) common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderRowList, PaletteBorderStyle.GridHeaderRowList, PaletteContentStyle.GridHeaderRowList); else common.StateCommon.SetStyles(PaletteBackStyle.GridHeaderRowSheet, PaletteBorderStyle.GridHeaderRowSheet, PaletteContentStyle.GridHeaderRowSheet); _headerRow.PopulateFromBase(state); }
/// <summary> /// Populate values from the base palette. /// </summary> /// <param name="common">Reference to common settings.</param> /// <param name="gridStyle">Grid style to use for populating.</param> public void PopulateFromBase(KryptonPaletteCommon common, GridStyle gridStyle) { // Populate only the designated styles _stateDisabled.PopulateFromBase(common, PaletteState.Disabled, gridStyle); _stateNormal.PopulateFromBase(common, PaletteState.Normal, gridStyle); _stateTracking.PopulateFromBase(common, PaletteState.Tracking, gridStyle); _statePressed.PopulateFromBase(common, PaletteState.Pressed, gridStyle); _stateSelected.PopulateFromBase(common, PaletteState.CheckedNormal, gridStyle); }
/// <summary> /// Loads the FlowChart document from a stream. /// </summary> public void LoadFromStream(Stream stream) { try { loading = true; SuspendLayout(); ClearAll(); PersistContext ctx = new PersistContext(stream, this); ctx.readHeader(); // read basic-type flowchart properties DocInfoVer1 docInfo1 = (DocInfoVer1)ctx.loadObject(); DocInfoVer2 docInfo2 = (DocInfoVer2)ctx.loadObject(); docInfo1.apply(this); docInfo2.apply(this); textFormat = ctx.loadStringFormat(); Font = ctx.loadFont(); BackgroundImage = ctx.loadImage(); // read diagram objects zOrder = (ChartObjectCollection)ctx.loadObject(); groups = (GroupCollection)ctx.loadObject(); selection = (Selection)ctx.loadObject(); ctx.loadReference(this); if (ctx.FileVersion > 2) { shapeTemplate = (ShapeTemplate)ctx.loadObject(); if (ctx.FileVersion > 3) { Brush.RestoreBrushes(this, new BinaryReader(stream), ctx); boxPen = (Pen)ctx.loadObject(); arrowPen = (Pen)ctx.loadObject(); tablePen = (Pen)ctx.loadObject(); ctx.loadReference(this); ctx.loadReference(this); ctx.loadReference(this); boxSelStyle = (HandlesStyle)ctx.reader.ReadInt32(); tableSelStyle = (HandlesStyle)ctx.reader.ReadInt32(); if (ctx.FileVersion > 4) { // new in save format 5 allowLinksRepeat = ctx.reader.ReadBoolean(); if (ctx.FileVersion > 5) { // new in save format 6 PolyTextLayout = ctx.reader.ReadBoolean(); ShapeOrientation = ctx.reader.ReadSingle(); if (ctx.FileVersion > 7) { // new in save format 8 routeArrows = ctx.reader.ReadBoolean(); arrowsRetainForm = ctx.reader.ReadBoolean(); arrowTextStyle = (ArrowTextStyle)ctx.reader.ReadInt32(); tableLinkStyle = (TableLinkStyle)ctx.reader.ReadInt32(); if (ctx.FileVersion >= 12) { // new in save format 12 measureUnit = (GraphicsUnit)ctx.reader.ReadInt32(); docExtentsMin = ctx.loadRectF(); if (ctx.FileVersion > 13) { // new in save format 14 expandBtnPos = (ExpandButtonPosition)ctx.reader.ReadInt32(); // not used anymore ctx.reader.ReadInt32(); ctx.reader.ReadInt32(); enableStyledText = ctx.reader.ReadBoolean(); usePolyTextLt = ctx.reader.ReadBoolean(); ctx.loadReference(this); // brush if (ctx.FileVersion > 16) { // new in save format 17 arrowText = ctx.reader.ReadString(); boxText = ctx.reader.ReadString(); arrowCrossings = (ArrowCrossings)ctx.reader.ReadInt32(); gridStyle = (GridStyle)ctx.reader.ReadInt32(); crossRadius = ctx.reader.ReadSingle(); if (ctx.FileVersion > 19) { // new in save format 20 ctx.loadReference(this); // exteriorBrush arrowsSnapToBorders = ctx.reader.ReadBoolean(); arrowSelStyle = (HandlesStyle)ctx.reader.ReadInt32(); if (ctx.FileVersion > 20) { // new in save format 21 Tag = null; bool tagAvailable = ctx.reader.ReadBoolean(); if (tagAvailable) Tag = ctx.loadTag(); if (ctx.FileVersion > 26) { // new in save format 27 roundedArrows = ctx.reader.ReadBoolean(); roundedArrowsRadius = ctx.reader.ReadSingle(); } } } } } } } } } } } // finish load ctx.loadRemainingObjects(); ctx.setReferences(); // add the objects to their specialized collections foreach (ChartObject obj in zOrder) addToObjColl(obj); foreach (Group group in groups) group.updateObjCol(); Brush.freeUnusedBrushes(); foreach (ChartObject obj in zOrder) obj.onLoad(); dirty = false; Invalidate(); } finally { loading = false; ResumeLayout(true); } }
/// <summary> /// Update the styles of the headers and data cells. /// </summary> /// <param name="headerColumn">Style for the column headers.</param> /// <param name="headerRow">Style for the row headers.</param> /// <param name="dataCell">Style for the data cells.</param> public void SetGridStyles(GridStyle headerColumn, GridStyle headerRow, GridStyle dataCell) { switch (headerColumn) { case GridStyle.List: _headerColumn.SetStyles(PaletteBackStyle.GridHeaderColumnList, PaletteBorderStyle.GridHeaderColumnList, PaletteContentStyle.GridHeaderColumnList); break; case GridStyle.Sheet: _headerColumn.SetStyles(PaletteBackStyle.GridHeaderColumnSheet, PaletteBorderStyle.GridHeaderColumnSheet, PaletteContentStyle.GridHeaderColumnSheet); break; case GridStyle.Custom1: _headerColumn.SetStyles(PaletteBackStyle.GridHeaderColumnCustom1, PaletteBorderStyle.GridHeaderColumnCustom1, PaletteContentStyle.GridHeaderColumnCustom1); break; } switch (headerRow) { case GridStyle.List: _headerRow.SetStyles(PaletteBackStyle.GridHeaderRowList, PaletteBorderStyle.GridHeaderRowList, PaletteContentStyle.GridHeaderRowList); break; case GridStyle.Sheet: _headerRow.SetStyles(PaletteBackStyle.GridHeaderRowSheet, PaletteBorderStyle.GridHeaderRowSheet, PaletteContentStyle.GridHeaderRowSheet); break; case GridStyle.Custom1: _headerRow.SetStyles(PaletteBackStyle.GridHeaderRowCustom1, PaletteBorderStyle.GridHeaderRowCustom1, PaletteContentStyle.GridHeaderRowCustom1); break; } switch (dataCell) { case GridStyle.List: _dataCell.SetStyles(PaletteBackStyle.GridDataCellList, PaletteBorderStyle.GridDataCellList, PaletteContentStyle.GridDataCellList); break; case GridStyle.Sheet: _dataCell.SetStyles(PaletteBackStyle.GridDataCellSheet, PaletteBorderStyle.GridDataCellSheet, PaletteContentStyle.GridDataCellSheet); break; case GridStyle.Custom1: _dataCell.SetStyles(PaletteBackStyle.GridDataCellCustom1, PaletteBorderStyle.GridDataCellCustom1, PaletteContentStyle.GridDataCellCustom1); break; } }
/// <summary> /// 切换网格 /// </summary> /// <param name="gridstyle"></param> public void TransformGrid(GridStyle gridstyle) { gridContext = new GridContext(gridstyle); base.Invalidate(); }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetGrid() { try { DataTable dtparmSelect = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtparmSelect.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); dtparmSelect.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCode.EditValue.ToString().Trim() }); dtparmSelect.Rows.Add(new object[] { "V_FACI_PART", this.tcFaciPart.SelectedTabPage.Tag.ToString().Trim() }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_DGRAS05.PR_03", dtparmSelect, DataLayer.MessageEncoding.Default); //dt.Clear(); DataTable dtCol = new DataTable(); if (ds.Tables[0].Rows.Count <= 0) { Basic.ShowMessage(1, "데이터가 존재 하지 않습니다."); return; } dtCol.Load(ds.Tables[0].CreateDataReader()); int forCnt = dtCol.Rows.Count; dt.Columns.Clear(); this.gridView.Columns.Clear(); GridStyle gs = new GridStyle(this.grid, this.gridView); //ROOM_STAT_NAME 객실상태에 따른 칼러값 지정 string filter = "HEAD = '{0}' AND DETAIL <> ' ' AND USE_YN = 'Y'"; DataRow[] rRommState = BizCommon.Parm.mDataTable.dtZx010ms.Select(string.Format(filter, "DA003")); DataRow[] rCleanState = BizCommon.Parm.mDataTable.dtZx010ms.Select(string.Format(filter, "DA002")); for (int i = 0; i < forCnt; i++) { dt.Columns.Add(dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()); dt.Columns.Add("ROOM_NO" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()); dt.Columns.Add("ROOM_STAT" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()); dt.Columns.Add("ROOM_STAT_NAME" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()); dt.Columns.Add("CLEAN_STAT" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()); dt.Columns.Add("CLEAN_STAT_NAME" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()); gs.AddColumn("객실번호", "ROOM_NO" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim(), _ColumnType.Default, 68, _ColumnAlign.Center, true); gs.AddColumn("객실상태", "ROOM_STAT_NAME" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim(), _ColumnType.Default, 68, _ColumnAlign.Center, true); gs.AddColumn("청소상태", "CLEAN_STAT_NAME" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim(), _ColumnType.Default, 68, _ColumnAlign.Center, true); Cls.Grid.Options.SetColumnColor(this.gridView, StyleFormatConditionType.Column, this.gridView.Columns["ROOM_NO" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()], DevExpress.XtraGrid.FormatConditionEnum.GreaterOrEqual, Color.Goldenrod, null); for (int h = 0; h < rRommState.Length; h++) { string strRoom = rRommState[h]["DETAIL_NAME"].ToString().Trim(); Color room_bgcolor = mColor.ConvertColor(rRommState[h]["ITEM2"].ToString().Trim()); // if (room_bgcolor.Name.Equals("ffffffff")) return; Color room_fgcolor = mColor.ConvertColor(rRommState[h]["ITEM3"].ToString().Trim()); Cls.Grid.Options.SetColumnColor(this.gridView, StyleFormatConditionType.Column, this.gridView.Columns["ROOM_STAT_NAME" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()], DevExpress.XtraGrid.FormatConditionEnum.Equal, room_bgcolor, room_fgcolor, strRoom); } for (int j = 0; j < rCleanState.Length; j++) { string strClean = rCleanState[j]["DETAIL_NAME"].ToString().Trim(); Color room_bgcolor = mColor.ConvertColor(rCleanState[j]["ITEM2"].ToString().Trim()); // if (room_bgcolor.Name.Equals("ffffffff")) return; Color room_fgcolor = mColor.ConvertColor(rCleanState[j]["ITEM3"].ToString().Trim()); Cls.Grid.Options.SetColumnColor(this.gridView, StyleFormatConditionType.Column, this.gridView.Columns["CLEAN_STAT_NAME" + dtCol.Rows[i]["ROOM_FLOOR"].ToString().Trim()], DevExpress.XtraGrid.FormatConditionEnum.Equal, room_bgcolor, room_fgcolor, strClean); } } this.gridView.OptionsSelection.EnableAppearanceFocusedCell = false; this.gridView.OptionsSelection.EnableAppearanceFocusedRow = false; this.gridView.OptionsSelection.EnableAppearanceHideSelection = true; } catch (Exception ex) { throw ex; } }
protected virtual void DrawGrid(CGContext context, IViewPort viewPort, IYAxis yAxis, nfloat axisLineStart, nfloat axisLineEnd, GridStyle gridStyle) { var Step = gridStyle.Step; var visibleSourceRangeStart = yAxis.Min - (yAxis.Min % Step) - Step; var visibleSourceRangeEnd = yAxis.Max - (yAxis.Max % Step) + Step; var leftAxisX = viewPort.ViewPortRect.Left + gridStyle.Offset.X; var rightAxisX = viewPort.ViewPortRect.Right - gridStyle.Offset.X; for (double i = visibleSourceRangeStart; i <= visibleSourceRangeEnd; i += Step) { var y = yAxis.GetContentValue(i); var viewPortPositionY = viewPort.DisplayPositionY((nfloat)y) + gridStyle.Offset.Y; if (viewPortPositionY >= axisLineStart && viewPortPositionY <= axisLineEnd) { DrawHelper.DrawLines(context, new List <CGPoint> { new CGPoint(leftAxisX, viewPortPositionY), new CGPoint(rightAxisX, viewPortPositionY) }, gridStyle); } } }
/// <summary> /// 创建矩形笔刷 /// </summary> /// <param name="gridSizeNumW">宽</param> /// <param name="gridSizeNumH">高</param> /// <returns></returns> public static TextureBrush DrawRectangle(int gridSizeNumW, int gridSizeNumH, GridStyle gridStyle) { return(DrawRectangle(-1, -1, gridSizeNumW, gridSizeNumH, gridStyle)); }
/// <summary> /// Populate values from the base palette. /// </summary> /// <param name="state">The palette state to populate with.</param> /// <param name="common">Reference to common settings.</param> /// <param name="gridStyle">Grid style to use for populating.</param> public override void PopulateFromBase(KryptonPaletteCommon common, PaletteState state, GridStyle gridStyle) { base.PopulateFromBase(common, state, gridStyle); if (gridStyle == GridStyle.List) common.StateCommon.BackStyle = PaletteBackStyle.GridBackgroundList; else common.StateCommon.BackStyle = PaletteBackStyle.GridBackgroundSheet; _background.PopulateFromBase(state); }
public static void SetGridStyle(string name, GridStyle gridStyle) { _gridStyles[name] = gridStyle; }
/// <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("FACI_PART"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("ROOM_TYPE"); dt.Columns.Add("GUEST_NAME"); dt.Columns.Add("CHECKIN_DATE"); dt.Columns.Add("NIGHTS", typeof(decimal)); dt.Columns.Add("CHECKOUT_DATE"); dt.Columns.Add("GUEST_TYPE"); dt.Columns.Add("GUEST_TYPE_NAME"); dt.Columns.Add("PERSON_CNT", typeof(decimal)); dt.Columns.Add("OVER_PERSON", typeof(decimal)); dt.Columns.Add("TAX_YN"); dt.Columns.Add("MAIN_YN"); dt.Columns.Add("DC_RATE", typeof(decimal)); dt.Columns.Add("UNIT_AMT", typeof(decimal)); dt.Columns.Add("FNB_AMT", typeof(decimal)); dt.Columns.Add("RSV_REMARKS"); dt.Columns.Add("RMRK"); dt.Columns.Add("CHECKIN_TYPE"); dt.Columns.Add("CHECKIN_TYPE_NAME"); dt.Columns.Add("USER_CODE"); dt.Columns.Add("USER_CODE_NAME"); dt.Columns.Add("RSV_NO"); dt.Columns.Add("APP_DATE"); dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("TYPEUP_GUBUN"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("관리번호", "MNG_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("관리순번", "MNG_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, false); gs.AddColumn("동구분", "FACI_PART", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("상위구분", "TYPEUP_GUBUN", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("우대구분코드", "GUEST_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("인원", "PERSON_CNT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("초과인원", "OVER_PERSON", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); gs.AddColumn("세금여부", "TAX_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("메인여부", "MAIN_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("할인율", "DC_RATE", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("메뉴단가", "UNIT_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("식음금액", "FNB_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("예약참고사항", "RSV_REMARKS", _ColumnType.Default, 120, _ColumnAlign.Center, false); gs.AddColumn("입실참고사항", "RMRK", _ColumnType.Default, 120, _ColumnAlign.Center, false); gs.AddColumn("입실유형", "CHECKIN_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("입실유형", "CHECKIN_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("사용자코드", "USER_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, false); gs.AddColumn("본인여부", "USER_CODE_NAME", _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 ResetStyleDataCells() { StyleDataCells = GridStyle.List; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { // 미수금 dtRece.Columns.Add("CHK"); dtRece.Columns.Add("RECE_NO"); dtRece.Columns.Add("MEMBER_NAME_KOR"); dtRece.Columns.Add("MEMBER_NO"); //dtRece.Columns.Add("OCCR_CODE" ); //dtRece.Columns.Add("OCCR_BIZ_CODE" ); //dtRece.Columns.Add("OCCR_FACILITY_CODE" ); //dtRece.Columns.Add("RECE_CODE" ); dtRece.Columns.Add("RECE_AMT", typeof(decimal)); dtRece.Columns.Add("MEMBER_SEQ"); dtRece.Columns.Add("ANNUAL"); //dtRece.Columns.Add("CAP_MEMBER_SEQ" ); dtRece.Columns.Add("GROUP_SEQ", typeof(decimal)); dtRece.Columns.Add("RECE_SALE_DATE"); //dtRece.Columns.Add("RECE_BIZ_CODE" ); //dtRece.Columns.Add("RECE_FACILITY_CODE" ); //dtRece.Columns.Add("RECE_POS_NO" ); //dtRece.Columns.Add("RECE_BILL_NO" ); //dtRece.Columns.Add("RECE_SALE_YN" ); //dtRece.Columns.Add("RECE_PAY_CODE" ); //dtRece.Columns.Add("RECE_PAY_SEQ" , typeof(decimal)); dtRece.Columns.Add("RMRK"); //dtRece.Columns.Add("U_DATE" ); //dtRece.Columns.Add("U_EMP_NO" ); //dtRece.Columns.Add("U_IP" ); GridStyle gsRece = new GridStyle(this.gridRece, this.gridViewRece); gsRece.AddColumn("선택", "CHK", _ColumnType.CheckBox, 50, _ColumnAlign.Center, true, true); gsRece.AddColumn("미수번호", "RECE_NO", _ColumnType.Default, 130, _ColumnAlign.Center, true); gsRece.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 140, _ColumnAlign.Center, true); gsRece.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gsRece.AddColumn("발생구분코드" , "OCCR_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("사업장코드" , "OCCR_BIZ_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("영업장코드" , "OCCR_FACILITY_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("미수구분코드" , "RECE_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); gsRece.AddColumn("미수금액", "RECE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); //gsRece.AddColumn("기수" , "ANNUAL" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("그룹회원일련번호" , "CAP_MEMBER_SEQ" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("그룹순번" , "GROUP_SEQ" , _ColumnType.Numbers , 80, _ColumnAlign.Right , true); gsRece.AddColumn("판매일자", "RECE_SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsRece.AddColumn("회원일련번호", "MEMBER_SEQ", _ColumnType.Default, 110, _ColumnAlign.Center, true); //gsRece.AddColumn("사업장코드" , "RECE_BIZ_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("영업장코드" , "RECE_FACILITY_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("POS번호" , "RECE_POS_NO" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("전표번호" , "RECE_BILL_NO" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("판매구분" , "RECE_SALE_YN" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("결제구분" , "RECE_PAY_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("순번" , "RECE_PAY_SEQ" , _ColumnType.Numbers , 80, _ColumnAlign.Right , true); gsRece.AddColumn("비고", "RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gsRece.AddColumn("수정일" , "U_DATE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("수정자" , "U_EMP_NO" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsRece.AddColumn("수정IP" , "U_IP" , _ColumnType.Default , 80, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridViewRece); Cls.Grid.Options.EmbeddedNavigater(this.gridRece); Cls.Grid.Options.FilterRow(this.gridViewRece, true); this.gridRece.DataSource = dtRece; // 미수금 그룹 dtReceGrp.Columns.Add("CHK"); dtReceGrp.Columns.Add("ANNUAL"); dtReceGrp.Columns.Add("CAP_MEMBER_NAME_KOR"); dtReceGrp.Columns.Add("CAP_MEMBER_NO"); dtReceGrp.Columns.Add("CAP_MEMBER_SEQ"); dtReceGrp.Columns.Add("GROUP_SEQ", typeof(decimal)); //dtReceGrp.Columns.Add("BIZ_CODE"); dtReceGrp.Columns.Add("EXAT_CALC_YN"); dtReceGrp.Columns.Add("RMRK"); dtReceGrp.Columns.Add("AMT", typeof(decimal)); dtReceGrp.Columns.Add("REDEEM_CNT", typeof(decimal)); GridStyle gsReceGrp = new GridStyle(this.gridReceGrp, this.gridViewReceGrp); gsReceGrp.AddColumn("선택", "CHK", _ColumnType.CheckBox, 50, _ColumnAlign.Center, true, true); gsReceGrp.AddColumn("기수", "ANNUAL", _ColumnType.Default, 50, _ColumnAlign.Center, true); gsReceGrp.AddColumn("대표자명", "CAP_MEMBER_NAME_KOR", _ColumnType.Default, 140, _ColumnAlign.Center, true); gsReceGrp.AddColumn("대표회원번호", "CAP_MEMBER_NO", _ColumnType.Default, 110, _ColumnAlign.Center, true); gsReceGrp.AddColumn("대표일련번호", "CAP_MEMBER_SEQ", _ColumnType.Default, 110, _ColumnAlign.Center, true); gsReceGrp.AddColumn("그룹순번", "GROUP_SEQ", _ColumnType.Numbers, 70, _ColumnAlign.Center, true); //gsReceGrp.AddColumn("사업장코드" , "BIZ_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); gsReceGrp.AddColumn("정산여부", "EXAT_CALC_YN", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsReceGrp.AddColumn("입금액", "AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsReceGrp.AddColumn("입금내역수", "REDEEM_CNT", _ColumnType.Numbers, 80, _ColumnAlign.Center, true); gsReceGrp.AddColumn("비고", "RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridViewReceGrp); Cls.Grid.Options.EmbeddedNavigater(this.gridReceGrp); Cls.Grid.Options.FilterRow(this.gridViewReceGrp, true); this.gridReceGrp.DataSource = dtReceGrp; // 미수금 그룹 맵버 dtReceGrpMem.Columns.Add("CHK"); dtReceGrpMem.Columns.Add("RECE_NO"); dtReceGrpMem.Columns.Add("MEMBER_NAME_KOR"); dtReceGrpMem.Columns.Add("MEMBER_NO"); //dtReceGrpMem.Columns.Add("OCCR_CODE"); //dtReceGrpMem.Columns.Add("OCCR_BIZ_CODE"); //dtReceGrpMem.Columns.Add("OCCR_FACILITY_CODE"); //dtReceGrpMem.Columns.Add("RECE_CODE"); dtReceGrpMem.Columns.Add("RECE_AMT", typeof(decimal)); dtReceGrpMem.Columns.Add("MEMBER_SEQ"); //dtReceGrpMem.Columns.Add("ANNUAL"); //dtReceGrpMem.Columns.Add("CAP_MEMBER_SEQ"); //dtReceGrpMem.Columns.Add("GROUP_SEQ", typeof(decimal)); dtReceGrpMem.Columns.Add("RECE_SALE_DATE"); //dtReceGrpMem.Columns.Add("RECE_BIZ_CODE"); //dtReceGrpMem.Columns.Add("RECE_FACILITY_CODE"); //dtReceGrpMem.Columns.Add("RECE_POS_NO"); //dtReceGrpMem.Columns.Add("RECE_BILL_NO"); //dtReceGrpMem.Columns.Add("RECE_SALE_YN"); //dtReceGrpMem.Columns.Add("RECE_PAY_CODE"); //dtReceGrpMem.Columns.Add("RECE_PAY_SEQ", typeof(decimal)); dtReceGrpMem.Columns.Add("RMRK"); //dtReceGrpMem.Columns.Add("U_DATE"); //dtReceGrpMem.Columns.Add("U_EMP_NO"); //dtReceGrpMem.Columns.Add("U_IP"); GridStyle gsReceGrpMem = new GridStyle(this.gridReceGrpMem, this.gridViewReceGrpMem); gsReceGrpMem.AddColumn("선택", "CHK", _ColumnType.CheckBox, 50, _ColumnAlign.Center, true, true); gsReceGrpMem.AddColumn("미수번호", "RECE_NO", _ColumnType.Default, 130, _ColumnAlign.Center, true); gsReceGrpMem.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 140, _ColumnAlign.Center, true); gsReceGrpMem.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("발생구분코드" , "OCCR_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("사업장코드" , "OCCR_BIZ_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("영업장코드" , "OCCR_FACILITY_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("미수구분코드" , "RECE_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); gsReceGrpMem.AddColumn("미수금액", "RECE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsReceGrpMem.AddColumn("회원일련번호", "MEMBER_SEQ", _ColumnType.Default, 110, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("기수" , "ANNUAL" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("대표번호일련번호" , "CAP_MEMBER_SEQ" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("그룹순번" , "GROUP_SEQ" , _ColumnType.Numbers , 80, _ColumnAlign.Right , true); gsReceGrpMem.AddColumn("판매일자", "RECE_SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("사업장코드" , "RECE_BIZ_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("영업장코드" , "RECE_FACILITY_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("POS번호" , "RECE_POS_NO" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("전표번호" , "RECE_BILL_NO" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("판매구분" , "RECE_SALE_YN" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("결제구분" , "RECE_PAY_CODE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("순번" , "RECE_PAY_SEQ" , _ColumnType.Numbers , 80, _ColumnAlign.Right , true); gsReceGrpMem.AddColumn("비고", "RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("최종수정일자" , "U_DATE" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("최종수정자사번" , "U_EMP_NO" , _ColumnType.Default , 80, _ColumnAlign.Center, true); //gsReceGrpMem.AddColumn("최종수정자IP" , "U_IP" , _ColumnType.Default , 80, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridViewReceGrpMem); Cls.Grid.Options.EmbeddedNavigater(this.gridReceGrpMem); Cls.Grid.Options.FilterRow(this.gridViewReceGrpMem, true); this.gridReceGrpMem.DataSource = dtReceGrpMem; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("CALN_DATE"); dt.Columns.Add("CALN_DATE_MASK"); dt.Columns.Add("DAYWEEK"); dt.Columns.Add("USE_CNT", typeof(decimal)); dt.Columns.Add("RSV_CNT", typeof(decimal)); dt.Columns.Add("BLOCK_CNT", typeof(decimal)); dt.Columns.Add("REMAIN_CNT", typeof(decimal)); dt.Columns.Add("WEEK_CODE"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("일자", "CALN_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("요일", "DAYWEEK", _ColumnType.Default, 40, _ColumnAlign.Center, true); gs.AddColumn("객실", "USE_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gs.AddColumn("예약", "RSV_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gs.AddColumn("블럭", "BLOCK_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gs.AddColumn("잔여", "REMAIN_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gs.AddColumn("WEEK_CODE", "WEEK_CODE", _ColumnType.Numbers, 50, _ColumnAlign.Right, false); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); this.grid.DataSource = dt; dtDetail.Columns.Add("STATUS_CODE_NAME"); dtDetail.Columns.Add("RSV_NO"); dtDetail.Columns.Add("ROOM_NO"); dtDetail.Columns.Add("MEMBER_NO"); dtDetail.Columns.Add("MEMBER_NAME_KOR"); dtDetail.Columns.Add("GUEST_NAME"); dtDetail.Columns.Add("ROOM_TYPE_NAME"); dtDetail.Columns.Add("CHECKIN_DATE_MASK"); dtDetail.Columns.Add("CHECKOUT_DATE_MASK"); dtDetail.Columns.Add("ROOM_CNT"); dtDetail.Columns.Add("NIGHTS"); dtDetail.Columns.Add("USER_CODE_NAME"); dtDetail.Columns.Add("APP_AMT", typeof(decimal)); dtDetail.Columns.Add("RMRK"); dtDetail.Columns.Add("U_DATE"); GridStyle gsDetail = new GridStyle(this.gridDetail, this.gridViewDetail); gsDetail.AddColumn("상태", "STATUS_CODE_NAME", _ColumnType.Default, 40, _ColumnAlign.Center, true); gsDetail.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsDetail.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsDetail.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsDetail.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Left, true); gsDetail.AddColumn("투숙자명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gsDetail.AddColumn("객실유형", "ROOM_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("입실일자", "CHECKIN_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("퇴실일자", "CHECKOUT_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true); gsDetail.AddColumn("객실수", "ROOM_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gsDetail.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 50, _ColumnAlign.Right, true); gsDetail.AddColumn("총요금", "APP_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gsDetail.AddColumn("비고", "RMRK", _ColumnType.Default, 100, _ColumnAlign.Left, true); gsDetail.AddColumn("입력정보", "U_DATE", _ColumnType.Default, 150, _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(gridViewDetail, DevExpress.Data.SummaryItemType.Sum, "ROOM_CNT", "ROOM_CNT", SummaryFormat.Sum); this.gridDetail.DataSource = dtDetail; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("ROOM_NO"); dt.Columns.Add("ROOM_TYPE"); dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("GUEST_NAME"); dt.Columns.Add("ACCEPT_NAME"); dt.Columns.Add("GUEST_TYPE_NAME"); dt.Columns.Add("RSV_NO"); dt.Columns.Add("PKG_NAME"); dt.Columns.Add("CHECKIN_DATE"); dt.Columns.Add("CHECKIN_DY"); dt.Columns.Add("SEASON_NAME"); dt.Columns.Add("NIGHTS", typeof(decimal)); dt.Columns.Add("CHECKOUT_DATE"); 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("ETC_AMT", typeof(decimal)); dt.Columns.Add("TOT_AMT", typeof(decimal)); dt.Columns.Add("RSV_RMRK"); dt.Columns.Add("STAY_RMRK"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 65, _ColumnAlign.Center, true); gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 65, _ColumnAlign.Center, true); gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("신청자명", "ACCEPT_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 70, _ColumnAlign.Left, true); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 65, _ColumnAlign.Center, true); gs.AddColumn("패키지명", "PKG_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("요일", "CHECKIN_DY", _ColumnType.Default, 45, _ColumnAlign.Center, true); gs.AddColumn("시즌", "SEASON_NAME", _ColumnType.Default, 50, _ColumnAlign.Center, true); gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 45, _ColumnAlign.Center, true); gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("객실료", "ROOM_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("인원초과", "OVER_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("침구추가", "BED_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("준회원", "RENTAL_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("기타", "ETC_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("합계", "TOT_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("예약참고사항", "RSV_RMRK", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("객실참고사항", "STAY_RMRK", _ColumnType.Default, 90, _ColumnAlign.Left, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "NIGHTS", "NIGHTS", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "ROOM_AMT", "ROOM_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "OVER_AMT", "ROOM_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "BED_AMT", "BED_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "RENTAL_AMT", "RENTAL_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "ETC_AMT", "ETC_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "TOT_AMT", "TOT_AMT", SummaryFormat.Sum); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("RSV_NO"); dt.Columns.Add("RSV_ROOM_TYPE_NAME"); dt.Columns.Add("RSV_USE_CODE_NAME"); dt.Columns.Add("RSV_CHECKIN_DATE"); dt.Columns.Add("RSV_CHECKOUT_DATE"); dt.Columns.Add("RSV_NIGHTS"); dt.Columns.Add("RSV_ROOM_CNT"); dt.Columns.Add("RSV_GUEST_NAME"); dt.Columns.Add("RSV_PART_NAME"); dt.Columns.Add("RSV_RMRK"); dt.Columns.Add("USE_DAY_CODE"); dt.Columns.Add("TASK_DATE"); dt.Columns.Add("FACILITY_NAME"); dt.Columns.Add("ROOM_TYPE_NAME"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("CHECKIN_DATE"); dt.Columns.Add("CHECKOUT_DATE"); dt.Columns.Add("GUEST_NAME"); dt.Columns.Add("ROOM_TEL"); dt.Columns.Add("SALE_AMT", typeof(decimal)); dt.Columns.Add("MEMBER_NO"); //dt.Columns.Add("MEMBER_NAME"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("예약-번호", "RSV_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("예약-유형", "RSV_ROOM_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("예약-구분", "RSV_USE_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("예약-CHECKIN", "RSV_CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("예약-CHECKOUT", "RSV_CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("예약-박수", "RSV_NIGHTS", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("예약-객실수", "RSV_ROOM_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("예약-투숙자", "RSV_GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("예약-형태", "RSV_PART_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("예약-참고", "RSV_RMRK", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("객실-시즌", "USE_DAY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실-투숙일", "TASK_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실-영업장", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실-유형", "ROOM_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("객실-번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실-CHECKIN", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실-CHECKOUT", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실-회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); //gs.AddColumn("객실-회원이름" , "MEMBER_NAME" , _ColumnType.Default , 80,_ColumnAlign.Center , true); gs.AddColumn("객실-투숙객", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("객실-연락처", "ROOM_TEL", _ColumnType.Default, 80, _ColumnAlign.Left, true); gs.AddColumn("객실-이용금액", "SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); this.gridView.OptionsView.ShowGroupPanel = true; this.gridView.OptionsView.ShowFooter = false; this.gridView.GroupCount = 1; this.gridView.SortInfo.AddRange(new DevExpress.XtraGrid.Columns.GridColumnSortInfo[] { new DevExpress.XtraGrid.Columns.GridColumnSortInfo(this.gridView.Columns["USE_DAY_CODE"], DevExpress.Data.ColumnSortOrder.Ascending) }); this.gridView.ExpandAllGroups(); //this.gridView.Columns["RSV_NO"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_ROOM_TYPE_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_USE_CODE_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_CHECKIN_DATE"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_CHECKOUT_DATE"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_NIGHTS"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_ROOM_CNT"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_GUEST_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_PART_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; //this.gridView.Columns["RSV_RMRK"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True; this.gridView.Columns["USE_DAY_CODE"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; this.gridView.Columns["TASK_DATE"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending; Cls.Grid.Options.Footer(this.gridView, DevExpress.Data.SummaryItemType.Count, "USE_DAY_CODE", "USE_DAY_CODE", SummaryFormat.Count); this.grid.DataSource = dt; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { //객실 dt1.Columns.Add("ROOM_CNT", typeof(decimal)); dt1.Columns.Add("UNIT_AMT", typeof(decimal)); dt1.Columns.Add("APPLY_AMT", typeof(decimal)); dt1.Columns.Add("SALE_AMT", typeof(decimal)); GridStyle gs1 = new GridStyle(this.grid1, this.gridView1); gs1.AddColumn("일 자", "CHECKIN_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs1.AddColumn("객실정원", "ROOM_SIZE_NAME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs1.AddColumn("객실타입", "ROOM_TYPE_NAME", _ColumnType.Default, 160, _ColumnAlign.Center, true); gs1.AddColumn("객실수", "ROOM_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("정상요금", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs1.AddColumn("적용요금", "APPLY_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs1.AddColumn("금 액", "SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true); gs1.AddColumn("비 고", "RMRK", _ColumnType.Default, 200, _ColumnAlign.Default, true); Cls.Grid.Options.SelectedRow(this.gridView1); Cls.Grid.Options.EmbeddedNavigater(this.grid1); Cls.Grid.Options.Footer(gridView1, DevExpress.Data.SummaryItemType.Sum, "ROOM_CNT", "ROOM_CNT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView1, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.grid1.DataSource = dt1; //식음료 dt2.Columns.Add("UNIT_AMT", typeof(decimal)); dt2.Columns.Add("APPLY_AMT", typeof(decimal)); dt2.Columns.Add("SALE_AMT", typeof(decimal)); GridStyle gs2 = new GridStyle(this.grid2, this.gridView2); gs2.AddColumn("일 자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs2.AddColumn("시 간", "ST_TIME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs2.AddColumn("메 뉴", "MENU_NAME", _ColumnType.Default, 160, _ColumnAlign.Default, true); gs2.AddColumn("보증인원", "PERSON_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs2.AddColumn("정상요금", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs2.AddColumn("적용요금", "APPLY_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs2.AddColumn("금 액", "SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true); gs2.AddColumn("비 고", "RMRK", _ColumnType.Default, 200, _ColumnAlign.Default, true); Cls.Grid.Options.SelectedRow(this.gridView2); //Cls.Grid.Options.EmbeddedNavigater(this.grid2); Cls.Grid.Options.Footer(gridView2, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.grid2.DataSource = dt2; //워터파크 -> 부대시설로 변경 dt3.Columns.Add("UNIT_AMT", typeof(decimal)); dt3.Columns.Add("APPLY_AMT", typeof(decimal)); dt3.Columns.Add("SALE_AMT", typeof(decimal)); GridStyle gs3 = new GridStyle(this.grid3, this.gridView3); gs3.AddColumn("일 자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs3.AddColumn("시 간", "ST_TIME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs3.AddColumn("내 용", "MENU_NAME", _ColumnType.Default, 160, _ColumnAlign.Default, true); gs3.AddColumn("인원/인", "PERSON_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("정상요금", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs3.AddColumn("적용요금", "APPLY_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs3.AddColumn("금 액", "SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true); gs3.AddColumn("비 고", "RMRK", _ColumnType.Default, 200, _ColumnAlign.Default, true); Cls.Grid.Options.SelectedRow(this.gridView3); //Cls.Grid.Options.EmbeddedNavigater(this.grid3); Cls.Grid.Options.Footer(gridView3, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.grid3.DataSource = dt3; //연회장 dt4.Columns.Add("UNIT_AMT", typeof(decimal)); dt4.Columns.Add("APPLY_AMT", typeof(decimal)); dt4.Columns.Add("SALE_AMT", typeof(decimal)); GridStyle gs4 = new GridStyle(this.grid4, this.gridView4); gs4.AddColumn("일 자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs4.AddColumn("시 간", "ST_TIME", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs4.AddColumn("장 소", "MENU_NAME", _ColumnType.Default, 160, _ColumnAlign.Default, true); gs4.AddColumn("인원/인", "PERSON_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs4.AddColumn("정상요금", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs4.AddColumn("적용요금", "APPLY_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs4.AddColumn("금 액", "SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true); gs4.AddColumn("비 고", "RMRK", _ColumnType.Default, 200, _ColumnAlign.Default, true); Cls.Grid.Options.SelectedRow(this.gridView4); //Cls.Grid.Options.EmbeddedNavigater(this.grid4); Cls.Grid.Options.Footer(gridView4, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.grid4.DataSource = dt4; //기타 dt5.Columns.Add("KEY_SEQ"); dt5.Columns.Add("ST_DATE"); dt5.Columns.Add("ST_TIME"); dt5.Columns.Add("FACILITY_NAME"); dt5.Columns.Add("MENU_NAME"); dt5.Columns.Add("UNIT_AMT"); dt5.Columns.Add("SALE_AMT"); dt5.Columns.Add("PERSON_CNT"); GridStyle gs5 = new GridStyle(this.grid5, this.gridView5); gs5.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("사용일자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("시간", "ST_TIME", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("메뉴", "MENU_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("정상단가", "UNIT_AMT", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("판매단가", "SALE_AMT", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs5.AddColumn("인원", "PERSON_CNT", _ColumnType.Default, 100, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridView4); //Cls.Grid.Options.EmbeddedNavigater(this.grid4); //Cls.Grid.Options.FilterRow(this.gridView1, true); //Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum); this.grid4.DataSource = dt4; dttot.Columns.Add("TOT_AMT", typeof(decimal)); }
private void SetDataTable() { dtFacilityRsv.Columns.Add("STAY_CODE"); dtFacilityRsv.Columns.Add("STAY_CODE_NAME"); dtFacilityRsv.Columns.Add("FACILITY_RSV_NO"); dtFacilityRsv.Columns.Add("FACILITY_RSV_NO_OUT"); dtFacilityRsv.Columns.Add("RSV_KEY_SEQ"); dtFacilityRsv.Columns.Add("RSV_NO"); dtFacilityRsv.Columns.Add("RSV_NO_OUT"); dtFacilityRsv.Columns.Add("CALN_DATE"); dtFacilityRsv.Columns.Add("DISP_CALN_DATE"); dtFacilityRsv.Columns.Add("FACILITY_CODE"); dtFacilityRsv.Columns.Add("FACILITY_NAME"); dtFacilityRsv.Columns.Add("PRODUCT_GBN_KEY"); dtFacilityRsv.Columns.Add("PRODUCT_GBN_NAME"); dtFacilityRsv.Columns.Add("TIME_SEQ"); dtFacilityRsv.Columns.Add("START_TIME"); dtFacilityRsv.Columns.Add("DISP_START_TIME"); dtFacilityRsv.Columns.Add("SALE_QTY", typeof(decimal)); dtFacilityRsv.Columns.Add("PERSON_CNT", typeof(decimal)); dtFacilityRsv.Columns.Add("TABLE_QTY", typeof(decimal)); dtFacilityRsv.Columns.Add("MENU_CODE"); dtFacilityRsv.Columns.Add("MENU_NAME"); dtFacilityRsv.Columns.Add("STND_AMT", typeof(decimal)); dtFacilityRsv.Columns.Add("DC_RATE", typeof(double)); dtFacilityRsv.Columns.Add("APP_AMT", typeof(decimal)); dtFacilityRsv.Columns.Add("SALE_AMT", typeof(decimal)); dtFacilityRsv.Columns.Add("GUEST_NAME"); dtFacilityRsv.Columns.Add("MOBILE_TEL"); dtFacilityRsv.Columns.Add("RMRK"); dtFacilityRsv.Columns.Add("U_DATE"); dtFacilityRsv.Columns.Add("GUEST_TYPE_NAME"); dtFacilityRsv.Columns.Add("PKG_NAME"); GridStyle gsFacilityRsv = new GridStyle(this.gridFacilityRsv, this.gridViewFacilityRsv); gsFacilityRsv.AddColumn("투숙구분", "STAY_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Left, true); gsFacilityRsv.AddColumn("예약번호", "RSV_NO_OUT", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("영업장예약번호", "FACILITY_RSV_NO_OUT", _ColumnType.Default, 70, _ColumnAlign.Center, false); gsFacilityRsv.AddColumn("이용일자", "DISP_CALN_DATE", _ColumnType.DateTime, 70, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("예약구분", "PRODUCT_GBN_NAME", _ColumnType.ComboBox, 100, _ColumnAlign.Left, true); gsFacilityRsv.AddColumn("시간타임", "DISP_START_TIME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("수량", "SALE_QTY", _ColumnType.Numbers, 60, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("인원", "PERSON_CNT", _ColumnType.Numbers, 60, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("동/T수", "TABLE_QTY", _ColumnType.Numbers, 70, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("상품옵션", "MENU_NAME", _ColumnType.Default, 140, _ColumnAlign.Left, true); gsFacilityRsv.AddColumn("할인율", "DC_RATE", _ColumnType.doubles2, 60, _ColumnAlign.Center, true); //gsFacilityRsv.AddColumn("이용금액", "APP_AMT", _ColumnType.Numbers, 70, _ColumnAlign.Right, true); gsFacilityRsv.AddColumn("이용금액", "SALE_AMT", _ColumnType.Numbers, 70, _ColumnAlign.Right, true); gsFacilityRsv.AddColumn("이용자명", "GUEST_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 140, _ColumnAlign.Left, true); gsFacilityRsv.AddColumn("패키지명", "PKG_NAME", _ColumnType.Default, 190, _ColumnAlign.Left, true); gsFacilityRsv.AddColumn("휴대전화", "MOBILE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true); gsFacilityRsv.AddColumn("비고", "RMRK", _ColumnType.Default, 250, _ColumnAlign.Left, true); gsFacilityRsv.AddColumn("입력정보", "U_DATE", _ColumnType.Default, 200, _ColumnAlign.Left, true); Cls.Grid.Options.SelectedRow(this.gridViewFacilityRsv); Cls.Grid.Options.EmbeddedNavigater(this.gridFacilityRsv); Cls.Grid.Options.FilterRow(this.gridViewFacilityRsv, true); Cls.Grid.Options.Footer(gridViewFacilityRsv, DevExpress.Data.SummaryItemType.Sum, "SALE_QTY", "SALE_QTY", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridViewFacilityRsv, DevExpress.Data.SummaryItemType.Sum, "TABLE_QTY", "TABLE_QTY", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridViewFacilityRsv, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum); this.gridFacilityRsv.DataSource = dtFacilityRsv; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { //입금예정 dtForPredestinator.Columns.Add("MEMBER_NO"); dtForPredestinator.Columns.Add("ROOM_TYPE"); dtForPredestinator.Columns.Add("CHECKIN_DATE"); dtForPredestinator.Columns.Add("CHECKOUT_DATE"); dtForPredestinator.Columns.Add("NIGHTS"); dtForPredestinator.Columns.Add("GUEST_NAME"); dtForPredestinator.Columns.Add("AMT_DATE"); dtForPredestinator.Columns.Add("RSV_AMT", typeof(decimal)); dtForPredestinator.Columns.Add("AMT_NAME"); dtForPredestinator.Columns.Add("RSV_NO"); dtForPredestinator.Columns.Add("FRONT_USE_YN"); GridStyle gs = new GridStyle(this.gridForPredestinator, this.gridViewForPredestinator); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("예정일자", "AMT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("입금자", "AMT_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("예약금", "RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("박수", "NIGHTS", _ColumnType.Default, 50, _ColumnAlign.Center, true); gs.AddColumn("이용자명", "GUEST_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("객실타입", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("사용여부", "FRONT_USE_YN", _ColumnType.Default, 70, _ColumnAlign.Center, false); Cls.Grid.Options.SelectedRow(this.gridViewForPredestinator); Cls.Grid.Options.EmbeddedNavigater(this.gridForPredestinator); Cls.Grid.Options.FilterRow(this.gridViewForPredestinator, true); Cls.Grid.Options.Footer(gridViewForPredestinator, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); this.gridForPredestinator.DataSource = dtForPredestinator; //현금 dtForCash.Columns.Add("AMT_DATE"); dtForCash.Columns.Add("RSV_AMT", typeof(decimal)); dtForCash.Columns.Add("AMT_NAME"); dtForCash.Columns.Add("RSV_NO"); dtForCash.Columns.Add("FRONT_USE_YN"); dtForCash.Columns.Add("USE_RSV_AMT", typeof(decimal)); gs = new GridStyle(this.gridForCash, this.gridViewForCash); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금일자", "AMT_DATE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금자", "AMT_NAME", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("입금금액", "RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용금액", "USE_RSV_AMT", _ColumnType.Default, 90, _ColumnAlign.Right, true); gs.AddColumn("사용여부", "FRONT_USE_YN", _ColumnType.Default, 70, _ColumnAlign.Center, false); Cls.Grid.Options.SelectedRow(this.gridViewForCash); Cls.Grid.Options.EmbeddedNavigater(this.gridForCash); Cls.Grid.Options.FilterRow(this.gridViewForCash, true); Cls.Grid.Options.Footer(gridViewForCash, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridViewForCash, DevExpress.Data.SummaryItemType.Sum, "USE_RSV_AMT", "USE_RSV_AMT", SummaryFormat.Sum); this.gridForCash.DataSource = dtForCash; //예금 dtForDeposit.Columns.Add("AMT_DATE"); dtForDeposit.Columns.Add("RSV_AMT", typeof(decimal)); dtForDeposit.Columns.Add("AMT_NAME"); dtForDeposit.Columns.Add("RSV_NO"); dtForDeposit.Columns.Add("FRONT_USE_YN"); dtForDeposit.Columns.Add("USE_RSV_AMT", typeof(decimal)); gs = new GridStyle(this.gridForDeposit, this.gridViewForDeposit); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금일자", "AMT_DATE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금자", "AMT_NAME", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("입금금액", "RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용금액", "USE_RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용여부", "FRONT_USE_YN", _ColumnType.Default, 70, _ColumnAlign.Center, false); Cls.Grid.Options.SelectedRow(this.gridViewForDeposit); Cls.Grid.Options.EmbeddedNavigater(this.gridForDeposit); Cls.Grid.Options.FilterRow(this.gridViewForDeposit, true); Cls.Grid.Options.Footer(gridViewForDeposit, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridViewForDeposit, DevExpress.Data.SummaryItemType.Sum, "USE_RSV_AMT", "USE_RSV_AMT", SummaryFormat.Sum); this.gridForDeposit.DataSource = dtForDeposit; //신용카드 dtForCreditcard.Columns.Add("AMT_DATE"); dtForCreditcard.Columns.Add("RSV_AMT", typeof(decimal)); dtForCreditcard.Columns.Add("AMT_NAME"); dtForCreditcard.Columns.Add("RSV_NO"); dtForCreditcard.Columns.Add("FRONT_USE_YN"); dtForCreditcard.Columns.Add("USE_RSV_AMT", typeof(decimal)); gs = new GridStyle(this.gridForCreditcard, this.gridViewForCreditcard); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금일자", "AMT_DATE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금자", "AMT_NAME", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("입금금액", "RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용금액", "USE_RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용여부", "FRONT_USE_YN", _ColumnType.Default, 70, _ColumnAlign.Center, false); Cls.Grid.Options.SelectedRow(this.gridViewForCreditcard); Cls.Grid.Options.EmbeddedNavigater(this.gridForCreditcard); Cls.Grid.Options.FilterRow(this.gridViewForCreditcard, true); Cls.Grid.Options.Footer(gridViewForCreditcard, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridViewForCreditcard, DevExpress.Data.SummaryItemType.Sum, "USE_RSV_AMT", "USE_RSV_AMT", SummaryFormat.Sum); this.gridForCreditcard.DataSource = dtForCreditcard; //예약번호 미확인 dtForUnconfirmed.Columns.Add("AMT_DATE"); dtForUnconfirmed.Columns.Add("RSV_AMT", typeof(decimal)); dtForUnconfirmed.Columns.Add("AMT_NAME"); dtForUnconfirmed.Columns.Add("RSV_NO"); dtForUnconfirmed.Columns.Add("FRONT_USE_YN"); dtForUnconfirmed.Columns.Add("USE_RSV_AMT", typeof(decimal)); gs = new GridStyle(this.gridForUnconfirmed, this.gridViewForUnconfirmed); gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금일자", "AMT_DATE", _ColumnType.Default, 90, _ColumnAlign.Center, true); gs.AddColumn("입금자", "AMT_NAME", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("입금금액", "RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용금액", "USE_RSV_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true); gs.AddColumn("사용여부", "FRONT_USE_YN", _ColumnType.Default, 90, _ColumnAlign.Center, false); Cls.Grid.Options.SelectedRow(this.gridViewForUnconfirmed); Cls.Grid.Options.EmbeddedNavigater(this.gridForUnconfirmed); Cls.Grid.Options.FilterRow(this.gridViewForUnconfirmed, true); Cls.Grid.Options.Footer(gridViewForUnconfirmed, DevExpress.Data.SummaryItemType.Sum, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridViewForUnconfirmed, DevExpress.Data.SummaryItemType.Sum, "USE_RSV_AMT", "USE_RSV_AMT", SummaryFormat.Sum); this.gridForUnconfirmed.DataSource = dtForUnconfirmed; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt1.Columns.Add("DCCOUPON_NO"); dt1.Columns.Add("MEMBER_NO"); dt1.Columns.Add("MEMBER_NAME"); dt1.Columns.Add("GUEST_NAME"); dt1.Columns.Add("GUEST_TYPE"); dt1.Columns.Add("GUEST_TYPE_NAME"); dt1.Columns.Add("USE_DATE_FROM"); dt1.Columns.Add("USE_DATE_TO"); dt1.Columns.Add("REQ_EMP_NO"); dt1.Columns.Add("REQ_EMP_NAME"); dt1.Columns.Add("ISSUE_EMP_NO"); dt1.Columns.Add("ISSUE_EMP_NAME"); dt1.Columns.Add("ISSUE_CODE"); dt1.Columns.Add("ISSUE_NAME"); dt1.Columns.Add("USE_QTY", typeof(decimal)); dt1.Columns.Add("RMRK"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("우대번호", "DCCOUPON_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("회원명", "MEMBER_NAME", _ColumnType.Default, 60, _ColumnAlign.Center, true); gs.AddColumn("대상자명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("고객유형", "GUEST_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("유효기간FROM", "USE_DATE_FROM", _ColumnType.Default, 120, _ColumnAlign.Center, true); gs.AddColumn("유효기간TO", "USE_DATE_TO", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs.AddColumn("신청자명", "REQ_EMP_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급자명", "ISSUE_EMP_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("발급사유", "ISSUE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("사용인원", "USE_QTY", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); this.grid.DataSource = dt1; dt2_All.Columns.Add("DCCOUPON_NO"); dt2_All.Columns.Add("FACILITY_TYPE"); dt2_All.Columns.Add("FACILITY_TYPE_NAME"); dt2_All.Columns.Add("DC_RATE", typeof(decimal)); dt2 = dt2_All.Clone(); GridStyle gs1 = new GridStyle(this.grid2, this.gridView2); gs1.AddColumn("우대번호", "DCCOUPON_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs1.AddColumn("영업장타입", "FACILITY_TYPE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true); gs1.AddColumn("할인율", "DC_RATE", _ColumnType.Numbers, 60, _ColumnAlign.Right, true); Cls.Grid.Options.SelectedRow(this.gridView2); Cls.Grid.Options.EmbeddedNavigater(this.grid2); Cls.Grid.Options.FilterRow(this.gridView2, true); this.grid2.DataSource = dt2; dt3_All.Columns.Add("DCCOUPON_NO"); dt3_All.Columns.Add("FACILITY_CODE"); dt3_All.Columns.Add("FACILITY_NAME"); dt3_All.Columns.Add("DC_RATE", typeof(decimal)); dt3_All.Columns.Add("CHARGE_CODE"); dt3_All.Columns.Add("CHARGE_TYPE_NAME"); dt3_All.Columns.Add("DAY_QTY", typeof(decimal)); dt3_All.Columns.Add("YEAR_QTY", typeof(decimal)); GridStyle gs3 = new GridStyle(this.grid3, this.gridView3); gs3.AddColumn("우대번호", "DCCOUPON_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("할인율", "DC_RATE", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs3.AddColumn("지불유형", "CHARGE_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs3.AddColumn("일사용횟수한도", "DAY_QTY", _ColumnType.Numbers, 130, _ColumnAlign.Right, true); gs3.AddColumn("년사용횟수한도", "YEAR_QTY", _ColumnType.Numbers, 130, _ColumnAlign.Right, true); dt3 = dt3_All.Clone(); Cls.Grid.Options.SelectedRow(this.gridView3); Cls.Grid.Options.EmbeddedNavigater(this.grid3); Cls.Grid.Options.FilterRow(this.gridView3, true); this.grid3.DataSource = dt3; }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("SEQ"); dt.Columns.Add("EVENT_NO"); dt.Columns.Add("EVENT_NAME"); dt.Columns.Add("MEMBER_NO"); dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("MARKET_CODE_NAME"); dt.Columns.Add("ADMIT_TOT", typeof(decimal)); dt.Columns.Add("DATE_TERM"); dt.Columns.Add("CONTRACT_AMT", typeof(decimal)); dt.Columns.Add("CONTRACT_FACING_NAME"); GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("연회번호", "EVENT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("연회명", "EVENT_NAME", _ColumnType.Default, 200, _ColumnAlign.Center, true); gs.AddColumn("분류", "MARKET_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("인원", "ADMIT_TOT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("일정", "DATE_TERM", _ColumnType.Default, 200, _ColumnAlign.Center, true); gs.AddColumn("계약총액", "CONTRACT_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true); gs.AddColumn("계약/현장담당", "CONTRACT_FACING_NAME", _ColumnType.Default, 200, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, true); //Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "ADMIT_TOT" , "ADMIT_TOT" , SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "CONTRACT_AMT", "CONTRACT_AMT", SummaryFormat.Sum); this.grid.DataSource = dt; dtDetail.Columns.Add("BIZ_CODE"); dtDetail.Columns.Add("EVENT_NO"); dtDetail.Columns.Add("KEY_SEQ"); //dtDetail.Columns.Add("DISPLAY_SEQ"); dtDetail.Columns.Add("ROOM"); dtDetail.Columns.Add("FB"); //dtDetail.Columns.Add("WB"); dtDetail.Columns.Add("FACILITY"); dtDetail.Columns.Add("BANQUET"); //dtDetail.Columns.Add("ETC"); GridStyle gsDetail = new GridStyle(this.gridDetail, this.gridViewDetail); gsDetail.AddColumn("객실", "ROOM", _ColumnType.Default, 200, _ColumnAlign.Center, true); gsDetail.AddColumn("식음", "FB", _ColumnType.Default, 200, _ColumnAlign.Center, true); //gsDetail.AddColumn("워터파크", "WB" , _ColumnType.Default, 200, _ColumnAlign.Center, true); gsDetail.AddColumn("부대시설", "FACILITY", _ColumnType.Default, 200, _ColumnAlign.Center, true); gsDetail.AddColumn("연회장", "BANQUET", _ColumnType.Default, 200, _ColumnAlign.Center, true); gsDetail.AddColumn("기타", "ETC", _ColumnType.Default, 200, _ColumnAlign.Center, true); Cls.Grid.Options.SelectedRow(this.gridViewDetail); Cls.Grid.Options.EmbeddedNavigater(this.gridDetail); Cls.Grid.Options.FilterRow(this.gridViewDetail, true); gridViewDetail.Columns["ROOM"].Tag = "객실"; gridViewDetail.Columns["FB"].Tag = "식음료"; //gridViewDetail.Columns["WB"] .Tag = "워터파크"; gridViewDetail.Columns["FACILITY"].Tag = "부대시설"; gridViewDetail.Columns["BANQUET"].Tag = "판촉"; gridViewDetail.Columns["ETC"].Tag = "기타"; //Cls.Grid.Options.Footer(gridViewDetail, DevExpress.Data.SummaryItemType.Sum, "ROOM" , "ROOM" , SummaryFormat.Sum); this.gridDetail.DataSource = dtDetail; dtDetailAll = dtDetail.Clone(); }
/// <summary> /// 데이터 테이블을 정의 합니다. /// </summary> private void SetDataTable() { dt.Columns.Add("APPLICATION_NO"); dt.Columns.Add("CONTRACT_NO"); dt.Columns.Add("MEMBER_NAME_KOR"); dt.Columns.Add("PROD_GROUP_CODE_NAME"); dt.Columns.Add("COMMODITY_CODE_NAME"); dt.Columns.Add("PURCHASE_CODE_NAME"); dt.Columns.Add("PAYMENT_CODE_NAME"); dt.Columns.Add("SALE_PROD_NAME"); dt.Columns.Add("FACILITY_CODE"); dt.Columns.Add("FACI_PART"); dt.Columns.Add("ROOM_NO"); dt.Columns.Add("PLAN_AMT_TOT", typeof(decimal)); dt.Columns.Add("AMT_TOT", typeof(decimal)); dt.Columns.Add("REMAIN_AMT_TOT", typeof(decimal)); dt.Columns.Add("PARTITION_CODE_NAME"); dt.Columns.Add("PLAN_DATE"); dt.Columns.Add("PLAN_AMT", typeof(decimal)); dt.Columns.Add("NO_AMT", typeof(decimal)); dt.Columns.Add("AMT_DATE"); dt.Columns.Add("AMT", typeof(decimal)); dt.Columns.Add("AMT_WAY_CODE_NAME"); dt.Columns.Add("CANCEL_DATE"); //조회조건 추가 : 입금일자 - V_DATE_FROM ~ V_DATE_TO //조회항목 추가 : 입금수단 - AMT_WAY_CODE_NAME GridStyle gs = new GridStyle(this.grid, this.gridView); gs.AddColumn("계약번호", "APPLICATION_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("계약번호", "CONTRACT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("계약자명", "MEMBER_NAME_KOR", _ColumnType.Default, 90, _ColumnAlign.Left, true); gs.AddColumn("상품구분", "PROD_GROUP_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false); gs.AddColumn("상품명", "SALE_PROD_NAME", _ColumnType.Default, 190, _ColumnAlign.Left, true); gs.AddColumn("회원타입", "COMMODITY_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("법인구분", "PURCHASE_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("분납구분", "PAYMENT_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("영업장", "FACILITY_CODE", _ColumnType.Default, 60, _ColumnAlign.Center, false); gs.AddColumn("동", "FACI_PART", _ColumnType.Default, 40, _ColumnAlign.Center, false); gs.AddColumn("호수", "ROOM_NO", _ColumnType.Default, 40, _ColumnAlign.Center, false); gs.AddColumn("입회총액", "PLAN_AMT_TOT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("입금총액", "AMT_TOT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("미수총액", "REMAIN_AMT_TOT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("납부구분", "PARTITION_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true); gs.AddColumn("납부기간", "PLAN_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("입회금액", "PLAN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("입금일자", "AMT_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true); gs.AddColumn("입금금액", "AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("미수금액", "NO_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true); gs.AddColumn("입금수단", "AMT_WAY_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true); //컬럼 정렬 설정 //gridView.OptionsCustomization.AllowSort = false; // gridView.OptionsSelection. Cls.Grid.Options.SelectedRow(this.gridView); Cls.Grid.Options.EmbeddedNavigater(this.grid); Cls.Grid.Options.FilterRow(this.gridView, false); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "PLAN_AMT_TOT", "PLAN_AMT_TOT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT", "AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "REMAIN_AMT_TOT", "REMAIN_AMT_TOT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "PLAN_AMT", "PLAN_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "NO_AMT", "NO_AMT", SummaryFormat.Sum); Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT_TOT", "AMT_TOT", SummaryFormat.Sum); //Cls.Grid.Options.FixedColumn(gridView, new string[]{"NO_AMT", "AMT","PLAN_AMT"} , PositionStyle.Right); this.grid.DataSource = dt; }