/// <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.AddMonths(1); //BizCommon.BasicCode.FillBasicCode(lupRsvNo, "DA009", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
private void PrepareEmployeeDocuments(HttpFileCollection hfc, EmployeeHeader employeeHeader, List <EmployeeDocument> employeeDocuments, List <EmployeeDocumentViewModel> employeeDocumentViewModel) { for (var i = 0; i < hfc.Count; i++) { HttpPostedFile httpPostedFileBase = hfc[i]; foreach (var item in employeeDocumentViewModel) { if (item.Name == httpPostedFileBase.FileName) { EmployeeDocument employeeDocument = new EmployeeDocument(); LookUp lookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == item.DocumentType).FirstOrDefault(); bool employeeHeaders = employeeHeader.EmployeeDocument != null?employeeHeader.EmployeeDocument.Any(e => e.DocumentType == lookUp.LookUpID && e.FileName == item.Name) : false; if (!employeeHeaders) { employeeDocument.CreatedBy = USER_OBJECT.UserID; employeeDocument.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now); employeeDocument.FileName = httpPostedFileBase.FileName; employeeDocument.BranchId = USER_OBJECT.BranchId; employeeDocument.DocumentType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == item.DocumentType).Select(s => s.LookUpID).FirstOrDefault();; // employeeDocuments.Add(employeeDocument); SaveFile(httpPostedFileBase); employeeHeader.EmployeeDocument = employeeHeader.EmployeeDocument == null ? new List <EmployeeDocument>() : employeeHeader.EmployeeDocument; employeeHeader.EmployeeDocument.Add(employeeDocument); } } } } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { this.dtpFrom.Properties.Mask.EditMask = "(1[9]|2[0-9])\\d\\d-(0[1-9]|1[012]) "; this.dtpFrom.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.RegEx; this.dtpFrom.EditValue = DateTime.Now.ToString("yyyyMM"); this.dtpFrom.Properties.Mask.UseMaskAsDisplayFormat = true; DataTable dtlupFacility = new DataTable("dtlupFacility"); dtlupFacility.Columns.Add("FACILITY_CODE"); dtlupFacility.Columns.Add("FACILITY_NAME"); DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParm.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_COMM.PR_25", dtParm, DataLayer.MessageEncoding.Default); dtlupFacility.Load(ds.Tables[0].CreateDataReader()); LookUp.SetFillCode(lupFacilityCode, dtlupFacility, "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None); this.lupFacilityCode.ItemIndex = 0; } catch (Exception ex) { Basic.ShowMessage(3, ex.Message); } }
public ActionResult NewVAT(string vat) { if (_systemService.GetLookUp(Constants.LuVat).Count(m => m.LookUpValue.Equals(vat)) > 0) { return(Json(new { result = Constants.Duplicate })); } try { var model = new LookUp { LookUpType = Constants.LuVat, LookUpKey = vat, LookUpValue = vat, Enable = true }; _systemService.InsertLookUp(model); return(Json(new { result = Constants.Success })); } catch (Exception e) { Log.Error("Create New Client!", e); return(Json(new { result = Constants.UnSuccess })); } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { //this.lupFacilityCode DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParm.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet dsTmp = DataLayer.ExecuteSpDataset("PKG_COMM.PR_02", dtParm, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupFacilityCode, dsTmp.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None); this.lupFacilityCode.EditValue = Parm.CurrentUserInformation.roomTask.gsDFacility; //영업장을 숨긴다 //this.lupFacilityCode.Visible = false; if (dsTmp.Tables[0].Rows.Count == 1) { this.lupFacilityCode.Visible = false; this.labFacilityCode.Visible = false; } //시즌바인딩 GetSeason(); // 마감 체크하여 버튼 enable 변경 SetNAStatus(CheckNAStart()); } 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())); string filter = string.Format("USE_YN = 'Y' AND PROJECT_ID = '{0}' AND FACILITY_TYPE = '10' ", base.ProjectID); LookUp.SetFillCode(this.lupFacility, Basic.GetdtSelect(BizCommon.Parm.mDataTable.dtZaa140ms, filter, "FACILITY_CODE"), "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None ); this.lupFacility.EditValue = Parm.CurrentUserInformation.roomTask.gsDFacility; BizCommon.BasicCode.FillBasicCode(lupRoomStat, "DA003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); //BizCommon.BasicCode.FillBasicCode(lupProductGroupCode_Select , "A0003", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { /* 기수 */ DataTable dtParm = DataLayer.GetDataTableParameter(DataLayer.DatatableStyle.Parameter); dtParm.Rows.Add(new object[] { "V_BIZ_CODE", Parm.CurrentUserInformation.BizInfo.BizCode }); DataSet ds = DataLayer.ExecuteSpDataset("PKG_COMM.PR_21", dtParm, DataLayer.MessageEncoding.Default); LookUp.SetFillCode(this.lupYear, ds.Tables[0], "DETAIL_NAME", "DETAIL", LookUp.CaptoinStyle.None); this.lupYear.ItemIndex = 0; /* 기간 */ 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; /* 법인구분 */ BizCommon.BasicCode.FillBasicCode(lupPurchaseCode, "A0005", BasicCode.BasicCodeReturnStyle.SelectStringCaption); } catch (Exception ex) { throw ex; } }
void ServiceClient_GetSysMenuByIDCompleted(object sender, GetSysMenuByIDCompletedEventArgs e) { LookUp lkParentMenu = Utility.FindChildControl <LookUp>(expander, "lkParentMenu"); lkParentMenu.DataContext = e.Result; lkParentMenu.DisplayMemberPath = "MENUNAME"; }
public ActionResult SaveEmployeeDesignation(LookUp lookup) { lookup.LookUpCategory = UTILITY.CONFIG_EMPLOYEEDESIGNATION; lookup.BranchId = BRANCHID; lookUpBO.Add(lookup); return(RedirectToAction("EmployeeDesignationList")); }
//주석을 풀고 사용하세요 /***************************************************************************** * #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; } }
public LookUp Get(string code, long parentId, bool isDiffer) { try { LookUp lookup = new LookUp(); try { using (LMJEntities db = new LMJEntities()) { lookup = db.LookUps .Where(e => e.Code == code && e.ParentId == parentId && e.IsDeleted == false) .FirstOrDefault(); } } catch (Exception ex) { throw; } return(lookup); } catch (Exception ex) { throw; } }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { string filter = string.Format("USE_YN = 'Y' AND PROJECT_ID = '{0}'", base.ProjectID); BizCommon.BasicCode.FillBasicCode(lupGuestTypeSelect, "Z0006", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); LookUp.SetFillCode(this.lupFacilitycodeSelect, Basic.GetdtSelect(BizCommon.Parm.mDataTable.dtZaa140ms, filter, "FACILITY_CODE ASC"), "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); BizCommon.BasicCode.FillBasicCode(lupGuestType, "Z0006", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BizCommon.BasicCode.FillBasicCode(lupMenuitem1, "C0012", BizCommon.BasicCode.BasicCodeReturnStyle.SelectStringCaption); BizCommon.BasicCode.FillBasicCode(lupMenuitem2, "Z0010", BizCommon.BasicCode.BasicCodeReturnStyle.Default); LookUp.SetFillCode(this.lupFacilitycode, Basic.GetdtSelect(BizCommon.Parm.mDataTable.dtZaa140ms, filter, "FACILITY_CODE ASC"), "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); if (lupMenuitem2.EditValue != null) { lupMenuitem2.ItemIndex = 0; } } catch (Exception ex) { throw ex; } }
private void SearchButton_Click(object sender, RoutedEventArgs e) { string filter = " 1=1 "; int pageCount = 0; ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值 ComboBox cbxSystemType = Utility.FindChildControl <ComboBox>(expander, "cbxSystemType"); //T_SYS_DICTIONARY dict = cbxSystemType.SelectedItem as T_SYS_DICTIONARY; //string systype = dict == null ? "" : dict.DICTIONARYVALUE.GetValueOrDefault().ToString(); string parentid = ""; LookUp lkParentMenu = Utility.FindChildControl <LookUp>(expander, "lkParentMenu"); T_SYS_ENTITYMENU menu = lkParentMenu.DataContext as T_SYS_ENTITYMENU; if (!string.IsNullOrEmpty(StrSystemType)) { filter += " && SYSTEMTYPE ==@" + paras.Count().ToString(); paras.Add(StrSystemType); } if (menu != null) { parentid = menu.ENTITYMENUID; if (!string.IsNullOrEmpty(parentid)) { filter += " && T_SYS_ENTITYMENU2!=null && T_SYS_ENTITYMENU2.ENTITYMENUID ==@" + paras.Count().ToString(); paras.Add(parentid); } } SMT.Saas.Tools.PermissionWS.LoginUserInfo loginUserInfo = new SMT.Saas.Tools.PermissionWS.LoginUserInfo(); loginUserInfo.companyID = Common.CurrentLoginUserInfo.UserPosts[0].CompanyID; loginUserInfo.userID = Common.CurrentLoginUserInfo.EmployeeID; //loadbar.Start(); RefreshUI(RefreshedTypes.ShowProgressBar); client.GetSysMenuByTypePagingAsync(0, 500, "ORDERNUMBER", filter, paras, pageCount, loginUserInfo); }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SetControlnitialize() { try { string filter = "FACILITY_TYPE = '10' AND USE_YN = 'Y' AND DIRECT_MANAGE_YN = 'Y'"; LookUp.SetFillCode(this.lupFacilityCode, Basic.GetdtSelect(Parm.mDataTable.dtJaa010ms, filter, "FACILITY_CODE"), "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.None ); int cntf = int.Parse(Parm.mDataTable.dtJaa010ms.Compute("COUNT(FACILITY_CODE)", filter).ToString().Trim()); if (cntf < 1) { throw new Exception("등록된 객실영업장이 없습니다."); } string filter1 = filter + string.Format(" AND FACILITY_CODE = '{0}'", Parm.CurrentUserInformation.roomTask.gsDFacility); int cnt = int.Parse(Parm.mDataTable.dtJaa010ms.Compute("COUNT(FACILITY_CODE)", filter1).ToString().Trim()); this.lupFacilityCode.EditValue = Parm.CurrentUserInformation.roomTask.gsDFacility; //영업장을 숨긴다 this.lupFacilityCode.Visible = false; this.lblFacilityCode.Visible = false; //SetTabPage(); // 탭페이지 생성 } catch (Exception ex) { throw ex; } }
public List <LookUp> getPeople(short?personTypeFK) { List <LookUp> l = new List <LookUp>(); using (SqlConnection conn = new SqlConnection(DBConnect.GetSchoolConnStr())) { using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "uspGetPeople"; if (personTypeFK != null) { cmd.Parameters.Add("@personTypeFK", SqlDbType.SmallInt).Value = personTypeFK; } conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { LookUp p = new LookUp(); p.keyfield = Convert.ToInt16(rdr["KeyField"].ToString()); p.name = rdr["name"].ToString(); l.Add(p); } } return(l); } }
public async Task <TaskCreateModel> AssignLookUps(IQueryable <Project> projects, TaskCreateModel model) { LookUp lookups = null; try { lookups = await _cacheHelper.CheckLookupCache(_cache); } catch (Exception ex) { var error = ex; } model.EffortDesc = lookups.Efforts; model.ResourceDesc = lookups.Resources; model.StatusDesc = lookups.Statuses; model.ProjectName = projects .Select(y => new SelectListItem { Value = y.Id.ToString(), Text = $"{y.Description}" }); return(model); }
/// <summary> /// 选择班次 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void lkShiftName_FindClick(object sender, EventArgs e) { Dictionary <string, string> cols = new Dictionary <string, string>(); cols.Add("SHIFTNAME", "SHIFTNAME"); cols.Add("WORKTIME", "WORKTIME"); LookupForm lookup = new LookupForm(SMT.Saas.Tools.OrganizationWS.EntityNames.ShiftDefine, typeof(T_HR_SHIFTDEFINE[]), cols); lookup.SelectedClick += (o, ev) => { T_HR_SHIFTDEFINE ent = lookup.SelectedObj as T_HR_SHIFTDEFINE; LookUp lkShiftName = sender as LookUp; if (ent != null) { lkShiftName.DataContext = ent; if (lkDefaultShiftName.DataContext != null) { T_HR_SHIFTDEFINE entDefault = lkDefaultShiftName.DataContext as T_HR_SHIFTDEFINE; if (ent.SHIFTDEFINEID != entDefault.SHIFTDEFINEID) { lkDefaultShiftName.DataContext = null; } } } }; lookup.Show <string>(DialogMode.Default, SMT.SAAS.Main.CurrentContext.Common.ParentLayoutRoot, "", (result) => { }); }
/// <summary> /// 기초코드를 바인딩합니다. /// </summary> private void SetBasicCodeBinding() { try { string filter = string.Format("USE_YN = 'Y' AND PROJECT_ID = '{0}'", base.ProjectID); LookUp.SetFillCode(this.lupFacilitycodeSelect, Basic.GetdtSelect(BizCommon.Parm.mDataTable.dtZaa140ms, filter, "FACILITY_CODE ASC"), "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); //LookUp.SetFillCode(this.lupFacilitycode, // Basic.GetdtSelect(BizCommon.Parm.mDataTable.dtZaa140ms, filter, "FACILITY_CODE ASC"), // "FACILITY_NAME", // "FACILITY_CODE", // 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 = 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)); } 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); DataTable dtTmp = Basic.GetdtSelect(Parm.mDataTable.dtZx010ms, "HEAD = 'F0002' AND USE_YN = 'Y' AND DETAIL <> ' ' ", "ITEM1"); LookUp.SetFillCode(this.lupFacilityType, dtTmp, "DETAIL_NAME", "ITEM1", LookUp.CaptoinStyle.SelectText); if (((DataTable)lupFacilityType.Properties.DataSource).Rows.Count <= 0) { Basic.ShowMessage(1, "선택가능한 영업장타입이 없습니다."); this.btnSelect.Enabled = false; this.btnExecel.Enabled = false; } } catch (Exception ex) { throw ex; } }
/// <summary> /// 컨트롤을 셋팅합니다. /// </summary> private void SettingControl() { 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); LookUp.SetFillCode(this.lupFactory, dsTmp.Tables[0], "FACILITY_NAME", "FACILITY_CODE", LookUp.CaptoinStyle.SelectText); if (dsTmp.Tables[0].Rows.Count > 0) { this.lupFactory.EditValue = dsTmp.Tables[0].Rows[0]["FACILITY_CODE"].ToString().Trim(); } this.dtpStart.EditValue = System.DateTime.Now; this.dtpEnd.EditValue = System.DateTime.Now.AddDays(30); Cls.Common.uMask.SetMask(dtpStart, Parm.mMask.DATE); Cls.Common.uMask.SetMask(dtpEnd, Parm.mMask.DATE); } catch (Exception ex) { throw ex; } }
public ValueDataResponse <LookUp> AddLookUpData(LookUp lookup) { ValueDataResponse <LookUp> response = new ValueDataResponse <LookUp>(); try { var result = _appContext.LookUps.Add(lookup); _appContext.SaveChanges(); if (result != null) { response.Result = lookup; response.IsSuccess = true; response.AffectedRecords = 1; response.EndUserMessage = "LookUp Added Successfully"; } else { response.IsSuccess = true; response.AffectedRecords = 0; response.EndUserMessage = "LookUp Added Failed"; } } catch (Exception ex) { response.IsSuccess = false; response.AffectedRecords = 0; response.EndUserMessage = ex.InnerException == null ? ex.Message : ex.InnerException.Message; response.Exception = ex; } return(response); }
public bool UpdatePosition(string positionCode, long tableId, bool isAdd, long?recordId) { try { //delete if (!isAdd) { //get position LookUp position = _LookUpAccessor.Get(positionCode, (long)recordId, false); LookUpMultiLanguage multi = new LookUpMultiLanguage(); LookUpMultiLanguage posMulti = new LookUpMultiLanguage(); posMulti = _LookUpMultiAccessor.Get(position.Id, 1); List <LookUp> positions = _LookUpAccessor.GetList(tableId).Where(e => e.Code == positionCode && e.Id != position.Id && e.IsDeleted == false).ToList(); foreach (LookUp p in positions) { //get multi multi = new LookUpMultiLanguage(); multi = _LookUpMultiAccessor.Get(p.Id, 1); if (long.Parse(multi.Description) >= long.Parse(posMulti.Description)) { //update _LookUpMultiAccessor.EditDesription(multi.Id, (long.Parse(multi.Description) - 1).ToString()); } } } else { List <LookUp> positions = _LookUpAccessor.GetList(tableId, positionCode); LookUpMultiLanguage multi = new LookUpMultiLanguage(); foreach (LookUp p in positions) { //get multi multi = new LookUpMultiLanguage(); if (tableId == 26) { multi = _LookUpMultiAccessor.Get(p.Id, null); } else { multi = _LookUpMultiAccessor.Get(p.Id, 1); } _LookUpMultiAccessor.EditDesription(multi.Id, (long.Parse(multi.Description) + 1).ToString()); } } return(true); } catch (Exception ex) { return(false); throw; } }
public override async Task <ChatRooms> GetChatRooms(LookUp request, ServerCallContext context) { var result = new ChatRooms(); var allChatRooms = await _chatRepository.GetAll(); result.ChatRooms_.AddRange(allChatRooms); return(result); }
public static INamingConvention GetInstanceOfNamingConvention() { var wordLookUp = new LookUp(GetInstanceOfIStreamReader()); var nameSplitter = new Splitter(); var metric = GetInstanceOfIMetric(); return(new NamingConvention(wordLookUp, nameSplitter, metric)); }
public ActionResult DeleteConfirmed(int id) { LookUp lookUp = db.LookUps.Find(id); db.LookUps.Remove(lookUp); db.SaveChanges(); return(RedirectToAction("Index")); }
public BundleSearch(Postgres postgres, OracleDB oracle, LookUp lookup) { this.postgres = postgres; this.oracle = oracle; this.lookup = lookup; InitializeComponent(); }
public ActionResult SaveLeaveType(LookUp lookup) { lookup.LookUpCategory = UTILITY.CONFIG_EMPLOYEELEAVETYPE; lookup.BranchId = BRANCHID; lookUpBO.Add(lookup); otherLeaveBo.AddLookUp(lookup); return(RedirectToAction("LeaveList")); }
public void AddToClose() { if (CheckRole()) { if (rbtIsAutono.IsChecked == true) { if (string.IsNullOrEmpty(perm.PERMISSIONCODE)) { Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), "权限编码不能为空"); return; } else { perm.ISCOMMOM = "0"; } LookUp lkParentMenu = Utility.FindChildControl <LookUp>(expander, "lkParentMenu"); T_SYS_ENTITYMENU menu = lkParentMenu.DataContext as T_SYS_ENTITYMENU; if (menu != null) { perm.T_SYS_ENTITYMENU = menu; //perm.T_SYS_ENTITYMENUReference.EntityKey = menu.EntityKey; perm.T_SYS_ENTITYMENU.ENTITYMENUID = menu.ENTITYMENUID; } } else { perm.ISCOMMOM = "1"; perm.PERMISSIONCODE = "";//是公共权限不设置编码 } if (!string.IsNullOrEmpty(perm.PERMISSIONVALUE)) { if (perm.PERMISSIONVALUE.IndexOf("-") > -1) { Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), "权限值不能为负数"); return; } try { int IntValue = System.Int32.Parse(perm.PERMISSIONVALUE); } catch (Exception ex) { Utility.ShowCustomMessage(MessageTypes.Message, Utility.GetResourceStr("WARING"), "权限值必须为整数"); return; } } if (FormTypes.New == this.FormType) { client.SysPermissionAddAsync(perm); } else { client.SysPermissionUpdateAsync(perm); } } }
void CalculateView() { Rotation = Quaternion.CreateFromYawPitchRoll(AngleV, AngleH, 0); Forward = Vector3.Transform(VectorF, Rotation); Forward.Normalize(); Side = Vector3.Transform(VectorH, Rotation); Side.Normalize(); LookUp = Vector3.Transform(VectorV, Rotation); LookUp.Normalize(); viewMatrix = Matrix.CreateLookAt(Position, Position + Forward, LookUp); }
private static LookUp MapLookUp(IDataReader reader) { LookUp lookUp = new LookUp(); int idx = 0; lookUp.Id = reader.GetSafeInt32(idx++); lookUp.Name = reader.GetSafeString(idx++); return(lookUp); }
public List<LookUp> getLookUps(string lookup_Name) { dl = new DataLayer(pConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_get_lookup_values"; cmd.Parameters.AddWithValue("@lookup_Name", lookup_Name); DataTable dt = dl.Execute(cmd); List<LookUp> Lookups = new List<LookUp>(); foreach (DataRow dr in dt.Rows) { LookUp lookup = new LookUp { lookup_id = dr["lookup_id"].ToString(), lookup_name = dr["lookup_name"].ToString().ToLower(), lookup_value = dr["lookup_value"].ToString().ToLower(), lookup_display_text = dr["lookup_display_text"].ToString().ToLower() }; Lookups.Add(lookup); } return Lookups; }