C#实例代码之抽奖升级版可以经表格数据导入数据库,抽奖设置,补抽

时间:2021-05-20

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

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;}}//创建labelsprivate 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;}//清除labelsprivate 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();}//先导入到dataSetpublic 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;}}//导入excleprivate 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();}#endregionprivate 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;}} }}

数据库设计


界面

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

声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。

相关文章