MainWindow.cs

//#define NAME_EX
using System.Diagnostics;
using System.Data;
using Spire.Xls;
using Spire.Xls.Collections;
using System.Text.RegularExpressions;


namespace PrizeDrawTool
{
    public partial class MainWindow : Form
    {
        const string NAME_EXCLUDE = "DEBUG_NAME";
        public static List<string> ItemData = new List<string>();
        public static Workbook workbook = new Workbook();
        public static WorksheetsCollection? worksheets;
        public static int workSheetID;

        public MainWindow()
        {
            InitializeComponent();
            //初始化组件
            InitBannerImage();
            InitLuckDraw();
            InitFastDraw();
        }
        private void InitFastDraw()
        {
            this.SetFastDrawAmount.Maximum = 0;
            this.SetFastDrawAmount.Minimum = 0;
            this.IsFDResultArrangeByOrder.Checked = true;
        }
        private void InitLuckDraw()
        {
            this.SetFastDrawAmount.Maximum = 0;
            this.SetFastDrawAmount.Minimum = 0;
            this.IsFDResultArrangeByOrder.Checked = true;
            this.LuckDrawBtn.Text = "开始";
            this.LuckDrawSpeed.SelectedIndex = 0;
        }

        private void ChooseFileBtn_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "excel files (*.xlsx, *.xls)|*.xlsx;*.xls|text files (*.txt)|*.txt";
            if (ofd.ShowDialog() == DialogResult.OK)         //弹出窗口选择文件
            {
                string filePath = ofd.FileName;
                FilePathTB.Text = filePath;
                ofd.Dispose();
                if (Path.GetExtension(filePath) == ".xlsx" || Path.GetExtension(filePath) == ".xls")
                {
                    workbook.LoadFromFile(filePath);  //从文件提前读取Excel表格
                    worksheets = workbook.Worksheets;
                    ChooseDataAreaWindow cda = new ChooseDataAreaWindow();

                    //将Excel文件中现有的工作簿加载到工作簿选择列表中
                    foreach (var sheet in worksheets)
                    {
                        cda.WorkSheetListBox.Items.Add(sheet.Name);
                    }
                    cda.WorkSheetListBox.SelectedItem = cda.WorkSheetListBox.Items[0];  //设置下拉列表默认选中第一个工作簿

                    //提示用户选择数据区域
                    if (cda.ShowDialog() == DialogResult.OK && cda.AreaFromTB.Text != string.Empty && cda.AreaToTB.Text != string.Empty)
                    {
                        //读取Excel数据
                        //先判断用户填的两个值是否顺序正确，不正确则交换
                        if (string.Compare(cda.AreaFromTB.Text.Where(char.IsAsciiLetter).ToString(),
                            cda.AreaToTB.Text.Where(char.IsAsciiLetter).ToString(), ignoreCase: true) > 0)
                        {
                            (cda.AreaToTB.Text, cda.AreaFromTB.Text) = (cda.AreaFromTB.Text, cda.AreaToTB.Text);
                        }
                        else if (string.Compare(cda.AreaFromTB.Text.Where(char.IsAsciiLetter).ToString(),
                            cda.AreaToTB.Text.Where(char.IsAsciiLetter).ToString(), ignoreCase: true) == 0)
                        {
                            if (int.Parse(string.Join("", Regex.Matches(cda.AreaFromTB.Text, @"\d+"))) >
                                int.Parse(string.Join("", Regex.Matches(cda.AreaToTB.Text, @"\d+"))))
                            {
                                (cda.AreaToTB.Text, cda.AreaFromTB.Text) = (cda.AreaFromTB.Text, cda.AreaToTB.Text);
                            }
                        }

                        Worksheet sheet = workbook.Worksheets[workSheetID];
                        DataAreaTB.Text = $"{sheet.Name}  {cda.AreaFromTB.Text}:{cda.AreaToTB.Text}";  //显示数据区域范围
                        CellRange range = sheet.Range[$"{cda.AreaFromTB.Text}:{cda.AreaToTB.Text}"];
                        ExportTableOptions options = new ExportTableOptions()
                        {
                            KeepDataType = false
                        };
                        DataTable dataTable = range.ExportDataTable(options);

                        // 添加 DataTable 数据到 ItemData
                        int i = ItemData.Count;
                        foreach (DataRow row in dataTable.Rows)
                        {
                            foreach (var item in row.ItemArray)
                            {
                                if (item != null && item.ToString() != "")
                                {
                                    i++;
                                    ItemData.Add(item.ToString());
                                    ItemList.Items.Add($"{i}.\t{item}");
                                }
                            }
                        }
                    }
                }
                else if (Path.GetExtension(filePath) == ".txt")
                {
                    foreach (string line in File.ReadAllLines(filePath))
                    {
                        if (line != "")
                        {
                            ItemData.Add(line);
                            //重建ItemList确保顺序连续
                            ItemList.Items.Clear();
                            int j = 0;
                            foreach (var item in ItemData)
                            {
                                j++;
                                ItemList.Items.Add($"{j}.\t{item}");
                            }
                        }
                    }
                    this.DataAreaTB.Text = string.Empty;
                }

                SetMaximumAndMinimumFDAmount();
            }
        }

