/// <summary> /// /// </summary> /// <param name="key"></param> /// <returns></returns> internal static UserEntity FromUrlKey(string key) { return(EB <UserEntity> .Get("SELECT * FROM user_account WHERE www=@www", new SqlParameter("@www", key))); }
internal static AttachmentEntity Get(int type, int uid, int referid) { return(EB <AttachmentEntity> .Get("SELECT TOP 1 * FROM attachment WHERE type=@type AND uid=@uid AND refer_id=@refer_id", new SqlParameter("@type", type), new SqlParameter("@uid", uid), new SqlParameter("@referid", referid))); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> internal static UserEntity Get(int id) { return(EB <UserEntity> .Get("SELECT * FROM user_account WHERE id=@id", new SqlParameter("@id", id))); }
/// <summary> /// 根据用户名和密码获取对应的账户实体对象. /// </summary> /// <param name="name">用户名</param> /// <param name="passwd">密码</param> /// <returns>如果无匹配的对象则返回null.</returns> public static UserEntity LoginByEmail(string email, string passwd) { return(EB <UserEntity> .Get("SELECT * FROM user_account WHERE email=@email AND passwd=@passwd AND status=0", new SqlParameter("@email", email), new SqlParameter("@passwd", passwd))); }
/// <summary> /// 获取用户的状态数据实体 /// </summary> /// <param name="uid">用户标识</param> /// <returns>返回对应的用户状态实体</returns> internal static UserStatusEntity GetStatus(int uid) { return(EB <UserStatusEntity> .Get("SELECT * FROM user_status WHERE uid=@uid", new SqlParameter("@uid", uid))); }
/// <summary> /// 根据用户名和密码获取对应的账户实体对象. /// </summary> /// <param name="name">用户名</param> /// <param name="passwd">密码</param> /// <returns>如果无匹配的对象则返回null.</returns> public static UserEntity LoginByName(string name, string passwd) { return(EB <UserEntity> .Get("SELECT * FROM user_account WHERE name=@name AND passwd=@passwd AND status=0", new SqlParameter("@name", name), new SqlParameter("@passwd", passwd))); }
/// <summary> /// /// </summary> /// <param name="code"></param> /// <returns></returns> internal static UserStatusEntity FromCode(string code) { return(EB <UserStatusEntity> .Get("SELECT * FROM user_status INNER JOIN inviteinfo ON user_status.uid = inviteinfo.id WHERE inviteinfo.code=@code and used=0", new SqlParameter("@code", code))); }