void btn_4_1_Click(object sender, RoutedEventArgs e)
{
decimal salary1 = 0, salary2 = Decimal.Parse(tb_4_2.Text.Trim());
Button btn = sender as Button;
int num = int.Parse(tb_4_1.Text.Trim());
using (var context = new BankDbEntities2())
{
var q = from t in context.Staff
where t.员工编号 == num
select t;
foreach (var v in q)
{
salary1 = v.工资;
v.工资 = salary2;
}
MessageBoxResult res = MessageBox.Show("是否将工资从" + salary1.ToString() + "改为" + salary2.ToString() + "?", "确认信息", MessageBoxButton.OKCancel, MessageBoxImage.Information);
if (res == MessageBoxResult.OK)
{
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("修改失败：" + ex.Message);
}
}
}
}
void btn_2_1_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
int num = int.Parse(tb_2_1.Text.Trim());
string id = tb_2_3.Text.Trim();
string pwd = tb_2_2.Password;
using (var context = new BankDbEntities2())
{
var q1 = from t1 in context.Deposit
where t1.账号 == num
select t1;
var q2 = from t2 in context.Costomer
where t2.账号 == num
select t2;
foreach (var v in q2)
{
if (v.身份证号码 == id && v.密码 == pwd)
{
datagrid3.ItemsSource = q1.ToList();
}
else
{
MessageBox.Show("无匹配客户！");
}
}
}
}
void btn_5_1_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
if (rb5_1.IsChecked == true)
{
costomer.性别 = "男";
}
else if (rb5_2.IsChecked == true)
{
costomer.性别 = "女";
}
if (tb_5_3.Password == tb_5_4.Password)
{
costomer.密码 = tb_5_3.Password;
}
costomer.姓名 = tb_5_1.Text.Trim();
costomer.身份证号码 = tb_5_2.Text.Trim();
costomer.余额 = 0;
costomer.账号 = 1;
using (var context = new BankDbEntities2())
{
try
{
context.Costomer.Add(costomer);
context.SaveChanges();
MessageBox.Show("操作成功！");
}
catch (Exception ex)
{
MessageBox.Show("开户失败：" + ex.Message);
}
}
}
void btn_5_2_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
string id = tb_5_5.Text.Trim();
string pwd = tb_5_6.Password;
using (var context = new BankDbEntities2())
{
var q = from t in context.Costomer
where t.身份证号码 == id
select t;
foreach (var v in q)
{
if (v.密码 == pwd)
{
context.Costomer.Remove(v);
}
else
{
MessageBox.Show("无匹配客户！");
}
}
try
{
context.SaveChanges();
MessageBox.Show("操作成功！");
}
catch (Exception ex)
{
MessageBox.Show("销户失败：" + ex.Message);
}
}
}
void btn_6_1_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
using (var context = new BankDbEntities2())
{
var q = from t in context.Costomer
select t;
datagrid5.ItemsSource = q.ToList();
}
}
void btn_6_2_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
using (var context = new BankDbEntities2())
{
try
{
context.SaveChanges();
MessageBox.Show("操作成功！");
}
catch (Exception ex)
{
MessageBox.Show("修改失败：" + ex.Message);
}
}
}
void btn_2_2_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
int num = int.Parse(tb_2_5.Text);
using (var context = new BankDbEntities2())
{
var q = from t in context.Deposit
where t.编号 == num
select t;
foreach (var v in q)
{
decimal money = addInterestRate(v);
context.Deposit.Remove(v);
Summary sum = new Summary();
sum.编号 = 20;
sum.账号 = v.账号;
sum.金额 = money;
sum.时间 = DateTime.Now;
sum.业务类型 = "取款";
context.Summary.Add(sum);
var qq = from t in context.Costomer
where t.账号 == v.账号
select t;
foreach (var vv in qq)
{
vv.余额 -= v.金额;
}
lb_money.Content = money.ToString();
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show("操作失败：" + ex.Message);
}
}
}
void btn3_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
int num = int.Parse(tb_3_1.Text);
DateTime time = DateTime.Now;
decimal price = Decimal.Parse(tb_3_2.Text.Trim());
using (var context = new BankDbEntities2())
{
deposit.编号 = 100; //标记
deposit.账号 = num;
deposit.日期 = time;
deposit.金额 = price;
try
{
context.Deposit.Add(deposit);
Summary sum = new Summary();
sum.编号 = 120; //标记
sum.账号 = deposit.账号;
sum.金额 = deposit.金额;
sum.时间 = DateTime.Now;
sum.业务类型 = deposit.存款类型;
context.Summary.Add(sum);
var q = from t in context.Costomer
where t.账号 == deposit.账号
select t;
foreach (var v in q)
{
v.余额 += deposit.金额;
}
context.SaveChanges();
MessageBox.Show("操作成功！");
}
catch (Exception ex)
{
MessageBox.Show("操作失败: " + ex.Message);
}
}
}
void btn_1_Click(object sender, RoutedEventArgs e)
{
Button btn = e.Source as Button;
switch (btn.Name.Trim())
{
case "btn_1_1":
DateTime tt = DateTime.Now.Date;
using (var context = new BankDbEntities2())
{
var q = from t in context.Summary
where t.时间 == tt
select t;
datagrid1.Visibility = System.Windows.Visibility.Visible;
datagrid1.ItemsSource = q.ToList();
};
break;
case "btn_1_2":
string idcard = tb_1.Text.Trim();
using (var context = new BankDbEntities2())
{
var q = from t1 in context.Deposit
from t2 in context.Costomer
where t1.账号 == t2.账号 && t2.身份证号码 == idcard
select new
{
存款类型 = t1.存款类型,
金额 = t1.金额,
期限 = t1.期限,
交易日期 = t1.日期
};
datagrid1.Visibility = System.Windows.Visibility.Visible;
datagrid1.ItemsSource = q.ToList();
}
break;
}
}
private decimal addInterestRate(Deposit dep)
{
decimal newMoney = 0;
var context = new BankDbEntities2();
var q = from t in context.InterestRate
select t;
List <InterestRate> list = q.ToList();
switch (dep.存款类型)
{
case "活期存款":
newMoney = dep.金额 * (1 + list.ElementAt(5).利率);
break;
case "定期存款":
switch (dep.期限)
{
case 1:
if (isExtended(dep))
{
newMoney = dep.金额 * (1 + list.ElementAt(0).利率) * (1 + list.ElementAt(3).利率);
}
else
{
newMoney = dep.金额 * (1 + list.ElementAt(4).利率);
}
break;
case 3:
if (isExtended(dep))
{
newMoney = dep.金额 * (1 + list.ElementAt(1).利率) * (1 + list.ElementAt(3).利率);
}
else
{
newMoney = dep.金额 * (1 + list.ElementAt(4).利率);
}
break;
case 5:
if (isExtended(dep))
{
newMoney = dep.金额 * (1 + list.ElementAt(2).利率) * (1 + list.ElementAt(3).利率);
}
else
{
newMoney = dep.金额 * (1 + list.ElementAt(4).利率);
}
break;
}
break;
case "零存整取":
switch (dep.期限)
{
case 1:
if (isExtended(dep))
{
newMoney = dep.金额 * (1 + list.ElementAt(6).利率) * (1 + list.ElementAt(9).利率);
}
else
{
newMoney = dep.金额 * (1 + list.ElementAt(10).利率);
}
break;
case 3:
if (isExtended(dep))
{
newMoney = dep.金额 * (1 + list.ElementAt(7).利率) * (1 + list.ElementAt(9).利率);
}
else
{
newMoney = dep.金额 * (1 + list.ElementAt(10).利率);
}
break;
case 5:
if (isExtended(dep))
{
newMoney = dep.金额 * (1 + list.ElementAt(8).利率) * (1 + list.ElementAt(9).利率);
}
else
{
newMoney = dep.金额 * (1 + list.ElementAt(10).利率);
}
break;
}
break;
}
return(newMoney);
}
