private void Init_lottery_result_list(List <Lottery_result> lr_list)
{
Lottery_resultTableAdapter adpter = new Lottery_resultTableAdapter();
Lottery.Lottery_resultDataTable table = adpter.GetData();
foreach (Lottery.Lottery_resultRow row in table.Rows)
{
Lottery_result lr = new Lottery_result()
{
Date = row.Date,
Id = row.Id,
Red_nums = new int[]
{
row.Red_nums01,
row.Red_nums02,
row.Red_nums03,
row.Red_nums04,
row.Red_nums05,
row.Red_nums06
},
Blue_num = row.Blue_num
};
lr_list.Add(lr);
}
}
private void Save_all_results(List <Lottery_result> lr_list)
{
Lottery_resultTableAdapter adpter = new Lottery_resultTableAdapter();
adpter.Adapter.DeleteCommand = adpter.Connection.CreateCommand();
adpter.Adapter.DeleteCommand.CommandText = "delete from [Lottery_result] where 1";
adpter.Connection.Open();
SQLiteTransaction transaction = adpter.Connection.BeginTransaction();
adpter.Adapter.DeleteCommand.ExecuteNonQuery();
foreach (Lottery_result item in lr_list)
{
adpter.Insert(
item.Id,
item.Date,
item.Red_nums[0],
item.Red_nums[1],
item.Red_nums[2],
item.Red_nums[3],
item.Red_nums[4],
item.Red_nums[5],
item.Blue_num
);
}
transaction.Commit();
adpter.Connection.Close();
}
