我写代码一直是这个风格，废话不多，直接给大家贴代码，现在还是老规矩，具体代码如下所示：

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-OUDREHCH;database=Xtf;uid=sa;pwd="; string sql = ""; int CurNum = ;//奖项人数 int second = ;//防止二次被抽取 Hashtable hashtable = new Hashtable();//存储编号 Hashtable hashtable = new Hashtable();//存储获奖名单 Hashtable hashtable = new Hashtable();//避免二次抽奖 Dictionary<int, string> dict = new Dictionary<int, string>();//词典存储所有参赛者 Random rd = new Random(); int time = ; Label[] label = new Label[]; int index = ;//词典key键值 int total = ;//label个数 int num = ;//获奖总数 string s = ""; int End = ;//抽奖结束 public Btn_UpLoadFile() { InitializeComponent(); } private void Form_Load(object sender, EventArgs e) { dataGridView.ForeColor = Color.Blue; menu.Visible = false; comboBox.SelectedIndex = ; this.timer.Interval = ; this.timer.Interval = ; this.timer.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 = ; CurNum = Convert.ToInt(ds.Tables[].Rows[]["PrizeNum"].ToString()); break; case "二等奖": second = ; CurNum = Convert.ToInt(ds.Tables[].Rows[]["PrizeNum"].ToString()); break; case "三等奖": second = ; CurNum = Convert.ToInt(ds.Tables[].Rows[]["PrizeNum"].ToString()); break; case "四等奖": second = ; CurNum = Convert.ToInt(ds.Tables[].Rows[]["PrizeNum"].ToString()); break; case "五等奖": second = ; CurNum = Convert.ToInt(ds.Tables[].Rows[]["PrizeNum"].ToString()); break; case "六等奖": second = ; CurNum = Convert.ToInt(ds.Tables[].Rows[]["PrizeNum"].ToString()); break; case "请选择": CurNum = ; break; default: break; } } private void button_Click(object sender, EventArgs e) { SqlConnection myconn = new SqlConnection(conn); myconn.Open(); //未选择抽奖项 if (CurNum == ) { MessageBox.Show("未设置该奖项或未选择奖项，抽奖没有意义！！！"); return; } //处理已经被抽奖项 if (!hashtable.ContainsValue(second)) { comboBox.Enabled = true; hashtable.Add(second, second); } else { MessageBox.Show("此奖项已经被抽过，换个奖项吧？"); return; } string prize = comboBox.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.ToInt(ds.Tables[].Rows[]["num"].ToString()); for (int i = ; i < dataGridView.RowCount-; i++) { dict.Add(index, dataGridView.Rows[i].Cells["WorkerID"].Value.ToString() + " " + dataGridView.Rows[i].Cells["Name"].Value.ToString()); index++; } myconn.Close(); timer.Start(); clearLabel(); bornLabel(); timer.Enabled = true; comboBox.Enabled = false; } private void button_Click(object sender, EventArgs e) { End = ; menu.Text = ""; hashtable.Clear(); clearLabel(); button.Enabled = true; button.Enabled = true; button.Enabled = false; menu.Visible = false; btnAdd.Visible = false; tbNum.Visible = false; ge.Visible = false; addEnd.Visible = false; lab.Text = "中奖名单"; dataGridView.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"); dataGridView.DataSource = ds; dataGridView.DataMember = "Ticket"; SqlCommand mycomm = new SqlCommand(sqlChecked, myconn); mycomm.ExecuteNonQuery(); myconn.Close(); } private void button_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 ds = new DataSet(); sda.Fill(ds, "Checked"); dataGridView.DataSource = ds; dataGridView.DataMember = "Checked"; dataGridView.Visible = true; menu.Text += "恭喜：n"; for(int i=;i<dataGridView.RowCount-;i++) { menu.Text += dataGridView.Rows[i].Cells["WorkerIDAndName"].Value.ToString() +" 获得"+ dataGridView.Rows[i].Cells["Prize"].Value.ToString() + "n"; } menu.Visible = true; timer.Start(); myconn.Close(); } private void button_Click(object sender, EventArgs e) { new SetPeople().ShowDialog(); } private void comboBox_SelectedValueChanged(object sender, EventArgs e) { getNumber(comboBox.Text.ToString()); } private void timer_Tick(object sender, EventArgs e) { lab.Left = lab.Left - ; if (lab.Right < ) { lab.Left = this.Width; } } //创建labels private void bornLabel() { int i = ; for (i = ; i < CurNum; i++) { label[i] = new Label(); label[i].ForeColor = Color.Blue; label[i].Location = new System.Drawing.Point(, + (i * )); label[i].Size = new System.Drawing.Size(, ); label[i].BackColor = Color.Transparent; label[i].Anchor = (AnchorStyles.Top); label[i].Font = new System.Drawing.Font("SimSun", , FontStyle.Bold); this.Controls.Add(label[i]); } total = i; } //清除labels private void clearLabel() { for (int i = ; i < total; i++) { this.Controls.Remove(label[i]); } } private void timer_Tick(object sender, EventArgs e) { hashtable.Clear(); hashtable.Clear(); SqlConnection con = new SqlConnection(conn); string sql = "select count(*) from Ticket"; SqlCommand com = new SqlCommand(sql, con); con.Open(); int emcount = Convert.ToInt(com.ExecuteScalar()); con.Close(); timer.Enabled = true; timer.Interval = time; int i; for (i = ; i < CurNum; i++) { int random = Convert.ToInt(rd.Next(, emcount)); if (dataGridView.Rows[random].Cells["Checked"].Value.ToString().Trim()=="" && !hashtable.ContainsValue(dict[random])) { hashtable.Add(random,random); hashtable.Add(dict[random], dict[random]); label[i].Text = dict[random]; } else { i--; } } } private void button_Click(object sender, EventArgs e) { comboBox.Enabled = true; SqlConnection con = new SqlConnection(conn); con.Open(); string sql = ""; s = ""; timer.Stop(); foreach (DictionaryEntry de in hashtable) { sql = string.Format("insert into Checked(WorkerIDAndName,Prize,PrizeID) values('{}','{}','{}')", de.Value.ToString(), comboBox.Text.ToString(),second.ToString()); SqlCommand com = new SqlCommand(sql, con); com.ExecuteNonQuery(); s += de.Value.ToString() +" "; } foreach (DictionaryEntry de in hashtable) { dataGridView.Rows[Convert.ToInt(de.Key)].Cells["Checked"].Value = ""; } lab.Text = "恭喜： " + s + "获得" + comboBox.Text.ToString(); //判断抽奖结束 End = End + CurNum; if (End == num) { button.Enabled = false; //button.Enabled = false; button.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 timer_Tick(object sender, EventArgs e) { menu.Top = menu.Top - ; if (menu.Bottom < ) { menu.Top = this.Height-; } } private void 关闭窗口ToolStripMenuItem_Click(object sender, EventArgs e) { this.Close(); } private void btnAdd_Click(object sender, EventArgs e) { CurNum = Convert.ToInt(tbNum.Text.ToString()); if (CurNum == ) { MessageBox.Show("请输入补抽个数!!!", "温馨提示"); return; } End = End + CurNum; if (End > Convert.ToInt(dataGridView.RowCount)) { button.Enabled = false; MessageBox.Show("抽奖超过参与人数无法进行补抽!","温馨提示"); return; } timer.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 ds = new DataSet(); sda.Fill(ds, "Checked"); dataGridView.DataSource = ds; dataGridView.DataMember = "Checked"; menu.Text += "恭喜：n"; for (int i = ; i < dataGridView.RowCount - ; i++) { menu.Text += dataGridView.Rows[i].Cells["WorkerIDAndName"].Value.ToString() + " 获得" + dataGridView.Rows[i].Cells["Prize"].Value.ToString() + "n"; } menu.Visible = true; timer.Start(); myconn.Close(); } //先导入到dataSet public DataSet getXSLData(string filepath) { string strCon = "Provider=Microsoft.ACE.OLEDB..;Data Source=" + filepath + ";Extended Properties="Excel .;HDR=YES;""; System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon); string strCom = "SELECT * FROM [Sheet$]"; Conn.Open(); System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn); DataSet ds = new DataSet(); myCommand.Fill(ds, "[Sheet$]"); Conn.Close(); return ds; } public static int errorcount = ;//记录错误信息条数 public static int insertcount = ;//记录插入成功条数 public static int updatecount = ;//记录更新信息条数 public bool ImportXSL(string home) { try { DataSet ds = new DataSet(); //取得数据集 //调用上面的函数 ds = getXSLData(@home); SqlConnection con = new SqlConnection(conn); con.Open(); for (int i = ; i < ds.Tables[].Rows.Count; i++) { string WorkerID = ds.Tables[].Rows[i][].ToString(); string Name = ds.Tables[].Rows[i][].ToString(); string Checked = ds.Tables[].Rows[i][].ToString(); if (WorkerID != "" && Name != "") { string sq = string.Format("select * from Ticket where WorkerID='{}' and Name='{}'", WorkerID, Name); SqlCommand selectcom = new SqlCommand(sq, con); int count = Convert.ToInt(selectcom.ExecuteScalar()); if (count > ) { updatecount++; } else { string s = string.Format("insert into Ticket(WorkerID,Name,Checked) values('{}','{}','{}')", WorkerID, Name,Checked); SqlCommand insertcom = new SqlCommand(s, con); int result = insertcom.ExecuteNonQuery(); insertcount++; } } } if (updatecount + insertcount == ds.Tables[].Rows.Count) { return true; } else { return false; } } catch (Exception e) { return false; } } //导入excle private void button_Click(object sender, EventArgs e) { OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";//过滤一下，只要表格格式的 ofd.RestoreDirectory = true; ofd.FilterIndex = ; ofd.AddExtension = true; ofd.CheckFileExists = true; ofd.CheckPathExists = true; ofd.ShowHelp = true;//是否显示帮助按钮 if (ofd.ShowDialog() == DialogResult.OK) { this.textBox.Text = ofd.FileName; } } //导入excle表格 private void button_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(conn); con.Open(); //清空主键信息，标识自增从开始 string sqlstr = "truncate table Ticket"; SqlCommand comm = new SqlCommand(sqlstr,con); comm.ExecuteNonQuery(); con.Close(); if (textBox.Text == "") { MessageBox.Show("请选择一张表格！！！", "温馨提示"); return; } if (ImportXSL(textBox.Text.ToString())) { MessageBox.Show(insertcount + "条数据导入成功！" + updatecount + "条数据重复！"); } textBox.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.lab = new System.Windows.Forms.Label(); this.comboBox = new System.Windows.Forms.ComboBox(); this.button = new System.Windows.Forms.Button(); this.dataGridView = new System.Windows.Forms.DataGridView(); this.button = new System.Windows.Forms.Button(); this.button = new System.Windows.Forms.Button(); this.dataGridView = new System.Windows.Forms.DataGridView(); this.button = new System.Windows.Forms.Button(); this.lab = new System.Windows.Forms.Label(); this.timer = new System.Windows.Forms.Timer(this.components); this.timer = new System.Windows.Forms.Timer(this.components); this.button = new System.Windows.Forms.Button(); this.lab = new System.Windows.Forms.Label(); this.timer = new System.Windows.Forms.Timer(this.components); this.menu = new System.Windows.Forms.Label(); this.menuStrip = new System.Windows.Forms.MenuStrip(); this.ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.附加功能ToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); this.label = 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.openFileDialog = new System.Windows.Forms.OpenFileDialog(); this.button = new System.Windows.Forms.Button(); this.textBox = new System.Windows.Forms.TextBox(); this.button = new System.Windows.Forms.Button(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView)).BeginInit(); this.menuStrip.SuspendLayout(); this.SuspendLayout(); // // lab // this.lab.AutoSize = true; this.lab.BackColor = System.Drawing.Color.Blue; this.lab.Font = new System.Drawing.Font("微软雅黑", .F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.lab.ForeColor = System.Drawing.Color.Red; this.lab.Location = new System.Drawing.Point(, ); this.lab.Name = "lab"; this.lab.Size = new System.Drawing.Size(, ); this.lab.TabIndex = ; this.lab.Text = "奖项名称:"; // // comboBox // this.comboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList; this.comboBox.ForeColor = System.Drawing.Color.Red; this.comboBox.FormattingEnabled = true; this.comboBox.Items.AddRange(new object[] { "请选择", "一等奖", "二等奖", "三等奖", "四等奖", "五等奖", "六等奖"}); this.comboBox.Location = new System.Drawing.Point(, ); this.comboBox.Name = "comboBox"; this.comboBox.Size = new System.Drawing.Size(, ); this.comboBox.TabIndex = ; this.comboBox.SelectedValueChanged += new System.EventHandler(this.comboBox_SelectedValueChanged); // // button // this.button.Enabled = false; this.button.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.button.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)()))), ((int)(((byte)()))), ((int)(((byte)())))); this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "开始抽奖"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_Click); // // dataGridView // this.dataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView.Location = new System.Drawing.Point(, ); this.dataGridView.Name = "dataGridView"; this.dataGridView.RowTemplate.Height = ; this.dataGridView.Size = new System.Drawing.Size(, ); this.dataGridView.TabIndex = ; this.dataGridView.Visible = false; // // button // this.button.Enabled = false; this.button.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.button.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)()))), ((int)(((byte)()))), ((int)(((byte)())))); this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "查看获奖名单"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_Click); // // button // this.button.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.button.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)()))), ((int)(((byte)()))), ((int)(((byte)())))); this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "人员加载"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_Click); // // dataGridView // this.dataGridView.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.AllCells; this.dataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView.GridColor = System.Drawing.Color.Black; this.dataGridView.Location = new System.Drawing.Point(, ); this.dataGridView.Name = "dataGridView"; this.dataGridView.RowHeadersVisible = false; this.dataGridView.RowTemplate.Height = ; this.dataGridView.Size = new System.Drawing.Size(, ); this.dataGridView.TabIndex = ; this.dataGridView.Visible = false; // // button // this.button.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.button.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)()))), ((int)(((byte)()))), ((int)(((byte)())))); this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "设置奖项对应人数"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_Click); // // lab // this.lab.AutoSize = true; this.lab.BackColor = System.Drawing.Color.Transparent; this.lab.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)())); this.lab.ForeColor = System.Drawing.Color.Blue; this.lab.Location = new System.Drawing.Point(, ); this.lab.Name = "lab"; this.lab.Size = new System.Drawing.Size(, ); this.lab.TabIndex = ; this.lab.Text = "获奖名单"; // // timer // this.timer.Tick += new System.EventHandler(this.timer_Tick); // // timer // this.timer.Tick += new System.EventHandler(this.timer_Tick); // // button // this.button.Enabled = false; this.button.ForeColor = System.Drawing.Color.Red; this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "停止抽奖"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_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("华文新魏", F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.lab.ForeColor = System.Drawing.Color.FromArgb(((int)(((byte)()))), ((int)(((byte)()))), ((int)(((byte)())))); this.lab.Location = new System.Drawing.Point(, ); this.lab.Name = "lab"; this.lab.Size = new System.Drawing.Size(, ); this.lab.TabIndex = ; this.lab.Text = "善林商务年会抽奖活动"; // // timer // this.timer.Tick += new System.EventHandler(this.timer_Tick); // // menu // this.menu.AutoSize = true; this.menu.BackColor = System.Drawing.Color.Transparent; this.menu.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)())); this.menu.ForeColor = System.Drawing.Color.Blue; this.menu.Location = new System.Drawing.Point(, ); this.menu.Name = "menu"; this.menu.Size = new System.Drawing.Size(, ); this.menu.TabIndex = ; // // menuStrip // this.menuStrip.BackColor = System.Drawing.Color.Transparent; this.menuStrip.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { this.ToolStripMenuItem, this.附加功能ToolStripMenuItem}); this.menuStrip.Location = new System.Drawing.Point(, ); this.menuStrip.Name = "menuStrip"; this.menuStrip.Size = new System.Drawing.Size(, ); this.menuStrip.TabIndex = ; this.menuStrip.Text = "menuStrip"; // // 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(, ); this.ToolStripMenuItem.Text = "关闭窗口"; this.ToolStripMenuItem.Click += new System.EventHandler(this.关闭窗口ToolStripMenuItem_Click); // // 附加功能ToolStripMenuItem // this.附加功能ToolStripMenuItem.Name = "附加功能ToolStripMenuItem"; this.附加功能ToolStripMenuItem.Size = new System.Drawing.Size(, ); // // label // this.label.Anchor = System.Windows.Forms.AnchorStyles.Top; this.label.AutoSize = true; this.label.ForeColor = System.Drawing.Color.Yellow; this.label.Location = new System.Drawing.Point(, ); this.label.Name = "label"; this.label.Size = new System.Drawing.Size(, ); this.label.TabIndex = ; this.label.Text = "---------------------------------------------------------------------------------" + "------"; // // btnAdd // this.btnAdd.ForeColor = System.Drawing.Color.Indigo; this.btnAdd.Location = new System.Drawing.Point(, ); this.btnAdd.Name = "btnAdd"; this.btnAdd.Size = new System.Drawing.Size(, ); this.btnAdd.TabIndex = ; 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(, ); this.tbNum.Name = "tbNum"; this.tbNum.Size = new System.Drawing.Size(, ); this.tbNum.TabIndex = ; this.tbNum.Text = ""; this.tbNum.Visible = false; // // ge // this.ge.AutoSize = true; this.ge.Font = new System.Drawing.Font("宋体", .F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.ge.Location = new System.Drawing.Point(, ); this.ge.Name = "ge"; this.ge.Size = new System.Drawing.Size(, ); this.ge.TabIndex = ; this.ge.Text = "个"; this.ge.Visible = false; // // 补抽ToolStripMenuItem // this.补抽ToolStripMenuItem.Name = "补抽ToolStripMenuItem"; this.补抽ToolStripMenuItem.Size = new System.Drawing.Size(, ); // // addEnd // this.addEnd.Location = new System.Drawing.Point(, ); this.addEnd.Name = "addEnd"; this.addEnd.Size = new System.Drawing.Size(, ); this.addEnd.TabIndex = ; this.addEnd.Text = "补抽结束"; this.addEnd.UseVisualStyleBackColor = true; this.addEnd.Visible = false; this.addEnd.Click += new System.EventHandler(this.addEnd_Click); // // openFileDialog // this.openFileDialog.FileName = "openFileDialog"; // // button // this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "选择文件"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_Click); // // textBox // this.textBox.Location = new System.Drawing.Point(, ); this.textBox.Name = "textBox"; this.textBox.Size = new System.Drawing.Size(, ); this.textBox.TabIndex = ; // // button // this.button.Location = new System.Drawing.Point(, ); this.button.Name = "button"; this.button.Size = new System.Drawing.Size(, ); this.button.TabIndex = ; this.button.Text = "上传文件"; this.button.UseVisualStyleBackColor = true; this.button.Click += new System.EventHandler(this.button_Click); // // Btn_UpLoadFile // this.AutoScaleDimensions = new System.Drawing.SizeF(F, F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.BackColor = System.Drawing.Color.Red; this.ClientSize = new System.Drawing.Size(, ); this.Controls.Add(this.button); this.Controls.Add(this.textBox); this.Controls.Add(this.button); this.Controls.Add(this.addEnd); this.Controls.Add(this.ge); this.Controls.Add(this.tbNum); this.Controls.Add(this.btnAdd); this.Controls.Add(this.label); this.Controls.Add(this.menu); this.Controls.Add(this.lab); this.Controls.Add(this.button); this.Controls.Add(this.lab); this.Controls.Add(this.button); this.Controls.Add(this.dataGridView); this.Controls.Add(this.button); this.Controls.Add(this.button); this.Controls.Add(this.comboBox); this.Controls.Add(this.dataGridView); this.Controls.Add(this.button); this.Controls.Add(this.lab); this.Controls.Add(this.menuStrip); this.DoubleBuffered = true; this.Font = new System.Drawing.Font("宋体", F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)())); this.ForeColor = System.Drawing.Color.Purple; this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None; this.MainMenuStrip = this.menuStrip; this.MaximumSize = new System.Drawing.Size(, ); this.MinimumSize = new System.Drawing.Size(, ); this.Name = "Btn_UpLoadFile"; this.ShowIcon = false; this.Text = "抽奖界面"; this.Load += new System.EventHandler(this.Form_Load); ((System.ComponentModel.ISupportInitialize)(this.dataGridView)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView)).EndInit(); this.menuStrip.ResumeLayout(false); this.menuStrip.PerformLayout(); this.ResumeLayout(false); this.PerformLayout(); } #endregion private System.Windows.Forms.Label lab; private System.Windows.Forms.ComboBox comboBox; private System.Windows.Forms.Button button; private System.Windows.Forms.DataGridView dataGridView; private System.Windows.Forms.Button button; private System.Windows.Forms.Button button; private System.Windows.Forms.DataGridView dataGridView; private System.Windows.Forms.Button button; private System.Windows.Forms.Label lab; private System.Windows.Forms.Timer timer; private System.Windows.Forms.Timer timer; private System.Windows.Forms.Button button; private System.Windows.Forms.Label lab; private System.Windows.Forms.Timer timer; private System.Windows.Forms.Label menu; private System.Windows.Forms.MenuStrip menuStrip; private System.Windows.Forms.ToolStripMenuItem ToolStripMenuItem; private System.Windows.Forms.Label label; 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 openFileDialog; private System.Windows.Forms.Button button; private System.Windows.Forms.TextBox textBox; private System.Windows.Forms.Button button; } } } }

数据库设计

界面

好了，本文就给大家介绍这么多，有需要的朋友可以参考下本代码，根据自己实际需求适当加入，同时感谢大家一直以来对查字典教程网的支持。

【C#实例代码之抽奖升级版可以经表格数据导入数据库，抽奖设置，补抽】相关文章：

★ C#垃圾回收机制的详细介绍

★ 浅谈Java与C#的一些细微差别

★ ADO.NET实体数据模型详细介绍

★ C# 对XML基本操作代码总结

★ C# 利用StringBuilder提升字符串拼接性能的小例子

★ C# 中文简体转繁体实现代码

★ 深入多线程之:内存栅栏与volatile关键字的使用分析

★ 基于DateTime.ParseExact方法的使用详解

★ C#设置子窗体在主窗体中居中显示解决方案

★ 使用Npoi操作excel的解决办法