年会抽奖（带抽奖音效,access数据库）

C#语言基础
下载此实例
开发语言：C#
实例大小：6.14M
下载次数：86
浏览次数：808
发布时间：2019-08-14
实例类别：C#语言基础
发布人：sunyzth
文件格式：.zip
所需积分：2
实例介绍

[下载地址]
【实例简介】
年会抽奖，通过F1/F2/F3/F4/F5... 键来切换抽奖轮次，详见代码
【实例截图】
【核心代码】
using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Threading;
using System.Runtime.InteropServices;
 
 
namespace choujiang
{
    public partial class Form1 : Form
    {
        /// <summary>
        ///  调用windows内置播放器类 WMPLib.WindowsMediaPlayerClass
        /// </summary>
        WMPLib.WindowsMediaPlayerClass MediaPlayer = new WMPLib.WindowsMediaPlayerClass();
 
        /// <summary>
        /// 创建连接数据库实例
        /// </summary>
        SqlBase db = new SqlBase();//实例化数据库连接类
 
        /// <summary>
        /// 定义随机抽奖线程名称 th
        /// </summary>
        Thread th = null;
 
        /// <summary>
        /// 定义随机抽奖线程执行标记 true：随机抽奖线程开始，false：随机抽奖线程结束
        /// </summary>
        private bool Exflag = false;
 
        /// <summary>
        /// 定义数据表 dTable
        /// </summary>
        DataTable dTable;
 
        /// <summary>
        /// 定义datatable的总记录数
        /// </summary>
        private int DataTotal;
 
        /// <summary>
        /// 定义抽奖模式变量,1 为幸运奖/ 2 为三等奖/ 3 为二等奖/ 4 为一等奖/ 5 为特等奖/ 6 为单独重新抽奖模式
        /// </summary>
        private int Draw_Model = 1; //抽奖模拟式
 
        /// <summary>
        /// 载入抽奖次数
        /// </summary>
        private int Draw_Model_Times;
 
        /// <summary>
        /// 载入每次抽奖的个数
        /// </summary>
        private int Per_Count;
 
        /// <summary>
        /// 记录临时抽奖的次数，用于比较抽奖次数，默认值 0
        /// </summary>
        private int Draw_Model_Times_Temp = 0;
 
        /// <summary>
        /// 定义抽奖完成标记 true：已完成，false：未完成
        /// </summary>
        private bool Finish_Flag = false;
 
        /// <summary>
        /// 定义是否单独抽奖模式，true：是，false：不是
        /// </summary>
        private bool Single_Mode = false;
 
        /// <summary>
        /// 存放抽奖级别记录
        /// </summary>        
        private List<int> Draw_Model_Record = new List<int>();
 
        /// <summary>
        /// 存放抽中号码泛型变量
        /// </summary>
        private List<string> Array_Lucky_Number = new List<string>();
 
        /// <summary>
        /// 存放记录抽奖结果的SQL语句集的动态数组
        /// </summary>
        ArrayList Array_SQL = new ArrayList();
 
        /// <summary>
        /// 存放设置抽奖参数的SQL语句集的动态数组
        /// </summary>
        ArrayList Array_Setup = new ArrayList();
 
        private string strr = string.Empty;
 
        public Form1()
        {
            InitializeComponent();
            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\X.jpg");
            KillProcess();
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
            #region   程序开始时加载
            Finish_Flag = false;
            label2.Text = string.Empty;
            strr = string.Empty;
            label1.Location = new System.Drawing.Point(360, 399);
            Finish_Flag = false;
            Draw_Model = 1;//幸运奖模式为1
            Loac_Draw_Data(Draw_Model);
            label1.Text = string.Empty;
            button2.Enabled = false;
            button1.Focus();
            timer1.Enabled = true;
            timer1.Start();
            KillProcess();
            #endregion
        }
 
 
        /// <summary>
        /// 定义播放音乐文件函数 PlayingMedia，参数String MediaPath 表示音乐文件的路径
        /// </summary>
        /// <param name="MediaPath">String MediaPath 表示音乐文件的路径</param>
        private void PlayingMedia(String MediaPath)
        {
            #region   播放音乐
            MediaPlayer.URL = MediaPath;
            MediaPlayer.play();
            #endregion
        }
 
