/// <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);
        }
示例#4
0
        /// <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;
        }
示例#5
0
        /// <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;
            /**************************************************************************************************/
        }
示例#6
0
        /// <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;
        }
示例#7
0
        /// <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;
        }
示例#8
0
        /// <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);
        }
示例#9
0
        /// <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;
        }
示例#10
0
        /// <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;
            /**************************************************************************************************/
        }
示例#11
0
 static extern bool gimp_image_grid_set_style(Int32 image_ID, GridStyle style);
示例#12
0
        /// <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;
        }
示例#13
0
        /// <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;
        }
示例#14
0
        /// <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;
 }
示例#16
0
        /// <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);
 }
示例#19
0
		/// <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;
            }
        }
示例#21
0
 /// <summary>
 /// 切换网格
 /// </summary>
 /// <param name="gridstyle"></param>
 public void TransformGrid(GridStyle gridstyle)
 {
     gridContext = new GridContext(gridstyle);
     base.Invalidate();
 }
示例#22
0
        /// <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;
            }
        }
示例#23
0
        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);
                }
            }
        }
示例#24
0
 /// <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);
        }
示例#26
0
 public static void SetGridStyle(string name, GridStyle gridStyle)
 {
     _gridStyles[name] = gridStyle;
 }
示例#27
0
 private void ResetStyleRow()
 {
     StyleRow = GridStyle.List;
 }
示例#28
0
        /// <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;
        }
示例#29
0
 private void ResetStyleDataCells()
 {
     StyleDataCells = GridStyle.List;
 }
示例#30
0
        /// <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;
        }
示例#31
0
        /// <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;
        }
示例#32
0
        /// <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;
        }
示例#33
0
        /// <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;
        }
示例#34
0
        /// <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));
        }
示例#35
0
        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;
        }
示例#36
0
        /// <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;
        }
示例#37
0
        /// <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;
        }
示例#38
0
        /// <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();
        }
示例#39
0
        /// <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;
        }