/// <summary>
/// 存款
/// </summary>
/// <param name="accountInfo"></param>
public static void UpdateSave(UserAccountInfo accountInfo)
{
using (var context = new BMS_DBEntities())
{
try
{
OperateRecordInfo operateinfo = new OperateRecordInfo();
var q = from t in context.UserAccountInfoes
where accountInfo.UAccountNumber == t.UAccountNumber
select t;
foreach (var i in q)
{
i.Balance += accountInfo.Balance;
operateinfo.AccountRemaining = (double)i.Balance;
}
operateinfo.OTime = System.DateTime.Now;
operateinfo.OType = "存款";
operateinfo.OAccountNumber = accountInfo.UAccountNumber;
operateinfo.OAccountChange = (double)accountInfo.Balance;
context.OperateRecordInfoes.Add(operateinfo);
context.SaveChanges();
context.Dispose();
}
catch
{
MessageBox.Show("修改失败");
}
}
}
/// <summary>
/// 获取存款用户信息,并初始化余额
/// </summary>
/// <param name="accountNumber"></param>
/// <returns></returns>
public static Custom GetCustom(string accountNumber)
{
Custom custom = null;
BMS_DBEntities c = new BMS_DBEntities();
try
{
var q = (from t in c.UserAccountInfoes
where t.UAccountNumber == accountNumber
select t).Single();
custom = CreateCustom(q.LoanType);
custom.AccountInfo.UAccountNumber = accountNumber;
custom.AccountInfo.UName = q.UName;
custom.AccountInfo.UAccountPassword = q.UAccountPassword;
custom.AccountInfo.UIdCardNumber = q.UIdCardNumber;
}
catch
{
return(null);
}
var q1 = (from t in c.OperateRecordInfoes
where t.OAccountNumber == accountNumber
select t).Sum(x => x.OAccountChange);
custom.AccountBalance = (double)q1; //??????????????????????????????????
return(custom);
}
private void b1_Click(object sender, RoutedEventArgs e)
{
using (var context = new BMS_DBEntities())
{
EmployeeInfo em = new EmployeeInfo()
{
EId = this.Id.Text,
EName = this.stName.Text,
EPassword = this.pass.Password,
ESex = this.Sex.Text,
EIdCardNumber = this.IdCard.Text,
ESalary = decimal.Parse(this.Wage.Text),
EPhone = this.Conn.Text,
};
try
{
context.EmployeeInfoes.Add(em);
context.SaveChanges();
context.Dispose();
MessageBox.Show("添加成功");
}
catch (Exception ex)
{
MessageBox.Show("添加失败!" + ex.Message);
}
}
this.Close();
}
public void show()
{
//查找数据库有关信息
using (var context = new BMS_DBEntities())
{
var q = from t1 in context.BusinessLoanInfoes
from t2 in context.UserAccountInfoes
where t1.BlAccountNumber == t2.UAccountNumber
select new
{
账号 = t1.BlAccountNumber,
姓名 = t2.UName,
公司 = t1.BlCompany,
总资产 = t1.BlCompanyAsset,
余额 = t2.Balance,
贷款类型 = "企业贷款"
};
data.ItemsSource = q.ToList();
//var q1 = from t2 in context.UserAccountInfoes
// from t1 in context.BusinessLoanInfoes
// where t1.BlAccountNumber == t2.UAccountNumber
// select t2;
//data.ItemsSource = q1.ToList();
}
}
//by wygdove start
public int check()
{
accountinfo.UName = this.CName.Text;
accountinfo.UIdCardNumber = this.IDCard.Text;
accountinfo.UAccountNumber = this.CreditCard.Text;
accountinfo.UAccountPassword = this.Password.Password;
using (var context = new BMS_DBEntities())
{
try
{
var q = from t in context.UserAccountInfoes
where t.UIdCardNumber == accountinfo.UIdCardNumber && t.UAccountPassword == accountinfo.UAccountPassword && t.UAccountNumber == accountinfo.UAccountNumber
select t;
foreach (var i in q)
{
MessageBox.Show("该账户状态为：" + i.Statement);
}
return(q.ToList().Count());
}
catch
{
MessageBox.Show("查询用户失败");
}
}
return(-1);
}
/// <summary>
/// 开户
/// </summary>
/// <param name="accountInfo"></param>
public static void CreateUser(UserAccountInfo accountInfo)
{
using (var context = new BMS_DBEntities())
{
try
{
accountInfo.Statement = "normal";
context.UserAccountInfoes.Add(accountInfo);
OperateRecordInfo operateinfo = new OperateRecordInfo();
operateinfo.OTime = System.DateTime.Now;
operateinfo.OType = "开户";
operateinfo.OAccountNumber = accountInfo.UAccountNumber;
operateinfo.OAccountChange = (double)accountInfo.Balance;
operateinfo.AccountRemaining = (double)accountInfo.Balance;
context.OperateRecordInfoes.Add(operateinfo);
context.SaveChanges();
context.Dispose();
}
catch
{
MessageBox.Show("修改失败");
}
}
}
public void staff()
{
BMS_DBEntities context = new BMS_DBEntities();
var query = from t in context.EmployeeInfoes
select t;
this.datagrid1.ItemsSource = query.ToList();
}
public OperateRecord()
{
InitializeComponent();
BMS_DBEntities context = new BMS_DBEntities();
var query = from t in context.OperateRecordInfoes
select t;
this.datagrid1.ItemsSource = query.ToList(); //数据库
}
/// <summary>
/// 获取指定类别的利率
/// </summary>
/// <param name="rateType">利率类别</param>
/// <returns>对应类别的利率值</returns>
public static double GetRate(RateType rateType)
{
string type = rateType.ToString();
BMS_DBEntities c = new BMS_DBEntities();
var q = (from t in c.RateInfoes
where t.DepositType == type
select t.Rate).Single();
return(q.Value);
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
//by wygdove start
UserAccountInfo accountinfo = new UserAccountInfo();
using (var context = new BMS_DBEntities())
{
accountinfo.UAccountNumber = this.AccountId.Text;
accountinfo.UName = this.LName.Text;
accountinfo.UPhone = this.LPhone.Text;
accountinfo.Balance = decimal.Parse(this.LoanAmount.Text);
var q = from t in context.UserAccountInfoes
where t.UAccountNumber == accountinfo.UAccountNumber
select t;
if (q.Count() == 0)
{
CustomOperation.CreateLoan(accountinfo, "企业贷款");
context.SaveChanges();
context.Dispose();
}
}
//by wygdove end
//将贷款信息添置数据库
using (var context = new BMS_DBEntities())
{
BusinessLoanInfo firm = new BusinessLoanInfo()
{
BlCompany = this.Company.Text,
BlCompanyLoaction = this.Location.Text,
BlAccountNumber = accountinfo.UAccountNumber,
BlCompanyAsset = this.TotalAssets.Text
};
try
{
context.BusinessLoanInfoes.Add(firm);
context.SaveChanges();
context.Dispose();
MessageBox.Show("贷款成功");
}
catch (Exception ex)
{
MessageBox.Show("贷款失败! " + ex.Message);
}
context.Dispose();
this.Close();
}
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
//by wygdove start
UserAccountInfo accountinfo = new UserAccountInfo();
using (var context = new BMS_DBEntities())
{
accountinfo.UAccountNumber = this.AccountId.Text;
accountinfo.UName = this.PName.Text;
accountinfo.UPhone = this.PPhone.Text;
accountinfo.Balance = decimal.Parse(this.LoanAmount.Text);
var q = from t in context.UserAccountInfoes
where t.UAccountNumber == accountinfo.UAccountNumber
select t;
if (q.Count() == 0)
{
CustomOperation.CreateLoan(accountinfo, "个人贷款");
context.SaveChanges();
context.Dispose();
}
}
//by wygdove end
//将贷款信息添置数据库
using (var context = new BMS_DBEntities())
{
PersonalLoanInfo person = new PersonalLoanInfo()
{
PlWork = this.Unit.Text,
//PlSalary = this.Wage.Text,
PlAccountNumber = this.AccountId.Text,
PlSalary = decimal.Parse(this.Wage.Text)
};
try
{
context.PersonalLoanInfoes.Add(person);
context.SaveChanges();
MessageBox.Show("贷款成功");
}
catch (Exception ex)
{
MessageBox.Show("贷款失败!" + ex.Message);
}
}
this.Close();
}
private void btnOk_Click(object sender, RoutedEventArgs e)
{
//by wygdove start
UserAccountInfo accountinfo = new UserAccountInfo();
using (var context = new BMS_DBEntities())
{
accountinfo.UAccountNumber = this.AccountId.Text;
accountinfo.UName = this.SName.Text;
accountinfo.UPhone = this.Phone.Text;
accountinfo.Balance = decimal.Parse(this.LoanAmount.Text);
var q = from t in context.UserAccountInfoes
where t.UAccountNumber == accountinfo.UAccountNumber
select t;
if (q.Count() == 0)
{
CustomOperation.CreateLoan(accountinfo, "教学贷款");
context.SaveChanges();
context.Dispose();
}
}
//by wygdove end
//将贷款信息添置数据库
using (var context = new BMS_DBEntities())
{
StudentLoanInfo student = new StudentLoanInfo()
{
SlSchool = this.School.Text,
SlInstitute = this.Academy.Text,
SlProfession = this.Major.Text,
SlAccountNumber = this.AccountId.Text
};
try
{
context.StudentLoanInfoes.Add(student);
context.SaveChanges();
MessageBox.Show("贷款成功");
}
catch (Exception ex)
{
MessageBox.Show("贷款失败!" + ex.Message);
}
}
this.Close();
}
/// <summary>
/// 获取操作员姓名
/// </summary>
/// <param name="id">操作员编号</param>
/// <returns></returns>
public static string GetOperateName(string id)
{
using (BMS_DBEntities c = new BMS_DBEntities())
{
var q = from t in c.EmployeeInfoes
where t.EId == id
select t;
if (q != null && q.Count() >= 1)
{
return(q.First().EName);
}
else
{
return("");
}
}
}
private void b3_Click(object sender, RoutedEventArgs e)
{
using (var context = new BMS_DBEntities())
{
var q = from t in context.EmployeeInfoes
where t.EId == this.SId.Text && t.EIdCardNumber == this.SIdCard.Text && t.EName == this.SName.Text && t.EPassword == this.password.Password
select t;
foreach (var v in q)
{
context.EmployeeInfoes.Remove(v);
}
context.SaveChanges();
context.Dispose();
MessageBox.Show("删除成功");
}
this.Close();
}
private void comboBoxAccountType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string s = comboBoxAccountType.SelectedItem.ToString();
using (BMS_DBEntities c = new BMS_DBEntities()) //数据库
{
var q = from t in c.UserAccountInfoes
where t.LoanType == s
select t;
if (q.Count() > 0)
{
this.txtAccountNo.Text = string.Format("{0}", int.Parse(q.Max(x => x.UAccountNumber)) + 1);
}
else
{
txtAccountNo.Text = string.Format("{0}00001", comboBoxAccountType.SelectedIndex + 1);
}
}
}
public void show()
{
//查找数据库有关信息
using (var context = new BMS_DBEntities())
{
var q = from t1 in context.StudentLoanInfoes
from t2 in context.UserAccountInfoes
where t1.SlAccountNumber == t2.UAccountNumber
select new
{
账户 = t1.SlAccountNumber,
姓名 = t2.UName,
学校 = t1.SlSchool,
手机号码 = t2.UPhone,
余额 = t2.Balance,
贷款类型 = "学生短期借款"
};
data.ItemsSource = q.ToList();
}
}
public void show()
{
InitializeComponent();
//查找数据库有关信息
using (var context = new BMS_DBEntities())
{
var q = from t1 in context.StudentLoanInfoes
from t2 in context.UserAccountInfoes
where t1.SlAccountNumber == t2.UAccountNumber
select new
{
账户 = t1.SlAccountNumber,
姓名 = t2.UName,
学校 = t1.SlSchool,
专业 = t1.SlProfession,
院系 = t1.SlInstitute,
余额 = t2.Balance,
贷款类型 = "教学贷款"
};
data.ItemsSource = q.ToList();
}
}
public void show()
{
//查找数据库有关信息
using (var context = new BMS_DBEntities())
{
var q = from t1 in context.PersonalLoanInfoes
from t2 in context.UserAccountInfoes
where t1.PlAccountNumber == t2.UAccountNumber
select new
{
账户 = t1.PlAccountNumber,
姓名 = t2.UName,
所在单位 = t1.PlWork,
基本工资 = t1.PlSalary,
余额 = t2.Balance,
贷款类型 = "个人贷款"
};
////test
//var q = from t in context.PersonalLoanInfoes
// select t;
////test
data.ItemsSource = q.ToList();
}
}