        /// <summary>
        /// 定义暂停播放音乐函数 pauseOperation
        /// </summary>
        private void pauseOperation()
        {
            #region    暂停播放音乐
            MediaPlayer.controls.pause();
            #endregion
        }
        
        private void show_number_1(List<int> arrnum, string str, Label label)
        {
            #region   显示幸运号码
            for (int i = 0; i < arrnum.Count; i  )
            {
                int T = i;
                T  ;
                if (T != arrnum.Count)
                {
                    str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   " ";
                }
                else
                {
                    str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0');
                }
            }
            label.Text = str;
            strr = str;
            #endregion
        }
 
        private List<int> arrnum = new List<int>();
 
        public List<int> getRandomNum1(int num, int minValue, int maxValue)
        {
            #region   获取随机数2
            Random ra = new Random(unchecked((int)DateTime.Now.Ticks));
            List<int> arrNum1 = new List<int>();
            int tmp = 0;
            for (int i = 0; i < num; i  )//确定抽取次数
            {
                int s = i;
                if (i == 0)
                {
                    tmp = ra.Next(minValue, maxValue); //随机取数 
                    arrNum1.Add(tmp);
                }
                else
                {
                    tmp = ra.Next(minValue, maxValue); //随机取数 
                    if (FindNu(arrNum1, tmp) == false)
                    {
 
                    }
                    if (FindNu(arrNum1, tmp) == true)
                    {
                        arrNum1.Add(tmp);
                    }
                    else
                    {
                        i--;
                        continue;//若重复返回重复抽取随机数
                    }
                }
            }
            GC.Collect();
            return arrNum1;
            #endregion
        }
 
        private bool FindNu(List<int> Fm, int tmp)
        {
            #region   判断随机数是否重复
            for (int i = 0; i < Fm.Count; i  )
            {
                if (Fm[i].CompareTo(tmp) == 0)
                {
                    return false;
                }
            }
            return true;
            #endregion
        }
         
        private void test()
        {
            #region   抽奖函数test()
            string strSQL;
            strSQL = "select [msgcontent],[manname],[value] from data1 where [value]<>'1' and [flag]<> '0'";
            dTable = db.SqlDataTable(strSQL);
            DataTotal = dTable.Rows.Count;
            while (!Exflag)
            {
 
                arrnum = getRandomNum1(Per_Count, 1, DataTotal);
                string str = string.Empty;
                if (Per_Count >= 10)
                {
                    for (int i = 0; i < arrnum.Count; i  )
                    {
                        if (i == 4)
                        {
                            str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   "\n";
                        }
                        else
                        {
                            str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   " ";
                        }
                    }
                    DispInfo(label1, str);
                }
                else
                {
                    for (int i = 0; i < arrnum.Count; i  )
                    {
                        str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   " ";
                    }
                    DispInfo(label1, str);
                }
                GC.Collect();
                KillProcess();
                Thread.Sleep(20);
            }
            #endregion
        }
 
        private void test_2()
        {
            #region   抽奖函数test_2()
            string strSQL1;
            strSQL1 = "select [msgcontent],[manname],[value] from data1_1 where [value]<>'1' and [flag]<> '0' ";
            dTable = db.SqlDataTable(strSQL1);
            DataTotal = dTable.Rows.Count;
            if (DataTotal != 0)
            {
                while (!Exflag)
                {
                    arrnum = getRandomNum1(Per_Count, 0, DataTotal);
                    string str = string.Empty;
                    if (Per_Count >= 10)
                    {
                        for (int i = 0; i < arrnum.Count; i  )
                        {
                            if (i == 4)
                            {
                                str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   "\n";
                            }
                            else
                            {
                                str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   " ";
                            }
                        }
                        DispInfo(label1, str);
 
                    }
                    else
                    {
                        for (int i = 0; i < arrnum.Count; i  )
                        {
                            //str  =  dTable.Rows[Convert.ToInt32(arrnum[i])][0].ToString().PadLeft(3, '0')   " ";
                            str  = dTable.Rows[arrnum[i]][0].ToString().PadLeft(3, '0')   " ";
                        }
                        DispInfo(label1, str);
                    }
                    GC.Collect();
                    KillProcess();
                    Thread.Sleep(20);
                }
            }
            else
            {
                MessageBox.Show("抽奖已完成！");
            }
            #endregion
        }
 
