/// <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); } }