private static string PrepareValueSql(string roleID, SOARolePropertyRow row, SOARolePropertyValue propValue) { InsertSqlClauseBuilder builder = ORMapping.GetInsertSqlClauseBuilder(propValue); builder.AppendItem("ROLE_ID", roleID); builder.AppendItem("PROPERTIES_ROW_ID", row.RowNumber); builder.AppendItem("PROPERTY_NAME", propValue.Column.Name); return("INSERT INTO WF.ROLE_PROPERTIES_CELLS" + builder.ToSqlString(TSqlBuilder.Instance)); }
private static void FillSheetData(SOARole role, WorkSheet ws) { int rowIndex = 4; SOARolePropertyRowCollection rows = SOARolePropertiesAdapter.Instance.LoadByRole(role, role.PropertyDefinitions); foreach (SOARolePropertyRow row in rows) { foreach (DefinedName name in ws.Names) { SOARolePropertyValue propertyValue = row.Values.FindByColumnName(name.Name); string dataValue = null; if (propertyValue != null) { dataValue = propertyValue.Value; } else { switch (name.Name.ToLower()) { case "operatortype": dataValue = row.OperatorType.ToString(); break; case "operator": dataValue = row.Operator; break; } } if (dataValue != null) { ws.Cells[rowIndex, name.Address.StartColumn].Value = dataValue; } } rowIndex++; } }