private void BtnCreateExpensenRecordClick(object sender, RoutedEventArgs e) { var record = new AccountRecord { ConsumeTime = DateTime.Now }; AddOrEditRecord(record, AccountCategory.Expense); }
/// <summary> /// 添加或编辑消费记录 /// </summary> /// <param name="record">消费记录实体对象</param> /// <param name="category"></param> private void AddOrEditRecord(AccountRecord record, AccountCategory category) { var win = new CreateEditRecordWindow(record, category); win.Closing += delegate { if (win.DialogResult.HasValue && win.DialogResult.Value) { QueryRecords(); } }; win.Show(); }
public CreateEditRecordWindow(AccountRecord record, AccountCategory category) { InitializeComponent(); _category = category; _isUpdateRecord = record.Id > 0; if (_isUpdateRecord) { Title = string.Format("Update {0} Record", category); BtnSave.Content = "Update"; BtnSaveAdd.Visibility = Visibility.Collapsed; } else { Title = string.Format("Create {0} Record", category); } this.DataContext = record; this.Closing += new EventHandler<System.ComponentModel.CancelEventArgs>(CreateEditRecordWindowClosing); }
public long AddAccountRecord(AccountRecord record) { string cmdText = @"INSERT INTO [AccountRecord] ( [TypeId],[Money],[ConsumeTime],[RecordTime],[Memo],[UserId],[IsAccessorial] ) VALUES ( @typeId, @money, @consumeTime, @recordTime, @memo, @userId, @isAccessorial )"; var parameters = new[] { new SQLiteParameter("@typeId", record.Type.TypeId), new SQLiteParameter("@money", record.Money), new SQLiteParameter("@consumeTime", record.ConsumeTime), new SQLiteParameter("@recordTime", DateTime.Now), new SQLiteParameter("@memo", record.Memo), new SQLiteParameter("@userId", record.Consumer.UserId), new SQLiteParameter("@isAccessorial", record.IsAccessorial) }; SqliteHelper.ExecuteNonQuery(cmdText, parameters); //查询刚插入数据的历史记录ID cmdText = @"SELECT last_insert_rowid()"; return (long)SqliteHelper.ExecuteScalar(cmdText); }
public bool UpdateConsumeRecord(AccountRecord record) { return _consumeRecordBLL.UpdateConsumeRecord(record); }
public long AddConsumeRecord(AccountRecord record) { return _consumeRecordBLL.AddConsumeRecord(record); }
public bool UpdateConsumeRecord(AccountRecord record) { return _accountRecordDAL.UpdateAccountRecord(record); }
public long AddConsumeRecord(AccountRecord record) { return _accountRecordDAL.AddAccountRecord(record); }
public bool UpdateAccountRecord(AccountRecord record) { const string cmdText = @"UPDATE [AccountRecord] SET [TypeId] = @typeId, [Money]=@money, [ConsumeTime]=@consumeTime, [RecordTime]=@recordTime, [Memo]= @memo, [UserId]= @userId, [IsAccessorial] = @isAccessorial WHERE [Id]=@recordId"; var parameters = new[] { new SQLiteParameter("@typeId", record.Type.TypeId), new SQLiteParameter("@money", record.Money), new SQLiteParameter("@consumeTime", record.ConsumeTime), new SQLiteParameter("@recordTime", DateTime.Now), new SQLiteParameter("@memo", record.Memo), new SQLiteParameter("@userId", record.Consumer.UserId), new SQLiteParameter("@isAccessorial", record.IsAccessorial), new SQLiteParameter("@recordId", record.Id) }; var rowCount = SqliteHelper.ExecuteNonQuery(cmdText, parameters); return rowCount == 1; }