C#抽名软件主体设计

女爷i 2022-08-07 14:59 10阅读 0赞

using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Text;
    using System.Windows.Forms;
    using System.Data.OleDb;
    using System.IO;
    
    namespace select3
    {
        public partial class Form2 : Form
        {
            int j, x, rg,f1=1,f2=1,f3=1,flag1=0,flag2=0,flag3=0;
            int[] ji = new int[22] {0, 1, 2, 3, 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21};
            int[] ji_y = new int[22];
            int[] xi = new int[9] {0, 59,60,61,62,63,64,65,66 };
            int[] xi_y = new int[9];
            int[] ru = new int[38] { 0,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58 };
            int[] ru_y = new int[38];
            string ls;
            int length1 = 22;
            int length2 = 9; int length3 = 38; int n;
            public Form2()
            {
                InitializeComponent();
            }
            private void del(int []a,int length,int n)
            {
                int flag=100;
                for(int i=1;i<length;i++)
                {
                    if (a[i] == n)
                    {
                        flag = i;
                    }
                }
                for (int j = flag; j < length-1; j++)
                {
                    a[j] = a[j + 1];
                }
            }
            private void init1()//信管初始化
            {
                StreamReader sreader = new StreamReader("H:\\save\\2.txt", Encoding.Default);
                string strline = string.Empty;
                while ((strline = sreader.ReadLine()) != null)
                {
                    n = Convert.ToInt32(strline);
                    del(xi, length2, n);
                    length2--;
                    flag1++;
                }
                sreader.Close();
                if (flag1 == 8)
                {
                    FileStream fs = File.Create("H:\\save\\2.txt");
                    fs.Close();
                    xi[0] = 0;
                    for (int i = 1; i < 9; i++)
                    {
                        xi[i] = i + 58;
                    }
                    length2 = 9;
                }
            }
            private void init2()//计科初始化
            {
                StreamReader sreader = new StreamReader("H:\\save\\1.txt", Encoding.Default);
                string strline = string.Empty;
                while ((strline = sreader.ReadLine()) != null)
                {
                    n = Convert.ToInt32(strline);
                    del(ji, length1, n);
                    length1--;
                    flag2++;
                }
                sreader.Close();
                if (flag2 == 21)
                {
                    FileStream fs = File.Create("H:\\save\\1.txt");
                    fs.Close();
                    ji[0] = 0;
                    for (int i = 1; i < 22; i++)
                    {
                        ji[i] = i + 0;
                    }
                    length1 = 22;
                }
            }
            private void init3()//软工初始化
            {
                StreamReader sreader = new StreamReader("H:\\save\\3.txt", Encoding.Default);
                string strline = string.Empty;
                while ((strline = sreader.ReadLine()) != null)
                {
                    n = Convert.ToInt32(strline);
                    del(ru, length3, n);
                    length3--;
                    flag3++;
                }
                sreader.Close();
                if (flag3== 38)
                {
                    FileStream fs = File.Create("H:\\save\\3.txt");
                    fs.Close();
                    ru[0] = 0;
                    for (int i = 1; i < 38; i++)
                    {
                        ji[i] = i + 21;
                    }
                    length3 = 38;
                }
            }
            
    
            private void Form2_Load(object sender, EventArgs e)
            {
                postion();
                string myconntion = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\save\\student.mdb";
                OleDbConnection mycon = new OleDbConnection(myconntion);
                string sql = "select * from table2";
                OleDbCommand mycmd = new OleDbCommand(sql, mycon);
                mycon.Open();
                OleDbDataReader odata = mycmd.ExecuteReader();
                if (odata.HasRows)
                {
                    while (odata.Read())
                    {
                        j = int.Parse(odata[4].ToString());
                        if (j == 0)
                        {
                            j = 21;
                        }
                        x = int.Parse(odata[5].ToString());
                        if (x == 58)
                        {
                            x = 66;
                        }
                        rg = int.Parse(odata[6].ToString());
                        if (rg == 21)
                        {
                            rg = 58;
                        }
    
                    }
                }
                init1();
                init2();
                init3();
            }
            private void postion()//设置开始位置！
            {
                  Rectangle ScreenArea = System.Windows.Forms.Screen.GetBounds(this);
                  int width1 = ScreenArea.Width;
                  int height1 = ScreenArea.Height;
                  this.Left = width1 - 10;
                 // this.Top = height1 - 50;
                  this.TopMost = true;
            }
    
            private void Form2_MouseEnter(object sender, EventArgs e)//鼠标点进去的效果！
            {
                Rectangle ScreenArea = System.Windows.Forms.Screen.GetBounds(this);
                int width1 = ScreenArea.Width;
                int height1 = ScreenArea.Height;
                this.Left = width1 - this.Width;
            }
    
            private void button3_Click(object sender, EventArgs e)//让窗体缩回去的按钮
            {
                postion();
            }
    
            private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
            {
                comboBox1.Text = comboBox1.SelectedItem.ToString();
            }
    
            private void button1_Click(object sender, EventArgs e)
            {
    
                string myconntion = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\save\\student.mdb";
                OleDbConnection mycon = new OleDbConnection(myconntion);
                mycon.Open();
                Random r = new Random();
                if (comboBox1.Text == "计算机科学与技术")
                {
                    try
                    {
                        int id = r.Next(1, j);
                        string s = ji[id].ToString();
                        string sql = @"select * from table1 where id='" + s + "'";
                        OleDbCommand mycmd = new OleDbCommand(sql, mycon);
                        OleDbDataReader odata = mycmd.ExecuteReader();
                        if (odata.Read())
                        {
                            ls = odata["name"].ToString();
                            ji_y[f1++] = ji[id];
                            ji[id] = ji[j];
                            j--;
                        }
                        string sql1 = "update table2 set j='" + j + "'";
                        OleDbCommand cdd = new OleDbCommand(sql1, mycon);
                        cdd.ExecuteNonQuery();
                        Form3 frm = new Form3(comboBox1.Text, ls);
                        frm.Show();
                 
                    }
                    catch (Exception)
                    {
                        MessageBox.Show(comboBox1.Text + "已经抽完了", "温馨提示！");
                        comboBox1.Items.Remove("计算机科学与技术");
                    }
                }
                else if (comboBox1.Text == "信息管理")
                {
                    try
                    {
                        int id = r.Next(1, x - 58);
                        string s = xi[id].ToString();
                        string sql = @"select * from table1 where id='" + s + "'";
                        OleDbCommand mycmd = new OleDbCommand(sql, mycon);
                        OleDbDataReader odata = mycmd.ExecuteReader();
                        if (odata.Read())
                        {
                            ls = odata["name"].ToString();
                            xi_y[f2++] = xi[id];
                            xi[id] = xi[x - 58];
                            x--;
                        }
                        string sql1 = "update table2 set x='" + x + "'";
                        OleDbCommand cdd = new OleDbCommand(sql1, mycon);
                        cdd.ExecuteNonQuery();
                        Form3 frm = new Form3(comboBox1.Text, ls);
                        frm.Show();
                 
    
                    }
                    catch (Exception)
                    {
                        MessageBox.Show(comboBox1.Text + "已经抽完了！", "温馨提示");
                        comboBox1.Items.Remove("信息管理");
                    }
    
                }
                else if (comboBox1.Text == "软件工程")
                {
                    try
                    {
                        int id = r.Next(1, rg - 21);
                        string s = ru[id].ToString();
                        string sql = @"select * from table1 where id='" + s + "'";
                        OleDbCommand mycmd = new OleDbCommand(sql, mycon);
                        OleDbDataReader odata = mycmd.ExecuteReader();
                        if (odata.Read())
                        {
                            ls = odata["name"].ToString();
                            ru_y[f3++] = ru[id];
                            ru[id] = ru[rg - 21];
                            rg--;
                        }
                        string sql1 = "update table2 set r='" + rg + "'";
                        OleDbCommand cdd = new OleDbCommand(sql1, mycon);
                        cdd.ExecuteNonQuery();
                        Form3 frm = new Form3(comboBox1.Text, ls);
                        frm.Show();
    
                    }
                    catch (Exception)
                    {
                        MessageBox.Show(comboBox1.Text + "已经抽完了！", "温馨提示");
                        comboBox1.Items.Remove("软件工程");
                    }
                }
            }
    
            private void button2_Click(object sender, EventArgs e)
            {
                string myconntion = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\save\\student.mdb";
                OleDbConnection mycon = new OleDbConnection(myconntion);
                mycon.Open();
                string sql = "insert into table3 values('" + ls + "','" + comboBox1.Text + "','" + float.Parse(textBox1.Text) + "','" + System.DateTime.Now + "')";
                OleDbCommand cmd = new OleDbCommand(sql, mycon);
                cmd.ExecuteNonQuery();
            }
    
            private void Form2_FormClosed(object sender, FormClosedEventArgs e)
            {
                StreamWriter swriter =File.AppendText("H:\\save\\2.txt");
                for (int i = 1; i < f2; i++)
                {
                    swriter.Write(xi_y[i].ToString() + "\r\n");
                }
                swriter.Close();//信管保存数据
                StreamWriter swriter1 = File.AppendText("H:\\save\\1.txt");
                for (int i = 1; i < f1; i++)
                {
                    swriter1.Write(ji_y[i].ToString() + "\r\n");
                }
                swriter1.Close();
                StreamWriter swriter2 = File.AppendText("H:\\save\\3.txt");
                for (int i = 1; i < f3; i++)
                {
                    swriter2.Write(ru_y[i].ToString() + "\r\n");
                }
                swriter2.Close();
    
            }
    
        }
    }