水晶报表打印

最新推荐文章于 2013-01-06 16:57:01 发布

飞翔ing

最新推荐文章于 2013-01-06 16:57:01 发布

阅读量597

点赞数

分类专栏： C#—WinForm

本文链接：https://blog.csdn.net/Yanweijie1/article/details/8473394

版权

C#—WinForm 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

水晶报表打印

    #region 尾箱打印

    //系统自带声音SystemSounds.Hand.Play();
    //App.config中配置声音路径
    //<appSettings>
    //<add key="MusicError"    value="C:\Windows\Error.wav"/>
    //</appSettings>

    string MusicError = Convert.ToString(ConfigurationSettings.AppSettings["MusicError"]);
    System.Media.SoundPlayer sp = new System.Media.SoundPlayer();
    sp.SoundLocation = MusicError;
    sp.Play();

    string sql = "select * from Smpackage inner join SmpackageLine on Smpackage.uuid = SmpackageLine.master where Smpackage.uuid = " + "'" + uuidsa + "'";
    DataSet ds = new DataSet();
    SqlConnection conn = new SqlConnection(connStr);
    SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
    ada.Fill(ds);
    CrystalReport5 rpt = new CrystalReport5();
    //打印带预览
    //rpt.SetDataSource(ds.Tables[0]);
    //Print view = new Print();
    //conn.Close();
    //ada.Dispose();
    //ds.Dispose();
    //ds.Clear();
    //view.setrpt(rpt);
    //view.Show();

    //打印不带预览 
    rpt.SetDataSource(ds.Tables[0]);
    rpt.PrintToPrinter(1, true, 0, 0);
    Print view = new Print();
    view.setrpt(rpt);
    //定义打印纸张标签
    rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperLetterSmall;

    conn.Close();
    ada.Dispose();
    ds.Dispose();
    ds.Clear();
    view.setrpt(rpt);
    #endregion