C#實例代碼之抽獎進級版可以經表格數據導入數據庫,抽獎設置,補抽。本站提示廣大學習愛好者:(C#實例代碼之抽獎進級版可以經表格數據導入數據庫,抽獎設置,補抽)文章只能為提供參考,不一定能成為您想要的結果。以下是C#實例代碼之抽獎進級版可以經表格數據導入數據庫,抽獎設置,補抽正文
我寫代碼一向是這個作風,空話不多,直接給年夜家貼代碼,如今照樣老例子,詳細代碼以下所示:
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; } } } }
數據庫設計
界面
好了,本文就給年夜家引見這麼多,有須要的同伙可以參考下本代碼,依據本身現實需求恰當參加,同時感激年夜家一向以來對網站的支撐。