private static void SetUniqueName(MyPropertyInfo propertyInfo, Dictionary <string, MyPropertyInfo> m_properties, int index = 0)
{
if (m_properties.Any(x => x.Key == propertyInfo.Name))
{
propertyInfo.Name += (index + 1).ToString();
SetUniqueName(propertyInfo, m_properties, index + 1);
}
}
private MyCustomSingleData GetCustomSingleData(MyPropertyInfo property, DP_DataRepository dataItem, DR_Requester requester, bool definition, Dictionary <string, MyPropertyInfo> properties, List <int> usedFormulaIDs)
{
var item = new MyCustomSingleData(dataItem, Requester, Definition, properties, UsedFormulaIDs);
item.ParentCustomData = this;
item.ParentProperty = property;
return(item);
}
//public MyPropertyInfo GetEntityProperty(string entityName, string propertyName)
//{
// entityName = entityName.ToLower();
// if (entityName.StartsWith("otorel"))
// {
// entityName = entityName.Substring(6, entityName.Length - 6);
// }
// else if (entityName.StartsWith("otmrel"))
// {
// entityName = entityName.Substring(6, entityName.Length - 6);
// }
// else if (entityName.StartsWith("mtorel"))
// {
// entityName = entityName.Substring(6, entityName.Length - 6);
// }
// if (entityName.EndsWith("1") || entityName.EndsWith("2") || entityName.EndsWith("3") || entityName.EndsWith("4"))
// {
// entityName = entityName.Substring(0, entityName.Length - 1);
// }
// var entityRecord = AllRegisterdProperties.FirstOrDefault(x => x.Entity.Name.ToLower() == entityName);
// if (entityRecord != null)
// return entityRecord.Properties.FirstOrDefault(x => x.Name == propertyName);
// else
// {
// //اینجا ایراد داره ممکنه مشابه پیدا بشه
// var entityID = bizTableDrivedEntity.GetTableDrivedEntityIDByName(Requester, entityName);
// if (entityID != 0)
// {
// //فقط برای اینکه لیست ساخته شود
// var fObject = new FormulaObject() { DataItem = new DP_DataRepository(entityID, "") };
// GetProperties(Requester, fObject, null);
// entityRecord = AllRegisterdProperties.FirstOrDefault(x => x.Entity.ID == entityID);
// if (entityRecord != null)
// return entityRecord.Properties.FirstOrDefault(x => x.Name == propertyName);
// }
// }
// return null;
//}
public MyPropertyInfo GetProperty(MyPropertyInfo previousObject, string propertyName)
{
if (previousObject != null)
{
return(previousObject.ChildProperties.FirstOrDefault(x => x.Name == propertyName));
}
else
{
return(Properties.FirstOrDefault(x => x.Name == propertyName));
}
}
public static object GetPropertyDefaultValue(MyPropertyInfo propertyInfo)
{
if (propertyInfo.Type == typeof(long) || propertyInfo.Type == typeof(long?))
{
return((long)1);
}
else if (propertyInfo.Type == typeof(int?) || propertyInfo.Type == typeof(int))
{
return(1);
}
else if (propertyInfo.Type == typeof(short?) || propertyInfo.Type == typeof(short))
{
return((short)1);
}
else if (propertyInfo.Type == typeof(byte?) || propertyInfo.Type == typeof(byte))
{
return((byte)1);
}
else if (propertyInfo.Type == typeof(double?) || propertyInfo.Type == typeof(double))
{
return((double)1);
}
else if (propertyInfo.Type == typeof(decimal?) || propertyInfo.Type == typeof(decimal))
{
return((decimal)1);
}
else if (propertyInfo.Type == typeof(float?) || propertyInfo.Type == typeof(float))
{
return((float)1);
}
else if (propertyInfo.Type == typeof(Guid) || propertyInfo.Type == typeof(Guid?))
{
return(propertyInfo.Name);
}
else if (propertyInfo.Type == typeof(string))
{
return(propertyInfo.Name);
}
else if (propertyInfo.Type == typeof(DateTime) || propertyInfo.Type == typeof(DateTime?))
{
return(DateTime.Now);
}
else if (propertyInfo.Type == typeof(bool?) || propertyInfo.Type == typeof(bool))
{
return(true);
}
return(propertyInfo.Name);
}
//private static Type GetPersianDateType()
//{
// return typeof(PersianDate);
//}
//private static PersianDate GetPersianDateDefaultValue()
//{
// return new PersianDate() { Value = "1397/01/01" };
//}
//private static Type GetCustomTypePropertyType(MyPropertyInfo propertyInfo, ValueCustomType valueCustomType)
//{
// if (valueCustomType == ValueCustomType.IsPersianDate)
// {
// return typeof(PersianDate);
// }
// return null;
//}
//private static object GetCustomTypePropertyDefaultValue(MyPropertyInfo propertyInfo, ValueCustomType valueCustomType)
//{
// if (valueCustomType == ValueCustomType.IsPersianDate)
// {
// return new PersianDate() { Value = "1397/01/01" };
// }
// return null;
//}
//private static object GetCustomTypePropertyValue(MyPropertyInfo propertyInfo, ValueCustomType valueCustomType, string value)
//{//<NULL> چی مقدار
// if (valueCustomType == ValueCustomType.IsPersianDate)
// {
// return new PersianDate() { Value = value };
// }
// return null;
//}
public static FormulaObject GetNewFormulaObject(MyPropertyInfo propertyInfo)
{
FormulaObject result = null;
//short propertyInfo.RelationshipLevel = 0;
//if (propertyInfo != null)
// propertyInfo.RelationshipLevel = propertyInfo.RelationshipLevel;
if (propertyInfo.RelationshipLevel == 0)
{
result = new BindableTypeDescriptor <tempClass1>();
}
else if (propertyInfo.RelationshipLevel == 1)
{
result = new BindableTypeDescriptor <tempClass2>();
}
else if (propertyInfo.RelationshipLevel == 2)
{
result = new BindableTypeDescriptor <tempClass3>();
}
else if (propertyInfo.RelationshipLevel == 3)
{
result = new BindableTypeDescriptor <tempClass4>();
}
else if (propertyInfo.RelationshipLevel == 4)
{
result = new BindableTypeDescriptor <tempClass5>();
}
else if (propertyInfo.RelationshipLevel == 5)
{
result = new BindableTypeDescriptor <tempClass6>();
}
else if (propertyInfo.RelationshipLevel == 6)
{
result = new BindableTypeDescriptor <tempClass7>();
}
else if (propertyInfo.RelationshipLevel == 7)
{
result = new BindableTypeDescriptor <tempClass8>();
}
else if (propertyInfo.RelationshipLevel == 8)
{
result = new BindableTypeDescriptor <tempClass9>();
}
//var aa = (result as BindableTypeDescriptor<tempClass3>).WordCount();
return(result);
}
public static IList GetNewFormulaObjectList(MyPropertyInfo propertyInfo)
{
//var propertyInfo.RelationshipLevel = parentFormulaObject.RelationshipLevel;
if (propertyInfo.RelationshipLevel == 0)
{
return(new List <BindableTypeDescriptor <tempClass1> >());
}
else if (propertyInfo.RelationshipLevel == 1)
{
return(new List <BindableTypeDescriptor <tempClass2> >());
}
else if (propertyInfo.RelationshipLevel == 2)
{
return(new List <BindableTypeDescriptor <tempClass3> >());
}
else if (propertyInfo.RelationshipLevel == 3)
{
return(new List <BindableTypeDescriptor <tempClass4> >());
}
else if (propertyInfo.RelationshipLevel == 4)
{
return(new List <BindableTypeDescriptor <tempClass5> >());
}
else if (propertyInfo.RelationshipLevel == 5)
{
return(new List <BindableTypeDescriptor <tempClass6> >());
}
else if (propertyInfo.RelationshipLevel == 6)
{
return(new List <BindableTypeDescriptor <tempClass7> >());
}
else if (propertyInfo.RelationshipLevel == 7)
{
return(new List <BindableTypeDescriptor <tempClass8> >());
}
else if (propertyInfo.RelationshipLevel == 8)
{
return(new List <BindableTypeDescriptor <tempClass9> >());
}
return(null);
}
private MyPropertyInfo CloneProperty(MyPropertyInfo value)
{
MyPropertyInfo result = new MyFormulaFunctionStateFunctionLibrary.MyPropertyInfo();
result.Context = value.Context;
result.FormulaObject = value.FormulaObject;
result.ID = value.ID;
result.Name = value.Name;
result.ParentProperty = value.ParentProperty;
result.PropertyRelationship = value.PropertyRelationship;
result.PropertyType = value.PropertyType;
result.RelationshipID = value.RelationshipID;
result.RelationshipLevel = value.RelationshipLevel;
result.RelationshipPropertyTail = value.RelationshipPropertyTail;
result.RelationshipTail = value.RelationshipTail;
result.Tooltip = value.Tooltip;
result.Type = value.Type;
result.Value = value.Value;
result.ValueSearched = value.ValueSearched;
return(result);
}
//private FormulaItemDTO GetParentFormulaItem(List<FormulaItemDTO> formulaItems, PropertyGetArg e)
//{
// if (string.IsNullOrEmpty(e.PropertyInfo.RelationshipTail))
// return null;
// foreach (var item in formulaItems)
// {
// if (item.RelationshipTail == e.PropertyInfo.RelationshipTail)
// return item;
// var fItem = GetParentFormulaItem(item.ChildFormulaItems, e);
// if (fItem != null)
// return fItem;
// }
// return null;
//}
private bool FormulaItemExists(MyPropertyInfo propertyInfo, int formulaItemID)
{
foreach (var item in FormulaItems)
{
if (item.RelationshipIDTail == propertyInfo.RelationshipTail && item.ItemType == GetFormulaItemType(propertyInfo.PropertyType) && item.ItemID == propertyInfo.ID)
{
return(true);
}
//if (propertyInfo.PropertyType == PropertyType.Relationship)
//{
// if (item.RelationshipTail == propertyInfo.RelationshipTail + (string.IsNullOrEmpty(propertyInfo.RelationshipTail) ? "" : ",") + propertyInfo.ID)
// return true;
//}
//else
//{
//if (item.ItemType == GetFormulaItemType(propertyInfo.PropertyType)
// && item.ItemID == formulaItemID)
//{
// return true;
//}
}
return(false);
}
private void OnProperyCalled(MyPropertyInfo property, string relationshipTailToProperty = "")
{
if (ParentCustomData != null)
{
if (string.IsNullOrEmpty(relationshipTailToProperty))
{
relationshipTailToProperty = ParentProperty.PropertyRelationship.ID.ToString();
}
else
{
relationshipTailToProperty = ParentProperty.PropertyRelationship.ID + "," + relationshipTailToProperty;
}
ParentCustomData.OnProperyCalled(property, relationshipTailToProperty);
}
if (PropertyCalled != null)
{
PropertyCalled(this, new MyFormulaFunctionStateFunctionLibrary.PropertyCalledArg()
{
CalledProperty = property, RelationshipPathToTargetProperty = relationshipTailToProperty
});
}
}
private static MyPropertyInfo GeneratePropertyInfo(TableDrivedEntityDTO entity, PropertyType propertyType, MyPropertyInfo parentProperty, int id, string name, object context)
{
MyPropertyInfo myPropertyInfo = new MyFormulaFunctionStateFunctionLibrary.MyPropertyInfo();
myPropertyInfo.Name = name;
// myPropertyInfo.FormulaObject = formulaObject;
myPropertyInfo.ID = id;
myPropertyInfo.ParentProperty = parentProperty;
myPropertyInfo.Context = context;
myPropertyInfo.PropertyType = propertyType;
if (parentProperty != null)
{
// myPropertyInfo.RelationshipTail = parentProperty.RelationshipTail + (string.IsNullOrEmpty(parentProperty.RelationshipTail) ? "" : ",") + relationship.ID;
myPropertyInfo.RelationshipLevel = parentProperty.RelationshipLevel + 1;
if (parentProperty.PropertyType == PropertyType.Relationship)
{
myPropertyInfo.RelationshipTail = parentProperty.RelationshipTail + (string.IsNullOrEmpty(parentProperty.RelationshipTail) ? "" : ",") + parentProperty.ID;
myPropertyInfo.RelationshipPropertyTail = parentProperty.RelationshipPropertyTail + (string.IsNullOrEmpty(parentProperty.RelationshipPropertyTail) ? "" : ".") + parentProperty.Name;
}
}
else
{
myPropertyInfo.RelationshipTail = "";
myPropertyInfo.RelationshipPropertyTail = "";
}
return(myPropertyInfo);
}
public static Dictionary <string, MyPropertyInfo> GetProperties(TableDrivedEntityDTO entity, MyPropertyInfo parentPropetyInfo, bool definition, bool withHelpers)
{
Dictionary <string, MyPropertyInfo> m_properties = new Dictionary <string, MyPropertyInfo>();
//روابط
foreach (var relationship in entity.Relationships.OrderBy(x => x.Name))
{
var name = "";
if (relationship.TypeEnum == Enum_RelationshipType.OneToMany)
{
name = "OTMREL" + relationship.Entity2;// + +relationship.ID;// + "_" + relationship.ID;
}
else if (relationship.TypeEnum == Enum_RelationshipType.ManyToOne)
{
name = "MTOREL" + relationship.Entity2;// + + relationship.ID;// + "_" + relationship.ID;
}
else
{
name = "OTOREL" + relationship.Entity2;// + + relationship.ID;// + "_" + relationship.ID;
}
MyPropertyInfo propertyInfo = GeneratePropertyInfo(entity, PropertyType.Relationship, parentPropetyInfo, relationship.ID, name, relationship);
//else
// propertyInfo.RelationshipTail = relationship.ID.ToString();
if (m_properties.Any(x => x.Key == propertyInfo.Name))
{
SetUniqueName(propertyInfo, m_properties);
}
propertyInfo.PropertyRelationship = relationship;
propertyInfo.Tooltip = relationship.TypeStr + Environment.NewLine + relationship.Name;
if (relationship.TypeEnum == Enum_RelationshipType.OneToMany)
{
propertyInfo.Type = GetNewFormulaObjectList(propertyInfo).GetType();
}
else
{
propertyInfo.Type = GetNewFormulaObject(propertyInfo).GetType();
}
m_properties.Add(propertyInfo.Name, propertyInfo);
}
foreach (var column in entity.Columns)
{
var name = "cl_" + column.Name;
MyPropertyInfo propertyInfo = GeneratePropertyInfo(entity, PropertyType.Column, parentPropetyInfo, column.ID, name, column);
//if (column.DateColumnType != null && column.DateColumnType.IsPersianDate)
//{
// propertyInfo.Type = GetCustomTypePropertyType(propertyInfo, ValueCustomType.IsPersianDate);
//}
//else
propertyInfo.Type = column.DotNetType;
if (definition)
{
//if (column.DateColumnType != null && column.DateColumnType.IsPersianDate)
//{
// propertyInfo.Value = GetCustomTypePropertyDefaultValue(propertyInfo, ValueCustomType.IsPersianDate);
//}
//else
//{
propertyInfo.Value = GetPropertyDefaultValue(propertyInfo);
//}
propertyInfo.ValueSearched = true;
}
else
{
propertyInfo.Value = null;
}
m_properties.Add(propertyInfo.Name, propertyInfo);
}
//مدل رو تا فولدر فرمول رفتم یا استیت رابطه داره و استیت هم با فرمول چیکار کنم
var formulaStates = bizEntityState.GetEntityStates(entity.ID, false);
foreach (var state in formulaStates)
{
var name = "st_" + state.Title;
MyPropertyInfo propertyInfo = GeneratePropertyInfo(entity, PropertyType.State, parentPropetyInfo, state.ID, name, state);
propertyInfo.Type = typeof(bool);
propertyInfo.Name = "st_" + state.Title;
if (definition)
{
propertyInfo.Value = GetPropertyDefaultValue(propertyInfo);
propertyInfo.ValueSearched = true;
}
else
{
propertyInfo.Value = null;
}
m_properties.Add(propertyInfo.Name, propertyInfo);
}
var formulaParameters = bizFormula.GetFormulas(entity.ID);
foreach (var formulaParameter in formulaParameters)
{
var name = "p_" + formulaParameter.Name;
MyPropertyInfo propertyInfo = GeneratePropertyInfo(entity, PropertyType.FormulaParameter, parentPropetyInfo, formulaParameter.ID, name, formulaParameter);
propertyInfo.ParameterFormulaID = formulaParameter.ID;
//if (formulaParameter.ValueCustomType != ValueCustomType.None)
//{
// propertyInfo.Type = GetCustomTypePropertyType(propertyInfo, formulaParameter.ValueCustomType);
//}
//else
propertyInfo.Type = formulaParameter.ResultDotNetType;
if (definition)
{
//if (formulaParameter.ValueCustomType != ValueCustomType.None)
//{
// propertyInfo.Value = GetCustomTypePropertyDefaultValue(propertyInfo, formulaParameter.ValueCustomType);
//}
//else
//{
propertyInfo.Value = GetPropertyDefaultValue(propertyInfo);
//}
propertyInfo.ValueSearched = true;
}
else
{
propertyInfo.Value = null;
}
m_properties.Add(propertyInfo.Name, propertyInfo);
}
//////var databaseFunctions = bizDatabaseFunction.GetDatabaseFunctionsByEntityID(entity.ID);
//////foreach (var dbfunction in databaseFunctions)
//////{
////// var name = "";
////// if (dbfunction.Type == Enum_DatabaseFunctionType.Function)
////// name = "fn_" + dbfunction.FunctionName;
////// else if (dbfunction.Type == Enum_DatabaseFunctionType.StoredProcedure)
////// name = "sp_" + dbfunction.FunctionName;
////// MyPropertyInfo propertyInfo = GeneratePropertyInfo(entity, PropertyType.DBFormula, parentPropetyInfo, dbfunction.ID, name, dbfunction, formulaObject);
////// //if (dbfunction.ValueCustomType != ValueCustomType.None)
////// //{
////// // propertyInfo.Type = GetCustomTypePropertyType(propertyInfo, dbfunction.ValueCustomType);
////// //}
////// //else
////// propertyInfo.Type = dbfunction.DotNetType;
////// if (definition)
////// {
////// //if (dbfunction.ValueCustomType != ValueCustomType.None)
////// //{
////// // propertyInfo.Value = GetCustomTypePropertyDefaultValue(propertyInfo, dbfunction.ValueCustomType);
////// //}
////// //else
////// //{
////// propertyInfo.Value = GetPropertyDefaultValue(propertyInfo);
////// //}
////// propertyInfo.ValueSearched = true;
////// }
////// else
////// {
////// propertyInfo.Value = null;
////// }
////// m_properties.Add(propertyInfo.Name, propertyInfo);
//////}
var codeFunctions = bizCodeFunction.GetCodeFunctionsByEntityID(entity.ID);
foreach (var codeFunction in codeFunctions)
{
var name = "cd_" + codeFunction.FunctionName;
MyPropertyInfo propertyInfo = GeneratePropertyInfo(entity, PropertyType.Code, parentPropetyInfo, codeFunction.ID, name, codeFunction);
//if (codeFunction.ValueCustomType != ValueCustomType.None)
//{
// propertyInfo.Type = GetCustomTypePropertyType(propertyInfo, codeFunction.ValueCustomType);
//}
//else
propertyInfo.Type = codeFunction.RetrunDotNetType;
if (definition)
{
//if (codeFunction.ValueCustomType != ValueCustomType.None)
//{
// propertyInfo.Value = GetCustomTypePropertyDefaultValue(propertyInfo, codeFunction.ValueCustomType);
//}
//else
//{
propertyInfo.Value = GetPropertyDefaultValue(propertyInfo);
//}
propertyInfo.ValueSearched = true;
}
else
{
propertyInfo.Value = null;
}
//فانکشنها در تعریف فرمول همینجا مقدار میگیرند
m_properties.Add(propertyInfo.Name, propertyInfo);
}
if (parentPropetyInfo == null)
{
//MyPropertyInfo numericHelperPropertyInfo = GeneratePropertyInfo(entity, PropertyType.Helper, parentPropetyInfo, 0, "NumericHelper", null);
//numericHelperPropertyInfo.Type = typeof(NumericHelper);
//numericHelperPropertyInfo.Value = new NumericHelper();
//numericHelperPropertyInfo.ValueSearched = true;
//m_properties.Add(numericHelperPropertyInfo.Name, numericHelperPropertyInfo);
////StringHelper
//MyPropertyInfo stringHelperPropertyInfo = GeneratePropertyInfo(entity, PropertyType.Helper, parentPropetyInfo, 0, "StringHelper", null);
//stringHelperPropertyInfo.Type = typeof(StringHelper);
//stringHelperPropertyInfo.Value = new StringHelper();
//stringHelperPropertyInfo.ValueSearched = true;
//m_properties.Add(stringHelperPropertyInfo.Name, stringHelperPropertyInfo);
//MyPropertyInfo persinaDateHelperPropertyInfo = GeneratePropertyInfo(entity, PropertyType.Helper, parentPropetyInfo, 0, "PersianDateHelper", null);
//persinaDateHelperPropertyInfo.Type = typeof(PersianDateHelper);
//persinaDateHelperPropertyInfo.Value = new PersianDateHelper();
//persinaDateHelperPropertyInfo.ValueSearched = true;
//m_properties.Add(persinaDateHelperPropertyInfo.Name, persinaDateHelperPropertyInfo);
//MyPropertyInfo miladiDateHelperPropertyInfo = GeneratePropertyInfo(entity, PropertyType.Helper, parentPropetyInfo, 0, "MiladiDateHelper", null);
//miladiDateHelperPropertyInfo.Type = typeof(MiladiDateHelper);
//miladiDateHelperPropertyInfo.Value = new MiladiDateHelper();
//miladiDateHelperPropertyInfo.ValueSearched = true;
//m_properties.Add(miladiDateHelperPropertyInfo.Name, miladiDateHelperPropertyInfo);
//MyPropertyInfo dbFunctionHelperHelperPropertyInfo = GeneratePropertyInfo(entity, PropertyType.Helper, parentPropetyInfo, 0, "DBFunctionHelper", null);
//dbFunctionHelperHelperPropertyInfo.Type = typeof(DBFunctionHelper);
//dbFunctionHelperHelperPropertyInfo.Value = new DBFunctionHelper(entity.DatabaseID);
//dbFunctionHelperHelperPropertyInfo.ValueSearched = true;
//m_properties.Add(dbFunctionHelperHelperPropertyInfo.Name, dbFunctionHelperHelperPropertyInfo);
}
return(m_properties);
}