コード例 #1
0
        public void TestLoadingFormatThenFile()
        {
            FixedWidthFormatFile formatFile = CreateFormatFile();

            string tempFileToCreate = Path.Combine(TestContext.CurrentContext.TestDirectory, "unitTestFixedWidthFile.txt");

            StreamWriter streamWriter = File.CreateText(tempFileToCreate);

            try
            {
                streamWriter.WriteLine("002644099999Akerman             Frank               FM 380512004040120090501");
                streamWriter.WriteLine("002705600000SHAW                LENA                LC 852251978100119941031");
                streamWriter.Flush();
                streamWriter.Close();

                DataTable dataTable = formatFile.GetDataTableFromFlatFile(new FileInfo(tempFileToCreate));
                Assert.AreEqual(dataTable.Rows.Count, 2);
                Assert.AreEqual("0026440", dataTable.Rows[0]["gmc"]);
                Assert.AreEqual("99999", dataTable.Rows[0]["gp_code"]);
                Assert.AreEqual("Akerman", dataTable.Rows[0]["surname"]);
                Assert.AreEqual("Frank", dataTable.Rows[0]["forename"]);
                Assert.AreEqual("FM", dataTable.Rows[0]["initials"]);
                Assert.AreEqual("38051", dataTable.Rows[0]["practice_code"]);
                Assert.AreEqual(new DateTime(2004, 4, 1), dataTable.Rows[0]["date_into_practice"]);
                Assert.AreEqual(new DateTime(2009, 5, 1), dataTable.Rows[0]["date_out_of_practice"]);
            }
            finally
            {
                File.Delete(tempFileToCreate);
            }
        }