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