RDLC报表使用实例

【核心代码】

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using CGT_Model;

namespace CGT_Report_Demo
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

            this.reportViewer1.RefreshReport();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            CommandData itemObj = new CommandData();
         
            itemObj.ReportName = "中山一院住院费用分类明细表";
            itemObj.ChargeCycle = DateTime.Now.AddDays(-10).ToString("yyy-MM-dd")   " 至 "   DateTime.Now.ToString("yyy-MM-dd");
            itemObj.InPatientNo = "0030872190";
            itemObj.PatientName = "张山疯";
            itemObj.Departments = "风湿免疫科";
            itemObj.ReportDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            List<ItemData> list = new List<ItemData>();
            List<string> listTypeKey = new List<string>();
            List<string> listSubTypeKey = new List<string>();
            for (int i = 1; i < 100; i  )
            {
                if (!listTypeKey.Contains("第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品"))
                {
                    listTypeKey.Add("第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品");
                    ItemData item = new ItemData();
                    item.ItemType = "第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品";
                    item.ItemSubType = "";
                    item.ItemCode = "第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品";
                    item.ItemName = "";
                    item.ItemNum = 0;
                    item.ItemPrice = 0;
                    item.ItemTotleAmt = 0;
                    item.ItemUnit = "";
                    item.SelfPay = 0;
                    item.PublicPay = 0;
                    item.Remark = "";
                    item.ItemShow = false;
                    item.Index = i.ToString().PadLeft(4, '0');
                    list.Add(item);
                }
                if (!listSubTypeKey.Contains("第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品"   "第"   ((i % 5)   1)   "分项"))
                {
                    listSubTypeKey.Add("第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品"   "第"   ((i % 5)   1)   "分项");
                    if (((i % 5)   1) != 2 && ((i % 5)   1) != 2)
                    {
                        ItemData itemSub = new ItemData();
                        itemSub.ItemType = "第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品";
                        itemSub.ItemSubType = "第"   ((i % 5)   1)   "分项";
                        itemSub.ItemCode = "第"   ((i % 5)   1)   "分项";
                        itemSub.ItemName = "";
                        itemSub.ItemNum = 0;
                        itemSub.ItemPrice = 0;
                        itemSub.ItemTotleAmt = 0;
                        itemSub.ItemUnit = "";
                        itemSub.SelfPay = 0;
                        itemSub.PublicPay = 0;
                        itemSub.Remark = "";
                        itemSub.ItemShow = false;
                        itemSub.Index = "1"   i.ToString().PadLeft(3, '0');
                        list.Add(itemSub);
                    }
                }
                ItemData items = new ItemData();
                items.ItemType = "第"   ((i % 11)   1).ToString().PadLeft(2, '0')   "类药品";
                items.ItemSubType = "第"   ((i % 5)   1)   "分项";
                items.ItemCode = "20200511-"   i.ToString().PadLeft(3, '0');
                items.ItemName = items.ItemType   ""   i.ToString().PadLeft(3, '0')   "号";
                items.ItemNum = i;
                items.ItemPrice = decimal.Parse((((i % 8)   1) * 1.82).ToString());
                items.ItemTotleAmt = items.ItemNum * items.ItemPrice;
                items.ItemUnit = "盒";
                items.SelfPay = decimal.Parse((((i % 8)   1) * 1.82).ToString()) - decimal.Parse((((i % 7)   1) * 0.44).ToString());
                items.PublicPay = items.ItemTotleAmt - items.SelfPay;
                items.Remark = "";
                items.ItemShow = true;
                items.Index = "2"   i.ToString().PadLeft(3, '0');
                list.Add(items);
            }

            //直接显示报表
            reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local;
            reportViewer1.LocalReport.ReportPath = Environment.CurrentDirectory   "\\"   "CGT_Report_test.rdlc";
            reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("ItemData", list));
            reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("CommandData", new object[] { itemObj }));
            this.reportViewer1.RefreshReport();
        }
    }
}