private void saveAndDisplay2() { DBManager.MailChecker.data mailChecker = new DBManager.MailChecker.data(); // 新規登録 if (bNewEntry2) { setToContents2(ref mailChecker); insert2(mailChecker); } // 更新 else { lock (mailCheckerList) { // 対象のコンテンツ一覧から検索取得 mailChecker = (DBManager.MailChecker.data)mailCheckerList[selectIndex]; setToContents2(ref mailChecker); } update2(mailChecker); } resetInputFields2(); // メールチェッカ設定ロード loadMailChecker(); // オーナフォーム(メールチェッカ)再ロード parentForm.readMailCheckerData(); }
/// <summary> /// SQL接続(destroy) /// </summary> private void destroy2(DBManager.MailChecker.data mailChecker) { string strSQL = "delete from mail_list" + " where id = " + mailChecker.id; sqliteAccess.update(strSQL); }
private void setToContents2(ref DBManager.MailChecker.data mailChecker) { mailChecker.mail_connect_name = txtConnectName.Text; mailChecker.mail_effective = cbMailCheckEffective.Checked; mailChecker.mail_pop3 = txtPop3.Text; mailChecker.mail_user = txtUser.Text; mailChecker.mail_pass = txtPass.Text; mailChecker.mail_check_span = Int32.Parse(nudCheckSpan.Value.ToString()); }
/// <summary> /// SQL接続(update) /// </summary> private void update2(DBManager.MailChecker.data mailChecker) { string strSQL = "update mail_list set " + "mail_connect_name = '" + mailChecker.mail_connect_name + "'" + ", mail_effective = " + ((mailChecker.mail_effective == true) ? 1 : 0) + ", mail_pop3 = '" + mailChecker.mail_pop3 + "'" + ", mail_user = '******'" + ", mail_pass = '******'" + ", mail_check_span = " + mailChecker.mail_check_span + "" + " where id = " + mailChecker.id; sqliteAccess.update(strSQL); }
private void btnDelete2_Click(object sender, EventArgs e) { DBManager.MailChecker.data mailChecker = new DBManager.MailChecker.data(); lock (mailCheckerList) { // 対象のコンテンツ一覧から検索取得 mailChecker = (DBManager.MailChecker.data)mailCheckerList[selectIndex]; } destroy2(mailChecker); resetInputFields2(); // メールチェッカ設定ロード loadMailChecker(); // オーナフォーム(メールチェッカ)再ロード parentForm.readMailCheckerData(); }
/// <summary> /// SQL接続(insert) /// </summary> private void insert2(DBManager.MailChecker.data mailChecker) { string strSQL = "insert into mail_list (" + "mail_connect_name" + ", mail_effective" + ", mail_pop3" + ", mail_user" + ", mail_pass" + ", mail_check_span" + ") values (" + "'" + mailChecker.mail_connect_name + "'" + ", " + ((mailChecker.mail_effective == true) ? 1 : 0) + "" + ", '" + mailChecker.mail_pop3 + "'" + ", '" + mailChecker.mail_user + "'" + ", '" + mailChecker.mail_pass + "'" + ", " + mailChecker.mail_check_span + "" + ")"; sqliteAccess.insert(strSQL, null); }
/// <summary> /// 指定されたコンテンツデータより編集領域へ /// </summary> /// <param name="data"></param> private void setInputFields2(DBManager.MailChecker.data mailChecker) { btnNew2.Enabled = false; btnCancel2.Enabled = true; btnEntry2.Enabled = true; btnDelete2.Enabled = true; txtConnectName.Enabled = true; cbMailCheckEffective.Enabled = true; txtPop3.Enabled = true; txtUser.Enabled = true; txtPass.Enabled = true; nudCheckSpan.Enabled = true; bNewEntry2 = false; txtConnectName.Text = mailChecker.mail_connect_name; cbMailCheckEffective.Checked = mailChecker.mail_effective; txtPop3.Text = mailChecker.mail_pop3; txtUser.Text = mailChecker.mail_user; txtPass.Text = mailChecker.mail_pass; nudCheckSpan.Value = mailChecker.mail_check_span; }
/// <summary> /// メールチェッカ設定ロード /// </summary> private void loadMailChecker() { this.SuspendLayout(); string strSQL = "select * from mail_list"; listView2.Items.Clear(); mailCheckerList.Clear(); int index = 0; // 祝祭日DBに該当年のデータがあるかどうか確認 SQLiteDataReader result = sqliteAccess.select(strSQL); if (result != null) { while (result.Read()) { DBManager.MailChecker.data mailChecker = new DBManager.MailChecker.data(); mailChecker.id = result.GetInt32((Int32)DBManager.MailChecker.enum_data.id); mailChecker.mail_connect_name = result.GetString((Int32)DBManager.MailChecker.enum_data.mail_connect_name); mailChecker.mail_effective = result.GetBoolean((Int32)DBManager.MailChecker.enum_data.mail_effective); mailChecker.mail_pop3 = result.GetString((Int32)DBManager.MailChecker.enum_data.mail_pop3); mailChecker.mail_user = result.GetString((Int32)DBManager.MailChecker.enum_data.mail_user); mailChecker.mail_pass = result.GetString((Int32)DBManager.MailChecker.enum_data.mail_pass); mailChecker.mail_check_span = result.GetInt32((Int32)DBManager.MailChecker.enum_data.mail_check_span); mailCheckerList.Add(mailChecker); string[] strMailChecker = { mailChecker.mail_effective ? "○" : "×", mailChecker.mail_connect_name }; ListViewItem lvi = new ListViewItem(strMailChecker); lvi.Tag = index; listView2.Items.Add(lvi); index++; } } sqliteAccess.readerClose(); this.ResumeLayout(); }