internal static IList <UserEntity> GetFriends(int count, int uid)
{
return(EB <UserEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT TOP " + count + " user_account.* FROM user_account INNER JOIN friend ON friend.uid2=user_account.id WHERE friend.uid1=@uid", new SqlParameter("@uid", uid)));
}
/// <summary>
/// 获取最近加入组织的用户信息
/// </summary>
/// <param name="count">获取的最大数量</param>
/// <returns>返回实体列表</returns>
internal static IList <UserStatusEntity> GetRecent(int count)
{
return(EB <UserStatusEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT TOP " + count + " * FROM user_status ORDER BY created DESC"));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
internal static IList <UserEntity> GetInvited(int id)
{
return(EB <UserEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT TOP 20 id,www,name,avatar FROM user_account WHERE id in(SELECT invited_id FROM inviteinfo WHERE id=@id and used=1) ORDER BY id ASC", new SqlParameter("@id", id)));
}
public static IList <RoleEntity> GetRoleList()
{
return(EB <RoleEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT * FROM role"));
}
internal static IList <AppEntity> GetAppList(int roleid)
{
return(EB <AppEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT app.* FROM role_app INNER JOIN app ON appid=app.id WHERE roleid=@roleid AND allowaccess=1 AND app.enabled=1 ORDER BY displayorder ASC",
new SqlParameter("@roleid", roleid)));
}
internal static IList <DistrictEntity> ListDistrict(int levelcode, int pid)
{
return(EB <DistrictEntity> .List(QA.DBCS_STATIC, CommandType.Text, "SELECT * FROM district WHERE pid=@pid AND levelcode=@levelcode", new SqlParameter("@pid", pid), new SqlParameter("@levelcode", levelcode)));
}
internal static IList <EventEntity> ListUserPublicEvent(int uid, int count)
{
return(EB <EventEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT TOP " + count + " * FROM event WHERE uid=@uid AND type=0", new SqlParameter("@uid", uid)));
}
internal static IList <EventEntity> ListEvent(int uid, int count, int eid)
{
return(EB <EventEntity> .List(QA.DBCS_MAIN, CommandType.Text, "SELECT TOP " + count + " event.* FROM event_index INNER JOIN event ON event_index.eid=event.id WHERE event_index.uid=@uid AND event_index.eid>@eid",
new SqlParameter("@uid", uid),
new SqlParameter("@eid", eid)));
}
