public virtual void Disconnect()
{
SocketUtils.Disconnect();
Logger.Debug("disconnecting");
_expectingDisconnection = true;
_bridgeComponent.dispose();
}
public override void Close()
{
Area.WindowSizeChanged -= Area_WindowSizeChanged;
Task.Factory.StartNew(() => {
try
{
if (presentation != null)
{
presentation.end();
}
if (component != null)
{
component.dispose();
}
if (desktop != null && desktop.getCurrentComponent() == null) // no component is running anymore
{
desktop.terminate();
}
}
catch (DisposedException)
{
// ignore
}
}).ContinueWith((t) =>
{
controller = null;
base.Close();
});
}
public static void ConvertToPdf(string inputFile, string outputFile)
{
if (ConvertExtensionToFilterType(Path.GetExtension(inputFile)) == null)
{
throw new InvalidProgramException("Unknown file type for OpenOffice. File = " + inputFile);
}
//StartOpenOffice();
//Get a ComponentContext
var xLocalContext = Bootstrap.bootstrap();
//Get MultiServiceFactory
XMultiServiceFactory xRemoteFactory = (XMultiServiceFactory)xLocalContext.getServiceManager();
//Get a CompontLoader
XComponentLoader aLoader = (XComponentLoader)xRemoteFactory.createInstance("com.sun.star.frame.Desktop");
//Load the sourcefile
XComponent xComponent = null;
try
{
xComponent = initDocument(aLoader, PathConverter(inputFile), "_blank");
//Wait for loading
while (xComponent == null)
{
System.Threading.Thread.Sleep(1000);
}
// save/export the document
saveDocument(xComponent, inputFile, PathConverter(outputFile));
}
catch { throw; }
finally { xComponent.dispose(); }
}
/** System.IDisposable impl
*/
public void Dispose()
{
if (null != m_xComponent)
{
m_xComponent.dispose();
}
}
private void storeDocument(XComponent document, String outputUrl, IDictionary storeProperties)
{
try
{
XStorable storable = (XStorable)document;
storable.storeToURL(outputUrl, ToPropertyValues(storeProperties));
}
finally
{
XCloseable closeable = (XCloseable)document;
if (closeable != null)
{
try
{
closeable.close(true);
}
catch (CloseVetoException closeVetoException)
{
Logger.Warn("document.close() vetoed:" + closeVetoException.Message);
}
}
else
{
document.dispose();
}
}
}
public void OpenODT(string inputFile)
{
StartOpenOffice();
//Get a ComponentContext
var xLocalContext =
Bootstrap.bootstrap();
//Get MultiServiceFactory
var xRemoteFactory =
(XMultiServiceFactory)
xLocalContext.getServiceManager();
//Get a CompontLoader
var aLoader =
(XComponentLoader)xRemoteFactory.createInstance("com.sun.star.frame.Desktop");
//Load the sourcefile
XComponent xComponent = null;
xComponent = InitDocument(aLoader,
PathConverter(inputFile), "_blank");
//Wait for loading
while (xComponent == null)
{
Thread.Sleep(1000);
}
ODTText = ((XTextDocument)xComponent).getText().getString();
if (xComponent != null)
{
xComponent.dispose();
}
}
/// <summary>
/// Try to close the document without any saving of modifications.
/// We can try it only! Controller and/or model of this document
/// can disagree with that. But mostly they doesn't do so.
/// </summary>
/// <param name="xDocument">document which should be clcosed</param>
public static void CloseDocument(XComponent xDocument)
{
try
{
// Check supported functionality of the document (model or controller).
XModel xModel = (XModel)xDocument;
if (xModel != null)
{
// It's a full featured office document.
// Reset the modify state of it and close it.
// Note: Model can disagree by throwing a veto exception.
XModifiable xModify = (XModifiable)xModel;
xModify.setModified(false);
xDocument.dispose();
}
else
{
// It's a document which supports a controller .. or may by a pure
// window only. If it's at least a controller - we can try to
// suspend him. But - he can disagree with that!
XController xController = (XController)xDocument;
if (xController != null)
{
if (xController.suspend(true))
{
// Note: Don't dispose the controller - destroy the frame
// to make it right!
XFrame xFrame = xController.getFrame();
xFrame.dispose();
}
}
}
}
catch (PropertyVetoException exVeto)
{
// Can be thrown by "setModified()" call on model.
// He disagree with our request.
// But there is nothing to do then. Following "dispose()" call wasn't
// never called (because we catch it before). Closing failed -that's it.
System.Diagnostics.Debug.WriteLine(exVeto);
}
catch (DisposedException exDisposed)
{
// If an UNO object was already disposed before - he throw this special
// runtime exception. Of course every UNO call must be look for that -
// but it's a question of error handling.
// For demonstration this exception is handled here.
System.Diagnostics.Debug.WriteLine(exDisposed);
}
catch (RuntimeException exRuntime)
{
// Every uno call can throw that.
// Do nothing - closing failed - that's it.
System.Diagnostics.Debug.WriteLine(exRuntime);
}
}
public string TestPDF()
{
var statuscode = "";
string inputFile = @"C:\ALISS_ProcessFile\GLASS\test.txt";
string outputFile = @"C:\ALISS_ProcessFile\GLASS\test.pdf";
if (ConvertExtensionToFilterType(Path.GetExtension(inputFile)) == null)
{
throw new InvalidProgramException("Unknown file type for OpenOffice. File = " + inputFile);
}
StartOpenOffice();
//Get a ComponentContext
var xLocalContext =
Bootstrap.bootstrap();
//Get MultiServiceFactory
var xRemoteFactory =
(XMultiServiceFactory)
xLocalContext.getServiceManager();
//Get a CompontLoader
var aLoader =
(XComponentLoader)xRemoteFactory.createInstance("com.sun.star.frame.Desktop");
//Load the sourcefile
XComponent xComponent = null;
try
{
xComponent = InitDocument(aLoader,
PathConverter(inputFile), "_blank");
//Wait for loading
while (xComponent == null)
{
Thread.Sleep(1000);
}
// save/export the document
SaveDocument(xComponent, inputFile, PathConverter(outputFile));
statuscode = "OK";
}
catch
{
statuscode = "Error";
}
finally
{
if (xComponent != null)
{
xComponent.dispose();
}
}
return("Gen PDF status : " + statuscode);
}
public static void ConvertToPdf(string inputFile, string outputFile)
{
if (GetFilterType(Path.GetExtension(inputFile)) == null)
{
throw new InvalidProgramException("Unknown file type for OpenOffice. File = " + inputFile);
}
XComponent xComponent = null;
try
{
Start();
//var xLocalContext = Bootstrap.defaultBootstrap_InitialComponentContext();
//var xLocalServiceManager = xLocalContext.getServiceManager();
//var xUrlResolver = (XUnoUrlResolver)xLocalServiceManager.createInstanceWithContext(
// "com.sun.star.bridge.UnoUrlResolver", xLocalContext);
var bootstrap = Bootstrap.defaultBootstrap_InitialComponentContext();
// ReSharper disable once SuspiciousTypeConversion.Global
var remoteFactory = (XMultiServiceFactory)bootstrap.getServiceManager();
var aLoader = (XComponentLoader)remoteFactory.createInstance("com.sun.star.frame.Desktop");
xComponent = InitDocument(aLoader, inputFile, "_blank");
//Wait for loading
//while (xComponent == null)
// Thread.Sleep(1000);
// save/export the document
SaveDocument(xComponent, inputFile, outputFile);
}
finally
{
xComponent?.dispose();
if (_libreOfficeProcess != null)
{
_libreOfficeProcess.Kill();
_libreOfficeProcess = null;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="inputStream"></param>
/// <param name="importOptions"></param>
/// <param name="outputStream"></param>
/// <param name="exportOptions"></param>
/// <remarks></remarks>
private void LoadAndExport(Stream inputStream, IDictionary importOptions, Stream outputStream, IDictionary exportOptions)
{
XComponentLoader desktop = OpenOfficeConnection.Desktop;
IDictionary loadProperties = new Hashtable();
SupportClass.MapSupport.PutAll(loadProperties, DefaultLoadProperties);
SupportClass.MapSupport.PutAll(loadProperties, importOptions);
// doesn't work using InputStreamToXInputStreamAdapter; probably because it's not XSeekable
//property("InputStream", new InputStreamToXInputStreamAdapter(inputStream))
loadProperties["InputStream"] = new Any(typeof(XInputStream), new XInputStreamWrapper(inputStream));
XComponent document = desktop.loadComponentFromURL("private:stream", "_blank", 0, ToPropertyValues(loadProperties));
if (document == null)
{
throw new OpenOfficeException("conversion failed: input document is null after loading");
}
RefreshDocument(document);
IDictionary storeProperties = new Hashtable();
SupportClass.MapSupport.PutAll(storeProperties, exportOptions);
storeProperties["OutputStream"] = new Any(typeof(XOutputStream), new XOutputStreamWrapper(outputStream));
try
{
XStorable storable = (XStorable)document;
storable.storeToURL("private:stream", ToPropertyValues(storeProperties));
}
finally
{
document.dispose();
}
}
private static void ConvertToPdf(string filePath)
{
Process[] ps = Process.GetProcessesByName("soffice.exe");
if (ps.Length != 0)
{
throw new InvalidProgramException("OpenOffice not found. Is OpenOffice installed?");
}
if (ps.Length > 0)
{
return;
}
Process p = new Process
{
StartInfo =
{
Arguments = "-headless -nofirststartwizard",
FileName = "soffice.exe",
CreateNoWindow = true
}
};
bool result = p.Start();
if (result == false)
{
throw new InvalidProgramException("OpenOffice failed to start.");
}
XComponentContext xLocalContext = Bootstrap.bootstrap();
XMultiServiceFactory xRemoteFactory = (XMultiServiceFactory)xLocalContext.getServiceManager();
XComponentLoader aLoader = (XComponentLoader)xRemoteFactory.createInstance("com.sun.star.frame.Desktop");
XComponent xComponent = null;
try
{
PropertyValue[] openProps = new PropertyValue[1];
openProps[0] = new PropertyValue {
Name = "Hidden", Value = new Any(true)
};
xComponent = aLoader.loadComponentFromURL(PathConverter(filePath), "_blank", 0, openProps);
while (xComponent == null)
{
Thread.Sleep(1000);
}
PropertyValue[] propertyValues = new PropertyValue[2];
propertyValues[1] = new PropertyValue {
Name = "Overwrite", Value = new Any(true)
};
propertyValues[0] = new PropertyValue {
Name = "FilterName", Value = new Any(ConvertExtensionToFilterType(Path.GetExtension(filePath)))
};
((XStorable)xComponent).storeToURL(PathConverter(OutputFolder + Path.GetFileNameWithoutExtension(filePath) + ".pdf"), propertyValues);
}
catch (System.Exception e)
{
log.Error("Eccezione la conversione del file OpenOffice " + filePath);
log.Error(e.StackTrace);
File.Move(filePath, ErrorFolder + Path.GetFileName(filePath));
}
finally
{
if (xComponent != null)
{
xComponent.dispose();
}
CloseProcess("soffice");
File.Delete(filePath);
}
}
static void Main(string[] args)
{
InitOpenOfficeEnvironment();
XMultiServiceFactory multiServiceFactory = Connect();
XComponent xComponent = null;
string docFileName = @"C:\test3.doc";
try
{
XComponentLoader componentLoader =
(XComponentLoader)multiServiceFactory
.createInstance("com.sun.star.frame.Desktop");
//set the property
PropertyValue[] propertyValue = new PropertyValue[1];
PropertyValue aProperty = new PropertyValue();
aProperty.Name = "Hidden";
aProperty.Value = new uno.Any(false);
propertyValue[0] = aProperty;
xComponent =
componentLoader
.loadComponentFromURL(PathConverter(docFileName),
"_blank", 0, propertyValue);
XTextDocument xTextDocument = ((XTextDocument)xComponent);
XEnumerationAccess xEnumerationAccess =
(XEnumerationAccess)xTextDocument.getText();
XEnumeration xParagraphEnumeration =
xEnumerationAccess.createEnumeration();
while (xParagraphEnumeration.hasMoreElements())
{
uno.Any element = xParagraphEnumeration.nextElement();
XServiceInfo xinfo = (XServiceInfo)element.Value;
if (xinfo.supportsService("com.sun.star.text.TextTable"))
{
Console.WriteLine("Found Table!");
XTextTable xTextTable = (XTextTable)element.Value;
String[] cellNames = xTextTable.getCellNames();
for (int i = 0; i < cellNames.Length; i++)
{
XCell xCell = xTextTable.getCellByName(cellNames[i]);
XText xTextCell = (XText)xCell;
String strText = xTextCell.getString();
Console.WriteLine(strText);
}
}
else
{
XTextContent xTextElement = (XTextContent)element.Value;
XEnumerationAccess xParaEnumerationAccess =
(XEnumerationAccess)xTextElement;
// create another enumeration to get all text portions of
//the paragraph
XEnumeration xTextPortionEnum =
xParaEnumerationAccess.createEnumeration();
//step 3 Through the Text portions Enumeration, get interface
//to each individual text portion
while (xTextPortionEnum.hasMoreElements())
{
XTextRange xTextPortion =
(XTextRange)xTextPortionEnum.nextElement().Value;
Console.Write(xTextPortion.getString());
}
}
}
}
catch (unoidl.com.sun.star.uno.Exception exp1)
{
Console.WriteLine(exp1.Message);
Console.WriteLine(exp1.StackTrace);
}
catch (System.Exception exp2)
{
Console.WriteLine(exp2.Message);
Console.WriteLine(exp2.StackTrace);
}
finally
{
xComponent.dispose();
xComponent = null;
}
Console.WriteLine("Done.");
Console.ReadLine();
}
public byte[] Convert(byte[] fileSource, string fileExtension, string extReq, AttachConversionMode mode)
{
logger.DebugFormat("Convert {0} to {1}", fileExtension, extReq);
string fileName = Path.GetTempFileName();
try
{
return(RetryingPolicyAction <byte[]>(() => {
File.WriteAllBytes(fileName + fileExtension, fileSource);
if (localContext == null)
{
localContext = uno.util.Bootstrap.bootstrap();
}
unoidl.com.sun.star.lang.XMultiServiceFactory multiServiceFactory = (unoidl.com.sun.star.lang.XMultiServiceFactory)localContext.getServiceManager();
XComponentLoader componentLoader = (XComponentLoader)multiServiceFactory.createInstance("com.sun.star.frame.Desktop");
PropertyValue[] propertyValue = new PropertyValue[2];
PropertyValue aProperty = new PropertyValue();
aProperty.Name = "Hidden";
aProperty.Value = new uno.Any(true);
propertyValue[0] = aProperty;
propertyValue[1] = new PropertyValue();
propertyValue[1].Name = "IsSkipEmptyPages";
propertyValue[1].Value = new uno.Any(true);
XComponent xComponent = null;
bool toConvert = false;
string fileConvertedName;
try
{
string fileToConvertName = PathConverter(fileName + fileExtension);
fileConvertedName = PathConverter(fileName + "." + extReq);
logger.DebugFormat("Url to comvert: {0} - {1}", fileToConvertName, fileConvertedName);
xComponent = componentLoader.loadComponentFromURL(
fileToConvertName,
"_blank",
0,
propertyValue
);
if (xComponent == null)
{
throw new DocumentNotConvertible_Exception();
}
logger.Debug("Verify if is to process...");
if (fileExtension.Contains("doc") && (UseRedirectMethod(xComponent)))
{
logger.Debug("No conversion to do...");
toConvert = true;
}
else
{
object xls = null;
if (xComponent is XSpreadsheetDocument)
{
xls = xComponent as XSpreadsheetDocument;
}
else if (xComponent is XTextDocument)
{
xls = xComponent as XTextDocument;
}
if (xls != null)
{
//Se i nomi degli sheets sono fra quelli non convertibili, usare il converter Office.
if (xls is XSpreadsheetDocument)
{
var sheetNames = (xls as XSpreadsheetDocument)
.getSheets()
.getElementNames()
.ToArray();
for (int i = 0; i < sheetNames.Length; i++)
{
sheetNames[i] = (sheetNames[i] ?? string.Empty).ToUpper();
}
var namesSet = (ConfigurationManager.AppSettings["RedirectSheetNames"] ?? string.Empty)
.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries)
.OrderByDescending(x => x.Length);
var founded = false;
foreach (var set in namesSet)
{
var names = set
.Split(new[] { "|" }, StringSplitOptions.RemoveEmptyEntries);
if (names.Length <= sheetNames.Length)
{
founded = true;
foreach (var n in names)
{
if (!sheetNames.Contains(n.ToUpper()))
{
founded = false;
break;
}
}
if (founded)
{
logger.Debug("No conversion to do...");
return null;
}
}
}
}
//var xls = xComponent as XSpreadsheetDocument;
var styles = (xls as XStyleFamiliesSupplier).getStyleFamilies();
var pageStyles = styles.getByName("PageStyles").Value as XNameContainer;
bool scaleToPages = false;
var configured = ConfigurationManager.AppSettings["ScaleToPages"];
try
{
if (!string.IsNullOrEmpty(configured))
{
var dummy = bool.Parse(configured);
scaleToPages = dummy;
}
}
catch { logger.ErrorFormat("Invalid value for configured parameter \"{0}\". Current value is \"{1}\".", "ScaleToPages", configured); }
var configValue = ConfigurationManager.AppSettings["StampaConforme.ForcePortrait"];
var forcePortrait = !string.IsNullOrEmpty(configValue) && configValue.Equals("true", StringComparison.InvariantCultureIgnoreCase);
logger.Info("StampaConforme.ForcePortrait: " + forcePortrait.ToString());
foreach (var nome in pageStyles.getElementNames())
{
var props = pageStyles.getByName(nome).Value as XPropertySet;
if (forcePortrait)
{
var isLandscape = (bool)props.getPropertyValue("IsLandscape").Value;
if (isLandscape)
{
var size = props.getPropertyValue("Size").Value as Size;
var w = size.Width;
size.Width = size.Height;
size.Height = w;
props.setPropertyValue("Size", new uno.Any(typeof(Size), size));
props.setPropertyValue("IsLandscape", new uno.Any(false));
}
}
if (scaleToPages && props.getPropertySetInfo().hasPropertyByName("ScaleToPages"))
{
props.setPropertyValue("ScaleToPages", new uno.Any((short)1));
}
}
}
PropertyValue[] saveProps = new PropertyValue[2];
saveProps[0] = new PropertyValue();
saveProps[0].Name = "FilterName";
saveProps[0].Value = new uno.Any("writer_pdf_Export");
saveProps[1] = new PropertyValue();
saveProps[1].Name = "IsSkipEmptyPages";
saveProps[1].Value = new uno.Any(true);
logger.Debug("loadComponentFromURL end.");
((XStorable)xComponent).storeToURL(fileConvertedName, saveProps);
}
}
catch (Exception ex)
{
logger.Error(ex);
throw;
}
finally
{
if (xComponent != null)
{
xComponent.dispose();
}
}
logger.DebugFormat("Conversione END - ToConvert: {0}", toConvert);
if (toConvert)
{
return null;
}
else
{
return File.ReadAllBytes(fileName + "." + extReq);
}
}));
}
catch (Exception ex)
{
logger.Error(ex);
throw;
}
finally
{
try
{
File.Delete(fileName + fileExtension);
File.Delete(fileName + extReq);
File.Delete(fileName);
}
catch { }
}
}
/// <summary>
/// Try to close the document without any saving of modifications.
/// We can try it only! Controller and/or model of this document
/// can disagree with that. But mostly they doesn't do so.
/// </summary>
/// <param name="xDocument">document which should be clcosed</param>
public static void CloseDocument(XComponent xDocument)
{
try
{
// Check supported functionality of the document (model or controller).
XModel xModel = (XModel)xDocument;
if (xModel != null)
{
// It's a full featured office document.
// Reset the modify state of it and close it.
// Note: Model can disagree by throwing a veto exception.
XModifiable xModify = (XModifiable)xModel;
xModify.setModified(false);
xDocument.dispose();
}
else
{
// It's a document which supports a controller .. or may by a pure
// window only. If it's at least a controller - we can try to
// suspend him. But - he can disagree with that!
XController xController = (XController)xDocument;
if (xController != null)
{
if (xController.suspend(true))
{
// Note: Don't dispose the controller - destroy the frame
// to make it right!
XFrame xFrame = xController.getFrame();
xFrame.dispose();
}
}
}
}
catch (PropertyVetoException exVeto)
{
// Can be thrown by "setModified()" call on model.
// He disagree with our request.
// But there is nothing to do then. Following "dispose()" call wasn't
// never called (because we catch it before). Closing failed -that's it.
System.Diagnostics.Debug.WriteLine(exVeto);
}
catch (DisposedException exDisposed)
{
// If an UNO object was already disposed before - he throw this special
// runtime exception. Of course every UNO call must be look for that -
// but it's a question of error handling.
// For demonstration this exception is handled here.
System.Diagnostics.Debug.WriteLine(exDisposed);
}
catch (RuntimeException exRuntime)
{
// Every uno call can throw that.
// Do nothing - closing failed - that's it.
System.Diagnostics.Debug.WriteLine(exRuntime);
}
}
public string PdfGenerator([FromBody] string[] lstfullpath)
{
var statuscode = "";
var strFullPath = string.Join("\\", lstfullpath);
var strReportPath = @"C:\ALISS_ProcessFile";
var query = new List <sp_GET_TCParameter_Result>();
query = db.sp_GET_TCParameter("RPT_PROCESS_PATH").ToList();
if (query.FirstOrDefault(x => x.prm_code_minor == "PATH") != null)
{
strReportPath = query.FirstOrDefault(x => x.prm_code_minor == "PATH").prm_value;
}
var inputFile = Path.Combine(strReportPath, strFullPath);
var outputFile = Path.Combine(strReportPath, strFullPath.Replace(Path.GetExtension(inputFile), ".pdf"));
//string outputFile = @"D:\TestDownload\pdf\test.pdf";
if (ConvertExtensionToFilterType(Path.GetExtension(inputFile)) == null)
{
throw new InvalidProgramException("Unknown file type for OpenOffice. File = " + inputFile);
}
StartOpenOffice();
//Get a ComponentContext
var xLocalContext =
Bootstrap.bootstrap();
//Get MultiServiceFactory
var xRemoteFactory =
(XMultiServiceFactory)
xLocalContext.getServiceManager();
//Get a CompontLoader
var aLoader =
(XComponentLoader)xRemoteFactory.createInstance("com.sun.star.frame.Desktop");
//Load the sourcefile
XComponent xComponent = null;
try
{
xComponent = InitDocument(aLoader,
PathConverter(inputFile), "_blank");
//Wait for loading
while (xComponent == null)
{
Thread.Sleep(1000);
}
// save/export the document
SaveDocument(xComponent, inputFile, PathConverter(outputFile));
statuscode = "OK";
}
finally
{
if (xComponent != null)
{
xComponent.dispose();
}
}
return(statuscode);
}
public void CozdSchetWriter(string push, int ID)
{
DB5 db = new DB5(kursach.Program.Pole.pole);
DB16 db2 = new DB16(kursach.Program.Pole.pole);
DB1 db1 = new DB1(kursach.Program.Pole.pole);
DB14 db14 = new DB14(kursach.Program.Pole.pole);
DB13 db13 = new DB13(kursach.Program.Pole.pole);
Mapping.DB17 db17 = new Mapping.DB17(kursach.Program.Pole.pole);
var ec = from n in db.JurnalRabot
where n.ID == Convert.ToInt32(ID)
select n;
int temp = 0;
foreach (var i in ec)
{
temp = i.IDZapisi;
}
var ec2 = from n in db2.Zapis
where n.ID == temp
select n;
var Firma = from n in db17.Firma
where n.ID == 1
select n;
string temp2 = "";
foreach (var i in ec2)
{
temp2 = i.Data;
}
unoidl.com.sun.star.uno.XComponentContext localContext = uno.util.Bootstrap.bootstrap();
unoidl.com.sun.star.lang.XMultiServiceFactory multiServiceFactory = (unoidl.com.sun.star.lang.XMultiServiceFactory)localContext.getServiceManager();
XComponentLoader componentLoader = (XComponentLoader)multiServiceFactory.createInstance("com.sun.star.frame.Desktop");
XComponent xComponent = componentLoader.loadComponentFromURL("private:factory/swriter", "_blank", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().setString("Счет №" + ID + Environment.NewLine);
unoidl.com.sun.star.text.XTextRange x = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().getEnd(); // в конец
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().insertString(x, "от " + temp2 + "г." + Environment.NewLine + Environment.NewLine + Environment.NewLine, true);
unoidl.com.sun.star.text.XTextRange xi = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().getEnd(); // в конец
foreach (var i in Firma)
{
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().insertString(xi, "ИНН " + i.INN + " КПП " + i.KPP + Environment.NewLine + "Получатель " + i.Name + " № Счета " + i.Schet + Environment.NewLine + "Банк получателя " + i.Bank + " № Счета банка " + i.SchetBank + Environment.NewLine, true);
}
DB11 db11 = new DB11(kursach.Program.Pole.pole);
var Raspisanie = from n in db11.Raspisanie
where n.ID == temp
select n;
foreach (var i in Raspisanie)
{
temp = i.IDVrach;
}
var Vrach = from n in db14.Vrach
where n.ID == temp
select n;
foreach (var i in Vrach)
{
temp2 = i.FIO;
}
unoidl.com.sun.star.text.XTextRange x2 = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().getEnd(); // в конец
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().insertString(x2, "Исполнитель: " + temp2 + Environment.NewLine, true);
foreach (var i in ec2)
{
temp = i.IDPacienta;
}
var ec3 = from n in db1.Pacient
where n.ID == temp
select n;
foreach (var i in ec3)
{
temp2 = i.FIO;
}
unoidl.com.sun.star.text.XTextRange x3 = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().getEnd(); // в конец
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().insertString(x3, "Заказчик: " + temp2 + Environment.NewLine + Environment.NewLine + Environment.NewLine, true);
//Таблица
XFrame frame = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getCurrentController().getFrame();
XDispatchHelper xDispatchHelper = (XDispatchHelper)multiServiceFactory.createInstance("com.sun.star.frame.DispatchHelper");
unoidl.com.sun.star.beans.PropertyValue[] tableArgs = new unoidl.com.sun.star.beans.PropertyValue[4];
tableArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
tableArgs[1] = new unoidl.com.sun.star.beans.PropertyValue();
tableArgs[2] = new unoidl.com.sun.star.beans.PropertyValue();
tableArgs[3] = new unoidl.com.sun.star.beans.PropertyValue();
tableArgs[0].Name = "TableName";
tableArgs[0].Value = new uno.Any("Акт");
tableArgs[1].Name = "Columns";
tableArgs[1].Value = new uno.Any(4);
tableArgs[2].Name = "Rows";
tableArgs[2].Value = new uno.Any(2);
tableArgs[3].Name = "Flags";
tableArgs[3].Value = new uno.Any(9);
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any("Наименование Услуги");
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertTable", "", 0, tableArgs);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs2 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any("Цена");
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs2);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs3 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any("Скидка");
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs3);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs4 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any("Итого");
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs4);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
foreach (var i in ec2)
{
temp = i.IDUslugi;
}
var ec5 = from n in db13.Uslugi
where n.ID == temp
select n;
foreach (var i in ec5)
{
temp2 = i.Name;
}
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs5 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any(temp2);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs5);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
foreach (var i in ec)
{
temp2 = i.Cena.ToString();
}
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs6 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any(temp2);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs6);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
foreach (var i in ec)
{
temp2 = i.Skidka.ToString();
}
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs7 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any(temp2);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs7);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
foreach (var i in ec)
{
temp2 = i.Itog.ToString();
}
unoidl.com.sun.star.beans.PropertyValue[] cellTextArgs8 =
new unoidl.com.sun.star.beans.PropertyValue[1];
cellTextArgs[0] = new unoidl.com.sun.star.beans.PropertyValue();
cellTextArgs[0].Name = "Text";
cellTextArgs[0].Value = new uno.Any(temp2);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs8);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:JumpToNextCell", "", 0, new unoidl.com.sun.star.beans.PropertyValue[0]);
xDispatchHelper.executeDispatch((XDispatchProvider)frame, ".uno:InsertText", "", 0, cellTextArgs);
unoidl.com.sun.star.text.XTextRange x4 = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().getEnd(); // в конец
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().insertString(x4, "Всего оказано услуг на сумму: " + temp2 + "рублей " + Environment.NewLine + Environment.NewLine + Environment.NewLine + Environment.NewLine, true);
string temp3 = "";
foreach (var i in Vrach)
{
temp2 = i.FIO;
}
foreach (var i in ec3)
{
temp3 = i.FIO;
}
unoidl.com.sun.star.text.XTextRange x5 = ((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().getEnd(); // в конец
foreach (var i in Firma)
{
((unoidl.com.sun.star.text.XTextDocument)xComponent).getText().insertString(x5, "Исполнитель:__________________ " + temp2 + Environment.NewLine + "Бухгалтер:__________________" + i.Buh, true);
}
((XStorable)xComponent).storeToURL(@"file:///" + push.Replace(@"\", "/"), new unoidl.com.sun.star.beans.PropertyValue[0]);
xComponent.dispose();
}
public static XControlContainer createDialog(XMultiComponentFactory xMultiComponentFactory, XComponentContext xContext,
int posX, int posY, int width, int height, string title
)
{
//dialog model
Object oDialogModel = xMultiComponentFactory.createInstanceWithContext(
"com.sun.star.awt.UnoControlDialogModel", xContext);
XPropertySet xPSetDialog = (XPropertySet)oDialogModel;
xPSetDialog.setPropertyValue("PositionX", Any.Get(posX));
xPSetDialog.setPropertyValue("PositionY", Any.Get(posY));
xPSetDialog.setPropertyValue("Width", Any.Get(width));
xPSetDialog.setPropertyValue("Height", Any.Get(height));
xPSetDialog.setPropertyValue("Title", Any.Get(title));
// get service manager from dialog model
XMultiServiceFactory MXMsfDialogModel = (XMultiServiceFactory)oDialogModel;
// dialog control model
Object oUnoDialog = xMultiComponentFactory.createInstanceWithContext(
"com.sun.star.awt.UnoControlDialog", xContext);
XControl MXDialogControl = (XControl)oUnoDialog;
XControlModel xControlModel = (XControlModel)oDialogModel;
MXDialogControl.setModel(xControlModel);
XToolkit xToolkit = (XToolkit)xMultiComponentFactory
.createInstanceWithContext("com.sun.star.awt.Toolkit",
xContext);
WindowDescriptor aDescriptor = new WindowDescriptor();
aDescriptor.Type = WindowClass.TOP;
aDescriptor.WindowServiceName = "";
aDescriptor.ParentIndex = -1;
aDescriptor.Parent = xToolkit.getDesktopWindow();
aDescriptor.Bounds = new Rectangle(100, 200, 300, 400);
aDescriptor.WindowAttributes = WindowAttribute.BORDER
| WindowAttribute.MOVEABLE | WindowAttribute.SIZEABLE
| WindowAttribute.CLOSEABLE;
XWindowPeer xPeer = xToolkit.createWindow(aDescriptor);
XWindow xWindow = (XWindow)xPeer;
xWindow.setVisible(false);
MXDialogControl.createPeer(xToolkit, xPeer);
// execute the dialog
XDialog xDialog = (XDialog)oUnoDialog;
xDialog.execute();
// dispose the dialog
XComponent xComponent = (XComponent)oUnoDialog;
xComponent.dispose();
return(oUnoDialog as XControlContainer);
}
public void Close()
{
doc.dispose();
doc = null;
}
/// <summary>
/// Converts the given <paramref name="inputFile" /> to PDF format and saves it as <paramref name="outputFile" />
/// </summary>
/// <param name="inputFile">The input file</param>
/// <param name="outputFile">The output file</param>
public void ConvertToPdf(string inputFile, string outputFile)
{
if (GetFilterType(Path.GetExtension(inputFile)) == null)
{
throw new InvalidProgramException("Unknown file type for OpenOffice. File = " + inputFile);
}
XComponent component = null;
try
{
var guid = Guid.NewGuid().ToString().Replace("-", string.Empty);
_userFolder = $"d:/{guid}";
_pipeName = guid;
//_pipeName = "keeshispipe";
//Directory.CreateDirectory(_userFolder);
Start();
var localContext = Bootstrap.defaultBootstrap_InitialComponentContext();
var localServiceManager = localContext.getServiceManager();
var urlResolver =
(XUnoUrlResolver)localServiceManager.createInstanceWithContext(
"com.sun.star.bridge.UnoUrlResolver", localContext);
XComponentContext remoteContext;
var i = 0;
while (true)
{
try
{
remoteContext =
(XComponentContext)urlResolver.resolve(
$"uno:pipe,name={_pipeName};urp;StarOffice.ComponentContext");
break;
}
catch (Exception exception)
{
if (i == 20 || !exception.Message.Contains("couldn't connect to pipe"))
{
throw;
}
Thread.Sleep(100);
i++;
}
}
// ReSharper disable once SuspiciousTypeConversion.Global
var remoteFactory = (XMultiServiceFactory)remoteContext.getServiceManager();
var componentLoader = (XComponentLoader)remoteFactory.createInstance("com.sun.star.frame.Desktop");
component = InitDocument(componentLoader, ConvertToUrl(inputFile), "_blank");
// Save/export the document
// http://herbertniemeyerblog.blogspot.com/2011/11/have-to-start-somewhere.html
// https://forum.openoffice.org/en/forum/viewtopic.php?t=73098
ExportToPdf(component, inputFile, outputFile);
CloseDocument(component);
}
finally
{
component?.dispose();
if (_libreOfficeProcess != null && !_libreOfficeProcess.HasExited)
{
_libreOfficeProcess.Kill();
while (!_libreOfficeProcess.HasExited)
{
Thread.Sleep(100);
}
_libreOfficeProcess = null;
}
try
{
if (!string.IsNullOrEmpty(_userFolder))
{
Directory.Delete(_userFolder, true);
}
}
catch
{
}
}
}