抽奖升级版 可以经表格数据导入数据库，抽奖设置，补抽

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Drawing.Imaging;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Collections;
using System.IO;

namespace Check_Ticket
{
    public partial class Btn_UpLoadFile : Form
    {
        string conn = "server=WIN-OUD59R7EHCH;database=Xtf;uid=sa;pwd=123456";
        string sql = "";
        int CurNum = 0;//奖项人数
        int second = 0;//防止二次被抽取
        Hashtable hashtable2 = new Hashtable();//存储编号
        Hashtable hashtable1 = new Hashtable();//存储获奖名单
        Hashtable hashtable = new Hashtable();//避免二次抽奖
        Dictionary<int, string> dict = new Dictionary<int, string>();//词典存储所有参赛者
        Random rd = new Random();
        int time = 1;
        Label[] label = new Label[100];
        int index = 0;//词典key键值
        int total = 0;//label个数
        int num = 0;//获奖总数
        string s = "";
        int End = 0;//抽奖结束
        public Btn_UpLoadFile()
        {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView2.ForeColor = Color.Blue;
            menu.Visible = false;
            comboBox1.SelectedIndex = 0;
            this.timer1.Interval = 10;
            this.timer3.Interval = 100;
            this.timer1.Enabled = true;
            this.WindowState = FormWindowState.Maximized;
        }
        private void getNumber(string s)
        {
            SqlConnection myconn = new SqlConnection(conn);
            myconn.Open();
            sql = "select *from SumPrize";
            SqlDataAdapter da = new SqlDataAdapter(sql, myconn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            switch (s)
            {
                case "一等奖":
                    second = 1;
                    CurNum = Convert.ToInt32(ds.Tables[0].Rows[0]["PrizeNum"].ToString());
                    break;
                case "二等奖":
                    second = 2;
                    CurNum = Convert.ToInt32(ds.Tables[0].Rows[1]["PrizeNum"].ToString());
                    break;
                case "三等奖":
                    second = 3;
                    CurNum = Convert.ToInt32(ds.Tables[0].Rows[2]["PrizeNum"].ToString());
                    break;
                case "四等奖":
                    second = 4;
                    CurNum = Convert.ToInt32(ds.Tables[0].Rows[3]["PrizeNum"].ToString());
                    break;
                case "五等奖":
                    second = 5;
                    CurNum = Convert.ToInt32(ds.Tables[0].Rows[4]["PrizeNum"].ToString());
                    break;
                case "六等奖":
                    second = 6;
                    CurNum = Convert.ToInt32(ds.Tables[0].Rows[5]["PrizeNum"].ToString());
                    break;
                case "请选择":
                    CurNum = 0;
                    break;
                default:
                    break;
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection myconn = new SqlConnection(conn);
            myconn.Open();
            //未选择抽奖项
            if (CurNum == 0)
            {
                MessageBox.Show("未设置该奖项或未选择奖项，抽奖没有意义！！！");
                return;
            }
            //处理已经被抽奖项

            if (!hashtable1.ContainsValue(second))
            {
                comboBox1.Enabled = true;
                hashtable1.Add(second, second);
            }
            else
            {
                MessageBox.Show("此奖项已经被抽过，换个奖项吧？");
                return;
            }
            string prize = comboBox1.Text.ToString();
            string sqlCount = "Select sum(PrizeNum) as num from SumPrize";
            SqlDataAdapter sda = new SqlDataAdapter(sqlCount, myconn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            //设置有奖总人数
            num = Convert.ToInt32(ds.Tables[0].Rows[0]["num"].ToString());
            for (int i = 0; i < dataGridView1.RowCount-1; i++)
            {
                dict.Add(index, dataGridView1.Rows[i].Cells["WorkerID"].Value.ToString() + " " + dataGridView1.Rows[i].Cells["Name"].Value.ToString());
                index++;
            }
           
            myconn.Close();
            timer2.Start();
            clearLabel();
            bornLabel();
            timer1.Enabled = true;
            comboBox1.Enabled = false;
        }

        private void button3_Click(object sender, EventArgs e)
        {
            End = 0;
            menu.Text = "";
            hashtable1.Clear();
            clearLabel();
            button1.Enabled = true;
            button5.Enabled = true;
            button2.Enabled = false;
            menu.Visible = false;
            btnAdd.Visible = false;
            tbNum.Visible = false;
            ge.Visible = false;
            addEnd.Visible = false;
            lab1.Text = "中奖名单";
            dataGridView2.Visible = false;
            string sqlChecked = "delete from Checked";
            sql = "select *from Ticket";
            SqlConnection myconn = new SqlConnection(conn);
            myconn.Open();
            SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
            DataSet ds = new DataSet();
            sda.Fill(ds, "Ticket");
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "Ticket";
            SqlCommand mycomm = new SqlCommand(sqlChecked, myconn);
            mycomm.ExecuteNonQuery();
            myconn.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            menu.Visible = false;
            clearLabel();
            sql = "select WorkerIDAndName,Prize from Checked order by PrizeID";
            SqlConnection myconn = new SqlConnection(conn);
            myconn.Open();
            SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
            DataSet ds1 = new DataSet();
            sda.Fill(ds1, "Checked");
            dataGridView2.DataSource = ds1;
            dataGridView2.DataMember = "Checked";
            dataGridView2.Visible = true;
            menu.Text += "恭喜：
";
            for(int i=0;i<dataGridView2.RowCount-1;i++)
            {
                menu.Text += dataGridView2.Rows[i].Cells["WorkerIDAndName"].Value.ToString() +"  获得"+ dataGridView2.Rows[i].Cells["Prize"].Value.ToString() + "
";
            }
            menu.Visible = true;
            timer3.Start();
            myconn.Close();
        }

        private void button4_Click(object sender, EventArgs e)
        {
            new SetPeople().ShowDialog();
        }

        private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
        {
            getNumber(comboBox1.Text.ToString());
        }

        private void timer1_Tick(object sender, EventArgs e)
        {
            lab1.Left = lab1.Left - 6;
            if (lab1.Right < 0)
            {
                lab1.Left = this.Width;
            }
        }
        //创建labels
        private void bornLabel()
        {
            int i = 0;
            for (i = 0; i < CurNum; i++)
            {
                label[i] = new Label();
                label[i].ForeColor = Color.Blue;
                label[i].Location = new System.Drawing.Point(350, 170 + (i * 50));
                label[i].Size = new System.Drawing.Size(320, 40);
                label[i].BackColor = Color.Transparent;
                label[i].Anchor = (AnchorStyles.Top);
                label[i].Font = new System.Drawing.Font("SimSun", 20, FontStyle.Bold);
                this.Controls.Add(label[i]);
            }
            total = i;
        }
        //清除labels
        private void clearLabel()
        {
            for (int i = 0; i < total; i++)
            {
                this.Controls.Remove(label[i]);
            }
        }
        private void timer2_Tick(object sender, EventArgs e)
        {
            hashtable.Clear();
            hashtable2.Clear();
            SqlConnection con = new SqlConnection(conn);
            string sql = "select count(*) from Ticket";
            SqlCommand com = new SqlCommand(sql, con);
            con.Open();
            int emcount = Convert.ToInt32(com.ExecuteScalar());
            con.Close();

            timer2.Enabled = true;

            timer2.Interval = time;
            int i;
            for (i = 0; i < CurNum; i++)
            {
                int random = Convert.ToInt32(rd.Next(0, emcount));
                if (dataGridView1.Rows[random].Cells["Checked"].Value.ToString().Trim()=="1" 
                    && !hashtable.ContainsValue(dict[random]))
                {
                    hashtable2.Add(random,random);
                    hashtable.Add(dict[random], dict[random]);
                    label[i].Text = dict[random];
                }
                else
                {
                    i--;
                }

            }
        }

        private void button5_Click(object sender, EventArgs e)
        {
            comboBox1.Enabled = true;
            SqlConnection con = new SqlConnection(conn);
            con.Open();
            string sql = "";
            s = "";
            timer2.Stop();
            foreach (DictionaryEntry de in hashtable)
            {
                sql = string.Format("insert into Checked(WorkerIDAndName,Prize,PrizeID) values('{0}','{1}','{2}')", de.Value.ToString(), comboBox1.Text.ToString(),second.ToString());
                SqlCommand com = new SqlCommand(sql, con);
                com.ExecuteNonQuery(); 
                s += de.Value.ToString() +"   "; 
            }
            foreach (DictionaryEntry de in hashtable2)
            {
                dataGridView1.Rows[Convert.ToInt32(de.Key)].Cells["Checked"].Value = "0";
            }
            lab1.Text = "恭喜： " + s + "获得" + comboBox1.Text.ToString();
            //判断抽奖结束
            End = End + CurNum;
            if (End == num)
            {
                button1.Enabled = false;
                //button5.Enabled = false;
                button2.Enabled = true;
                if (MessageBox.Show("抽奖结束,是否进行补抽，点击确定进行补抽，取消结束此次抽奖！", "温馨提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                {
                    btnAdd.Visible = true;
                    tbNum.Visible = true;
                    ge.Visible = true;
                    addEnd.Visible = true;
                }
            }
            
        }

        private void timer3_Tick(object sender, EventArgs e)
        {
            menu.Top = menu.Top - 6 ;
            if (menu.Bottom < 0)
            {
                menu.Top = this.Height-600;
            }
        }

        private void 关闭窗口ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btnAdd_Click(object sender, EventArgs e)
        {
            CurNum = Convert.ToInt32(tbNum.Text.ToString());
            if (CurNum == 0)
            {
                MessageBox.Show("请输入补抽个数!!!", "温馨提示");
                return;
            }
            End = End + CurNum;
            if (End > Convert.ToInt32(dataGridView1.RowCount))
            {
                button5.Enabled = false;
                MessageBox.Show("抽奖超过参与人数无法进行补抽!","温馨提示");
                return;
            }
            timer2.Start();
            clearLabel();
            bornLabel();
        }

        private void addEnd_Click(object sender, EventArgs e)
        {
            btnAdd.Visible = false;
            addEnd.Visible = false;
            tbNum.Visible = false;
            ge.Visible = false;
            menu.Visible = false;
            clearLabel();
            sql = "select WorkerIDAndName,Prize from Checked order by PrizeID";
            SqlConnection myconn = new SqlConnection(conn);
            myconn.Open();
            SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
            DataSet ds1 = new DataSet();
            sda.Fill(ds1, "Checked");
            dataGridView2.DataSource = ds1;
            dataGridView2.DataMember = "Checked";
            menu.Text += "恭喜：
";
            for (int i = 0; i < dataGridView2.RowCount - 1; i++)
            {
                menu.Text += dataGridView2.Rows[i].Cells["WorkerIDAndName"].Value.ToString() + "  获得" + dataGridView2.Rows[i].Cells["Prize"].Value.ToString() + "
";
            }
            menu.Visible = true;
            timer3.Start();
            myconn.Close();
        }

        //先导入到dataSet
        public DataSet getXSLData(string filepath)
        {
            string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties="Excel 12.0;HDR=YES;"";
            System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon);
            string strCom = "SELECT * FROM [Sheet1$]";
            Conn.Open();
            System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
            DataSet ds = new DataSet();
            myCommand.Fill(ds, "[Sheet1$]");
            Conn.Close();
            return ds;
        }

        public static int errorcount = 0;//记录错误信息条数
        public static int insertcount = 0;//记录插入成功条数
        public static int updatecount = 0;//记录更新信息条数

        public bool ImportXSL(string home)
        {
            try
            {
                DataSet ds = new DataSet();
                //取得数据集
                //调用上面的函数
                ds = getXSLData(@home);

                SqlConnection con = new SqlConnection(conn);
                con.Open();
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    string WorkerID = ds.Tables[0].Rows[i][1].ToString();
                    string Name = ds.Tables[0].Rows[i][2].ToString();
                    string Checked = ds.Tables[0].Rows[i][3].ToString();

                    if (WorkerID != "" && Name != "")
                    {
                        string sq = string.Format("select * from Ticket where WorkerID='{0}' and Name='{1}'", WorkerID, Name);
                        SqlCommand selectcom = new SqlCommand(sq, con);
                        int count = Convert.ToInt32(selectcom.ExecuteScalar());
                        if (count > 0)
                        {
                            updatecount++;
                        }
                        else
                        {
                            string s = string.Format("insert into Ticket(WorkerID,Name,Checked) values('{0}','{1}','{2}')", WorkerID, Name,Checked);
                            SqlCommand insertcom = new SqlCommand(s, con);
                            int result = insertcom.ExecuteNonQuery();
                            insertcount++;
                        }
                    }
                }
                if (updatecount + insertcount == ds.Tables[0].Rows.Count)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //导入excle
        private void button6_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";//过滤一下，只要表格格式的
            ofd.RestoreDirectory = true;
            ofd.FilterIndex = 1;
            ofd.AddExtension = true;
            ofd.CheckFileExists = true;
            ofd.CheckPathExists = true;
            ofd.ShowHelp = true;//是否显示帮助按钮
            if (ofd.ShowDialog() == DialogResult.OK)
            {
                this.textBox1.Text = ofd.FileName;
            }   
        }
        //导入excle表格
        private void button7_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(conn);
            con.Open();
            //清空主键信息，标识自增从1开始
            string sqlstr = "truncate table Ticket";
            SqlCommand comm = new SqlCommand(sqlstr,con);
            comm.ExecuteNonQuery();
            con.Close();
            if (textBox1.Text == "")
            {
                MessageBox.Show("请选择一张表格！！！", "温馨提示");
                return;
            }  
            if (ImportXSL(textBox1.Text.ToString()))
            {
                MessageBox.Show(insertcount + "条数据导入成功！" + updatecount + "条数据重复！");
            }
            textBox1.Text = "";
        }

namespace Check_Ticket
{
    partial class Btn_UpLoadFile
    {
        /// <summary>
        /// 必需的设计器变量。
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>
        /// 清理所有正在使用的资源。
        /// </summary>
        /// <param name="disposing">如果应释放托管资源，为 true；否则为 false。</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Windows 窗体设计器生成的代码

        /// <summary>
        /// 设计器支持所需的方法 - 不要
        /// 使用代码编辑器修改此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {
            this.components = new System.ComponentModel.Container();
            this.lab2 = new System.Windows.Forms.Label();
            this.comboBox1 = new System.Windows.Forms.ComboBox();
            this.button1 = new System.Windows.Forms.Button();
            this.dataGridView1 = new System.Windows.Forms.DataGridView();
            this.button2 = new System.Windows.Forms.Button();
            this.button3 = new System.Windows.Forms.Button();
            this.dataGridView2 = new System.Windows.Forms.DataGridView();
            this.button4 = new System.Windows.Forms.Button();
            this.lab1 = new System.Windows.Forms.Label();
            this.timer1 = new System.Windows.Forms.Timer(this.components);
            this.timer2 = new System.Windows.Forms.Timer(this.components);
            this.button5 = new System.Windows.Forms.Button();
            this.lab = new System.Windows.Forms.Label();
            this.timer3 = new System.Windows.Forms.Timer(this.components);
            this.menu = new System.Windows.Forms.Label();
            this.menuStrip1 = new System.Windows.Forms.MenuStrip();
            this.ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.附加功能ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.label1 = new System.Windows.Forms.Label();
            this.btnAdd = new System.Windows.Forms.Button();
            this.tbNum = new System.Windows.Forms.TextBox();
            this.ge = new System.Windows.Forms.Label();
            this.补抽ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
            this.addEnd = new System.Windows.Forms.Button();
            this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog();
            this.button6 = new System.Windows.Forms.Button();
            this.textBox1 = new System.Windows.Forms.TextBox();
            this.button7 = new System.Windows.Forms.Button();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
            this.menuStrip1.SuspendLayout();
            this.SuspendLayout();
            // 
            // lab2
            // 
            this.lab2.AutoSize = true;
            this.lab2.BackColor = System.Drawing.Color.Blue;
            this.lab2.Font = new System.Drawing.Font("微软雅黑", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.lab2.ForeColor = System.Drawing.Color.Red;
            this.lab2.Location = new System.Drawing.Point(959, 323);
            this.lab2.Name = "lab2";
            this.lab2.Size = new System.Drawing.Size(69, 19);
            this.lab2.TabIndex = 2;
            this.lab2.Text = "奖项名称:";
            // 
            // comboBox1
            // 
            this.comboBox1.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
            this.comboBox1.ForeColor = System.Drawing.Color.Red;
            this.comboBox1.FormattingEnabled = true;
            this.comboBox1.Items.AddRange(new object[] {
            "请选择",
            "一等奖",
            "二等奖",
            "三等奖",
            "四等奖",
            "五等奖",
            "六等奖"});
            this.comboBox1.Location = new System.Drawing.Point(1047, 322);
            this.comboBox1.Name = "comboBox1";
            this.comboBox1.Size = new System.Drawing.Size(140, 20);
            this.comboBox1.TabIndex = 3;
            this.comboBox1.SelectedValueChanged += new System.EventHandler(this.comboBox1_SelectedValueChanged);
            // 
            // button1
            // 
            this.button1.Enabled = false;
            this.button1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.button1.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
            this.button1.Location = new System.Drawing.Point(944, 402);
            this.button1.Name = "button1";
            this.button1.Size = new System.Drawing.Size(107, 23);
            this.button1.TabIndex = 4;
            this.button1.Text = "开始抽奖";
            this.button1.UseVisualStyleBackColor = true;
            this.button1.Click += new System.EventHandler(this.button1_Click);
            // 
            // dataGridView1
            // 
            this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView1.Location = new System.Drawing.Point(717, 486);
            this.dataGridView1.Name = "dataGridView1";
            this.dataGridView1.RowTemplate.Height = 23;
            this.dataGridView1.Size = new System.Drawing.Size(737, 199);
            this.dataGridView1.TabIndex = 5;
            this.dataGridView1.Visible = false;
            // 
            // button2
            // 
            this.button2.Enabled = false;
            this.button2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.button2.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
            this.button2.Location = new System.Drawing.Point(1086, 401);
            this.button2.Name = "button2";
            this.button2.Size = new System.Drawing.Size(101, 23);
            this.button2.TabIndex = 6;
            this.button2.Text = "查看获奖名单";
            this.button2.UseVisualStyleBackColor = true;
            this.button2.Click += new System.EventHandler(this.button2_Click);
            // 
            // button3
            // 
            this.button3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.button3.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
            this.button3.Location = new System.Drawing.Point(818, 401);
            this.button3.Name = "button3";
            this.button3.Size = new System.Drawing.Size(87, 23);
            this.button3.TabIndex = 7;
            this.button3.Text = "人员加载";
            this.button3.UseVisualStyleBackColor = true;
            this.button3.Click += new System.EventHandler(this.button3_Click);
            // 
            // dataGridView2
            // 
            this.dataGridView2.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.AllCells;
            this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
            this.dataGridView2.GridColor = System.Drawing.Color.Black;
            this.dataGridView2.Location = new System.Drawing.Point(963, 486);
            this.dataGridView2.Name = "dataGridView2";
            this.dataGridView2.RowHeadersVisible = false;
            this.dataGridView2.RowTemplate.Height = 23;
            this.dataGridView2.Size = new System.Drawing.Size(203, 199);
            this.dataGridView2.TabIndex = 8;
            this.dataGridView2.Visible = false;
            // 
            // button4
            // 
            this.button4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.button4.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(0)))), ((int)(((byte)(0)))), ((int)(((byte)(192)))));
            this.button4.Location = new System.Drawing.Point(1223, 401);
            this.button4.Name = "button4";
            this.button4.Size = new System.Drawing.Size(156, 23);
            this.button4.TabIndex = 9;
            this.button4.Text = "设置奖项对应人数";
            this.button4.UseVisualStyleBackColor = true;
            this.button4.Click += new System.EventHandler(this.button4_Click);
            // 
            // lab1
            // 
            this.lab1.AutoSize = true;
            this.lab1.BackColor = System.Drawing.Color.Transparent;
            this.lab1.Font = new System.Drawing.Font("宋体", 18F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.lab1.ForeColor = System.Drawing.Color.Blue;
            this.lab1.Location = new System.Drawing.Point(1011, 830);
            this.lab1.Name = "lab1";
            this.lab1.Size = new System.Drawing.Size(106, 24);
            this.lab1.TabIndex = 10;
            this.lab1.Text = "获奖名单";
            // 
            // timer1
            // 
            this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
            // 
            // timer2
            // 
            this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
            // 
            // button5
            // 
            this.button5.Enabled = false;
            this.button5.ForeColor = System.Drawing.Color.Red;
            this.button5.Location = new System.Drawing.Point(944, 431);
            this.button5.Name = "button5";
            this.button5.Size = new System.Drawing.Size(107, 23);
            this.button5.TabIndex = 11;
            this.button5.Text = "停止抽奖";
            this.button5.UseVisualStyleBackColor = true;
            this.button5.Click += new System.EventHandler(this.button5_Click);
            // 
            // lab
            // 
            this.lab.Anchor = System.Windows.Forms.AnchorStyles.Top;
            this.lab.AutoSize = true;
            this.lab.BackColor = System.Drawing.Color.Transparent;
            this.lab.Font = new System.Drawing.Font("华文新魏", 42F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.lab.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)(255)))), ((int)(((byte)(255)))), ((int)(((byte)(128)))));
            this.lab.Location = new System.Drawing.Point(753, 31);
            this.lab.Name = "lab";
            this.lab.Size = new System.Drawing.Size(595, 57);
            this.lab.TabIndex = 12;
            this.lab.Text = "善林商务年会抽奖活动";
            // 
            // timer3
            // 
            this.timer3.Tick += new System.EventHandler(this.timer3_Tick);
            // 
            // menu
            // 
            this.menu.AutoSize = true;
            this.menu.BackColor = System.Drawing.Color.Transparent;
            this.menu.Font = new System.Drawing.Font("宋体", 18F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.menu.ForeColor = System.Drawing.Color.Blue;
            this.menu.Location = new System.Drawing.Point(269, 573);
            this.menu.Name = "menu";
            this.menu.Size = new System.Drawing.Size(0, 24);
            this.menu.TabIndex = 13;
            // 
            // menuStrip1
            // 
            this.menuStrip1.BackColor = System.Drawing.Color.Transparent;
            this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.ToolStripMenuItem,
            this.附加功能ToolStripMenuItem});
            this.menuStrip1.Location = new System.Drawing.Point(0, 0);
            this.menuStrip1.Name = "menuStrip1";
            this.menuStrip1.Size = new System.Drawing.Size(1920, 25);
            this.menuStrip1.TabIndex = 14;
            this.menuStrip1.Text = "menuStrip1";
            // 
            // ToolStripMenuItem
            // 
            this.ToolStripMenuItem.BackColor = System.Drawing.Color.Transparent;
            this.ToolStripMenuItem.ForeColor = System.Drawing.Color.Blue;
            this.ToolStripMenuItem.Name = "ToolStripMenuItem";
            this.ToolStripMenuItem.Size = new System.Drawing.Size(68, 21);
            this.ToolStripMenuItem.Text = "关闭窗口";
            this.ToolStripMenuItem.Click += new System.EventHandler(this.关闭窗口ToolStripMenuItem_Click);
            // 
            // 附加功能ToolStripMenuItem
            // 
            this.附加功能ToolStripMenuItem.Name = "附加功能ToolStripMenuItem";
            this.附加功能ToolStripMenuItem.Size = new System.Drawing.Size(12, 21);
            // 
            // label1
            // 
            this.label1.Anchor = System.Windows.Forms.AnchorStyles.Top;
            this.label1.AutoSize = true;
            this.label1.ForeColor = System.Drawing.Color.Yellow;
            this.label1.Location = new System.Drawing.Point(747, 98);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(614, 12);
            this.label1.TabIndex = 15;
            this.label1.Text = "---------------------------------------------------------------------------------" +
    "------";
            // 
            // btnAdd
            // 
            this.btnAdd.ForeColor = System.Drawing.Color.Indigo;
            this.btnAdd.Location = new System.Drawing.Point(1086, 431);
            this.btnAdd.Name = "btnAdd";
            this.btnAdd.Size = new System.Drawing.Size(101, 23);
            this.btnAdd.TabIndex = 16;
            this.btnAdd.Text = "补抽";
            this.btnAdd.UseVisualStyleBackColor = true;
            this.btnAdd.Visible = false;
            this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
            // 
            // tbNum
            // 
            this.tbNum.Location = new System.Drawing.Point(1223, 431);
            this.tbNum.Name = "tbNum";
            this.tbNum.Size = new System.Drawing.Size(125, 21);
            this.tbNum.TabIndex = 17;
            this.tbNum.Text = "0";
            this.tbNum.Visible = false;
            // 
            // ge
            // 
            this.ge.AutoSize = true;
            this.ge.Font = new System.Drawing.Font("宋体", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.ge.Location = new System.Drawing.Point(1357, 438);
            this.ge.Name = "ge";
            this.ge.Size = new System.Drawing.Size(22, 14);
            this.ge.TabIndex = 18;
            this.ge.Text = "个";
            this.ge.Visible = false;
            // 
            // 补抽ToolStripMenuItem
            // 
            this.补抽ToolStripMenuItem.Name = "补抽ToolStripMenuItem";
            this.补抽ToolStripMenuItem.Size = new System.Drawing.Size(32, 19);
            // 
            // addEnd
            // 
            this.addEnd.Location = new System.Drawing.Point(818, 431);
            this.addEnd.Name = "addEnd";
            this.addEnd.Size = new System.Drawing.Size(87, 23);
            this.addEnd.TabIndex = 19;
            this.addEnd.Text = "补抽结束";
            this.addEnd.UseVisualStyleBackColor = true;
            this.addEnd.Visible = false;
            this.addEnd.Click += new System.EventHandler(this.addEnd_Click);
            // 
            // openFileDialog1
            // 
            this.openFileDialog1.FileName = "openFileDialog1";
            // 
            // button6
            // 
            this.button6.Location = new System.Drawing.Point(1086, 371);
            this.button6.Name = "button6";
            this.button6.Size = new System.Drawing.Size(107, 23);
            this.button6.TabIndex = 20;
            this.button6.Text = "选择文件";
            this.button6.UseVisualStyleBackColor = true;
            this.button6.Click += new System.EventHandler(this.button6_Click);
            // 
            // textBox1
            // 
            this.textBox1.Location = new System.Drawing.Point(818, 371);
            this.textBox1.Name = "textBox1";
            this.textBox1.Size = new System.Drawing.Size(233, 21);
            this.textBox1.TabIndex = 21;
            // 
            // button7
            // 
            this.button7.Location = new System.Drawing.Point(1223, 371);
            this.button7.Name = "button7";
            this.button7.Size = new System.Drawing.Size(156, 23);
            this.button7.TabIndex = 22;
            this.button7.Text = "上传文件";
            this.button7.UseVisualStyleBackColor = true;
            this.button7.Click += new System.EventHandler(this.button7_Click);
            // 
            // Btn_UpLoadFile
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.BackColor = System.Drawing.Color.Red;
            this.ClientSize = new System.Drawing.Size(1920, 1038);
            this.Controls.Add(this.button7);
            this.Controls.Add(this.textBox1);
            this.Controls.Add(this.button6);
            this.Controls.Add(this.addEnd);
            this.Controls.Add(this.ge);
            this.Controls.Add(this.tbNum);
            this.Controls.Add(this.btnAdd);
            this.Controls.Add(this.label1);
            this.Controls.Add(this.menu);
            this.Controls.Add(this.lab);
            this.Controls.Add(this.button5);
            this.Controls.Add(this.lab1);
            this.Controls.Add(this.button4);
            this.Controls.Add(this.dataGridView2);
            this.Controls.Add(this.button3);
            this.Controls.Add(this.button2);
            this.Controls.Add(this.comboBox1);
            this.Controls.Add(this.dataGridView1);
            this.Controls.Add(this.button1);
            this.Controls.Add(this.lab2);
            this.Controls.Add(this.menuStrip1);
            this.DoubleBuffered = true;
            this.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
            this.ForeColor = System.Drawing.Color.Purple;
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
            this.MainMenuStrip = this.menuStrip1;
            this.MaximumSize = new System.Drawing.Size(2237, 1080);
            this.MinimumSize = new System.Drawing.Size(1918, 1038);
            this.Name = "Btn_UpLoadFile";
            this.ShowIcon = false;
            this.Text = "抽奖界面";
            this.Load += new System.EventHandler(this.Form1_Load);
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
            this.menuStrip1.ResumeLayout(false);
            this.menuStrip1.PerformLayout();
            this.ResumeLayout(false);
            this.PerformLayout();

        }

        #endregion

        private System.Windows.Forms.Label lab2;
        private System.Windows.Forms.ComboBox comboBox1;
        private System.Windows.Forms.Button button1;
        private System.Windows.Forms.DataGridView dataGridView1;
        private System.Windows.Forms.Button button2;
        private System.Windows.Forms.Button button3;
        private System.Windows.Forms.DataGridView dataGridView2;
        private System.Windows.Forms.Button button4;
        private System.Windows.Forms.Label lab1;
        private System.Windows.Forms.Timer timer1;
        private System.Windows.Forms.Timer timer2;
        private System.Windows.Forms.Button button5;
        private System.Windows.Forms.Label lab;
        private System.Windows.Forms.Timer timer3;
        private System.Windows.Forms.Label menu;
        private System.Windows.Forms.MenuStrip menuStrip1;
        private System.Windows.Forms.ToolStripMenuItem ToolStripMenuItem;
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.Button btnAdd;
        private System.Windows.Forms.TextBox tbNum;
        private System.Windows.Forms.Label ge;
        private System.Windows.Forms.ToolStripMenuItem 附加功能ToolStripMenuItem;
        private System.Windows.Forms.ToolStripMenuItem 补抽ToolStripMenuItem;
        private System.Windows.Forms.Button addEnd;
        private System.Windows.Forms.OpenFileDialog openFileDialog1;
        private System.Windows.Forms.Button button6;
        private System.Windows.Forms.TextBox textBox1;
        private System.Windows.Forms.Button button7;
    }
}

    }
}

数据库设计

界面