private void contentsSaveAndDisplay()
{
DBManager.Contents.data contents = new DBManager.Contents.data();
// 新規登録
if (bNewEntry)
{
setToContents(contents);
insert(contents);
contentsList.Add(contents);
}
// 更新
else
{
lock (contentsList)
{
// 対象のコンテンツ一覧から検索取得
DBManager.Contents.data data = contentsList.SelectId(id);
if (data != null)
{
contents = data;
}
setToContents(contents);
}
update(contents);
}
resetInputFields();
// オーナフォーム(カレンダ)再表示
parentForm.setCalendar();
}
/// <summary>
/// 各種データ読込
/// </summary>
private void readContentsData()
{
// SELECT文の作成
string strSQLCheckBox = "";
ArrayList exprList = new ArrayList();
if (cbSchedule.Checked == true)
{
exprList.Add(0);
}
if (cbTodo.Checked == true)
{
exprList.Add(1);
}
if (cbMemo.Checked == true)
{
exprList.Add(2);
}
if (cbSticky.Checked == true)
{
exprList.Add(3);
}
if (cbAlarm.Checked == true)
{
exprList.Add(4);
}
string strSQL = "select * from contents_list ";
strSQL = strSQL + "where data_type in (";
foreach (int type in exprList)
{
if (strSQLCheckBox.Equals("") == false)
{
strSQLCheckBox = strSQLCheckBox + ", ";
}
strSQLCheckBox = strSQLCheckBox + type.ToString();
}
strSQL = strSQL + strSQLCheckBox;
strSQL = strSQL + ") and";
if (rbComplete.Checked == true)
{
strSQL = strSQL + " contents like '%" + cmbQueryString.Text + "%'";
}
else
{
ArrayList queryList = new ArrayList();
char[] sep = { ' ' };
string[] query = cmbQueryString.Text.Split(sep);
for (int i = 0; i < query.Length; i++)
{
if (i == 0)
{
strSQL = strSQL + " (";
}
else
{
if (rbAnd.Checked == true)
{
strSQL = strSQL + " and";
}
else if (rbOr.Checked == true)
{
strSQL = strSQL + " or";
}
}
strSQL = strSQL + " contents like '%" + query[i] + "%'";
}
strSQL = strSQL + ")";
}
SQLiteDataReader result = sqliteAccess.select(strSQL);
while (result.Read())
{
DBManager.Contents.data data = new DBManager.Contents.data();
data.id = result.GetInt32((Int32)DBManager.Contents.enum_data.id);
data.effective = result.GetBoolean((Int32)DBManager.Contents.enum_data.effective);
data.data_type = result.GetInt32((Int32)DBManager.Contents.enum_data.data_type);
data.date_time = result.GetDateTime((Int32)DBManager.Contents.enum_data.date_time);
data.contents = result.GetString((Int32)DBManager.Contents.enum_data.contents);
data.show_stickies = result.GetBoolean((Int32)DBManager.Contents.enum_data.show_stickies);
data.backcolor_stickies = result.GetString((Int32)DBManager.Contents.enum_data.backcolor_stickies);
data.point_stickies = result.GetString((Int32)DBManager.Contents.enum_data.point_stickies);
data.time_trigger = result.GetBoolean((Int32)DBManager.Contents.enum_data.time_trigger);
data.time_trigger_type = result.GetInt32((Int32)DBManager.Contents.enum_data.time_trigger_type);
if (data.time_trigger == true)
{
data.time_trigger_datetime = result.GetDateTime((Int32)DBManager.Contents.enum_data.time_trigger_datetime);
}
data.time_trigger_dayofweek = result.GetInt32((Int32)DBManager.Contents.enum_data.time_trigger_dayofweek);
data.attach_trigger = result.GetBoolean((Int32)DBManager.Contents.enum_data.attach_trigger);
if (data.attach_trigger == true)
{
data.attach_trigger_title = result.GetString((Int32)DBManager.Contents.enum_data.attach_trigger_title);
}
data.display_backimage_stickies = result.GetBoolean((Int32)DBManager.Contents.enum_data.display_backimage_stickies);
data.display_backimage_type_stickies = result.GetInt32((Int32)DBManager.Contents.enum_data.display_backimage_type_stickies);
if (data.display_backimage_stickies == true)
{
data.display_backimage_path_stickies = result.GetString((Int32)DBManager.Contents.enum_data.display_backimage_path_stickies);
}
data.display_backimage_region_stickies = result.GetBoolean((Int32)DBManager.Contents.enum_data.display_backimage_region_stickies);
data.alpha_stickies = result.GetInt32((Int32)DBManager.Contents.enum_data.alpha_stickies);
object objFontSerializeble = result.GetValue((Int32)DBManager.Contents.enum_data.display_font_stickies);
if (objFontSerializeble != null)
{
string fontSerializeble = objFontSerializeble.ToString();
if (!fontSerializeble.Trim().Equals(""))
{
FontConverter fc = new FontConverter();
data.display_font_stickies = (Font)fc.ConvertFromString(fontSerializeble);
}
else
{
data.display_font_stickies = this.Font;
}
}
else
{
data.display_font_stickies = this.Font;
}
// データ格納
contentsList.Add(data);
// リストビューへデータ移行
string[] queryResult =
{
(string)dataType[(int)data.data_type]
, data.date_time.ToString()
, data.contents
};
ListViewItem lvi = new ListViewItem(queryResult);
lvi.ToolTipText = data.contents;
lvi.Tag = data.id.ToString();
listView1.Items.Add(lvi);
}
// リーダクローズ
sqliteAccess.readerClose();
}
