public int dzialajDlaProjektuLinkedDoc(string pr, string sql) { log("Projekt " + pr, "Info"); int ile = 0; using (MySql.Data.MySqlClient.MySqlConnection conn2 = new MySql.Data.MySqlClient.MySqlConnection()) using (MySqlCommand cmd2 = new MySqlCommand()) using (MySqlCommand cmd = new MySqlCommand()) { try { cmd.Connection = conn; cmd.CommandText = sql; string sciezkaDef = sciezkaDomyslna + pr + @"\LinkedDoc\"; string sciezkaDb; using (MySqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { if (EA_Connect(pr) == 0) { conn2.ConnectionString = "server=10.22.23.82;uid=eakzg;database=eakzg_schema;Pwd=a;port=3306"; conn2.Open(); cmd2.Connection = conn2; while (reader.Read()) { string objectID = reader["object_ID"].ToString(); string datWyrzyg = reader["dataWyrzygu"].ToString(); string sciezka = reader["sciezka"].ToString(); string plik = reader["plik"].ToString(); string objectGuid = reader["ea_guid"].ToString(); if (sciezka == String.Empty) { sciezka = sciezkaDef; } try { System.IO.Directory.CreateDirectory(sciezka); sciezkaDb = sciezka.Replace(@"\", @"\\"); //projektInterfejs.PutDiagramImageToFile(objectGuid, sciezka + objectID + ".png", 1); /* sql = " SELECT o.object_id,d.BinContent, o.Note FROM " + * "`" + schema + "`.t_object o " + * ", `" + schema + "`.t_document d " + * " WHERE o.Style LIKE '%MDoc=1%' and o.object_type='Object' and d.elementid=o.ea_guid and o.name='Skrot';"; */ EA.Element e = eaRepository.GetElementByGuid(objectGuid); string rtf = e.GetLinkedDocument(); string html = ConvertRtfToHtml(rtf); System.IO.StreamWriter file = new System.IO.StreamWriter(sciezka + objectID + ".html"); file.Write(html); file.Close(); System.IO.StreamWriter filertf = new System.IO.StreamWriter(sciezka + objectID + ".rtf"); filertf.Write(rtf); filertf.Close(); string updt = " INSERT INTO eakzg_schema.eakzg_wyrzyg_log (id,projekt,objectID,objectGUID,dataWyrzygu,sciezka,plik) " + "values (null,'" + pr + "','" + objectID + "','" + objectGuid + "', " + @"now(), '" + sciezkaDb + "','" + objectID + ".html') on duplicate key update " + @" dataWyrzygu=now(),sciezka='" + sciezkaDb + "',plik='" + objectID + ".html'"; cmd2.CommandText = updt; int numRowsUpdated = cmd2.ExecuteNonQuery(); ile++; } catch (Exception ex) { log("Blad IO msg: " + ex.Message, "Exc - dzialajDlaProjektu " + " TargetSite: " + ex.TargetSite.ToString()); } } } } } } catch (MySqlException ex) { log("Blad " + ex.Number + " msg: " + ex.Message, "Exc - dzialajDlaProjektu " + " TargetSite: " + ex.TargetSite.ToString()); } log("Projekt " + pr + "### Wygenerowano: " + ile + " diagramów", "Info"); } return(ile); }