/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())).AddMonths(-1); this.dtpTo.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())); /*영업장*/ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(this.lupFacilitycode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); /*영업장Total*/ DataTable dtparmSelect = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtparmSelect.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_DCRAS13.PR_02", dtparmSelect, DataLayer.MessageEncoding.Default); Cls.Common.LookUp.SetFillCode(this.lupFacilitytotal, ds.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩한다. /// </summary> private void SetBasicCode() { try { //DataTable dtBiz = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); //dtBiz.Rows.Add(new object[]{"V_BIZ_CODE" ,Parm.CurrentUserInformation.BizInfo.BizCode}); //DataSet dstmp = DataLayer.ExecuteSpDataset("PKG_CAAAI02.PR_03", dtBiz,DataLayer.MessageEncoding.Default); //Cls.Common.LookUp.SetFillCode(lupFacilitySelect, dstmp.Tables[0], "FACILITY_NAME","FACILITY_CODE", LookUp.CaptoinStyle.SelectText); //Cls.Common.LookUp.SetFillCode(lupFacilitycode , dstmp.Tables[0], "FACILITY_NAME","FACILITY_CODE", LookUp.CaptoinStyle.SelectText); BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(this.lupFacilitySelect, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.SelectText); this.lupFacilitySelect.ItemIndex = 1; BizCommon.mFacility.SetFacility(this.lupFacilitycode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.SelectText); } catch (Exception ex) { 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 * { * * 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 dtType = new DataTable(); * //dtType.Columns.Add("FACILITY_CODE" ); * //dtType.Columns.Add("FACILITY_NAME" ); * //dtType.Columns.Add("FACILITY_NAME_ENG" ); * //dtType.Columns.Add("FACILITY_NAME_SHORT" ); * //dtType.Columns.Add("FACILITY_TYPE" ); * //dtType.Columns.Add("FACILITY_TYPE_NAME"); * //dtType.Columns.Add("DIRECT_MANAGE_YN" ); * //dtType.Columns.Add("USE_YN" ); * //dtType.Columns.Add("RMRK" ); * * DataTable dtType = Basic.GetdtSelect(Parm.dtZaa140ms, "PROJECT_ID = '" + base.ProjectID + "' AND USE_YN = 'Y'", "FACILITY_CODE"); * * 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("영문명" , "FACILITY_NAME_ENG" , _ColumnType.Default , 80,_ColumnAlign.Center , true); * gs.AddColumn("단축명" , "FACILITY_NAME_SHORT" , _ColumnType.Default , 80,_ColumnAlign.Center , true); * gs.AddColumn("업장타입" , "FACILITY_TYPE_NAME" , _ColumnType.Default , 80,_ColumnAlign.Center , true); * gs.AddColumn("직영여부" , "DIRECT_MANAGE_YN" , _ColumnType.Default , 80,_ColumnAlign.Center , true); * * Cls.Grid.Options.SelectedRow(gridView); * Cls.Grid.Options.EmbeddedNavigater(grid); * Cls.Grid.Options.FilterRow(gridView, true); * grid.DataSource = dtType; * * 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); * } * } #endregion * #region 팝업그리드 뷰에서의 키이벤트 * * /// <summary> * /// 팝업그리드 뷰에서의 키이벤트 * /// </summary> * /// <param name="sender">The source of the event.</param> * /// <param name="e">The <see cref="System.Windows.Forms.KeyEventArgs"/> instance containing the event data.</param> * private void PopupGridview_KeyDown(object sender, KeyEventArgs e) * { * try * { * if (e.KeyCode != Keys.Enter) return; * * SetPopupGrid(sender); * * } * catch (Exception ex) * { * * Basic.ShowMessage(3, ex.Message); * } * * } #endregion * #region 팝업그리드 뷰에서의 더블클릭 * /// <summary> * /// 팝업그리드 뷰에서의 더블클릭 * /// </summary> * /// <param name="sender">The source of the event.</param> * /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> * private void PopupGridview_DoubleClick(object sender, EventArgs e) * { * try * { * SetPopupGrid(sender); * } * catch (Exception ex) * { * * Basic.ShowMessage(3, ex.Message); * } * } #endregion * #region 팝업그리드 이벤트시 해당 컨트롤값 셋팅 * /// <summary> * /// 그리드 이벤트시 해당 컨트롤값 셋팅 * /// </summary> * /// <param name="sender">그리드뷰.</param> * /// <remarks> * /// 그리드 뷰를 넘기는 이유는 팝업에디트가 1개 이상일대 어떤컨트롤에 바인딩 할 것인가를 비교하기 위해서 * /// </remarks> * private void SetPopupGrid(object sender) * { * * try * { * DataRow r; * * r = Cls.Common.uPopupContainer.GetSelectRow(this.popFacilitycode, 0); * * if (this.popFacilitycode.Properties.PopupControl.OwnerEdit != null) * this.popFacilitycode.Properties.PopupControl.OwnerEdit.ClosePopup(); * * if (r != null) * { * this.popFacilitycode.Text = r["FACILITY_CODE"].ToString() + " " + r["FACILITY_NAME"]; * } * else * { * this.popFacilitycode.Text = "선택하세요"; * dt.Clear(); * dtCode.RejectChanges(); * dtCode.AcceptChanges(); * dtOption.Clear(); * } * * Selects(true); * } * catch (Exception ex) * { * * throw ex; * } * } #endregion * #region 파업이 열렸을때 * private void popFacilitycode_Popup(object sender, EventArgs e) * { * try * { * ((GridView)((DevExpress.XtraGrid.GridControl)this.popFacilitycode.Properties.PopupControl.Controls[0]).MainView).ClearColumnsFilter(); * } * catch(Exception ex) * { * Basic.ShowMessage(3, ex.Message); * } * } #endregion *****************************************************************************/ #endregion #region 기초코드를 바인딩합니다. /// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*=====조회항목======*/ this.dteTaskDate.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())); //영업장 코드 바인딩 BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(this.lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCode.Properties.DataSource).Rows.Count == 1) { this.lupFacilityCode.Visible = false; this.labFacilityCode.Visible = false; } else { this.lupFacilityCode.Visible = true; this.labFacilityCode.Visible = true; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate)).AddMonths(-1); this.dtpTo.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate)); /* 영업장코드 */ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacilitycode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCode.Properties.DataSource).Rows.Count == 1) { this.lblFacilityCode.Visible = false; this.lupFacilityCode.Visible = false; } else { this.lblFacilityCode.Visible = true; this.lupFacilityCode.Visible = true; } BizCommon.BasicCode.FillBasicCode(lupRoomItemPart, "DG012", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { //영업장 BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCode.Properties.DataSource).Rows.Count == 1) { this.lblFacilitycode.Visible = false; this.lupFacilityCode.Visible = false; } else { this.lblFacilitycode.Visible = true; this.lupFacilityCode.Visible = true; } //객실타입 BizCommon.General.FillRoomTypeCode(this.lupRoomType, lupFacilityCode.EditValue.ToString()); //품목구분 //BizCommon.BasicCode.FillBasicCode(lupRoomPart, "DG012", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(this.lupRoomPart, "HEAD = 'DG012' AND ITEM3 = 'Y' AND ITEM5 = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = DateTime.Now; this.dtpTo.EditValue = DateTime.Now.AddDays(7); /* 영업장코드 */ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacilitycode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); /* 객실유형 */ BizCommon.General.FillRoomTypeCode(this.lupRoomtype, this.lupFacilitycode.EditValue.ToString()); /* 객실전망 */ //BasicCode.FillBasicCode(lupRoomview, "DA004", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /* 객실전용구분 */ DataTable dttmp = new DataTable(); dttmp.Columns.Add("코드"); dttmp.Columns.Add("코드명"); dttmp.Rows.Add("일반객실", Parm_D.EXCLUSIVE_CODE_NORMAL); dttmp.Rows.Add("전용객실", Parm_D.EXCLUSIVE_CODE_EXCLUS);; Cls.Common.LookUp.SetFillCode(lupExcute, dttmp, "코드", "코드명", Cls.Common.LookUp.CaptoinStyle.SelectText); lupExcute.EditValue = "01"; //임시 객실전망 사용x //this.lupRoomview.Visible = false; ////객실 포케스팅 사용여부에 따라 전망 활성/비활성 //if (!Parm.CurrentUserInformation.roomTask.IsForcasting) //{ // this.lupRoomview.Visible = false; //} if (!Parm.CurrentUserInformation.roomTask.IsMember) { this.lupRoomtype.Enabled = false; this.lupExcute.Enabled = false; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { /*=====조회항목======*/ //조회조건 DataTable dttmp = new DataTable(); dttmp.Columns.Add("코드"); dttmp.Columns.Add("코드명"); dttmp.Rows.Add(new object[] { "ROOM_NO", "객실번호" }); dttmp.Rows.Add(new object[] { "RSV_NO", "예약번호" }); dttmp.Rows.Add(new object[] { "GUEST_NAME", "투숙객명" }); dttmp.Rows.Add(new object[] { "MEMBER_NO", "회원번호" }); dttmp.Rows.Add(new object[] { "MEMBER_NAME", "회원명" }); dttmp.Rows.Add(new object[] { "CHECKIN_DATE", "입실일자" }); this.lupSelectTerms.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete; this.lupSelectTerms.Properties.DataSource = dttmp; this.lupSelectTerms.Properties.DisplayMember = "코드명"; this.lupSelectTerms.Properties.ValueMember = "코드"; this.lupSelectTerms.Properties.AutoSearchColumnIndex = 0; this.lupSelectTerms.EditValue = "ROOM_NO"; /*=====조회항목======*/ BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.SelectText); DataTable dtTmp = (DataTable)this.lupFacilityCode.Properties.DataSource; //if (dtTmp.Rows.Count -2 == 1) if (dtTmp.Rows.Count - 1 == 1) { this.lupFacilityCode.Visible = false; this.labFacilityCode.Visible = false; } else { this.lupFacilityCode.Visible = true; this.labFacilityCode.Visible = true; } //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { string roomTask = DateTime.Now.ToString("yyyy-MM-01"); DateTime roomTaskDateTime = new DateTime(Convert.ToDateTime(roomTask).Ticks); string roomTask1 = Parm.CurrentUserInformation.roomTask.gsTaskDate; string roomTask1Date1 = roomTask1.Substring(0, 4) + "-" + roomTask1.Substring(4, 2) + "-" + roomTask1.Substring(6, 2); DateTime roomTask1DateTime1 = new DateTime(Convert.ToDateTime(roomTask1Date1).Ticks); this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = roomTaskDateTime; this.dtpTo.EditValue = roomTask1DateTime1; //영업장 BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCode.Properties.DataSource).Rows.Count == 1) { this.lblFacilitycode.Visible = false; this.lupFacilityCode.Visible = false; } else { this.lblFacilitycode.Visible = true; this.lupFacilityCode.Visible = true; } //BizCommon.BasicCode.FillBasicCode(lupRoomPart, "DG012", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(this.lupRoomPart, "HEAD = 'DG012' AND ITEM3 = 'Y' AND ITEM5 = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BizCommon.BasicCode.FillBasicCode(lupLossCode, "DG008", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.DirectManageYn = "Y"; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(this.lupFacilitySelect, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.SelectText); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { //this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; //this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; //this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; //this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; //this.dtpFrom.EditValue = DateTime.Now.AddMonths(-1); //this.dtpTo.EditValue = DateTime.Now; //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //영업장코드 BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCode.Properties.DataSource).Rows.Count == 1) { this.lupFacilityCode.Visible = false; this.labFacilityCode.Visible = false; } else { this.lupFacilityCode.Visible = true; this.labFacilityCode.Visible = true; } this.dtpTaskDate.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(fnCloseDate().Trim())); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { /* 기간 */ this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())); this.dtpTo.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())); /* 영업장코드 */ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacilitycode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); /* 동코드 */ DataTable dtParmFaci = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParmFaci.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); dtParmFaci.Rows.Add(new object[] { "V_FACILITY_CODE", Parm.CurrentUserInformation.roomTask.gsDFacility }); DataSet dsFaci = DataLayer.ExecuteSpDataset("PKG_DAAAI13.PR_06", dtParmFaci, DataLayer.MessageEncoding.Default); Cls.Common.LookUp.SetFillCode(this.lupFaci, dsFaci.Tables[0], "FACI_PART_NAME", "FACI_PART", LookUp.CaptoinStyle.SelectText); if (dsFaci.Tables[0].Rows.Count == 1) { lupFaci.EditValue = dsFaci.Tables[0].Rows[0]["FACI_PART"].ToString().Trim(); lupFaci.Enabled = false; } /*객실유형*/ BizCommon.General.FillRoomTypeCode(this.lupRoomType, this.lupFacilitycode.EditValue.ToString().Trim()); //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacility, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); BizCommon.BasicCode.FillBasicCode(lupBrokenState, "DG002", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BizCommon.BasicCode.FillBasicCode(lupBrokenCode, "DG001", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { /* 투숙일자 */ this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate)); this.dtpTo.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate)); /* 영업장코드 */ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacilitycode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); /* 검색조건 */ DataTable dttmp = new DataTable(); dttmp.Columns.Add("코드"); dttmp.Columns.Add("코드명"); dttmp.Rows.Add("전체", "0"); dttmp.Rows.Add("당일투숙자", "1"); dttmp.Rows.Add("Stay-Over", "2"); dttmp.Rows.Add("Comp", Parm_D.GUEST_TYPE_COMP); dttmp.Rows.Add("이월자", Parm_D.CHECKIN_TYPE_IWOL); dttmp.Rows.Add("VIP", "Y"); dttmp.Rows.Add("House Use", Parm_D.GUEST_TYPE_HOUSEUSE); dttmp.Rows.Add("Walk-In", Parm_D.CHECKIN_TYPE_WALKIN); Cls.Common.LookUp.SetFillCode(this.lupSearchCondition, dttmp, "코드", "코드명", Cls.Common.LookUp.CaptoinStyle.SelectText); this.lupSearchCondition.EditValue = "0"; //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*처리상태*/ BasicCode.FillBasicCode(this.lupBroken_State_ForSelect, "DG002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); this.lupBroken_State_ForSelect.ItemIndex = 1; /*고장종류(조회용)*/ BasicCode.FillBasicCode(this.lupBrokenType_ForSelect, "DG001", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*영업장코드*/ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); /*의뢰부서*/ DataTable dtBiz = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtBiz.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_DAAAI14.PR_04", dtBiz, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupDept_Sid, ds.Tables[0], "DEPT_NM", "DEPT_SID", LookUp.CaptoinStyle.SelectText ); /*고장종류(등록용)*/ BasicCode.FillBasicCode(this.lupBrokenType, "DG001", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*처리상태*/ BasicCode.FillBasicCode(this.lupBroken_State, "DG002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { //동코드를 가져온다. DataTable dtParmFaci = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParmFaci.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); dtParmFaci.Rows.Add(new object[] { "V_FACILITY_CODE", Parm.CurrentUserInformation.roomTask.gsDFacility }); DataSet dsFaci = DataLayer.ExecuteSpDataset("PKG_DAAAI13.PR_06", dtParmFaci, DataLayer.MessageEncoding.Default); Cls.Common.LookUp.SetFillCode(this.lupFaci, dsFaci.Tables[0], "FACI_PART_NAME", "FACI_PART", LookUp.CaptoinStyle.SelectText); if (dsFaci.Tables[0].Rows.Count == 1) { lupFaci.EditValue = dsFaci.Tables[0].Rows[0]["FACI_PART"].ToString().Trim(); lupFaci.Enabled = false; this.lupFloor.Focus(); } /* 영업장코드 */ BizCommon.mFacility.FacilityCondition st = new mFacility.FacilityCondition(); st.FacilityType = "10"; st.Project_ID = base.ProjectID; st.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.mFacility.SetFacility(lupFacilitycode, Parm.mDataTable.dtZaa140ms, st, LookUp.CaptoinStyle.None); /*객실상태*/ BasicCode.FillBasicCode(lupRoomStat, "DA003", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*객실전망*/ BasicCode.FillBasicCode(lupRoomView, "DA004", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*청소사태*/ BasicCode.FillBasicCode(lupCleanStat, "DA002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*객실유형*/ BizCommon.General.FillRoomTypeCode(this.lupRoomType, this.lupFacilitycode.EditValue.ToString().Trim()); //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { this.dtpMonths.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; //this.dtpTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpMonths.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; //this.dtpTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpMonths.EditValue = DateTime.Now; //this.dtpTo.EditValue = DateTime.Now; //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.SelectText); DataTable dtTmp = (DataTable)this.lupFacilityCode.Properties.DataSource; //if (dtTmp.Rows.Count - 2 == 1) if (dtTmp.Rows.Count - 1 == 1) { this.lupFacilityCode.Visible = false; this.labFacilityCode.Visible = false; } else { this.lupFacilityCode.Visible = true; this.labFacilityCode.Visible = true; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = DateTime.Now; //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //객실품목구분 //BasicCode.FillBasicCode(lupRoomItemPartName, "HEAD = 'DG012' AND ITEM3 = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //BasicCode.FillBasicCode(lupAmtWayCode, "HEAD = 'A0017' AND ITEM3 = 'Y' AND USE_YN = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupRoomItemPartName, "HEAD = 'DG012' AND ITEM3 = 'Y' AND ITEM5 = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //영업장 코드 바인딩 BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCodeSelect, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCodeSelect.Properties.DataSource).Rows.Count == 1) { this.lblFacilityCodeSelect.Visible = false; this.lupFacilityCodeSelect.Visible = false; } else { this.lblFacilityCodeSelect.Visible = true; this.lupFacilityCodeSelect.Visible = true; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*=====조회항목======*/ //영업장 코드 바인딩 BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; condition.FacilityType = "10"; condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCodeSelect, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCodeSelect.Properties.DataSource).Rows.Count == 1) { this.lblFacilityCodeSelect.Visible = false; this.lupFacilityCodeSelect.Visible = false; } else { this.lblFacilityCodeSelect.Visible = true; this.lupFacilityCodeSelect.Visible = true; } //동코드를 가져온다. DataTable dtParmFaci = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParmFaci.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); dtParmFaci.Rows.Add(new object[] { "V_FACILITY_CODE", this.lupFacilityCodeSelect.EditValue.ToString().Trim() }); DataSet dsFaci = DataLayer.ExecuteSpDataset("PKG_ROOM.PR_02", dtParmFaci, DataLayer.MessageEncoding.Default); Cls.Common.LookUp.SetFillCode(this.lupFaciPartSelect, dsFaci.Tables[0], "FACI_PART_NAME", "FACI_PART", LookUp.CaptoinStyle.SelectText); this.lupFaciPartSelect.ItemIndex = 0; if (((DataTable)this.lupFaciPartSelect.Properties.DataSource).Rows.Count == 1) { this.lupFaciPartSelect.ItemIndex = 1; this.labFaciPartSelect.Visible = false; this.lupFaciPartSelect.Visible = false; } else { this.labFaciPartSelect.Visible = true; this.lupFaciPartSelect.Visible = true; } this.lupTaskdateFrom.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim().Substring(0, 6) + "01")); this.lupTaskdateTo.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())); //처리구분 BizCommon.BasicCode.FillBasicCode(this.lupLossCodeSelect, "DG008", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //품목구분 //BizCommon.BasicCode.FillBasicCode(this.lupRoomItemPartSelect, "DG012", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(this.lupRoomItemPartSelect, "HEAD = 'DG012' AND ITEM3 = 'Y' AND ITEM5 = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*=====입력항목======*/ //BizCommon.mFacility.FacilityCondition condition = new mFacility.FacilityCondition(); //condition.DefaultFacilityCode = Parm.CurrentUserInformation.roomTask.gsDFacility; //condition.FacilityType = "10"; //condition.Project_ID = base.ProjectID; BizCommon.mFacility.SetFacility(lupFacilityCode, Parm.mDataTable.dtZaa140ms, condition, LookUp.CaptoinStyle.None); if (((DataTable)this.lupFacilityCode.Properties.DataSource).Rows.Count == 1) { this.labFacilityCode.Visible = false; this.lupFacilityCode.Visible = false; } else { this.labFacilityCode.Visible = true; this.lupFacilityCode.Visible = true; } Cls.Common.LookUp.SetFillCode(this.lupFaciPart, dsFaci.Tables[0], "FACI_PART_NAME", "FACI_PART", LookUp.CaptoinStyle.SelectText); this.lupFaciPart.ItemIndex = 0; if (((DataTable)this.lupFaciPart.Properties.DataSource).Rows.Count == 1) { this.lupFaciPart.ItemIndex = 1; this.labFaciPart.Visible = false; this.lupFaciPart.Visible = false; } else { this.labFaciPart.Visible = true; this.lupFaciPart.Visible = true; } this.dteTaskDate.EditValue = Convert.ToDateTime(Cls.Common.uDate.GetDateFromYYYY_MM_DD(Parm.CurrentUserInformation.roomTask.gsTaskDate.Trim())); BizCommon.BasicCode.FillBasicCode(lupLossCode, "DG008", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //BizCommon.BasicCode.FillBasicCode(lupRoomItemPart, "DG012", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(this.lupRoomItemPart, "HEAD = 'DG012' AND ITEM3 = 'Y' AND ITEM5 = 'Y'", "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*차수구분*/ //BizCommon.BasicCode.FillBasicCode(lupSaleinlotCnt, "A0002", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*계약기간*/ //BizCommon.BasicCode.FillBasicCode(lupContractTeam, "A0008", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*회원구분*/ //BizCommon.BasicCode.FillBasicCode(lupMemberGroupCode, "B0001", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*우대구분*/ //BizCommon.BasicCode.FillBasicCode(lupGuestType, "Z0006", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*숙박구분*/ //BizCommon.BasicCode.FillBasicCode(lupEntryCode, "A0009", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*할인코드*/ //BizCommon.BasicCode.FillBasicCode(lupSaleDC, "A0033", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*판매상태*/ //BizCommon.BasicCode.FillBasicCode(lupStatusCode, "A0022", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); ///*납부코드*/ //BizCommon.BasicCode.FillBasicCode(lupPartitionCnt, "A0015", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }