欧美大屁股bbbbxxxx,狼人大香伊蕉国产www亚洲,男ji大巴进入女人的视频小说,男人把ji大巴放进女人免费视频,免费情侣作爱视频

歡迎來到入門教程網(wǎng)!

C#教程

當(dāng)前位置:主頁 > 軟件編程 > C#教程 >

C#實(shí)例代碼之抽獎升級版可以經(jīng)表格數(shù)據(jù)導(dǎo)入數(shù)據(jù)庫,抽獎設(shè)置,補(bǔ)抽

來源:本站原創(chuàng)|時間:2020-01-10|欄目:C#教程|點(diǎn)擊: 次

我寫代碼一直是這個風(fēng)格,廢話不多,直接給大家貼代碼,現(xiàn)在還是老規(guī)矩,具體代碼如下所示:

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 = ;//獎項(xiàng)人數(shù)
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個數(shù)
int num = ;//獲獎總數(shù)
string s = "";
int End = ;//抽獎結(jié)束
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();
//未選擇抽獎項(xiàng)
if (CurNum == )
{
MessageBox.Show("未設(shè)置該獎項(xiàng)或未選擇獎項(xiàng),抽獎沒有意義!??!");
return;
}
//處理已經(jīng)被抽獎項(xiàng)
if (!hashtable.ContainsValue(second))
{
comboBox.Enabled = true;
hashtable.Add(second, second);
}
else
{
MessageBox.Show("此獎項(xiàng)已經(jīng)被抽過,換個獎項(xiàng)吧?");
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);
//設(shè)置有獎總?cè)藬?shù)
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;
}
}
//創(chuàng)建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();
//判斷抽獎結(jié)束
End = End + CurNum;
if (End == num)
{
button.Enabled = false;
//button.Enabled = false;
button.Enabled = true;
if (MessageBox.Show("抽獎結(jié)束,是否進(jìn)行補(bǔ)抽,點(diǎn)擊確定進(jìn)行補(bǔ)抽,取消結(jié)束此次抽獎!", "溫馨提示", 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 關(guān)閉窗口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("請輸入補(bǔ)抽個數(shù)!!!", "溫馨提示");
return;
}
End = End + CurNum;
if (End > Convert.ToInt(dataGridView.RowCount))
{
button.Enabled = false;
MessageBox.Show("抽獎超過參與人數(shù)無法進(jìn)行補(bǔ)抽!","溫馨提示");
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();
}
//先導(dǎo)入到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 = ;//記錄錯誤信息條數(shù)
public static int insertcount = ;//記錄插入成功條數(shù)
public static int updatecount = ;//記錄更新信息條數(shù)
public bool ImportXSL(string home)
{
try
{
DataSet ds = new DataSet();
//取得數(shù)據(jù)集
//調(diào)用上面的函數(shù)
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;
}
}
//導(dǎo)入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;
} 
}
//導(dǎo)入excle表格
private void button_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(conn);
con.Open();
//清空主鍵信息,標(biāo)識自增從開始
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 + "條數(shù)據(jù)導(dǎo)入成功!" + updatecount + "條數(shù)據(jù)重復(fù)!");
}
textBox.Text = "";
} 
namespace Check_Ticket
{
partial class Btn_UpLoadFile
{
/// <summary>
/// 必需的設(shè)計(jì)器變量。
/// </summary>
private System.ComponentModel.IContainer components = null;
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
/// <param name="disposing">如果應(yīng)釋放托管資源,為 true;否則為 false。</param>
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
base.Dispose(disposing);
}
#region Windows 窗體設(shè)計(jì)器生成的代碼
/// <summary>
/// 設(shè)計(jì)器支持所需的方法 - 不要
/// 使用代碼編輯器修改此方法的內(nèi)容。
/// </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.補(bǔ)抽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 = "獎項(xiàng)名稱:";
// 
// 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 = "設(shè)置獎項(xiàng)對應(yīng)人數(shù)";
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 = "善林商務(wù)年會抽獎活動";
// 
// 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 = "關(guān)閉窗口";
this.ToolStripMenuItem.Click += new System.EventHandler(this.關(guān)閉窗口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 = "補(bǔ)抽";
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;
// 
// 補(bǔ)抽ToolStripMenuItem
// 
this.補(bǔ)抽ToolStripMenuItem.Name = "補(bǔ)抽ToolStripMenuItem";
this.補(bǔ)抽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 = "補(bǔ)抽結(jié)束";
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 補(bǔ)抽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;
}
} 
}
}

數(shù)據(jù)庫設(shè)計(jì)


界面

好了,本文就給大家介紹這么多,有需要的朋友可以參考下本代碼,根據(jù)自己實(shí)際需求適當(dāng)加入,同時感謝大家一直以來對我們網(wǎng)站的支持。

網(wǎng)頁制作CMS教程網(wǎng)絡(luò)編程軟件編程腳本語言數(shù)據(jù)庫服務(wù)器

如果侵犯了您的權(quán)利,請與我們聯(lián)系,我們將在24小時內(nèi)進(jìn)行處理、任何非本站因素導(dǎo)致的法律后果,本站均不負(fù)任何責(zé)任。

聯(lián)系QQ:835971066 | 郵箱:835971066#qq.com(#換成@)

Copyright © 2002-2020 腳本教程網(wǎng) 版權(quán)所有