private static void FillSqlClauseBuilder <T>(
SqlClauseBuilderIUW builder,
T graph,
ORMappingItemCollection mapping,
ClauseBindingFlags bindingFlags,
DoSqlClauseBuilder <T> builderDelegate,
params string[] ignoreProperties)
{
ExceptionHelper.FalseThrow <ArgumentNullException>(graph != null, "graph");
using (ORMappingContext context = ORMappingContext.GetContext())
{
foreach (ORMappingItem item in mapping)
{
if (Array.Exists <string>(ignoreProperties, target => (string.Compare(target, item.PropertyName, true) == 0)
) == false)
{
if ((item.BindingFlags & bindingFlags) != ClauseBindingFlags.None)
{
builderDelegate(builder, item, graph);
}
}
}
}
builder.AppendTenantCode(typeof(T));
}
private static void DataRowToBuilder(DataRow row, SqlClauseBuilderIUW builder, params string[] ignorColumns)
{
foreach (DataColumn column in row.Table.Columns)
{
if (Array.Exists(ignorColumns, (c => c == column.ColumnName)) == false)
{
builder.AppendItem(column.ColumnName, row[column.ColumnName]);
}
}
}
private static void FillSqlBuilder(SqlClauseBuilderIUW builder, StartWorkflowJob data)
{
builder.AppendItem("JOB_ID", data.JobID);
builder.AppendItem("PROCESS_KEY", data.ProcessKey);
builder.AppendTenantCode(typeof(StartWorkflowJob));
if (OguBase.IsNotNullOrEmpty(data.Operator))
{
builder.AppendItem("OPERATOR_ID", data.Operator.ID);
builder.AppendItem("OPERATOR_NAME", data.Operator.DisplayName);
}
}
private static void DoWhereSqlClauseBuilder <T>(SqlClauseBuilderIUW builder, ORMappingItem item, T graph)
{
object data = GetValueFromObject(item, graph);
if ((data == null || data == DBNull.Value))
{
builder.AppendItem(item.DataFieldName, data, SqlClauseBuilderBase.Is);
}
else
{
builder.AppendItem(item.DataFieldName, FormatValue(data, item));
}
}
private static void FillSqlClauseBuilder <T>(SqlClauseBuilderIUW builder, T graph, DataModel mapping,
ClauseBindingFlags bindingFlags, DoSqlClauseBuilder <T> builderDelegate, string[] ignorProperties)
{
ExceptionHelper.FalseThrow <ArgumentNullException>(graph != null, "graph");
mapping.Properties.ForEach(property =>
{
if (!ignorProperties.Contains(property.Name))
{
if (property.InputMapping)
{
builderDelegate(builder, property, graph);
}
}
});
}
private static void DoWhereSqlClauseBuilderByPrimaryKey <T>(SqlClauseBuilderIUW builder, DataProperty item, T graph)
{
if (item.Primary)
{
object data = GetPropertyValue(item, graph);
if ((data == null || data == DBNull.Value))
{
builder.AppendItem(item.FieldName, data, SqlClauseBuilderBase.Is);
}
else
{
builder.AppendItem(item.FieldName, data);
}
}
}
private static void DoInsertUpdateSqlClauseBuilder <T>(SqlClauseBuilderIUW builder, ORMappingItem item, T graph)
{
if (item.IsIdentity == false)
{
object data = GetValueFromObject(item, graph);
if ((data == null || data == DBNull.Value || (data != null && data.Equals(TypeCreator.GetTypeDefaultValue(data.GetType())))) &&
string.IsNullOrEmpty(item.DefaultExpression) == false)
{
builder.AppendItem(item.DataFieldName, item.DefaultExpression, SqlClauseBuilderBase.EqualTo, true);
}
else
{
builder.AppendItem(item.DataFieldName, FormatValue(data, item));
}
}
}
private static void DoInsertUpdateSqlClauseBuilder <T>(SqlClauseBuilderIUW builder, DataProperty property, T graph)
{
object data = GetPropertyValue(property, graph);
if (data == null || data == DBNull.Value || data.Equals(TypeCreator.GetTypeDefaultValue(data.GetType())))
{
if (string.IsNullOrWhiteSpace(property.DefaultValue))
{
data = DBNull.Value;
}
else
{
builder.AppendItem(property.FieldName, property.DefaultValue, SqlClauseBuilderBase.EqualTo, true);
}
}
else
{
builder.AppendItem(property.FieldName, data);
}
}
private static void FillSqlBuilder(SqlClauseBuilderIUW builder, InvokeWebServiceJob data)
{
builder.AppendItem("JOB_ID", data.JobID).AppendItem("SERVICE_DEF_DATA", data.XmlData).AppendTenantCode(typeof(InvokeWebServiceJob));
}
