Пример #1
0
        public void OutputToWordDocument()
        {
            PFWordDocument wordDoc = null;
            DataSet        ds      = null;

            try
            {
                _msg.Length = 0;
                _msg.Append("OutputToWordDocument started ...\r\n");
                Program._messageLog.WriteLine(_msg.ToString());

                ds = new DataSet();
                ds.ReadXml(@"C:\Testfiles\C1Testing\BostonZipInfo.xml");
                ds.Tables[0].TableName = "RandomNames";

                wordDoc = new PFWordDocument(enWordOutputFormat.Word2007, @"c:\temp\WordRandomNamesBostonZip.docx", true);
                wordDoc.WriteDataToDocument(ds.Tables[0]);

                ds = new DataSet();
                ds.ReadXml(@"C:\Testfiles\C1Testing\RandomNames100Lines.xml");
                ds.Tables[0].TableName = "RandomNames";

                wordDoc = new PFWordDocument(enWordOutputFormat.Word2007, @"c:\temp\WordRandomNames.docx", true);
                wordDoc.WriteDataToDocument(ds.Tables[0]);

                ds = new DataSet();
                ds.ReadXml(@"C:\Testfiles\C1Testing\BostonZipInfo.xml");
                ds.Tables[0].TableName = "RandomNames";

                wordDoc = new PFWordDocument(enWordOutputFormat.Word2003, @"c:\temp\WordRandomNamesBostonZip.doc", true);
                wordDoc.WriteDataToDocument(ds.Tables[0]);

                ds = new DataSet();
                ds.ReadXml(@"C:\Testfiles\C1Testing\RandomNames100Lines.xml");
                ds.Tables[0].TableName = "RandomNames";

                wordDoc = new PFWordDocument(enWordOutputFormat.Word2003, @"c:\temp\WordRandomNames.doc", true);
                wordDoc.WriteDataToDocument(ds.Tables[0]);
            }
            catch (System.Exception ex)
            {
                _msg.Length = 0;
                _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
                Program._messageLog.WriteLine(_msg.ToString());
                AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog);
            }
            finally
            {
                _msg.Length = 0;
                _msg.Append("\r\n... OutputToWordDocument finished.");
                Program._messageLog.WriteLine(_msg.ToString());
            }
        }
Пример #2
0
        /// <summary>
        /// Writes data contained in ADO.NET DataTable object to path stored in OutputFileName property.
        /// </summary>
        /// <param name="dt">DataTable object containing data to be output.</param>
        /// <returns>True if output operation is successful. False if write fails.</returns>
        public bool WriteDataToOutput(DataTable dt)
        {
            bool           success = true;
            PFWordDocument docOut  = null;

            try
            {
                if (File.Exists(_outputFileName))
                {
                    if (_replaceExistingFile)
                    {
                        File.SetAttributes(_outputFileName, FileAttributes.Normal);
                        File.Delete(_outputFileName);
                    }
                    else
                    {
                        _msg.Length = 0;
                        _msg.Append("File exists and ReplaceExistingFile set to False. Write to Output has failed.");
                        throw new System.Exception(_msg.ToString());
                    }
                }

                enWordOutputFormat outputFormat = this.WordVersion == enWordVersion.Word2007 ? enWordOutputFormat.Word2007 : enWordOutputFormat.Word2003;
                docOut = new PFWordDocument(outputFormat, this.OutputFileName, this.ReplaceExistingFile);
                docOut.WriteDataToDocument(dt);
            }
            catch (System.Exception ex)
            {
                success     = false;
                _msg.Length = 0;
                _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex));
                throw new System.Exception(_msg.ToString());
            }
            finally
            {
                if (docOut != null)
                {
                    docOut = null;
                }
            }

            return(success);
        }