private void btnVerifyUpdate_Click(object sender, RoutedEventArgs e)
{
using (var context = new BankInfoManagementEntities())
{
var q = from t in context.CreditCardInfo
where t.CNo == textBoxChangeCNo.Text
where t.CPassword == textBoxChangeCPwd.Password
select new
{
账号 = t.CNo,
客户姓名 = t.CName,
开户日期 = t.CDate,
开户地址 = t.COpenAdress,
手机号 = t.CPhoneNo
};
dataGridPersonalInfo.ItemsSource = q.ToList();
var q1 = from t in context.CreditCardInfo
where t.CNo == textBoxChangeCNo.Text
select t;
if (q1.ToList().Count() != 0)
{
foreach (var v in q1)
{
v.CPassword = textBoxChangeNewPwd.Password;
}
context.SaveChanges();
MessageBox.Show("修改密码成功！");
}
else
{
MessageBox.Show("修改密码失败，账户名或密码错误", "警告", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
/// <summary>
/// 确认开户
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOpenAccount_Click(object sender, RoutedEventArgs e)
{
DateTime d = Convert.ToDateTime(datePickerOpen.SelectedDate);
using (var context = new BankInfoManagementEntities())
{
DeposInfo deposinfo = new DeposInfo()
{
CName = textBoxKCName.Text,
CSex = textBoxOpenSex.Text,
CNo = textBoxKCNo.Text,
CPassword = textBoxKCPwd.Password,
CID = textBoxOpenID.Text,
CDate = d,
CAdress = textOpenAddress.Text,
CPhoneNum = textBoxPhoneNo.Text
};
try
{
context.DeposInfo.Add(deposinfo);
context.SaveChanges();
MessageBox.Show("开户成功", "提示", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show("开户失败" + ex.ToString());
}
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
context.SaveChanges();
MessageBox.Show("保存成功。");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "保存失败");
}
}
private void btnVerifyChange_Click(object sender, RoutedEventArgs e)
{
using (var context = new BankInfoManagementEntities())
{
var q = from t in context.EmploeeInfo
where t.YNo == textBoxChangeYNo.Text
where t.YPassword == pwdBoxOldYPwd.Password
select t;
if (q.ToList().Count() != 0)
{
foreach (var v in q)
{
v.YPassword = pwdBoxNewYPwd.Password;
}
context.SaveChanges();
MessageBox.Show("修改密码成功！");
}
else
{
MessageBox.Show("修改密码失败，账户名或密码错误", "警告", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
