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; }