public void run() { DbElement Outfit_Elements = MDB.CurrentMDB.GetFirstWorld(Aveva.Pdms.Database.DbType.Design); DbElementType[] dbtype = new DbElementType[] { DbElementTypeInstance.PIPE }; TypeFilter filter = new TypeFilter(dbtype); AndFilter finalfilter = new AndFilter(); AttributeStringFilter filter2 = new AttributeStringFilter(DbAttribute.GetDbAttribute("Name"), FilterOperator.Equals, "/babo"); finalfilter.Add(filter); finalfilter.Add(filter2); DBElementCollection spwl_collects = new DBElementCollection(Outfit_Elements, finalfilter); Console.WriteLine("스펙월드갯수:" + spwl_collects.Cast <DbElement>().Count()); int speccnt = 0; List <DbElement> working_dbelement = new List <DbElement>(); foreach (DbElement element in spwl_collects) { //element.Delete(); DbCopyOption dd = new DbCopyOption(); //dd.ToName="/bbboa"; //DbElement de= element.CreateCopyHierarchyAfter(CurrentElement.Element, dd); //de.InsertBefore(CurrentElement.Element); DbElement xx = DbElement.GetElement("/xx1"); CurrentElement.Element.InsertAfterLast(xx); //de.InsertAfterLast(element.Owner); ////Console.WriteLine("스펙월드]" + spwl.GetAsString(DbAttributeInstance.NAME)); //foreach (DbElement spec in spwl.Members()) //{ // //spec.CreateLast(DbElementType.GetElementType("Sele")); // string specname = spec.GetAsString(DbAttributeInstance.NAME); // if (specname.Substring(1, 2) == "/*") // continue; // working_dbelement.Add(spec); // speccnt++; // //Console.WriteLine(" -->스펙]"+spec.GetAsString(DbAttributeInstance.NAME)); //} } //MDB.CurrentMDB.GetWork(); }
private void btnModelInsert_Click(object sender, EventArgs e) { //Drawlist 정의하고 추가하는 부분 var drawListManager = DrawListManager.Instance; var currentCursor = Cursor.Current; Cursor.Current = Cursors.WaitCursor; drawListManager.BeginUpdate(); var currentDrawList = drawListManager.CurrentDrawList; DbElement Outfit_Elements = MDB.CurrentMDB.GetFirstWorld(Aveva.Pdms.Database.DbType.Design); DbElementType[] dbtypes = new DbElementType[] { DbElementTypeInstance.PIPE }; if (checkPipe.Checked) { dbtypes = new DbElementType[] { DbElementTypeInstance.PIPE }; DBElementCollection pipe_collection = Get_Element_Collection(Outfit_Elements, dbtypes, txt_pipe_name.Text, txt_pipe_module.Text); currentDrawList.Add(pipe_collection.Cast <DbElement>().ToArray()); } if (checkStru.Checked) { dbtypes = new DbElementType[] { DbElementTypeInstance.STRUCTURE }; DBElementCollection stru_collection = Get_Element_Collection(Outfit_Elements, dbtypes, txt_stru_name.Text, txt_stru_module.Text); currentDrawList.Add(stru_collection.Cast <DbElement>().ToArray()); } if (checkEquip.Checked) { dbtypes = new DbElementType[] { DbElementTypeInstance.EQUIPMENT }; DBElementCollection equip_collection = Get_Element_Collection(Outfit_Elements, dbtypes, txt_equip_name.Text, txt_equip_module.Text); currentDrawList.Add(equip_collection.Cast <DbElement>().ToArray()); } drawListManager.EndUpdate(); currentDrawList.VisibleAll(); Cursor.Current = currentCursor; }
private void Search_Element(string findstr, bool replace_mode) { findindex = 0; string searchname = "*" + findstr + "*"; string replacestr = txtreplace.Text; //트리에서 Element Type을 선택할수 있게 함. List <DbElementType> dbtype_list = new List <DbElementType>(); foreach (TreeNode firstnode in tree_type.Nodes) { if (firstnode.Checked) { dbtype_list.Add((DbElementType)firstnode.Tag); } foreach (TreeNode secondnode in firstnode.Nodes) { if (secondnode.Checked) { dbtype_list.Add((DbElementType)secondnode.Tag); } foreach (TreeNode thirdnode in secondnode.Nodes) { if (thirdnode.Checked) { dbtype_list.Add((DbElementType)thirdnode.Tag); } foreach (TreeNode forthnode in thirdnode.Nodes) { if (forthnode.Checked) { dbtype_list.Add((DbElementType)forthnode.Tag); } } } } } dbtypes = dbtype_list.ToArray(); if (radio_3dview.Checked) { DrawList drawlist = DrawListManager.Instance.CurrentDrawList; DrawListMember[] drawlistmems = drawlist.Members(); DrawListMember [] FindDrawElements = drawlistmems.Cast <DrawListMember>() .Where(item => item.DbElement.GetAsString(DbAttributeInstance.NAMN).Contains(txt_search.Text) && dbtypes.Contains(item.DbElement.GetElementType())) .ToArray(); FindElements = FindDrawElements.Select(x => x.DbElement).ToArray(); //Highlight시 색은 General Colours에서 Visible의 색을 따라감. drawlist.Highlight(FindElements); foreach (DbElement item in FindElements) { string type = item.GetAsString(DbAttributeInstance.TYPE); string pos = ""; if (type == "BRAN") { pos = item.GetAsString(DbAttributeInstance.HPOS); } else { pos = item.GetAsString(DbAttributeInstance.POS); } string name = item.GetAsString(DbAttributeInstance.NAMN); Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("AID TEXT number 9898 |{0}| at {1}", name, pos)).RunInPdms(); } } else { //Root가 CE일때 if (radio_ce.Checked) { root = CurrentElement.Element; } else if (radio_entire.Checked) { if (ServiceManager.Instance.ApplicationName == "Outfitting") { root = MDB.CurrentMDB.GetFirstWorld(Aveva.Pdms.Database.DbType.Design); } if (ServiceManager.Instance.ApplicationName == "Paragon") { root = MDB.CurrentMDB.GetFirstWorld(Aveva.Pdms.Database.DbType.Catalogue); } if (ServiceManager.Instance.ApplicationName == "MarineDrafting") { root = MDB.CurrentMDB.GetFirstWorld(Aveva.Pdms.Database.DbType.Draft); } } TypeFilter typefilter = new TypeFilter(dbtypes); AndFilter finalfilter = new AndFilter(); AttributeLikeFilter xfilter = new AttributeLikeFilter(DbAttributeInstance.NAMN, searchname); finalfilter.Add(typefilter); finalfilter.Add(xfilter); result = new DBElementCollection(root, finalfilter); FindElements = result.Cast <DbElement>().ToArray(); } //Item 들이 가지고 속해있는 DB리스트생성 List <Db> dblist = new List <Db>(); foreach (DbElement item in FindElements) { if (!dblist.Contains(item.Db)) { dblist.Add(item.Db); } } //Partial Getwork수행 MDB.CurrentMDB.GetWork(dblist.ToArray()); int replace_count = 0; if (replace_mode == true) { foreach (DbElement item in FindElements) { try { //listView_searchresult.Items.Add(new ListViewItem(new string[]{"1","2","3","4"})); string element_name = item.GetAsString(DbAttributeInstance.NAME); string name = element_name.Replace(findstr, replacestr); DbElement exsititem = DbElement.GetElement(name); if (!exsititem.IsNull) { MessageBox.Show(string.Format("바꿀려는 이름 {0}은 존재하므로 바꿀수 없습니다.", name)); return; continue; } item.SetAttribute(DbAttributeInstance.NAME, name); replace_count++; mDesExpCtrl.RefreshNodes(item); } catch (Exception ee) { Console.WriteLine(item.ToString()); Console.WriteLine("오류발생"); } } //Tree View 업데이트 부분 아래 구문이 없으면 화면이 업데이트 안됨. try { var windows = Aveva.ApplicationFramework.Presentation.WindowManager.Instance.Windows.OfType <Presentation.DockedWindow>().Where(x => x.Key == "DesignExplorer").ToArray(); if (windows.Count() > 0) { MessageBox.Show(replace_count + "개 항목의 이름 바꾸기 완료!"); } } catch (Exception ee) { } } else { if (!radio_3dview.Checked) { if (FindElements.Count() != 0) { string refno = FindElements[0].GetAsString(DbAttributeInstance.REF); Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(refno).RunInPdms(); } } int idx = 1; //listView_searchresult.ColumnClick -= listView_searchresult_ColumnClick; listView_searchresult.Items.Clear(); foreach (DbElement item in FindElements) { string elementname = item.GetAsString(DbAttributeInstance.FLNN); string elementtype = item.GetAsString(DbAttributeInstance.TYPE); string marptype = "0"; if (elementtype == "SHEE") { marptype = item.GetAsString(DbAttributeInstance.MARPTY); } bool lclm = item.GetBool(DbAttributeInstance.LCLM); string userclaim = item.GetAsString(DbAttributeInstance.USERC); string islock = "X"; if (lclm == true) { islock = "X"; } else { if (userclaim == "unset") { islock = "X"; } else { islock = "O"; } } listView_searchresult.Items.Add(new ListViewItem(new string[] { idx.ToString(), elementname, elementtype, islock, marptype })); idx++; } //listView_searchresult.ColumnClick += listView_searchresult_ColumnClick; lbl_result.Text = "검색결과 : " + FindElements.Count().ToString() + " 건"; } }
private void CreateSpecification(string connstr, string query, string dept) { OdbcConnection conn = new OdbcConnection(connstr); OdbcCommand cmd = new OdbcCommand(query, conn); DataTable dt = new DataTable(); OdbcDataAdapter da = new OdbcDataAdapter(cmd); da.Fill(dt); string comp_ref_query = "select * from STD_PDST_COMP_REF_AM"; cmd.CommandText = comp_ref_query; DataTable comp_ref_dt = new DataTable(); da.SelectCommand = cmd; da.Fill(comp_ref_dt); DbElement Outfit_Elements = MDB.CurrentMDB.GetFirstWorld(Aveva.Pdms.Database.DbType.Catalogue); DbElementType[] dbtype = new DbElementType[] { DbElementTypeInstance.SPWLD }; TypeFilter filter = new TypeFilter(dbtype); AndFilter finalfilter = new AndFilter(); AttributeStringFilter filter2 = new AttributeStringFilter(DbAttribute.GetDbAttribute("Description"), FilterOperator.Equals, "HMD_PIPE_SPEC"); finalfilter.Add(filter); finalfilter.Add(filter2); DBElementCollection spwl_collects = new DBElementCollection(Outfit_Elements, finalfilter); Console.WriteLine("스펙갯수:" + spwl_collects.Cast <DbElement>().Count()); //dt.Rows.OfType<DataRow>().Where(x => x[1].ToString() == "WB").Count(); //dt.Rows.OfType<DataRow>().GroupBy(x=>x[11].ToString()) //var xx =spwl_collects.Cast<DbElement>().Where(x => x.GetAsString(DbAttributeInstance.NAME).Substring(0, 2) == "AA"); int speccnt = 0; List <DbElement> working_dbelement = new List <DbElement>(); var system_analysis = dt.Rows.OfType <DataRow>().GroupBy(x => x["LINE_NO"], x => x["NOM_DIA"], (lineno, nomdia) => new { lineno, nomdia }).OrderBy(x => x.lineno.ToString()); int cnt = 0; foreach (var lineno in system_analysis) { cnt++; //if (cnt == 3) // break; //스펙생성부분 //DbElement spec_element = DbElement.GetElement("/PROJ_SPWL").CreateAfter(DbElementTypeInstance.SPECIFICATION); string specname = dept + "." + lineno.lineno.ToString().Replace(' ', '.'); DbElement spec_element = null; if (DbElement.GetElement("/" + specname).IsNull) { spec_element = DbElement.GetElement("/PROJ_SPWL").CreateLast(DbElementTypeInstance.SPECIFICATION); spec_element.SetAttribute(DbAttributeInstance.NAME, "/" + specname); spec_element.SetAttribute(DbAttributeInstance.QUES, "TYPE"); spec_element.SetAttribute(DbAttributeInstance.PURP, "PIPE"); spec_element.SetAttribute(DbAttributeInstance.DESC, "PROJ.SPEC"); } try { //SPEC TEXT 추가 DbElement spectext_element = spec_element.CreateLast(DbElementTypeInstance.TEXT); spectext_element.SetAttribute(DbAttributeInstance.NAME, "/" + specname + "." + "PIPINGTEXT"); spectext_element.SetAttribute(DbAttributeInstance.STEX, "PIPING"); spectext_element.SetAttribute(DbAttributeInstance.RTEX, "PIPING"); } catch (Exception ee) { } try { foreach (var nomdia in lineno.nomdia) { //Aveva.Pdms.Utilities.Messaging.PdmsException. Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("$p |size: {0} |", nomdia.ToString())).RunInPdms(); DataRow[] targetrow = dt.Rows.OfType <DataRow>().Where(row => row["LINE_NO"].ToString() == lineno.lineno.ToString() && row["NOM_DIA"].ToString() == nomdia.ToString()).ToArray(); string press = targetrow[0]["PRESS"].ToString(); string temp = targetrow[0]["TEMP"].ToString(); string matlspec = targetrow[0]["MATL_SPEC"].ToString(); string connspec = targetrow[0]["PIPE_C_TYPE"].ToString() + "/" + targetrow[0]["PIPE_C_STD"].ToString() + "/" + targetrow[0]["PIPE_C_MATL"].ToString(); connspec = connspec.Replace("\n", ""); string valvespec = targetrow[0]["VALVE_C_TYPE"].ToString(); DataRow[] matl_datarow = comp_ref_dt.Rows.Cast <DataRow>().Where(row => row[0].ToString() == matlspec).ToArray(); DataRow[] conn_datarow = comp_ref_dt.Rows.Cast <DataRow>().Where(row => row[0].ToString() == connspec).ToArray(); DataRow[] valve_datarow = comp_ref_dt.Rows.Cast <DataRow>().Where(row => row[0].ToString() == valvespec).ToArray(); List <int> diameters = get_dias(nomdia.ToString()); //Material Spec생성 if (matl_datarow.Count() == 0) { //Aveva.Pdms.Utilities.CommandLine.Command.OutputAndClearError(); Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("$p |{0} material ref 없음|", matlspec)).RunInPdms(); } else { //Aveva.Pdms.Utilities.CommandLine.Command.OutputAndClearError(); DbElement material_spec = DbElement.GetElement(matl_datarow[0][1].ToString()); string[] allowtype = new string[] { "ELBO" };// foreach (DbElement element in material_spec.Members()) { if (element.GetElementType().ToString() != "TEXT") { //if (!allowtype.Contains(element.GetAsString(DbAttributeInstance.TANS))) // continue; //Aveva.Pdms.Utilities.CommandLine.Command.OutputAndClearError(); reculsive_copy_spec(spec_element, element, specname, diameters); } } } //Conn spec 생성 if (conn_datarow.Count() == 0) { Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("$p |{0} conn ref 없음|", connspec)).RunInPdms(); } else { //Gasket 생성 DbElement gask_spec = null; if (connspec.Contains("5K")) { gask_spec = DbElement.GetElement("/POGASASF05/HMDP_SPEC"); } else if (connspec.Contains("10K")) { gask_spec = DbElement.GetElement("/POGASASF10/HMDP_SPEC"); } else if (connspec.Contains("16K")) { gask_spec = DbElement.GetElement("/POGASASF16/HMDP_SPEC"); } else if (connspec.Contains("20K")) { gask_spec = DbElement.GetElement("/POGASASF20/HMDP_SPEC"); } else if (connspec.Contains("30K")) { gask_spec = DbElement.GetElement("/POGASASF30/HMDP_SPEC"); } foreach (DbElement element in gask_spec.Members()) { reculsive_copy_spec(spec_element, element, specname, diameters); } //Flange Spec DbElement conn_spec = DbElement.GetElement(conn_datarow[0][1].ToString()); foreach (DbElement element in conn_spec.Members()) { reculsive_copy_spec(spec_element, element, specname, diameters); } } //Valve Spec생성 if (valve_datarow.Count() == 0) { Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("$p |{0} valve ref 없음|", valvespec).Replace("\n", "")).RunInPdms(); } else { DbElement valve_spec = DbElement.GetElement(valve_datarow[0][1].ToString()); foreach (DbElement element in valve_spec.Members()) { reculsive_copy_spec(spec_element, element, specname, diameters); } } //DbElement conn_spec = DbElement.GetElement("/PFSF30/HMDP_SPEC"); //DbElement valve_spec = DbElement.GetElement("/PVVVV10/HMDP_SPEC"); //Select 생성 } } catch (Exception ee) { Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("$p |{0} 오륭", "11")).RunInPdms(); Console.WriteLine("오류:" + ee.Message); } //break; } Aveva.Pdms.Utilities.CommandLine.Command.CreateCommand(string.Format("$p |뻥뻥2|")).RunInPdms(); //MDB.CurrentMDB.SaveWork("스펙생성"); //CurrentElement.Element.Copy(DbElement.GetElement("/ACCOM.(DF)")); //DbElement de = CurrentElement.Element.Clone(); //지정된 Element 뒤에 object생성하는 부분 //DbElement xx= CurrentElement.Element.CreateAfter(DbElementTypeInstance.SPECIFICATION); //xx.SetAttribute(DbAttributeInstance.NAME, "/바보야4"); //새로운 Element를 만들고 다른object의 하위구조를 모두 복사하는 부분. //DbElement xx = CurrentElement.Element.CreateAfter(DbElementTypeInstance.SPECIFICATION); //DbCopyOption op=new DbCopyOption(); //op.ToName="vvd"; ////DbElement yy= DbElement.GetElement("/ALDJSAFKL"); //xx.CopyHierarchy(DbElement.GetElement("/ALDJSAFKL"),op); //DbCopyOption op = new DbCopyOption(); // ALDJSAFKL을 복사하는데 /xxx 다음에 만들어서 복사한다. //DbElement yy= DbElement.GetElement("/ALDJSAFKL").CreateCopyHierarchyAfter(DbElement.GetElement("/xxx"), op); //테스트가 필요하네요 //삭제 //DbElement.GetElement("/xxx").Delete(); //Rename //DbElement.GetElement("/보바").SetAttribute(DbAttributeInstance.NAME, "/보바1"); //CurrentElement.Element.Copy(DbElement.GetElement("/보바1")); //MDB.CurrentMDB.SaveWork("여기는 테스트1"); // //foreach (DbElement element in spwl_collects) //{ // //element.Delete(); // DbCopyOption dd= new DbCopyOption(); // //dd.ToName="/bbboa"; // //DbElement de= element.CreateCopyHierarchyAfter(CurrentElement.Element, dd); // //de.InsertBefore(CurrentElement.Element); // //DbElement xx=DbElement.GetElement("/ACCOM.(DF)"); // CurrentElement.Element.InsertAfterLast(xx); // //de.InsertAfterLast(element.Owner); // ////Console.WriteLine("스펙월드]" + spwl.GetAsString(DbAttributeInstance.NAME)); // //foreach (DbElement spec in spwl.Members()) // //{ // // //spec.CreateLast(DbElementType.GetElementType("Sele")); // // string specname = spec.GetAsString(DbAttributeInstance.NAME); // // if (specname.Substring(1, 2) == "/*") // // continue; // // working_dbelement.Add(spec); // // speccnt++; // // //Console.WriteLine(" -->스펙]"+spec.GetAsString(DbAttributeInstance.NAME)); // //} //} //MDB.CurrentMDB.GetWork(); }