        /// <summary>
        /// 显示 抽奖 Label 委托信息
        /// </summary>
        /// <param name="str"></param>
        private delegate void myDelegate(Label lb, string str);
        private void DispInfo(Label lb, string str)
        {
            #region   委托事件显示label文本
            if (lb.InvokeRequired)
            {
                myDelegate md = new myDelegate(this.DispInfo);
                lb.Invoke(md, new object[] { lb, str });
            }
            else
            {
                lb.Text = str;
                lb.Refresh();
            }
            #endregion
        }
 
        private void Check_Draw_Model(int draw_model)
        {
            #region   检测抽奖模式
            switch (draw_model)
            {
                case 1:
                    {
                        MessageBox.Show("当前抽奖模式为：幸运奖");
                        break;
                    }
                case 2:
                    {
                        MessageBox.Show("当前抽奖模式为：三等奖");
                        break;
                    }
                case 3:
                    {
                        MessageBox.Show("当前抽奖模式为：二等奖");
                        break;
                    }
                case 4:
                    {
                        MessageBox.Show("当前抽奖模式为：一等奖");
                        break;
                    }
                case 5:
                    {
                        MessageBox.Show("当前抽奖模式为：特等奖");
                        break;
                    }
                case 6:
                    {
                        MessageBox.Show("当前抽奖模式为：单独重新抽奖模式");
                        break;
                    }
                case 0:
                    {
                        MessageBox.Show("当前抽奖模式还没有开始!");
                        break;
                    }
            }
            #endregion
        }
 
        /// <summary>
        /// 载入当前抽奖模式参数
        /// </summary>
        /// <param name="Draw_Model"></param>
        private void Loac_Draw_Data(int Draw_Model)
        {
            #region   载入当前抽奖模式参数
            string Query_Draw_Model = string.Format("select award_level,times,per_count,times_record from data_setup where award_level={0}", Draw_Model);
            OleDbDataReader dr = db.SqlGetDataReader(Query_Draw_Model);
            if (dr.Read())
            {
                if (Convert.ToInt32(dr["times_record"].ToString()) > 0)
                {
                    Draw_Model_Times = Convert.ToInt32(dr["times"].ToString());
                    Per_Count = Convert.ToInt32(dr["per_count"].ToString());
                    Draw_Model_Times_Temp = Convert.ToInt32(dr["times_record"].ToString());
                }
                else
                {
                    Draw_Model_Times = Convert.ToInt32(dr["times"].ToString());
                    Per_Count = Convert.ToInt32(dr["per_count"].ToString());
                    Draw_Model_Times_Temp = 0;
                }
            }
            dr.Close();
            KillProcess();
            #endregion
        }
 
        private void but_min_Click(object sender, EventArgs e)
        {
            #region  最小化抽奖程序
            this.WindowState = FormWindowState.Minimized;
            #endregion
        }
 
        private void but_max_Click(object sender, EventArgs e)
        {
            #region   最大化抽奖程序
            if (this.WindowState == FormWindowState.Maximized)
            {
                this.WindowState = FormWindowState.Normal;
            }
            else
            {
                this.WindowState = FormWindowState.Maximized;
            }
            #endregion
        }
 
