• 水晶报表


     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();


        }

  • 相关阅读:
    SQL Server 使用全文索引进行页面搜索
    基于TI Davinci架构的多核/双核开发高速扫盲(以OMAP L138为例),dm8168多核开发參考以及达芬奇系列资料user guide整理
    HBase 数据库检索性能优化策略
    在oracle存储过程中创建暂时表
    永和维护---从问题中得到的一些感受
    spring set注入
    为计算机教育改革而摇旗呐喊
    hdu5288 OO’s Sequence 二分 多校联合第一场
    HTML5贪吃蛇源代码
    软工初体验
  • 原文地址:https://www.cnblogs.com/tongdengquan/p/6090612.html
Copyright © 2020-2023  润新知