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