        private void Form1_KeyDown5555(object sender, KeyEventArgs e)
        {
            #region   快捷键调用
            switch (e.KeyData)
            {
                case Keys.F1:
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=1 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label1.Dock = System.Windows.Forms.DockStyle.None;
                            label1.Location = new System.Drawing.Point(160, 460);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 75);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\X.jpg");
                            Finish_Flag = false;
                            Single_Mode = false;
                            Draw_Model = 1;//幸运奖模式为1
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F2:
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=2 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label2.Dock = System.Windows.Forms.DockStyle.Top;
                            label1.Location = new System.Drawing.Point(145, 430);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 60);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\3.jpg");
                            Draw_Model = 2;
                            Single_Mode = false;
                            Finish_Flag = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F3:
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=3 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label2.Dock = System.Windows.Forms.DockStyle.Top;
                            label1.Location = new System.Drawing.Point(147, 450);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 60);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\2.jpg");
                            Draw_Model = 3;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F4:
                    {
                         string sql = string.Format("select use_flag from data_setup where award_level=4 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label2.Dock = System.Windows.Forms.DockStyle.None;
                            label1.Location = new System.Drawing.Point(120, 380);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\1.jpg");
                            Draw_Model = 4;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F5:
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=5 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label1.Location = new System.Drawing.Point(100, 400);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\T.jpg");
                            Draw_Model = 4;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                            Draw_Model = 5;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F6:
                    {
                        /*
                        strr = string.Empty;
                        label2.Text = string.Empty;
                        label1.Text = string.Empty;
                        label1.Visible = true;
                        label1.Location = new System.Drawing.Point(435, 356);
                        Finish_Flag = false;
                        Single_Mode = true;
                        Per_Count = 1;
                        */
                        break;
                    }
                case Keys.F7:
                    {
                        Init_Setup abc = new Init_Setup();
                        abc.ShowDialog();
                        break;
                    }
                case Keys.F8:
                    {
                        Show_Lucky_Number Show_Lucky_Number = new Show_Lucky_Number();
                        Show_Lucky_Number.ShowDialog();
                        break;
                    }
                case Keys.F9:
                    {
                        Array_Setup.Clear();
                        ////清空抽奖次数
                        string str1 = string.Format("update data_setup set [times_record]=0");
                        Array_Setup.Add(str1);
                        ////重置抽奖记录值标志
                        string str2 = string.Format("update data1 set [value]='0'");
                        string str22 = string.Format("update data1_1 set [value]='0'");
                        Array_Setup.Add(str2);
                        Array_Setup.Add(str22);
                        ////清空获奖名单
                        string str3 = string.Format("delete * from  data2");
                        string str33 = string.Format("delete * from  data2_2");
                        Array_Setup.Add(str3);
                        Array_Setup.Add(str33);
                        if (db.SqlExeSqlTran(Array_Setup) == 1)
                        {
                            Draw_Model = 1; //抽奖模拟式
                            Loac_Draw_Data(Draw_Model);
                            Finish_Flag = false;
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label1.Location = new System.Drawing.Point(150, 460);
                            label1.Dock = System.Windows.Forms.DockStyle.None;
                            this.label1.Font = new System.Drawing.Font("宋体", 75);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\X.jpg");
                            MessageBox.Show("重置成功!");
                            return;
                        }
                        else
                        {
                            MessageBox.Show("重置失败!");
                            return;
                        }
                        break;
                    }
                case Keys.Enter:
                    {
                        button2.Focus();
                        break;
                    }
                case Keys.Space:
                    {
                        button2.Focus();
                        break;
                    }
                case Keys.Escape:
                    {
                        this.Close();
                        break;
                    }
            }
            #endregion
        }
 
        private void but_clo_Click(object sender, EventArgs e)
        {
            #region   关闭抽奖程序
            this.Close();
            #endregion
        }
 
         
        /// <summary>
        /// 快速释放内存资源
        /// </summary>
        public void KillProcess()
        {
            #region 快速释放内存资源
            System.Diagnostics.Process.GetCurrentProcess().MinWorkingSet = new System.IntPtr(5);
            #endregion
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            #region   线程抽奖开始
            switch (Single_Mode)
            {
                case false:
                    {
                        if (Draw_Model_Times_Temp >= Draw_Model_Times)
                        {
                            Finish_Flag = true;
                            show_number(Draw_Model);
                            label1.Text = string.Empty;
                            label1.Visible = false;
                            return;
                        }
                        else
                        {
                            string file_pathe = "./sound/11.wma";
                            PlayingMedia(file_pathe);
                            label2.Text = string.Empty;
                            label1.Visible = true;
                            button1.Enabled = false;
                            button2.Enabled = true;
                            th = new Thread(new ThreadStart(test));
                            th.IsBackground = true;
                            th.Start();
                        }
                        button2.Focus();
                        KillProcess();
                        break;
                    }
                case true:
                    {
                        string file_pathe = "./sound/11.wma";
                        PlayingMedia(file_pathe);
                        label2.Text = string.Empty;
                        label1.Visible = true;
                        button1.Enabled = false;
                        button2.Enabled = true;
                        th = new Thread(new ThreadStart(test));
                        th.IsBackground = true;
                        th.Start();
                        button2.Focus();
                        KillProcess();
                        break;
                    }
            }
 
 
 
            #endregion
        }
 
