public static void InsertRecore(ClockRecord clockRecord)
{
SqLiteWrapperHelper.ExnoculSql(
String.Format(
"insert into ClockRecord (Id,RecordConent,ClockDate,Music,MusicName,Beer,Email,EmailAdress) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')",
clockRecord.Id, clockRecord.RecordConent, clockRecord.ClockDate, clockRecord.Music.BoolCoverString(),
clockRecord.MusicName, clockRecord.Beer.BoolCoverString(), clockRecord.Email.BoolCoverString(),
clockRecord.EmailAdress));
}
public static void DeleteRecore(ClockRecord clockRecord)
{
if (null != clockRecord)
{
SqLiteWrapperHelper.ExnoculSql(
String.Format(
"delete ClockRecord where Id='{0}'", clockRecord.Id));
}
}
private void ButtonBase_OnClick(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(Datetime.Text))
{
MessageBox.Show("请选择时间!");
return;
}
var clockre = new ClockRecord
{
Id = Guid.NewGuid().ToString(),
Beer = Beer.IsChecked ?? false,
EmailAdress = EmailAdress.Text,
ClockDate =
DateTime.Parse(Datetime.Text.ToString(CultureInfo.InvariantCulture))
.ToString("yyyy-MM-dd HH:mm:ss"),
Email = Emailtip.IsChecked ?? false,
Music = Musitip.IsChecked ?? false,
RecordConent = Record.Text
};
_clockAddViewModel.CurrentDateTimeClock = clockre;
_clockAddViewModel.AddRecord.Execute(null);
}