Beispiel #1
0
        private void button3_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("所有中奖人员和奖项都将重置\n确认清除吗", "清除奖项", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);

            //取消清除
            if (result == DialogResult.Cancel)
            {
                return;
            }

            //所有奖项重置为未抽取状态
            for (int i = 0; i < Form1.LuckCatagroyList.Count; i++)
            {
                List <String> catagroy = Form1.LuckCatagroyList[i];
                catagroy[2] = "未抽取";     //奖项状态
            }


            //已中奖人员名单添加到抽奖人员数据库
            for (int i = 0; i < Form1.LuckedPerson.Count; i++)
            {
                List <String> person = Form1.LuckedPerson[i];
                MySqlitePersons.AddOnePersonFormTable(person[3], person[4], person[5]);
                MySqlitePersons.ReadPersonsFormSQL();
            }

            //清除所有中奖人员名单,清空人员数据
            listView1.Items.Clear();
            Form1.LuckedPerson = new List <List <String> >();

            //删除数据库表
            MySqliteLuckedPerson.DeleteLuckedTable();
        }