//--买家查询余额--
/// <summary>
/// SearchBalance函数的功能：查询买家账户余额
/// </summary>
/// <param name="account">买家账号</param>
/// <returns></returns>
public double SearchBalance(string account)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
return(Date.searchBalanceOfBuyer(B));
}
/// <summary>
/// deleteBuyerByAccount函数的功能：根据买家账号删除买家表中的数据（删）
/// </summary>
/// <param name="buyer">买家对象</param>
public void deleteBuyerByAccount(buyer_Entity buyer)
{
var results = buyerDB.buyer_T.Where(r => r.b_account == buyer.B_account).Select(r => r);
buyerDB.buyer_T.DeleteAllOnSubmit(results);
buyerDB.SubmitChanges();
}
/// <summary>
/// SearchByName函数的功能：根据买家姓名查找买家信息
/// </summary>
/// <param name="name">买家的姓名</param>
/// <returns>返回的是根据买家姓名来查询买家信息的Linq查询结果的集合</returns>
public object SearchByName(string name)
{
buyer_Entity B = new buyer_Entity();
B.B_name = name;
return(Date.searchByName(B));
}
/// <summary>
/// ShowAnswer函数的功能：显示买家用户的密保问题的答案
/// </summary>
/// <param name="account">买家账号</param>
/// <returns>返回用户的密保问题的答案</returns>
public string ShowAnswer(string account)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
return(Date.Return_answer(B));
}
/// <summary>
/// ShowQuestion函数的功能：用于显示用户的密保问题
/// </summary>
/// <param name="account">买家账号</param>
/// <returns>返回用户的密保问题</returns>
public string ShowQuestion(string account)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
return(Date.Return_question(B));
}
protected void Button1_Click(object sender, EventArgs e)
{
buyer_Entity buyer = new buyer_Entity();
buyerIntSer B = new buyerIntSer();
buyer.B_account = Session["UserAccount"].ToString().Trim();
bool b = B.ifBuyerExist(buyer.B_account);
if (b)
{
buyer.B_name = txtName.Text;
buyer.B_tel = txtTel.Text;
buyer.B_question = DropDownList1.SelectedItem.Value;
buyer.B_answer = txtAnswer.Text;
buyer.B_email = txtEmail.Text;
B.BuyerModify(buyer.B_account, buyer.B_name, buyer.B_tel,
buyer.B_question, buyer.B_answer, buyer.B_email);
Response.Write(MessagesBox.showMessages("修改成功！"));
System.Threading.Thread.Sleep(1000);
Response.Redirect("~/Default.aspx");
}
else
{
Response.Write(MessagesBox.showMessages("信息修改失败，请重新进行修改操作！"));
}
}
/// <summary>
/// Updatepassword函数的功能：修改密码
/// </summary>
/// <param name="account">买家账号</param>
/// <param name="password">原密码</param>
public void Updatepassword(string account, string password)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
B.B_password = password;
Date.UpDatePassword(B);
}
//--买家充值--
/// <summary>
/// AddMoney函数的功能：买家充值
/// </summary>
/// <param name="account">买家账户</param>
/// <param name="money">充值金额</param>
public void AddMoney(string account, double money)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
B.B_balance = money;
Date.addmoney(B);
}
/// <summary>
/// login函数的功能：买家账号登录函数
/// login函数的实现：主要是通过验证给定的密码与数据库中账号对应的密码是否一致来判断是否登录成功
/// </summary>
/// <param name="account">买家账号</param>
/// <param name="password">登录时输入的密码</param>
/// <returns>如果验证成功返回true,验证失败返回false</returns>
public bool login(string account, string password)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
B.B_password = password;
bool result;
result = Date.user_login(B);
return(result);
}
/// <summary>
/// BuyerModify函数的功能：实现对买家用户信息的修改
/// </summary>
/// <param name="account">买家账号</param>
/// <param name="name">买家姓名</param>
/// <param name="tel">电话</param>
/// <param name="question">密保问题</param>
/// <param name="answer">答案</param>
/// <param name="email">电子邮箱</param>
public void BuyerModify(string account, string name, string tel, string question, string answer, string email)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
B.B_name = name;
B.B_tel = tel;
B.B_question = question;
B.B_answer = answer;
B.B_email = email;
Date.user_modify(B);
}
//--买家充值--
/// <summary>
/// addmoney函数的功能：访问数据库根据买家的账号修改买家的账户余额（改）
/// </summary>
/// <param name="buyer">买家对象</param>
public void addmoney(buyer_Entity buyer)
{
var results = buyerDB.buyer_T.Where(c => c.b_account.Equals(buyer.B_account));
if (results.Count() > 0)
{
foreach (buyer_T buyerT in results)
{
buyerT.b_balance += (decimal)buyer.B_balance;
}
buyerDB.SubmitChanges();
}
}
/// <summary>
/// UpDatePassword函数的功能：访问数据库根据用户的账户更新用户的密码
/// </summary>
/// <param name="buyer">买家对象</param>
public void UpDatePassword(buyer_Entity buyer)
{
var results = buyerDB.buyer_T.Where(r => r.b_account == buyer.B_account).Select(r => r);
if (results.Count() > 0)
{
foreach (buyer_T r in results)
{
r.b_password = buyer.B_password;
}
buyerDB.SubmitChanges();
}
}
/// <summary>
/// FindPassword函数的功能：验证用户输入的密保问题与注册时的密保答案是否一致
/// </summary>
/// <param name="account">买家账号</param>
/// <param name="answer">密保答案</param>
/// <returns>如果密保问题验证成功返回true，否则返回false</returns>
public bool FindPassword(string account, string answer)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
if (Date.Return_answer(B) == answer)
{
return(true);
}
else
{
return(false);
}
}
//--买家信息模块--
/// <summary>
/// user_reg函数的功能：向买家表中增加一条新的记录（增）
/// </summary>
/// <param name="buyer">买家对象</param>
public void user_reg(buyer_Entity buyer)
{
buyer_T Buyer = new buyer_T();
Buyer.b_account = buyer.B_account;
Buyer.b_password = buyer.B_password;
Buyer.b_name = buyer.B_name;
Buyer.b_tel = buyer.B_tel;
Buyer.b_question = buyer.B_question;
Buyer.b_answer = buyer.B_answer;
Buyer.b_email = buyer.B_email;
buyerDB.buyer_T.InsertOnSubmit(Buyer);
buyerDB.SubmitChanges();
}
/// <summary>
/// user_login函数的功能：访问数据库根据用户提供的账号查询对应的密码进行比较如果密码一样则登录成功，否则登录失败。
/// </summary>
/// <param name="buyer">买家对象</param>
/// <returns>如果密码验证成功返回true，否则返回false</returns>
public bool user_login(buyer_Entity buyer)
{
buyer_T Buyer = new buyer_T();
string passWord = buyerDB.buyer_T.Where(c => c.b_account.Equals(buyer.B_account)).Select(c => c.b_password).FirstOrDefault();
if (passWord != null)
{
if (passWord.Equals(buyer.B_password))
{
return(true);
}
}
return(false);
}
/// <summary>
/// user_modify函数的功能：买家表的修改（改）
/// </summary>
/// <param name="buyer">买家对象</param>
public void user_modify(buyer_Entity buyer)
{
var results = buyerDB.buyer_T.Where(r => r.b_account == buyer.B_account).Select(r => r);
if (results.Count() > 0)
{
foreach (buyer_T r in results)
{
r.b_name = buyer.B_name;
r.b_tel = buyer.B_tel;
r.b_question = buyer.B_question;
r.b_answer = buyer.B_answer;
r.b_email = buyer.B_email;
}
buyerDB.SubmitChanges();
}
}
//--买家信息模块--
/// <summary>
/// BuyerReg函数的功能：买家的注册
/// </summary>
/// <param name="account">买家账号</param>
/// <param name="password">账号密码</param>
/// <param name="name">买家姓名</param>
/// <param name="tel">联系电话</param>
/// <param name="question">密保问题</param>
/// <param name="answer">答案</param>
/// <param name="email">电子邮箱</param>
public bool BuyerReg(string account, string password, string name, string tel, string question, string answer, string email)
{
buyer_Entity B = new buyer_Entity();
B.B_account = account;
B.B_password = password;
B.B_name = name;
B.B_tel = tel;
B.B_question = question;
B.B_answer = answer;
B.B_email = email;
if (!Date.ifBuyerExist(B.B_account))
{
Date.user_reg(B);
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// ShowInformOfUseer函数的功能：买家表的查询（查）
/// </summary>
/// <param name="buyer">买家对象</param>
/// <returns>LINQ查询结果的集合</returns>
public object ShowInformOfUseer(buyer_Entity buyer)
{
var results = buyerDB.buyer_T.Select(r => r);
return((object)results);
}
//--买家查询余额--
/// <summary>
/// searchBalanceOfBuyer函数的功能：访问数据库根据买家的账号查询买家的账户余额
/// </summary>
/// <param name="buyer">买家对象</param>
/// <returns>LINQ查询结果的集合</returns>
public double searchBalanceOfBuyer(buyer_Entity buyer)
{
var balance = buyerDB.buyer_T.Where(b => b.b_account == buyer.B_account).Select(b => b.b_balance);
return((double)balance.FirstOrDefault());
}
/// <summary>
/// searchByName函数的功能：访问数据库根据买家名字查找出买家的信息
/// </summary>
/// <param name="buyer">买家对象</param>
/// <returns>LINQ查询结果的集合</returns>
public object searchByName(buyer_Entity buyer)
{
var Name = buyerDB.buyer_T.Where(r => r.b_name == buyer.B_name).Select(r => r);
return((object)Name);
}
/// <summary>
/// find_password函数的功能：访问数据库根据用户的账号查找用户的密保问题答案
/// </summary>
/// <param name="buyer">买家对象</param>
/// <returns>LINQ查询结果的集合</returns>
public string Return_answer(buyer_Entity buyer)
{
var Answer = buyerDB.buyer_T.Where(a => a.b_account == buyer.B_account).Select(a => a.b_answer);
return(Answer.First());
}
/// <summary>
/// Return_question函数的功能：访问数据库根据用户的账号查找用户的密保问题
/// </summary>
/// <param name="buyer">买家对象</param>
/// <returns>LINQ查询结果的集合</returns>
public string Return_question(buyer_Entity buyer)
{
var question = buyerDB.buyer_T.Where(q => q.b_account == buyer.B_account).Select(q => q.b_question);
return(question.First());
}
public object ShowUser()
{
buyer_Entity B = new buyer_Entity();
return(Date.ShowInformOfUseer(B));
}
