/// <summary>
/// 管理员注册
/// </summary>
/// <param name="Name"></param>
/// <param name="Password"></param>
public bool Insert(string Name, string Password)
{
using (XPMSEntities db = new XPMSEntities())
{
var query = from a in db.T_Admin
where a.Name.Equals(Name)
select a;
if (query.Count() > 0)
{
//1.判断唯一性
throw new Exception("用户名已存在");
}
else
{
//2.插入数据
var salt = Utils.Number(4);
T_Admin obj = new T_Admin()
{
Name = Name,
Password = DESEncrypt.Encrypt(Password, salt),
Salt = salt,
IsDelete = false,
IsLock = false
};
db.T_Admin.Add(obj);
return(true);
}
}
}
/// <summary>
/// 管理员登录
/// </summary>
public Model.T_Admin Get(string Name, string Password)
{
using (XPMSEntities db = new XPMSEntities())
{
var query = from a in db.T_Admin
where a.Name.Equals(Name)
select a;
if (query.Count() > 0)
{
var salt = query.FirstOrDefault().Salt;
Password = DESEncrypt.Encrypt(Password, salt);
var query2 = from a in db.T_Admin
where a.Name.Equals(Name) && a.Password.Equals(Password)
select a;
if (query2.Count() > 0)
{
return(query2.FirstOrDefault());
}
else
{
throw new Exception("密码错误");
}
}
throw new Exception("该用户名不存在");
}
}
/// <summary>
/// 取出所有的房间类型
/// </summary>
/// <returns></returns>
public List <T_RoomType> GetAll()
{
using (XPMSEntities db = new XPMSEntities())
{
var query = from a in db.T_RoomType
where a.IsDelete == true
select a;
var type = query.ToList().GetType();
return(query.ToList());
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool Insert(T_RoomType obj)
{
using (XPMSEntities db = new XPMSEntities())
{
var query = from a in db.T_RoomType
where a.Name.Equals(obj.Name)
select a;
if (query.Count() > 0)
{
throw new Exception("该名称已存在");
}
var model = db.T_RoomType.Add(obj);
if (model == null)
{
return(false);
}
else
{
return(true);
}
}
}
