private void fill_table(BomFeature bom)
{
found_bom = bom;
string itno = string.Empty;
string ptno = string.Empty;
_cols.Clear();
_prts.Clear();
swTable = (ITableAnnotation)bom.IGetTableAnnotations(1);
part.ClearSelection2(true);
_col_count = swTable.ColumnCount;
find_part_column();
_row_count = swTable.RowCount;
for (int i = 0; i < _col_count; i++)
{
_cols.Add(swTable.get_DisplayedText(0, i));
}
object[] bomtaa = (object[])bom.GetTableAnnotations();
BomTableAnnotation bta = (BomTableAnnotation)bomtaa[0];
int prtcol = get_column_by_name(_part_column);
for (int i = 0; i < _row_count; i++)
{
string prt_ = swTable.get_DisplayedText(i, prtcol);
_prts.Add(prt_);
string[] pathnames = (string[])bta.GetModelPathNames(i, out itno, out ptno);
if (pathnames != null)
{
foreach (string pathname in pathnames)
{
FileInfo fi_ = new FileInfo(pathname);
path_list.Add(fi_);
if (!path_dict.ContainsKey(prt_.ToUpper()))
{
path_dict.Add(prt_.ToUpper(), fi_);
}
}
}
}
initialated = true;
}
/// <summary>
/// Returns Lists of Custom_parts and Standard_Parts
/// </summary>
/// <param name="swModel"></param>
/// <param name="swTableAnn"></param>
/// <param name="ConfigName"></param>
/// <param name="Standard_Parts"></param>
/// <param name="Custom_Parts"></param>
public static void Get_Sorted_Part_Data(ModelDoc2 swModel, BomFeature swBomFeat, List <BOM_Part_Informations> Standard_Parts, List <BOM_Part_Informations> Custom_Parts, string projectpath)
{
try
{
int nNumRow = 0;
int J = 0;
int I = 0;
int numStandard_Part = 1;
int numCustom_Part = 1;
int quantity = 0;
int index_description = 0;
int index_article_number = 0;
int index_supplier = 0;
BOM_Part_Informations part_informations;
string ItemNumber = null;
string PartNumber = null;
// Debug.Print(" Table Title " + swTableAnn.Title);
Feature swFeat = default(Feature);
object[] vTableArr = null;
object vTable = null;
string[] vConfigArray = null;
object vConfig = null;
string ConfigName = null;
string partconfig = null;
TableAnnotation swTable = default(TableAnnotation);
Annotation swAnnotation = default(Annotation);
object visibility = null;
swFeat = swBomFeat.GetFeature();
vTableArr = (object[])swBomFeat.GetTableAnnotations();
foreach (TableAnnotation vTable_loopVariable in vTableArr)
{
vTable = vTable_loopVariable;
swTable = (TableAnnotation)vTable;
vConfigArray = (string[])swBomFeat.GetConfigurations(true, ref visibility);
foreach (object vConfig_loopVariable in vConfigArray)
{
vConfig = vConfig_loopVariable;
ConfigName = (string)vConfig;
// MessageBox.Show(ConfigName);
// swTable.SaveAsPDF(@"C:\Users\alex\Desktop\test.pdf");
nNumRow = swTable.RowCount;
BomTableAnnotation swBOMTableAnn = default(BomTableAnnotation);
swBOMTableAnn = (BomTableAnnotation)swTable;
//swTable.GetColumnTitle
for (int h = 0; h < swTable.ColumnCount; h++)
{
switch (swTable.GetColumnTitle(h))
{
case "Benennung":
index_description = h;
break;
case "Artikelnummer":
index_article_number = h;
break;
case "Lieferant":
index_supplier = h;
break;
default:
break;
}
}
if (index_supplier != 0 || index_supplier != 0 || index_article_number != 0) //Standard BOM Template
{
for (int n = 0; n <= nNumRow - 1; n++)
{
// Debug.Print(" Row Number " + J + " Component Count : " + swBOMTableAnn.GetComponentsCount2(J, ConfigName, out ItemNumber, out PartNumber));
// Debug.Print(" Item Number : " + ItemNumber);
// Debug.Print(" Part Number : " + PartNumber);
// MessageBox.Show("bubu");
object[] vPtArr = null;
Component2 swComp = null;
object pt = null;
quantity = swBOMTableAnn.GetComponentsCount2(n, ConfigName, out ItemNumber, out PartNumber);
vPtArr = (object[])swBOMTableAnn.GetComponents2(n, ConfigName);
if (((vPtArr != null)))
{
for (I = 0; I <= vPtArr.GetUpperBound(0); I++)
{
pt = vPtArr[I];
swComp = (Component2)pt;
if ((swComp != null))
{
part_informations = new BOM_Part_Informations();
part_informations.manufacturer = swTable.get_Text(n, index_supplier);
part_informations.order_number = swTable.get_Text(n, index_article_number);
part_informations.IsAssembly = false;
part_informations.part_number = PartNumber.TrimStart();
part_informations.quantity = quantity.ToString();
//Custom part
if (swComp.GetPathName().Contains(projectpath))
{
if (swComp.GetPathName().Contains(".sldasm") || swComp.GetPathName().Contains(".SLDASM"))
{
// MessageBox.Show(swComp.GetPathName());
part_informations.IsAssembly = true;
}
part_informations.description = swComp.ReferencedConfiguration;
part_informations.item_number = numCustom_Part.ToString();
numCustom_Part++;
Custom_Parts.Add(part_informations);
break;
}
part_informations.description = swTable.get_Text(n, index_description);
part_informations.item_number = numStandard_Part.ToString();
numStandard_Part++;
Standard_Parts.Add(part_informations);
break;
}
else
{
Debug.Print(" Could not get component.");
}
}
}
}
}
else //No Standard BOM Template
{
for (J = 0; J <= nNumRow - 1; J++)
{
// Debug.Print(" Row Number " + J + " Component Count : " + swBOMTableAnn.GetComponentsCount2(J, ConfigName, out ItemNumber, out PartNumber));
// Debug.Print(" Item Number : " + ItemNumber);
// Debug.Print(" Part Number : " + PartNumber);
object[] vPtArr = null;
Component2 swComp = null;
object pt = null;
quantity = swBOMTableAnn.GetComponentsCount2(J, ConfigName, out ItemNumber, out PartNumber);
vPtArr = (object[])swBOMTableAnn.GetComponents2(J, ConfigName);
if (((vPtArr != null)))
{
for (I = 0; I <= vPtArr.GetUpperBound(0); I++)
{
pt = vPtArr[I];
swComp = (Component2)pt;
if ((swComp != null))
{
part_informations = new BOM_Part_Informations();
part_informations.description = swComp.ReferencedConfiguration;
part_informations.part_number = PartNumber;
part_informations.quantity = quantity.ToString();
//Custom part
if (swComp.GetPathName().Contains(projectpath))
{
if (swComp.GetPathName().Contains(".sldasm") || swComp.GetPathName().Contains(".SLDASM"))
{
break;
}
else
{
part_informations.item_number = numCustom_Part.ToString();
numCustom_Part++;
Custom_Parts.Add(part_informations);
break;
}
}
part_informations.item_number = numStandard_Part.ToString();
numStandard_Part++;
Standard_Parts.Add(part_informations);
break;
}
else
{
Debug.Print(" Could not get component.");
}
}
}
}
}
break;
}
}
swAnnotation = swTable.GetAnnotation();
swAnnotation.Select3(false, null);
swModel.EditDelete();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ex.StackTrace);
}
}
public void GetXMLfromBOM()
{
swapp = (SldWorks)Marshal.GetActiveObject("SldWorks.Application");
swmodel = swapp.ActiveDoc;
swModelDocExt = swmodel.Extension;
//создаем MemoryStream, в который будем писать XML
var myMemoryStream = new MemoryStream();
//создаем XmlTextWriter, указываем объект – myMemoryStream, в который будем писать XML, и кодировку
try
{
var myXml = new System.Xml.XmlTextWriter("C:\\Program Files\\SW-Complex\\SP-Temp.xml", System.Text.Encoding.UTF8);
swDraw = (DrawingDoc)swmodel;
vSheetNames = swDraw.GetSheetNames();
ok = swDraw.ActivateSheet(vSheetNames[0]);
swView = swDraw.GetFirstView();
// Получаем параметры модели
swView = swView.GetNextView();
swmodel = swView.ReferencedDocument;
//swSelMgr = swDraw.SelectionManager;
myXml.WriteStartDocument();
myXml.Formatting = System.Xml.Formatting.Indented;
//длина отступа
myXml.Indentation = 2;
vConfName = swmodel.GetConfigurationNames();
swapp = new SldWorks();
swmodel = swapp.ActiveDoc;
Feature swFeat = swmodel.FirstFeature();
while ((swFeat != null))
{
if (swFeat.GetTypeName() == "BomFeat")
{
swFeat.Select(true);
swBomFeature = swFeat.GetSpecificFeature2();
}
swFeat = swFeat.GetNextFeature();
}
//////////////////////////////////////////////////////
//
// GetPropertyBomTableFromDrawDoc
//
//////////////////////////////////////////////////////
object vConfigurations = null;
object vVisibility = null;
bool bGetVisible = false;
long lNumRow = 0;
long lNumColumn = 0;
int lRow = 0;
TableAnnotation swTableAnnotation = default(TableAnnotation);
ModelDoc2 swDocument = default(ModelDoc2);
AssemblyDoc swAssembly = default(AssemblyDoc);
int lStartRow = 0;
string strItemNumber = "";
string strPartNumber = "";
string strDescription = "";
var strDocumentName = swBomFeature.GetReferencedModelName();
swDocument = swapp.GetOpenDocumentByName(strDocumentName);
swAssembly = (AssemblyDoc)swDocument;
//swBOMTableAnnotation = swBomFeature.GetTableAnnotations(0)
var swBomTableAnnotation = (BomTableAnnotation)swBomFeature.GetTableAnnotations()[0];
swTableAnnotation = (TableAnnotation)swBomTableAnnotation;
lNumRow = swTableAnnotation.RowCount;
lNumColumn = swTableAnnotation.ColumnCount;
lStartRow = 1;
//If (Not (swTableAnnotation.TitleVisible = False)) Then
if (swTableAnnotation.TitleVisible == false)
{
lStartRow = 2;
}
bGetVisible = false;
vConfigurations = swBomFeature.GetConfigurations(bGetVisible, vVisibility);
//swTableAnnotation = swTableAnnotation;
///////////////////////////////////////////////////////////////////
swSheet = swDraw.GetCurrentSheet();
strActiveSheetName = swSheet.GetName();
vSheetNames = swDraw.GetSheetNames();
ok = swDraw.ActivateSheet(vSheetNames[0]);
swSheet = swDraw.GetCurrentSheet();
swView = swDraw.GetFirstView();
if (swSheet.CustomPropertyView == "По умолчанию" | swSheet.CustomPropertyView == "Default")
{
swView = swView.GetNextView();
}
// get custom property
var valout = ""; //Обозначение
var valout1 = ""; //Наименование
CustomPropertyManager swCustProp = default(CustomPropertyManager);
var resolvedValOut = "";
var resolvedValOut1 = "";
//string resolvedValOut3 = "";
//string resolvedValOut4 = "";
//string resolvedValOut5 = "";
swCustProp = swmodel.Extension.CustomPropertyManager[""];
swCustProp.Get2("Обозначение", out valout, out resolvedValOut);
swCustProp.Get2("Description", out valout1, out resolvedValOut1);
// переменные для колонок
int Jj = 0; // наименование
int aa = 0; // раздел
int oo = 0; // обозначение
int tt = 0; // формат
int yy = 0; //
int uu = 0; // Код материала
int ss = 0; // Примечание
string sRowStr = null; // наименовани
string sRowStr1 = null; // раздел
string sRowStr2 = null; // обозначение
string sRowStr3 = null; // формат
string sRowStr4 = null; // ERP code
string sRowStr5 = null; // Код материала
string sRowStr6 = null; // Примечание
// При выборе электромонтажа
string Complect = "";
if (addinform.ChkElectro1.Checked)
{
Complect = "МЭ";
}
else if (addinform.ChkElectro2.Checked)
{
Complect = "ТБ";
}
////////////////////////////////////////////////////////////
//
// XML
//
////////////////////////////////////////////////////////////
//создаем элементы
myXml.WriteStartElement("xml");
//
myXml.WriteStartElement("Item");
// имя пути основного чертежа
myXml.WriteStartElement("PathName");
//записываем строку
myXml.WriteString(swmodel.GetPathName());
myXml.WriteEndElement();
// Устанавливаем ДОК из формы добавление
myXml.WriteStartElement("doc");
//
myXml.WriteStartElement("Обозначение");
//записываем строку
myXml.WriteString(resolvedValOut + "CБ");
myXml.WriteEndElement();
//
myXml.WriteStartElement("Наименование");
myXml.WriteString("Сборочный чертеж");
myXml.WriteEndElement();
//
myXml.WriteEndElement(); //doc
//dynamic CheckedRows2 = (from Rows in addinform.DGDoc.Rows.Cast<DataGridViewRow>()where Convert.ToBoolean(Rows.Cells(0).Value) == true).ToList;
dynamic CheckedRows2 = (from Rows in addinform.DGDoc.Rows.Cast <DataGridViewRow>() where Convert.ToBoolean(Rows.Cells[0].Value.ToString()) select Rows).ToList();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (DataGridViewRow row in CheckedRows2)
{
sb.AppendLine(row.Cells[1].Value.ToString());
sb.ToString();
//Оставляем первые две буквы для обозначения разделитель
var literal = row.Cells[1].Value.ToString();
var substring = literal.Substring(0, 2);
var literal2 = row.Cells[1].Value.ToString();
var substring2 = literal2.Substring(5);
myXml.WriteStartElement("doc");
///
myXml.WriteStartElement("Обозначение");
//записываем строку
myXml.WriteString(resolvedValOut + substring);
myXml.WriteEndElement();
///
myXml.WriteStartElement("Наименование");
myXml.WriteString(substring2);
myXml.WriteEndElement();
///
myXml.WriteEndElement();
//doc
}
//<------------- Elec
if (addinform.ChkElectro.Checked == true & addinform.ChkElectro1.Checked == false & addinform.ChkElectro2.Checked == false)
{
myXml.WriteStartElement("Elec");
//Elec
myXml.WriteString("Устанавливают при электромонтаже");
myXml.WriteEndElement();
//Elec
}
//<------------- ChkElectro1
if (addinform.ChkElectro.Checked == true & addinform.ChkElectro1.Checked == true)
{
myXml.WriteStartElement("Elec");
//Elec
myXml.WriteString("Устанавливают по " + resolvedValOut + Complect);
myXml.WriteEndElement();
//Elec
}
//<------------- ChkElectro2
if (addinform.ChkElectro.Checked == true & addinform.ChkElectro2.Checked == true)
{
myXml.WriteStartElement("Elec");
//Elec
myXml.WriteString("Устанавливают по " + resolvedValOut + Complect);
myXml.WriteEndElement();
//Elec
}
//
myXml.WriteStartElement("Обозначение");
//записываем строку
myXml.WriteString(resolvedValOut);
myXml.WriteEndElement();
///
myXml.WriteStartElement("Наименование");
myXml.WriteString(resolvedValOut1);
myXml.WriteEndElement();
//\reference
myXml.WriteStartElement("references");
// ВЫГРУЖАЕМ ВЫБРАННЫЕ КОНФИГУРАЦИИ
dynamic CheckedRows = (from Rows in DataGridConfig.Rows.Cast <DataGridViewRow>() where Convert.ToBoolean(Rows.Cells[0].Value.ToString()) select Rows).ToList();
System.Text.StringBuilder sb2 = new System.Text.StringBuilder();
foreach (DataGridViewRow row in CheckedRows)
{
sb2.AppendLine(row.Cells[1].Value.ToString());
swmodel = swView.ReferencedDocument;
var configuration = swView.ReferencedConfiguration;
var sConfigName = swView.ReferencedConfiguration;
Configuration swConfig = swmodel.GetConfigurationByName(sConfigName);
for (var i = 0; i <= vConfName.GetUpperBound(0); i++)
{
const string ucase = "";
if (vConfName[i] == row.Cells[1].Value.ToString())
{
configuration = vConfName[i];
}
}
swView.ReferencedConfiguration = sConfigName;
myXml.WriteStartElement("config");
myXml.WriteAttributeString("value", row.Cells[1].Value.ToString());
/////////////////////////////////////////////////////////////
//
// PART
//
/////////////////////////////////////////////////////////////
for (lRow = lStartRow; lRow <= (lNumRow - 1); lRow++)
{
if (swBomTableAnnotation.GetComponentsCount2((int)lRow, row.Cells[1].Value.ToString(), out strItemNumber, out strPartNumber) > 0)
{
myXml.WriteStartElement("part");
//PathNameComponent
string strModelPathName = null;
var vModelPathNames = swBomTableAnnotation.GetModelPathNames((int)lRow, out strItemNumber, out strPartNumber);
if (((vModelPathNames != null)))
{
myXml.WriteStartElement("PathNameComponent");
foreach (var vModelPathName_loopVariable in vModelPathNames)
{
var vModelPathName = vModelPathName_loopVariable;
strModelPathName = vModelPathName;
myXml.WriteString(strModelPathName);
}
myXml.WriteEndElement();
}
//'\ Row
myXml.WriteStartElement("Row");
myXml.WriteString(Convert.ToString(lRow - lStartRow + 1));
myXml.WriteEndElement();
vModelPathNames = swBomTableAnnotation.GetModelPathNames((int)lRow, out strItemNumber, out strPartNumber);
//\ ItemNum
myXml.WriteStartElement("ItemNum");
myXml.WriteString(strItemNumber);
myXml.WriteEndElement();
//\ раздел
aa = 3;
/// раздел
sRowStr1 = "";
sRowStr1 = sRowStr1 + swTableAnnotation.Text[lRow, aa];
myXml.WriteStartElement("Раздел");
myXml.WriteString(sRowStr1);
myXml.WriteEndElement();
//\ обозначение
oo = 1;
/// обозначение
sRowStr2 = "";
sRowStr2 = sRowStr2 + swTableAnnotation.Text[lRow, oo];
myXml.WriteStartElement("Обозначение");
myXml.WriteString(sRowStr2);
myXml.WriteEndElement();
//\ наименование
Jj = 2;
/// наименование
sRowStr = "";
sRowStr = sRowStr + swTableAnnotation.Text[lRow, Jj];
myXml.WriteStartElement("Наименование");
myXml.WriteString(sRowStr);
myXml.WriteEndElement();
//\
tt = 4;
/// формат
sRowStr3 = "";
sRowStr3 = sRowStr3 + swTableAnnotation.Text[lRow, tt];
myXml.WriteStartElement("Формат");
myXml.WriteString(sRowStr3);
myXml.WriteEndElement();
//\
yy = 5;
/// ERP code
sRowStr4 = "";
sRowStr4 = sRowStr4 + swTableAnnotation.Text[lRow, yy];
myXml.WriteStartElement("ERP_code");
myXml.WriteString(sRowStr4);
myXml.WriteEndElement();
//\
uu = 6;
/// Код материала
sRowStr5 = "";
sRowStr5 = sRowStr5 + swTableAnnotation.Text[lRow, uu];
myXml.WriteStartElement("Код_материала");
myXml.WriteString(sRowStr5);
myXml.WriteEndElement();
//\
ss = 7;
/// наименование
sRowStr6 = "";
sRowStr6 = sRowStr6 + swTableAnnotation.Text[lRow, ss];
myXml.WriteStartElement("Примечание");
myXml.WriteString(sRowStr6);
myXml.WriteEndElement();
//\
myXml.WriteStartElement("Количество");
//myXml.WriteString(swTableAnnotation.GetComponentsCount2(lRow, strConfiguration, strItemNumber, strPartNumber))
myXml.WriteString(Convert.ToString(swBomTableAnnotation.GetComponentsCount2(lRow, row.Cells[1].Value.ToString(), out strItemNumber, out strPartNumber)));
myXml.WriteEndElement();
myXml.WriteEndElement();
//config
}
}
myXml.WriteEndElement(); //part
}
myXml.WriteEndElement(); //references
//<~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the Total Number of Rows
Annotation swAnn = default(Annotation);
TableAnnotation swTable = default(TableAnnotation);
long nNumRow = 0;
swmodel = swapp.ActiveDoc;
swView = swDraw.GetFirstView();
swTable = swView.GetFirstTableAnnotation();
swAnn = swTable.GetAnnotation();
nNumRow = swTable.RowCount;
myXml.WriteStartElement("TotalRows");
myXml.WriteString(Convert.ToString(nNumRow));
myXml.WriteEndElement();
//end TotalRows
myXml.WriteEndElement();
//Item
myXml.WriteEndElement();
//элемент XML
//End If
//заносим данные в myMemoryStream
myXml.Flush();
myXml.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
throw;
}
}