水晶报表
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) 编辑 收藏 举报