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