private void Functino_buttonClitk(object sender, RoutedEventArgs e)
{
Button btn = (Button)sender as Button;
switch (btn.Name)
{
case "btn_save":
DiaryModel.DiaryModel tempDiaryModel = new DiaryModel.DiaryModel();
tempDiaryModel.UserName = "******";
tempDiaryModel.diaryType = cmb_diaryType.SelectedIndex;
tempDiaryModel.itemTitle = txt_Title.Text.ToString();
tempDiaryModel.diaryContent = Editor.ContentHtml;
tempDiaryModel.writeDate = Convert.ToDateTime(Picker_Time.Text);
Dictionary <string, string> DataList = new Dictionary <string, string>();
List <string> SqlList = new List <string>();
SoftHelper.SqlLiteHelper helper = new SoftHelper.SqlLiteHelper(localParh)
; DataList = helper.GetDateAndIDDataList("select * from baseinfo order by WriteDownDate desc");
string sql = "";
if (DataList.ContainsKey(Convert.ToDateTime(Picker_Time.Text).ToString("yyyy-MM-dd")))
{
sql = string.Format("update baseinfo set UserName='******',DiaryType={1},DiaryTitle='{2}',DiaryContext='{3}' where UserId='{4}'"
, tempDiaryModel.UserName
, tempDiaryModel.diaryType
, tempDiaryModel.itemTitle
, tempDiaryModel.diaryContent
, DataList[Convert.ToDateTime(Picker_Time.Text).ToString("yyyy-MM-dd")]);
}
else
{
sql = string.Format("insert into baseinfo (UserName,DiaryType,DiaryTitle,WriteDownDate,DiaryContext,UserId) values('{0}',{1},'{2}','{3}','{4}','{5}')"
, tempDiaryModel.UserName
, tempDiaryModel.diaryType
, tempDiaryModel.itemTitle
, tempDiaryModel.writeDate.ToString("s")
, tempDiaryModel.diaryContent.Replace("'", "\"")
, Convert.ToUInt64(Convert.ToDateTime(Picker_Time.Text).ToString("yyyyMMdd") + DateTime.Now.ToString("HHmmss")).ToString());
}
SqlList.Add(sql);
bool result = helper.InsertData(SqlList);
if (result)
{
MessageBox.Show("日记保存 成功！", "Tip");
}
else
{
MessageBox.Show("日记保存 失败！", "Tip");
}
RefreshLisbox();
break;
default:
break;
}
}
private void listB_itemList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DiaryModel.DiaryModel curItem = (DiaryModel.DiaryModel)listB_itemList.SelectedItem;
Picker_Time.Text = curItem.writeDate.ToString("yyyy-MM-dd");
cmb_diaryType.SelectedIndex = curItem.diaryType;
txt_Title.Text = curItem.itemTitle;
Editor.ContentHtml = curItem.diaryContent;
}
