程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> C# >> C#入門知識 >> C#實例代碼之抽獎進級版可以經表格數據導入數據庫,抽獎設置,補抽

C#實例代碼之抽獎進級版可以經表格數據導入數據庫,抽獎設置,補抽

編輯:C#入門知識

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;
}
} 
}
}

數據庫設計


界面

好了,本文就給年夜家引見這麼多,有須要的同伙可以參考下本代碼,依據本身現實需求恰當參加,同時感激年夜家一向以來對網站的支撐。

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved