public BasicInfoForm()
{
InitializeComponent();
this.StartPosition = StartPosition = FormStartPosition.CenterScreen;
BankDataContext bd = new BankDataContext();
}
private void newToolStripButton_Click(object sender, EventArgs e)
{
count = 1;
this.pictureBox1.Image = null;
textBoxID.Text = "";
textBoxName.Text = "";
radioButton1.Checked = true;
dateTimePicker.Value = DateTime.Now;
textBoxPhoneNumber.Text = "";
textBoxPID.Text = "";
BankDataContext d = new BankDataContext();
var q = from t in d.EmployeeInfo
select t.编号;
int max = int.Parse(q.Max()) + 1;
string ii = "0000";
if (max >= 10)
{
ii = "000";
}
if (max >= 100)
{
ii = "00";
}
string i = ii + max.ToString();
textBoxID.Text = i;
}
private void textBoxAccount_TextChanged(object sender, EventArgs e)
{
int Number;
if (textBoxAccount.Text == "")
{
MessageBox.Show("请输入账号");
return;
}
try
{
Number = Convert.ToInt32(textBoxAccount.Text);
}
catch (Exception)
{
textBoxAccount.Text = "";
return;
}
if (Number > 300000)
{
textBoxMoney.ReadOnly = true;
try
{
Custom custom = DataOperation.GetCustom(textBoxAccount.Text.Trim());
BankDataContext c = new BankDataContext();
var q = from t in c.MoneyInfo
where t.帐号 == custom.AccountInfo.帐号 && t.发生类别 == "开户"
select t.余额;
textBoxMoney.ReadOnly = true;
textBoxMoney.Text = q.Max().ToString();
}
catch (Exception) { }
}
}
public List <Person> ByEmailUser(string email)
{
List <Person> users = new List <Person>();
BankDataContext context = new BankDataContext();
users = context.People.Where(x => x.Email == email).ToList();
return(users);
}
/// 开户
/// </summary>
/// <param name="accountNumber">帐号</param>
/// <param name="money">开户金额</param>
public virtual void Create(string accountNumber, double money)
{
this.AccountBalance = money;
BankDataContext c = new BankDataContext();
c.AccountInfo.InsertOnSubmit(AccountInfo);
c.SubmitChanges();
this.MoneyInfo.帐号 = accountNumber;
InsertData("开户", money);
}
public FlexibleForm()
{
InitializeComponent();
c = new BankDataContext();
var q = (from t in c.RateInfo
where t.类别 == "活期"
select t).Single();
txtOldRate.Text = q.利率.ToString("f4");
}
public static int PhoneByNumber(this BankDataContext context, string Phonenumber)
{
// List<int> registerPhones = new List<int>();
//registerPhones = (from e in context.RegisterPhones
// where e.NumberPhone == Phonenumber
// select e.PersonId).ToList();
int registerPhones = context.RegisterPhones.Where(x => x.NumberPhone == Phonenumber).Select(x => x.PersonId).FirstOrDefault();
return(registerPhones);
}
private void cmbDBIType_SelectedIndexChanged(object sender, EventArgs e)
{
txtNewRate.Clear();
c = new BankDataContext();
var q = (from t in c.RateInfo
where t.类别 == cmbDBIType.Text
select t.利率).Single();
txtOldRate.Text = q.ToString();
}
public void AddBalance(List <CardModel> cards)
{
using (BankDataContext context = new BankDataContext())
{
decimal bl = cards.Select(y => y.Balance).FirstOrDefault();
int id = cards.Select(y => y.Id).FirstOrDefault();
var ss = context.Cards.Where(x => x.Id == id).ToList().First();
ss.Balance = bl;
context.SaveChanges();
}
}
/// <summary>
/// 在表中添加新记录
/// </summary>
/// <param name="genType">发生类别</param>
/// <param name="money">发生金额</param>
public void InsertData(string genType, double money)
{
BankDataContext c = new BankDataContext();
this.MoneyInfo.帐号 = this.AccountInfo.帐号;
this.MoneyInfo.发生时间 = DateTime.Now;
this.MoneyInfo.发生类别 = genType;
this.MoneyInfo.发生金额 = money;
this.MoneyInfo.余额 = AccountBalance;
c.MoneyInfo.InsertOnSubmit(this.MoneyInfo);
c.SubmitChanges();
}
public static bool PhoneByAbuneCode(this BankDataContext context, int Abunecode)
{
bool isfound = false;
int registerPhones = context.InternetModels.Where(x => x.AbuneKodu == Abunecode).Select(x => x.Id).FirstOrDefault();
if (registerPhones != 0)
{
isfound = true;
}
return(isfound);
}
public void InsertMessage(string message, List <CardModel> cards, string repaymentName)
{
using (BankDataContext context = new BankDataContext())
{
int id = context.Repayments.Where(x => x.RepaymentName == repaymentName).Select(x => x.Id).FirstOrDefault();
context.AddMessages.Add(new AddMessages
{
UserMessage = message,
PersonId = cards.Select(x => x.PersonId).FirstOrDefault(),
RepaymentId = id
});
context.SaveChanges();
}
}
public BankDataContext CreateContext()
{
if (connection == null)
{
connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
var options = CreateOptions();
using var context = new BankDataContext(options);
context.Database.EnsureCreated();
}
return(new BankDataContext(CreateOptions()));
}
private void txtFixedType_SelectedIndexChanged(object sender, EventArgs e)
{
txtNewRate.Clear();
c = new BankDataContext();
try
{
var q = (from t in c.RateInfo
where t.类别 == cmbFixedType.Text
select t.利率).Single();
txtOldRate.Text = q.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ChangeCustomPassword_Load(object sender, EventArgs e)
{
try
{
BankDataContext bd = new BankDataContext();
var q = from t in bd.AccountInfo
select t.帐号;
string[] range = q.ToArray();
this.comboBox1.Items.AddRange(range);
this.comboBox1.SelectedIndex = 0;
}
catch (Exception)
{
MessageBox.Show("没有帐号");
}
}
private void comboBoxAccountType_SelectedIndexChanged(object sender, EventArgs e)
{
string s = comboBoxAccountType.SelectedItem.ToString();
BankDataContext c = new BankDataContext();
var q = from t in c.AccountInfo
where t.存款类型 == s
select t;
if (q.Count() > 0)
{
textBoxAccount.Text = string.Format("{0}", int.Parse(q.Max(x => x.帐号)) + 1);
}
else
{
textBoxAccount.Text = string.Format("{0}00001", comboBoxAccountType.SelectedIndex + 1);
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
float rate = float.Parse(txtNewRate.Text.ToString());
c = new BankDataContext();
var q = (from t in c.RateInfo
where t.类别 == "活期"
select t).Single();
q.利率 = rate;
c.SubmitChanges();
MessageBox.Show("修改成功");
}
catch (Exception)
{
MessageBox.Show("请输入调整后利率");
}
}
private void btnTotal_Click(object sender, EventArgs e)
{
label3.Hide();
BankDataContext c = new BankDataContext();
var q = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生类别 == "存款" || t2.发生类别 == "开户"
where t1.身份证号 == txtID.Text
select new
{
身份证号 = t1.身份证号,
姓名 = t1.姓名,
帐号 = t1.帐号,
存款类型 = t2.发生类别,
余额 = string.Format("{0,8:f2}", t2.余额),
};
dataGridView1.DataSource = q;
}
public ShowCustomForm()
{
InitializeComponent();
BankDataContext c = new BankDataContext();
var q = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
select new
{
时间 = string.Format("{0:yyyy-MM-dd[HH:mm:ss]}", t2.发生时间),
帐号 = t1.帐号,
姓名 = t1.姓名,
存款类型 = t1.存款类型,
类别 = t2.发生类别,
金额 = string.Format("{0,8:f2}", t2.发生金额),
余额 = string.Format("{0,8:f2}", t2.余额)
};
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGridView1.DataSource = q;
}
public List <CardModel> GettAllCardById(int id)
{
List <CardModel> vs = new List <CardModel>();
using (BankDataContext context = new BankDataContext())
{
//vs = (from e in context.People
// join pp in context.Cards
// on e.Id equals pp.PersonId
// where e.Id == id
// select new CardModel
// {
// Id = pp.Id,
// Name = e.Name,
// Surname = e.Surname,
// CardName = pp.CardName,
// CardType = pp.CardType,
// CardNumber = pp.CardNumber,
// ExpireDeath = pp.ExpireDeath,
// CVC = pp.CVC
// }).ToList();
vs = context.Cards.Join(context.People, x => x.PersonId, y => y.Id, (x, y) => new CardModel
{
Id = x.Id,
Name = y.Name,
Surname = y.Surname,
CardName = x.CardName,
CardType = x.CardType,
CardNumber = x.CardNumber,
ExpireDeath = x.ExpireDeath,
CVC = x.CVC,
Balance = x.Balance,
PersonId = x.PersonId
}).Where(x => x.PersonId == id).ToList();
}
return(vs);
}
private void btnOK_Click(object sender, EventArgs e)
{
string oldPass, newPass, confirmPass;
if (txtPid.Text == "")
{
MessageBox.Show("请输入身份证号");
return;
}
else
{
oldPass = txtPid.Text;
}
if (txtNew.Text == "")
{
MessageBox.Show("请输入新密码");
return;
}
else
{
newPass = txtNew.Text;
}
if (txtConfirm.Text == "")
{
MessageBox.Show("请再次输入新密码");
return;
}
else
{
confirmPass = txtConfirm.Text;
}
if (newPass != confirmPass)
{
MessageBox.Show("输入的两次新密码不一致");
return;
}
else if (ValidatingTest(newPass) == false)
{
MessageBox.Show("新密码输入包含非法符号");
}
else
{
string id = this.comboBox1.SelectedItem.ToString();
BankDataContext bd = new BankDataContext();
var q = from t in bd.AccountInfo
where t.帐号 == id
select t.身份证号;
string getPass = q.Single().ToString();
if (getPass != oldPass)
{
MessageBox.Show("身份证号错误");
return;
}
else
{
var q2 = from t in bd.AccountInfo
where t.帐号 == id
select t;
q2.Single().密码 = newPass.Trim();//取消两边空格
bd.SubmitChanges();
MessageBox.Show("密码修改成功");
//textbox置空
txtPid.Text = "";
txtNew.Text = "";
txtConfirm.Text = "";
}
}
}
public SumForm()
{
InitializeComponent();
BankDataContext c = new BankDataContext();
//在dataGridView中显示当天金额发生数据
var q = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生时间.Day == DateTime.Now.Day
select new
{
时间 = string.Format("{0:yyyy-MM-dd[HH:mm:ss]}", t2.发生时间),
帐号 = t1.帐号,
姓名 = t1.姓名,
存款类型 = t1.存款类型,
类别 = t2.发生类别,
金额 = string.Format("{0,8:f2}", t2.发生金额),
余额 = string.Format("{0,8:f2}", t2.余额)
};
dataGridView1.DataSource = q;
//计算显示当天存款总汇，取款总会，金额总汇
var q1 = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生时间.Day == DateTime.Now.Day
where t2.发生类别 == "存款" || t2.发生类别 == "开户"
select t2.发生金额;
var q2 = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生时间.Day == DateTime.Now.Day
where t2.发生类别 == "取款"
select t2.发生金额;
if (q1.Count() == 0)
{
if (q2.Count() == 0)
{
txtDespoit.Text = "0";
textWithdraw.Text = "0";
textSum.Text = "0";
dataGridView1.DataSource = q;
}
else
{
txtDespoit.Text = "0";
textWithdraw.Text = Math.Abs(q2.Sum()).ToString();
textSum.Text = (q1.Sum() + q2.Sum()).ToString();
dataGridView1.DataSource = q;
}
}
else
{
if (q2.Count() == 0)
{
txtDespoit.Text = q1.Sum().ToString();
textWithdraw.Text = "0";
textSum.Text = q1.Sum().ToString();
dataGridView1.DataSource = q;
}
else
{
txtDespoit.Text = q1.Sum().ToString();
textWithdraw.Text = Math.Abs(q2.Sum()).ToString();
textSum.Text = (q1.Sum() + q2.Sum()).ToString();
dataGridView1.DataSource = q;
}
}
}
// 查询其他日期的金额总汇
private void btnTotal_Click(object sender, EventArgs e)
{
BankDataContext c = new BankDataContext();
var q = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生时间.Year == dateTimePicker1.Value.Year && t2.发生时间.Month == dateTimePicker1.Value.Month && t2.发生时间.Day == dateTimePicker1.Value.Day
select new
{
时间 = string.Format("{0:yyyy-MM-dd[HH:mm:ss]}", t2.发生时间),
帐号 = t1.帐号,
姓名 = t1.姓名,
存款类型 = t1.存款类型,
类别 = t2.发生类别,
金额 = string.Format("{0,8:f2}", t2.发生金额),
余额 = string.Format("{0,8:f2}", t2.余额)
};
if (dateTimePicker1.Value.Year == DateTime.Now.Year && dateTimePicker1.Value.Month == DateTime.Now.Month && dateTimePicker1.Value.Day == DateTime.Now.Day)
{
labDespoit.Text = "今日取款金额";
labWithdraw.Text = "今日取款金额";
labSum.Text = "今日金额总汇";
}
else
{
labDespoit.Text = dateTimePicker1.Text + "存款金额：";
labWithdraw.Text = dateTimePicker1.Text + "取款总汇";
labSum.Text = dateTimePicker1.Text + "金额总汇";
}
var q1 = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生时间.Year == dateTimePicker1.Value.Year && t2.发生时间.Month == dateTimePicker1.Value.Month && t2.发生时间.Day == dateTimePicker1.Value.Day
where t2.发生类别 == "存款" || t2.发生类别 == "开户"
select t2.发生金额;
var q2 = from t1 in c.AccountInfo
from t2 in c.MoneyInfo
where t1.帐号 == t2.帐号
where t2.发生时间.Year == dateTimePicker1.Value.Year && t2.发生时间.Month == dateTimePicker1.Value.Month && t2.发生时间.Day == dateTimePicker1.Value.Day
where t2.发生类别 == "取款"
select t2.发生金额;
if (q1.Count() == 0)
{
if (q2.Count() == 0)
{
txtDespoit.Text = "0";
textWithdraw.Text = "0";
textSum.Text = "0";
dataGridView1.DataSource = q;
}
else
{
txtDespoit.Text = "0";
textWithdraw.Text = Math.Abs(q2.Sum()).ToString();
textSum.Text = (q1.Sum() + q2.Sum()).ToString();
dataGridView1.DataSource = q;
}
}
else
{
if (q2.Count() == 0)
{
txtDespoit.Text = q1.Sum().ToString();
textWithdraw.Text = "0";
textSum.Text = q1.Sum().ToString();
dataGridView1.DataSource = q;
}
else
{
txtDespoit.Text = q1.Sum().ToString();
textWithdraw.Text = Math.Abs(q2.Sum()).ToString();
textSum.Text = (q1.Sum() + q2.Sum()).ToString();
dataGridView1.DataSource = q;
}
}
}
private void buttonSubmit_Click(object sender, EventArgs e)
{
string oldPass, newPass, confirmPass;
if (textBoxOldPassword.Text == "")
{
MessageBox.Show("请输入原密码");
return;
}
else
{
oldPass = textBoxOldPassword.Text;
}
if (textBoxNewPassword.Text == "")
{
MessageBox.Show("请输入新密码");
return;
}
else
{
newPass = textBoxNewPassword.Text;
}
if (textBoxPasswordConfirm.Text == "")
{
MessageBox.Show("请再次输入新密码");
return;
}
else
{
confirmPass = textBoxPasswordConfirm.Text;
}
if (newPass != confirmPass)
{
MessageBox.Show("输入的两次新密码不一致");
return;
}
else if (ValidatingTest(newPass) == false)
{
MessageBox.Show("新密码输入包含非法符号");
}
else
{
BankDataContext bd = new BankDataContext();
var q = from t in bd.LoginInfo
where t.编号 == id
select t.密码;
string getPass = q.Single().ToString();
if (getPass != oldPass)
{
MessageBox.Show("原密码错误");
return;
}
else
{
var q2 = from t in bd.LoginInfo
where t.编号 == id
select t;
q2.Single().密码 = newPass.Trim();//取消两边空格
bd.SubmitChanges();
MessageBox.Show("密码修改成功");
//textbox置空
textBoxNewPassword.Text = "";
textBoxOldPassword.Text = "";
textBoxPasswordConfirm.Text = "";
}
}
}
private void 保存SToolStripButton_Click(object sender, EventArgs e)
{
//获取业务员信息并验证
string id1 = textBoxID.Text;
string name;
if ((textBoxName.Text == "") ||
textBoxName.Text.Length > 4 ||
textBoxName.Text.Length < 2 ||
(regChina.IsMatch(textBoxName.Text) == false))
{
MessageBox.Show("姓名长度为2-4，且只能为汉字");
return;
}
else
{
name = textBoxName.Text;
}
char sex;
if (radioButton1.Checked == true)
{
sex = '女';
}
else
{
sex = '男';
}
System.DateTime date = dateTimePicker.Value;
string pid;
if (textBoxPID.Text.Trim() == "" || ValidatingTest2(textBoxPID.Text.Trim()) == false)
{
MessageBox.Show("请输入正确格式的身份证号");
return;
}
else
{
pid = textBoxPID.Text.Trim();
}
//string salary = textBoxSalary.Text;
string phoneNum;
if (ValidatingTest2(textBoxPhoneNumber.Text) == false)
{
MessageBox.Show("请输入正确格式的电话");
return;
}
else
{
phoneNum = textBoxPhoneNumber.Text;
}
BankDataContext bd = new BankDataContext();
//修改或保存新信息
//int max = bd.EmployeeInfo.Count()+1;
//int tb = int.Parse(textBoxID.Text);
if (count == 0)//修改
{
if (this.pictureBox1.Image == null)
{
MessageBox.Show("没有照片");
return;
}
//pic获取到数组
getPic();
var q = from t in bd.EmployeeInfo
where t.编号 == id1
select t;
q.Single().姓名 = name;
q.Single().性别 = sex;
q.Single().参加工作日期 = date;
q.Single().身份证号 = pid;
//q.Single().工资 = Convert.ToDecimal(salary);
q.Single().联系电话 = phoneNum;
q.Single().照片 = new System.Data.Linq.Binary(by);
bd.SubmitChanges();
MessageBox.Show("保存成功！");
}
else//添加新操作员信息
{
if (this.pictureBox1.Image == null)
{
MessageBox.Show("没有照片");
return;
}
//pic获取到数组
getPic();
SqlConnection conn = new SqlConnection(Properties.Settings.Default.BankConnectionString);
SqlDataAdapter adapter = new SqlDataAdapter("select * from EmployeeInfo", conn);
SqlCommandBuilder builder = new SqlCommandBuilder(adapter);
adapter.InsertCommand = builder.GetInsertCommand();
adapter.DeleteCommand = builder.GetDeleteCommand();
adapter.UpdateCommand = builder.GetUpdateCommand();
DataTable table = new DataTable();
adapter.Fill(table);
DataRow row = table.NewRow();
row[0] = id1;
row[1] = name;
row[2] = sex;
row[3] = date;
row[4] = phoneNum;
row[5] = pid;
row[6] = by;
table.Rows.Add(row);
adapter.Update(table);
//添加登陆界面信息，默认密码：身份证
BankDataContext b = new BankDataContext();
LoginInfo ta = new LoginInfo();
ta.编号 = id1;
ta.密码 = pid;
b.LoginInfo.InsertOnSubmit(ta);
b.SubmitChanges();
MessageBox.Show("新建成功，初始密码为身份证号");
}
count = 0;
//更新到datagridview
if (id == "00001")
{
var q1 = from t in bd.EmployeeInfo
select new
{
编号 = t.编号,
姓名 = t.姓名,
性别 = t.性别,
参加工作日期 = t.参加工作日期,
电话 = t.联系电话,
身份证号 = t.身份证号,
//工资 = t.工资,
//照片 = t.照片
};
//datagridview显示数据
BindingSource bs = new BindingSource();
bs.DataSource = q1;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.DataSource = bs;
bindingNavigator1.BindingSource = bs;
}
}
private void 剪切UToolStripButton_Click(object sender, EventArgs e)
{
count = 0;
string id1 = textBoxID.Text;
if (id1 == "00001")
{
MessageBox.Show("管理员不能删除");
return;
}
BankDataContext bd = new BankDataContext();
var q1 = from t in bd.EmployeeInfo
where t.编号 == id1
select t;
if (q1.Count() > 0)
{
var q11 = q1.First();
bd.EmployeeInfo.DeleteOnSubmit(q11);
bd.SubmitChanges();
}
var qq2 = from t2 in bd.LoginInfo
where t2.编号 == id1
select t2;
if (qq2.Count() > 0)
{
var qqq = qq2.First();
bd.LoginInfo.DeleteOnSubmit(qqq);
bd.SubmitChanges();
}
MessageBox.Show("删除成功");
BankDataContext c = new BankDataContext();
var qq = from t in c.EmployeeInfo
select new
{
编号 = t.编号,
姓名 = t.姓名,
性别 = t.性别,
参加工作日期 = t.参加工作日期,
电话 = t.联系电话,
身份证号 = t.身份证号,
//工资 = t.工资,
//照片 = t.照片
};
//datagridview显示数据
BindingSource bds1 = new BindingSource();
bds1.DataSource = qq;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.DataSource = bds1;
bindingNavigator1.BindingSource = bds1;
}
public HomeController(ILogger <HomeController> logger, BankDataContext dbContext)
{
_logger = logger;
_dbContext = dbContext;
}
private void BasicInfoForm_Load(object sender, EventArgs e)
{
count = 0;
//datagridview信息
BindingSource bds1 = new BindingSource();
BankDataContext c = new BankDataContext();
if (id == "00001")
{
label1.Hide();
newToolStripButton.Visible = true;
剪切UToolStripButton.Visible = true;
dataGridView1.Show();
var q1 = from t in c.EmployeeInfo
select new
{
编号 = t.编号,
姓名 = t.姓名,
性别 = t.性别,
参加工作日期 = t.参加工作日期,
电话 = t.联系电话,
身份证号 = t.身份证号,
//工资 = t.工资,
//照片 = t.照片
};
//datagridview显示数据
bds1.DataSource = q1;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.DataSource = bds1;
//navigator绑定
bindingNavigator1.BindingSource = bds1;
//textbox显示数据
Display();
//照片导入
if (this.pictureBox1.Image != null)
{
this.pictureBox1.Image.Dispose();
}
this.pictureBox1.Image = DataOperation.GetOperatePicture(textBoxID.Text);
}
else
{
this.Refresh();
dataGridView1.Hide();
newToolStripButton.Visible = false;
剪切UToolStripButton.Visible = false;
label1.Show();
var q2 = from t in c.EmployeeInfo
where t.编号 == id
select t;
bindingNavigator1.BindingSource = bds1;
bds1.DataSource = q2;
//textbox显示数据
textBoxID.Text = q2.Single().编号;
textBoxName.Text = q2.Single().姓名;
if (q2.Single().性别 == '女')
{
radioButton1.Checked = true;
radioButton2.Checked = false;
}
else
{
radioButton1.Checked = false;
radioButton2.Checked = true;
}
dateTimePicker.Text = q2.Single().参加工作日期.ToString();
textBoxPID.Text = q2.Single().身份证号;
//textBoxSalary.Text = q2.Single().工资.ToString();
textBoxPhoneNumber.Text = q2.Single().联系电话;
//照片导入
if (this.pictureBox1.Image != null)
{
this.pictureBox1.Image.Dispose();
}
this.pictureBox1.Image = DataOperation.GetOperatePicture(textBoxID.Text);
}
}
public ClientService(BankDataContext dataContext, IMapper mapper)
{
_dataContext = dataContext;
_mapper = mapper;
}
public AccountsService(BankDataContext dataContext, IMapper mapper)
{
_dataContext = dataContext;
_mapper = mapper;
}
