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); }