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