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