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