Exemple #1
0
        private void RowAdd(DataTable dataTable, WebToDB RowAdd_wtd, string numBonus)
        {
            DataRow dr = dataTable.NewRow();

            dr["회차"] = RowAdd_wtd.DrwNo;
            int sum = RowAdd_wtd.No1 + RowAdd_wtd.No2 + RowAdd_wtd.No3 + RowAdd_wtd.No4 + RowAdd_wtd.No5 + RowAdd_wtd.No6 + RowAdd_wtd.BonusNo;

            if (sum >= 60)
            {
                dr["등수"] = 1;
            }
            else if (sum == 51)
            {
                dr["등수"] = 2;
            }
            else if (sum == 50)
            {
                dr["등수"] = 3;
            }
            else if (sum >= 40)
            {
                dr["등수"] = 4;
            }
            else if (sum >= 30)
            {
                dr["등수"] = 5;
            }

            dr["No1\n" + this.txtNo1.Text] = convert1or0(RowAdd_wtd.No1);
            dr["No2\n" + this.txtNo2.Text] = convert1or0(RowAdd_wtd.No2);
            dr["No3\n" + this.txtNo3.Text] = convert1or0(RowAdd_wtd.No3);
            dr["No4\n" + this.txtNo4.Text] = convert1or0(RowAdd_wtd.No4);
            dr["No5\n" + this.txtNo5.Text] = convert1or0(RowAdd_wtd.No5);
            dr["No6\n" + this.txtNo6.Text] = convert1or0(RowAdd_wtd.No6);
            dr["Bonus\n"] = convert1or0(RowAdd_wtd.BonusNo) + " " + numBonus;
            dataTable.Rows.Add(dr);
        }
Exemple #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            ExamineNum();//중복 검사
            #region 중복일때 초기화작업
            if (temp == true)
            {
                txtNo1.Text = txtNo2.Text = txtNo3.Text = txtNo4.Text = txtNo5.Text = txtNo6.Text = "";
                numList.Clear();
                DBGridView.DataSource = "";
                beforeList.Clear();
                return;
            }
            #endregion
            DataTable dataTable = new DataTable();

            #region 공백제거
            this.txtNo1.Text = this.txtNo1.Text.Replace(" ", "").Trim();
            this.txtNo2.Text = this.txtNo2.Text.Replace(" ", "").Trim();
            this.txtNo3.Text = this.txtNo3.Text.Replace(" ", "").Trim();
            this.txtNo4.Text = this.txtNo4.Text.Replace(" ", "").Trim();
            this.txtNo5.Text = this.txtNo5.Text.Replace(" ", "").Trim();
            this.txtNo6.Text = this.txtNo6.Text.Replace(" ", "").Trim();
            #endregion


            #region 데이터테이블 컬럼추가
            dataTable.Columns.Add("회차");
            dataTable.Columns.Add("등수");
            dataTable.Columns.Add("No1\n" + this.txtNo1.Text);
            dataTable.Columns.Add("No2\n" + this.txtNo2.Text);
            dataTable.Columns.Add("No3\n" + this.txtNo3.Text);
            dataTable.Columns.Add("No4\n" + this.txtNo4.Text);
            dataTable.Columns.Add("No5\n" + this.txtNo5.Text);
            dataTable.Columns.Add("No6\n" + this.txtNo6.Text);
            dataTable.Columns.Add("Bonus\n");

            #endregion


            DBGridView.DataSource = "";
            beforeList.Clear();
            string[] num = new string[] { this.txtNo1.Text, this.txtNo2.Text, this.txtNo3.Text, this.txtNo4.Text, this.txtNo5.Text, this.txtNo6.Text };
            #region 당첨여부 저장
            foreach (var item in WebToDB.dataLst)
            {
                wtd     = new WebToDB();
                wtd.No1 = wtd.No2 = wtd.No3 = wtd.No4 = wtd.No5 = wtd.No6 = wtd.BonusNo = 0;
                int[] numOX = new int[6]; //당첨여부에 대한 Array
                for (int i = 0; i < num.Length; i++)
                {
                    if (num[i] == item.No1 + "")
                    {
                        numOX[i] = 10;
                    }
                    else if (num[i] == item.No2 + "")
                    {
                        numOX[i] = 10;
                    }
                    else if (num[i] == item.No3 + "")
                    {
                        numOX[i] = 10;
                    }
                    else if (num[i] == item.No4 + "")
                    {
                        numOX[i] = 10;
                    }
                    else if (num[i] == item.No5 + "")
                    {
                        numOX[i] = 10;
                    }
                    else if (num[i] == item.No6 + "")
                    {
                        numOX[i] = 10;
                    }
                }
                string numBonus = "";
                wtd.No1 = numOX[0];
                wtd.No2 = numOX[1];
                wtd.No3 = numOX[2];
                wtd.No4 = numOX[3];
                wtd.No5 = numOX[4];
                wtd.No6 = numOX[5];

                if (wtd.No1 + wtd.No2 + wtd.No3 + wtd.No4 + wtd.No5 + wtd.No6 == 50)
                {
                    for (int i = 0; i < numOX.Length; i++)
                    {
                        if (numOX[i] == 0)
                        {
                            if (Int32.Parse(num[i]) == item.BonusNo)
                            {
                                numBonus    = num[i];
                                wtd.BonusNo = 1; //2,3등을 구분하기 위해 1로 저장
                            }
                        }
                    }
                }

                if (wtd.No1 + wtd.No2 + wtd.No3 + wtd.No4 + wtd.No5 + wtd.No6 > 21) // 5등이상 리스트에 저장
                {
                    wtd.DrwNo = item.DrwNo;
                    beforeList.Add(wtd);
                    RowAdd(dataTable, wtd, numBonus);//등수 매기기
                }
            }
            #endregion

            #region 컬럼 header 이름 변경
            DBGridView.DataSource          = dataTable;
            DBGridView.Columns["회차"].Width = 40;
            DBGridView.Columns["등수"].Width = 40;
            DBGridView.Columns["No1\n" + this.txtNo1.Text].Width = 40;
            DBGridView.Columns["No2\n" + this.txtNo2.Text].Width = 40;
            DBGridView.Columns["No3\n" + this.txtNo3.Text].Width = 40;
            DBGridView.Columns["No4\n" + this.txtNo4.Text].Width = 40;
            DBGridView.Columns["No5\n" + this.txtNo5.Text].Width = 40;
            DBGridView.Columns["No6\n" + this.txtNo6.Text].Width = 40;
            DBGridView.Columns["Bonus\n"].Width = 70;
            DBGridView.Sort(DBGridView.Columns["등수"], ListSortDirection.Ascending);
            #endregion
            //DBGridView.Sort
            txtNo1.Text = txtNo2.Text = txtNo3.Text = txtNo4.Text = txtNo5.Text = txtNo6.Text = "";
        }