public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
UIApplication uiapp = commandData.Application;
UIDocument uidoc = uiapp.ActiveUIDocument;
Document doc = uidoc.Document;
FilteredElementCollector floorCollector = FloorIntial.FloorCollector(doc);
System.Data.DataTable dt = FloorIntial.CreateFloorExcelTitle();
FloorIntial.FloorElementExcelPara(doc, floorCollector, dt);
//TaskDialog.Show("EXCEL放置位置", excelPath.ToString());
string t = "楼板.xls";
excelPath = LChuDemo.PickFolderInfo() + t;
LChuDemo.dataTableToCsv(dt, excelPath);
System.Diagnostics.Process.Start(excelPath);
//dt = FloorIntial.CreateFloorMySQLTitle();
//dt.TableName = "FloorTable";
//FloorIntial.FloorElementMySQLPara(doc, floorCollector, dt);
//string connStr = "server=localhost;database=mytest;uid=root;pwd=123456";
//var result = MySQLIntial.BulkInsert(connStr, dt, 1);
//if (result != 0.0)
//{
// TaskDialog.Show("导出到MYSQL中成功", "数据已经存入" + "数据库mytest" + dt.TableName + "中");
//}
FloorWpf doorWpf = new FloorWpf(dt);
if (doorWpf.ShowDialog() == false)
{
return(Result.Cancelled);
}
return(Result.Succeeded);
}
public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
UIApplication uiapp = commandData.Application;
UIDocument uidoc = uiapp.ActiveUIDocument;
Document doc = uidoc.Document;
FilteredElementCollector columnCollector = ColumnIntial.ColumnCollector(doc);
DataTable dt = ColumnIntial.CreateColumnExcelTitle();
ColumnIntial.ColumnElementExcelPara(doc, columnCollector, dt);
string t = "结构柱.xls";
excelPath = LChuDemo.PickFolderInfo() + t;
LChuDemo.dataTableToCsv(dt, excelPath);
System.Diagnostics.Process.Start(excelPath);
//dt = ColumnIntial.CreateColumnMySQLTitle();
//dt.TableName = "StructColumnTable";
//ColumnIntial.ColumnElementMySQLPara(doc, columnCollector, dt);
////传入数据
//ColumnWpf columnWpf = new ColumnWpf(dt);
//if (columnWpf.ShowDialog() == false)
//{
// return Result.Cancelled;
//}
//传入数据
ColumnWpf columnWpf = new ColumnWpf(dt);
if (columnWpf.ShowDialog() == false)
{
return(Result.Cancelled);
}
return(Result.Succeeded);
}
//@"D:\梁demo.xls";
public Result Execute(ExternalCommandData commandData, ref string message, ElementSet elements)
{
//初始化相关元素
UIApplication uiapp = commandData.Application;
UIDocument uidoc = uiapp.ActiveUIDocument;
Document doc = uidoc.Document;
//创造梁过滤器
FilteredElementCollector beamCollector = BeamIntial.BeamCollector(doc);
//自动生成一个DataTable表格，将这份表格导入到CSV和MYSQL中
//生成相关TITLE中
DataTable dt = BeamIntial.CreateBeamExcelTitle();
//调用静态函数
BeamIntial.BeamElementExcelPara(doc, beamCollector, dt);
string t = "梁.xls";
excelPath = LChuDemo.PickFolderInfo() + t;
//将其导入到相关的位置下
LChuDemo.dataTableToCsv(dt, excelPath);
//导入到相关位置
//TaskDialog.Show("表已经导入到当前位置",excelPath.ToString());
System.Diagnostics.Process.Start(excelPath);
////生成一个新的MYSQL数据表格
//dt = BeamIntial.CreateBeamMySQLTitle();
////这是为了给datatable赋值，放置不存在，嘻嘻嘻嘻
////赋予DATATABLE的值
//dt.TableName = "BeamTable";
////将MYSQL数据导入到相关数据中
//BeamIntial.BeamElementMySQLPara(doc, beamCollector, dt);
////这里是一个按钮
//传入数据
BeamWpf beamWpf = new BeamWpf(dt);
if (beamWpf.ShowDialog() == false)
{
return(Result.Cancelled);
}
return(Result.Succeeded);
}
