internal static IList <string> List()
{
return(DBH.GetList <string>(QA.DBCS_MAIN, CommandType.Text, "SELECT typename FROM ajaxmethods"));
}
/// <summary>
/// 获取可用的邀请码
/// </summary>
/// <param name="id">用户标识</param>
/// <returns>返回邀请码列表，如果没有可用的邀请码返回NULL</returns>
public static IList <string> GetInviteCode(int id)
{
return(DBH.GetList <string>(QA.DBCS_MAIN, CommandType.Text, "SELECT code FROM inviteinfo WHERE id=@id AND used=0", new SqlParameter("@id", id)));
}
public static IList <int> GetRoleExList(int uid)
{
return(DBH.GetList <int>(QA.DBCS_MAIN, CommandType.Text, "SELECT roleid FROM user_role_ex WHERE uid=@uid", new SqlParameter("@uid", uid)));
}