CyManager/MembersBills.cs

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

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using Common;
using BLL;
namespace CyManager
{
    public partial class MembersBills : UserControl
    {
        ListViewItem lviCMBill = new ListViewItem();//存储消费信息列表中选中的项
        List<CMembers> lm = new List<CMembers>();
        
        public MembersBills()
        {
            InitializeComponent();
        }

        private void MenversBills_Load(object sender, EventArgs e)
        {
            MemberBillQuery();

            GetMoney();
        }

        /// <summary>
        /// 获得消费金额的方法
        /// </summary>
        private void GetMoney()
        {
            float money = 0;
            float NeedMoney = 0;
            foreach (ListViewItem lvi in this.lvMBills.Items)
            {
                money += Convert.ToSingle(lvi.SubItems[5].Text);
                NeedMoney += Convert.ToSingle(lvi.SubItems[6].Text);
            }
            this.tsslblMoney.Text = money.ToString() + ".00";
            this.tsslblNeedM.Text = "    " + NeedMoney.ToString() + ".00";
        }

        /// <summary>
        /// 查询所有会员消费信息的方法
        /// </summary>
        private void MemberBillQuery()
        {
            this.lvMBills.Items.Clear();//清空
            DataSet ds = null;
            try
            {
                ds = BLLOpenBills.BLLOpenBillsMemberBills();
            }
            catch (Exception)
            {
                MessageBoxNew.Show("查询会员消费信息失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }