protected override void AfterLoad(WfMatrixDefinitionCollection data)
{
if (data.Count == 0)
{
return;
}
InSqlClauseBuilder builder = new InSqlClauseBuilder("MATRIX_DEF_KEY");
data.ForEach(md => builder.AppendItem(md.Key));
string sql = string.Format("SELECT * FROM WF.MATRIX_DIMENSION_DEFINITION WHERE {0} ORDER BY MATRIX_DEF_KEY, SORT_ORDER",
builder.AppendTenantCodeSqlClause(typeof(WfMatrixDefinition)).ToSqlString(TSqlBuilder.Instance));
DataTable table = DbHelper.RunSqlReturnDS(sql, GetConnectionName()).Tables[0];
foreach (DataRow row in table.Rows)
{
WfMatrixDimensionDefinition dd = new WfMatrixDimensionDefinition();
ORMapping.DataRowToObject(row, dd);
WfMatrixDefinition matrixDefinition = data.Find(md => string.Compare(md.Key, dd.MatrixKey, true) == 0);
if (matrixDefinition != null)
{
matrixDefinition.Dimensions.Add(dd);
}
}
}
public override object Deserialize(IDictionary <string, object> dictionary, Type type, JavaScriptSerializer serializer)
{
WfMatrixDimensionDefinition matrixDimensionDefinition = new WfMatrixDimensionDefinition();
matrixDimensionDefinition.DataType = DictionaryHelper.GetValue(dictionary, "DataType", PropertyDataType.String);
matrixDimensionDefinition.Description = DictionaryHelper.GetValue(dictionary, "Description", string.Empty);
matrixDimensionDefinition.DimensionKey = DictionaryHelper.GetValue(dictionary, "DimensionKey", string.Empty);
matrixDimensionDefinition.MatrixKey = DictionaryHelper.GetValue(dictionary, "MatrixKey", string.Empty);
matrixDimensionDefinition.Name = DictionaryHelper.GetValue(dictionary, "Name", string.Empty);
matrixDimensionDefinition.SortOrder = DictionaryHelper.GetValue(dictionary, "SortOrder", 0);
return(matrixDimensionDefinition);
}
public override IDictionary <string, object> Serialize(object obj, JavaScriptSerializer serializer)
{
IDictionary <string, object> dictionary = new Dictionary <string, object>();
WfMatrixDimensionDefinition matrixDimensionDefinition = (WfMatrixDimensionDefinition)obj;
DictionaryHelper.AddNonDefaultValue <string, object>(dictionary, "DataType", matrixDimensionDefinition.DataType);
DictionaryHelper.AddNonDefaultValue <string, object>(dictionary, "Description", matrixDimensionDefinition.Description);
DictionaryHelper.AddNonDefaultValue <string, object>(dictionary, "DimensionKey", matrixDimensionDefinition.DimensionKey);
DictionaryHelper.AddNonDefaultValue <string, object>(dictionary, "MatrixKey", matrixDimensionDefinition.MatrixKey);
DictionaryHelper.AddNonDefaultValue <string, object>(dictionary, "Name", matrixDimensionDefinition.Name);
DictionaryHelper.AddNonDefaultValue <string, object>(dictionary, "SortOrder", matrixDimensionDefinition.SortOrder);
return(dictionary);
}
public WfMatrixCell(WfMatrixDimensionDefinition dd)
{
dd.NullCheck("dd");
Definition = dd;
}
