/// <summary>
/// 获取关注用户列表
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public ArrayList getFollowlist(string uid)
{
ArrayList list = new ArrayList();
string sql = "select a.* from " + GlobalVar.User.TABLE_USER + " a left join " + GlobalVar.Follow.TABLE_FOLLOW + " b on a." + GlobalVar.User.UID + "=b." + GlobalVar.Follow.FOLLOW + " where b." + GlobalVar.Follow.UID + "='" + uid + "'";
try
{
DataTable dt_users = ctSqlHelper.getInstance().Query(sql);
if (dt_users.Rows.Count > 0)
{
for (int i = 0; i < dt_users.Rows.Count; i++)
{
CTPerson user = new CTPerson();
user.Uid = dt_users.Rows[i][GlobalVar.User.UID].ToString();
user.Sex = dt_users.Rows[i][GlobalVar.User.SEX].ToString();
user.Nickname = dt_users.Rows[i][GlobalVar.User.NICKNAME].ToString();
CTSchool tmp_school = new CTSchool();
tmp_school.SCode = dt_users.Rows[i][GlobalVar.User.UID].ToString();
tmp_school.SName = getSchoolNameBySchoolCode(tmp_school.SCode);
user.School = tmp_school;
user.Email = dt_users.Rows[i][GlobalVar.User.EMAIL].ToString();
user.Headpic = dt_users.Rows[i][GlobalVar.User.HEADPIC].ToString();
user.Userexplain = dt_users.Rows[i][GlobalVar.User.USEREXPLAIN].ToString();
user.State = dt_users.Rows[i][GlobalVar.User.STATE].ToString();
user.Age = dt_users.Rows[i][GlobalVar.User.AGE].ToString();
list.Add(user);
}
}
}
catch (Exception e)
{
Console.Write(e.Message);
}
return(list);
}
/// <summary>
/// 查询单个用户信息
/// </summary>
/// <param name="uid"></param>
/// <returns></returns>
public CTPerson getUserProfile(string uid)
{
CTPerson user = new CTPerson();
try
{
string sql = "select * from " + GlobalVar.User.TABLE_USER + " where " + GlobalVar.User.UID + "='" + uid + "'";
DataTable dt_users = ctSqlHelper.getInstance().Query(sql);
if (dt_users.Rows.Count > 0)
{
user.Uid = dt_users.Rows[0][GlobalVar.User.UID].ToString();
user.Sex = dt_users.Rows[0][GlobalVar.User.SEX].ToString();
user.Nickname = dt_users.Rows[0][GlobalVar.User.NICKNAME].ToString();
CTSchool tmp_school = new CTSchool();
tmp_school.SCode = dt_users.Rows[0][GlobalVar.User.SCHOOLCODE].ToString();
tmp_school.SName = getSchoolNameBySchoolCode(tmp_school.SCode);
user.School = tmp_school;
user.Email = dt_users.Rows[0][GlobalVar.User.EMAIL].ToString();
user.Headpic = dt_users.Rows[0][GlobalVar.User.HEADPIC].ToString();
user.Userexplain = dt_users.Rows[0][GlobalVar.User.USEREXPLAIN].ToString();
user.State = dt_users.Rows[0][GlobalVar.User.STATE].ToString();
user.Age = dt_users.Rows[0][GlobalVar.User.AGE].ToString();
}
}
catch (Exception e)
{
Console.Write(e.Message);
}
return(user);
}
/// <summary>
///
/// 1.获取学校列表
/// </summary>
/// <returns></returns>
public ArrayList getSchoolList()
{
ArrayList list = new ArrayList();
string sql = "select * from " + GlobalVar.SchoolInfo.TABLE_SCHOOLINFO;
DataTable dt_school = ctSqlHelper.getInstance().Query(sql);
if (dt_school.Rows.Count > 0)
{
for (int i = 0; i < dt_school.Rows.Count; i++)
{
CTSchool school = new CTSchool();
school.Areacode = dt_school.Rows[i][GlobalVar.SchoolInfo.AREACODE].ToString();
school.SName = dt_school.Rows[i][GlobalVar.SchoolInfo.SCHOOLNAME].ToString();
school.SCode = dt_school.Rows[i][GlobalVar.SchoolInfo.SCHOOLCODE].ToString();
list.Add(school);
}
}
return(list);
}
