CyManager/UReporting.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Common;
using BLL;
using System.Drawing.Printing;
using System.Data.OleDb;
using System.IO;
namespace CyManager
{
    public partial class UReporting : Form
    {
        private PrintPreviewDialog ppd = new PrintPreviewDialog();
        private PrintDialog pdg = new PrintDialog();
        private PrintDocument pd = new PrintDocument();
        private PageSetupDialog psd = new PageSetupDialog();
        string printName = "";
        public UReporting()
        {
            InitializeComponent();
            pd.PrintPage += new PrintPageEventHandler(printDocument1_PrintPage);
            pdg.Document = pd;
            //pd.OriginAtMargins = true;
            //ppd.UseAntiAlias = true;
            ppd.Document = pd;
        }
        ListViewItem lviBill = new ListViewItem();
        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void UReporting_Load(object sender, EventArgs e)
        {
            panel1.HorizontalScroll.Visible = true;
            panel1.VerticalScroll.Visible = true;
            panel2.HorizontalScroll.Visible = true;
            panel2.VerticalScroll.Visible = true;
            this.dtpStart.Value = Convert.ToDateTime(DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"));//设计起始时间
            BillsQuery1();//查询所有结账信息的方法
            //BillsQuery2();
            GetMoney();//获得结账金额的方法
            //GetMoneyT();//销售汇总 获得结账金额的方法
            QueryToday();
           // QueryCaidan();//查询菜单的销售金额
           
            
        }
        /// <summary>
        /// 查询所有结账信息的方法
        /// </summary>
        public void BillsQuery1()
        {
            this.lvBills.Items.Clear();//清空集合中的项
            List<COpenBills> lob = new List<COpenBills>();