private void button2_Click(object sender, EventArgs e) { //清除选中功能 foreach (ListViewItem item in listView1.SelectedItems) //选中项遍历 { String indexString = item.Text.ToString(); int index = Convert.ToInt32(indexString); Form1.PersonList.RemoveAt(index - 1); //获取工号 String id = listView1.SelectedItems[0].SubItems[1].Text.ToString(); //获取名字 String name = listView1.SelectedItems[0].SubItems[3].Text.ToString(); //从数据库表删除该id人员 MySqlitePersons.DeleteOnePersonFormTable(id, name); listView1.Items.Remove(item); //按项移除 break; } //刷新列表,不然出BUG AddDataToListView(); }
private void RemoveLuckPerson() { //允许多次抽奖 if (MultipleLuck) { return; } //获取中奖人工号和名字 String id = label7.Text; String name = label9.Text; //从数据库中删除 MySqlitePersons.DeleteOnePersonFormTable(id, name); //从数据库重新获取人员名单 MySqlitePersons.ReadPersonsFormSQL(); }