37
« on: November 06, 2011, 10:51:54 AM »
Hi,
Here's a little example for attributes extraction.
I try to write it in a "declarative" style using the Linq extension methods and some others defined in the Extension class (thanks to Thorsten 'kaefer' @ TheSwamp for its nice 'evil' ones).
The extraction is collected in a System.Data.DataTable so that it can be easily converted to an AutoCAD table, an Exel sheet and so on.
The DataTable.WriteXls() extension method uses late binding while interacting with Excel application to avoid version reference dependency.
The BlockAttribute class which defines a new Type which main properties are:
- Block: the block (effective) name ;
- Attributes: a dictionary for the block attributes where Key is the tag and Value the text string.
The BlockAttributeEqualityComparer class implements the IEqualityComparer<BlockAttribute> interface so that BlockAttribute collections can be used with some Linq extension methods as GroupBy().
using System;
using System.Collections.Generic;
using System.Linq;
using Autodesk.AutoCAD.ApplicationServices;
using Autodesk.AutoCAD.DatabaseServices;
using AcAp = Autodesk.AutoCAD.ApplicationServices.Application;
namespace AttributeExtraction
{
public class BlockAttribute
{
private string _name;
private Dictionary<string, string> _atts;
// Public read only properties
public string Name
{
get { return _name; }
}
public Dictionary<string, string> Attributes
{
get { return _atts; }
}
public string this[string key]
{
get { return _atts[key.ToUpper()]; }
}
// Constructors
public BlockAttribute(BlockReference br)
{
SetProperties(br);
}
public BlockAttribute(ObjectId id)
{
Document doc = AcAp.DocumentManager.MdiActiveDocument;
using (Transaction tr = doc.TransactionManager.StartTransaction())
{
SetProperties(tr.GetObject(id, OpenMode.ForRead) as BlockReference);
}
}
// Public method
new public string ToString()
{
if (_atts != null && _atts.Count > 0)
return string.Format("{0}: {1}",
_name,
_atts.Select(a => string.Format("{0}={1}", a.Key, a.Value))
.Aggregate((a, b) => string.Format("{0}; {1}", a, b)));
return _name;
}
// Private method
private void SetProperties(BlockReference br)
{
if (br == null) return;
_name = br.GetEffectiveName();
_atts = new Dictionary<string, string>();
br.AttributeCollection
.GetObjects<AttributeReference>()
.Iterate(att => _atts.Add(att.Tag.ToUpper(), att.TextString));
}
}
public class BlockAttributeEqualityComparer : IEqualityComparer<BlockAttribute>
{
public bool Equals(BlockAttribute x, BlockAttribute y)
{
return
x.Name.Equals(y.Name, StringComparison.CurrentCultureIgnoreCase) &&
x.Attributes.SequenceEqual(y.Attributes);
}
public int GetHashCode(BlockAttribute obj)
{
return base.GetHashCode();
}
}
}
The Extensions class provides extension methods that allows to write code in a more "declarative" style
and methods to build a DataTable from a BlockAttribute collection and convert this DataTable into xls, csv files or AutoCAD Table.
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Linq;
using Autodesk.AutoCAD.DatabaseServices;
using AcDataTable = Autodesk.AutoCAD.DatabaseServices.DataTable;
using Autodesk.AutoCAD.Runtime;
namespace AttributeExtraction
{
public static class Extensions
{
// Thorsten's 'evil' extension methods (thanks again to him)
public static T GetObject<T>(this ObjectId id) where T : DBObject
{
return id.GetObject<T>(OpenMode.ForRead);
}
public static T GetObject<T>(this ObjectId id, OpenMode openMode) where T : DBObject
{
return id.GetObject(openMode, false, false) as T;
}
public static IEnumerable<T> GetObjects<T>(this IEnumerable ids) where T : DBObject
{
return ids.GetObjects<T>(OpenMode.ForRead);
}
public static IEnumerable<T> GetObjects<T>(this IEnumerable ids, OpenMode openMode) where T : DBObject
{
RXClass rxc = RXObject.GetClass(typeof(T));
return ids
.Cast<ObjectId>()
.Where(id => id.ObjectClass == rxc || id.ObjectClass.IsDerivedFrom(rxc))
.Select(id => (T)id.GetObject(openMode, false, false));
}
// Mimics the F# Seq.iter function
public static void Iterate<T>(this IEnumerable<T> collection, Action<T> action)
{
foreach (T item in collection) action(item);
}
// Mimics the F# Seq.iteri function
public static void Iterate<T>(this IEnumerable<T> collection, Action<T, int> action)
{
int i = 0;
foreach (T item in collection) action(item, i++);
}
// Gets the block effective name (anonymous dynamic blocs)
public static string GetEffectiveName(this BlockReference br)
{
if (br.IsDynamicBlock)
return br.DynamicBlockTableRecord.GetObject<BlockTableRecord>().Name;
return br.Name;
}
// Creates a Datatable from a BlockAttribute collection
public static System.Data.DataTable ToDataTable(this IEnumerable<BlockAttribute> blockAtts, string name)
{
System.Data.DataTable dTable = new System.Data.DataTable(name);
dTable.Columns.Add("Name", typeof(string));
dTable.Columns.Add("Quantity", typeof(int));
blockAtts
.GroupBy(blk => blk, (blk, blks) => new { Block = blk, Count = blks.Count() }, new BlockAttributeEqualityComparer())
.Iterate(row =>
{
System.Data.DataRow dRow = dTable.Rows.Add(row.Block.Name, row.Count);
row.Block.Attributes.Iterate(att =>
{
if (!dTable.Columns.Contains(att.Key))
dTable.Columns.Add(att.Key);
dRow[att.Key] = att.Value;
});
});
return dTable;
}
// Converts a Datatble into a two dimensional object array
public static object[,] ToArray(this System.Data.DataTable dTable)
{
int numRows = dTable.Rows.Count;
int numColoumns = dTable.Columns.Count;
object[,] result = new object[numRows + 1, numColoumns];
string[] colNames = dTable.GetColumnNames().ToArray();
for (int i = 0; i < numColoumns; i++)
{
result[0, i] = colNames[i];
}
for (int i = 0; i < numRows; i++)
{
for (int j = 0; j < numColoumns; j++)
{
result[i + 1, j] = dTable.Rows[i][j];
}
}
return result;
}
// Gets the column names collection of the Datatable
public static IEnumerable<string> GetColumnNames(this System.Data.DataTable dataTbl)
{
return dataTbl.Columns.Cast<System.Data.DataColumn>().Select(col => col.ColumnName);
}
// Writes a xls file from the datatable
public static void WriteXls(this System.Data.DataTable dataTbl, string filename, string sheetName, bool visible)
{
object mis = Type.Missing;
object xlApp = LateBinding.GetOrCreateInstance("Excel.Application");
xlApp.Set("DisplayAlerts", false);
object workbooks = xlApp.Get("Workbooks");
object workbook, worksheet;
if (File.Exists(filename))
workbook = workbooks.Invoke("Open", filename);
else
workbook = workbooks.Invoke("Add", mis);
if (string.IsNullOrEmpty(sheetName))
worksheet = workbook.Get("Activesheet");
else
{
object worksheets = workbook.Get("Worksheets");
try
{
worksheet = worksheets.Get("Item", sheetName);
worksheet.Get("Cells").Invoke("Clear");
}
catch
{
worksheet = worksheets.Invoke("Add", mis);
worksheet.Set("Name", sheetName);
}
}
object range = worksheet.Get("Range",
worksheet.Get("Cells", 1, 1),
worksheet.Get("Cells", dataTbl.Rows.Count + 1, dataTbl.Columns.Count));
range.Set("NumberFormat", "@");
range.Set("Value2", dataTbl.ToArray());
xlApp.Set("DisplayAlerts", true);
if (visible)
{
xlApp.Set("Visible", true);
}
else
{
if (File.Exists(filename))
workbook.Invoke("Save");
else
{
int fileFormat =
string.Compare("11.0", (string)xlApp.Get("Version")) < 0 &&
filename.EndsWith(".xlsx", StringComparison.CurrentCultureIgnoreCase) ?
51 : -4143;
workbook.Invoke("Saveas", filename, fileFormat, string.Empty, string.Empty, false, false, 1, 1);
}
workbook.Invoke("Close");
workbook = null;
xlApp.Invoke("Quit");
xlApp.ReleaseInstance();
xlApp = null;
}
}
// Writes a csv file from the datatable
public static void WriteCsv(this System.Data.DataTable dataTbl, string filename)
{
using (StreamWriter writer = new StreamWriter(filename))
{
writer.WriteLine(dataTbl.GetColumnNames().Aggregate((s1, s2) => string.Format("{0},{1}", s1, s2)));
dataTbl.Rows
.Cast<DataRow>()
.Select(row => row.ItemArray.Aggregate((s1, s2) => string.Format("{0},{1}", s1, s2)))
.Iterate(line => writer.WriteLine(line));
}
}
// Creates an AutoCAD Table from the datatable
public static Table ToAcadTable(this System.Data.DataTable dataTbl, double rowHeight, double columnWidth)
{
Table tbl = new Table();
tbl.Rows[0].Height = rowHeight;
tbl.Columns[0].Width = columnWidth;
tbl.InsertColumns(0, columnWidth, dataTbl.Columns.Count - 1);
tbl.InsertRows(0, rowHeight, dataTbl.Rows.Count + 1);
tbl.Cells[0, 0].Value = dataTbl.TableName;
dataTbl.GetColumnNames()
.Iterate((name, i) => tbl.Cells[1, i].Value = name);
dataTbl.Rows
.Cast<DataRow>()
.Iterate((row, i) =>
row.ItemArray.Iterate((item, j) =>
tbl.Cells[i + 2, j].Value = item));
return tbl;
}
}
}
The LateBinding class provides helpers to write late binding instructions in a more friendly style (thanks to Thorsten and Tony T).
using BF = System.Reflection.BindingFlags;
namespace AttributeExtraction
{
public static class LateBinding
{
public static object GetInstance(string appName)
{
return System.Runtime.InteropServices.Marshal.GetActiveObject(appName);
}
public static object CreateInstance(string appName)
{
return System.Activator.CreateInstance(System.Type.GetTypeFromProgID(appName));
}
public static object GetOrCreateInstance(string appName)
{
try { return GetInstance(appName); }
catch { return CreateInstance(appName); }
}
public static object Get(this object obj, string propName, params object[] parameter)
{
return obj.GetType().InvokeMember(propName, BF.GetProperty, null, obj, parameter);
}
public static void Set(this object obj, string propName, params object[] parameter)
{
obj.GetType().InvokeMember(propName, BF.SetProperty, null, obj, parameter);
}
public static object Invoke(this object obj, string methName, params object[] parameter)
{
return obj.GetType().InvokeMember(methName, BF.InvokeMethod, null, obj, parameter);
}
public static void ReleaseInstance(this object obj)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
}
}
}
A testing command
using System.Linq;
using Autodesk.AutoCAD.ApplicationServices;
using Autodesk.AutoCAD.DatabaseServices;
using Autodesk.AutoCAD.EditorInput;
using Autodesk.AutoCAD.Runtime;
using AcAp = Autodesk.AutoCAD.ApplicationServices.Application;
namespace AttributeExtraction
{
public class Commands
{
[CommandMethod("Test")]
public void Test()
{
Document doc = AcAp.DocumentManager.MdiActiveDocument;
Database db = doc.Database;
Editor ed = doc.Editor;
TypedValue[] filter = { new TypedValue(0, "INSERT") };
PromptSelectionResult psr = ed.GetSelection(new SelectionFilter(filter));
if (psr.Status != PromptStatus.OK) return;
PromptPointResult ppr = ed.GetPoint("\nInsertion point: ");
if (ppr.Status != PromptStatus.OK) return;
using (Transaction tr = db.TransactionManager.StartTransaction())
{
System.Data.DataTable dataTable = psr.Value.GetObjectIds()
.Select(id => new BlockAttribute(id.GetObject<BlockReference>()))
.ToDataTable("Extraction");
Table tbl = dataTable.ToAcadTable(9.0, 40.0);
tbl.Position = ppr.Value.TransformBy(ed.CurrentUserCoordinateSystem);
BlockTableRecord btr = db.CurrentSpaceId.GetObject<BlockTableRecord>(OpenMode.ForWrite);
btr.AppendEntity(tbl);
tr.AddNewlyCreatedDBObject(tbl, true);
try
{
string filename = (string)AcAp.GetSystemVariable("dwgprefix") + "Extraction.xls";
dataTable.WriteXls(filename, null, true);
}
catch
{
AcAp.ShowAlertDialog("Failed to open Excel");
}
tr.Commit();
}
}
}
}
Show Posts