public ActionResult Index(BasicCode BasicCode, EFPagingInfo <BasicCode> p) { if (!BasicCode.CharCode.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.CharCode.Contains(BasicCode.CharCode)); } if (!BasicCode.CharText.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.CharText.Contains(BasicCode.CharText)); } if (!BasicCode.Sort.IsNullOrEmpty()) { p.SqlWhere.Add(f => f.Sort == BasicCode.Sort); } p.OrderByList.Add("Id", "DESC"); IPageOfItems <BasicCode> BasicCodeList = Entity.Selects <BasicCode>(p); ViewBag.BasicCodeList = BasicCodeList; ViewBag.BasicCode = BasicCode; ViewBag.Add = this.checkPower("Add"); ViewBag.Edit = this.checkPower("Edit"); ViewBag.Delete = this.checkPower("Delete"); ViewBag.Save = this.checkPower("Save"); return(View()); }
void DuplicateTurret() { if (BuildManager.isDuplicated == false) { Debug.Log("Select the duplicate option!"); return; } if (PlayerStats.Money < BuildManager.duplicatedBlueprint.cost) { Debug.Log("Not enough money to build that!"); return; } PlayerStats.Money -= BuildManager.duplicatedBlueprint.cost; turret = (GameObject)Instantiate(BuildManager.duplicatedPrefab, transform.position, transform.rotation); turret.transform.SetParent(transform); // To make sure that turret instantiates correctly turret.transform.localPosition = Vector3.zero; turret.transform.localScale = Vector3.one; blueprint = BuildManager.duplicatedBlueprint; this.GetComponent <DisplayConsole>().towerConsole = ((GameObject)Instantiate(BuildManager.duplicatedTowerconsole)).transform; this.GetComponent <DisplayConsole>().codeShop = ((GameObject)Instantiate(BuildManager.duplicatedCodeshop)).transform; BasicCode towerConsoleRef = this.GetComponent <DisplayConsole>().towerConsole.transform.GetChild(1).GetComponent <BasicCode>(); towerConsoleRef.SetTowerRef(turret.transform); towerConsoleRef.UpdateTowerRef(); }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*=====조회항목======*/ this.dtpFrom.EditValue = DateTime.Now.AddMonths(-1); this.dtpTo.EditValue = DateTime.Now; /*=====입력항목======*/ BasicCode.FillBasicCode(lupSaleLot, "A0002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupAccountCode, "A0007", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupCommodityCode, "A0004", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPaymentCode, "A0032", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPurchaseCode, "A0005", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupCancelYn, "Z0000", BasicCode.BasicCodeReturnStyle.Default, "N", BasicCode.LookupSearchStyle.DisplayMember); this.dteGiveDate.EditValue = DateTime.Now; } 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; /*영업장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_COMM.PR_05", dtparmSelect, DataLayer.MessageEncoding.Default); Cls.Common.LookUp.SetFillCode(this.lupFacilityCode, ds.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); BasicCode.FillBasicCode(lupFacilityType, "J0003", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*=====조회항목======*/ //분양차수 BasicCode.FillBasicCode(lupSaleInLotCntSelect, "A0002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //회원타입 BasicCode.FillBasicCode(lupCommodityCodeSelect, "A0004", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //특별혜택 string Filter1 = "HEAD = 'Z0006' AND ITEM2 = 'Y'"; BasicCode.FillBasicCode(lupGuesttypeSelect, Filter1, "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*=====입력항목======*/ //특별혜택 Filter1 = "HEAD = 'Z0006' AND ITEM2 = 'Y'"; BasicCode.FillBasicCode(lupGuesttype, Filter1, "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); this.dtpStartDate.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpEndDate.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpOccurDate.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01]) "; this.dtpStartDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpEndDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpOccurDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpStartDate.EditValue = DateTime.Now; this.dtpEndDate.EditValue = DateTime.Now; this.dtpOccurDate.EditValue = DateTime.Now; } 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; BasicCode.FillBasicCode(lupProductGroupCode_Select, "A0003", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPurchaseCode, "A0005", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupSaleinlotcnt, "A0002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupFullYn, "A0091", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupCommodityCode, "A0004", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPaymentCode, "A0015", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPartitionCode, "A0032", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupSortValue, "A0042", BasicCode.BasicCodeReturnStyle.Default); if (((DataTable)(lupSortValue.Properties.DataSource)).Rows.Count > 0) { lupSortValue.ItemIndex = 0; } } catch (Exception ex) { throw ex; } }
/// <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 AAABI09_Load(object sender, EventArgs e) { try { ///TODO:[입회보증금반환등록] - 폼로드이벤트 //상품구분 BasicCode.FillBasicCode(lupProdCodeSelect, "A0003", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //법인구분 BasicCode.FillBasicCode(lupPurchaseCodeSelect, "A0005", BasicCode.BasicCodeReturnStyle.SelectStringCaption); //해약여부 BasicCode.FillBasicCode(lupCancelYnSelect, "Z0000", BasicCode.BasicCodeReturnStyle.Default, "Y", BasicCode.LookupSearchStyle.DisplayMember); //일자 초기화 this.datReturnDate.EditValue = DateTime.Now; //테이터 테이블 스키마 설정 SetDataTable(); //기초코드 바인딩 SetBasicCodeBinding(); } catch (Exception ex) { //폼로드시 에러.. 화면을 닫는다. //화면을 닫을때 로드이벤트에서 종료하면 //에러가난다. 그렇기때문에 종료타이머를 호출한다. Basic.ShowMessage(3, ex.Message); this.timer_Close.Enabled = true; } }
/// <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.AddMonths(1); //영업장 DataTable dtBiz = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtBiz.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet dsTmp = DataLayer.ExecuteSpDataset("PKG_COMM.PR_02", dtBiz, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupFacilitycode, dsTmp.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); //객실유형 DataTable dtRoom = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtRoom.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet dsTmp1 = DataLayer.ExecuteSpDataset("PKG_COMM.PR_17", dtRoom, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupRoomtype, dsTmp1.Tables[0], "ROOM_TYPE_NAME", "ROOM_TYPE", LookUp.CaptoinStyle.SelectText); //회원구분 BasicCode.FillBasicCode(this.lupMemberCode, "B0001", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //법인구분 BasicCode.FillBasicCode(lupPurchaseCode, "A0005", 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; } }
//주석을 풀고 사용하세요 /***************************************************************************** * #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, "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 { /*=====조회항목======*/ //영업장 DataTable dtBiz = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtBiz.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet dsTmp = DataLayer.ExecuteSpDataset("PKG_COMM.PR_02", dtBiz, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupSrchFacilityCode, dsTmp.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); //객실유형 DataTable dtRoom = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtRoom.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet dsTmp1 = DataLayer.ExecuteSpDataset("PKG_COMM.PR_17", dtRoom, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupSrchRoomType, dsTmp1.Tables[0], "ROOM_TYPE_NAME", "ROOM_TYPE", LookUp.CaptoinStyle.SelectText); //해지여부 BasicCode.FillBasicCode(lupSrchCancelYn, "Z0000", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { 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.datAmtDate.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.datAmtDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = DateTime.Now.AddMonths(-1); this.dtpTo.EditValue = DateTime.Now; this.datAmtDate.EditValue = DateTime.Now; BizCommon.BasicCode.FillBasicCode(lupFamilyYn, "Z0000", BizCommon.BasicCode.BasicCodeReturnStyle.Default); this.lupFamilyYn.EditValue = "N"; BizCommon.BasicCode.FillBasicCode(lupGubun, "B0070", BasicCode.BasicCodeReturnStyle.Default, "01", BasicCode.LookupSearchStyle.DisplayMember); /*=====입력항목======*/ BizCommon.BasicCode.FillBasicCode(lupRegwaycode, "B0071", BasicCode.BasicCodeReturnStyle.Default, "01", BasicCode.LookupSearchStyle.DisplayMember); BizCommon.BasicCode.FillBasicCode(lupRegreasoncode, "B0072", BasicCode.BasicCodeReturnStyle.Default, "01", BasicCode.LookupSearchStyle.DisplayMember); //입금수단 BasicCode.FillBasicCode(lupAmtWayCode, "HEAD = 'A0017' AND ITEM2 = 'Y' AND USE_YN = '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.dtpPrintDate.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.dtpPrintDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = DateTime.Now.AddMonths(-1); this.dtpTo.EditValue = DateTime.Now; this.dtpPrintDate.EditValue = DateTime.Now; BasicCode.FillBasicCode(lupProductGroupCode_Select, "A0003", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPurchaseCode, "A0005", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupCancelYn, "Z0000", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupFullYn, "Z0000", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } 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 { /*=====조회항목======*/ /*채널구분*/ BasicCode.FillBasicCode(lupChCodeSelect, "B0040", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*사용여부*/ BasicCode.FillBasicCode(lupUseYnSelect, "Z0000", BasicCode.BasicCodeReturnStyle.Default, "Y", BasicCode.LookupSearchStyle.DisplayMember); /*=====입력항목======*/ this.datRegDate.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])"; this.datRegDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.datRegDate.EditValue = DateTime.Now; /*채널구분*/ BasicCode.FillBasicCode(lupChCode, "B0040", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*발송구분*/ BasicCode.FillBasicCode(lupSendCode, "B0041", BasicCode.BasicCodeReturnStyle.SelectStringCaption); /*사용여부*/ BasicCode.FillBasicCode(lupUseYn, "Z0000", BasicCode.BasicCodeReturnStyle.Default, "Y", BasicCode.LookupSearchStyle.DisplayMember); } 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; BasicCode.FillBasicCode(lupSaleLotFrom, "A0002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupSaleLotTo, "A0002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupCommoityCode, "A0004", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPurchaseCode, "A0005", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupPaymentCode, "A0032", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupAccountCode, "A0007", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
public void Save(BasicCode BasicCode) { BasicCode baseBasicCode = Entity.BasicCode.FirstOrDefault(n => n.Id == BasicCode.Id); baseBasicCode = Request.ConvertRequestToModel <BasicCode>(baseBasicCode, BasicCode); Entity.SaveChanges(); BaseRedirect(); }
protected void Page_Load(object sender, System.EventArgs e) { if (!base.IsPostBack) { System.Collections.Generic.IList <BasicCode> byType = BasicCode.GetByType("ProjectState"); this.rptProjectState.DataSource = byType; this.rptProjectState.DataBind(); } }
public void Delete(BasicCode BasicCode, string InfoList, int?IsDel) { if (string.IsNullOrEmpty(InfoList)) { InfoList = BasicCode.Id.ToString(); } int Ret = Entity.MoveToDeleteEntity <BasicCode>(InfoList, IsDel, AdminUser.UserName); Entity.SaveChanges(); Response.Write(Ret); }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { 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_COMM.PR_02", dtBiz, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupSrchFacilityCode, dsTmp.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); //객실유형 DataTable dtRoom = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtRoom.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet dsTmp1 = DataLayer.ExecuteSpDataset("PKG_COMM.PR_17", dtRoom, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupSrchRoomType, dsTmp1.Tables[0], "ROOM_TYPE_NAME", "ROOM_TYPE", LookUp.CaptoinStyle.SelectText); //날짜마스크값 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; this.dtpSysDateFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])"; this.dtpSysDateTo.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])"; this.dtpSysDateFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpSysDateTo.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpSysDateFrom.EditValue = DateTime.Now.AddDays(-1); this.dtpSysDateTo.EditValue = DateTime.Now; //공통코드 //BizCommon.BasicCode.FillBasicCode(lupStatusCode, "C0001", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); string filter1 = "HEAD = 'C0001' AND DETAIL <> ' ' AND USE_YN = 'Y' AND ITEM1 = 'Y'"; BasicCode.FillBasicCode(lupStatusCode, filter1, "USE_SORT", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BizCommon.BasicCode.FillBasicCode(lupRsvWay, "C0017", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //시간마스크값 Cls.Common.uMask.SetMask(txtSysTimeFrom, Parm.mMask.TIME); Cls.Common.uMask.SetMask(txtSysTimeTo, Parm.mMask.TIME); txtSysTimeFrom.Text = "17:00"; txtSysTimeTo.Text = "17:00"; //우대구분 BizCommon.BasicCode.FillBasicCode(lupGuestType, "Z0006", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //회원구분 BizCommon.BasicCode.FillBasicCode(this.lupMemberCode, "B0001", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { BasicCode.FillBasicCode(lupCashBill_IdCode, "Z0028", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { BasicCode.FillBasicCode(lupGiftPart, "AE001", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
public void ChangeStatus(BasicCode BasicCode, string InfoList, string Clomn, string Value) { if (string.IsNullOrEmpty(InfoList)) { InfoList = BasicCode.Id.ToString(); } int Ret = Entity.ChangeEntity <BasicCode>(InfoList, Clomn, Value); Entity.SaveChanges(); Response.Write(Ret); }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*=====조회항목======*/ BasicCode.FillBasicCode(lupCancelYnSelect, "Z0000", BasicCode.BasicCodeReturnStyle.Default, "N", BasicCode.LookupSearchStyle.DisplayMember); } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { BasicCode.FillBasicCode(lupProductGroupCode_Select, "A0003", BasicCode.BasicCodeReturnStyle.Default, "E", BasicCode.LookupSearchStyle.ValueMember); BasicCode.FillBasicCode(lupSaleinlotcnt, "A0002", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /*=====입력항목======*/ BasicCode.FillBasicCode(lupBankCode, "H0020", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
//录入基本代码表 public void Insert(BasicCode basiccode) { try { dbcontext.BasicCodeContext.Add(basiccode); dbcontext.SaveChanges(); } catch { throw; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { BasicCode.FillBasicCode(lupUseYn_L, "Z0000", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupUseYn_M, "Z0000", BasicCode.BasicCodeReturnStyle.SelectStringCaption); BasicCode.FillBasicCode(lupUseYn_S, "Z0000", 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 { this.dtpSaleDate.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])"; this.dtpSaleDate.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpSaleDate.EditValue = DateTime.Now; BasicCode.FillBasicCode(lupFacilityType, "J0003", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤들 초기화 /// </summary> private void InitControls() { DataSet dsLookup = DataLayer.ExecuteSpDataset("PKG_ALAAI11.PR_00", DataLayer.MessageEncoding.Default); // 소수점처리 LookUp.SetFillCode(lupDecimalMethod, dsLookup.Tables[0], "DECIMAL_METHOD_NAME", "DECIMAL_METHOD", LookUp.CaptoinStyle.SelectText); // 예외구분 LookUp.SetFillCode(lupExceptDiv, dsLookup.Tables[1], "EXCEPT_DIV_NAME", "EXCEPT_DIV", LookUp.CaptoinStyle.None); lupExceptDiv.EditValue = "S"; // 예외구분값 (우대구분, 시즌, 영업장) BasicCode.FillBasicCode(lupExceptDivValue, "C0012", BasicCode.BasicCodeReturnStyle.Default); }
//删除 public void Delete(int BasicCodeID) { try { BasicCode basiccode = dbcontext.BasicCodeContext.Where(u => u.BasicCodeID == BasicCodeID).FirstOrDefault(); dbcontext.BasicCodeContext.Attach(basiccode); dbcontext.BasicCodeContext.Remove(basiccode); dbcontext.SaveChanges(); } catch { throw; } }