public JsonResult GetLookup(Dictionary <string, object> ctx, int windowNo, int column_ID, int AD_Reference_ID, string columnName, int AD_Reference_Value_ID, bool isParent, string validationCode) { Ctx _ctx = new Ctx(ctx); //Ctx _ctx = null;//(ctx) as Ctx; Lookup res = LookupHelper.GetLookup(_ctx, windowNo, column_ID, AD_Reference_ID, columnName, AD_Reference_Value_ID, isParent, validationCode); return(Json(JsonConvert.SerializeObject(res), JsonRequestBehavior.AllowGet)); }
public ActionResult Index(int?page, string searchText, int resetTo = 0) { if (resetTo == 1) { page = 1; } var status = LookupHelper.GetStatuses(Request.Cookies["_culture"]); ViewBag.Status = new SelectList(status, "Id", "Name"); ViewBag.StatusEdit = new SelectList(status, "Id", "Name"); ViewBag.StatusDetails = new SelectList(status, "Id", "Name"); ViewBag.StatusEditDetails = new SelectList(status, "Id", "Name"); var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); var masterLookupsForcurrentLan = _db.MasterLookupTranslations .Where(r => (r.LanguageId == currentLanguageId) && r.MasterLookup.Status != (int)GeneralEnums.StatusEnum.Deleted).Select(c => c.MasterLookupId); var masterLookup = _db.MasterLookupTranslations .Where(r => (r.IsDefault) && r.MasterLookup.Status != (int)GeneralEnums.StatusEnum.Deleted && !masterLookupsForcurrentLan.Contains(r.MasterLookupId)) .Union( _db.MasterLookupTranslations .Where(r => r.LanguageId == currentLanguageId && r.MasterLookup.Status != (int)GeneralEnums.StatusEnum.Deleted && masterLookupsForcurrentLan.Contains(r.MasterLookupId))) .ToList(); if (!string.IsNullOrWhiteSpace(searchText)) { masterLookup = masterLookup.Where(r => r.Name.Contains(searchText)).ToList(); ViewBag.searchText = searchText; } var result = masterLookup.ToList().Select(r => new MasterLookupViewModel { Id = r.MasterLookup.Id, Status = r.MasterLookup.Status, Name = r.Name, CreatedBy = r.MasterLookup.CreatedBy, CreatedOn = r.MasterLookup.CreatedOn, DeletedOn = r.MasterLookup.DeletedOn, IsDefault = r.IsDefault, LanguageId = r.LanguageId } ); var pageSize = int.Parse(SettingHelper.GetOrCreate(Constants.SystemSettings.ControlPanelPageSize, "10").Value); var pageNumber = (page ?? 1); return(View(result.OrderByDescending(r => r.Id).ToPagedList(pageNumber, pageSize))); }
public static string GetFormattedValue(CustomParamValue cpv) { if (cpv == null) { return(null); } var cp = cpv.Cp; if (cp == null) { return(null); } var value = cpv.CPVValue; if (!string.IsNullOrEmpty(cp.ObjectlookupCode_R)) { return(LookupHelper.GetDispalyMemberValue(cp.ObjectlookupCode_R, value)); } var fieldType = GetValueType(cpv); if (fieldType == null) { return(value); } var type = fieldType.GetNonNullableType(); var existsFormat = !string.IsNullOrEmpty(cp.CustomParamFormat); if (type == typeof(DateTime)) { var dtvalue = new StringToDateTimeConverter().Convert(value, null, GetDateTimeFormat(), Thread.CurrentThread.CurrentCulture) as DateTime?; if (dtvalue.HasValue) { return(existsFormat ? dtvalue.Value.ToString(cp.CustomParamFormat) : dtvalue.Value.ToShortDateString()); } return(null); } if (type.IsPrimitive || type == typeof(decimal)) { var nvalue = new StringToNumericConverter().Convert(value, null, fieldType, Thread.CurrentThread.CurrentCulture); if (nvalue != null) { return(existsFormat ? string.Format("{0}:" + cp.CustomParamFormat, nvalue) : nvalue.ToString()); } return(null); } return(value); }
public async Task <Result <PagedList <GCListItemModel> > > GetGiftCertificates([FromBody] GCFilter filter) { var result = await GCService.GetGiftCertificatesAsync(filter); var toReturn = new PagedList <GCListItemModel> { Items = result.Items.Select(p => new GCListItemModel(p, LookupHelper.GetGCTypeName(p.GCType))).ToList(), Count = result.Count, }; return(toReturn); }
private string UpdateFilter(string key, object data, Dictionary <string, Dictionary <string, string> > varFilter) { if (varFilter == null || data == null || string.IsNullOrEmpty(key)) { return(null); } var keyinternal = LookupHelper.GetStringValue(key); if (varFilter.ContainsKey(keyinternal)) { string filter = null; var propvalue = string.Empty; if (data is ExpandoObject) { var dict = data as IDictionary <string, object>; if (dict.ContainsKey(key)) { propvalue = dict[key].To <string>(); } if (string.IsNullOrEmpty(propvalue)) { propvalue = LookupHelper.FilterValueNull; } } else { var prdesc = TypeDescriptor.GetProperties(data); var prop = prdesc.Find(keyinternal, true); if (prop == null) { return(null); } propvalue = LookupHelper.GetStringValue(prop.GetValue(data).To(LookupHelper.FilterValueNull)); } if (string.IsNullOrEmpty(propvalue)) { return(null); } if (varFilter[keyinternal].ContainsKey(propvalue)) { filter = string.Format(varFilter[keyinternal][propvalue], propvalue); } else if (varFilter[keyinternal].ContainsKey(LookupHelper.FilterValueAny)) { filter = string.Format(varFilter[keyinternal][LookupHelper.FilterValueAny], propvalue); } return(filter); } return(null); }
public List <int> LookupMany2ManyIds <TDataObject>([NotNull] IIntKeyedDataObject firstPart, [CanBeNull] IDBPredicate condition) { using (var scope = DBScope("Looking up many-2-many ids between " + firstPart.GetType().Name + " and " + typeof(TDataObject).Name)) { using (var c = scope.Connection.CreateCommand()) { var sc = new SqlSerializationContext(c); LookupHelper.AppendMMLookupSql(sc, firstPart, typeof(TDataObject)); sc.Finish(); return(c.FullReadInts()); } } }
public JsonResult GetKeyColumns(int AD_Table_ID) { if (Session["ctx"] != null) { Ctx _ctx = Session["ctx"] as Ctx; string[] res = LookupHelper.GetKeyColumns(AD_Table_ID, _ctx); return(Json(JsonConvert.SerializeObject(res), JsonRequestBehavior.AllowGet)); } else { return(Json(JsonConvert.SerializeObject("SessionExpired"), JsonRequestBehavior.AllowGet)); } }
public List <int> LookupMany2ManyIds <TDataObject>([NotNull] IIntKeyedDataObject firstPart, [CanBeNull] IDBPredicate condition) { using (var scope = DBScope(Translations.DatabaseModel_LookupMany2ManyIds_Looking_up_many_2_many_ids_between_ + firstPart.GetType().Name + Translations.DatabaseModel_LookupMany2ManyIds__and_ + typeof(TDataObject).Name)) { using (var c = scope.Connection.CreateCommand()) { var sc = new SqlSerializationContext(c); LookupHelper.AppendMMLookupSql(sc, firstPart, typeof(TDataObject)); sc.Finish(); return(c.FullReadInts()); } } }
public void UnLink(IIntKeyedDataObject do1, IIntKeyedDataObject do2) { using (var scope = DBScope(Translations.DatabaseModel_UnLink_UnLinking_ + do1.GetType().Name + ": " + do1.ID + Translations.DatabaseModel_LookupMany2ManyIds__and_ + do2.GetType().Name + ": " + do2.ID)) { using (var c = scope.Connection.CreateCommand()) { var sc = new SqlSerializationContext(c); LookupHelper.AppendMMUnLinkSql(sc, do1, do2); sc.Finish(); c.LexExecuteNonQuery(); } } }
public void UnLink(IIntKeyedDataObject do1, IIntKeyedDataObject do2) { using (var scope = DBScope("UnLinking " + do1.GetType().Name + ": " + do1.ID + " and " + do2.GetType().Name + ": " + do2.ID)) { using (var c = scope.Connection.CreateCommand()) { var sc = new SqlSerializationContext(c); LookupHelper.AppendMMUnLinkSql(sc, do1, do2); sc.Finish(); c.LexExecuteNonQuery(); } } }
private async Task <IEnumerable <object> > GetDataAsync() { if (LookUpInfo == null) { return(null); } return(await Task.Factory.StartNew(() => { var attrEntity = LookupHelper.GetAttrEntity(LookUpInfo); return ManagerInstance.GetFiltered(_filter0, attrEntity); })); }
private void OnLookUpCodeEditorPropertyChanged() { if (string.IsNullOrEmpty(LookUpCodeEditor)) { return; } LookUpInfo = LookupHelper.GetLookupInfo(LookUpCodeEditor); DisplayMember = LookUpInfo.DisplayMember; ValueMember = LookUpInfo.ValueMember; ManagerInstance = LookupHelper.GetItemSourceManager(LookUpInfo); ManagerInstance.AllowMonitorChangesInOtherInsances = true; LookupHelper.InitializeVarFilter(LookUpInfo.Filter, out _filter0); }
public List <int> LookupIds <TDataObject>([NotNull] IIntKeyedDataObject owner, [CanBeNull] IDBPredicate condition) where TDataObject : IDataObject { using (var scope = DBScope("Looking up ids of " + owner.GetType().Name + " for " + typeof(TDataObject).Name)) { using (var c = scope.Connection.CreateCommand()) { var sc = new SqlSerializationContext(c); LookupHelper.AppendLookupSql(sc, owner, typeof(TDataObject), condition); sc.Finish(); return(c.FullReadInts()); } } }
public async Task <Result <string> > RequestGiftCertificatesReportFile([FromBody] GCFilter filter) { filter.Paging = null; var data = (await GCService.GetGiftCertificatesAsync(filter)).Items. Select(p => new GCListItemModel(p, LookupHelper.GetGCTypeName(p.GCType))).ToList(); var result = _gCListItemModelExportCSVExportService.ExportToCsv(data); var guid = Guid.NewGuid().ToString().ToLower(); _cache.SetItem(String.Format(CacheKeys.ReportFormat, guid), result); return(guid); }
protected virtual async Task <IEnumerable <object> > GetDataAsync() { var filter = GetDataFilter(); if (IsSimpleMode && (CanUseVirtualField() || string.IsNullOrEmpty(filter))) { return(null); } return(await Task.Factory.StartNew(() => { var mgr = LookupHelper.GetItemSourceManager(LookupInfo); return mgr.GetFiltered(filter, GetModeEnum.Partial); })); }
protected override async Task <IEnumerable <object> > GetDataAsync() { var filter = GetDataFilter(); if (IsSimpleMode && (CanUseVirtualField() || string.IsNullOrEmpty(filter))) { return(null); } return(await Task.Factory.StartNew(() => { var mgr = LookupHelper.GetItemSourceManager(LookupInfo); var result = Partner.SplitWithAddress(mgr.GetFiltered(filter).Cast <Partner>()); return result; })); }
public ActionResult Index(int?page, string searchText, int resetTo = 0) { if (resetTo == 1) { page = 1; } var statuses = LookupHelper.GetStatuses(Request.Cookies["_culture"]); ViewBag.Status = new SelectList(statuses, "Id", "Name"); ViewBag.StatusEdit = new SelectList(statuses, "Id", "Name"); var currentLanguageId = CultureHelper.GetCurrentLanguageId(Request.Cookies["_culture"]); var departmentForcurrentLan = _db.DepartmentTranslations .Where(r => (r.LanguageId == currentLanguageId) && r.Department.Status != (int)GeneralEnums.StatusEnum.Deleted).Select(c => c.DepartmentId); var departments = _db.DepartmentTranslations .Where(r => (r.IsDefault) && r.Department.Status != (int)GeneralEnums.StatusEnum.Deleted && !departmentForcurrentLan.Contains(r.DepartmentId)) .Union( _db.DepartmentTranslations .Where(r => r.LanguageId == currentLanguageId && r.Department.Status != (int)GeneralEnums.StatusEnum.Deleted && departmentForcurrentLan.Contains(r.DepartmentId))) .ToList(); if (!searchText.IsNullOrWhiteSpace()) { departments = departments .Where(r => (r.Name.Contains(searchText) || r.Description.Contains(searchText))).ToList(); ViewBag.searchText = searchText; } var result = departments.ToList().Select(x => new DepartmentViewModel() { Id = x.DepartmentId, Name = x.Name, Status = x.Department.Status, Description = x.Description, CreatedOn = x.Department.CreatedOn, DeletedOn = x.Department.DeletedOn, CreatedBy = x.Department.CreatedBy }); int pageSize = int.Parse(SettingHelper.GetOrCreate(Constants.SystemSettings.ControlPanelPageSize, "10").Value); var pageNumber = (page ?? 1); return(View(result.OrderByDescending(r => r.Id).ToList().ToPagedList(pageNumber, pageSize))); }
public async Task <Result <PagedList <DiscountListItemModel> > > GetDiscounts([FromBody] DiscountFilter filter) { var result = await _discountService.GetDiscountsAsync(filter); var toReturn = new PagedList <DiscountListItemModel> { Items = result.Items.Select(p => new DiscountListItemModel(p)).ToList(), Count = result.Count, }; foreach (var discountListItemModel in toReturn.Items) { discountListItemModel.DiscountTypeName = LookupHelper.GetDiscountTypeName(discountListItemModel.DiscountType); } return(toReturn); }
private static bool AssertOrder(object v, bool ascending) { int length = ArrayHelper.GetLength(v, 0); for (int i = 0; i < length; i++) { if (i > 0) { object a = ArrayHelper.GetValue(v, i - 1, 0); object b = ArrayHelper.GetValue(v, i, 0); if ((LookupHelper.value_compare(a, b, false) == 2) && !ascending) { return(false); } } } return(true); }
private void Initialize() { using (DBScope(Translations.DatabaseModel_Initialize_Initializing_Database_Model___)) { foreach (var t in Assembly.GetExecutingAssembly().GetTypes()) { if (t.IsClass) { ManyToManyRelationshipAttribute mmat; if (t.TryGetAtr(out mmat)) { if (!t.IsSubclassOf(typeof(RelTable))) { throw new DMError(Translations.DatabaseModel_Initialize_Class__0__cannot_take_participation_into_many_to_many_relationship_because_it_is_not_derived_from__1_, t.FullName, typeof(RelTable).Name); } if (!t.HasAtr <TableAttribute>()) { throw new DMError(Translations.DatabaseModel_Initialize_Class__0__cannot_take_participation_into_many_to_many_relationship_because_it_is_not_marked_with__1_, t.FullName, typeof(TableAttribute).Name); } LookupHelper.RegisterMMLookup(mmat, t); } else if (t.GetInterface(typeof(IIntKeyedDataObject).Name) != null && t.HasAtr <TableAttribute>()) { foreach (var p in t.GetProperties()) { AssociationAttribute aa; if (p.TryGetAtr(out aa) && p.PropertyType.IsGenericType && p.PropertyType.GetGenericTypeDefinition() == typeof(EntitySet <>)) { var pt = p.PropertyType.GetGenericArguments()[0]; if (pt.IsSubclassOf(typeof(DataObject))) { LookupHelper.RegisterLookup(t, pt, aa); } } } } } } } }
private void Initialize() { using (DBScope("Initializing Database Model...")) { foreach (var t in Assembly.GetExecutingAssembly().GetTypes()) { if (t.IsClass) { ManyToManyRelationshipAttribute mmat; if (t.TryGetAtr(out mmat)) { if (!t.IsSubclassOf(typeof(RelTable))) { throw new DMError("Class {0} cannot take participation into many-to-many relationship because it is not derived from {1}", t.FullName, typeof(RelTable).Name); } if (!t.HasAtr <TableAttribute>()) { throw new DMError("Class {0} cannot take participation into many-to-many relationship because it is not marked with {1}", t.FullName, typeof(TableAttribute).Name); } LookupHelper.RegisterMMLookup(mmat, t); } else if (t.GetInterface(typeof(IIntKeyedDataObject).Name) != null && t.HasAtr <TableAttribute>()) { foreach (var p in t.GetProperties()) { AssociationAttribute aa; if (p.TryGetAtr(out aa) && p.PropertyType.IsGenericType && p.PropertyType.GetGenericTypeDefinition() == typeof(EntitySet <>)) { var pt = p.PropertyType.GetGenericArguments()[0]; if (pt.IsSubclassOf(typeof(DataObject))) { LookupHelper.RegisterLookup(t, pt, aa); } } } } } } } }
private void InitializeLookUpCodeEditor() { if (IsSettings) { return; } if (string.IsNullOrEmpty(LookUpCodeEditor)) { throw new DeveloperException("Lookup code is not set."); } LookUpInfo = LookupHelper.GetLookupInfo(LookUpCodeEditor); ValueMember = LookUpInfo.ValueMember; DisplayMember = LookUpInfo.DisplayMember; var typedSettings = Settings as CustomCommonLookupSettings; if (typedSettings != null) { NullText = typedSettings.NullText; } var filtertxt = LookUpInfo.Filter; filtertxt += string.IsNullOrEmpty(LookUpCodeEditorVarFilterExt) ? string.Empty : LookUpCodeEditorVarFilterExt; LookupHelper.InitializeVarFilter(filtertxt, out _filter0, out _varFilter); ManagerInstance = LookupHelper.GetItemSourceManager(LookUpInfo); ManagerInstance.AllowMonitorChangesInOtherInsances = true; //Если контрол запускается без сеттингов IsSettings = false (т.е. не из GridControl'а) то получаем ItemsSource var oldfilter = FilterInternal; SetFilter(null); if (oldfilter == FilterInternal) { RefreshData(); } }
public ActionResult Register() { if (User.Identity.IsAuthenticated) { return(RedirectToAction("Index", "Manage")); } //ViewBag.ProvinceId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Province, Request.Cookies["_culture"]), "Id", "Name"); //ViewBag.RegionId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Region, Request.Cookies["_culture"]), "Id", "Name"); //ViewBag.CityId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.City, Request.Cookies["_culture"]), "Id", "Name"); var prefferdLanguage = LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.PrefferdLanguage, Request.Cookies["_culture"]); ViewBag.PrefferdLanguage = new SelectList(prefferdLanguage, "Id", "Name"); ViewBag.GenderLookupId = new SelectList( LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.Gender, Request.Cookies["_culture"]), "Id", "Name"); //ViewBag.MartialStatusLookupId = new SelectList(LookupHelper.GetLookupDetailsByMasterId((int)GeneralEnums.MasterLookupEnums.MartialStatus, Request.Cookies["_culture"]), "Id", "Name"); return(View()); }
/// <summary> /// Returns the relative position of an item in an array that matches /// a specified value in a specified order. /// </summary> /// <param name="args"><para> /// The args contains 2 - 3 items: lookup_value, lookup_array, [match_type]. /// </para> /// <para> /// Lookup_value is the value you use to find the value you want in a table. /// </para> /// <para> /// Lookup_array is a contiguous range of cells containing possible lookup /// values. Lookup_array must be an array or an array reference. /// </para> /// <para> /// [Match_type] is the number -1, 0, or 1. Match_type specifies how to /// matches lookup_value with values in lookup_array. /// </para></param> /// <returns> /// A <see cref="T:System.Int32" /> value that indicates the evaluate result. /// </returns> public override object Evaluate(object[] args) { base.CheckArgumentsLength(args); int columnCount = ArrayHelper.GetColumnCount(args[1], 0); int rowCount = ArrayHelper.GetRowCount(args[1], 0); int num3 = CalcHelper.ArgumentExists(args, 2) ? CalcConvert.ToInt(args[2]) : 1; if ((columnCount > 1) && (rowCount > 1)) { return(CalcErrors.NotAvailable); } if ((num3 == 1) && !AssertOrder(args[1], true)) { return(CalcErrors.NotAvailable); } if ((num3 == -1) && !AssertOrder(args[1], false)) { return(CalcErrors.NotAvailable); } int num4 = -1; switch (num3) { case 1: num4 = LookupHelper.find_index_bisection(args[0], args[1], 1, rowCount > 1); break; case 0: num4 = LookupHelper.find_index_linear(args[0], args[1], 0, rowCount > 1); break; case -1: num4 = LookupHelper.find_index_bisection(args[0], args[1], -1, rowCount > 1); break; } if (num4 == -1) { return(CalcErrors.NotAvailable); } return((int)(num4 + 1)); }
private new async void RefreshData() { if (ManagerInstance == null) { return; } var trueNullText = NullText; try { NullText = StringResources.Wait; var source = await GetDataAsync(); ItemsSource = LookupHelper.GetComboItemsSource(source, _displayMember); } finally { NullText = trueNullText; } }
public GCListView(string fieldName, string lookupCode = "") : this() { if (string.IsNullOrEmpty(lookupCode)) { throw new DeveloperException("LookupCode is null"); } _lookupInfo = LookupHelper.GetLookupInfo(lookupCode); _itemType = _lookupInfo.ItemType; if (_itemType == null) { throw new DeveloperException("Type of itemType is null."); } SubListParentFieldName = fieldName; FillFields(); DataContextChanged += OnDataContextChanged; }
public ActionResult Index(int?page, string searchText, int resetTo = 0) { if (resetTo == 1) { page = 1; } var statuses = LookupHelper.GetStatuses(Request.Cookies["_culture"]); ViewBag.Status = new SelectList(statuses, "Id", "Name"); ViewBag.StatusEdit = new SelectList(statuses, "Id", "Name"); var permissions = _db.Permissions .Where(r => r.Status != (int)GeneralEnums.StatusEnum.Deleted); if (!searchText.IsNullOrWhiteSpace()) { permissions = permissions .Where(r => r.PageUrl.Contains(searchText) || r.PageName.Contains(searchText) || r.PermissionKey.Contains(searchText) || r.Description.Contains(searchText)); ViewBag.searchText = searchText; } var result = permissions.ToList().Select(x => new PermissionViewModel() { Id = x.Id, PageUrl = x.PageUrl, PageName = x.PageName, PermissionKey = x.PermissionKey, Status = x.Status, Description = x.Description, CreatedOn = x.CreatedOn, DeletedOn = x.DeletedOn, CreatedBy = x.CreatedBy }); int pageSize = int.Parse(SettingHelper.GetOrCreate(Constants.SystemSettings.ControlPanelPageSize, "10").Value); var pageNumber = (page ?? 1); return(View(result.OrderByDescending(r => r.Id).ToList().ToPagedList(pageNumber, pageSize))); }
private bool UpdateFilter(string key, object data) { if (_varFilter == null || data == null || string.IsNullOrEmpty(key)) { return(false); } var keyinternal = LookupHelper.GetStringValue(key); if (_varFilter.ContainsKey(keyinternal)) { string filter = null; var prdesc = TypeDescriptor.GetProperties(data); var prop = prdesc.Find(keyinternal, true); if (prop == null) { return(false); } var propvalue = LookupHelper.GetStringValue(prop.GetValue(data).To(LookupHelper.FilterValueNull)); if (_varFilter[keyinternal].ContainsKey(propvalue)) //проверяем - есть ли фильтр для данного значения { filter = string.Format(_varFilter[keyinternal][propvalue], propvalue); } else if (_varFilter[keyinternal].ContainsKey(LookupHelper.FilterValueAny)) //если нет - есть ли универсальный фильтр (*) { filter = string.Format(_varFilter[keyinternal][LookupHelper.FilterValueAny], propvalue); } if (filter == null) { return(false); } SetFilter(filter); return(true); } return(false); }
/// <summary> /// Получаем источник данных, если задан LookUpCodeEditor. /// </summary> private Task <object> PrepareItemsSourceByLookupCodeAsync() { return(Task.Factory.StartNew(() => { //Thread.Sleep(10000); if (string.IsNullOrEmpty(LookUpCodeEditor)) { return null; } var lookupInfo = LookupHelper.GetLookupInfo(LookUpCodeEditor); var filtertxt = lookupInfo.Filter; string filter0; LookupHelper.InitializeVarFilter(filtertxt, out filter0); var filters = new List <string> { filter0, LookUpCodeEditorFilterExt }; var filter = string.Join(" AND ", filters.Where(p => !string.IsNullOrEmpty(p)).Select(p => p)); if (MaxRows.HasValue && MaxRows.Value > 0) { filter = string.Format("{0}ROWNUM <= {1}", string.IsNullOrEmpty(filter) ? string.Empty : " AND ", MaxRows.Value); } Dispatcher.Invoke(new Action(() => { ItemsSourceType = LookupHelper.GetItemSourceType(lookupInfo); })); //var valueMember = lookUp.ObjectLookupPkey; //var displayMember = lookUp.ObjectLookupDisplay; // using не делаем - можем прибить singleton manager var mgr = LookupHelper.GetItemSourceManager(lookupInfo); object result = mgr.GetFiltered(filter, GetModeEnum.Partial); return result; })); }
/// <summary> /// locate one text string within a second text string, /// and return the number of the starting position of the first /// text string from the first character of the second text string. /// </summary> /// <param name="args"><para> /// The args contains 2 - 3 items: find_text, within_text, [start_num]. /// </para> /// <para> /// Find_text is the text you want to find. /// </para> /// <para> /// Within_text is the text in which you want to search for find_text. /// </para> /// <para> /// [Start_num] is the character number in within_text at which you want to /// start searching, the default value is 1. /// </para></param> /// <returns> /// A <see cref="T:System.String" /> value that indicates the evaluate result. /// </returns> public override object Evaluate(object[] args) { base.CheckArgumentsLength(args); string s = CalcConvert.ToString(args[0]); string str2 = CalcConvert.ToString(args[1]); int startIndex = CalcHelper.ArgumentExists(args, 2) ? CalcConvert.ToInt(args[2]) : 1; startIndex--; if (startIndex < 0) { return(CalcErrors.Value); } int index = -1; try { if ((s.IndexOf('*') == -1) && (s.IndexOf('?') == -1)) { index = str2.ToLower().IndexOf(s.ToLower(), startIndex); } else { Match match = new Regex(LookupHelper.CreateStringcomparisonRegexPattern(s).ToLower()).Match(str2.ToLower(), startIndex); if ((match != null) && match.Success) { index = match.Index; } } } catch { } if (index == -1) { return(CalcErrors.Value); } return((int)(index + 1)); }
public virtual void SetServiceProvider(IServiceProvider serviceProvider) { _windowManager = (WindowManager)serviceProvider.GetService(typeof(IWindowManager)); _lookup = new LookupHelper(_windowManager); }