/// <summary> /// 存款界面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSubmitCK_Click(object sender, RoutedEventArgs e) { using (var context = new BankInfoManagementEntities()) { var q = from t in context.CreditCardInfo where t.CNo == textBoxCNo.Text where t.CPassword == textBoxCPwd.Password select t; if (q.ToList().Count == 0) { MessageBox.Show("用户名或密码错误!!请重新输入!", "警告", MessageBoxButton.OK, MessageBoxImage.Warning); textBoxCNo.Text = ""; textBoxCPwd.Password = ""; } else { db Db = new db(); string Procedure_CK = "exec DepositOperation'" + textBoxCNo.Text + "','" + textBoxCPwd.Password + "','" + textBoxCName.Text + "','" + Convert.ToDecimal(textBoxCMoney.Text) + "','" + comboBoxCKType.Text.ToString() + "','" + Convert.ToInt32(textBoxCTime.Text) + "'"; if (Db.SQlCommand(Procedure_CK) > 0) { MessageBox.Show("存款成功"); } else { MessageBox.Show("存款失败"); } } } }
/// <summary> /// 转账记录查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnCheckZZRecord_Click(object sender, RoutedEventArgs e) { using (var context = new BankInfoManagementEntities()) { var q = from t in context.CreditCardInfo where t.CNo == textBoxZZLogNo.Text where t.CPassword == pwdBoxZZLog.Password select t; if (q.ToList().Count() != 0) { MessageBox.Show("登陆成功", "提示", MessageBoxButton.OK, MessageBoxImage.Information); var q1 = from t in context.TransferInfo where t.TDate == datePickerZZ.SelectedDate where t.OutNo == textBoxZZLogNo.Text select new { 转出账号 = t.OutNo, 客户姓名 = t.OutName, 转入账户 = t.InNo, 金额 = t.TransMoney, 日期 = t.TDate }; if (q1.ToList().Count == 0) { MessageBox.Show("无存款记录", "提示", MessageBoxButton.OK, MessageBoxImage.Information); } else { dataGridZZ.ItemsSource = q1.ToList(); } } } }
/// <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 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); } } }
private void DatePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e) { using (var context = new BankInfoManagementEntities()) { var q = from t in context.OperationLog where t.CDate == datePicker1.SelectedDate select new { 账号 = t.CNo, 客户姓名 = t.CName, 操作类型 = t.CStyle, 日期 = t.CDate, 金额 = t.CMoney, 存款时长 = t.CTimeLen, 利率 = t.CRate }; dataGrid1.ItemsSource = q.ToList(); var q1 = (from t in context.OperationLog where t.CStyle.Contains("存") select t).Sum(x => x.CMoney); textBoxInTotal.Text = q1.ToString() + "¥"; var q2 = (from t in context.OperationLog where t.CStyle.Contains("取") select t).Sum(x => - x.CMoney); textBoxOutTotal.Text = q2.ToString() + "¥"; } }
private void btnSubmitQK_Click(object sender, RoutedEventArgs e) { decimal y = 0, t1 = 0; using (var context = new BankInfoManagementEntities()) { var q = from t in context.CreditCardInfo where t.CNo == textBoxQNo.Text where t.CPassword == textBoxQPwd.Password select t; if (q.ToList().Count == 0) { MessageBox.Show("用户名或密码错误!!请重新输入!", "警告", MessageBoxButton.OK, MessageBoxImage.Warning); textBoxCNo.Text = ""; textBoxCPwd.Password = ""; } else { db Db = new db(); SqlConnection conn = db.Camcon(); conn.Open(); string str1 = "select CBalance from CreditCardInfo where CNo='" + textBoxQNo.Text + "'"; SqlCommand comm = new SqlCommand(str1, conn); SqlDataReader sdr = comm.ExecuteReader(); sdr.Read(); y = Convert.ToDecimal(sdr["CBalance"].ToString()); sdr.Close(); t1 = y - Convert.ToDecimal(textBoxQMoney.Text); if (t1 > 0) { textBoxQType.Text = "取款"; string Procedure_QK = "exec DepositOperation'" + textBoxQNo.Text + "','" + textBoxQPwd.Password + "','" + textBoxQName.Text + "','" + Convert.ToDecimal(textBoxQMoney.Text) + "','" + textBoxQType.Text + "','" + "0" + "'"; MessageBox.Show("\r\t卡上总余额" + y + "人民币\r\t可操作余额" + t1 + "人民币"); if (Db.SQlCommand(Procedure_QK) > 0) { MessageBox.Show("取款成功"); } else { MessageBox.Show("取款失败"); } } else { MessageBox.Show("\r\t卡上总余额" + y + "人民币\r\t可操作余额" + y + "人民币" + "余额不足", "警告", MessageBoxButton.OK, MessageBoxImage.Information); } } } }
private void btnLogin_Click(object sender, RoutedEventArgs e) { AdminManageWindow amw = new AdminManageWindow(); if (comoBoxUserType.SelectedIndex == 0) { using (var context = new BankInfoManagementEntities()) { var q = from t in context.EmploeeInfo where t.YNo == textBoxUserName.Text where t.YPassword == pwdBoxUserPassword.Password where t.YPosition == 1 select t; if (q.ToList().Count() != 0) { MessageBox.Show("登陆成功", "提示", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); amw.Show(); } else { MessageBox.Show("登陆失败,账户名或密码错误", "警告", MessageBoxButton.OK, MessageBoxImage.Information); } } } else { AssistantWindow aw = new AssistantWindow(); using (var context = new BankInfoManagementEntities()) { var q = from t in context.EmploeeInfo where t.YNo == textBoxUserName.Text where t.YPassword == pwdBoxUserPassword.Password where t.YPosition == 0 select t; if (q.ToList().Count() != 0) { MessageBox.Show("登陆成功", "提示", MessageBoxButton.OK, MessageBoxImage.Information); this.Close(); aw.Show(); } else { MessageBox.Show("登陆失败,账户名或密码错误", "警告", MessageBoxButton.OK, MessageBoxImage.Information); } } } }
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); } } }
private void btnCheckInterest_Click(object sender, RoutedEventArgs e) { using (var context = new BankInfoManagementEntities()) { var q = from t in context.CreditCardInfo where t.CNo == textBoxCheckCNo.Text where t.CPassword == textBoxCheckPwd.Password select t; if (q.ToList().Count() != 0) { MessageBox.Show("登录成功", "提示", MessageBoxButton.OK, MessageBoxImage.Information); if (radioBtnLCZQ.IsChecked == true) { var q1 = from t in context.OperationLog where t.CDate == datePicker2.SelectedDate where t.CNo == textBoxCheckCNo.Text where t.CStyle.Contains("零存整取") select new { 账号 = t.CNo, 客户姓名 = t.CName, 操作类型 = t.CStyle, 日期 = t.CDate, 金额 = t.CMoney, 存款时长 = t.CTimeLen, 利率 = t.CRate, 利息 = t.Interest }; if (q1.ToList().Count == 0) { MessageBox.Show("无存款记录", "提示", MessageBoxButton.OK, MessageBoxImage.Information); } else { dataGrid2.ItemsSource = q1.ToList(); } } else if (radioBtnDQCK.IsChecked == true) { var q2 = from t in context.OperationLog where t.CDate == datePicker2.SelectedDate where t.CNo == textBoxCheckCNo.Text where t.CStyle.Contains("定存") select new { 账号 = t.CNo, 客户姓名 = t.CName, 操作类型 = t.CStyle, 日期 = t.CDate, 金额 = t.CMoney, 利率 = t.CRate, 利息 = t.Interest }; if (q2.ToList().Count == 0) { MessageBox.Show("无记录", "提示", MessageBoxButton.OK, MessageBoxImage.Information); } else { dataGrid2.ItemsSource = q2.ToList(); } } } else { MessageBox.Show("登录失败,账户名或密码错误", "警告", MessageBoxButton.OK, MessageBoxImage.Information); } } }