水晶报表 model取数据赋值

最新推荐文章于 2020-11-22 16:02:15 发布

zhaohongx

最新推荐文章于 2020-11-22 16:02:15 发布

阅读量403

点赞数

分类专栏： .NET

本文链接：https://blog.csdn.net/zhaohongx/article/details/39892293

版权

.NET 专栏收录该内容

166 篇文章 0 订阅

订阅专栏

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="print_addjifen.aspx.cs" Inherits="print_addjifen" %>

<%@ Register assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" namespace="CrystalDecisions.Web" tagprefix="CR" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>

<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server"
AutoDataBind="true" EnableToolTips="False" HasCrystalLogo="False"
HasToggleGroupTreeButton="False" HasToggleParameterPanelButton="False"
Height="50px" PrintMode="ActiveX" SeparatePages="False" ShowAllPageIds="True"
ToolPanelView="None" ToolPanelWidth="200px" Width="350px" />

</div>
</form>
</body>
</html>

///

using System;

using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CrystalDecisions.CrystalReports.Engine;
using RYJL.Common;

public partial class print_addjifen : PageBase
{
ReportDocument doc = new ReportDocument();
RYJL.BLL.jifen_log jifen_logBLL = new RYJL.BLL.jifen_log();

protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
RYJL.Model.jifen_log jifen_logModel = new RYJL.Model.jifen_log();
jifen_logModel = jifen_logBLL.GetModel(int.Parse(id));
string TxtKaNumber = jifen_logModel.KaNumber;
string TxtJieShaoTaoXiNumber = jifen_logModel.TaoXiNumber;
string TxtUserName = jifen_logModel.UserName;
string ddlPhotoClassId = jifen_logModel.PhotoClassId.ToString();
string ddlJiFenId = jifen_logModel.JiFenId.ToString();
string Txt_xiaofei = jifen_logModel.XiaoFeiMoney.ToString();
string Txt_jifen = jifen_logModel.JiFen.ToString();

doc.Load(Server.MapPath("CrystalReport.rpt"));
TextObject KaNumber = (TextObject)doc.ReportDefinition.ReportObjects["KaNumber"];
TextObject Admin = (TextObject)doc.ReportDefinition.ReportObjects["Admin"];
TextObject JieShaoTaoXiNumber = (TextObject)doc.ReportDefinition.ReportObjects["JieShaoTaoXiNumber"];
TextObject TUserName = (TextObject)doc.ReportDefinition.ReportObjects["TUserName"];
TextObject DianName = (TextObject)doc.ReportDefinition.ReportObjects["DianName"];
TextObject ddlPhotoClassName = (TextObject)doc.ReportDefinition.ReportObjects["ddlPhotoClassName"];
TextObject ddlJiFenName = (TextObject)doc.ReportDefinition.ReportObjects["ddlJiFenName"];
TextObject xiaofei = (TextObject)doc.ReportDefinition.ReportObjects["xiaofei"];
TextObject jifen = (TextObject)doc.ReportDefinition.ReportObjects["jifen"];

KaNumber.Text = TxtKaNumber;
Admin.Text = Common.Instance.GetAdminName(AdminUid);
JieShaoTaoXiNumber.Text = TxtJieShaoTaoXiNumber;
TUserName.Text = TxtUserName;
DianName.Text = Common.Instance.GetDianName(DianId);
ddlPhotoClassName.Text = Common.Instance.GetPhotoClass(ddlPhotoClassId);
ddlJiFenName.Text = Common.Instance.GetJiFenClass(ddlJiFenId);
xiaofei.Text = "￥" + Txt_xiaofei + " 元";
jifen.Text = Txt_jifen + " 分";
this.CrystalReportViewer1.ReportSource = doc;

}
protected void Page_UnLoad(object sender, EventArgs e)
{
if (doc != null)//
{
doc.Dispose();//防止查看水晶报表时，在C:\WINDOWS\Temp下产生很多临时文件
}

}
}