public void selectHistory(clsDbInfo cDbInfo)
{
// 日付の選択
_form1.dateTimePicker1.Value =
DateTime.Parse(cDbInfo.strdate.Insert(4, "/").Insert(7, "/"));
// 会場の取得
if (!cDatabase.getDbDataDate(cDbInfo.strdate))
{
}
// 会場の選択
if (selectListBox1(cDbInfo.nameJyo))
{
}
// レースの取得
string strPlace = _form1.listBox1.SelectedItem.ToString();
if (!cDatabase.getDbDataPlace(cDbInfo.strdate, strPlace))
{
}
// レースの選択
if (selectListBox2(cDbInfo.racenum))
{
}
// 馬名の取得
if (!cDatabase.getDbDataBamei(cDbInfo.strdate, strPlace, cDbInfo.racenum))
{
}
}
private void btnGetJVData_Click(object sender, EventArgs e)
{
//var sw = new System.Diagnostics.Stopwatch();
//sw.Start();
cLog.writeLog("btnGetJVData_Click");
DateTime datetimeTarg = dateTimePicker1.Value;
string strDateTarg = datetimeTarg.ToString("yyyyMMdd");
string strPlace;
string strRace;
if (this.textBox1.Text == "")
{
System.Media.SystemSounds.Asterisk.Play();
MessageBox.Show("出力ファイルを保存するフォルダを選択してください。");
cOperateForm.enableButton();
return;
}
try
{
strPlace = listBox1.SelectedItem.ToString();
}
catch
{
System.Media.SystemSounds.Asterisk.Play();
MessageBox.Show("会場を選択してください。");
cOperateForm.enableButton();
return;
}
try
{
strRace = listBox2.SelectedItem.ToString();
}
catch
{
System.Media.SystemSounds.Asterisk.Play();
MessageBox.Show("レースを選択してください。");
cOperateForm.enableButton();
return;
}
UmatanOdds cUmatanOdds = new UmatanOdds(cCommon, cOperateForm, this);
cUmatanOdds.getUmatanOdds(strDateTarg, strPlace, strRace);
// 保持用
string codeJyo = cCommon.JyogyakuCord(strPlace.Substring(0, 2));
clsDbInfo cDbInfo = new clsDbInfo();
cDbInfo.strdate = strDateTarg;
cDbInfo.nameJyo = strPlace;
cDbInfo.racenum = strRace;
cDbInfo.raceId = strDateTarg + codeJyo + strRace;
cDatabase.putHistory(cDbInfo);
//sw.Stop();
//TimeSpan ts = sw.Elapsed;
//rtbData.Text = $"{ts}";
}
public bool putHistory(clsDbInfo cDbInfo)
{
DateTime datetimeCreate = DateTime.Now;
try
{
using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + filenameDB))
{
conn.Open();
using (SQLiteTransaction trans = conn.BeginTransaction())
{
SQLiteCommand cmd = conn.CreateCommand();
string strsql = "INSERT INTO " +
nameTableHistory + " (" +
nameColumnHis1 + "," +
nameColumnHis2 + "," +
nameColumnHis3 + "," +
nameColumnHis4 + "," +
nameColumnHis5 + ") VALUES (" +
"@" + nameColumnHis1 + ", " +
"@" + nameColumnHis2 + ", " +
"@" + nameColumnHis3 + ", " +
"@" + nameColumnHis4 + ", " +
"@" + nameColumnHis5 + ")";
cmd.CommandText = strsql;
cmd.Parameters.Add(nameColumnHis1, System.Data.DbType.String);
cmd.Parameters.Add(nameColumnHis2, System.Data.DbType.String);
cmd.Parameters.Add(nameColumnHis3, System.Data.DbType.String);
cmd.Parameters.Add(nameColumnHis4, System.Data.DbType.String);
cmd.Parameters.Add(nameColumnHis5, System.Data.DbType.String);
cmd.Parameters[nameColumnHis1].Value = cDbInfo.strdate;
cmd.Parameters[nameColumnHis2].Value = cDbInfo.nameJyo;
cmd.Parameters[nameColumnHis3].Value = cDbInfo.racenum;
cmd.Parameters[nameColumnHis4].Value = cDbInfo.raceId;
cmd.Parameters[nameColumnHis5].Value = datetimeCreate;
cmd.ExecuteNonQuery();
trans.Commit();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"エラー",
MessageBoxButtons.OK,
MessageBoxIcon.Hand);
return(false);
}
return(true);
}
private void Form1_Load(object sender, EventArgs e)
{
cLog.writeLog("Form1_Load " + this.Text);
cCommon = new clsCommon(this);
cDatabase = new clsDatabase(cCommon, this);
cOperateForm = new OperateForm(this, cDatabase, cCommon);
oldSelectDate = DateTime.Now;
// JV-Linkチェック
if (cCommon.checkInit() != 0)
{
//return;
}
// CodeTable.csvのチェック
if (!File.Exists(Application.StartupPath + "\\CodeTable.csv"))
{
Application.Exit();
}
// DBファイルがなければDB作る
if (!cDatabase.isExistDbFile())
{
if (!cDatabase.isMakeDB())
{
MessageBox.Show("DBが作成できません。");
Application.Exit();
}
}
// 前回選択した日付があれば表示する
List <clsDbInfo> listdbHistory;
listdbHistory = cDatabase.getDbHistory();
if (listdbHistory.Count > 0)
{
clsDbInfo cDbInfo = listdbHistory[listdbHistory.Count - 1];
cOperateForm.selectHistory(cDbInfo);
}
isFormLord = false;
}
