水晶报表

 protected ReportDocument reportDocument1 = new ReportDocument();//用  protected ReportDocument reportDocument1,没有实例化 出错
    protected void Page_Load(object sender, EventArgs e)
    {
        string credit_id = Request.QueryString["credit_id"].ToString().Trim();
        Bll_Material_Buy_Credit bll_material_buy_credit = new Bll_Material_Buy_Credit();
        DataTable table_material_buy_credit = bll_material_buy_credit.Get_DataSet_Material_Buy_Credit_By_Credit_id(credit_id);
        DataColumn col = new DataColumn("material_name", typeof(string));
        table_material_buy_credit.Columns.Add(col);

        //通过ID查名称
        IList<Material_Info_Info> param_material_info = Bll_Get_Name_By_Id.All_Material_Info();
        IList<Service_Company_Info> param_service_company_info = Bll_Get_Name_By_Id.All_Service_Company();
        IList<Lis_Base_Data_Info> param_lis_base_data_info = Bll_Get_Name_By_Id.All_Lis_Base_Data();
        IList<Deptment_Info_Info> param_deptment_info = Bll_Get_Name_By_Id.All_Deptment_Info();

        for (int i = 0; i < table_material_buy_credit.Rows.Count; i++)
        {
            table_material_buy_credit.Rows[i]["material_name"] = Bll_Get_Name_By_Id.Get_Material_Info_Name_By_Id(table_material_buy_credit.Rows[i]["material_id"].ToString().Trim(), param_material_info);
           
            table_material_buy_credit.Rows[i]["deptment_id"] = Bll_Get_Name_By_Id.Get_Deptment_Info_Name_By_Id(table_material_buy_credit.Rows[i]["deptment_id"].ToString().Trim(), param_deptment_info);

            table_material_buy_credit.Rows[i]["pack"] = Bll_Get_Name_By_Id.Get_Lis_Base_Data_Name_By_Id(table_material_buy_credit.Rows[i]["pack"].ToString().Trim(), param_lis_base_data_info);

            table_material_buy_credit.Rows[i]["buy_date"] = table_material_buy_credit.Rows[i]["buy_date"].ToString();
           
        }
        string path = Server.MapPath("~//reports//report_material_buy_credit.rpt");
        reportDocument1.Load(path);
        reportDocument1.SetDataSource(table_material_buy_credit);
        this.CrystalReportViewer1.ReportSource = reportDocument1;
        CrystalReportViewer1.DataBind();


    }

posted on 2010-01-18 15:57  tongdengquan  阅读(89)  评论(0编辑  收藏  举报