public static TList <GE.MyLearning.BL.UserInfo> GetUserListByGroupID(string groupid)
{
string whereClause = "";
if ((groupid == null) || (groupid == ""))
{
whereClause = "UserID not in (select UserID from UserGroup)";
}
else
{
whereClause = "UserID in (select UserID from UserGroup where GroupID=" + CommonClass.sqlString(groupid) + ")";
}
string orderBy = "UserCNName";
int count = -1;
return(DataRepository.UserInfoProvider.GetPaged(whereClause, orderBy, 0, 0x7fffffff, out count));
}
public static TList <GE.MyLearning.BL.UserInfo> GetUserListByGroupIDAndPermissionID(string groupid, string permissionId)
{
string whereClause = "UserID in ( select UserID from UserRole as a inner join RolePermission as b on a.RoleID=b.RoleID where PermissionId=" + CommonClass.sqlString(permissionId) + ")";
if ((groupid == "") || (groupid == null))
{
whereClause = whereClause + " and UserID not in (select UserID from UserGroup)";
}
else
{
whereClause = whereClause + " and UserID in (select UserID from UserGroup where GroupID=" + CommonClass.sqlString(groupid) + ")";
}
string orderBy = "UserCNName";
int count = -1;
return(DataRepository.UserInfoProvider.GetPaged(whereClause, orderBy, 0, 0x7fffffff, out count));
}
public static string GetCourseRelationId()
{
return(CommonClass.BindId(DbHelperSQL.GetMaxID("CourseRelationID", "dbo.CourseRelation")));
}