动态创建表并添加数据最后用reporting显示

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using BnbCRM.Models;
using BnbCRM.BLL;
using Microsoft.Reporting.WebForms;
using System.Collections.Generic;
public partial class commanReport_FinaceReport : System.Web.UI.Page
{
    int project_id = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        project_id = Convert.ToInt32(Request.QueryString["project_id"]);
        if (!IsPostBack)
        {
            this.txtCreatedt.Value = DateTime.Now.ToString("yyyy-MM-dd");
            this.txtCreatedto.Value = DateTime.Now.ToString("yyyy-MM-dd");
        }
        ReportViewer1.LocalReport.Refresh();

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
       
        DateTime cretd = Convert.ToDateTime(this.txtCreatedt.Value);
        DateTime endtd = Convert.ToDateTime(this.txtCreatedto.Value);

        DataTable DT = new DataTable();
        DT.Columns.Add("dt", typeof(DateTime));
        DT.Columns.Add("basic_orderid", typeof(string));
        DT.Columns.Add("id", typeof(int));
        DT.Columns.Add("fee_pay_mode", typeof(string));
        DT.Columns.Add("fee_sum", typeof(decimal));
        DT.Columns.Add("fee_fact_all", typeof(decimal));
        DT.Columns.Add("remark", typeof(string));
        DT.Columns.Add("quantity", typeof(int));
        DT.Columns.Add("pay_dt", typeof(string));
        DT.Columns.Add("pay_sum", typeof(decimal));
        DT.Columns.Add("AR",typeof(decimal));

        IList<tborder> orderlist = tborderManager.getOrderByProject_idAndShipping_dt(project_id, cretd, endtd);

        for (int i = 0; i < orderlist.Count; i++)
        {
            DataRow row = DT.NewRow();

            row["dt"] = orderlist[i].Shipping_dt;
            string basic_orderid= orderlist[i].Basic_orderid.ToString().Trim();
            int id= Convert.ToInt32(orderlist[i].Id);

          
          TbOrderDetail tod=tborderDetailManager.GetTbOrderDetailByOrder_Id(id);
          row["quantity"] = tod.Quantity;
         
            row["id"] = id;
            row["basic_orderid"] = basic_orderid;
            if (basic_orderid.Length > 0 && basic_orderid!="")
            {
                tbFinCompareTaobao tb = tbFinCompareTaobaoManager.getSomeBytaobaoId(basic_orderid);

                if (tb.Pay_dt == Convert.ToDateTime("0001-1-1 0:00:00"))
                {
                    row["pay_dt"] = "";
                }
                else
                {
                    row["pay_dt"] = tb.Pay_dt.ToString("yyyy/MM/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
                }
              
                row["pay_sum"]=tb.Fee_sum;
           
            }
            else
            {
                tbFinCompareCod cc = tbFinCompareCodManager.getSomeBytaobaoid(id);

              
               
                if (cc.Pay_dt==Convert.ToDateTime("0001-1-1 0:00:00"))
                {
                    row["pay_dt"] = "";
                }
                else
                {
                    row["pay_dt"] = cc.Pay_dt.ToString("yyyy/MM/dd", System.Globalization.DateTimeFormatInfo.InvariantInfo);
                }

                row["pay_sum"] = cc.Fee_sum;
             
            }
         
            row["fee_pay_mode"] = orderlist[i].Fee_pay_mode;
            row["fee_sum"] = orderlist[i].Fee_sum;
            row["fee_fact_all"] = orderlist[i].Fee_fact_all;
            row["remark"] = orderlist[i].Remark;
           
            DT.Rows.Add(row);

         
            ReportViewer1.LocalReport.ReportPath = @"commanReport/finaceReport.rdlc";

            ReportViewer1.LocalReport.DataSources.Clear();
            ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("CommanDateSet_tbOrder", DT));
            ReportViewer1.LocalReport.Refresh();

       
         

        }

     

     

      

       
    }

 

 
}