private void ParsingLotto(HtmlAgilityPack.HtmlDocument htmlDoc) // 원하는 회차를 파싱해서 로또 객체에 저장후 List에 넣어줌
{
string[] temp = new string[7];
Lotto lotto = new Lotto();
int i = 0;
foreach (HtmlNode item in htmlDoc.DocumentNode.SelectNodes("//body//div//section//div//div//div//div//div//div//p//span"))
{
temp[i] = item.InnerText;
i++;
}
foreach (var item in htmlDoc.DocumentNode.SelectNodes("//body//h4//strong"))
{
lotto.TurnNumber = Int32.Parse(item.InnerText.Remove(item.InnerText.Length - 1, 1));
}
lotto.Num1 = Int32.Parse(temp[0]);
lotto.Num2 = Int32.Parse(temp[1]);
lotto.Num3 = Int32.Parse(temp[2]);
lotto.Num4 = Int32.Parse(temp[3]);
lotto.Num5 = Int32.Parse(temp[4]);
lotto.Num6 = Int32.Parse(temp[5]);
lotto.BonusNum = Int32.Parse(temp[6]);
lottoList.Add(lotto);
}
private void Parsing(HtmlAgilityPack.HtmlDocument htmlDoc) // 원하는 회차를 파싱해서 로또 객체에 저장후 List에 넣어줌
{
string[] temp = new string[6];
Lotto lotto = new Lotto();
foreach (var item in htmlDoc.DocumentNode.SelectNodes("//body//p"))
{
if (item.GetAttributeValue("class", "") == "number")
{
int i = 0;
foreach (var item2 in item.ChildNodes)
{
if (item2.Name == "img")
{
temp[i] = item2.Attributes["alt"].Value;
i++;
}
foreach (var item3 in item2.ChildNodes)
{
if (item3.Name == "img")
{
lotto.BonusNum = Int32.Parse(item3.Attributes["alt"].Value);
}
}
}
}
}
foreach (var item in htmlDoc.DocumentNode.SelectNodes("//body//h3//strong"))
{
lotto.TurnNumber = Int32.Parse(item.InnerText);
}
lotto.Num1 = Int32.Parse(temp[0]);
lotto.Num2 = Int32.Parse(temp[1]);
lotto.Num3 = Int32.Parse(temp[2]);
lotto.Num4 = Int32.Parse(temp[3]);
lotto.Num5 = Int32.Parse(temp[4]);
lotto.Num6 = Int32.Parse(temp[5]);
lottoList.Add(lotto);
}
private void DisplayLottoList() // LottoDB에서 전체 내용을 가져와 List에 저장후 DataGridView에 보여준다
{
lottoList.Clear();
LottoGridView.Columns.Clear();
LottoGridView.DataSource = null;
using (SqlConnection con = DBConnection.Connecting())
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SelectLotto";
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
Lotto lotto = new Lotto(Int32.Parse(sdr["turnnumber"].ToString()), Int32.Parse(sdr["num1"].ToString()), Int32.Parse(sdr["num2"].ToString()), Int32.Parse(sdr["num3"].ToString()), Int32.Parse(sdr["num4"].ToString()), Int32.Parse(sdr["num5"].ToString()), Int32.Parse(sdr["num6"].ToString()), Int32.Parse(sdr["bonusnum"].ToString()));
lottoList.Add(lotto); //
if (Int32.Parse(sdr["turnnumber"].ToString()) == newTurnNum)
{
lblCurrentLottoNum.Text = lotto.TurnNumber + "회차 : " + lotto.Num1 + " " + lotto.Num2 + " " + lotto.Num3 + " " + lotto.Num4 + " " + lotto.Num5 + " " + lotto.Num6 + " 보너스 번호 : " + lotto.BonusNum + "";
}
}
}
LottoGridView.DataSource = lottoList;
LottoGridView.Columns[0].HeaderText = "회차";
LottoGridView.Columns[1].HeaderText = "1구";
LottoGridView.Columns[2].HeaderText = "2구";
LottoGridView.Columns[3].HeaderText = "3구";
LottoGridView.Columns[4].HeaderText = "4구";
LottoGridView.Columns[5].HeaderText = "5구";
LottoGridView.Columns[6].HeaderText = "6구";
LottoGridView.Columns[7].HeaderText = "보너스구";
}
static void Main(string[] args)
{
for (int i = 0; i < 10; i++)
{
Coupon c1 = new CouponRandom();
Console.WriteLine(c1.showNumber());
Lotto lotto1 = new Lotto();
Console.WriteLine("\nTrafiłes " + lotto1.game(c1) + " liczb");
Console.WriteLine("#############################");
}
int tryGet6 = 0;
Coupon c3 = new CouponRandom();
Lotto lotto2 = new Lotto();
Console.WriteLine("\nPróbuję trafić 6 liczb...");
do
{
c3.fill();
tryGet6++;
} while (lotto2.game(c3) != 6);
Console.Write("Trafiono 6 liczb za " + tryGet6 + " razem");
Console.ReadKey();
}