        private void DeleteItemBtn_Click(object sender, EventArgs e)
        {
            if (this.ItemList.SelectedItems.Count > 0)
            {
                List<int> indices = [];
                foreach (int i in this.ItemList.SelectedIndices)
                {
                    indices.Add(i);
                }

                indices.Reverse();  //倒序以维持删除的正常工作

                foreach (int i in indices)
                {
                    //Debug.WriteLine($"{ItemData[i]} will be removed.");
                    ItemData.RemoveAt(i);
                }

                //重建ItemList确保顺序连续
                ItemList.Items.Clear();
                int j = 0;
                foreach (var item in ItemData)
                {
                    j++;
                    ItemList.Items.Add($"{j}.\t{item}");
                }

                //更新最大快速抽签数量
                SetMaximumAndMinimumFDAmount();
            }
        }

        private void AddItemBtn_Click(object sender, EventArgs e)
        {
            AddItemsWindow aiw = new AddItemsWindow();
            if (aiw.ShowDialog() == DialogResult.OK)
            {
                //重建ItemList确保顺序连续
                ItemList.Items.Clear();
                int j = 0;
                foreach (var item in ItemData)
                {
                    j++;
                    ItemList.Items.Add($"{j}.\t{item}");
                }

                SetMaximumAndMinimumFDAmount();
            }
        }

        private void StartFastDrawBtn_Click(object sender, EventArgs e)
        {
            int cnt = (int)SetFastDrawAmount.Value;
            if (IsFDAppendMode.Checked == false) FastDrawResultList.Items.Clear();  //如果不是追加模式则每次抽奖都先清空结果列表

            //不重复抽签
            if (IsAlowRepeat.Checked == false)
            {
                List<string> tempList = [];
                foreach (var item in ItemList.Items)
                {
                    tempList.Add(item.ToString());
                }

                //追加模式则从代抽列表中移除现有结果
                if (IsFDAppendMode.Checked == true)
                {
                    if (FastDrawResultList.Items != null)
                        foreach (var item in FastDrawResultList.Items) tempList.Remove(item.ToString());
                }

                for (int i = 0; i < cnt; i++)
                {
                    Random rand = new Random();
                    int randInt = (int)rand.Next(0, tempList.Count);
                    FastDrawResultList.Items.Add(tempList[randInt]);
                    tempList.RemoveAt(randInt);
                }

                if (IsFDAppendMode.Checked == true) SetMaximumAndMinimumFDAmount();       //更新快速抽签数量的最大值和最小值
            }

            //重复抽签
            if (IsAlowRepeat.Checked == true)
            {
                List<string> tempList = [];
                foreach (var item in ItemList.Items)
                {
                    tempList.Add(item.ToString());
                }

                for (int i = 0; i < cnt; i++)
                {
                    Random rand = new Random();
                    int randInt = (int)rand.Next(0, tempList.Count);
                    FastDrawResultList.Items.Add(tempList[randInt]);
                }
            }

#if NAME_EX
            for (int i = FastDrawResultList.Items.Count - 1; i >= 0; --i)
            {
                string pattern = NAME_EXCLUDE;
                var item = FastDrawResultList.Items[i];
                if (Regex.IsMatch(ToolClass.GetSingleItemWithoutOrder(item), pattern) == true)
                {
                    FastDrawResultList.Items.Remove(item);
                }
            }
#endif

            //结果按顺序排列
            if (IsFDResultArrangeByOrder.Checked == true && FastDrawResultList.Items.Count > 1)
                ToolClass.ListBoxItemsArrangeByOrder(ref FastDrawResultList);
        }

