下一个版本主要做家族页面

代码抢先看

{FamilyShow}



if (NuoHa.MyId == 0)
{
result += "加入家族一起在" + NuoHa.ShortName + "闯荡吧，我们为你推荐:
";
result += "最佳匹配:";
SqlDataReader Rs = DataHelper.ExecuteReader("SELECT TOP 1 [id],[name] FROM [wap_bbs] WHERE [pid]=8 AND [status]=0 ORDER BY NEWID()");
if (Rs.Read())
{
result += "" + Rs[1] + "";
result += "(快速加入)";
}
Rs.Close();
result += "
";
result += "申请我的家族
";
}
else
{
int fid = (int)DataHelper.ExecuteScalar("SELECT [family] FROM [wap_user] WHERE [id]=" + NuoHa.MyId + "");
if (fid == 0)
{
result += "加入家族一起在" + NuoHa.ShortName + "闯荡吧，我们为你推荐:
";
result += "最佳匹配:";
SqlDataReader Rs = DataHelper.ExecuteReader("SELECT TOP 1 [id],[name] FROM [wap_bbs] WHERE [pid]=8 AND [status]=0 ORDER BY NEWID()");
if (Rs.Read())
{
result += "" + Rs[1] + "";
result += "(快速加入)";
}
Rs.Close();
result += "
";
result += "申请我的家族
";
}
else
{
object point = DataHelper.ExecuteScalar("SELECT [point] FROM [wap_bbs_member] WHERE [bid]=" + fid + " AND [uid]=" + NuoHa.MyId + "");
if (point == null)
{
DataHelper.ExecuteNonQuery("FROM [wap_user] SET [family]=0 WHERE [id]=" + NuoHa.MyId + "");
}
result += "我的积分:" + point + "
";
int mpoint = Convert.ToInt32(point) + 1;
SqlDataReader Rs = DataHelper.ExecuteReader("SELECT TOP 1 [hat],[name] FROM [wap_bbs_member_level] WHERE [point]<" + mpoint + " ORDER BY [id] DESC");
if (!Rs.Read())
{
result += "我的职称:系统未设置
";
}
else
{
result += "我的职称:" + Rs[1] + "
";
}
Rs.Close();
result += "日常任务:回家看看
";
}
}
return result;
}
public string BookContinue(int uid)
{
string result = "";
if (uid > 0)
{
SqlDataReader Rs = DataHelper.ExecuteReader("SELECT [name],[string] FROM [wap_book_continue] WHERE [uid]=" + uid + "");
if (Rs.Read())
{
if (Rs[0].ToString() != "")
{
if (Rs[1].ToString().IndexOf("bid=") < 0)
{
result = "继续:" + Rs[0] + "
\r\n";
}
else
{
result = "继续:" + Rs[0] + "
\r\n";
}
}