c# - 捕获数据表中的所有必需值。需要将此结果集传递给 ssis 包中的邮件任务

Question

捕获数据表中的所有必需值。

列和相应的值被添加到数据表中。**需要将datatable值传递给ssis包中的mail任务。

因为它是表格格式**请建议在邮件中的值将像这样在此处输入图像描述

        DataTable dt = new DataTable();
        DataRow row;
        DataColumn column;
        column = new DataColumn();
        dt.Columns.Add("Count_File_Date", typeof(String));
        dt.Columns.Add("Count_File_Name", typeof(String));
        dt.Columns.Add("Count_File_LMD", typeof(String));
        dt.Columns.Add("Switch_File_Name", typeof(String));
        dt.Columns.Add("Switch_File_Date", typeof(String));
        dt.Columns.Add("Data_File_Name", typeof(String));
        dt.Columns.Add("Data_File_LMD", typeof(String));
        var directories = Directory.GetDirectories(directory);

        foreach (string subdirectory in directories)
        {
            row = dt.NewRow();
            dt.Rows.Add(row);

            if (Directory.GetFiles(subdirectory, "*.count").Length == 0)
            {
                row["Count_File_Name"] = "Count File Not Found";

            }
            else
            {
                // Getting the values of count file
                DateTime Count_L_M_D;
                string Count_File_Name;
                string[] Count_filePath1 = Directory.GetFiles(subdirectory, "*.count");
                string Content = File.ReadAllText(@Count_filePath1[0]);
                string loadedDate = DateTime.ParseExact(Content.Substring(9, 8), "yyyyMMdd",
                                CultureInfo.InvariantCulture).ToString("yyyy/MM/dd");
                DateTime Datevalue = DateTime.Parse(loadedDate);
                Count_File_Name = Path.GetFileName(Count_filePath1[0]);
                Count_L_M_D = Directory.GetLastWriteTime(Count_filePath1[0]);
                row["Count_File_Date"] = Datevalue;
                row["Count_File_Name"] = Count_File_Name;
                row["Count_File_LMD"] = Count_L_M_D;
            }

            if (Directory.GetFiles(subdirectory, "*.switch").Length == 0)
            {
                row["Switch_File_Name"] = "Switch File Not Found";

            }
            else
            {
                string[] Switch_filePath = Directory.GetFiles(subdirectory, "*.switch");
                DateTime Switch_L_M_D;
                string S_File_Name;

                S_File_Name = Path.GetFileName(Switch_filePath[0]);
                Switch_L_M_D = Directory.GetLastWriteTime(Switch_filePath[0]);

                row["Switch_File_Name"] = S_File_Name;
                row["Switch_File_Date"] = Switch_L_M_D;
            }

}

标签： c#ssis