private static void ReadActions(ComponentModel model, ReferenceType entity, string componentFolderPath)
{
if (model.DetailDataSets?.DetailDataSet2 == null)
{
return;
}
foreach (var actionModel in model.DetailDataSets.DetailDataSet2.Rows)
{
var action = new ActionWithHandler();
var nameReq = actionModel.Requisites
.FirstOrDefault(r => r.Code == ActionNameReqName);
if (nameReq != null)
{
action.Name = nameReq.Value;
}
var methodNameReq = actionModel.Requisites
.FirstOrDefault(r => r.Code == ActionMethodNameReqName);
if (methodNameReq != null)
{
// Заполнить имя действия, только если его не нашли ранее (имя метода менее читабельное).
var methodName = methodNameReq.Value;
if (action.Name == null)
{
action.Name = methodName;
}
var executionHandler = entity.Methods
.FirstOrDefault(m => m.Name.Equals(methodName, StringComparison.OrdinalIgnoreCase));
if (executionHandler != null)
{
action.ExecutionHandler = executionHandler;
}
else
{
log.Warn($"Method {methodName} for action {action.Name} not found");
action.CalculationText = "";
}
}
if (action.ExecutionHandler == null)
{
var actionFileName = Path.Combine(componentFolderPath, "Actions", $"{action.Name}.isbl");
if (File.Exists(actionFileName))
{
action.CalculationText = File.ReadAllText(actionFileName, Encoding.GetEncoding(1251));
}
else
{
log.Warn($"File not found {actionFileName}");
action.CalculationText = "";
}
}
entity.Actions.Add(action);
}
}
private static void ReadActions(ComponentModel model, DocumentCardType entity)
{
if (model.DetailDataSets?.DetailDataSet2 == null)
{
return;
}
foreach (var row in model.DetailDataSets.DetailDataSet2.Rows)
{
var action = new ActionWithHandler();
var nameReq = row.Requisites
.FirstOrDefault(r => r.Code == ActionNameReqName);
if (nameReq != null)
{
action.Name = nameReq.DecodedText;
}
var calculationTextReq = row.Requisites
.FirstOrDefault(r => r.Code == ActionCalculationTextReqName);
if (calculationTextReq != null)
{
var calculationText = calculationTextReq.DecodedText;
var executionHandler = entity.Methods
.FirstOrDefault(m => m.Name.Equals(calculationText, StringComparison.OrdinalIgnoreCase));
if (executionHandler != null)
{
action.ExecutionHandler = executionHandler;
}
else
{
action.CalculationText = calculationText;
}
}
entity.Actions.Add(action);
}
}
private void ReadActions(RecordRefModel model, ManagedFolder entity)
{
foreach (var actionNameRequisite in model.Requisites.Where(r => r.Name == "СодержаниеТ2"))
{
var action = new ActionWithHandler
{
Name = actionNameRequisite.Value
};
var actionNumber = actionNameRequisite.Number;
var actionMethodNameReq = model.Requisites
.Where(r => r.Name == "ISBActionMethodName")
.FirstOrDefault(r => r.Number == actionNumber);
if (actionMethodNameReq != null)
{
action.ExecutionHandler = entity.Methods
.FirstOrDefault(m => m.Name == actionMethodNameReq.Value);
}
entity.Actions.Add(action);
}
}
public IEnumerable <ManagedFolder> Read(SqlConnection connection, Version platformVersion)
{
var components = new Dictionary <string, ManagedFolder>();
var query = this.GetManagedFoldersQuery(platformVersion);
if (string.IsNullOrEmpty(query))
{
return(components.Values.ToList());
}
var command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var managedFolder = new ManagedFolder
{
Name = (reader["Name"] as string).Trim(),
Title = (reader["Title"] as string).Trim()
};
if (ActiveValue.Equals(reader["State"] as string))
{
managedFolder.State = ComponentState.Active;
}
else
{
managedFolder.State = ComponentState.Closed;
}
if (reader["SearchDescription"] is byte[] searchDescriptionRawData)
{
var searchDescriptionDfm = Encoding.GetEncoding(1251).GetString(searchDescriptionRawData);
if (!string.IsNullOrWhiteSpace(searchDescriptionDfm))
{
managedFolder.SearchDescription = SearchDescriptionParser.Parse(searchDescriptionDfm);
}
}
components.Add(managedFolder.Name, managedFolder);
}
}
}
query = this.GetMethodsQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var managedFolderName = reader["ManagedFolderName"] as string;
if (!components.TryGetValue(managedFolderName, out ManagedFolder managedFolder))
{
continue;
}
var method = new Method {
Name = reader["Name"] as string
};
if (reader["CalculationText"] is byte[] calculationValue)
{
method.CalculationText = Encoding.GetEncoding(1251).GetString(calculationValue);
}
else
{
method.CalculationText = string.Empty;
}
managedFolder.Methods.Add(method);
}
}
}
}
query = this.GetMethodParamsQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var managedFolderName = reader["ManagedFolderName"] as string;
if (!components.TryGetValue(managedFolderName, out ManagedFolder managedFolder))
{
continue;
}
var methodName = reader["MethodName"] as string;
var method = managedFolder.Methods
.FirstOrDefault(m => m.Name == methodName);
if (method == null)
{
continue;
}
var parameter = new MethodParam
{
Number = (int)reader["Number"],
Name = reader["Name"] as string
};
var typeValue = reader["Type"] as string;
if (TypeValues.TryGetValue(typeValue, out MethodParamType methodParamType))
{
parameter.Type = methodParamType;
}
parameter.DefaultValue = reader["DefaultValue"] as string;
parameter.HasDefaultValue = !string.IsNullOrEmpty(parameter.DefaultValue);
method.Params.Add(parameter);
}
}
}
}
query = this.GetActionQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var managedFolderName = reader["ManagedFolderName"] as string;
if (!components.TryGetValue(managedFolderName, out ManagedFolder managedFolder))
{
continue;
}
var action = new ActionWithHandler {
Name = reader["Name"] as string
};
var methodName = reader["MethodName"] as string;
var executionHandler = managedFolder.Methods.FirstOrDefault(m => m.Name == methodName);
if (executionHandler != null)
{
action.ExecutionHandler = executionHandler;
}
else
{
action.CalculationText = string.Empty;
}
managedFolder.Actions.Add(action);
}
}
}
}
return(components.Values.ToList());
}
public IEnumerable <ReferenceType> Read(SqlConnection connection, Version platformVersion)
{
var components = new Dictionary <string, ReferenceType>();
var query = this.GetReferenceTypeQuery(platformVersion);
if (string.IsNullOrEmpty(query))
{
return(components.Values.ToList());
}
var command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var referenceType = new ReferenceType
{
Name = reader["Name"] as string,
Title = reader["Title"] as string
};
if (reader["State"] is string stateValue &&
StateValues.ContainsKey(stateValue))
{
referenceType.State = StateValues[stateValue];
}
if (reader["NumerationMethod"] is string numerationMethodValue &&
NumerationMethodValues.ContainsKey(numerationMethodValue))
{
referenceType.NumerationMethod = NumerationMethodValues[numerationMethodValue];
}
if (reader["DisplayRequisite"] is string displayRequisiteValue &&
DisplayRequisiteValues.ContainsKey(displayRequisiteValue))
{
referenceType.DisplayRequisite = DisplayRequisiteValues[displayRequisiteValue];
}
referenceType.LeadingReference = reader["LeadingReference"] as string;
referenceType.HasLongRecordNames = YesValue.Equals(reader["HasLongRecordNames"] as string);
referenceType.HasUniqueRecordNames = YesValue.Equals(reader["HasUniqueRecordNames"] as string);
var eventsValue = reader["Events"] as string;
if (!string.IsNullOrEmpty(eventsValue))
{
var events = EventTextParser.Parse(eventsValue);
foreach (var @event in events)
{
referenceType.Events.Add(@event);
}
}
components.Add(referenceType.Name, referenceType);
}
}
}
query = this.GetMethodsQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var referenceTypeName = reader["ReferenceTypeName"] as string;
if (!components.TryGetValue(referenceTypeName, out ReferenceType referenceType))
{
continue;
}
var method = new Method
{
Name = reader["Name"] as string,
CalculationText = reader["CalculationText"] as string ?? string.Empty
};
referenceType.Methods.Add(method);
}
}
}
}
query = this.GetMethodParamsQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var referenceTypeName = reader["ReferenceTypeName"] as string;
if (!components.TryGetValue(referenceTypeName, out ReferenceType referenceType))
{
continue;
}
var methodName = reader["MethodName"] as string;
var method = referenceType.Methods
.FirstOrDefault(m => m.Name == methodName);
if (method == null)
{
continue;
}
var parameter = new MethodParam
{
Number = (int)reader["Number"],
Name = reader["Name"] as string
};
var typeValue = reader["Type"] as string;
if (TypeValues.TryGetValue(typeValue, out MethodParamType methodParamType))
{
parameter.Type = methodParamType;
}
parameter.DefaultValue = reader["DefaultValue"] as string;
parameter.HasDefaultValue = !string.IsNullOrEmpty(parameter.DefaultValue);
method.Params.Add(parameter);
}
}
}
}
query = this.GetActionQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var referenceTypeName = reader["ReferenceTypeName"] as string;
if (!components.TryGetValue(referenceTypeName, out ReferenceType referenceType))
{
continue;
}
var action = new ActionWithHandler {
Name = reader["Name"] as string
};
var calculationText = reader["CalculationText"] as string;
var executionHandler = referenceType.Methods
.FirstOrDefault(m => m.Name == calculationText);
if (executionHandler != null)
{
action.ExecutionHandler = executionHandler;
}
else
{
action.CalculationText = calculationText ?? string.Empty;
}
referenceType.Actions.Add(action);
}
}
}
}
query = this.GetRequisiteQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var referenceTypeName = reader["ReferenceTypeName"] as string;
if (!components.TryGetValue(referenceTypeName, out ReferenceType referenceType))
{
continue;
}
var cardRequisite = new CardRequisite {
Number = (int)reader["Number"]
};
if (reader["Section"] is string sectionValue &&
RequisiteSectionValues.ContainsKey(sectionValue))
{
cardRequisite.Section = RequisiteSectionValues[sectionValue];
}
cardRequisite.Name = reader["Name"] as string;
cardRequisite.IsRequired = RuYesValue.Equals(reader["IsRequired"] as string);
cardRequisite.IsFilter = RuYesValue.Equals(reader["IsFilter"] as string);
cardRequisite.IsLeading = RuYesValue.Equals(reader["IsLeading"] as string);
cardRequisite.IsControl = RuYesValue.Equals(reader["IsControl"] as string);
var changeEventValue = reader["ChangeEvent"] as string;
if (!string.IsNullOrEmpty(changeEventValue))
{
var @event = new Event
{
EventType = EventType.Change,
CalculationText = changeEventValue
};
cardRequisite.Events.Add(@event);
}
var selectEventsValue = reader["SelectEvents"] as string;
if (!string.IsNullOrEmpty(selectEventsValue))
{
var events = EventTextParser.Parse(selectEventsValue);
foreach (var @event in events)
{
if (@event.EventType == EventType.Unknown)
{
@event.EventType = EventType.Select;
}
cardRequisite.Events.Add(@event);
}
}
referenceType.Requisites.Add(cardRequisite);
}
}
}
}
query = this.GetViewQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var referenceTypeName = reader["ReferenceTypeName"] as string;
if (!components.TryGetValue(referenceTypeName, out ReferenceType referenceType))
{
continue;
}
var view = new View
{
Name = reader["Name"] as string,
IsMain = RuYesValue.Equals(reader["IsMain"] as string),
ListForm = reader["ListForm"] as string,
CardForm = reader["CardForm"] as string
};
referenceType.Views.Add(view);
referenceType.Views.Add(view);
}
}
}
}
return(components.Values.ToList());
}
public IEnumerable <Dialog> Read(SqlConnection connection, Version platformVersion)
{
var components = new Dictionary <string, Dialog>();
var query = this.GetDialogQuery(platformVersion);
if (string.IsNullOrEmpty(query))
{
return(components.Values.ToList());
}
var command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var dialog = new Dialog
{
Name = reader["Name"] as string,
Title = reader["Title"] as string,
CardForm = reader["CardForm"] as string
};
var eventsValue = reader["Events"] as string;
if (!string.IsNullOrEmpty(eventsValue))
{
var events = EventTextParser.Parse(eventsValue);
foreach (var @event in events)
{
dialog.Events.Add(@event);
}
}
components.Add(dialog.Name, dialog);
}
}
}
query = this.GetMethodsQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var dialogName = reader["DialogName"] as string;
if (!components.TryGetValue(dialogName, out Dialog dialog))
{
continue;
}
var method = new Method
{
Name = reader["Name"] as string,
CalculationText = reader["CalculationText"] as string ?? string.Empty
};
dialog.Methods.Add(method);
}
}
}
}
query = this.GetMethodParamsQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var dialogName = reader["DialogName"] as string;
if (!components.TryGetValue(dialogName, out Dialog dialog))
{
continue;
}
var methodName = reader["MethodName"] as string;
var method = dialog.Methods
.FirstOrDefault(m => m.Name == methodName);
if (method == null)
{
continue;
}
var parameter = new MethodParam
{
Number = (int)reader["Number"],
Name = reader["Name"] as string
};
var typeValue = reader["Type"] as string;
if (TypeValues.TryGetValue(typeValue, out MethodParamType methodParamType))
{
parameter.Type = methodParamType;
}
parameter.DefaultValue = reader["DefaultValue"] as string;
parameter.HasDefaultValue = !string.IsNullOrEmpty(parameter.DefaultValue);
method.Params.Add(parameter);
}
}
}
}
query = this.GetActionQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var dialogName = reader["DialogName"] as string;
if (!components.TryGetValue(dialogName, out Dialog dialog))
{
continue;
}
var action = new ActionWithHandler {
Name = reader["Name"] as string
};
var calculationText = reader["CalculationText"] as string;
var executionHandler = dialog.Methods
.FirstOrDefault(m => m.Name == calculationText);
if (executionHandler != null)
{
action.ExecutionHandler = executionHandler;
}
else
{
action.CalculationText = calculationText ?? string.Empty;
}
dialog.Actions.Add(action);
}
}
}
}
query = this.GetRequisiteQuery(platformVersion);
if (!string.IsNullOrEmpty(query))
{
command = new SqlCommand(query, connection);
using (var reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var dialogName = reader["DialogName"] as string;
if (!components.TryGetValue(dialogName, out Dialog dialog))
{
continue;
}
var cardRequisite = new CardRequisite {
Number = (int)reader["Number"]
};
if (reader["Section"] is string sectionValue &&
RequisiteSectionValues.ContainsKey(sectionValue))
{
cardRequisite.Section = RequisiteSectionValues[sectionValue];
}
cardRequisite.Name = reader["Name"] as string;
cardRequisite.IsRequired = YesValue.Equals(reader["IsRequired"] as string);
cardRequisite.IsLastValueSaved = YesValue.Equals(reader["IsLastValueSaved"] as string);
cardRequisite.IsSelectionConstrained = YesValue.Equals(reader["IsSelectionConstrained"] as string);
var changeEventValue = reader["ChangeEvent"] as string;
if (!string.IsNullOrEmpty(changeEventValue))
{
var @event = new Event
{
EventType = EventType.Change,
CalculationText = changeEventValue
};
cardRequisite.Events.Add(@event);
}
var selectEventsValue = reader["SelectEvents"] as string;
if (!string.IsNullOrEmpty(selectEventsValue))
{
var events = EventTextParser.Parse(selectEventsValue);
foreach (var @event in events)
{
if (@event.EventType == EventType.Unknown)
{
@event.EventType = EventType.Select;
}
cardRequisite.Events.Add(@event);
}
}
dialog.Requisites.Add(cardRequisite);
}
}
}
}
return(components.Values.ToList());
}
