protected void Page_Load(object sender, EventArgs e) { Random rnd = new Random(); ArrayList alBmp = new ArrayList(); ArrayList alUid = new ArrayList(); int intUserID = 0; int intType = 0; intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0)); intType = Convert.ToInt32(Classlibrary.GetRequest("Type", 0)); if (intUserID > 0) { Session["UserID"] = intUserID; this.strUserID = intUserID.ToString(); } else { Response.Redirect("Logins.aspx"); return; } if (intType > 0) { this.strContent = "<script type='text/javascript'>ShowConcern();</script>"; return; } this.strCMD = "<script type='text/javascript'>Timer1();</script>"; int intPage = 1; if (Request.QueryString["Page"] != null) { intPage = Convert.ToInt32(Request.QueryString["Page"].ToString()); } if (intPage < 0 || !intPage.Equals(intPage)) { intPage = 1; } SqlParameter[] sp = new SqlParameter[2]; sp[0] = new SqlParameter("@PageIndex", SqlDbType.Int, 4); sp[1] = new SqlParameter("@PageSize", SqlDbType.Int, 4); sp[0].Value = intPage; sp[1].Value = 8; DataTable dt = SqlHelper.ExecuteDataTable(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "Xn_GetShowList", sp); DataTable dtConcernList = SqlLibrary.ReadConcernList(intUserID); if (dt != null) { string strSQL = "SELECT ISNULL(Count(id),0) AS Count FROM [MT_Media]"; this.intPageSize = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlLibrary.GetServer_Main(), CommandType.Text, strSQL)); if (this.intPageSize % 8 > 0) { this.intPageSize = this.intPageSize / 8 + 1; } else { this.intPageSize = this.intPageSize / 8; } int i = 1; foreach (DataRow dr in dt.Rows) { int intUserIDT = (int)dr["UserId"]; //this.sb.Append("<div class=\"pic" + i + "\">"); //this.sb.Append("<div class=\"headpic\"><a href=\"#\"><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" width=\"149\" height=\"115\" /></a></div>"); //this.sb.Append("<div class=\"headname\"><a href=\"#\">" + (string)dr["NickName"].ToString().Trim() + "</a></div>"); //this.sb.Append("<div class=\"headtime\">" + StringItem.FormatDate((DateTime)dr["CreateTime"], "hh:mm") + "</div>"); this.sb.Append("<div class=\"pic" + i + "\">"); this.sb.Append("<div class=\"headpic\"><a href=\"javascript:;\" title='" + (string)dr["NickName"].ToString().Trim() + "' onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" ><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" /></a></div>"); this.sb.Append("<div class=\"show_text\">"); this.sb.Append("<div class=\"headname\"><a href=\"#\">" + (string)dr["NickName"].ToString().Trim() + "</a></div>"); this.sb.Append("<div class=\"headtime\">" + StringItem.FormatDate((DateTime)dr["CreateTime"], "hh:mm") + "</div>"); if (intUserID == intUserIDT) { //this.sb.Append("<div class=\"sms\">*</div>"); this.sb.Append("<div class=\"sms\"><img src=\"Images/pao.jpg\" onMouseOver='this.src=\"Images/pao_hover.jpg\"' onMouseOut='this.src=\"Images/pao.jpg\"'></div>"); } else { //this.sb.Append("<div class=\"sms\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" >M</a></div>"); this.sb.Append("<div class=\"sms\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" ><img src=\"Images/pao.jpg\" onMouseOver='this.src=\"Images/pao_hover.jpg\"' onMouseOut='this.src=\"Images/pao.jpg\"'></a></div>"); } if (dtConcernList != null) { DataRow[] drs = dtConcernList.Select("ConcernID=" + intUserIDT); if (drs != null && drs.Length > 0) { //this.sb.Append("<div class=\"concern\"><a href=\"javascript:;\" onclick=\"DeleteConcern(" + intUserID + "," + intUserIDT + ")\" >-</a></div>"); this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"DeleteConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/cut.jpg\" onMouseOver='this.src=\"Images/cut_hover.jpg\"' onMouseOut='this.src=\"Images/cut.jpg\"'></a></div>"); } else { if (intUserID == intUserIDT) { //this.sb.Append("<div class=\"concern\">*</div>"); this.sb.Append("<div class=\"headadd\"><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></div>"); } else { //this.sb.Append("<div class=\"concern\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" >+</a></div>"); this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></a></div>"); } } dtConcernList.Dispose(); } else { if (intUserID == intUserIDT) { //this.sb.Append("<div class=\"concern\">*</div>"); this.sb.Append("<div class=\"headadd\"><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></div>"); } else { //this.sb.Append("<div class=\"concern\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" >+</a></div>"); this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></a></div>"); } } this.sb.Append("</div>\r\n"); this.sb.Append("</div>\r\n"); i++; } //ShowImg.Visible = true; this.strContent = this.sb.ToString(); dt.Dispose(); } else { this.strContent = "当前没有在线用户~~~"; } }
protected void Page_Load(object sender, EventArgs e) { Random rnd = new Random(); int intUserID = Convert.ToInt32(Session["UserID"]); int intPage = Convert.ToInt32(Request.QueryString["Page"].ToString()); intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString()); if (intPage < 0 || !intPage.Equals(intPage)) { intPage = 1; } DataTable dt = SqlLibrary.ShowConcernList(intPage, intUserID); DataTable dtConcernList = SqlLibrary.ReadConcernList(intUserID); if (dt != null) { int i = 1; foreach (DataRow dr in dt.Rows) { int intUserIDT = (int)dr["UserId"]; DateTime dtnow = DateTime.Now; DateTime Birthday = (DateTime)dr["Birthday"]; this.sb.Append("<div class=\"pic" + i + "\">"); if (Convert.ToString((bool)dr["Online"]) == "True") { this.sb.Append("<div class=\"headpic\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" title=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" width=\"150\" height=\"130\" alt=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"/></a></div>"); //this.sb.Append("<div class=\"headpic\"><a href=\"#\" title='" + (string)dr["NickName"].ToString().Trim() + "'><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" width=\"150\" height=\"130\" alt='" + (string)dr["NickName"].ToString().Trim() + "' /></a></div>"); } else { this.sb.Append("<div class=\"headpic\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" title=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "\" width=\"150\" height=\"130\" alt=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"/></a></div>"); } this.sb.Append("<div class=\"show_text\">"); this.sb.Append("<div class=\"headname\"><a href=\"#\" title='" + (string)dr["NickName"].ToString().Trim() + "'>" + StringItem.StringTruncat((string)dr["NickName"].ToString().Trim(), 10, "...") + "</a></div>"); this.sb.Append("<div class=\"headtime\">" + StringItem.FormatDate((DateTime)dr["CreateTime"], "hh:mm") + "</div>"); if (intUserID == intUserIDT) { this.sb.Append("<div class=\"sms\"></div>"); } else { this.sb.Append("<div class=\"sms\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" ><img src=\"Images/pao.jpg\" alt=\"联系我\" onMouseOver='this.src=\"Images/pao_hover.jpg\"' onMouseOut='this.src=\"Images/pao.jpg\"' /></a></div>"); } if (dtConcernList != null) { DataRow[] drs = dtConcernList.Select("ConcernID=" + intUserIDT); if (drs != null && drs.Length > 0) { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"DeleteConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/cut.jpg\" alt=\"取消对该用户的关注\" onMouseOver='this.src=\"Images/cut_hover.jpg\"' onMouseOut='this.src=\"Images/cut.jpg\"' /></a></div>"); } else { if (intUserID == intUserIDT) { this.sb.Append("<div class=\"headadd\"></div>"); } else { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" alt=\"添加对该用户的关注\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"' /></a></div>"); } } dtConcernList.Dispose(); } else { if (intUserID == intUserIDT) { this.sb.Append("<div class=\"headadd\"></div>"); } else { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" alt=\"添加对该用户的关注\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"' /></a></div>"); } } this.sb.Append("</div>\r\n"); this.sb.Append("</div>\r\n"); i++; } //ShowImg.Visible = true; this.strContent = this.sb.ToString(); dt.Dispose(); } else { this.strContent = "添加你感兴趣的用户为关注后,你可以在这里更方便的找到他们(*^__^*) 嘻嘻……"; } }
protected void Page_Load(object sender, EventArgs e) { Random rnd = new Random(); ArrayList alBmp = new ArrayList(); ArrayList alUid = new ArrayList(); DataTable dt; int intType = Convert.ToInt32(Request.QueryString["Type"].ToString().Trim()); int intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0)); if (intType < 0 || intType > 2 || !intType.Equals(intType)) { intType = 1; } switch (intType) { case 1: int intPage = Convert.ToInt32(Request.QueryString["Page"].ToString().Trim()); string strProvince = Request.QueryString["Province"].ToString().Trim(); //省 string strCity = Request.QueryString["City"].ToString().Trim(); //市 int intGender = Convert.ToInt32(Request.QueryString["Gender"].ToString().Trim()); //性别 1男、0女、2全部 int intCategory = Convert.ToInt32(Request.QueryString["Category"].ToString().Trim()); //0 全部,1 小于15岁,2 16-22岁,3 23-30岁,4 31-40岁,5 大于40岁 if (intPage < 0 || !intPage.Equals(intPage)) { intPage = 1; } dt = SqlLibrary.SearchUserList(intPage, strProvince, strCity, intGender, intCategory); DataTable dtConcernList = SqlLibrary.ReadConcernList(intUserID); if (dt != null) { int i = 1; foreach (DataRow dr in dt.Rows) { int intUserIDT = (int)dr["UserId"]; DateTime dtnow = DateTime.Now; DateTime Birthday = (DateTime)dr["Birthday"]; this.sb.Append("<div class=\"pic" + i + "\">"); if (Convert.ToString((bool)dr["Online"]) == "True") { this.sb.Append("<div class=\"headpic\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" title=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" width=\"150\" height=\"130\" alt=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"/></a></div>"); //this.sb.Append("<div class=\"headpic\"><a href=\"#\" title='" + (string)dr["NickName"].ToString().Trim() + "'><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" width=\"150\" height=\"130\" alt='" + (string)dr["NickName"].ToString().Trim() + "' /></a></div>"); } else { this.sb.Append("<div class=\"headpic\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" title=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "\" width=\"150\" height=\"130\" alt=\"昵称:" + (string)dr["NickName"].ToString() + " 地区:" + (string)dr["Province"].ToString() + " " + (string)dr["City"].ToString() + " 年龄:" + Convert.ToString(dtnow.Year - Birthday.Year) + " 性别:" + (Convert.ToString((bool)dr["Sex"]) == "True" ? "男" : "女") + "\"/></a></div>"); } this.sb.Append("<div class=\"show_text\">"); this.sb.Append("<div class=\"headname\"><a href=\"#\" title='" + (string)dr["NickName"].ToString().Trim() + "'>" + StringItem.StringTruncat((string)dr["NickName"].ToString().Trim(), 10, "...") + "</a></div>"); this.sb.Append("<div class=\"headtime\">" + StringItem.FormatDate((DateTime)dr["CreateTime"], "hh:mm") + "</div>"); if (intUserID == intUserIDT) { this.sb.Append("<div class=\"sms\"></div>"); } else { this.sb.Append("<div class=\"sms\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" ><img src=\"Images/pao.jpg\" alt=\"联系我\" onMouseOver='this.src=\"Images/pao_hover.jpg\"' onMouseOut='this.src=\"Images/pao.jpg\"' /></a></div>"); } if (dtConcernList != null) { DataRow[] drs = dtConcernList.Select("ConcernID=" + intUserIDT); if (drs != null && drs.Length > 0) { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"DeleteConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/cut.jpg\" alt=\"取消对该用户的关注\" onMouseOver='this.src=\"Images/cut_hover.jpg\"' onMouseOut='this.src=\"Images/cut.jpg\"' /></a></div>"); } else { if (intUserID == intUserIDT) { this.sb.Append("<div class=\"headadd\"></div>"); } else { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" alt=\"添加对该用户的关注\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"' /></a></div>"); } } dtConcernList.Dispose(); } else { if (intUserID == intUserIDT) { this.sb.Append("<div class=\"headadd\"></div>"); } else { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" alt=\"添加对该用户的关注\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"' /></a></div>"); } } this.sb.Append("</div>\r\n"); this.sb.Append("</div>\r\n"); i++; } //ShowImg.Visible = true; //////////////////////////////////////////////// //if (intCount % 8 > 0) //{ // intCount = intCount / 8 + 1; //} //else //{ // intCount = intCount / 8; //} //this.strContent = "<script type=\"text/javascript\">SearchPage(" + intCount + ");</script>"; //////////////////////////////////////////////// this.strContent = this.sb.ToString(); dt.Dispose(); } else { this.strContent = "当前没有满足查询条件的用户"; } break; case 2: string strNickName = Server.UrlDecode(Request.QueryString["NickName"].ToString().Trim()); dt = SqlLibrary.SearchUser(strNickName); dtConcernList = SqlLibrary.ReadConcernList(intUserID); if (dt != null) { int i = 1; foreach (DataRow dr in dt.Rows) { int intUserIDT = (int)dr["UserId"]; this.sb.Append("<div class=\"pic" + i + "\">"); this.sb.Append("<div class=\"headpic\"><a href=\"#\"><img src=\"http://ishow.xba.com.cn/image/" + (string)dr["Bmp"].ToString().Trim() + "?tmp=" + rnd.Next(000000, 999999).ToString() + "\" width=\"150\" height=\"130\" /></a></div>"); this.sb.Append("<div class=\"show_text\">"); this.sb.Append("<div class=\"headname\"><a href=\"#\">" + (string)dr["NickName"].ToString().Trim() + "</a></div>"); this.sb.Append("<div class=\"headtime\">" + StringItem.FormatDate((DateTime)dr["CreateTime"], "hh:mm") + "</div>"); if (intUserID == intUserIDT) { this.sb.Append("<div class=\"sms\"></div>"); } else { this.sb.Append("<div class=\"sms\"><a href=\"javascript:;\" onclick=\"ShowMsgBox(" + (int)dr["UserId"] + ",'" + (string)dr["NickName"].ToString().Trim() + "')\" ><img src=\"Images/pao.jpg\" onMouseOver='this.src=\"Images/pao_hover.jpg\"' onMouseOut='this.src=\"Images/pao.jpg\"'></a></div>"); } if (dtConcernList != null) { DataRow[] drs = dtConcernList.Select("ConcernID=" + intUserIDT); if (drs != null && drs.Length > 0) { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"DeleteConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/cut.jpg\" onMouseOver='this.src=\"Images/cut_hover.jpg\"' onMouseOut='this.src=\"Images/cut.jpg\"'></a></div>"); } else { if (intUserID == intUserIDT) { this.sb.Append("<div class=\"headadd\"></div>"); } else { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></a></div>"); } } dtConcernList.Dispose(); } else { if (intUserID == intUserIDT) { this.sb.Append("<div class=\"headadd\"><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></div>"); } else { this.sb.Append("<div class=\"headadd\"><a href=\"javascript:;\" onclick=\"AddConcern(" + intUserID + "," + intUserIDT + ")\" ><img src=\"Images/add.jpg\" onMouseOver='this.src=\"Images/add_hover.jpg\"' onMouseOut='this.src=\"Images/add.jpg\"'></a></div>"); } } this.sb.Append("</div>\r\n"); this.sb.Append("</div>\r\n"); i++; } //ShowImg.Visible = true; this.strContent = this.sb.ToString(); dt.Dispose(); } else { this.strContent = "当前没有满足查询条件的用户"; } break; } }
protected void Page_Load(object sender, EventArgs e) { StringBuilder sb = new StringBuilder(); int intType = 0; int intCount = 0; int intUserID = 0; string strSQL = null; string strProvince = null; string strCity = null; string strGender = null; string strCategory = null; intType = Convert.ToInt32(Classlibrary.GetRequest("Type", 0)); if (!intType.Equals(intType) || intType > 0) { switch (intType) { case 1: //大厅分页 strSQL = "SELECT ISNULL(Count(id),1) AS Count FROM [MT_Media] WITH(NOLOCK)"; intCount = Convert.ToInt32(SqlHelper.ExecuteScalar(SqlLibrary.GetServer_Main(), CommandType.Text, strSQL)); if (intCount % 8 > 0) { intCount = intCount / 8 + 1; } else { intCount = intCount / 8; } this.strContent = "{\"Page\":" + intCount + "}"; break; case 2: //关注分页 intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 1)); //intUserID = Convert.ToInt32(Session["UserID"]); DataTable dt = SqlLibrary.ReadConcernList(intUserID); if (dt != null) { intCount = dt.Rows.Count; if (intCount % 8 > 0) { intCount = intCount / 8 + 1; } else { intCount = intCount / 8; } this.strContent = "{\"Page\":" + intCount + "}"; } else { this.strContent = "{\"Page\":0}"; } break; case 3: //粉丝分页 intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 1)); intCount = SqlLibrary.CountFans(intUserID); if (intCount > 0) { if (intCount % 8 > 0) { intCount = intCount / 8 + 1; } else { intCount = intCount / 8; } this.strContent = "{\"Page\":" + intCount + "}"; } else { this.strContent = "{\"Page\":0}"; } break; case 4: //搜索分页 strProvince = Classlibrary.GetRequest("Province", 1).ToString(); strCity = Classlibrary.GetRequest("City", 1).ToString(); strGender = Classlibrary.GetRequest("Gender", 1).ToString(); strCategory = Classlibrary.GetRequest("Category", 1).ToString(); intCount = SqlLibrary.SearchUserListCount(strProvince, strCity, strGender, strCategory); if (intCount > 0) { if (intCount % 8 > 0) { intCount = intCount / 8 + 1; } else { intCount = intCount / 8; } this.strContent = "{\"Page\":" + intCount + "}"; } else { this.strContent = "{\"Page\":0}"; } break; } } }