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

        }