CyManager/Report2.cs

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

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

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 BLL;
using Common;

namespace CyManager
{
    public partial class Report2 : Form
    {
        public Report2()
        {
            InitializeComponent();
        }
        ListViewItem lviBill = new ListViewItem();
        private void Report2_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"));//设计起始时间
            BillsQuery();//查询所有结账信息的方法
            GetMoney();//获得结账金额的方法
        }

        /// <summary>
        /// 查询所有结账信息的方法
        /// </summary>
        public void BillsQuery()
        {
            this.lvBills.Items.Clear();//清空集合中的项
            List<COpenBills> lob = new List<COpenBills>();
            try
            {
                lob = BLLOpenBills.BLLOpenBillsQuery();

            }
            catch (Exception ex)
            {
                MessageBoxNew.Show("查询结账信息失败!" + ex.Message, "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }
            foreach (COpenBills op in lob)
            {
                ListViewItem lvi = new ListViewItem();
                lvi.Text = op.CobId1;
                this.lvBills.Items.Add(lvi);
                lvi.SubItems.AddRange(new string[] { op.TName, op.CopMoney1.ToString(), op.CopSaveMoney1.ToString(), op.CopClientPay1.ToString(), (op.CobId1.Substring(2, 4) + "-" + op.CobId1.Substring(6, 2) + "-" + op.CobId1.Substring(8, 2)), op.CopRemark1 });
            }

        }

        /// <summary>
        /// 获得结账金额的方法