Пример #1
0
        public static bool Print(Oid rootOID, ReportConfiguration reportConfig)
        {
            bool Rslt = false;

            //Create a Excel object and add the Template specified in ReportPath.
            object oExcel         = Excel.GetExcel(false);
            object oExcelTemplate = Excel.GetExcelTemplate(
                Excel.GetExcelWorkbooks(oExcel), reportConfig.ReportFilePath);

            //Get the XML query requests.
            string XmlReport = Excel.DataRequest(rootOID, oExcelTemplate);

            if (XmlReport.Length > 0)
            {
                //Execute the queries.
                XmlDocument xmlDoc = new XmlDocument();
                xmlDoc.LoadXml(XmlReport);
                XmlNode nodeRslt = PrintToXML.GetQueryXML(rootOID, xmlDoc.DocumentElement);
                Excel.DataProcessing(oExcelTemplate, nodeRslt.OuterXml);
                Excel.SetVisibleExcel(true, oExcel);
                Rslt = true;
            }

            return(Rslt);
        }
Пример #2
0
        public static bool Print(Oid rootOID, ReportConfiguration reportConfig, bool preview, int numCopies, string printerName, string fileName)
        {
            bool Rslt = false;

            //Create a Word object and add the Template specified in ReportPath.
            object oWord         = Word.GetWord(false);
            object oWordTemplate = Word.GetWordDocumentTemplate(
                Word.GetWordDocuments(oWord), reportConfig.ReportFilePath);

            //Get the XML query requests.
            string XmlReport = Word.DataRequest(rootOID, oWordTemplate);

            if (XmlReport.Length > 0)
            {
                try
                {
                    //Execute the queries.
                    XmlDocument xmlDoc = new XmlDocument();
                    xmlDoc.LoadXml(XmlReport);

                    XmlNode nodeRslt = PrintToXML.GetQueryXML(rootOID, xmlDoc.DocumentElement);
                    Word.DataProcessing(oWordTemplate, nodeRslt.OuterXml);

                    // Ask for extra information, Preview or not, number of copies ...

                    if (preview)
                    {
                        Word.SetVisibleWord(true, oWord);
                    }
                    else
                    {
                        // If filename has values, save the document else print it
                        if (fileName != "")
                        {
                            Word.SaveAs(oWordTemplate, fileName);
                            Word.Close(WordSaveOptions.wdDoNotSaveChanges, oWordTemplate);
                        }
                        else
                        {
                            // Print and close Word
                            Word.ActivePrinter(oWord, printerName);
                            Word.PrintOut(oWordTemplate, numCopies);
                            // Before closing the created document, it must be saved.
                            //  Save in the temp folder and delete it
                            string tempFileName = System.IO.Path.GetTempFileName();
                            Word.SaveAs(oWordTemplate, tempFileName);
                            Word.Close(WordSaveOptions.wdDoNotSaveChanges, oWordTemplate);
                            System.IO.File.Delete(tempFileName);
                        }
                        // Quit from Word
                        Word.Quit(WordSaveOptions.wdDoNotSaveChanges, oWord);
                    }
                }
                catch (Exception e)
                {
                    Word.Quit(WordSaveOptions.wdDoNotSaveChanges, oWord);
                    throw new Exception(e.Message, e);
                }
                Rslt = true;
            }
            return(Rslt);
        }