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; }