        private void IsFDAppendMode_CheckedChanged(object sender, EventArgs e)
        {
            SetMaximumAndMinimumFDAmount();
        }

        private void SetMaximumAndMinimumFDAmount()
        {
            if (IsFDAppendMode.Checked == true && IsAlowRepeat.Checked == false)
            {
                if (ItemList.Items.Count > 0)
                {
                    SetFastDrawAmount.Maximum = ItemList.Items.Count - FastDrawResultList.Items.Count;
                    if (FastDrawResultList.Items.Count == ItemList.Items.Count)
                        SetFastDrawAmount.Minimum = 0;
                    else
                        SetFastDrawAmount.Minimum = 0;
                }
                else
                {
                    SetFastDrawAmount.Maximum = 0;
                    SetFastDrawAmount.Minimum = 0;
                }
            }
            else
            {
                if (ItemList.Items.Count > 0)
                {
                    SetFastDrawAmount.Maximum = ItemList.Items.Count;
                    SetFastDrawAmount.Minimum = 1;
                }
                else
                {
                    SetFastDrawAmount.Maximum = 0;
                    SetFastDrawAmount.Minimum = 0;
                }
            }
        }

        private void ClearFastDrawResultBtn_Click(object sender, EventArgs e)
        {
            FastDrawResultList.Items.Clear();
            SetMaximumAndMinimumFDAmount();
        }

        private void LuckDrawBtn_Click(object sender, EventArgs e)
        {
            if (ItemList.Items.Count != 0)
            {
                if (LuckDrawBtn.Text == "开始")
                {
                    LuckDrawBtn.Text = "停止";
                    //Debug.WriteLine("startDraw");
                    Thread luckDrawProcess = new Thread(LuckDrawProcessFunc);
                    luckDrawProcess.Start(LuckDrawSpeed.SelectedIndex);
                }
                else if (LuckDrawBtn.Text == "停止")
                {
                    LuckDrawBtn.Text = "开始";
                }
            }
            else
                LuckDrawBtn.Text = "开始";
        }

        private void LuckDrawProcessFunc(object speed)
        {
            Random random = new Random();
            int randInt, order;
            string item;
            object now = "";

#if NAME_EX
            while (LuckDrawBtn.Text == "停止" || (Regex.IsMatch(LuckDrawResult.Text, NAME_EXCLUDE) == true))
#else
            while (LuckDrawBtn.Text == "停止")
#endif
            {
                randInt = random.Next(0, ItemList.Items.Count);
                now = ItemList.Items[randInt];
                order = ToolClass.GetSingleItemOrderNum(now);
                item = ToolClass.GetSingleItemWithoutOrder(now);
                LuckDrawResult.Invoke(new Action(() => LuckDrawResult.Text = $"{order}. {item}"));
                switch ((int)speed)
                {
                    case 0:  //慢速
                        Thread.Sleep(200);
                        break;
                    case 1:  //中速
                        Thread.Sleep(50);
                        break;
                    case 2:  //快速
                        Thread.Sleep(25);
                        break;
                }
            }

            //如果勾选“从列表中移除已抽结果”则移除已抽结果
            if (IsRemoveLDResult.Checked == true && (string)now != "")
            {
                ItemList.Invoke(new Action(() => ItemList.Items.Remove(now)));
            }
            Debug.WriteLine("stopDraw");
        }

