获取报告 Stream转string，利用字符串分割转换成DataTable

最新推荐文章于 2024-10-22 00:59:35 发布

smartsmile2012

最新推荐文章于 2024-10-22 00:59:35 发布

阅读量3.1k

点赞数

分类专栏： Asp.net & C#

Asp.net & C# 专栏收录该内容

219 篇文章

订阅专栏

本文介绍了一种使用Amazon MarketplaceWebService (MWS) 获取并解析报表的方法。通过C#实现了一个具体的功能，该功能创建内存流并利用此流请求指定报表。在成功获取报表后，文章展示了如何将报表内容转换为DataTable以便于进一步的数据处理和展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    protected void Button1_Click(object sender, EventArgs e)
    {
        MemoryStream stream = new MemoryStream();
        StreamReader reader = new StreamReader(stream);

        GetReportRequest request = new GetReportRequest();
        request.ReportId = "24537536063";
        request.Merchant = sellerId;
        request.MWSAuthToken = mwsAuthToken;
        request.Report = stream;
        ltMsg.Text = InvokeGetReport(request);

        string text = reader.ReadToEnd();
        stream.Dispose();
        stream.Close();
        reader.Dispose();
        reader.Close();


        DataTable dt = ConvertReport2DT(text);
        GridView1.DataSource = dt;
        GridView1.DataBind();

        //Response.Write(text);
    }

    public static string InvokeGetReport(GetReportRequest request)
    {
        StringBuilder builder = new StringBuilder();
        try
        {
            MarketplaceWebService.MarketplaceWebServiceConfig config = new MarketplaceWebServiceConfig();
            config.ServiceURL = serviceURL;
            MarketplaceWebService.MarketplaceWebService service = new MarketplaceWebServiceClient
                (accessKey, secretKey, appName, appVersion, config);

            GetReportResponse response = service.GetReport(request);

            builder.AppendFormat("Service Response");
            builder.AppendFormat("=============================================================================");

            builder.AppendFormat("        GetReportResponse");
            if (response.IsSetGetReportResult())
            {
                builder.AppendFormat("            GetReportResult");
                GetReportResult getReportResult = response.GetReportResult;
                if (getReportResult.IsSetContentMD5())
                {
                    builder.AppendFormat("                ContentMD5");
                    builder.AppendFormat("                    {0}", getReportResult.ContentMD5);
                }
            }
            if (response.IsSetResponseMetadata())
            {
                builder.AppendFormat("            ResponseMetadata");
                ResponseMetadata responseMetadata = response.ResponseMetadata;
                if (responseMetadata.IsSetRequestId())
                {
                    builder.AppendFormat("                RequestId");
                    builder.AppendFormat("                    {0}", responseMetadata.RequestId);
                }
            }

            builder.AppendFormat("            ResponseHeaderMetadata");
            builder.AppendFormat("                RequestId");
            builder.AppendFormat("                    " + response.ResponseHeaderMetadata.RequestId);
            builder.AppendFormat("                ResponseContext");
            builder.AppendFormat("                    " + response.ResponseHeaderMetadata.ResponseContext);
            builder.AppendFormat("                Timestamp");
            builder.AppendFormat("                    " + response.ResponseHeaderMetadata.Timestamp);

        }
        catch (MarketplaceWebServiceException ex)
        {
            builder.AppendFormat("Caught Exception: " + ex.Message);
            builder.AppendFormat("Response Status Code: " + ex.StatusCode);
            builder.AppendFormat("Error Code: " + ex.ErrorCode);
            builder.AppendFormat("Error Type: " + ex.ErrorType);
            builder.AppendFormat("Request ID: " + ex.RequestId);
            builder.AppendFormat("XML: " + ex.XML);
            builder.AppendFormat("ResponseHeaderMetadata: " + ex.ResponseHeaderMetadata);
        }
        return builder.ToString();
    }

    #region 报告字符串转换成DataTable
    /// <summary>
    /// 报告字符串转换成DataTable
    /// </summary>
    /// <param name="reportMsg">报告字符串</param>
    /// <returns></returns>
    public static DataTable ConvertReport2DT(string reportMsg)
    {
        DataTable dt = new DataTable();
        try
        {
            //\t       \r\n
            if (reportMsg.Contains("\r\n"))
            {
                string[] rows = reportMsg.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
                //第一行表头
                if (rows[0].Contains("\t")) //制表符
                {
                    string[] columns = rows[0].Split('\t');
                    for (int i = 0; i < columns.Length; i++)
                    {
                        if (!dt.Columns.Contains(columns[i]))
                        {
                            dt.Columns.Add(columns[i]);
                        }
                    }
                }
                //第二行开始数据
                for (int i = 1; i < rows.Length; i++)
                {
                    string[] datas = rows[i].Split('\t');
                    DataRow dr = dt.NewRow();
                    for (int j = 0; j < datas.Length; j++)
                    {
                        dr[j] = datas[j];
                    }
                    dt.Rows.Add(dr);
                    dr = null;
                }
            }
        }
        catch { }
        return dt;
    }
    #endregion