/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("EVENT_NO");
dt.Columns.Add("EVENT_NAME");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("DATE_FROM");
dt.Columns.Add("DATE_TO");
dt.Columns.Add("CONFIRM_DATE");
dt.Columns.Add("SALE_QTY", typeof(decimal));
dt.Columns.Add("ROOM_AMT", typeof(decimal));
dt.Columns.Add("FP_AMT", typeof(decimal));
dt.Columns.Add("WT_AMT", typeof(decimal));
dt.Columns.Add("EV_AMT", typeof(decimal));
dt.Columns.Add("ETC_AMT", typeof(decimal));
dt.Columns.Add("TOT_AMT", typeof(decimal));
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("단체번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("단체명", "MEMBER_NAME_KOR", _ColumnType.Default, 100, _ColumnAlign.Left, true);
gs.AddColumn("연회번호", "EVENT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("연회명", "EVENT_NAME", _ColumnType.Default, 100, _ColumnAlign.Left, true);
gs.AddColumn("행사시작일", "DATE_FROM", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("행사종료일", "DATE_TO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("확정일자", "CONFIRM_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("인원", "SALE_QTY", _ColumnType.Numbers, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실", "ROOM_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("식음", "FP_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("부대시설", "FCT_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("연회장", "BQ_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
//gs.AddColumn("워터파크", "WT_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("이벤트", "EV_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("기타", "ETC_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("합계", "TOT_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);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "SALE_QTY", "SALE_QTY", 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, "FP_AMT", "FP_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "FCT_AMT", "FCT_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "BQ_AMT", "BQ_AMT", SummaryFormat.Sum);
//Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "WT_AMT", "WT_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "EV_AMT", "EV_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);
gridView.Columns["ROOM_AMT"].Tag = "객실";
gridView.Columns["FP_AMT"].Tag = "식음료";
gridView.Columns["FCT_AMT"].Tag = "부대시설";
gridView.Columns["BQ_AMT"].Tag = "연회장";
//gridView.Columns["WT_AMT"].Tag = "워터파크";
gridView.Columns["ETC_AMT"].Tag = "기타";
this.grid.DataSource = dt;
}
private void SetDataTable()
{
dtUser.Columns.Add("PROJECT_ID");
dtUser.Columns.Add("PROJECT_NAME");
dtUser.Columns.Add("DETAIL_NAME");
dtUser.Columns.Add("EMP_NO");
dtUser.Columns.Add("EMP_NAME");
GridStyle gsUser = new GridStyle(gridUser, gridViewUser);
gsUser.AddColumn("프로젝트ID", "PROJECT_ID", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsUser.AddColumn("프로젝트이름", "PROJECT_NAME", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsUser.AddColumn("권한이름", "DETAIL_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gsUser.AddColumn("사원번호", "EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsUser.AddColumn("사원이름", "EMP_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gridViewUser.Columns["PROJECT_ID"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
gridViewUser.Columns["PROJECT_ID"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
gridViewUser.Columns["PROJECT_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
gridViewUser.Columns["DETAIL_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
gridViewUser.Columns["EMP_NO"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
gridViewUser.Columns["EMP_NAME"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.True;
this.gridViewUser.OptionsView.AllowCellMerge = true;
Cls.Grid.Options.SelectedRow(gridViewUser);
Cls.Grid.Options.EmbeddedNavigater(gridUser);
Cls.Grid.Options.FilterRow(gridViewUser, true);
this.gridViewUser.OptionsView.ShowGroupPanel = true;
this.gridUser.DataSource = dtUser;
dtMember.Columns.Add("BIZ_CODE");
dtMember.Columns.Add("EMP_NO");
dtMember.Columns.Add("EMP_NAME");
GridStyle gs1 = new GridStyle(gridEmp, gridViewEmp);
gs1.AddColumn("사용자번호", "EMP_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("사용자명", "EMP_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridViewEmp);
Cls.Grid.Options.EmbeddedNavigater(gridEmp);
Cls.Grid.Options.FilterRow(gridViewEmp, true);
this.gridEmp.DataSource = dtMember;
dtProjectRole.Columns.Add("PROJECT_ID");
dtProjectRole.Columns.Add("PROJECT_NAME");
dtProjectRole.Constraints.AddRange(new System.Data.Constraint[] {
new System.Data.UniqueConstraint("PK_PROJECT", new DataColumn[] { dtProjectRole.Columns["PROJECT_ID"] }, true)
});
dtProjectRole_Detail.Columns.Add("PROJECT_ID");
dtProjectRole_Detail.Columns.Add("PROJECT_LEVEL");
dtProjectRole_Detail.Columns.Add("PROJECT_LEVEL_NAME");
dtProjectRole_Detail.Columns.Add("USE_YN");
dtProjectRole_Detail.Constraints.AddRange(new System.Data.Constraint[] {
new System.Data.UniqueConstraint("PK_PROJECT_DETAIL", new DataColumn[] { dtProjectRole_Detail.Columns["PROJECT_ID"],
dtProjectRole_Detail.Columns["PROJECT_LEVEL"] }, true)
});
dtProjectRole_Detail.Constraints.AddRange(new System.Data.Constraint[] {
new System.Data.ForeignKeyConstraint("FK_PROJECT_DETAIL",
new DataColumn[] { dtProjectRole.Columns["PROJECT_ID"] },
new DataColumn[] { dtProjectRole_Detail.Columns["PROJECT_ID"] })
});
GridStyle gs = new GridStyle(gridProject, gridViewProject);
gs.AddColumn("프로젝트ID", "PROJECT_ID", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("프로젝트명", "PROJECT_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridViewProject);
DevExpress.XtraGrid.Views.Grid.GridView[] mView = new DevExpress.XtraGrid.Views.Grid.GridView[1];
mView[0] = new DevExpress.XtraGrid.Views.Grid.GridView();
mView[0].CellValueChanging += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(ZAAI01_CellValueChanging);
GridStyle gs2 = new GridStyle(this.gridProject, mView[0]);
gs2.AddColumn("사용자그룹", "PROJECT_LEVEL_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs2.AddColumn("사용여부", "USE_YN", _ColumnType.CheckBox, 100, _ColumnAlign.Center, true, true);
gs2.AddColumn("", "PROJECT_ID", _ColumnType.Default, 0, _ColumnAlign.Center, false);
gs2.AddColumn("", "PROJECT_LEVEL", _ColumnType.Default, 0, _ColumnAlign.Center, false);
Cls.Grid.Options.SelectedRow(mView[0]);
#region 레벨정보를 생성
Cls.Grid.LevelNode Lnode;
Lnode.LevelGridView = mView;
Lnode.RelationName = new string[] { "권한그룹" };
Lnode.TopGridIndex = new int[] { 0 };
#endregion
#region 데이터 셋에 Relation 정보 생성
DataTable[] nTable = new DataTable[] { dtProjectRole,
dtProjectRole_Detail };
dsProjects.Tables.AddRange(nTable);
dsProjects.Relations.AddRange(new System.Data.DataRelation[] {
new System.Data.DataRelation("권한그룹", new DataColumn[] { dtProjectRole.Columns["PROJECT_ID"] },
new DataColumn[] { dtProjectRole_Detail.Columns["PROJECT_ID"] }, false)
});
#endregion
#region 그리드 욥션설정 Master Detail
this.gridViewProject.OptionsView.ShowIndicator = true;
mView[0].OptionsView.ShowIndicator = true;
BindingSource bindingSource1 = new BindingSource();
bindingSource1.DataSource = dsProjects;
bindingSource1.Position = 0;
this.gridProject.DataMember = "dtProjectRole";
gridProject.DataSource = bindingSource1;
Cls.Grid.MultiGrid.MakeLevel(this.gridProject, Lnode);
this.gridViewProject.OptionsDetail.AllowZoomDetail = true;
gridViewProject.OptionsDetail.AutoZoomDetail = false;
mView[0].OptionsDetail.AllowZoomDetail = true;
mView[0].OptionsDetail.AutoZoomDetail = false;
gridViewProject.OptionsDetail.ShowDetailTabs = false;
mView[0].OptionsCustomization.AllowSort = false;
#endregion
//사업장 매핑
//사원데이터를 가져온다.
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("CHECKOUT_DATE_VIEW");
dt.Columns.Add("ROOM_NO");
dt.Columns.Add("GUEST_NAME");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("ROOM_TYPE");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("CHECKIN_DATE_VIEW");
dt.Columns.Add("NIGHTS", typeof(decimal));
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME");
dt.Columns.Add("BALANCE", typeof(decimal));
dt.Columns.Add("ROOM_AMT", typeof(decimal));
dt.Columns.Add("TEL_AMT", typeof(decimal));
dt.Columns.Add("ETC_AMT", typeof(decimal));
dt.Columns.Add("ROOM_DEFER", typeof(decimal));
dt.Columns.Add("IPGUM", typeof(decimal));
dt.Columns.Add("RMRK");
dt.Columns.Add("RSV_RMRK");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("예정일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("예정일자", "CHECKOUT_DATE_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("연락처", "MOBILE_TEL", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("입실일자", "CHECKIN_DATE_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 40, _ColumnAlign.Right, true);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("우대구분 부가번호", "MEMBER_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("밸런스", "BALANCE", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("객실료", "ROOM_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("전화료", "TEL_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("기타", "ETC_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("룸후불", "ROOM_DEFER", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("입금", "IPGUM", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("투숙참고사항", "RMRK", _ColumnType.Default, 150, _ColumnAlign.Left, true);
gs.AddColumn("예약참고사항", "RSV_RMRK", _ColumnType.Default, 150, _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.Count, "ROOM_NO", "ROOM_NO", SummaryFormat.Count);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "BALANCE", "BALANCE", 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, "TEL_AMT", "TEL_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, "ROOM_DEFER", "ROOM_DEFER", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "IPGUM", "IPGUM", SummaryFormat.Sum);
this.grid.DataSource = dt;
StyleFormatCondition condition = new DevExpress.XtraGrid.StyleFormatCondition();
condition.Appearance.ForeColor = Color.Red;
condition.Column = this.gridView.Columns["BALANCE"];
condition.ApplyToRow = false;
condition.Appearance.Options.UseFont = true;
condition.Appearance.Options.UseForeColor = true;
condition.Appearance.Font = new System.Drawing.Font("굴림체", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
condition.Condition = FormatConditionEnum.Expression;
condition.Expression = "BALANCE >= 0";
gridView.FormatConditions.Add(condition);
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("TASK_DATE");
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("MNG_NO");
dt.Columns.Add("MNG_SEQ");
dt.Columns.Add("FROM_ROOM", typeof(decimal));
dt.Columns.Add("FROM_GUEST_NAME");
dt.Columns.Add("ROOM_TYPE");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("NIGHTS", typeof(decimal));
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME");
dt.Columns.Add("TRANS_AMT", typeof(decimal));
dt.Columns.Add("TO_ROOM");
dt.Columns.Add("TO_GUEST_NAME");
dt.Columns.Add("U_DATE");
dt.Columns.Add("U_EMP_NO");
dt.Columns.Add("OUT_CODE");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("영업일자", "TASK_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실번호", "FROM_ROOM", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙객명", "FROM_GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("대체금액", "TRANS_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("이체객실", "TO_ROOM", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙객명", "TO_GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("이체시간", "U_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("담당자", "U_EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("퇴실여부(Y:퇴실, N:재실, C:등록취소)", "OUT_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
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, "TRANS_AMT", "TRANS_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블 바인딩
/// </summary>
private void SetDataTable1()
{
try
{
//[사원정보]
dtMember.Columns.Add("EMP_NO");
dtMember.Columns.Add("EMP_NAME");
GridStyle gs1 = new GridStyle(this.gridEmp, this.gridViewEmp);
gs1.AddColumn("사용자번호", "EMP_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("사용자명", "EMP_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridViewEmp);
Cls.Grid.Options.EmbeddedNavigater(gridEmp);
Cls.Grid.Options.FilterRow(gridViewEmp, true);
this.gridEmp.DataSource = dtMember;
//////////////////////////////////////////////////////////////////////////////////////////////////////
//[사업장정보]
dtCompany.Columns.Add("CHK");
dtCompany.Columns.Add("BIZ_CODE");
dtCompany.Columns.Add("BIZ_NAME");
dtCompany.Columns.Add("WITHIN_COMPANY");
GridStyle gsCompany = new GridStyle(this.gridCompany, this.gridViewCompany);
gsCompany.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true);
gsCompany.AddColumn("코드", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsCompany.AddColumn("사업장", "BIZ_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsCompany.AddColumn("권한", "WITHIN_COMPANY", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridViewCompany);
Cls.Grid.Options.EmbeddedNavigater(gridCompany);
//Cls.Grid.Options.FilterRow(gridViewCompany, true);
this.gridCompany.DataSource = dtCompany;
//////////////////////////////////////////////////////////////////////////////////////////////////////
//[프로젝트정보]
dtProject.Columns.Add("CHK");
dtProject.Columns.Add("PROJECT_ID");
dtProject.Columns.Add("PROJECT_NAME");
dtProject.Columns.Add("PROJECT_PART");
GridStyle gsProject = new GridStyle(this.gridProject, this.gridViewProject);
gsProject.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true);
gsProject.AddColumn("코드", "PROJECT_ID", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsProject.AddColumn("프로젝", "PROJECT_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridViewProject);
Cls.Grid.Options.EmbeddedNavigater(gridProject);
//Cls.Grid.Options.FilterRow(gridViewProject , true);
this.gridProject.DataSource = dtProject;
//////////////////////////////////////////////////////////////////////////////////////////////////////
//[권한매핑정보]
dtMapping.Columns.Add("BIZ_CODE");
dtMapping.Columns.Add("BIZ_NAME");
dtMapping.Columns.Add("EMP_NO");
dtMapping.Columns.Add("PROJECT_ID");
dtMapping.Columns.Add("PROJECT_NAME");
GridStyle gsMapping = new GridStyle(this.gridMapping, this.gridViewMapping);
gsMapping.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true);
gsMapping.AddColumn("사업장", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsMapping.AddColumn("사업장명", "BIZ_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsMapping.AddColumn("프로젝트ID", "PROJECT_ID", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsMapping.AddColumn("프로젝트명", "PROJECT_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsMapping.AddColumn("사용자번호", "EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsMapping.AddColumn("사용자명", "EMP_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridViewMapping);
Cls.Grid.Options.EmbeddedNavigater(gridProject);
Cls.Grid.Options.FilterRow(gridViewMapping, true);
this.gridMapping.DataSource = dtMapping;
//////////////////////////////////////////////////////////////////////////////////////////////////////
//사업장별 소속사원정보
dtCompanyWithinEmp.Columns.Add("CHK");
dtCompanyWithinEmp.Columns.Add("BIZ_CODE");
dtCompanyWithinEmp.Columns.Add("EMP_NO");
dtCompanyWithinEmp.Columns.Add("EMP_NAME");
//////////////////////////////////////////////////////////////////////////////////////////////////////
//DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit chkMember = gridViewEmp.Columns["CHK"].ColumnEdit as DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit;
//DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit chkCompany = gridViewCompany.Columns["CHK"].ColumnEdit as DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit;
//DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit chkProject = gridViewProject.Columns["CHK"].ColumnEdit as DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit;
//DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit chkMapping = gridViewMapping.Columns["CHK"].ColumnEdit as DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit;
Cls.Grid.Options.SetColumnColor(this.gridViewCompany,
StyleFormatConditionType.Row,
this.gridViewCompany.Columns["WITHIN_COMPANY"],
DevExpress.XtraGrid.FormatConditionEnum.Equal,
Color.Goldenrod,
"Y"
);
DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit chkCompany = gridViewCompany.Columns["CHK"].ColumnEdit as DevExpress.XtraEditors.Repository.RepositoryItemCheckEdit;
chkCompany.CheckedChanged += new EventHandler(chkCompany_CheckedChanged);
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("RSAMT_INFO");
dt.Columns.Add("REAMT_NO");
dt.Columns.Add("RSV_NO");
dt.Columns.Add("RSV_NO_VIEW");
dt.Columns.Add("RSV_INFO");
dt.Columns.Add("RSV_AMT", typeof(decimal));
dt.Columns.Add("PENALTY_AMT", typeof(decimal));
dt.Columns.Add("APP_DATE");
dt.Columns.Add("APP_DATE_VIEW");
dt.Columns.Add("ACCEPT_YN");
dt.Columns.Add("ACCEPT_DATE");
dt.Columns.Add("ACCEPT_DATE_VIEW");
dt.Columns.Add("PENALTY_EMP_NO");
dt.Columns.Add("PENALTY_EMP_NAME");
dt.Columns.Add("PENALTY_RMRK");
dt.Columns.Add("BANK_CODE");
dt.Columns.Add("BANK_CODE_NAME");
dt.Columns.Add("BANK_NO");
dt.Columns.Add("DEPOSITOR");
dt.Columns.Add("REFUND_AMT", typeof(decimal));
dt.Columns.Add("REFUND_DATE");
dt.Columns.Add("REFUND_DATE_VIEW");
dt.Columns.Add("REFUND_YN");
dt.Columns.Add("REFUND_EMP_NO");
dt.Columns.Add("REFUND_EMP_NAME");
dt.Columns.Add("REFUND_RMRK");
//그리드 스타일을 구성합니다.
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("환불번호", "REAMT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("등록일자", "APP_DATE_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("환불신청", "ACCEPT_YN", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("환불확정", "REFUND_YN", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("예약번호", "RSV_NO_VIEW", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("예약사항", "RSV_INFO", _ColumnType.Default, 200, _ColumnAlign.Left, true);
gs.AddColumn("예약금", "RSV_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("신청일자", "ACCEPT_DATE_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("신청사원", "PENALTY_EMP_NAME", _ColumnType.Default, 70, _ColumnAlign.Left, true);
gs.AddColumn("환불은행", "BANK_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("환불계좌", "BANK_NO", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("예금주", "DEPOSITOR", _ColumnType.Default, 70, _ColumnAlign.Left, true);
gs.AddColumn("환불금", "REFUND_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("환불사원", "REFUND_EMP_NAME", _ColumnType.Default, 70, _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, "RSV_AMT", "RSV_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "REFUND_AMT", "REFUND_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("APPLICATION_NO");
dt.Columns.Add("CONTRACT_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("PROD_GROUP_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("PURCHASE_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, 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, 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);
gs.AddColumn("법인구분", "PURCHASE_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, false);
gs.AddColumn("해약일자", "CANCEL_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, false);
//컬럼 정렬 설정
gridView.OptionsCustomization.AllowSort = false;
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;
}
/// <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("SALEINLOT_CNT_NAME");
dt.Columns.Add("PURCHASE_CODE_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("CHANGE_DATE");
dt.Columns.Add("DM_CODE_NAME");
dt.Columns.Add("ADDRESS");
dt.Columns.Add("CONT_ITEM1");
dt.Columns.Add("CONT_ITEM2");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("HOME_TEL");
dt.Columns.Add("OFFICE_TEL");
dt.Columns.Add("HOME_FAX");
dt.Columns.Add("OFFICE_FAX");
dt.Columns.Add("CHARGE_NAME");
dt.Columns.Add("CHARGE_TEL");
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("분양차수", "SALEINLOT_CNT_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("영업장", "FACILITY_CODE", _ColumnType.Default, 60, _ColumnAlign.Center, false);
gs.AddColumn("동", "FACI_PART", _ColumnType.Default, 50, _ColumnAlign.Center, false);
gs.AddColumn("호수", "ROOM_NO", _ColumnType.Default, 50, _ColumnAlign.Center, true);
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("GC여부", "CONT_ITEM1", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("계약서번호", "CONT_ITEM2", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("휴대전화", "MOBILE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, 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("DM구분", "DM_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("주소", "ADDRESS", _ColumnType.Default, 250, _ColumnAlign.Left, true);
gs.AddColumn("담당자", "CHARGE_NAME", _ColumnType.Default, 70, _ColumnAlign.Left, true);
gs.AddColumn("담당자전화", "CHARGE_TEL", _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, "PLAN_AMT", "PLAN_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT", "AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "NO_AMT", "NO_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
//콘도
dtCondo.Columns.Add("GUBUN1");
dtCondo.Columns.Add("GUBUN2");
dtCondo.Columns.Add("TOT", typeof(decimal));
dtCondo.Columns.Add("A", typeof(decimal));
dtCondo.Columns.Add("B", typeof(decimal));
dtCondo.Columns.Add("C1", typeof(decimal));
dtCondo.Columns.Add("C2", typeof(decimal));
dtCondo.Columns.Add("D", typeof(decimal));
dtCondo.Columns.Add("E", typeof(decimal));
dtCondo.Columns.Add("O", typeof(decimal));
//워터파크
dtWp.Columns.Add("PART_1");
dtWp.Columns.Add("PART_2");
dtWp.Columns.Add("PART_3");
dtWp.Columns.Add("TOTAL", typeof(decimal));
dtWp.Columns.Add("WP", typeof(decimal));
dtWp.Columns.Add("SPA", typeof(decimal));
dtWp.Columns.Add("RENTAL", typeof(decimal));
dtWp.Columns.Add("ETC", typeof(decimal));
//부대업장
dtBoo.Columns.Add("FACILITY_NAME");
dtBoo.Columns.Add("PART");
dtBoo.Columns.Add("SALE_AMT", typeof(decimal));
dtBoo.Columns.Add("RENTAL_AMT", typeof(decimal));
dtBoo.Columns.Add("RMRK");
//총 매출
dtTot.Columns.Add("DAY_SALE_AMT_D", typeof(decimal));
dtTot.Columns.Add("DAY_SALE_AMT_R", typeof(decimal));
dtTot.Columns.Add("DAY_SALE_AMT", typeof(decimal));
dtTot.Columns.Add("DAY_SALE_AMT_S", typeof(decimal));
dtTot.Columns.Add("MON_SALE_AMT_S", typeof(decimal));
dtTot.Columns.Add("YEAR_SALE_AMT_S", typeof(decimal));
GridStyle gsCondo = new GridStyle(this.gridCondo, this.gridViewCondo);
gsCondo.AddColumn("구분", "GUBUN1", _ColumnType.Default, 60, _ColumnAlign.Center, true);
gsCondo.AddColumn(" ", "GUBUN2", _ColumnType.Default, 50, _ColumnAlign.Center, true);
gsCondo.AddColumn("합계", "TOT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("골드(A)", "A", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("플래티늄(B)", "B", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("다이아몬드1(C1)", "C1", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("다이아몬드2(C2)", "C2", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("포시즌1(D)", "D", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("포시즌2(E)", "E", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsCondo.AddColumn("기타", "O", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
this.gridViewCondo.Columns["GUBUN1"].SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
this.gridViewCondo.Columns["GUBUN2"].SortOrder = DevExpress.Data.ColumnSortOrder.Descending;
GridStyle gsWp = new GridStyle(this.gridWp, this.gridViewWp);
gsWp.AddColumn("구분", "PART_1", _ColumnType.Default, 60, _ColumnAlign.Center, true);
gsWp.AddColumn(" ", "PART_2", _ColumnType.Default, 40, _ColumnAlign.Center, true);
gsWp.AddColumn(" ", "PART_3", _ColumnType.Default, 40, _ColumnAlign.Center, true);
gsWp.AddColumn("합계", "TOTAL", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsWp.AddColumn("워터파크", "WP", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsWp.AddColumn("스파", "SPA", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsWp.AddColumn("라이프렌탈샾", "RENTAL", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsWp.AddColumn("기타", "ETC", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
GridStyle gsBoo = new GridStyle(this.gridBoo, this.gridViewBoo);
gsBoo.AddColumn("구분", "FACILITY_NAME", _ColumnType.Default, 60, _ColumnAlign.Center, true);
gsBoo.AddColumn(" ", "PART", _ColumnType.Default, 40, _ColumnAlign.Center, true);
gsBoo.AddColumn("매출액", "SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsBoo.AddColumn("임대수익", "RENTAL_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsBoo.AddColumn("비고", "RMRK", _ColumnType.Default, 120, _ColumnAlign.Center, true);
GridStyle gsTot = new GridStyle(this.gridTot, this.gridViewTot);
gsTot.AddColumn("직영매장", "DAY_SALE_AMT_D", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsTot.AddColumn("임대매장", "DAY_SALE_AMT_R", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsTot.AddColumn("총계", "DAY_SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsTot.AddColumn("금일(순매출)", "DAY_SALE_AMT_S", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsTot.AddColumn("월계(순매출)", "MON_SALE_AMT_S", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsTot.AddColumn("년계(순매출)", "YEAR_SALE_AMT_S", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
//컬럼 정렬 설정
//gridViewCondo.OptionsCustomization.AllowSort = false;
Cls.Grid.Options.SelectedRow(this.gridViewCondo);
Cls.Grid.Options.EmbeddedNavigater(this.gridCondo);
Cls.Grid.Options.FilterRow(this.gridViewCondo, false);
Cls.Grid.Options.SelectedRow(this.gridViewWp);
Cls.Grid.Options.EmbeddedNavigater(this.gridWp);
Cls.Grid.Options.FilterRow(this.gridViewWp, false);
Cls.Grid.Options.SelectedRow(this.gridViewBoo);
Cls.Grid.Options.EmbeddedNavigater(this.gridBoo);
Cls.Grid.Options.FilterRow(this.gridViewBoo, false);
Cls.Grid.Options.SelectedRow(this.gridViewTot);
Cls.Grid.Options.EmbeddedNavigater(this.gridTot);
Cls.Grid.Options.FilterRow(this.gridViewTot, false);
this.gridCondo.DataSource = dtCondo;
this.gridWp.DataSource = dtWp;
this.gridBoo.DataSource = dtBoo;
this.gridTot.DataSource = dtTot;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("CHK");
dt.Columns.Add("CUST_NO");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("ID_NO");
dt.Columns.Add("HOME_TEL");
dt.Columns.Add("OFFICE_TEL");
dt.Columns.Add("CHARGE_NAME");
dt.Columns.Add("CHARGE_TEL");
dt.Columns.Add("ID_NO_MASK");
dt.Columns.Add("SMS_YN");
dt.Columns.Add("SMS_YN_NAME");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("POST");
dt.Columns.Add("POST_MASK");
dt.Columns.Add("ADDRESS");
dt.Columns.Add("ERROR");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("선택", "CHK", _ColumnType.CheckBox, 40, _ColumnAlign.Center, true, true);
gs.AddColumn("고객번호", "CUST_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 60, _ColumnAlign.Center, true, true);
gs.AddColumn("주민/사업자", "ID_NO", _ColumnType.Default, 120, _ColumnAlign.Center, false);
gs.AddColumn("주민/사업자", "ID_NO_MASK", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gs.AddColumn("자택전화", "HOME_TEL", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("직장전화", "OFFICE_TEL", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("담당자명", "CHARGE_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("담당전화", "CHARGE_TEL", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("SMS수신", "SMS_YN", _ColumnType.Default, 60, _ColumnAlign.Center, true);
gs.AddColumn("SMS수신", "SMS_YN_NAME", _ColumnType.Default, 60, _ColumnAlign.Center, false);
gs.AddColumn("SMS번호", "MOBILE_TEL", _ColumnType.Default, 110, _ColumnAlign.Center, true, true);
gs.AddColumn("우편번호", "POST", _ColumnType.Default, 70, _ColumnAlign.Center, true, true);
gs.AddColumn("주소", "ADDRESS", _ColumnType.Default, 520, _ColumnAlign.Left, true, true);
gridView.Columns["CHK"].OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
Cls.Grid.Options.SetColumnColor(this.gridView,
StyleFormatConditionType.Column,
gridView.Columns["MEMBER_NAME_KOR"],
DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
Color.DarkOrange,
null);
Cls.Grid.Options.SetColumnColor(this.gridView,
StyleFormatConditionType.Column,
gridView.Columns["MOBILE_TEL"],
DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
Color.DarkOrange,
null);
Cls.Grid.Options.SetColumnColor(this.gridView,
StyleFormatConditionType.Column,
gridView.Columns["POST"],
DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
Color.DarkOrange,
null);
Cls.Grid.Options.SetColumnColor(this.gridView,
StyleFormatConditionType.Column,
gridView.Columns["ADDRESS"],
DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
Color.DarkOrange,
null);
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.gridView, true);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("APPLICATION_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("SALEINLOT_CNT");
dt.Columns.Add("SALEINLOT_CNT_NAME");
dt.Columns.Add("SALE_AMT", typeof(decimal));
dt.Columns.Add("AMT", typeof(decimal));
dt.Columns.Add("PARTITION_CODE");
dt.Columns.Add("PARTITION_CODE_NAME");
dt.Columns.Add("PLAN_DATE_MASK");
dt.Columns.Add("PLAN_AMT_LAST", typeof(decimal));
dt.Columns.Add("PLAN_AMT", typeof(decimal));
dt.Columns.Add("PLAN_AMT_TOT", typeof(decimal));
dt.Columns.Add("CANCEL_DATE");
dt.Columns.Add("PURCHASE_CODE_NAME");
dt.Columns.Add("PROD_GROUP_CODE_NAME");
dt.Columns.Add("CONTRACT_NO");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("입회계약번호[YYYYMM+SEQ4]", "APPLICATION_NO", _ColumnType.Default, 200, _ColumnAlign.Center, false);
gs.AddColumn("계약자명", "MEMBER_NAME_KOR", _ColumnType.Default, 200, _ColumnAlign.Left, true);
gs.AddColumn("분양차수", "SALEINLOT_CNT_NAME", _ColumnType.Numbers, 80, _ColumnAlign.Center, true);
gs.AddColumn("총분양금", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("총입금액", "AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("입금구분코드[공통:A0015]", "PARTITION_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("납부구분", "PARTITION_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("납부일자", "PLAN_DATE_MASK", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("미납금액", "PLAN_AMT_LAST", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("예정금액", "PLAN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("청구금액", "PLAN_AMT_TOT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("해약일자", "CANCEL_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("법인구분", "PURCHASE_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("상품구분", "PROD_GROUP_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("계약번호", "CONTRACT_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
//컬럼 정렬 설정
gridView.OptionsCustomization.AllowSort = false;
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);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT", "AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "PLAN_AMT_LAST", "PLAN_AMT_LAST", 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, "PLAN_AMT_TOT", "PLAN_AMT_TOT", SummaryFormat.Sum);
//Cls.Grid.Options.FixedColumn(gridView,new string[]{"PLAN_AMT", "AMT", "NO_AMT"}, PositionStyle.Right);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("CONTRACT_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("PROD_GROUP_CODE_NAME");
dt.Columns.Add("SALE_PROD_NAME");
dt.Columns.Add("CONTRACT_DATE_MASK");
dt.Columns.Add("CANCEL_DATE_MASK");
dt.Columns.Add("TOT_PLAN_AMT", typeof(decimal));
dt.Columns.Add("TOT_AMT", typeof(decimal));
dt.Columns.Add("TOT_RETURN_AMT", typeof(decimal));
dt.Columns.Add("RETURN_DATE_MASK");
dt.Columns.Add("BANK_CODE_NAME");
dt.Columns.Add("BANK_NO");
dt.Columns.Add("RETURN_AMT", typeof(decimal));
dt.Columns.Add("PURCHASE_CODE_NAME");
dt.Columns.Add("CANCEL_DATE");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("계약번호", "CONTRACT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("계약자명", "MEMBER_NAME_KOR", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("상품구분", "PROD_GROUP_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("상품명", "SALE_PROD_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true);
gs.AddColumn("계약일자", "CONTRACT_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("해약일자", "CANCEL_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("총분양금", "TOT_PLAN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("총입금액", "TOT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("총환급액", "TOT_RETURN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("환급은행", "BANK_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("환급계좌", "BANK_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("환급금액", "RETURN_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("법인구분", "PURCHASE_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("해약일자", "CANCEL_DATE", _ColumnType.Default, 100, _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, "TOT_PLAN_AMT", "TOT_PLAN_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "TOT_AMT", "TOT_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "TOT_RETURN_AMT", "TOT_RETURN_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "RETURN_AMT", "RETURN_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("PHOTO", typeof(byte[]));
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("BIRTH_DAY");
dt.Columns.Add("ID_NO");
dt.Columns.Add("HOME_TEL");
dt.Columns.Add("OFFICE_TEL");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("CONT_ITEM1");
dt.Columns.Add("REM_ITEM1");
dt.Columns.Add("REM_ITEM2");
dt.Columns.Add("REM_WEEK");
dt.Columns.Add("REM_WEEKEND");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("사진", "PHOTO", _ColumnType.Picture, 90, _ColumnAlign.Center, true, false, DevExpress.Utils.DefaultBoolean.False);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("생년월일", "BIRTH_DAY", _ColumnType.Default, 70, _ColumnAlign.Center, false);
gs.AddColumn("주민/사업", "ID_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("자택전화", "HOME_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("직장전화", "OFFICE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("휴대전화", "MOBILE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("G.C여부", "CONT_ITEM1", _ColumnType.Default, 65, _ColumnAlign.Center, true);
gs.AddColumn("부킹여부", "REM_ITEM2", _ColumnType.Default, 65, _ColumnAlign.Center, true);
gs.AddColumn("혜택", "REM_ITEM1", _ColumnType.Default, 65, _ColumnAlign.Center, true);
gs.AddColumn("주중", "REM_WEEK", _ColumnType.Default, 200, _ColumnAlign.Left, true);
gs.AddColumn("주말", "REM_WEEKEND", _ColumnType.Default, 200, _ColumnAlign.Left, true);
RepositoryItemPictureEdit photo = (RepositoryItemPictureEdit)gridView.Columns["PHOTO"].ColumnEdit;
photo.CustomHeight = 100;
photo.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Stretch;
this.gridView.OptionsView.RowAutoHeight = true;
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.gridView, false);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dtDeposit.Columns.Add("SSID");
dtDeposit.Columns.Add("SALE_AMT", typeof(decimal));
dtSale.Columns.Add("SSID");
dtSale.Columns.Add("SALE_AMT", typeof(decimal));
dtCancel.Columns.Add("SSID");
dtCancel.Columns.Add("SALE_AMT", typeof(decimal));
//dtBalance.Columns.Add("SSID");
//dtBalance.Columns.Add("SALE_AMT", typeof(decimal));
dtBalance.Columns.Add("D_SALE_AMT", typeof(decimal));
dtBalance.Columns.Add("C_SALE_AMT", typeof(decimal));
dtBalance.Columns.Add("RT_SALE_AMT", typeof(decimal));
dtBalance.Columns.Add("S_SALE_AMT", typeof(decimal));
dtBalance.Columns.Add("TOTAL_SALE_AMT", typeof(decimal));
dtCreditCardCancel.Columns.Add("SSID");
dtCreditCardCancel.Columns.Add("SALE_AMT", typeof(decimal));
GridStyle gsDeposit = new GridStyle(this.gridDeposit, this.gridViewDeposit);
gsDeposit.AddColumn("구분", "SSID", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsDeposit.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
GridStyle gsSale = new GridStyle(this.gridSale, this.gridViewSale);
gsSale.AddColumn("구분", "SSID", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsSale.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
GridStyle gsCancel = new GridStyle(this.gridCancel, this.gridViewCancel);
gsCancel.AddColumn("구분", "SSID", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsCancel.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
GridStyle gsBalance = new GridStyle(this.gridBalance, this.gridViewBalance);
gsBalance.AddColumn("현금 충전분", "D_SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsBalance.AddColumn("현금 환불분 ", "C_SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsBalance.AddColumn("충전 시재", "RT_SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsBalance.AddColumn("정산소 판매분", "S_SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsBalance.AddColumn("정산소 현금 시재", "TOTAL_SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
//gsBalance.AddColumn("구분", "SSID", _ColumnType.Default, 120, _ColumnAlign.Center, true);
//gsBalance.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
GridStyle gsCreditCardCancel = new GridStyle(this.gridCreditCardCancel, this.gridViewCreditCardCancel);
gsCreditCardCancel.AddColumn("구분", "SSID", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsCreditCardCancel.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
//컬럼 정렬 설정
//gridViewDeposit.OptionsCustomization.AllowSort = false;
Cls.Grid.Options.SelectedRow(this.gridViewDeposit);
Cls.Grid.Options.EmbeddedNavigater(this.gridDeposit);
Cls.Grid.Options.FilterRow(this.gridViewDeposit, false);
Cls.Grid.Options.Footer(gridViewDeposit, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
Cls.Grid.Options.SelectedRow(this.gridViewSale);
Cls.Grid.Options.EmbeddedNavigater(this.gridSale);
Cls.Grid.Options.FilterRow(this.gridViewSale, false);
Cls.Grid.Options.Footer(gridViewSale, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
Cls.Grid.Options.SelectedRow(this.gridViewCancel);
Cls.Grid.Options.EmbeddedNavigater(this.gridCancel);
Cls.Grid.Options.FilterRow(this.gridViewCancel, false);
Cls.Grid.Options.Footer(gridViewCancel, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
Cls.Grid.Options.SelectedRow(this.gridViewBalance);
Cls.Grid.Options.EmbeddedNavigater(this.gridBalance);
Cls.Grid.Options.FilterRow(this.gridViewBalance, false);
//Cls.Grid.Options.Footer(gridViewBalance, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
Cls.Grid.Options.SelectedRow(this.gridViewCreditCardCancel);
Cls.Grid.Options.EmbeddedNavigater(this.gridCreditCardCancel);
Cls.Grid.Options.FilterRow(this.gridViewCreditCardCancel, false);
//Cls.Grid.Options.Footer(gridViewCreditCardCancel, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
this.gridDeposit.DataSource = dtDeposit;
this.gridSale.DataSource = dtSale;
this.gridCancel.DataSource = dtCancel;
this.gridBalance.DataSource = dtBalance;
this.gridCreditCardCancel.DataSource = dtCreditCardCancel;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("CUST_NO");
dt.Columns.Add("MEMBER_SEQ");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("MEMBER_NAME_ENG");
dt.Columns.Add("MEMBER_NAME_CHT");
dt.Columns.Add("ID_NO");
dt.Columns.Add("ID_NO_MASK");
dt.Columns.Add("MEMBER_GROUP_CODE");
dt.Columns.Add("MEMBER_GROUP_CODE_NAME");
dt.Columns.Add("CARD_ISSUE_NO");
dt.Columns.Add("ISSUE_SEQ", typeof(decimal));
dt.Columns.Add("REG_DATE");
dt.Columns.Add("REG_DATE_MASK");
dt.Columns.Add("REG_WAY_CODE");
dt.Columns.Add("REG_WAY_CODE_NAME");
dt.Columns.Add("REG_REASON_CODE");
dt.Columns.Add("REG_REASON_CODE_NAME");
dt.Columns.Add("ISSUE_DATE");
dt.Columns.Add("ISSUE_DATE_MASK");
dt.Columns.Add("ISSUE_FEE", typeof(decimal));
dt.Columns.Add("END_DATE");
dt.Columns.Add("END_DATE_MASK");
dt.Columns.Add("USE_YN");
dt.Columns.Add("RMRK");
dt.Columns.Add("IMAGE", typeof(byte[]));
dt.Columns.Add("CONT_REM_NO");
dt.Columns.Add("STND_REM_NO");
dt.Columns.Add("TRANSFER_NO");
dt.Columns.Add("KEY_SEQ");
dt.Columns.Add("AMT_WAY_CODE");
dt.Columns.Add("AMT_WAY_CODE_NAME");
dt.Columns.Add("AMT_DATE");
dt.Columns.Add("AMT_DATE_MASK");
dt.Columns.Add("AMT", typeof(decimal));
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("고객번호", "CUST_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("접수일자", "REG_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("발급일자", "ISSUE_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("사용여부", "USE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("카드번호", "CARD_ISSUE_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gs.AddColumn("발급회차", "ISSUE_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금수단", "AMT_WAY_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금액", "AMT", _ColumnType.Numbers, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금일자", "AMT_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.gridView, true);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("ANAMT_NO");
dt.Columns.Add("AMT_DATE");
dt.Columns.Add("AMT_DATE_MASK");
dt.Columns.Add("AMT_STATUS");
dt.Columns.Add("AMT_STATUS_NAME");
dt.Columns.Add("AMT_NAME");
dt.Columns.Add("AMT", typeof(decimal));
dt.Columns.Add("TRANS_AMT", typeof(decimal));
dt.Columns.Add("AMT_REMAIN", typeof(decimal));
dt.Columns.Add("SALE_DEPT_CODE");
dt.Columns.Add("SALE_DEPT_CODE_NAME");
dt.Columns.Add("AMT_WAY_CODE");
dt.Columns.Add("AMT_WAY_CODE_NAME");
dt.Columns.Add("BANK_CODE");
dt.Columns.Add("BANK_CODE_NAME");
dt.Columns.Add("BANK_NO");
dt.Columns.Add("MEMBER_SEQ");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("ID_NO");
dt.Columns.Add("ID_NO_MASK");
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("HOME_TEL");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("E_MAIL");
dt.Columns.Add("USE_YN");
dt.Columns.Add("USE_YN_NAME");
dt.Columns.Add("RMRK");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("가입금번호", "ANAMT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금일자", "AMT_DATE_MASK", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("입금상태", "AMT_STATUS_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("입금자명", "AMT_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("입금금액", "AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("대체금액", "TRANS_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("대체잔액", "AMT_REMAIN", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("업무구분", "SALE_DEPT_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Left, true);
gs.AddColumn("입금수단", "AMT_WAY_CODE_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
//gs.AddColumn("은행구분" , "BANK_CODE_NAME" , _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("계좌번호", "BANK_NO", _ColumnType.Default, 110, _ColumnAlign.Left, true);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("주민/사업", "ID_NO_MASK", _ColumnType.Default, 100, _ColumnAlign.Left, false);
gs.AddColumn("회원구분", "MEMBER_GROUP_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, false);
gs.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, false);
gs.AddColumn("자택번호", "HOME_TEL", _ColumnType.Default, 100, _ColumnAlign.Left, false);
gs.AddColumn("휴대전화", "MOBILE_TEL", _ColumnType.Default, 100, _ColumnAlign.Left, true);
gs.AddColumn("이메일", "E_MAIL", _ColumnType.Default, 100, _ColumnAlign.Left, false);
gs.AddColumn("사용여부", "USE_YN_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false);
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, "AMT", "AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "TRANS_AMT", "TRANS_AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT_REMAIN", "AMT_REMAIN", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("영업일자", "SALE_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, false);
gs.AddColumn("영업일자", "SALE_DATE_F", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 100, _ColumnAlign.Center, false);
gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("POS NO", "POS_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("BILL NO", "BILL_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("순번", "PAY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("판매금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Center, true);
gs.AddColumn("승인번호", "AGREE_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("승인일자", "AGREE_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, false);
gs.AddColumn("승인일자", "AGREE_DATE_F", _ColumnType.Default, 100, _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, "컬럼명", "필드명", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("WAIT_DATE");
dt.Columns.Add("KEY_SEQ");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("STATUS_CODE");
dt.Columns.Add("STATUS_CODE_NAME");
dt.Columns.Add("ACCEPT_NO");
dt.Columns.Add("GUEST_TYPE");
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("FACILITY_NAME");
dt.Columns.Add("ROOM_TYPE");
dt.Columns.Add("ROOM_TYPE_NAME");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("NIGHTS");
dt.Columns.Add("ROOM_CNT");
dt.Columns.Add("GUEST_NAME");
dt.Columns.Add("GUEST_TEL_NO");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("ACCEPT_NAME");
dt.Columns.Add("ACCEPT_TEL_NO");
dt.Columns.Add("RSV_WAY");
dt.Columns.Add("RSV_NO");
dt.Columns.Add("RMRK");
dt.Columns.Add("U_DATE");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("신청일자", "WAIT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙자명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("전화번호", "GUEST_TEL_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("휴대번호", "MOBILE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("신청자명", "ACCEPT_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("전화번호", "ACCEPT_TEL_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("예약상태", "STATUS_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("객실유형", "ROOM_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 50, _ColumnAlign.Center, true);
gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실수", "ROOM_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Center, true);
gs.AddColumn("비고", "RMRK", _ColumnType.Default, 100, _ColumnAlign.Left, true);
gs.AddColumn("입력정보", "U_DATE", _ColumnType.Default, 120, _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_CNT", "ROOM_CNT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("SALE_AMT", typeof(decimal));
dt.Columns.Add("NET_AMT", typeof(decimal));
dt.Columns.Add("VAT_AMT", typeof(decimal));
dt.Columns.Add("ETC_AMT1", typeof(decimal));
dt.Columns.Add("ETC_AMT2", typeof(decimal));
dt.Columns.Add("RMRK");
dt.Columns.Add("KEY_SEQ");
dt.Columns.Add("SALE_DATE");
dt.Columns.Add("BIZ_CODE");
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("PAY_CODE");
dt.Columns.Add("FACILITY_NAME");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("판매금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("공급가", "NET_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("부가세", "VAT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("기타세금1", "ETC_AMT1", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("기타세금2", "ETC_AMT2", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("참고사항", "RMRK", _ColumnType.Default, 350, _ColumnAlign.Left, true);
gs.AddColumn("지급순번", "KEY_SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("SALE_DATE", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("BIZ_CODE", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("FACILITY_CODE", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("PAY_CODE", "PAY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("FACILITY_NAME", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false);
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.gridView, true);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("CHECK_YN");
dt.Columns.Add("RSV_CODE");
dt.Columns.Add("RSV_CODE_NAME");
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("CHECKIN_DATE_VIEW");
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("CHECKOUT_DATE_VIEW");
dt.Columns.Add("GUEST_NAME");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("RSV_NO");
dt.Columns.Add("RSV_NO_VIEW");
dt.Columns.Add("ROOM_TYPE");
dt.Columns.Add("ROOM_TYPE_NAME");
dt.Columns.Add("ROOM_VIEW");
dt.Columns.Add("ROOM_VIEW_NAME");
dt.Columns.Add("NIGHTS");
dt.Columns.Add("ROOM_CNT");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("선택", "CHECK_YN", _ColumnType.CheckBox, 100, _ColumnAlign.Center, true, true);
gs.AddColumn("예약구분", "RSV_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("예약구분", "RSV_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("입실일자", "CHECKIN_DATE_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGHTS", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("퇴실일자", "CHECKOUT_DATE_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실수", "ROOM_CNT", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙자명", "GUEST_NAME", _ColumnType.Default, 100, _ColumnAlign.Left, true, true);
gs.AddColumn("SMS번호", "MOBILE_TEL", _ColumnType.Default, 100, _ColumnAlign.Center, true, true);
gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("예약번호", "RSV_NO_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("객실평형", "ROOM_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("객실전망", "ROOM_VIEW", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("객실전망", "ROOM_VIEW_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SetColumnColor(this.gridView,
StyleFormatConditionType.Column,
gridView.Columns["GUEST_NAME"],
DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
Color.DarkOrange,
null);
Cls.Grid.Options.SetColumnColor(this.gridView,
StyleFormatConditionType.Column,
gridView.Columns["MOBILE_TEL"],
DevExpress.XtraGrid.FormatConditionEnum.NotEqual,
Color.DarkOrange,
null);
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.gridView, true);
this.grid.DataSource = dt;
gridView.Columns["CHECK_YN"].OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("GUEST_TEL_NO");
dt.Columns.Add("MOBILE_TEL");
dt.Columns.Add("ACCEPT_DATE");
dt.Columns.Add("ACCEPT_NAME");
dt.Columns.Add("RSV_WAY_NAME");
dt.Columns.Add("RSV_NO");
dt.Columns.Add("WISH_CNT", typeof(decimal));
dt.Columns.Add("FACILITY_NAME");
dt.Columns.Add("ROOM_TYPE_NAME");
dt.Columns.Add("CHECKIN_DATE_VIEW");
dt.Columns.Add("CHECKOUT_DATE_VIEW");
dt.Columns.Add("NIGHTS", typeof(decimal));
dt.Columns.Add("WIN_YN");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 90, _ColumnAlign.Left, true);
gs.AddColumn("전화번호", "GUEST_TEL_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("휴대전화", "MOBILE_TEL", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("접수일자", "ACCEPT_DATE", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("접수자명", "ACCEPT_NAME", _ColumnType.Default, 90, _ColumnAlign.Left, true);
gs.AddColumn("예약방법", "RSV_WAY_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 70, _ColumnAlign.Center, false);
gs.AddColumn("지망차수", "WISH_CNT", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
gs.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE_NAME", _ColumnType.Default, 70, _ColumnAlign.Left, true);
gs.AddColumn("입실일자", "CHECKIN_DATE_VIEW", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("퇴실일자", "CHECKOUT_DATE_VIEW", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
gs.AddColumn("당첨여부", "WIN_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;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dtMaster.Columns.Add("BIZ_CODE");
dtMaster.Columns.Add("FACILITY_CODE");
dtMaster.Columns.Add("FACILITY_NAME");
dtMaster.Columns.Add("STND_SEQ");
dtMaster.Columns.Add("GIVE_YN_FG");
dtMaster.Columns.Add("GIVE_STRT_MMDD");
dtMaster.Columns.Add("GIVE_END_MMDD");
dtMaster.Columns.Add("GIVE_RTO");
dtMaster.Columns.Add("DEC_PNT_PROC_DCD");
dtMaster.Columns.Add("DEC_PNT_PROC_DCD_NM");
dtMaster.Columns.Add("USE_YN_FG");
dtMaster.Columns.Add("USE_STND_AMT", typeof(decimal));
dtMaster.Columns.Add("RMRK");
GridStyle gs = new GridStyle(this.gridMaster, this.gridViewMaster);
gs.AddColumn("사업장", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 150, _ColumnAlign.Left, false);
gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Left, true);
gs.AddColumn("일련번호", "STND_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("적용시작일", "GIVE_STRT_MMDD", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("적용종료일", "GIVE_END_MMDD", _ColumnType.Default, 150, _ColumnAlign.Center, true);
gs.AddColumn("부여비율", "GIVE_RTO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("부여여부", "GIVE_YN_FG", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("사용여부", "USE_YN_FG", _ColumnType.Default, 200, _ColumnAlign.Center, true);
gs.AddColumn("소수점처리구분코드", "DEC_PNT_PROC_DCD", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("소수점처리구분", "DEC_PNT_PROC_DCD_NM", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("사용기준금액", "USE_STND_AMT", _ColumnType.Default, 200, _ColumnAlign.Left, false);
gs.AddColumn("비고", "RMRK", _ColumnType.Default, 200, _ColumnAlign.Left, false);
Cls.Grid.Options.SelectedRow(this.gridViewMaster);
Cls.Grid.Options.EmbeddedNavigater(this.gridMaster);
Cls.Grid.Options.FilterRow(this.gridViewMaster, true);
//Cls.Grid.Options.FixedColumn(this.gridViewMaster , new string[]{"MENU_NAME"}, PositionStyle.Left);
this.gridMaster.DataSource = dtMaster;
dtDetail.Columns.Add("BIZ_CODE");
dtDetail.Columns.Add("GUEST_TYPE");
dtDetail.Columns.Add("GUEST_TYPE_NAME");
dtDetail.Columns.Add("GIVE_RTO");
dtDetail.Columns.Add("DEC_PNT_PROC_DCD");
dtDetail.Columns.Add("DEC_PNT_PROC_DCD_NM");
dtDetail.Columns.Add("USE_YN");
GridStyle gsDetail = new GridStyle(this.gridDetail, this.gridViewDetail);
gsDetail.AddColumn("사업장", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsDetail.AddColumn("우대구분", "GUEST_TYPE", _ColumnType.Default, 100, _ColumnAlign.Center, false);
gsDetail.AddColumn("우대구분", "GUEST_TYPE_NAME", _ColumnType.Default, 150, _ColumnAlign.Left, true);
gsDetail.AddColumn("부여비율", "GIVE_RTO", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gsDetail.AddColumn("소수점처리구분", "VAT_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
gsDetail.AddColumn("사용여부", "USE_YN", _ColumnType.Numbers, 120, _ColumnAlign.Right, false);
Cls.Grid.Options.SelectedRow(this.gridViewDetail);
Cls.Grid.Options.EmbeddedNavigater(this.gridDetail);
Cls.Grid.Options.FilterRow(this.gridViewDetail, true);
//Cls.Grid.Options.FixedColumn(this.gridViewDetail , new string[]{"MENU_NAME"}, PositionStyle.Left);
//Cls.Grid.Options.Footer(gridViewDetail, DevExpress.Data.SummaryItemType.Sum, "UNIT_AMT", "UNIT_AMT", SummaryFormat.Sum);
this.gridDetail.DataSource = dtDetail;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dtHistoryMaster.Columns.Add("FACILITY_CODE");
dtHistoryMaster.Columns.Add("RSV_NO");
dtHistoryMaster.Columns.Add("MNG_NO");
dtHistoryMaster.Columns.Add("MNG_SEQ", typeof(decimal));
dtHistoryMaster.Columns.Add("TEMP_MNG_NO");
dtHistoryMaster.Columns.Add("STATUS_CODE");
dtHistoryMaster.Columns.Add("ROOM_CNT", typeof(decimal));
dtHistoryMaster.Columns.Add("ROOM_NO");
dtHistoryMaster.Columns.Add("ROOM_TYPE");
dtHistoryMaster.Columns.Add("GUEST_NAME");
dtHistoryMaster.Columns.Add("CHECKIN_DATE");
dtHistoryMaster.Columns.Add("NIGHT");
dtHistoryMaster.Columns.Add("CHECKOUT_DATE");
dtHistoryMaster.Columns.Add("SALE_AMT", typeof(decimal));
GridStyle gsHIstroyMaster = new GridStyle(this.gridHistoryMaster, this.gridViewHistoryMaster);
gsHIstroyMaster.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsHIstroyMaster.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("관리번호", "MNG_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsHIstroyMaster.AddColumn("관리순번", "MNG_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, false);
gsHIstroyMaster.AddColumn("임시관리번호", "TEMP_MNG_NO", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("상태", "STATUS_CODE", _ColumnType.Default, 40, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("객실수", "ROOM_CNT", _ColumnType.Numbers, 60, _ColumnAlign.Right, true);
gsHIstroyMaster.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("박수", "NIGHT", _ColumnType.Default, 40, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyMaster.AddColumn("매출", "SALE_AMT", _ColumnType.Numbers, 40, _ColumnAlign.Right, true);
Cls.Grid.Options.SelectedRow(this.gridViewHistoryMaster);
Cls.Grid.Options.EmbeddedNavigater(this.gridHistoryMaster);
Cls.Grid.Options.FilterRow(this.gridViewHistoryMaster, true);
this.gridHistoryMaster.DataSource = dtHistoryMaster;
dtHistoryDetail2.Columns.Add("TASK_DATE");
dtHistoryDetail2.Columns.Add("RAISE_FACILITY_CODE");
dtHistoryDetail2.Columns.Add("FACILITY_NAME");
dtHistoryDetail2.Columns.Add("DEFERED_AMT", typeof(decimal));
dtHistoryDetail2.Columns.Add("POS_NO");
dtHistoryDetail2.Columns.Add("BILL_NO");
GridStyle gsHIstroyDetail2 = new GridStyle(this.gridHistoryDetail2, this.gridViewHistoryDetail2);
gsHIstroyDetail2.AddColumn("발생일자", "TASK_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyDetail2.AddColumn("발생 영업장코드", "RAISE_FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsHIstroyDetail2.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsHIstroyDetail2.AddColumn("후불금액", "DEFERED_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gsHIstroyDetail2.AddColumn("POS번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsHIstroyDetail2.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
Cls.Grid.Options.SelectedRow(this.gridViewHistoryDetail2);
Cls.Grid.Options.EmbeddedNavigater(this.gridHistoryDetail2);
//Cls.Grid.Options.FilterRow(this.gridViewCustType, true);
//사용일수
dt_Useday.Columns.Add("ANNUAL");
dt_Useday.Columns.Add("ANNUAL_NAME");
dt_Useday.Columns.Add("MEMBER_SEQ");
dt_Useday.Columns.Add("SEQ");
dt_Useday.Columns.Add("CNT_NAME");
dt_Useday.Columns.Add("CNT_WEEK", typeof(decimal));
dt_Useday.Columns.Add("CNT_WEEKED", typeof(decimal));
dt_Useday.Columns.Add("CNT_SUMMER", typeof(decimal));
dt_Useday.Columns.Add("CNT_WINTER", typeof(decimal));
dt_Useday.Columns.Add("CNT_TOT", typeof(decimal));
GridStyle gsUseday = new GridStyle(this.gridUseDay, this.gridViewUseDay);
gsUseday.AddColumn("회원일련번호", "MEMBER_SEQ", _ColumnType.Default, 70, _ColumnAlign.Center, false);
gsUseday.AddColumn("기수", "ANNUAL_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gsUseday.AddColumn("구분", "SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsUseday.AddColumn("구분", "CNT_NAME", _ColumnType.Default, 70, _ColumnAlign.Center, true);
gsUseday.AddColumn("주중", "CNT_WEEK", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
gsUseday.AddColumn("주말", "CNT_WEEKED", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
gsUseday.AddColumn("여름", "CNT_SUMMER", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
gsUseday.AddColumn("겨울", "CNT_WINTER", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
gsUseday.AddColumn("합계", "CNT_TOT", _ColumnType.Numbers, 70, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridViewUseDay);
Cls.Grid.Options.EmbeddedNavigater(this.gridUseDay);
//Cls.Grid.Options.FilterRow(this.gridViewUseDay, true);
this.gridUseDay.DataSource = dt_Useday;
dtSpec.Columns.Add("MEMBER_SEQ");
dtSpec.Columns.Add("KEY_SEQ");
dtSpec.Columns.Add("MEMBER_NO");
dtSpec.Columns.Add("MEMBER_NAME_KOR");
dtSpec.Columns.Add("SALEINLOT_CNT");
dtSpec.Columns.Add("SALEINLOT_CNT_NAME");
dtSpec.Columns.Add("COMMODITY_CODE");
dtSpec.Columns.Add("COMMODITY_CODE_NAME");
dtSpec.Columns.Add("USE_DATE_FROM");
dtSpec.Columns.Add("USE_DATE_TO");
dtSpec.Columns.Add("ACCEPT_DATE");
dtSpec.Columns.Add("ACCEPT_RMRK");
dtSpec.Columns.Add("GUEST_TYPE");
dtSpec.Columns.Add("GUEST_TYPE_NAME");
dtSpec.Columns.Add("DC_QTY");
dtSpec.Columns.Add("RMRK");
GridStyle gsSpec = new GridStyle(this.gridSpec, this.gridViewSpec);
gsSpec.AddColumn("회원순번", "MEMBER_SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsSpec.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsSpec.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Left, false);
gsSpec.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 40, _ColumnAlign.Center, true);
gsSpec.AddColumn("분양차수", "SALEINLOT_CNT_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsSpec.AddColumn("회원타입", "COMMODITY_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsSpec.AddColumn("시작일자", "USE_DATE_FROM", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsSpec.AddColumn("종료일자", "USE_DATE_TO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsSpec.AddColumn("발생일자", "ACCEPT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsSpec.AddColumn("발생근거", "ACCEPT_RMRK", _ColumnType.Default, 100, _ColumnAlign.Left, false);
gsSpec.AddColumn("특별혜택", "GUEST_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsSpec.AddColumn("특별혜택", "GUEST_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsSpec.AddColumn("할인횟수", "DC_QTY", _ColumnType.Default, 70, _ColumnAlign.Right, true);
gsSpec.AddColumn("비고", "RMRK", _ColumnType.Default, 100, _ColumnAlign.Left, false);
Cls.Grid.Options.SelectedRow(this.gridViewSpec);
Cls.Grid.Options.EmbeddedNavigater(this.gridSpec);
this.gridSpec.DataSource = dtSpec;
//영업장예약
dtFacilityRsv.Columns.Add("FACILITY_RSV_NO");
dtFacilityRsv.Columns.Add("RSV_KEY_SEQ");
dtFacilityRsv.Columns.Add("KEY_SEQ");
dtFacilityRsv.Columns.Add("RSV_NO");
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");
GridStyle gsFacilityRsv = new GridStyle(this.gridFacilityRsv, this.gridViewFacilityRsv);
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, 60, _ColumnAlign.Center, true);
gsFacilityRsv.AddColumn("수량", "SALE_QTY", _ColumnType.Numbers, 40, _ColumnAlign.Center, true);
gsFacilityRsv.AddColumn("인원", "PERSON_CNT", _ColumnType.Numbers, 40, _ColumnAlign.Center, true);
gsFacilityRsv.AddColumn("동/T수", "TABLE_QTY", _ColumnType.Numbers, 50, _ColumnAlign.Center, true);
gsFacilityRsv.AddColumn("상품옵션", "MENU_NAME", _ColumnType.Default, 100, _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("휴대전화", "MOBILE_TEL", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gsFacilityRsv.AddColumn("비고", "RMRK", _ColumnType.Default, 180, _ColumnAlign.Left, true);
Cls.Grid.Options.SelectedRow(this.gridViewFacilityRsv);
Cls.Grid.Options.EmbeddedNavigater(this.gridFacilityRsv);
Cls.Grid.Options.FilterRow(this.gridViewFacilityRsv, true);
Cls.Grid.Options.Footer(gridViewFacilityRsv, DevExpress.Data.SummaryItemType.Sum, "SALE_QTY", "SALE_QTY", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridViewFacilityRsv, DevExpress.Data.SummaryItemType.Sum, "TABLE_QTY", "TABLE_QTY", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridViewFacilityRsv, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
this.gridFacilityRsv.DataSource = dtFacilityRsv;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
//객실
dt1.Columns.Add("KEY_SEQ");
dt1.Columns.Add("CHECKIN_DATE");
dt1.Columns.Add("NIGHTS");
dt1.Columns.Add("FACILITY_NAME");
dt1.Columns.Add("ROOM_TYPE");
dt1.Columns.Add("ROOM_TYPE_NAME");
dt1.Columns.Add("ROOM_CNT");
dt1.Columns.Add("SALE_AMT_DAY", typeof(decimal));
dt1.Columns.Add("SALE_AMT_WEEKEND", typeof(decimal));
dt1.Columns.Add("SALE_AMT", typeof(decimal));
dt1.Columns.Add("RSV_NO");
GridStyle gs1 = new GridStyle(this.grid1, this.gridView1);
gs1.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("박수", "NIGHTS", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("객실명", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("객실타입", "ROOM_TYPE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("객실수", "ROOM_CNT", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs1.AddColumn("판매단가", "SALE_AMT_DAY", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs1.AddColumn("주말단가", "SALE_AMT_WEEKEND", _ColumnType.Numbers, 100, _ColumnAlign.Right, false);
gs1.AddColumn("판매금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs1.AddColumn("예약번호", "RSV_NO", _ColumnType.Default, 100, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridView1);
//Cls.Grid.Options.EmbeddedNavigater(this.grid1);
//Cls.Grid.Options.FilterRow(this.gridView1, true);
//Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum);
this.grid1.DataSource = dt1;
//식음료
dt2.Columns.Add("KEY_SEQ");
dt2.Columns.Add("ST_DATE");
dt2.Columns.Add("ST_TIME");
dt2.Columns.Add("FACILITY_NAME");
dt2.Columns.Add("MENU_NAME");
dt2.Columns.Add("UNIT_AMT", typeof(decimal));
dt2.Columns.Add("SALE_AMT", typeof(decimal));
dt2.Columns.Add("TOT_SALE_AMT", typeof(decimal));
dt2.Columns.Add("PERSON_CNT");
GridStyle gs2 = new GridStyle(this.grid2, this.gridView2);
gs2.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs2.AddColumn("사용일자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs2.AddColumn("시간", "ST_TIME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs2.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs2.AddColumn("메뉴", "MENU_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs2.AddColumn("정상단가", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs2.AddColumn("판매단가", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs2.AddColumn("팜매금액", "TOT_SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, false);
gs2.AddColumn("인원", "PERSON_CNT", _ColumnType.Default, 100, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridView2);
//Cls.Grid.Options.EmbeddedNavigater(this.grid2);
//Cls.Grid.Options.FilterRow(this.gridView1, true);
//Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum);
this.grid2.DataSource = dt2;
//워터파크
dt3.Columns.Add("KEY_SEQ");
dt3.Columns.Add("ST_DATE");
dt3.Columns.Add("ST_TIME");
dt3.Columns.Add("FACILITY_NAME");
dt3.Columns.Add("MENU_NAME");
dt3.Columns.Add("UNIT_AMT", typeof(decimal));
dt3.Columns.Add("SALE_AMT", typeof(decimal));
dt3.Columns.Add("PERSON_CNT");
GridStyle gs3 = new GridStyle(this.grid3, this.gridView3);
gs3.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs3.AddColumn("사용일자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs3.AddColumn("시간", "ST_TIME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs3.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs3.AddColumn("메뉴", "MENU_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs3.AddColumn("정상단가", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs3.AddColumn("판매단가", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs3.AddColumn("인원", "PERSON_CNT", _ColumnType.Default, 100, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridView3);
//Cls.Grid.Options.EmbeddedNavigater(this.grid3);
//Cls.Grid.Options.FilterRow(this.gridView1, true);
//Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum);
this.grid3.DataSource = dt3;
//연회장
dt4.Columns.Add("KEY_SEQ");
dt4.Columns.Add("ST_DATE");
dt4.Columns.Add("ST_TIME");
dt4.Columns.Add("END_TIME");
dt4.Columns.Add("FACILITY_NAME");
dt4.Columns.Add("MENU_NAME");
dt4.Columns.Add("PERSON_CNT");
dt4.Columns.Add("UNIT_AMT", typeof(decimal));
dt4.Columns.Add("SALE_AMT", typeof(decimal));
dt4.Columns.Add("TABLE_SET");
GridStyle gs4 = new GridStyle(this.grid4, this.gridView4);
gs4.AddColumn("순번", "KEY_SEQ", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("사용일자", "ST_DATE", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("시작", "ST_TIME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("종료", "END_TIME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("강의장", "MENU_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("인원", "PERSON_CNT", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs4.AddColumn("정상단가", "UNIT_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs4.AddColumn("판매단가", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs4.AddColumn("TABLESET", "TABLE_SET", _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;
//기타
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));
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("FACILITY_NAME");
dt.Columns.Add("MNG_NO");
dt.Columns.Add("MNG_SEQ");
dt.Columns.Add("ROOM_NO");
dt.Columns.Add("GUEST_NAME");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("NIGTHS");
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME");
dt.Columns.Add("TASK_DATE");
dt.Columns.Add("PAY_AMT", typeof(decimal));
dt.Columns.Add("DETAIL_NAME");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("예약번호", "MNG_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("관리번호", "MNG_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGTHS", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("퇴실일자", "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.Left, true);
gs.AddColumn("입금일자", "TASK_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금금액", "PAY_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("입금구분", "DETAIL_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);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "PAY_AMT", "PAY_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dtUse.Columns.Add("SALE_DATE");
dtUse.Columns.Add("SALE_TIME");
dtUse.Columns.Add("FACILITY_NAME");
dtUse.Columns.Add("POS_NO");
dtUse.Columns.Add("BILL_NO");
dtUse.Columns.Add("MENU_NAME");
dtUse.Columns.Add("SALE_QTY", typeof(decimal));
dtUse.Columns.Add("UNIT_AMT", typeof(decimal));
dtUse.Columns.Add("SALE_AMT", typeof(decimal));
dtUse.Columns.Add("U_DATE");
dtUse.Columns.Add("UNIT_AMT_YN", typeof(decimal));
GridStyle gs = new GridStyle(this.gridUse, this.gridViewUse);
gs.AddColumn("일자", "SALE_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("시간", "SALE_TIME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("영업장", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("POS", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("순번", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("메뉴", "MENU_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("수량", "SALE_QTY", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("단가", "UNIT_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("수정일시", "U_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("", "UNIT_AMT_YN", _ColumnType.Numbers, 80, _ColumnAlign.Right, false);
Cls.Grid.Options.SelectedRow(this.gridViewUse);
Cls.Grid.Options.EmbeddedNavigater(this.gridUse);
Cls.Grid.Options.FilterRow(this.gridViewUse, true);
Cls.Grid.Options.Footer(gridViewUse, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
this.gridUse.DataSource = dtUse;
StyleFormatCondition condition = new DevExpress.XtraGrid.StyleFormatCondition();
condition.Column = this.gridViewUse.Columns["UNIT_AMT_YN"];
condition.ApplyToRow = true;
condition.Appearance.Options.UseBackColor = true;
condition.Appearance.BackColor = Color.Red;
condition.Condition = FormatConditionEnum.Expression;
condition.Expression = "UNIT_AMT_YN = 1";
gridViewUse.FormatConditions.Add(condition);
dtCharge.Columns.Add("U_DATE");
dtCharge.Columns.Add("POS_NO");
dtCharge.Columns.Add("BILL_NO");
dtCharge.Columns.Add("PAY_CODE");
dtCharge.Columns.Add("PAY_CODE_NAME");
dtCharge.Columns.Add("SALE_AMT", typeof(decimal));
dtCharge.Columns.Add("RMRK");
GridStyle gsCharge = new GridStyle(this.gridCharge, this.gridViewCharge);
gsCharge.AddColumn("충전일시", "U_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsCharge.AddColumn("포스번호", "POS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsCharge.AddColumn("전표번호", "BILL_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsCharge.AddColumn("입금수단[Z0016]", "PAY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gsCharge.AddColumn("결제", "PAY_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gsCharge.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gsCharge.AddColumn("비고", "RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(this.gridViewCharge);
Cls.Grid.Options.EmbeddedNavigater(this.gridCharge);
Cls.Grid.Options.FilterRow(this.gridViewCharge, true);
Cls.Grid.Options.Footer(gridViewCharge, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
this.gridCharge.DataSource = dtCharge;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("ANAMT_NO");
dt.Columns.Add("AMT_DATE_MASK");
dt.Columns.Add("AMT_STATUS_NAME");
dt.Columns.Add("AMT_NAME");
dt.Columns.Add("AMT", typeof(decimal));
dt.Columns.Add("TRANS_AMT_TOT", typeof(decimal));
dt.Columns.Add("REMAIN_AMT_TOT", typeof(decimal));
dt.Columns.Add("SALE_DEPT_CODE_NAME");
dt.Columns.Add("AMT_WAY_CODE_NAME");
dt.Columns.Add("BANK_CODE_NAME");
dt.Columns.Add("BANK_NO");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("RMRK");
dt.Columns.Add("TRANS_SEQ");
dt.Columns.Add("TRANS_CODE_NAME");
dt.Columns.Add("TRANS_PART_SEQ");
dt.Columns.Add("TRANS_DATE_MASK");
dt.Columns.Add("TRANS_AMT", typeof(decimal));
dt.Columns.Add("TITLE_ACCOUNT");
dt.Columns.Add("TITLE_ACCOUNT_NAME");
dt.Columns.Add("TRANS_NO");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("가입금번호", "ANAMT_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금일자", "AMT_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금상태", "AMT_STATUS_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금자명", "AMT_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금금액", "AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("대체금액", "TRANS_AMT_TOT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("대체잔액", "REMAIN_AMT_TOT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("영업부서", "SALE_DEPT_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입금수단", "AMT_WAY_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("은행구분", "BANK_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("계좌번호", "BANK_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원번호", "MEMBER_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("대체순번", "TRANS_SEQ", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("대체방법구분", "TRANS_CODE_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("대체일자", "TRANS_DATE_MASK", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("대체금액", "TRANS_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("타계정코드", "TITLE_ACCOUNT", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("타계정명", "TITLE_ACCOUNT_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("대체관계번호", "TRANS_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("대체비고", "RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("대체구분순번", "TRANS_PART_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, false);
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);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "AMT", "AMT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "TRANS_AMT_TOT", "TRANS_AMT_TOT", 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, "TRANS_AMT", "TRANS_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("BIZ_CODE");
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("FACILITY_NAME");
dt.Columns.Add("FACILITY_CLOSE_YN");
dt.Columns.Add("SALE_AMT", typeof(decimal));
dt.Columns.Add("NET_AMT", typeof(decimal));
dt.Columns.Add("VAT_AMT", typeof(decimal));
dt.Columns.Add("SLIP_NO_SALE");
dt.Columns.Add("SLIP_NO_CAL");
dt.Columns.Add("CLOSE_YN");
dt.Columns.Add("ITEM3");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("BIZ_CODE", "BIZ_CODE", _ColumnType.Default, 50, _ColumnAlign.Center, false);
gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Left, true);
gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 120, _ColumnAlign.Left, true);
gs.AddColumn("영업장마감", "FACILITY_CLOSE_YN", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("판매금액", "SALE_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("공급가액", "NET_AMT", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("부가세액", "VAT_AMT", _ColumnType.Numbers, 90, _ColumnAlign.Right, true);
gs.AddColumn("매출전표", "SLIP_NO_SALE", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("정산전표", "SLIP_NO_CAL", _ColumnType.Numbers, 100, _ColumnAlign.Right, true);
gs.AddColumn("마감여부", "CLOSE_YN", _ColumnType.CheckBox, 60, _ColumnAlign.Left, true, true);
gs.AddColumn("ITEM3", "ITEM3", _ColumnType.Default, 50, _ColumnAlign.Center, 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("BIZ_CODE");
dtDetail.Columns.Add("PAY_CODE");
dtDetail.Columns.Add("DETAIL_NAME");
dtDetail.Columns.Add("SALE_AMT", typeof(decimal));
GridStyle dgs = new GridStyle(this.Detailgrid, this.DetailgridView);
dgs.AddColumn("사업장코드[SMSLOG.BIZ_CODE]", "BIZ_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
dgs.AddColumn("입금구분", "PAY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
dgs.AddColumn("입금구분", "DETAIL_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
dgs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
Cls.Grid.Options.SelectedRow(this.DetailgridView);
Cls.Grid.Options.EmbeddedNavigater(this.Detailgrid);
Cls.Grid.Options.FilterRow(this.DetailgridView, true);
this.Detailgrid.DataSource = dtDetail;
dtDetailAll.Columns.Add("REMARK");
dtDetailAll.Columns.Add("DR_AMT", typeof(decimal));
dtDetailAll.Columns.Add("CR_AMT", typeof(decimal));
dtDetailAll.Columns.Add("CUST");
dtDetailAll.Columns.Add("CUST_NAME");
GridStyle dgs2 = new GridStyle(this.Detailgrid2, this.DetailgridView2);
dgs2.AddColumn("적요", "REMARK", _ColumnType.Default, 400, _ColumnAlign.Left, true);
dgs2.AddColumn("차변", "DR_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
dgs2.AddColumn("대변", "CR_AMT", _ColumnType.Numbers, 120, _ColumnAlign.Right, true);
dgs2.AddColumn("거래처", "CUST", _ColumnType.Default, 90, _ColumnAlign.Center, true);
dgs2.AddColumn("거래처명", "CUST_NAME", _ColumnType.Default, 300, _ColumnAlign.Left, true);
Cls.Grid.Options.SelectedRow(this.DetailgridView2);
Cls.Grid.Options.EmbeddedNavigater(this.Detailgrid2);
Cls.Grid.Options.FilterRow(this.DetailgridView2, true);
this.Detailgrid2.DataSource = dtDetailAll;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("CH_CODE");
dt.Columns.Add("CH_CODE_NAME");
dt.Columns.Add("GUBUN");
dt.Columns.Add("CH_NO");
dt.Columns.Add("CH_NAME");
dt.Columns.Add("SEND_CNT", typeof(decimal));
dt.Columns.Add("CUST_NO");
dt.Columns.Add("MEMBER_NAME_KOR");
dt.Columns.Add("SMS_NO");
dt.Columns.Add("SEND_DATE");
dt.Columns.Add("SMS_RSLTDATE");
dt.Columns.Add("SEND_RMRK");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("채널구분", "CH_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("채널구분", "CH_CODE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("상태", "GUBUN", _ColumnType.Default, 50, _ColumnAlign.Center, true);
gs.AddColumn("채널번호", "CH_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("채널명", "CH_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회차", "SEND_CNT", _ColumnType.Numbers, 50, _ColumnAlign.Right, true);
gs.AddColumn("고객번호", "CUST_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("회원명", "MEMBER_NAME_KOR", _ColumnType.Default, 60, _ColumnAlign.Center, true);
gs.AddColumn("SMS번호", "SMS_NO", _ColumnType.Default, 90, _ColumnAlign.Center, true);
gs.AddColumn("SMS예약일시/출력일시", "SEND_DATE", _ColumnType.Default, 180, _ColumnAlign.Center, true);
gs.AddColumn("SMS전송일시", "SMS_RSLTDATE", _ColumnType.Default, 180, _ColumnAlign.Center, true);
gs.AddColumn("문자메세지", "SEND_RMRK", _ColumnType.Default, 340, _ColumnAlign.Left, true);
Cls.Grid.Options.SelectedRow(this.gridView);
Cls.Grid.Options.EmbeddedNavigater(this.grid);
Cls.Grid.Options.FilterRow(this.gridView, true);
//Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "컬럼명", "필드명", SummaryFormat.Sum);
this.grid.DataSource = dt;
}
/// <summary>
/// 데이터 테이블을 정의 합니다.
/// </summary>
private void SetDataTable()
{
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("MNG_NO");
dt.Columns.Add("MNG_SEQ");
dt.Columns.Add("TASK_DATE");
dt.Columns.Add("ROOM_NO");
dt.Columns.Add("GUEST_NAME");
dt.Columns.Add("ROOM_TYPE");
dt.Columns.Add("CHECKIN_DATE");
dt.Columns.Add("NIGHTS", typeof(decimal));
dt.Columns.Add("CHECKOUT_DATE");
dt.Columns.Add("MEMBER_NO");
dt.Columns.Add("MEMBER_NAME");
dt.Columns.Add("MENU_NAME");
dt.Columns.Add("MENU_CNT", typeof(decimal));
dt.Columns.Add("SALE_AMT", typeof(decimal));
dt.Columns.Add("U_EMP_NO");
dt.Columns.Add("OUT_CODE");
dt.Columns.Add("RSV_RMRK");
dt.Columns.Add("CHECKIN_RMRK");
dt.Columns.Add("ITEM_STAT");
dt.Columns.Add("OTHER_RMRK");
GridStyle gs = new GridStyle(this.grid, this.gridView);
gs.AddColumn("영업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("관리번호", "MNG_NO", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("관리순번", "MNG_SEQ", _ColumnType.Numbers, 80, _ColumnAlign.Right, false);
gs.AddColumn("영업일자", "TASK_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실번호", "ROOM_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("투숙객명", "GUEST_NAME", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("입실일자", "CHECKIN_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("박수", "NIGHTS", _ColumnType.Numbers, 45, _ColumnAlign.Right, true);
gs.AddColumn("퇴실일자", "CHECKOUT_DATE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("매출항목", "MENU_NAME", _ColumnType.Default, 100, _ColumnAlign.Center, true);
gs.AddColumn("수량", "MENU_CNT", _ColumnType.Numbers, 45, _ColumnAlign.Right, true);
gs.AddColumn("금액", "SALE_AMT", _ColumnType.Numbers, 80, _ColumnAlign.Right, true);
gs.AddColumn("담당자", "U_EMP_NO", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("예약참고사항", "RSV_RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("입실참고사항", "CHECKIN_RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, false);
gs.AddColumn("매출/입금/후불", "ITEM_STAT", _ColumnType.Default, 120, _ColumnAlign.Center, true);
gs.AddColumn("기타요금등록참고", "OTHER_RMRK", _ColumnType.Default, 80, _ColumnAlign.Center, false);
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, "MENU_CNT", "MENU_CNT", SummaryFormat.Sum);
Cls.Grid.Options.Footer(gridView, DevExpress.Data.SummaryItemType.Sum, "SALE_AMT", "SALE_AMT", SummaryFormat.Sum);
this.grid.DataSource = dt;
}