        private void button2_Click(object sender, EventArgs e)
        {
            #region   线程抽奖结束
            pauseOperation();
            strr = string.Empty;
            Array_Lucky_Number.Clear();
            Array_SQL.Clear();
            button1.Enabled = true;
            Exflag = false;
            th.Abort();
            show_number_1(arrnum, strr, label1);
            switch (Draw_Model)
            {
                case 1:
                    {
                        if (Single_Mode == false)
                        {
                            string[] str4 = System.Text.RegularExpressions.Regex.Split(strr, @"[ ] ");
                            foreach (string i in str4)
                            {
                                int Number1 = Convert.ToInt32(i);
                                if (Number1 % 2 != 0)
                                {
                                    string Update_Lucky_Number = string.Format("update data1 set [value]='1' where MsgContent mod 2 <>0 and flag <>'0'");
                                    Array_SQL.Add(Update_Lucky_Number);
                                }
                                else
                                {
                                    string Update_Lucky_Number = string.Format("update data1 set [value]='1' where MsgContent mod 2=0 and flag <>'0'");
                                    Array_SQL.Add(Update_Lucky_Number);
                                }
                            }
                        }
                        else
                        {
                            string[] str4 = System.Text.RegularExpressions.Regex.Split(strr, @"[ ] ");
                            foreach (string i in str4)
                            {
                                Array_Lucky_Number.Add(i);
                            }
                        }
                        break;
                    }
                case 2:
                    {
                        if (Single_Mode == false)
                        {
                            string str = string.Empty;
                            string str2 = string.Empty;
                            for (int i = 0; i < arrnum.Count; i  )
                            {
                                if (i >= 5)
                                {
                                    str  = dTable.Rows[Convert.ToInt32(arrnum[i])][0].ToString()   " ";
                                }
                                else
                                {
                                    str2  = dTable.Rows[Convert.ToInt32(arrnum[i])][0].ToString()   " ";
                                }
                            }
                            string[] str4 = System.Text.RegularExpressions.Regex.Split(strr, @"[ ] ");
                            foreach (string i in str4)
                            {
                                Array_Lucky_Number.Add(i);
                            }
 
                        }
                        else
                        {
                        }
                        break;
                    }
                case 3:
                    {
                        if (Single_Mode == false)
                        {
                            string str = string.Empty;
                            string str2 = string.Empty;
                            for (int i = 0; i < arrnum.Count; i  )
                            {
                                if (i >= 5)
                                {
                                    str  = dTable.Rows[Convert.ToInt32(arrnum[i])][0].ToString()   " ";
                                }
                                else
                                {
                                    str2  = dTable.Rows[Convert.ToInt32(arrnum[i])][0].ToString()   " ";
                                }
                            }
                            string[] str4 = System.Text.RegularExpressions.Regex.Split(strr, @"[ ] ");
                            foreach (string i in str4)
                            {
                                Array_Lucky_Number.Add(i);
                            }
                        }
                        else
                        {
                        }
                        break;
                    }
                case 4:
                    {
                        if (Single_Mode == false)
                        {
                            string[] str4 = System.Text.RegularExpressions.Regex.Split(strr, @"[ ] ");
                            foreach (string i in str4)
                            {
                                Array_Lucky_Number.Add(i);
                            }
 
                        }
                        else
                        {
                        }
                        break;
                    }
                case 5:
                    {
                        if (Single_Mode == false)
                        {
                            string[] str4 = System.Text.RegularExpressions.Regex.Split(strr, @"[ ] ");
                            foreach (string i in str4)
                            {
                                Array_Lucky_Number.Add(i);
                            }
                        }
                        else
                        {
                        }
                        break;
                    }
                case 6:
                    {
                        if (Single_Mode == false)
                        {
                        }
                        else
                        {
                        }
                        break;
                    }
            }
            switch (Single_Mode)
            {
                case false:
                    {
                        Draw_Model_Times_Temp  ;
                        //////写入抽取记录
                        string Write_Record = string.Format("update data_setup set [times_record]=[times_record] 1 where [award_level]={0}", Draw_Model);
                        Array_SQL.Add(Write_Record);
                        if (Array_Lucky_Number.Count > 0)
                        {
                            for (int i = 0; i < Array_Lucky_Number.Count; i  )
                            {
                                string Write_Lucky_Number = string.Format("insert into data2 values({0},'{1}','{2}')", Array_Lucky_Number[i], Array_Lucky_Number[i], Draw_Model);
                                string Update_Lucky_Number = string.Format("update data1 set [value]='1' where [msgcontent]={0}", Array_Lucky_Number[i]);
                                Array_SQL.Add(Write_Lucky_Number);
                                Array_SQL.Add(Update_Lucky_Number);
                            }
                            db.SqlExeSqlTran(Array_SQL);
                        }
                        else
                        {
                            db.SqlExeSqlTran(Array_SQL);
                            string Write_Lucky_Number1 = string.Format("insert into data2 (lucky_number,name,award_level) select MsgContent,ManName,'{0}' from data1 where value='1'", Draw_Model);
                            //Array_SQL.Add(Write_Lucky_Number);
                            db.SqlExSql(Write_Lucky_Number1);
                        }
                        
                        break;
                    }
                case true:
                    {
                        if (Draw_Model != 1)
                        {
                            Draw_Model_Times_Temp  ;
                            //////写入抽取记录
                            for (int i = 0; i < Array_Lucky_Number.Count; i  )
                            {
                                string Write_Lucky_Number = string.Format("insert into data2 values({0},'{1}','{2}')", Array_Lucky_Number[i], Array_Lucky_Number[i], Draw_Model);
                                string Update_Lucky_Number = string.Format("update data1_1 set [value]='1' where [msgcontent]={0}", Array_Lucky_Number[i]);
                                Array_SQL.Add(Write_Lucky_Number);
                                Array_SQL.Add(Update_Lucky_Number);
                            }
                        }
                        else
                        {
                            Draw_Model_Times_Temp  ;
                            //////写入抽取记录
                            for (int i = 0; i < Array_Lucky_Number.Count; i  )
                            {
                                string Write_Lucky_Number = string.Format("insert into data2_2 values({0},'{1}','{2}')", Array_Lucky_Number[i], Array_Lucky_Number[i], Draw_Model);
                                string Update_Lucky_Number = string.Format("update data1_1 set [value]='1' where [msgcontent]={0}", Array_Lucky_Number[i]);
                                Array_SQL.Add(Write_Lucky_Number);
                                Array_SQL.Add(Update_Lucky_Number);
                            }
                        }
                        db.SqlExeSqlTran(Array_SQL);
                        break;
                    }
            }
            button2.Enabled = false;
            button1.Focus();
            KillProcess();
 
            #endregion
        }
 
