public IQueryable <user> Test()
{
barteammanagedbEntities1 db = new barteammanagedbEntities1();
var result = from a in db.user
select a;
return(result);
}
/// <summary>
/// 通过账号得到用户的姓名和昵称
/// </summary>
/// <param name="account">账号</param>
/// <returns></returns>
public IQueryable <user> FindNickName(string account)
{
barteammanagedbEntities1 db = new barteammanagedbEntities1();
var result = from u in db.user
where u.vcUserAccount == account
select u;
return(result);
}
/// <summary>
/// 检查用户的注册状态
/// </summary>
/// <param name="account">账号</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
public IQueryable <user> CheckUserRegisterStatus(string account, string pwd)
{
barteammanagedbEntities1 db = new barteammanagedbEntities1();
var result = from a in db.user
where a.vcUserAccount == account && a.vcPassWord == pwd
select a;
return(result);
}
/// <summary>
/// 检查用户的账号是否被注册
/// </summary>
/// <param name="account">用户账号</param>
/// <returns></returns>
public IQueryable <user> CheckAccount(string account)
{
barteammanagedbEntities1 db = new barteammanagedbEntities1();
var reslut = from a in db.user
where a.vcUserAccount == account
select a;
return(reslut);
}
/// <summary>
/// 根据name获取数据库中的数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IQueryable <webmaster> GetWebmasterByName(string name)
{
barteammanagedbEntities1 db = new barteammanagedbEntities1();
var webMaster = from web in db.webmaster
where web.vcName.ToUpper() == name.ToUpper()
select web;
return(webMaster);
}
/// <summary>
/// 得到用户的身份标识
/// </summary>
/// <param name="id">用户id</param>
/// <returns></returns>
public IQueryable <registerlogin> LoginUserIdentity(int id)
{
barteammanagedbEntities1 db = new barteammanagedbEntities1();
var reslut = from a in db.registerlogin
where a.iUserID == id
select a;
return(reslut);
}
/// <summary>
/// 线程槽
/// </summary>
/// <returns></returns>
public static DbContext CreateDbContext()
{
DbContext dbContext = (DbContext)CallContext.GetData("DbContext");
if (dbContext == null)
{
dbContext = new barteammanagedbEntities1();
CallContext.SetData("DbContext", dbContext);
}
return(dbContext);
}
