private long FindWinMoney(int i, UserNumbers userLottoItem)
{
long money = 0;
using (SqlConnection con = DBConnection.Connecting())
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SelectWinMoney";
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
if (userLottoItem.Turnnumber == int.Parse(sdr["turnnumber"].ToString()))
{
money = int.Parse(sdr["win" + i].ToString());
}
}
}
return(money);
}
private void btnResist_Click(object sender, EventArgs e) // 등록 버튼 클릭 이벤트 처리
{
UserNumbers uNumbers = new UserNumbers();
try
{
if (Int32.Parse(cbxTurnNum.Text) <= Form1.newTurnNum && cbxTurnNum.Text != null)
{
uNumbers.Turnnumber = int.Parse(cbxTurnNum.Text);
uNumbers.Num1 = int.Parse(selectedNums[0].ToString());
uNumbers.Num2 = int.Parse(selectedNums[1].ToString());
uNumbers.Num3 = int.Parse(selectedNums[2].ToString());
uNumbers.Num4 = int.Parse(selectedNums[3].ToString());
uNumbers.Num5 = int.Parse(selectedNums[4].ToString());
uNumbers.Num6 = int.Parse(selectedNums[5].ToString());
uNumbers.Id = user.Id;
using (SqlConnection con = DBConnection.Connecting())
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsertUserNumbers";
cmd.Parameters.AddWithValue("turnnumber", uNumbers.Turnnumber);
cmd.Parameters.AddWithValue("num1", uNumbers.Num1);
cmd.Parameters.AddWithValue("num2", uNumbers.Num2);
cmd.Parameters.AddWithValue("num3", uNumbers.Num3);
cmd.Parameters.AddWithValue("num4", uNumbers.Num4);
cmd.Parameters.AddWithValue("num5", uNumbers.Num5);
cmd.Parameters.AddWithValue("num6", uNumbers.Num6);
cmd.Parameters.AddWithValue("id", uNumbers.Id);
cmd.ExecuteNonQuery();
con.Close();
DisplayUserNumbers();
MessageBox.Show("등록 성공");
}
catch (Exception)
{
MessageBox.Show("등록 실패");
}
}
}
else
{
MessageBox.Show("회차를 선택해 주세요");
}
}
catch (Exception)
{
MessageBox.Show("숫자를 입력해 주세요");
}
}
private void ColorGridView(Color color, UserNumbers userLottoItem)
{
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if (int.Parse(item.Cells[0].Value.ToString()) == userLottoItem.LogNum)
{
foreach (DataGridViewCell item2 in item.Cells)
{
item2.Style.BackColor = color;
}
}
}
}
public void DisplayUserNumbers()
{
dataGridView1.DataSource = null;
dataGridView1.Columns.Clear();
userNumbersList.Clear();
using (SqlConnection con = DBConnection.Connecting())
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SelectUserNumbersById";
cmd.Parameters.AddWithValue("id", user.Id);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
UserNumbers userNumbers = new UserNumbers();
userNumbers.LogNum = int.Parse(sdr["logNum"].ToString());
userNumbers.Turnnumber = int.Parse(sdr["turnnumber"].ToString());
userNumbers.Num1 = int.Parse(sdr["num1"].ToString());
userNumbers.Num2 = int.Parse(sdr["num2"].ToString());
userNumbers.Num3 = int.Parse(sdr["num3"].ToString());
userNumbers.Num4 = int.Parse(sdr["num4"].ToString());
userNumbers.Num5 = int.Parse(sdr["num5"].ToString());
userNumbers.Num6 = int.Parse(sdr["num6"].ToString());
userNumbers.Id = user.Id;
userNumbersList.Add(userNumbers);
}
dataGridView1.DataSource = userNumbersList;
dataGridView1.Columns[0].HeaderText = "번호";
dataGridView1.Columns[1].HeaderText = "회차";
dataGridView1.Columns[2].HeaderText = "1구";
dataGridView1.Columns[3].HeaderText = "2구";
dataGridView1.Columns[4].HeaderText = "3구";
dataGridView1.Columns[5].HeaderText = "4구";
dataGridView1.Columns[6].HeaderText = "5구";
dataGridView1.Columns[7].HeaderText = "6구";
}
}
private void CalculateWin(int[] countHit, int[] countWin, UserNumbers userLottoItem)// 몇등 담첨됬는지 계산해주는 메서드
{
int sum = 0;
for (int i = 0; i < countHit.Length - 1; i++)
{
sum += countHit[i];
}
int winNum = 0;
if (sum == 6) // 1등 당첨
{
countWin[1 - 1] += 1;
winNum = 1;
}
else if (sum == 5 && countHit[7 - 1] == 1) // 2등 당첨
{
countWin[2 - 1] += 1;
winNum = 2;
}
else if (sum == 4) // 4등 당첨
{
countWin[4 - 1] += 1;
winNum = 3;
}
else if (sum == 5) // 3등 당첨
{
countWin[3 - 1] += 1;
winNum = 4;
}
else if (sum == 3) // 5등 당첨
{
countWin[5 - 1] += 1;
winNum = 5;
}
if (winNum == 1)
{
takeBackMoney += FindWinMoney(1, userLottoItem);
ColorGridView(Color.Red, userLottoItem);
}
else if (winNum == 2)
{
takeBackMoney += FindWinMoney(2, userLottoItem);
ColorGridView(Color.Blue, userLottoItem);
}
else if (winNum == 3)
{
takeBackMoney += FindWinMoney(3, userLottoItem);
ColorGridView(Color.Green, userLottoItem);
}
else if (winNum == 4)
{
takeBackMoney += FindWinMoney(4, userLottoItem);
ColorGridView(Color.Orange, userLottoItem);
}
else if (winNum == 5)
{
takeBackMoney += FindWinMoney(5, userLottoItem);
ColorGridView(Color.Yellow, userLottoItem);
}
lblHitNum.Text = "";
for (int i = 0; i < countWin.Length; i++)
{
lblHitNum.Text += (i + 1) + "등 : " + countWin[i] + "\r\n";
}
}
