//添加余额
private void btnYes_Click(object sender, RoutedEventArgs e)
{
if (!IsShowBalance)
{
Balance balance = new Balance();
balance.Balances = decimal.Parse(txtBalance.Text); //把string类型转为decimal
bool i = new BalanceBLL().Update(LoginWindow.GetOperatorId(), balance.Balances);
if (i)
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "添加余额成功！");
MessageBox.Show("添加数据成功！");
this.Close();
}
else
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "添加余额失败！");
MessageBox.Show("添加数据错误！");
this.Close();
}
}
}
//点击保存按钮的
private void btnSave_Click(object sender, RoutedEventArgs e)
{
Account account = (Account)gridEditAccount.DataContext;
AccountBLL accountBll = new AccountBLL();
//判断金额大于0
if (cbType.SelectedIndex > -1)
{
if (account.Money <= 0)
{
MessageBox.Show("你输入的收入金额不合法，请重新输入！");
return;
}
}
if (cbType.SelectedIndex < 0)
{
MessageBox.Show("请选择收支！");
return;
}
else if (cbItem.SelectedIndex < 0)
{
MessageBox.Show("请选择项目！");
return;
}
//有问题
else
{
//获得名字为收入的Id值
IdName idname = new IdNameBLL().GetByName("收入");
Balance balance = new Balance();
#region 添加收支
//添加收支
if (IsAddNew)
{
int i;
//分布式事务处理收支和余额，可实现回滚
using (TransactionScope ts = new TransactionScope())
{
i = accountBll.AddNew(account);
//判断是否为收入,收入为正的，支出为负数
if (account.CostType == idname.Id) //收入
{
balance.Balances = (decimal)account.Money;
}
else //支出
{
balance.Balances = (decimal)(-account.Money);
}
new BalanceBLL().Update(account.OperatorId, balance.Balances);
ts.Complete();//表示已完成
}
//严谨点Update也应该返回true or false
if (i < 0)
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "添加收支，更新余额失败！");
MessageBox.Show("添加错误！");
}
else if (i > 1)
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "添加收支时错误！");
throw new Exception("数据发生错误！");
}
else
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "添加收支，更新余额成功！");//日志
MessageBox.Show("添加成功！");
this.Close();
}
}
#endregion
#region 编辑收支
//编辑收支
else
{
bool i;//插入余额是否成功
bool isAddbalanceSuc;//插入余额是否成功
//分布式处理
using (TransactionScope ts = new TransactionScope())
{
//更新收支
i = accountBll.Update(account);
//更新前的数据类型是否为收入，并计算出差额，
if (BeforeCostType == idname.Id)
{
//收入改为收入 只是金额的更改
if (account.CostType == idname.Id) //更改后收支类型，为收入
{
if ((decimal)account.Money != BeforeEditingMoney) //更新后的钱不等更新前的前
{
balance.Balances = (decimal)account.Money - BeforeEditingMoney; //加上前后的差额（后大于前取+，否则为—）
}
else
{
balance.Balances = 0;
}
}
//收入改为支出，前为收，后为支
else
{
// 先减去更新前的收入，再减去更新后的支出金额
balance.Balances = -BeforeEditingMoney - (decimal)account.Money;
}
}
//若更新前为支出，计算出差额
else
{
//判断更新后的类型
if (account.CostType == idname.Id)//更新后的类型为收入，更新前为支出
{
balance.Balances = BeforeEditingMoney + (decimal)account.Money; //先加上更新前的支出，再加上更新后的收入
}
//更新后为支出，更新前为支出
else
{
if (BeforeEditingMoney != (decimal)account.Money) //更新前的钱不等于更新后的钱，求钱差额
{
balance.Balances = BeforeEditingMoney - (decimal)account.Money; //更新前 减去更新后 若更新前大，那就加上差额
}
else
{
balance.Balances = 0;
}
}
}
isAddbalanceSuc = new BalanceBLL().Update(account.OperatorId, balance.Balances);
ts.Complete();
}
if (i && isAddbalanceSuc)
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "编辑收支成功！");
MessageBox.Show("更改成功！");
this.Close();
}
else
{
new OperationLogBLL().Insert(LoginWindow.GetOperatorId(), "编辑收支失败！");
MessageBox.Show("更新失败！");
}
}
#endregion
}
}
//为属性赋值
private Balance ToBalance(DataRow row)
{
Balance balance = new Balance();
balance.Id = (Guid)row["Id"];
balance.OperatorId = (Guid)row["OperatorId"];
balance.Balances = (decimal)row["Balance"];
return balance;
}
//删除选中数据
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
Account account = (Account)dataGridShow.SelectedItem;
//判断是否选中数据
if (account == null)
{
MessageBox.Show("请选择一条数据！");
return;
}
if (MessageBox.Show("确认删除此条数据吗？", "提醒", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
IdName idname = new IdNameBLL().GetByName("收入");
int i; //deleted返回
bool isSuceess; //判断余额是否更新成功
using (TransactionScope ts = new TransactionScope())
{
i = new AccountBLL().DeleteById(account.Id);
Balance balance = new Balance();
if (idname.Id == account.CostType)//要删除的为收入
{
balance.Balances = (decimal)(-account.Money);
isSuceess = new BalanceBLL().Update(account.OperatorId, balance.Balances);
}
else
{
balance.Balances = (decimal)account.Money;
isSuceess = new BalanceBLL().Update(account.OperatorId, balance.Balances);
}
if (i > 0 && isSuceess)
{
MessageBox.Show("删除成功！");
}
else
{
MessageBox.Show("删除失败！");
}
ts.Complete();
}
LoadData();
}
}