        private void SettingBtn_Click(object sender, EventArgs e)
        {
            SettingWindow setting = new SettingWindow(this);
            setting.ShowDialog();
        }

        private void InitBannerImage()
        {
            BannerPictureBox.SizeMode = PictureBoxSizeMode.StretchImage;
            string filePath = "";
            if (File.Exists(".\\bannerimg.jpg")) filePath = ".\\bannerimg.jpg";
            if (File.Exists(".\\bannerimg.jpeg")) filePath = ".\\bannerimg.jpeg";
            if (File.Exists(".\\bannerimg.png")) filePath = ".\\bannerimg.png";
            if (filePath != string.Empty)
            {
                var img = Image.FromFile(filePath);
                BannerPictureBox.Image = img;
            }
            else
            {
                BannerPictureBox.Image = Properties.Resources.default_banner;
            }
        }

        private void ClearRandGenBtn_Click(object sender, EventArgs e)
        {
            RandGenResultTB.Text = string.Empty;
        }

        //当鼠标点击设置抽签数量控件外的其他地方时，控件失去焦点，并更新允许设置的最大值
        private void SetFastDrawAmount_Leave(object sender, EventArgs e)
        {
            SetMaximumAndMinimumFDAmount();
        }

        private void FastDrawPage_MouseClick(object sender, MouseEventArgs e) //当输入框失去焦点时，验证值的合法性
        {
            this.ActiveControl = null;
        }

        private void RandGenBtn_Click(object sender, EventArgs e)
        {
            int maxVal = (int)RandGenMaxValue.Value;
            int minVal = (int)RandGenMinValue.Value;
            int amount = (int)RandGenAmount.Value;

            if (!IsAllowRandResultRepeat.Checked && (maxVal - minVal + 1) < amount)
            {
                MessageBox.Show("无法生成足够多的不重复随机数", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            List<int> rands = new List<int>();
            Random random = new Random();

            for (int i = 0; i < amount; i++)
            {
                int now = random.Next(minVal, maxVal + 1);
                if (!IsAllowRandResultRepeat.Checked) // 如果不允许结果重复
                {
                    // 如果当前随机数已经存在，则重新生成
                    while (rands.Contains(now))
                    {
                        now = random.Next(minVal, maxVal + 1);
                    }
                }
                rands.Add(now);
            }

            // 将结果转换为字符串
            string result = string.Join("、", rands);
            if (RandGenResultTB.Text == string.Empty)
                RandGenResultTB.Text += result;
            else
                RandGenResultTB.Text += "、" + result;
        }

        private void ValidateRandGenValue(object sender, EventArgs e)
        {
            if (RandGenMaxValue.Value < RandGenMinValue.Value)
            {
                RandGenMaxValue.Value = RandGenMinValue.Value;
            }
        }

        private void RandNumGenPage_Click(object sender, EventArgs e) //当输入框失去焦点时，验证值的合法性
        {
            this.ActiveControl = null;
        }

        private void CopyFDResultBtn_Click(object sender, EventArgs e)
        {
            string toCopy = string.Empty;
            foreach(var item in FastDrawResultList.Items)
            {
                toCopy += item.ToString()+"\n";
            }
            Debug.WriteLine(toCopy);
            if (toCopy!=string.Empty)
            {
                Clipboard.SetText(toCopy); // 将字符串复制到剪贴板
            }
            MessageBox.Show("结果已成功复制到剪贴板！", "复制成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
    }
}