using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using DataSetNetShopTableAdapters;
/// <summary>
/// Summary description for Employees
/// </summary>
[System.ComponentModel.DataObject]
public class UserBLL
{
private UserInfoTableAdapter _userAdapter = null;
protected UserInfoTableAdapter Adapter
{
get
{
if (_userAdapter == null)
_userAdapter = new UserInfoTableAdapter();
return _userAdapter;
}
}
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public DataSetNetShop.UserInfoDataTable GetUsers()
{
return Adapter.GetUsers();
}
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public DataSetNetShop.UserInfoRow GetUserByID(int ID)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByID(ID);
return users[0];
}
public DataSetNetShop.UserInfoRow GetUserByname(string name)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByname(name);
return users[0];
}
public bool Add(string name, string password, string email)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByname(name);
if (users.Count > 0)
{
return false;
}
decimal Money = 0;
int affectedRow = Adapter.Insert(name,password,email,Convert.ToDouble(Money));
return (affectedRow == 1);
}
public bool AddMoney(int id, string password, decimal money)
{
//UserBLL user = new UserBLL();
if (CheckPwd(id, password) == true)
{
DataSetNetShop.UserInfoRow user = GetUserByID(id);
user.Money += Convert.ToDouble(money);
int affectedRow = Adapter.Update(user);
return (affectedRow == 1);
}
else
{
return false;
}
}
public bool AddMoney(string name, string password, decimal money)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByname(name);
if (users.Count== 0)
{
return false;
}
DataSetNetShop.UserInfoRow user = users[0];
return AddMoney(Convert.ToInt32(user.ID), password, Convert.ToDecimal(money));
}
public decimal ShowMoney(string name)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByname(name);
DataSetNetShop.UserInfoRow user = users[0];
return Convert.ToDecimal(user.Money);
}
public bool CheckPwd(int id, string password)
{
DataSetNetShop.UserInfoRow user = GetUserByID(id);
if (user.ID == id && user.password == password)
{
return true;
}
else
{
return false;
}
}
public bool Checkname(string name)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByname(name);
if (users.Count==0)// 等于0表示没有注册过
{
return true;
}
else
{
return false;
}
}
public bool CheckPwd(string name, string password)
{
DataSetNetShop.UserInfoDataTable users = Adapter.GetUserByname(name);
if (users.Count == 0)
{
return false;
}
DataSetNetShop.UserInfoRow user = users[0];
if (user.name == name && user.password == password)
{
return true;
}
else
{
return false;
}
}
}