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