        private void timer1_Tick(object sender, EventArgs e)
        {
            #region   定时循环播放音乐
            if (MediaPlayer.playState == WMPLib.WMPPlayState.wmppsStopped)
            {
                MediaPlayer.play();
 
            }
            KillProcess();
            #endregion
        }
 
        private void Form1_KeyDown(object sender, KeyEventArgs e)
        {
            #region   快捷键调用
            switch (e.KeyData)
            {
                case Keys.F1://二等奖、安慰奖
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=1 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label1.Dock = System.Windows.Forms.DockStyle.None;
                            label1.Location = new System.Drawing.Point(270, 350);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\X.jpg");
                            Finish_Flag = false;
                            Single_Mode = false;
                            Draw_Model = 1;//幸运奖模式为1
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F2://三等奖
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=2 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label2.Dock = System.Windows.Forms.DockStyle.Top;
                            label1.Location = new System.Drawing.Point(30, 360);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 75);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\3.jpg");
                            Draw_Model = 2;
                            Single_Mode = false;
                            Finish_Flag = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F3://二等奖
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=3 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label2.Dock = System.Windows.Forms.DockStyle.Top;
                            label1.Location = new System.Drawing.Point(50, 350);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\2.jpg");
                            Draw_Model = 3;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F4://一等奖
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=4 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label2.Dock = System.Windows.Forms.DockStyle.None;
                            label1.Location = new System.Drawing.Point(270, 350);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\1.jpg");
                            Draw_Model = 4;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F5://特等奖
                    {
                        string sql = string.Format("select use_flag from data_setup where award_level=5 ");
                        OleDbDataReader dr = db.SqlGetDataReader(sql);
                        dr.Read();
                        if (dr["use_flag"].ToString().Equals("1"))
                        {
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label1.Location = new System.Drawing.Point(100, 400);
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\T.jpg");
                            Draw_Model = 4;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                            Draw_Model = 5;
                            Finish_Flag = false;
                            Single_Mode = false;
                            Loac_Draw_Data(Draw_Model);
                        }
                        else
                        {
                            return;
                        }
                        break;
                    }
                case Keys.F6:
                    {
                        /*
                        strr = string.Empty;
                        label2.Text = string.Empty;
                        label1.Text = string.Empty;
                        label1.Visible = true;
                        label1.Location = new System.Drawing.Point(435, 356);
                        Finish_Flag = false;
                        Single_Mode = true;
                        Per_Count = 1;
                        */
                        break;
                    }
                case Keys.F7:
                    {
                        Init_Setup abc = new Init_Setup();
                        abc.ShowDialog();
                        break;
                    }
                case Keys.F8:
                    {
                        Show_Lucky_Number Show_Lucky_Number = new Show_Lucky_Number();
                        Show_Lucky_Number.ShowDialog();
                        break;
                    }
                case Keys.F9:
                    {
                        Array_Setup.Clear(); //清空抽奖次数
                        string str1 = string.Format("update data_setup set [times_record]=0");
                        Array_Setup.Add(str1); //重置抽奖记录值标志
                        string str2 = string.Format("update data1 set [value]='0'");
                        string str22 = string.Format("update data1_1 set [value]='0'");
                        Array_Setup.Add(str2);
                        Array_Setup.Add(str22);//清空获奖名单
                        string str3 = string.Format("delete * from  data2");
                        string str33 = string.Format("delete * from  data2_2");
                        Array_Setup.Add(str3);
                        Array_Setup.Add(str33);
                        if (db.SqlExeSqlTran(Array_Setup) == 1)
                        {
                            Draw_Model = 1; //抽奖模拟式
                            Loac_Draw_Data(Draw_Model);
                            Finish_Flag = false;
                            strr = string.Empty;
                            label2.Text = string.Empty;
                            label1.Text = string.Empty;
                            label1.Visible = true;
                            label1.Location = new System.Drawing.Point(270, 350);
                            label1.Dock = System.Windows.Forms.DockStyle.None;
                            this.label1.Font = new System.Drawing.Font("方正综艺简体", 180);
                            this.BackgroundImage = System.Drawing.Image.FromFile(Application.StartupPath   @"\\img\\X.jpg");
                            MessageBox.Show("重置成功!");
                            //return;
                        }
                        else
                        {
                            MessageBox.Show("重置失败!");
                            //return;
                        }
                        break;
                    }
                     
                case Keys.Enter:
                    {
                        button2.Focus();
                        break;
                    }
                case Keys.Space:
                    {
                        button2.Focus();
                        break;
                    }
                case Keys.Escape:
                    {
                        this.Close();
                        break;
                    }
            }
            #endregion
        }
 
        private void show_number(int DrawMode)
        {
            #region   完成抽奖后显示号码
            string Query_Lucky_Number = string.Empty;
            Query_Lucky_Number = string.Format("select lucky_number,name from data2 where award_level='{0}'", DrawMode);
            DataTable dt = db.SqlDataTable(Query_Lucky_Number);
            string sstr = string.Empty;
            switch (Draw_Model)
            {
                case 1:
                    {
                        label2.Dock = System.Windows.Forms.DockStyle.None;
                        label2.Location = new System.Drawing.Point(170, 320);
                        this.label2.Font = new System.Drawing.Font("方正综艺简体", 40);
                        int lucky_number = Convert.ToInt32(dt.Rows[0][0].ToString());
                        if (lucky_number % 2 == 0)
                        {
                            sstr = "恭喜你，抽奖卷号码尾数为："
                                  "\n"   "          0，2，4，6，8 "
                                  "\n"   "             的观众获得"
                                  "\n"   "                安慰奖！";
                        }
                        else
                        {
                            sstr = "恭喜你，抽奖卷号码尾数为："
                                  "\n"   "          1，3，5，7，9 "
                                  "\n"   "             的观众获得"
                                  "\n"   "                安慰奖！";
                        }
                    }
                    break;
                case 2://公布三等奖名单
                    {
                        label2.Dock = System.Windows.Forms.DockStyle.None;
                        label2.Location = new System.Drawing.Point(30, 360);
                        this.label2.Font = new System.Drawing.Font("方正综艺简体", 75);
                        for (int i = 0; i < dt.Rows.Count; i  )
                        {
                            int s = i   1;
                            if (s % 5 == 0)
                            {
                                sstr  = dt.Rows[i][0].ToString().PadLeft(3, '0')   " \n";
                            }
                            else
                            {
                                sstr  = dt.Rows[i][0].ToString().PadLeft(3, '0')   " ";
                            }
 
                        }
                    }
                    break;
                case 3://公布二等奖名单
                    {
                        label2.Dock = System.Windows.Forms.DockStyle.None;
                        label2.Location = new System.Drawing.Point(50, 350);
                        this.label2.Font = new System.Drawing.Font("方正综艺简体", 180);
                        for (int i = 0; i < dt.Rows.Count; i  )
                        {
                            int s = i   1;
                            if (s % 5 == 0)
                            {
                                sstr  = dt.Rows[i][0].ToString().PadLeft(3, '0')   " \n";
                            }
                            else
                            {
                                sstr  = dt.Rows[i][0].ToString().PadLeft(3, '0')   " ";
                            }
 
                        }
                    }
                    break;
                case 4://公布一等奖名单
                    {
                        label2.Dock = System.Windows.Forms.DockStyle.None;
                        label2.Location = new System.Drawing.Point(270, 350);
                        this.label2.Font = new System.Drawing.Font("方正综艺简体", 180);
                        for (int i = 0; i < dt.Rows.Count; i  )
                        {
                            sstr  = dt.Rows[i][0].ToString().PadLeft(3, '0')   " \n";
                        }
                    }
                    break;
                case 5://公布特等奖名单
                    {
                        label2.Dock = System.Windows.Forms.DockStyle.None;
                        label2.Location = new System.Drawing.Point(100, 400);
                        this.label2.Font = new System.Drawing.Font("方正综艺简体", 180);
                        for (int i = 0; i < dt.Rows.Count; i  )
                        {
                            sstr  = dt.Rows[i][0].ToString().PadLeft(3, '0')   " \n";
                        }
                    }
                    break;
                case 6:
                    {
                        label2.Dock = System.Windows.Forms.DockStyle.None;
                        label2.Location = new System.Drawing.Point(164, 176);
 
                    }
                    break;
            }
            label2.Text = sstr;
            #endregion
        }
    }
 
}
标签： 年会抽奖
实例下载地址

年会抽奖（带抽奖音效,access数据库）

点此下载实例
不能下载？内容有错？点击这里报错 + 投诉 + 提问
好例子网口号：伸出你的我的手 — 分享！
网友评论

我要评论
小贴士

感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网

本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见版权及免责申明
年会抽奖（带抽奖音效,access数据库）

同类人气实例

实例介绍

实例下载地址

年会抽奖（带抽奖音效,access数据库）

相关软件

相关文章

网友评论

小贴士

关于好例子网

下载周排行

下载总排行
