private string GenerateFieldCreateSql(IFieldType field)
{
// There is probably a better way to do this but this is how things are currently
switch (field)
{
case BooleanField _:
return($"{field.Name} boolean {(!field.Nullable ? "not null" : "")}");
case NumberField _:
return($"{field.Name} integer" + (!field.Nullable ? "NOT NULL" : ""));
case PrimaryField _:
return($"{field.Name} uuid Not Null Primary Key");
case TextField _:
TextField castedTextField = (TextField)field;
return($"{castedTextField.Name} varchar({castedTextField.Length})" + (!castedTextField.Nullable ? "NOT NULL" : ""));
case LookupField _:
LookupField castedLookupField = (LookupField)field;
return($"{field.Name} uuid references {castedLookupField.Target}({castedLookupField.Target}id) {(!field.Nullable ? "not null" : "")}");
default:
throw new NotSupportedException($"Field type {field.GetType().Name} is unsupported by this backend");
}
}
public AutocompleteItem[] GetLookupDisplayNames(int reportTableFieldID, string term)
{
List <AutocompleteItem> result = new List <AutocompleteItem>();
Dictionary <int, string> values = LookupField.GetValues(TSAuthentication.GetLoginUser(), reportTableFieldID, term, 10);
result.Add(new AutocompleteItem("Unassigned", "-1"));
if (values != null)
{
foreach (KeyValuePair <int, string> pair in values)
{
bool found = false;
foreach (AutocompleteItem item in result)
{
if (item.label.ToLower().Trim() == pair.Value.ToLower().Trim())
{
found = true;
break;
}
}
if (!found)
{
result.Add(new AutocompleteItem(pair.Value, pair.Key.ToString()));
}
}
}
return(result.ToArray());
}
private bool ParseLookup(Element el)
{
LookupField field = new LookupField
{
Label = el.label,
LookupArchiveName = el.lookupRepositoryName,
LookupArchiveColumnName = el.lookupFieldName == "Oggetto" ? "_subject" : el.lookupFieldName,
Required = el.required,
Searchable = el.searchable,
ModifyEnabled = el.modifyEnable,
HiddenField = el.hiddenField,
ClientId = el.clientId,
ColumnName = Utils.SafeSQLName(el.label),
ResultVisibility = el.resultVisibility,
ResultPosition = el.resultPosition,
MultipleValues = el.multipleValues,
MultipleValuesSpecified = el.multipleValues,
Layout = new LayoutPosition
{
PanelId = el.columns.ToString(),
ColNumber = el.columns,
RowNumber = el.rows
}
};
sections.AddCtrl(field);
return(true);
}
/// <summary>
/// Returns lookup field value as an item name instead of item ID.
/// </summary>
/// <returns></returns>
public override string GetValue()
{
var lookupField = new LookupField(_field);
var targetItem = lookupField.TargetItem;
return(targetItem != null?targetItem.DisplayName.ToLowerInvariant() : String.Empty);
}
protected Item GetWildcardDetailPage(string landingPageTemplateId, ID fieldId, Item currentItem = null)
{
Item detailItem = null;
var context = Context.Item;
// Handle case where context page is either the wildcard node or landing page
if (context.Name.StartsWith(Constants.Wildcard.Node) &&
context.Parent.InheritsTemplate(landingPageTemplateId))
{
detailItem = context;
}
else if (context.InheritsTemplate(landingPageTemplateId))
{
detailItem =
context.Children
.FirstOrDefault(i => i.Name.StartsWith(Constants.Wildcard.Node));
}
if (detailItem == null)
{
var settingItem = Sitecore.Context.Database.GetItem(EventConfigSettings.EventCalendarSettingItem);
if (settingItem != null)
{
var siteLookupField = new LookupField(settingItem.Fields[fieldId]);
var selectedPage = siteLookupField.TargetItem;
if (selectedPage != null && selectedPage.Name.StartsWith(EventCalendar.Constants.Wildcard.Node))
{
detailItem = selectedPage;
}
}
}
return(detailItem);
}
public static float CompareFieldTypes(LookupType t1, LookupType t2, LookupModule lookupModel)
{
float comparative_score = 1.0f;
float score_penalty = comparative_score / t1.Fields.Count(f => !f.IsStatic && !f.IsLiteral);
foreach (var f1 in t1.Fields.Select((Value, Index) => new { Value, Index }))
{
LookupField f2 = t2.Fields[f1.Index];
if (f1.Value.Name == f2.Name)
{
return(1.5f);
}
if (!Regex.Match(f1.Value.Name, lookupModel.NamingRegex).Success&& f1.Value.Name != f2.Name)
{
return(0.0f);
}
if (f1.Value.IsStatic || f1.Value.IsLiteral)
{
continue;
}
if (f1.Value.GetType().Namespace == "System" && f2.GetType().Namespace == "System" && f1.Value.Name == f2.Name)
{
comparative_score -= score_penalty;
}
}
return(comparative_score);
}
public override IRenderingModelBase GetModel()
{
HistogramRenderingModel model = new HistogramRenderingModel();
this.FillBaseProperties(model);
if (model.DataSourceItem != null)
{
LookupField timePeriod = model.DataSourceItem.Fields[Templates.Histogram.Fields.TimePeriod];
if (timePeriod.TargetItem != null)
{
model.TimePeriod = (TimePeriods)Enum.Parse(typeof(TimePeriods), timePeriod.TargetItem.Fields["Value"].Value); //TODO Pull from Foundation. And put this in a method.
}
model.SetDataUrl(model.DataSourceItem.Fields[Templates.DataVisualization.Fields.Data]);
model.ShowLabels = !(string.IsNullOrWhiteSpace(this.Rendering.Parameters[Constants.ShowLabels]) ||
this.Rendering.Parameters[Constants.ShowLabels] == "0"); //TODO Clean up
DateField fromDate = model.DataSourceItem.Fields[Templates.Histogram.Fields.FromDate];
if (fromDate.DateTime != DateTime.MinValue)
{
model.FromDate = fromDate.DateTime;
}
DateField toDate = model.DataSourceItem.Fields[Templates.Histogram.Fields.ToDate];
if (toDate.DateTime != DateTime.MinValue)
{
model.ToDate = toDate.DateTime;
}
TextField dataColumnName = model.DataSourceItem.Fields[Templates.Histogram.Fields.DataColumnName];
if (!string.IsNullOrWhiteSpace(dataColumnName.Value))
{
model.DateColumnName = dataColumnName.Value;
}
}
return(model);
}
public Translation(string obfName, LookupField field)
{
ObfName = obfName;
CleanName = field.Name;
_field = field;
Type = TranslationType.FieldTranslation;
}
public void CreatePlanItems(List <PlanEvent> planlist, ID parentid)
{
Database db = Sitecore.Configuration.Factory.GetDatabase("master");
Item parentItem = db.GetItem(parentid);
using (new SecurityDisabler())
{
parentItem.Editing.BeginEdit();
foreach (var plan in planlist)
{
Item child = parentItem.Add(plan.PlanTitleID, new TemplateID(new ID("{50B06575-9906-4B50-8E63-3E8BBEF1F858}")));
child.Editing.BeginEdit();
LookupField lf = child.Fields["Broadcast Date"];
lf.Value = HttpUtility.HtmlDecode(plan.BroadcastDate);
lf = child.Fields["Plan Date"];
lf.Value = HttpUtility.HtmlDecode(plan.PlanDate);
lf = child.Fields["Plan Time"];
lf.Value = plan.PlanTime;
lf = child.Fields["Plan Duration"];
lf.Value = plan.PlanDuration;
lf = child.Fields["Material ID"];
lf.Value = plan.MaterialID;
lf = child.Fields["Title Name"];
lf.Value = plan.TitleName;
lf = child.Fields["Episode Name"];
lf.Value = plan.EpisodeName;
lf = child.Fields["EPG"];
lf.Value = plan.EPG;
lf = child.Fields["Title ID"];
lf.Value = plan.TitleID;
lf = child.Fields["Episode ID"];
lf.Value = plan.EpisodeID;
lf = child.Fields["Plan Title ID"];
lf.Value = plan.PlanTitleID;
lf = child.Fields["Day Name"];
lf.Value = plan.DayName;
lf = child.Fields["Definition"];
lf.Value = plan.Definition;
child.Editing.EndEdit();
}
parentItem.Editing.EndEdit();
}
}
/// <summary>
/// Relinks the branch reference, if present, in the given field
/// </summary>
/// <param name="field">The field to relink the reference in</param>
/// <param name="instanceRoot">Root item of the branch instance</param>
/// <param name="branchPath">Sitecore path of the branch template</param>
/// <param name="branchPathLength">Length of the branch template's Sitecore path</param>
public static void RelinkBranchReferenceInLookupField(LookupField field, Item instanceRoot, string branchPath, int?branchPathLength = null)
{
RelinkBranchReferenceInCustomField(
field,
lookupField => lookupField.TargetItem?.Paths.FullPath,
item => item.ID.ToString(),
instanceRoot,
branchPath,
branchPathLength);
}
private static Control CreateLookupFieldControl(SPField field, SPList list, SPListItem item, SPControlMode mode)
{
LookupField lf = new LookupField();
lf.ListId = list.ID;
lf.ItemId = item.ID;
lf.FieldName = field.Title;
lf.ID = field.Title;
lf.ControlMode = mode;
return(lf);
}
public AutocompleteItem[] GetLookupValues(int reportTableFieldID, string term)
{
List <AutocompleteItem> result = new List <AutocompleteItem>();
Dictionary <int, string> values = LookupField.GetValues(TSAuthentication.GetLoginUser(), reportTableFieldID, term, 10);
result.Add(new AutocompleteItem("Unassigned", "-1"));
if (values != null)
{
foreach (KeyValuePair <int, string> pair in values)
{
result.Add(new AutocompleteItem(pair.Value, pair.Key.ToString()));
}
}
return(result.ToArray());
}
/// <summary>
/// Returns lookup field value as an item display name instead of item ID.
/// </summary>
/// <returns></returns>
public override string GetValue()
{
var value = String.Empty;
if (FieldTypeManager.GetField(_field) is LookupField)
{
var lookupField = new LookupField(_field);
value = IdHelper.NormalizeGuid(lookupField.TargetID);
}
if (FieldTypeManager.GetField(_field) is ReferenceField)
{
var referenceField = new ReferenceField(_field);
value = IdHelper.NormalizeGuid(referenceField.TargetID);
}
return value;
}
/// <summary>
/// Returns lookup field value as an item display name instead of item ID.
/// </summary>
/// <returns></returns>
public override string GetValue()
{
var value = String.Empty;
if (FieldTypeManager.GetField(_field) is LookupField)
{
var lookupField = new LookupField(_field);
value = IdHelper.NormalizeGuid(lookupField.TargetID);
}
if (FieldTypeManager.GetField(_field) is ReferenceField)
{
var referenceField = new ReferenceField(_field);
value = IdHelper.NormalizeGuid(referenceField.TargetID);
}
return(value);
}
/// <summary>
/// Actualiza la fila seleccionada del grid grvItemsPedidos
/// </summary>
/// <param name="itemId"></param>
/// <param name="row"></param>
private void ActualizarItemPedido(int itemId, GridViewRow row)
{
NumberField fCantidad = (NumberField)row.FindControl("numCantidad");
NumberField fPrecioU = (NumberField)row.FindControl("numPrecioUnitario");
//LookupField fMoneda = (LookupField)row.FindControl("lufMonedaItem");
NumberField fPeso = (NumberField)row.FindControl("numPeso");
LookupField fUnidadM = (LookupField)row.FindControl("lufUnidadMedida");
TextField fDims = (TextField)row.FindControl("txtDimensiones");
LookupField fCliente = (LookupField)row.FindControl("lufCliente");
LookupField fClienteAsociado = (LookupField)row.FindControl("lufClienteAsociado");
LookupField fTipoPedido = (LookupField)row.FindControl("lufTipoPedido");
string cantidad = fCantidad.Value.ToString();
string precioU = fPrecioU.Value.ToString();
//string moneda = fMoneda.Value.ToString();
string peso = "";
if (fPeso.Value != null)
{
peso = fPeso.Value.ToString();
}
string unidadM = "";
if (fUnidadM.Value != null)
{
unidadM = fUnidadM.Value.ToString();
}
string dims = "";
if (fDims.Value != null)
{
dims = fDims.Value.ToString();
}
string cliente = fCliente.Value.ToString();
string clienteAsociado = "";
if (fClienteAsociado.Value != null)
{
clienteAsociado = fClienteAsociado.Value.ToString();
}
string tipoPedido = fTipoPedido.Value.ToString();
EjecutorOperacionesSP.ActualizarItemPedido(itemId, cantidad, precioU,
peso, unidadM, dims, cliente, tipoPedido, clienteAsociado);
}
public static void SetName(this LookupField field, string name, LookupModule module)
{
string obfName = field.CSharpName;
if (!Regex.Match(field.Name, module.NamingRegex).Success)
{
return;
}
if (field.Il2CppField != null)
{
field.Il2CppField.Name = name;
}
var translation = new Translation(obfName, field);
module.Translations.Add(translation);
field.Translation = translation;
}
private static bool CheckFromUIValue(string fieldName, Enums.Operator op, string value, SPFormContext formContext, string clientID)
{
BaseFieldControl field = ValidationInjector.GetFieldControlByName(fieldName, formContext, clientID);
// to manage the rich field UI text
if (field is RichTextField)
{
string fieldVaue = ((RichTextField)field).HiddenInput.Value;
switch (op)
{
case Enums.Operator.Equal:
return(fieldVaue.Equals(value));
case Enums.Operator.NotEqual:
return(!fieldVaue.Equals(value));
case Enums.Operator.Contains:
return(fieldVaue.Contains(value));
case Enums.Operator.NotContains:
return(!fieldVaue.Contains(value));
default:
return(false);
}
}
else
{
if (field is LookupField)
{
LookupField l = field as LookupField;
String v = l.Value.ToString();
}
return(MatchItemValueBasedOnOperatorAndValueType(op, value, field.Value, field.Field.FieldValueType));
}
}
public static float CompareFieldOffsets(LookupType t1, LookupType t2, LookupModel lookupModel)
{
if (t1.Il2CppType == null || t2.Il2CppType == null)
{
return(1.0f);
}
float comparative_score = 1.0f;
float score_penalty = comparative_score / t1.Fields.Count(f => !f.IsStatic && !f.IsLiteral);
foreach (var f1 in t1.Fields.Select((Value, Index) => new { Value, Index }))
{
LookupField f2 = t2.Fields[f1.Index];
if (f1.Value.Name == f2.Name)
{
return(1.5f);
}
if (!Regex.Match(f1.Value.Name, lookupModel.NamingRegex).Success&& f1.Value.Name != f2.Name)
{
return(0.0f);
}
if (f1.Value.IsStatic || f1.Value.IsLiteral)
{
continue;
}
if (f1.Value.Offset != f2.Offset)
{
comparative_score -= score_penalty;
}
}
return(comparative_score);
}
public static string ToFieldExport(this LookupField field)
{
string modifiers = $"[TranslatorFieldOffset(0x{field.Offset:X})]{(field.IsStatic ? " static" : "")}{(field.IsPublic ? " public" : "")}{(field.IsPrivate ? " private" : "")}";
string fieldType = "";
if (field.Type.IsArray)
{
fieldType = $"{field.Type.ElementType?.ToString() ?? "object"}[]";
}
else if (field.Type.IsGenericType && field.Type.GenericTypeParameters.Any())
{
fieldType = field.Type.Name.Split("`")[0] + "<";
foreach (LookupType type in field.Type.GenericTypeParameters)
{
fieldType += type.ToString() + (field.Type.GenericTypeParameters[field.Type.GenericTypeParameters.Count() - 1] != type ? ", " : "");
}
fieldType += ">";
}
else
{
fieldType = field.Type.ToString();
}
return($" {modifiers} {fieldType} {field.Name};");
}
/// <summary>
/// Returns lookup field value as an item name instead of item ID.
/// </summary>
/// <returns></returns>
public override string GetValue()
{
var lookupField = new LookupField(_field);
var targetItem = lookupField.TargetItem;
return targetItem != null ? targetItem.DisplayName.ToLowerInvariant() : String.Empty;
}
private static void PrintField(Field field)
{
//Get the SystemMandatory of each Field
Console.WriteLine("Field SystemMandatory: " + field.SystemMandatory);
//Get the Webhook of each Field
Console.WriteLine("Field Webhook: " + field.Webhook);
//Get the JsonType of each Field
Console.WriteLine("Field JsonType: " + field.JsonType);
//Get the Object obtained Crypt instance
Crypt crypt = field.Crypt;
//Check if crypt is not null
if (crypt != null)
{
//Get the Mode of the Crypt
Console.WriteLine("Field Crypt Mode: " + crypt.Mode);
//Get the Column of the Crypt
Console.WriteLine("Field Crypt Column: " + crypt.Column);
//Get the Table of the Crypt
Console.WriteLine("Field Crypt Table: " + crypt.Table);
//Get the Status of the Crypt
Console.WriteLine("Field Crypt Status: " + crypt.Status);
}
//Get the FieldLabel of each Field
Console.WriteLine("Field FieldLabel: " + field.FieldLabel);
//Get the Object obtained ToolTip instance
ToolTip tooltip = field.Tooltip;
//Check if tooltip is not null
if (tooltip != null)
{
//Get the Name of the ToolTip
Console.WriteLine("Field ToolTip Name: " + tooltip.Name);
//Get the Value of the ToolTip
Console.WriteLine("Field ToolTip Value: " + tooltip.Value);
}
//Get the CreatedSource of each Field
Console.WriteLine("Field CreatedSource: " + field.CreatedSource);
//Get the FieldReadOnly of each Field
Console.WriteLine("Field FieldReadOnly: " + field.FieldReadOnly);
//Get the DisplayLabel of each Field
Console.WriteLine("Field DisplayLabel: " + field.DisplayLabel);
//Get the ReadOnly of each Field
Console.WriteLine("Field ReadOnly: " + field.ReadOnly);
//Get the Object obtained AssociationDetails instance
AssociationDetails associationDetails = field.AssociationDetails;
//Check if associationDetails is not null
if (associationDetails != null)
{
//Get the Object obtained LookupField instance
LookupField lookupField = associationDetails.LookupField;
//Check if lookupField is not null
if (lookupField != null)
{
//Get the ID of the LookupField
Console.WriteLine("Field AssociationDetails LookupField ID: " + lookupField.Id);
//Get the Name of the LookupField
Console.WriteLine("Field AssociationDetails LookupField Name: " + lookupField.Name);
}
//Get the Object obtained LookupField instance
LookupField relatedField = associationDetails.RelatedField;
//Check if relatedField is not null
if (relatedField != null)
{
//Get the ID of the LookupField
Console.WriteLine("Field AssociationDetails RelatedField ID: " + relatedField.Id);
//Get the Name of the LookupField
Console.WriteLine("Field AssociationDetails RelatedField Name: " + relatedField.Name);
}
}
if (field.QuickSequenceNumber != null)
{
//Get the QuickSequenceNumber of each Field
Console.WriteLine("Field QuickSequenceNumber: " + field.QuickSequenceNumber);
}
if (field.BusinesscardSupported != null)
{
//Get the BusinesscardSupported of each Field
Console.WriteLine("Field BusinesscardSupported: " + field.BusinesscardSupported);
}
//Check if MultiModuleLookup is not null
if (field.MultiModuleLookup != null)
{
//Get the MultiModuleLookup map
foreach (KeyValuePair <string, object> entry in field.MultiModuleLookup)
{
//Get each value in the map
Console.WriteLine(entry.Key + ": " + JsonConvert.SerializeObject(entry.Value));
}
}
//Get the Object obtained Currency instance
Currency currency = field.Currency;
//Check if currency is not null
if (currency != null)
{
//Get the RoundingOption of the Currency
Console.WriteLine("Field Currency RoundingOption: " + currency.RoundingOption);
if (currency.Precision != null)
{
//Get the Precision of the Currency
Console.WriteLine("Field Currency Precision: " + currency.Precision);
}
}
//Get the ID of each Field
Console.WriteLine("Field ID: " + field.Id);
if (field.CustomField != null)
{
//Get the CustomField of each Field
Console.WriteLine("Field CustomField: " + field.CustomField);
}
//Get the Object obtained Module instance
Module lookup = field.Lookup;
//Check if lookup is not null
if (lookup != null)
{
//Get the Object obtained Layout instance
Com.Zoho.Crm.API.Layouts.Layout layout = lookup.Layout;
//Check if layout is not null
if (layout != null)
{
//Get the ID of the Layout
Console.WriteLine("Field ModuleLookup Layout ID: " + layout.Id);
//Get the Name of the Layout
Console.WriteLine("Field ModuleLookup Layout Name: " + layout.Name);
}
//Get the DisplayLabel of the Module
Console.WriteLine("Field ModuleLookup DisplayLabel: " + lookup.DisplayLabel);
//Get the APIName of the Module
Console.WriteLine("Field ModuleLookup APIName: " + lookup.APIName);
//Get the Module of the Module
Console.WriteLine("Field ModuleLookup Module: " + lookup.Module_1);
if (lookup.Id != null)
{
//Get the ID of the Module
Console.WriteLine("Field ModuleLookup ID: " + lookup.Id);
}
}
if (field.Visible != null)
{
//Get the Visible of each Field
Console.WriteLine("Field Visible: " + field.Visible);
}
if (field.Length != null)
{
//Get the Length of each Field
Console.WriteLine("Field Length: " + field.Length);
}
//Get the Object obtained ViewType instance
ViewType viewType = field.ViewType;
//Check if viewType is not null
if (viewType != null)
{
//Get the View of the ViewType
Console.WriteLine("Field ViewType View: " + viewType.View);
//Get the Edit of the ViewType
Console.WriteLine("Field ViewType Edit: " + viewType.Edit);
//Get the Create of the ViewType
Console.WriteLine("Field ViewType Create: " + viewType.Create);
//Get the View of the ViewType
Console.WriteLine("Field ViewType QuickCreate: " + viewType.QuickCreate);
}
//Get the Object obtained Module instance
Module subform = field.Subform;
//Check if subform is not null
if (subform != null)
{
//Get the Object obtained Layout instance
Com.Zoho.Crm.API.Layouts.Layout layout = subform.Layout;
//Check if layout is not null
if (layout != null)
{
//Get the ID of the Layout
Console.WriteLine("Field Subform Layout ID: " + layout.Id);
//Get the Name of the Layout
Console.WriteLine("Field Subform Layout Name: " + layout.Name);
}
//Get the DisplayLabel of the Module
Console.WriteLine("Field Subform DisplayLabel: " + subform.DisplayLabel);
//Get the APIName of the Module
Console.WriteLine("Field Subform APIName: " + subform.APIName);
//Get the Module of the Module
Console.WriteLine("Field Subform Module: " + subform.Module_1);
if (subform.Id != null)
{
//Get the ID of the Module
Console.WriteLine("Field Subform ID: " + subform.Id);
}
}
//Get the APIName of each Field
Console.WriteLine("Field APIName: " + field.APIName);
//Get the Object obtained Unique instance
Unique unique = field.Unique;
//Check if unique is not null
if (unique != null)
{
//Get the Casesensitive of the Unique
Console.WriteLine("Field Unique Casesensitive in " + unique.Casesensitive);
}
if (field.HistoryTracking != null)
{
//Get the HistoryTracking of each Field
Console.WriteLine("Field HistoryTracking: " + field.HistoryTracking);
}
//Get the DataType of each Field
Console.WriteLine("Field DataType: " + field.DataType);
//Get the Object obtained Formula instance
Formula formula = field.Formula;
//Check if formula is not null
if (formula != null)
{
//Get the ReturnType of the Formula
Console.WriteLine("Field Formula ReturnType:" + formula.ReturnType);
if (formula.Expression != null)
{
//Get the Expression of the Formula
Console.WriteLine("Field Formula Expression:" + formula.Expression);
}
}
if (field.DecimalPlace != null)
{
//Get the DecimalPlace of each Field
Console.WriteLine("Field DecimalPlace: " + field.DecimalPlace);
}
if (field.MassUpdate != null)
{
//Get the MassUpdate of each Field
Console.WriteLine("Field MassUpdate: " + field.MassUpdate);
}
if (field.BlueprintSupported != null)
{
//Get the BlueprintSupported of each Field
Console.WriteLine("Field BlueprintSupported: " + field.BlueprintSupported);
}
//Get all entries from the MultiSelectLookup instance
MultiSelectLookup multiSelectLookup = field.Multiselectlookup;
//Check if formula is not null
if (multiSelectLookup != null)
{
//Get the DisplayValue of the MultiSelectLookup
Console.WriteLine("Field MultiSelectLookup DisplayLabel: " + multiSelectLookup.DisplayLabel);
//Get the LinkingModule of the MultiSelectLookup
Console.WriteLine("Field MultiSelectLookup LinkingModule: " + multiSelectLookup.LinkingModule);
//Get the LookupApiname of the MultiSelectLookup
Console.WriteLine("Field MultiSelectLookup LookupApiname: " + multiSelectLookup.LookupApiname);
//Get the APIName of the MultiSelectLookup
Console.WriteLine("Field MultiSelectLookup APIName: " + multiSelectLookup.APIName);
//Get the ConnectedlookupApiname of the MultiSelectLookup
Console.WriteLine("Field MultiSelectLookup ConnectedlookupApiname: " + multiSelectLookup.ConnectedlookupApiname);
//Get the ID of the MultiSelectLookup
Console.WriteLine("Field MultiSelectLookup ID: " + multiSelectLookup.Id);
}
//Get the PickListValue of each Field
List <PickListValue> pickListValues = field.PickListValues;
//Check if formula is not null
if (pickListValues != null)
{
foreach (PickListValue pickListValue in pickListValues)
{
//Get the DisplayValue of each PickListValues
Console.WriteLine("Field PickListValue DisplayValue: " + pickListValue.DisplayValue);
if (pickListValue.SequenceNumber != null)
{
//Get the SequenceNumber of each PickListValues
Console.WriteLine(" Field PickListValue SequenceNumber: " + pickListValue.SequenceNumber);
}
//Get the ExpectedDataType of each PickListValues
Console.WriteLine("Field PickListValue ExpectedDataType: " + pickListValue.ExpectedDataType);
//Get the ActualValue of each PickListValues
Console.WriteLine("Field PickListValue ActualValue: " + pickListValue.ActualValue);
if (pickListValue.Maps != null)
{
foreach (Object map in pickListValue.Maps)
{
//Get each value from the map
Console.WriteLine(map);
}
}
//Get the SysRefName of each PickListValues
Console.WriteLine("Field PickListValue SysRefName: " + pickListValue.SysRefName);
//Get the Type of each PickListValues
Console.WriteLine("Field PickListValue Type: " + pickListValue.Type);
}
}
//Get the AutoNumber of each Field
AutoNumber autoNumber = field.AutoNumber;
//Check if formula is not null
if (autoNumber != null)
{
//Get the Prefix of the AutoNumber
Console.WriteLine("Field AutoNumber Prefix: " + autoNumber.Prefix);
//Get the Suffix of the AutoNumber
Console.WriteLine("Field AutoNumber Suffix: " + autoNumber.Suffix);
if (autoNumber.StartNumber != null)
{
//Get the StartNumber of the AutoNumber
Console.WriteLine("Field AutoNumber StartNumber: " + autoNumber.StartNumber);
}
}
if (field.DefaultValue != null)
{
//Get the DefaultValue of each Field
Console.WriteLine("Field DefaultValue: " + field.DefaultValue);
}
if (field.SectionId != null)
{
//Get the SectionId of each Field
Console.WriteLine("Field SectionId: " + field.SectionId);
}
//Check if ValidationRule is not null
if (field.ValidationRule != null)
{
//Get the details map
foreach (KeyValuePair <string, object> entry in field.ValidationRule)
{
//Get each value in the map
Console.WriteLine(entry.Key + ": " + JsonConvert.SerializeObject(entry.Value));
}
}
//Check if ConvertMapping is not null
if (field.ConvertMapping != null)
{
//Get the details map
foreach (KeyValuePair <string, object> entry in field.ConvertMapping)
{
//Get each value in the map
Console.WriteLine(entry.Key + ": " + JsonConvert.SerializeObject(entry.Value));
}
}
}
/// <summary>
/// Converts the field.
/// </summary>
/// <param name="field">The field.</param>
/// <param name="writer">The writer.</param>
private static void ConvertField(Field field, XmlTextWriter writer)
{
switch (field.Type.ToLower())
{
case "lookup":
LookupField lookupField = new LookupField(field);
if (lookupField.TargetItem != null)
{
string language = lookupField.TargetItem["Regional Iso Code"];
if (string.IsNullOrEmpty(language) || !UseRegionalIsoCodeForEnglish)
{
language = lookupField.TargetItem["Iso"];
}
if (!string.IsNullOrEmpty(language))
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString(language);
writer.WriteEndAttribute();
}
}
break;
case "link":
LinkField link = new LinkField(field);
if (link.InternalPath != string.Empty)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString(link.InternalPath);
writer.WriteEndAttribute();
}
break;
case "checkbox":
CheckboxField checkbox = new CheckboxField(field);
if (field.Name == "mode")
{
if (!checkbox.Checked)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString("off");
writer.WriteEndAttribute();
}
}
else
{
if (checkbox.Checked)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString("true");
writer.WriteEndAttribute();
}
}
break;
default:
if (field.Value != string.Empty)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString(field.Value);
writer.WriteEndAttribute();
}
break;
}
}
protected override void CreateChildControls()
{
if (Field == null)
{
return;
}
base.CreateChildControls();
SPFieldLookupValue fLookValue = (SPFieldLookupValue )this.ItemFieldValue;
fldAction = (LookupField)TemplateContainer.FindControl("fldAction");
if (this.ControlMode == SPControlMode.Display)
{
lblDisplayText = (Label)TemplateContainer.FindControl("lblDisplayText");
if (lblDisplayText != null)
{
if (fLookValue != null)
{
lblDisplayText.Text = fLookValue.LookupValue;// showText.TrimEnd('：');
}
}
}
else
{
this.DropDownList1 = (DropDownList)TemplateContainer.FindControl("DropDownList1");
this.ddlDes = (DropDownList)TemplateContainer.FindControl("ddlDes");
this.spanDesc = (HtmlGenericControl )TemplateContainer.FindControl("spanDesc");
this.spanTxtDesc = (HtmlGenericControl )TemplateContainer.FindControl("spanTxtDesc");
this.tblLevel = (HtmlTable)TemplateContainer.FindControl("tblLevel");
DropDownList1.AutoPostBack = true;
DropDownList1.SelectedIndexChanged += Ddl_SelectedIndexChanged;
//CustomConcatenatedField field = (CustomConcatenatedField)base.Field;
//新建或编辑值为空时，进行初始化填充
if (fLookValue == null)
{
if (ViewState["lastID"] != null)
{
string lastID = ViewState["lastID"].ToString();
InitControls(int.Parse(lastID));
}
else
{
InitControls();
}
}
else
{
int id;//编辑过程中，更改选项
if (ViewState["lastID"] != null)
{
id = int.Parse(ViewState["lastID"].ToString());
}
else
{
id = fLookValue.LookupId;
}
//填充值
InitControls(id);
}
}
}
/// <summary>
/// Converts the field.
/// </summary>
/// <param name="field">The field.</param>
/// <param name="writer">The writer.</param>
private static void ConvertField(Field field, XmlTextWriter writer)
{
switch (field.Type.ToLower())
{
case "lookup":
LookupField lookupField = new LookupField(field);
if (lookupField.TargetItem != null)
{
string language = lookupField.TargetItem["Regional Iso Code"];
if (string.IsNullOrEmpty(language) || !UseRegionalIsoCodeForEnglish)
{
language = lookupField.TargetItem["Iso"];
}
if (!string.IsNullOrEmpty(language))
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString(language);
writer.WriteEndAttribute();
}
}
break;
case "link":
LinkField link = new LinkField(field);
if (link.InternalPath != string.Empty)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString(link.InternalPath);
writer.WriteEndAttribute();
}
break;
case "checkbox":
CheckboxField checkbox = new CheckboxField(field);
if (field.Name == "mode")
{
if (!checkbox.Checked)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString("off");
writer.WriteEndAttribute();
}
}
else
{
if (checkbox.Checked)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString("true");
writer.WriteEndAttribute();
}
}
break;
default:
if (field.Value != string.Empty)
{
writer.WriteStartAttribute(field.Name, string.Empty);
writer.WriteString(field.Value);
writer.WriteEndAttribute();
}
break;
}
}
/// <inheritdoc />
/// <summary>
/// Initializes a new instance of the <see cref="LookupProperty"/> class.
/// </summary>
/// <param name="field">The field to wrap.</param>
public LookupProperty(Field field)
: base(field)
{
_lookupField = field;
}
protected static string getFriendlyFieldValue(string name, Item itemElement, int iMaxLength)
{
Field field = itemElement.Fields[name];
if (field != null)
{
switch (field.TypeKey)
{
case "date":
case "datetime":
return(formatDateField(itemElement, field.ID));
case "droplink":
case "droptree":
case "reference":
case "grouped droplink":
LookupField lookupFld = (LookupField)field;
if (lookupFld != null && lookupFld.TargetItem != null)
{
return(lookupFld.TargetItem.Name);
}
break;
case "checklist":
case "multilist":
case "treelist":
case "treelistex":
MultilistField multilistField = (MultilistField)field;
if (multilistField != null)
{
StringBuilder strBuilder = new StringBuilder();
foreach (Item item in multilistField.GetItems())
{
strBuilder.AppendFormat("{0}, ", item.Name);
}
return(StringUtil.Clip(strBuilder.ToString().TrimEnd(',', ' '), iMaxLength, true));
}
break;
case "link":
case "general link":
LinkField lf = new LinkField(field);
switch (lf.LinkType)
{
case "media":
case "internal": return(lf.TargetItem.Paths.ContentPath);
case "anchor":
case "mailto":
case "external": return(lf.Url);
default:
return(lf.Text);
}
default:
return(StringUtil.Clip(field.Value, iMaxLength, true));
}
}
return(String.Empty);
}
private Item GetNextItem(Item item)
{
LookupField address = (LookupField)item.Fields["Next Question To Point"];
return(address?.TargetItem);
}
public static void PopulateLookupFields(Field field)
{
if (string.IsNullOrEmpty(field.LookupTable))
{
return;
}
DataProvider provider = DataService.Providers["MyProvider"];
if (Path.HasExtension(field.LookupTable))
{
field.LookupTable = Path.GetExtension(field.LookupTable).Substring(1);
}
Query qry = new Query(DataService.GetSchema(field.LookupTable, provider.Name, TableType.Table));
qry.SelectList = field.LinkField;
if (field.LinkField != field.DisplayField)
{
qry.SelectList += "," + field.DisplayField;
}
if (field.UseCategory && !string.IsNullOrEmpty(field.CategoryControlField))
{
qry.SelectList += "," + field.CategoryControlField;
}
if (!string.IsNullOrEmpty(field.Where))
{
qry.WHERE(field.Where);
}
if (field.Parent != null && field.Parent.Value != null && !string.IsNullOrEmpty(field.Parent.Value.ToString()))
{
qry.WHERE(field.CategoryControlField, field.Parent.Value);
}
if (field.Unique)
{
qry.DISTINCT();
}
if (!string.IsNullOrEmpty(field.OrderBy))
{
if (field.Desc)
{
qry.OrderBy = SubSonic.OrderBy.Desc(field.OrderBy);
}
else
{
qry.OrderBy = SubSonic.OrderBy.Asc(field.OrderBy);
}
}
field.LookupFields.Clear();
string[] values = null;
if (field.Multiselect)
{
if (field.Value != null)
{
values = field.Value.ToString().Split(new char[] { ',' });
}
}
IDataReader reader = qry.ExecuteReader();
while (reader.Read())
{
LookupField newField = null;
object link = reader[0] ?? string.Empty;
if (field.LinkField != field.DisplayField)
{
object display = reader[1] ?? string.Empty;
newField = new LookupField(link.ToString(),
display.ToString());
}
else
{
newField = new LookupField(link.ToString(),
link.ToString());
}
object val = field.Value ?? string.Empty;
if (field.Multiselect && values != null)
{
foreach (string msvalue in values)
{
if (link.ToString() == msvalue)
{
newField.Selected = true;
}
}
}
else
{
if (link.ToString() == val.ToString())
{
newField.Selected = true;
}
}
field.LookupFields.Add(newField);
}
reader.Close();
}
/// <summary>
/// Initializes a new instance of the <see cref="LookupProperty"/> class.
/// </summary>
/// <param name="field">The field to wrap.</param>
public LookupProperty(Field field)
: base(field)
{
this.lookupField = field;
}
private Element CreateFieldElement(FieldBaseType obj)
{
if (obj.GetType() == typeof(EnumField))
{
EnumField field = obj as EnumField;
Element enumField = new Element
{
ctrlType = ctlEnum,
label = field.Label,
enumOptions = field.Options,
defaultValue = field.DefaultValue ?? "",
defaultSearchValue = field.DefaultSearchValue ?? "",
readOnly = field.ReadOnly,
required = field.Required,
columnName = field.ColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition,
multipleValues = field.MultipleValues
};
if (field.Layout != null)
{
enumField.rows = field.Layout.RowNumber;
enumField.columns = field.Layout.ColNumber;
}
return(enumField);
}
if (obj.GetType() == typeof(StatusField))
{
StatusField field = obj as StatusField;
Element statusField = new Element
{
ctrlType = ctlStatus,
label = field.Label,
statusType = field.Options,
defaultValue = field.DefaultValue ?? "",
defaultSearchValue = field.DefaultSearchValue ?? "",
readOnly = field.ReadOnly,
required = field.Required,
columnName = field.ColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition
};
if (field.Layout != null)
{
statusField.rows = field.Layout.RowNumber;
statusField.columns = field.Layout.ColNumber;
}
return(statusField);
}
if (obj.GetType() == typeof(TextField))
{
TextField field = obj as TextField;
Element textField = new Element
{
ctrlType = ctlText,
label = field.Label,
multiLine = field.Multiline,
HTMLEnable = field.HTMLEnable,
defaultValue = field.DefaultValue ?? "",
defaultSearchValue = field.DefaultSearchValue ?? "",
readOnly = field.ReadOnly,
required = field.Required,
columnName = field.ColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition
};
if (field.Layout != null)
{
textField.rows = field.Layout.RowNumber;
textField.columns = field.Layout.ColNumber;
}
return(textField);
}
if (obj.GetType() == typeof(DateField))
{
DateField field = obj as DateField;
Element element = new Element
{
ctrlType = ctlDate,
label = field.Label,
defaultSearchValue = field.DefaultSearchValue.ToString("dd/MM/yyyy") ?? "",
restrictedYear = field.RestrictedYear,
enableDefaultDate = field.DefaultTodayEnabled,
readOnly = field.ReadOnly,
required = field.Required,
columnName = field.ColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition
};
element.defaultValue = "";
if (field.DefaultValueSpecified && field.DefaultValue != DateTime.MinValue)
{
element.defaultValue = field.DefaultValue.ToString("dd/MM/yyyy");
}
if (field.Layout != null)
{
element.rows = field.Layout.RowNumber;
element.columns = field.Layout.ColNumber;
}
return(element);
}
if (obj.GetType() == typeof(NumberField))
{
NumberField field = obj as NumberField;
Element numberField = new Element
{
ctrlType = ctlNumber,
label = field.Label,
defaultValue = field.DefaultValueSpecified == true?field.DefaultValue.ToString() : "",
readOnly = field.ReadOnly,
required = field.Required,
columnName = field.ColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition,
format = field.Format
};
if (field.MinValueSpecified)
{
numberField.minValue = field.MinValue;
}
if (field.MaxValueSpecified)
{
numberField.maxValue = field.MaxValue;
}
if (field.Layout != null)
{
numberField.rows = field.Layout.RowNumber;
numberField.columns = field.Layout.ColNumber;
}
return(numberField);
}
if (obj.GetType() == typeof(BoolField))
{
BoolField field = obj as BoolField;
Element boolField = new Element
{
ctrlType = ctlCheckbox,
label = field.Label,
defaultValue = field.DefaultValue == true && field.DefaultValueSpecified ? "True" : "",
readOnly = field.ReadOnly,
required = field.Required,
columnName = field.ColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition
};
if (field.Layout != null)
{
boolField.rows = field.Layout.RowNumber;
boolField.columns = field.Layout.ColNumber;
}
return(boolField);
}
if (obj.GetType() == typeof(LookupField))
{
LookupField field = obj as LookupField;
Element lookup = new Element
{
ctrlType = ctlLookup,
label = field.Label,
required = field.Required,
columnName = field.ColumnName,
lookupRepositoryName = field.LookupArchiveName,
lookupFieldName = field.LookupArchiveColumnName == "_subject" ? "Oggetto" : field.LookupArchiveColumnName,
searchable = field.Searchable,
modifyEnable = field.ModifyEnabled,
hiddenField = field.HiddenField,
clientId = field.ClientId,
resultVisibility = field.ResultVisibility,
resultPosition = field.ResultPosition,
multipleValues = field.MultipleValues
};
if (field.Layout != null)
{
lookup.rows = field.Layout.RowNumber;
lookup.columns = field.Layout.ColNumber;
}
return(lookup);
}
return(null);
}
private static string GetEnumFieldValue(LookupField field)
{
var enumItem = field?.TargetItem;
return(enumItem?.Fields[Sitecore.XA.Foundation.Common.Templates.Enum.Fields.Value].Value);
}
/// <summary>
/// </summary>
/// <returns>
/// </returns>
public override string GetValue()
{
var targetItem = new LookupField(_field).TargetItem;
return targetItem.IsNotNull() ? targetItem.Name.ToLowerInvariant() : string.Empty;
}
public static string GetUDSValue(FieldBaseType field)
{
string ret = string.Empty;
if (field is StatusField)
{
StatusField rField = field as StatusField;
if (!string.IsNullOrEmpty(rField.Value))
{
ret = rField.Value;
}
return(ret);
}
if (field is LookupField)
{
LookupField rField = field as LookupField;
if (!string.IsNullOrEmpty(rField.Value))
{
ret = string.Join(", ", JsonConvert.DeserializeObject <string[]>(rField.Value));
}
return(ret);
}
if (field is EnumField)
{
EnumField rField = field as EnumField;
if (!string.IsNullOrEmpty(rField.Value))
{
ret = string.Join(", ", JsonConvert.DeserializeObject <string[]>(rField.Value));
}
return(ret);
}
if (field is NumberField)
{
NumberField rField = field as NumberField;
if (rField.Value != double.MinValue)
{
ret = rField.Value.ToString(rField.Format);
}
return(ret);
}
if (field is BoolField)
{
BoolField rField = field as BoolField;
ret = rField.Value ? "vero" : "falso";
return(ret);
}
if (field is DateField)
{
DateField rField = field as DateField;
if (rField.Value != DateTime.MinValue)
{
ret = rField.Value.ToLongDateString();
if (rField.RestrictedYear)
{
ret = rField.Value.Year.ToString();
}
}
return(ret);
}
if (field is TextField)
{
TextField rField = field as TextField;
ret = rField.Value;
}
return(ret);
}
/// <summary>
/// </summary>
/// <returns>
/// </returns>
public override string GetValue()
{
var targetItem = new LookupField(_field).TargetItem;
return targetItem.IsNotNull() ? targetItem.Name.ToLowerInvariant() : string.Empty;
}
