水晶报表的推与拉

最新推荐文章于 2024-02-29 18:23:11 发布

e_zhiwen

最新推荐文章于 2024-02-29 18:23:11 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： C Sharp 文章标签：报表 dataset object exception sql system

本文链接：https://blog.youkuaiyun.com/e_zhiwen/article/details/7886753

C Sharp 专栏收录该内容

51 篇文章

订阅专栏

本文介绍了一个水晶报表的应用实例，通过C#代码实现从数据库获取指定月份的数据，并填充到报表中进行展示。讨论了这种方式是否属于Push或Pull模式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在网上看了阿泰的贴子，关于水晶报表的推与拉：

http://topic.youkuaiyun.com/u/20090713/01/15a1a826-b3d9-45f9-9557-c278245176fa.html

下面有个我自己设置的水晶报表参照了下有点二不像不知道是什么模式的，找位高手给分柝下。

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 System.Data.SqlClient;


namespace BDTC_SysTem
{
    public partial class frmFinanceSumMonthDay : Form
    {
        public frmFinanceSumMonthDay()
        {
            InitializeComponent();
        }
        private DataSet ds = new DataSet();
        private void frmFinanceSumMonthDay_Load(object sender, EventArgs e)
        {
            GetSumMonth(DateTime.Today);
        }

        private void GetSumMonth(DateTime mydate)
        {
            //FillCombboxClass fillsum = new FillCombboxClass();
            string sql = "Select Createdate,prosumpack,prosumprice,prosumpaper,prosumfire,prosumpackprice,prosumbreakprice,prosumotherprice,(prosumprice+prosumpaper+prosumfire+prosumpackprice+prosumbreakprice+prosumotherprice) as sumall from summonthofstopackaging_view where year(createdate)="+mydate.Year+" and month(createdate)="+mydate.Month;
            //DataTable dt= fillsum.SelectContent(sql);
            //dataGridView1.DataSource = dt;

            SqlConnection cn = new SqlConnection(Properties.Settings.Default.bdtcConnectionString);
            
            try
            {
                cn.Open();
                SqlDataAdapter da = new SqlDataAdapter(sql, cn);
                da.Fill(ds, "SumMOnthofStoPackagingAll_view");
                dataGridView1.DataSource = ds.Tables["SumMOnthofStoPackagingAll_view"];

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                cn.Close();
            }            

        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            GetSumMonth(dateTimePicker1.Value);
        }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
            PrintFinanceSumMonth p = new PrintFinanceSumMonth();
            p.SetDataSource(ds);            
            PrintViewFrm pv = new PrintViewFrm();
            pv.SumFinanceMonth.ReportSource = p;
            pv.ShowDialog();
            
         }

    }
}

制作的报表