CyManager/MembersXX.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;
using System.Data.OleDb;
using System.IO;
using Microsoft.Office.Interop.Excel;

namespace CyManager
{
    public partial class MembersXX : UserControl
    {
        private string mgName;
        private CMembers m = new CMembers();
        private ListViewItem lviCMember = new ListViewItem(); //获得选中的会员
        private List<CMembers> lm = new List<CMembers>();
        private int i = 1;

        public MembersXX()
        {
            InitializeComponent();
        }

        private void MembersXX_Load(object sender, EventArgs e)
        {
            this.txtMId.Focus();
            this.txtMId.Text = "";
            List<CMemberGrade> lmg = new List<CMemberGrade>();
            try
            {
                lmg = BLLMemberGrade.BLLMemberGradeQuery();
            }
            catch (Exception ex)
            {
                MessageBoxNew.Show("查询等级失败!" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            this.cboMGrade.DisplayMember = "CmgName1";
            this.cboMGrade.ValueMember = "CmgId1";
            this.cboMGrade.DataSource = lmg;

            MembersQuery();
            label2.Text = "当前会员总数： " + (i - 1) + "人";
        }

        /// <summary>
        /// 查询所you会员信息的方法
        /// </summary>
        private void MembersQuery()
        {
            this.lvMembers.Items.Clear(); //清空
            DataSet ds = null;
            try
            {
                ds = BLLMembers.BLLMembersQuery();