/// <summary>
/// Grid2을 디스플레이한다
/// </summary>
private void SetGridInfomationDisplay()
{
try
{
//그리드 초기화
Basic.SetGridSourceClear(grid2.DataSource);
int iRow = this.gridView.GetFocusedDataSourceRowIndex();
string filter = "CARD_COMPANY_NAME = '" + dt.Rows[iRow]["CARD_COMPANY_NAME"].ToString().Trim() + "' AND " +
"CARD_COMPANY_CODE = '" + dt.Rows[iRow]["CARD_COMPANY_CODE"].ToString().Trim() + "' ";
Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
//helper.InsertGroupByInto(dt2, dtCasch, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO, MEMBER_NO", filter, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO, MEMBER_NO");
//helper.InsertGroupByInto(dt2, dtCasch, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO, MEMBER_NO", filter, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO");
//helper.InsertGroupByInto(dt2, dtCasch, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO", filter, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO, MEMBER_NO");
helper.InsertGroupByInto(dt2, dtCasch, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO", filter, "SALE_DATE, FACILITY_NAME, POS_NO, BILL_NO, PAY_SEQ, SALE_AMT, CARD_NO, AGREE_NO");
//dt2.Columns.Add("SALE_DATE");
//dt2.Columns.Add("FACILITY_NAME");
//dt2.Columns.Add("POS_NO");
//dt2.Columns.Add("BILL_NO");
//dt2.Columns.Add("PAY_SEQ", typeof(decimal));
//dt2.Columns.Add("SALE_AMT", typeof(decimal));
//dt2.Columns.Add("CARD_NO");
//dt2.Columns.Add("AGREE_NO");
//dt3.Load(dtTotal.Select(filter, "POS_NO")[0].Table.CreateDataReader());
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// Grid3을 디스플레이한다
/// </summary>
private void SetGridInfomationDisplay3()
{
try
{
//그리드 초기화
Basic.SetGridSourceClear(grid3.DataSource);
int iRow = this.gridView2.GetFocusedDataSourceRowIndex();
string filter = "SALE_DATE = '" + dt2.Rows[iRow]["SALE_DATE"].ToString().Trim() + "' AND " +
"FACILITY_CODE = '" + dt2.Rows[iRow]["FACILITY_CODE"].ToString().Trim() + "' AND " +
"FACILITY_NAME = '" + dt2.Rows[iRow]["FACILITY_NAME"].ToString().Trim() + "' AND " +
"POS_NO = '" + dt2.Rows[iRow]["POS_NO"].ToString().Trim() + "' ";
Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
helper.InsertGroupByInto(dt3, dtTotal, "POS_NO, BILL_NO, BILL_SEQ, SALE_GUBUN, MENU_CODE, MENU_NAME, SALE_QTY, SALE_AMT", filter, "POS_NO, BILL_NO, BILL_SEQ, SALE_GUBUN, MENU_CODE, MENU_NAME, SALE_QTY, SALE_AMT");
//dt3.Columns.Add("POS_NO");
//dt3.Columns.Add("BILL_NO");
//dt3.Columns.Add("BILL_SEQ", typeof(decimal));
//dt3.Columns.Add("SALE_YN");
//dt3.Columns.Add("SALE_GUBUN");
//dt3.Columns.Add("MENU_CODE");
//dt3.Columns.Add("MENU_NAME");
//dt3.Columns.Add("SALE_QTY", typeof(decimal));
//dt3.Columns.Add("SALE_AMT", typeof(decimal));
//dt3.Load(dtTotal.Select(filter, "POS_NO")[0].Table.CreateDataReader());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Grid2을 디스플레이한다
/// </summary>
private void SetGridInfomationDisplay2()
{
try
{
//그리드 초기화
Basic.SetGridSourceClear(grid3.DataSource);
Basic.SetGridSourceClear(grid2.DataSource);
int iRow = this.gridView1.GetFocusedDataSourceRowIndex();
string filter = "SALE_DATE = '" + dt1.Rows[iRow]["SALE_DATE"].ToString().Trim() + "' AND " +
"FACILITY_CODE = '" + dt1.Rows[iRow]["FACILITY_CODE"].ToString().Trim() + "' AND " +
"FACILITY_NAME = '" + dt1.Rows[iRow]["FACILITY_NAME"].ToString().Trim() + "'";
Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
helper.InsertGroupByInto(dt2, dtTotal, "SALE_DATE, FACILITY_CODE, FACILITY_NAME, POS_NO, SUM(SALE_AMT) SALE_AMT", filter, "SALE_DATE, FACILITY_CODE, FACILITY_NAME, POS_NO");
//this.gridForSame.DataSource = Basic.GetdtSelect(dtForSame, filter1, "USER_SORT ASC");
//this.gridForStandard.DataSource = Basic.GetdtSelect(dtForStandard, filter1, "LOT_CODE ASC");
//Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
//helper.InsertGroupByInto(dt1, dtTotal, "sum(test), test2", "", "test2");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Grid1을 디스플레이한다
/// </summary>
private void DisplayGrid1()
{
try
{
Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
helper.InsertGroupByInto(dt1, dtTotal, "SALE_DATE, FACILITY_CODE, FACILITY_NAME, SUM(SALE_AMT) SALE_AMT", "", "SALE_DATE, FACILITY_CODE, FACILITY_NAME");
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// Grid1을 디스플레이한다
/// </summary>
private void DisplaySummery()
{
////마스터 그리드
//dt.Columns.Add("FACILITY_NAME");
//dt.Columns.Add("BILL_NO");
//dt.Columns.Add("SALE_AMT", typeof(decimal));
//dt.Columns.Add("FACILITY_CODE");
try
{
Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
helper.InsertGroupByInto(dt, dtCasch, "CARD_COMPANY_NAME,CARD_COMPANY_CODE, COUNT(BILL_NO) BILL_NO, SUM(SALE_AMT) SALE_AMT", "", "CARD_COMPANY_CODE, CARD_COMPANY_NAME");
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
/// <summary>
/// 마스터 데이터를 조회 합니다.
/// </summary>
/// <param name="mngno">관리번호</param>
/// <param name="mngseq">관리일련번호.</param>
private void fnSelectMaster(string mngno, string mngseq)
{
try
{
MngNo = mngno;
MngSeq = mngseq;
DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtParm.Rows.Add(new object[] { "V_MNG_NO", mngno });
dtParm.Rows.Add(new object[] { "V_MNG_SEQ", mngseq });
dtParm.Rows.Add(new object[] { "V_CHECKIN_TYPE_IWOL", BizCommon.Parm_D.CHECKIN_TYPE_IWOL });
dtParm.Rows.Add(new object[] { "V_TASK_DATE", Parm.CurrentUserInformation.roomTask.gsTaskDate });
dtMaster.Clear();
dtDetail.Clear();
dtCondition.Clear();
dtConditionAll.Clear();
dtMaster.AcceptChanges();
dtDetail.AcceptChanges();
dtCondition.AcceptChanges();
dtConditionAll.AcceptChanges();
DataSet ds = DataLayer.ExecuteSpDataset("PKG_DAAAI12.PR_01", dtParm, DataLayer.MessageEncoding.Default);
dtMaster.Load(ds.Tables[0].CreateDataReader());
dtMaster.AcceptChanges();
dtlupFacility.RejectChanges(); //영업장정보를 초기화합니다.
if (dtMaster.Rows.Count <= 0 || dtMaster.Rows.Count <= 1)
{
//this.btnAmtChange.Enabled = false;
this.btnMainChangeRoom.Enabled = false;
//카운터가 없다면 영업장장보에에 있던 기존 영업장 정보를 날립니다.
//LookUp.SetFillCode(lupFacility , dtlupFacility, "CODE_NAME" , "CODE", LookUp.CaptoinStyle.None);
LookUp.SetFillCode(lupFacility, dtlupFacility, "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None);
//return;
}
else
{
//this.btnAmtChange.Enabled = true;
this.btnMainChangeRoom.Enabled = true;
}
//마스터 항목중에 메인객실이 있는지 확인합니다.
int cnt = int.Parse(dtMaster.Compute("COUNT(MAIN_YN)", "MAIN_YN = 'Y'").ToString().Trim());
string masterno = dtMaster.Rows[0]["MASTER_NO"].ToString().Trim();
string str = "";
//메인객실이 있다면 오른쪽 관련객실로 묶을 데이터중에서
//메인객실포함 관련객실을 NOT IN 항목으로 제외시켜줍니다.
if (cnt > 0)
{
//디테일을 조회한다.
DataTable dtParm1 = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtParm1.Rows.Add(new object[] { "V_MASTER_NO", masterno });
DataSet ds1 = DataLayer.ExecuteSpDataset("PKG_DAAAI12.PR_03", dtParm1, DataLayer.MessageEncoding.Default);
dtDetail.Load(ds1.Tables[0].CreateDataReader());
dtDetail.AcceptChanges();
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
str += dtDetail.Rows[i]["FACI_PART"].ToString().Trim() + dtDetail.Rows[i]["ROOM_NO"].ToString().Trim();
if (i < dtDetail.Rows.Count - 1) //마지막데이터가 아니라면
{
str += ",";
}
}
}
//최종데이터를 불러옵니다.
DataTable dtParm2 = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtParm2.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtParm2.Rows.Add(new object[] { "V_FACILITY_CODE", "" });
dtParm2.Rows.Add(new object[] { "V_MASTER_NO", masterno });
dtParm2.Rows.Add(new object[] { "V_ROOM_NOT_IN", str });
DataSet ds3 = DataLayer.ExecuteSpDataset("PKG_DAAAI12.PR_02", dtParm2, DataLayer.MessageEncoding.Default);
dtConditionAll.Load(ds3.Tables[0].CreateDataReader());
dtConditionAll.AcceptChanges();
if (dtConditionAll.Rows.Count <= 0)
{
return;
}
//카운터가 있다면
//가져온데이터를 기준으로 영업장을 Groupby 하여 룩업컨트롤에 바인딩합니다.
Cls.GroupByHelper.DataSetHelper dshelper = new Cls.GroupByHelper.DataSetHelper();
DataTable dtTmp = dshelper.SelectGroupByInto("dtlups", dtConditionAll, "FACILITY_CODE , FACILITY_NAME", "", "FACILITY_CODE, FACILITY_NAME");
//룩업에데이터를 채운다.
Cls.Common.LookUp.SetFillCode(this.lupFacility, dtTmp, "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None);
lupFacility.ItemIndex = 0;
}
catch (Exception ex)
{
dtMaster.RejectChanges();
dtDetail.RejectChanges();
dtCondition.RejectChanges();
dtConditionAll.RejectChanges();
throw ex;
}
}
/// <summary>
/// 가져온 데이터를 기준으로 크로스 탭을 만들어 뷰어한다.
/// </summary>
private void fnCreateCrossTab()
{
try
{
if (dtFactory.Rows.Count <= 0)
{
return;
}
//유형별 탭을 동적으로 생성합니다.
//-----------------------------------------------------------------------------
//그리드 와 밴드를 동적으로 설정합니다.
// | 유형별
//-----------------------------------------------------------------------------
// | 총객실 | 잔여객실 | 블럭수 | 인터넷운영수 | 인터넷예약가능여부
//-----------------------------------------------------------------------------
//일자별 |
//-----------------------------------------------------------------------------
// 데이터 테이블을 동적으로 생성한다.
// 1 유형별 그룹바이 갯수가 밴드가 되며 하위 밴드에 5개의 컬럼이 들어간다.
//가져온데이터에서 유형를 그룹으로 데이터를 축출한다.
Cls.GroupByHelper.DataSetHelper helper = new Cls.GroupByHelper.DataSetHelper();
dt.Clear();
//컬럼을 날린다.
dt.Columns.Clear();
SetClearGridBand();
DataTable dtRoomTypeGroup = helper.SelectGroupByInto("ROOM_TYPE", dtFactory, "ROOM_TYPE, ROOM_TYPE_AND_NAME", "", "ROOM_TYPE, ROOM_TYPE_AND_NAME");
DataTable dtCalnGroup = helper.SelectGroupByInto("CALN_DATE", dtFactory,
"CALN_DATE,CALN_DATE_YOIL,FACILITY_CODE,EXCLUSIVE_CODE , EXCLUSIVE_CODE_NAME", "",
"CALN_DATE,CALN_DATE_YOIL,FACILITY_CODE,EXCLUSIVE_CODE , EXCLUSIVE_CODE_NAME");
//DataTable dtCalnIdentity = helper.SelectGroupByInto ("CALN_DATE" ,dtFactory, "CALN_DATE", "" , "CALN_DATE");
if (dtRoomTypeGroup.Rows.Count <= 0)
{
return;
}
dt.Columns.Add("CALN_DATE");
dt.Columns.Add("CALN_DATE_YOIL");
dt.Columns.Add("FACILITY_CODE");
dt.Columns.Add("EXCLUSIVE_CODE");
dt.Columns.Add("EXCLUSIVE_CODE_NAME");
//------------------------------------------------------------------------------------------
//그리드에밴드를 추가한다.
//------------------------------------------------------------------------------------------
DevExpress.XtraGrid.Views.BandedGrid.GridBand Band = new GridBand();
Band.AppearanceHeader.Options.UseTextOptions = true;
Band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
Band.Caption = "일자정보";
//Band.MinWidth = 20;
Band.Name = "Band";
Band.OptionsBand.AllowSize = true;
Band.Visible = true;
//Band.Width = 134;
this.advBandedGridViewFactory.Bands.Add(Band);
//------------------------------------------------------------------------------------------
// 밴드에 컬럼을 추가한다.
//------------------------------------------------------------------------------------------
SetAddBandColumn(Band, "일자", "CALN_DATE_YOIL", "CALN_DATE_YOIL", DevExpress.Utils.HorzAlignment.Center, 120);
Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridViewFactory, "CALN_DATE_YOIL", _ColumnType.Default, _ColumnAlign.Center, true);
SetAddBandColumn(Band, "전용구분", "EXCLUSIVE_CODE_NAME", "EXCLUSIVE_CODE_NAME", DevExpress.Utils.HorzAlignment.Center, 80);
Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridViewFactory, "EXCLUSIVE_CODE_NAME", _ColumnType.Default, _ColumnAlign.Center, true);
//------------------------------------------------------------------------------------------
advBandedGridViewFactory.FormatConditions.Clear();
StyleFormatCondition condition = new DevExpress.XtraGrid.StyleFormatCondition();
//condition.Appearance.ForeColor = Color.Red;
condition.Column = Band.Columns["CALN_DATE_YOIL"];
condition.ApplyToRow = true;
condition.Appearance.BackColor = Color.LightBlue;
condition.Appearance.Options.UseBackColor = true;
//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 = "CALN_DATE_YOIL Like '%토요일%'";
advBandedGridViewFactory.FormatConditions.Add(condition);
StyleFormatCondition condition1 = new DevExpress.XtraGrid.StyleFormatCondition();
//condition1.Appearance.ForeColor = Color.Red;
condition1.Column = Band.Columns["CALN_DATE_YOIL"];
condition1.ApplyToRow = true;
condition1.Appearance.BackColor = Color.Pink;
condition1.Appearance.Options.UseBackColor = true;
//condition1.Appearance.Options.UseFont = true;
//condition1.Appearance.Options.UseForeColor = true;
//condition1.Appearance.Font = new System.Drawing.Font("굴림체", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
condition1.Condition = FormatConditionEnum.Expression;
condition1.Expression = "CALN_DATE_YOIL Like '%일요일%'";
advBandedGridViewFactory.FormatConditions.Add(condition1);
for (int iRoomType = 0; iRoomType < dtRoomTypeGroup.Rows.Count; iRoomType++)
{
string freeFix = "_" + dtRoomTypeGroup.Rows[iRoomType]["ROOM_TYPE"].ToString();
string cRoomType = "ROOM_TYPE" + freeFix;
string cRoomView = "ROOM_VIEW" + freeFix;
string cRoomTypeAndName = "ROOM_TYPE_AND_NAME" + freeFix;
string cUseCntTot = "USE_CNT_TOT" + freeFix;
string cRemainCnt = "REMAIN_CNT" + freeFix;
string cBlockCnt = "BLOCK_CNT" + freeFix;
string cIntRsvYn = "INT_RSV_YN" + freeFix;
string cIntUseCnt = "INT_USE_CNT" + freeFix;
dt.Columns.Add(cRoomType);
dt.Columns.Add(cRoomView);
dt.Columns.Add(cRoomTypeAndName);
dt.Columns.Add(cUseCntTot, typeof(decimal));
dt.Columns.Add(cRemainCnt, typeof(decimal));
dt.Columns.Add(cBlockCnt, typeof(decimal));
dt.Columns.Add(cIntRsvYn);
dt.Columns.Add(cIntUseCnt, typeof(decimal));
DevExpress.XtraGrid.Views.BandedGrid.GridBand Bandi = new GridBand();
Band.AppearanceHeader.Options.UseTextOptions = true;
Band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
Bandi.Caption = dtRoomTypeGroup.Rows[iRoomType]["ROOM_TYPE_AND_NAME"].ToString();
//Bandi.MinWidth = 20;
Bandi.Name = "Band" + freeFix;
Bandi.OptionsBand.AllowSize = true;
Bandi.Visible = true;
//Bandi.Width = 134;
this.advBandedGridViewFactory.Bands.Add(Bandi);
SetAddBandColumn(Bandi, "잔여객실", cRemainCnt, cRemainCnt, DevExpress.Utils.HorzAlignment.Center, 120);
Cls.Grid.AdvBandedGrid.InitializeColumn(this.advBandedGridViewFactory, cRemainCnt, _ColumnType.Numbers, _ColumnAlign.Right, true);
Band.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
}
//데이터를 넣는다..
for (int iCaln = 0; iCaln < dtCalnGroup.Rows.Count; iCaln++)
{
DataRow ImportRow = dt.NewRow();
string strCaln = dtCalnGroup.Rows[iCaln]["CALN_DATE"].ToString();
string strCalnYoiL = dtCalnGroup.Rows[iCaln]["CALN_DATE_YOIL"].ToString();
string strFacility = dtCalnGroup.Rows[iCaln]["FACILITY_CODE"].ToString();
string strExcusive = dtCalnGroup.Rows[iCaln]["EXCLUSIVE_CODE"].ToString();
string strExcusiveName = dtCalnGroup.Rows[iCaln]["EXCLUSIVE_CODE_NAME"].ToString();
ImportRow["CALN_DATE"] = strCaln;
ImportRow["CALN_DATE_YOIL"] = strCalnYoiL;
ImportRow["FACILITY_CODE"] = strFacility;
ImportRow["EXCLUSIVE_CODE"] = strExcusive;
ImportRow["EXCLUSIVE_CODE_NAME"] = strExcusiveName;
//룸타입별로 루핑을 돈다.
for (int iRoomType1 = 0; iRoomType1 < dtRoomTypeGroup.Rows.Count; iRoomType1++)
{
string strRoomType = dtRoomTypeGroup.Rows[iRoomType1]["ROOM_TYPE"].ToString();
//해당되는 데이터의 유형별 레코드를 찾아서 데이터를 채운더.
string strFilter = string.Format(@"CALN_DATE = '{0}' AND
CALN_DATE_YOIL = '{1}' AND
FACILITY_CODE = '{2}' AND
ROOM_TYPE = '{3}' AND
EXCLUSIVE_CODE = '{4}'
"
, new object[] {
strCaln,
strCalnYoiL,
strFacility,
strRoomType,
strExcusive
});
DataRow[] r = dtFactory.Select(strFilter);
if (r == null || r.Length <= 0)
{
continue;
}
string freeFix = "_" + strRoomType;
/*컬럼명 정의*/
string cRoomType = "ROOM_TYPE" + freeFix;
string cRoomView = "ROOM_VIEW" + freeFix;
string cRoomType_And_Name = "ROOM_TYPE_AND_NAME" + freeFix;
string cUseCntTot = "USE_CNT_TOT" + freeFix;
string ReaminCnt = "REMAIN_CNT" + freeFix;
string BlockCnt = "BLOCK_CNT" + freeFix;
string IntRsvYn = "INT_RSV_YN" + freeFix;
string IntUseCnt = "INT_USE_CNT" + freeFix;
ImportRow[cRoomType] = r[0]["ROOM_TYPE"].ToString().Trim();
ImportRow[cRoomView] = r[0]["ROOM_VIEW"].ToString().Trim();
ImportRow[cRoomType_And_Name] = r[0]["ROOM_TYPE_AND_NAME"].ToString().Trim();
ImportRow[cUseCntTot] = r[0]["USE_CNT_TOT"].ToString().Trim();
ImportRow[ReaminCnt] = r[0]["REMAIN_CNT"].ToString().Trim();
ImportRow[BlockCnt] = r[0]["BLOCK_CNT"].ToString().Trim();
ImportRow[IntRsvYn] = r[0]["INT_RSV_YN"].ToString().Trim();
ImportRow[IntUseCnt] = r[0]["INT_USE_CNT"].ToString().Trim();
}
//dt.ImportRow(ImportRow);
dt.Rows.Add(ImportRow);
}
dt.AcceptChanges();
}
catch (Exception ex)
{
dt.RejectChanges();
throw ex;
}
}
//주석을 풀고 사용하세요
/*****************************************************************************/
#region 팝업컨테이너 에티트의 컨트롤 바인딩
/// <summary>
/// 팝업컨테이너 에티트의 컨트롤 바인딩
/// </summary>
/// <param name="popedit">The popedit.</param>
/// <param name="gridName">Name of the grid.</param>
/// <param name="gridViewName">Name of the grid view.</param>
private void SetAddressSchma(DevExpress.XtraEditors.PopupContainerEdit popedit,
string gridName,
string gridViewName)
{
try
{
if (lupFacilitySelect.EditValue.ToString() == "")
{
return;
}
DevExpress.XtraGrid.GridControl grid = new DevExpress.XtraGrid.GridControl();
DevExpress.XtraGrid.Views.Grid.GridView gridView = new DevExpress.XtraGrid.Views.Grid.GridView();
grid.Name = gridName;
gridView.Name = gridViewName;
DataTable dtBiz = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter);
dtBiz.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode });
dtBiz.Rows.Add(new object[] { "V_FACILITY_CODE", lupFacilitySelect.EditValue });
DataSet dsTmp = DataLayer.ExecuteSpDataset("PKG_DAAAI18.PR_01", dtBiz, DataLayer.MessageEncoding.Default);
Cls.GroupByHelper.DataSetHelper group = new Cls.GroupByHelper.DataSetHelper();
//조회 영업장을 셋팅한다.
//LookUp.SetFillCode(this.lupFacilitySelect, group.SelectGroupByInto("MyTable" , dsTmp.Tables[0], "FACILITY_CODE , FACILITY_NAME","", "FACILITY_CODE , FACILITY_NAME") , "FACILITY_NAME", "FACILITY_CODE" , LookUp.CaptoinStyle.SelectText);
//this.lupFacilitySelect.ItemIndex = 1;
/*
* dsTmp.Tables[0].Columns.Add("FACILITY_CODE" );
* dsTmp.Tables[0].Columns.Add("FACILITY_NAME" );
* dsTmp.Tables[0].Columns.Add("ROOM_TYPE" );
* dsTmp.Tables[0].Columns.Add("ROOM_TYPE_NAME" );
*/
GridStyle gs = new GridStyle(grid, gridView);
gs.AddColumn("업장코드", "FACILITY_CODE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("영업장명", "FACILITY_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("객실유형", "ROOM_TYPE", _ColumnType.Default, 80, _ColumnAlign.Center, true);
gs.AddColumn("유형명칭", "ROOM_TYPE_NAME", _ColumnType.Default, 80, _ColumnAlign.Center, true);
Cls.Grid.Options.SelectedRow(gridView);
Cls.Grid.Options.EmbeddedNavigater(grid);
Cls.Grid.Options.FilterRow(gridView, true);
grid.DataSource = dsTmp.Tables[0];
//Cls.Grid.Options.SetColumnColor(gridView,
// StyleFormatConditionType.Column,
// this.gridView.Columns["FACILITY_CODE"], FormatConditionEnum.GreaterOrEqual,
// Color.Goldenrod,
// null);
//Cls.Grid.Options.SetColumnColor(gridView,
// StyleFormatConditionType.Column,
// this.gridView.Columns["ROOM_TYPE"],
// FormatConditionEnum.GreaterOrEqual,
// Color.Goldenrod,
// null);
Cls.Common.uPopupContainer.AddPopupGridControl("product",
new System.Drawing.Size(500, 350),
popedit,
"선택하세요",
grid,
gridView, DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor);
gridView.KeyDown += new System.Windows.Forms.KeyEventHandler(PopupGridview_KeyDown);
gridView.DoubleClick += new System.EventHandler(PopupGridview_DoubleClick);
}
catch (Exception ex)
{
Basic.ShowMessage(3, ex.Message);
}
}
