public static DataRow GetUserRowByUserNamePWD(string strUserName, string strPassword)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("UserName", SqlDbType.VarChar), new SqlParameter("Password", SqlDbType.VarChar) };
commandParameters[0].Value = strUserName;
commandParameters[1].Value = strPassword;
return(SqlHelper.ExecuteDataRow(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "GetUserRowByUserNamePWD", commandParameters));
}
/// <summary>
/// 检查用户状态
/// </summary>
/// <param name="intSID">用户SID</param>
/// <returns>1\禁用 0\正常</returns>
public static byte UserStatus(int intSID)
{
byte byteStatus = 0;
string strSQL = "SELECT TOP 1 Status FROM Fx_User WHERE [SID] = " + intSID + "";
try
{
DataRow dr = SqlHelper.ExecuteDataRow(SqlLibrary.GetFx_Main(), CommandType.Text, strSQL);
byteStatus = Convert.ToByte(dr["Status"]);
if (byteStatus == 1)
{
Console.WriteLine("==================== [系统消息] 开始 ================== \r\n");
Console.WriteLine("UserID:" + intSID + " 已被锁定！\r\n");
Console.WriteLine("==================== [系统消息] 结束 ================== \r\n");
}
else if (byteStatus == 0)
{
byteStatus = 0;
}
}
catch
{
Console.WriteLine("==================== [系统消息] 开始 ================== \r\n");
Console.WriteLine("UserID:" + intSID + " 查无此用户！\r\n");
Console.WriteLine("==================== [系统消息] 结束 ================== \r\n");
}
return(byteStatus);
}
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.ShowFansList(intPage, 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>");
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=\"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>");
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++;
}
this.strContent = this.sb.ToString();
dt.Dispose();
}
else
{
this.strContent = "很遗憾，还没有人成为你的粉丝，你需要散发出更多的魅力呦O(∩_∩)O~";
}
}
/// <summary>
/// 发送消息
/// </summary>
public static void SendMessage()
{
int intID = 0;
int intSID = 0;
string strSMSContent = "";
string strSQL = "SELECT TOP 1 ID,SID,SMSContent FROM Fx_OutBox WHERE [Status] = 0";
Console.WriteLine(strSQL);//111111111111111111111111111111111
try
{
Console.WriteLine("==================== [发送消息] 开始 ================== \r\n");
DataRow dr = SqlHelper.ExecuteDataRow(SqlLibrary.GetFx_Main(), CommandType.Text, strSQL);
intID = Convert.ToInt32(dr["ID"]);
intSID = Convert.ToInt32(dr["SID"]);
strSMSContent = Convert.ToString(dr["SMSContent"]);
Console.WriteLine(intID + " " + intSID + " " + strSMSContent); //111111111111111111111111
string[] arrSMSContent = strSMSContent.Split(new char[] { ' ' });
Console.WriteLine(arrSMSContent.Length); //1111111111111111111111111
if (arrSMSContent.Length > 1)
{
if (intID > 0)
{
Console.WriteLine("用户状态：" + UserStatus(intSID));//111111111111111111
if (UserStatus(intSID) == 0)
{
Console.WriteLine("SysConsole: " + intSID + " " + arrSMSContent[0].ToLower().ToString() + " " + arrSMSContent[1].ToLower().ToString());
SysConsole(intSID, arrSMSContent[0].ToLower().ToString(), arrSMSContent[1].ToLower().ToString());
Console.WriteLine("sysconsole runing");//11111111111111111
intID = SqlLibrary.Fx_UpdateMessage(intID);
Console.WriteLine("[信息已发出]");
Console.WriteLine("发送对像:" + intSID + " 命令:" + arrSMSContent[0].ToString() + " 参数:" + arrSMSContent[1].ToString() + "\r\n");
}
else
{
SqlLibrary.Fx_UpdateMessage(intID);
Console.WriteLine("[信息已被取消]");
}
}
else
{
Console.WriteLine("[信息标记出错]");
}
}
else
{
SqlLibrary.Fx_UpdateMessage(intID);
Console.WriteLine("[信息已被取消]");
}
Console.WriteLine("==================== [发送消息] 结束 ================== \r\n");
}
catch (Exception ex)
{
Console.WriteLine(ex);
//Console.WriteLine("[没有要发送的消息]\r\n");
Console.WriteLine("==================== [发送消息] 结束 ================== \r\n");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string strSQL = "SELECT COUNT(*) AS Count FROM MT_User WITH(NOLOCK)";
DataRow dr = SqlHelper.ExecuteDataRow(SqlLibrary.GetServer_Main(), CommandType.Text, strSQL);
intCount = (int)dr["Count"];
strSQL = "SELECT COUNT(*) AS Count FROM MT_Media WITH(NOLOCK) WHERE OnLine = 1";
dr = SqlHelper.ExecuteDataRow(SqlLibrary.GetServer_Main(), CommandType.Text, strSQL);
intOnlineCount = (int)dr["Count"];
}
/// <summary>
/// 搜索用户列表(精确)
/// </summary>
/// <param name="strNickName"></param>
/// <returns></returns>
public static DataTable SearchUser(string strNickName)
{
SqlParameter[] sp = new SqlParameter[1];
sp[0] = new SqlParameter("@NickName", SqlDbType.VarChar, 50);
sp[0].Value = strNickName;
DataTable dt = SqlHelper.ExecuteDataTable(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "SearchUser", sp);
return(dt);
}
/// <summary>
/// 读取用户信息和图片信息
/// </summary>
/// <param name="intUserID"></param>
/// <returns></returns>
public static DataRow ReadUserInfoAndImg(int intUserID)
{
SqlParameter[] sp = new SqlParameter[1];
sp[0] = new SqlParameter("@UserID", SqlDbType.Int);
sp[0].Value = intUserID;
DataRow dr = SqlHelper.ExecuteDataRow(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "ReadUserInfoAndImg", sp);
return(dr);
}
public static SqlDataReader RegisterUser(string strUserName, string strPassword, string strNickName, int intSex, string strBirthDay, string strPro, string strCity, string strQQ)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("UserName", SqlDbType.VarChar), new SqlParameter("Password", SqlDbType.VarChar), new SqlParameter("NickName", SqlDbType.VarChar), new SqlParameter("Sex", SqlDbType.Bit), new SqlParameter("BirthDay", SqlDbType.DateTime), new SqlParameter("Province", SqlDbType.VarChar), new SqlParameter("City", SqlDbType.VarChar), new SqlParameter("QQ", SqlDbType.VarChar) };
commandParameters[0].Value = strUserName;
commandParameters[1].Value = strPassword;
commandParameters[2].Value = strNickName;
commandParameters[3].Value = intSex;
commandParameters[4].Value = strBirthDay;
commandParameters[5].Value = strPro;
commandParameters[6].Value = strCity;
commandParameters[7].Value = strQQ;
return(SqlHelper.ExecuteReader(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "RegisterUser", commandParameters));
}
/// <summary>
/// 搜索用户列表(模糊)
/// </summary>
/// <param name="intPage"></param>
/// <param name="strProvince"></param>
/// <param name="strCity"></param>
/// <param name="intGender"></param>
/// <param name="intCategory"></param>
/// <returns></returns>
public static DataTable SearchUserList(int intPage, string strProvince, string strCity, int intGender, int intCategory)
{
SqlParameter[] sp = new SqlParameter[6];
sp[0] = new SqlParameter("@PageIndex", SqlDbType.Int, 4);
sp[1] = new SqlParameter("@PageSize", SqlDbType.Int, 4);
sp[2] = new SqlParameter("@Province", SqlDbType.VarChar, 20);
sp[3] = new SqlParameter("@City", SqlDbType.VarChar, 20);
sp[4] = new SqlParameter("@Gender", SqlDbType.Int, 1);
sp[5] = new SqlParameter("@Category", SqlDbType.Int, 1);
sp[0].Value = intPage;
sp[1].Value = 8;
sp[2].Value = strProvince;
sp[3].Value = strCity;
sp[4].Value = intGender;
sp[5].Value = intCategory;
DataTable dt = SqlHelper.ExecuteDataTable(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "SearchUserList", sp);
return(dt);
}
/// <summary>
/// 存储消息
/// </summary>
/// <param name="strSID"></param>
/// <param name="strSMSContent"></param>
public static void SaveMessage(string strSID, string strSMSContent)
{
int intSID = 0;
int intOut = 0;
intSID = Convert.ToInt32(Regex.Match(strSID, @"\d{2,15}").ToString());
if (intSID > 0)
{
intOut = SqlLibrary.Fx_SaveMessage(intSID, strSMSContent);
if (intOut == 0)
{
Console.WriteLine("[收到:" + intSID + "消息！]\r\n");
}
else
{
Console.WriteLine("[接收:" + intSID + "出错！]\r\n");
}
}
else
{
Console.WriteLine("[用户传入SID出错！]");
}
}
/// <summary>
/// 运行计划任务
/// </summary>
public static void RunTask()
{
int intID = 0;
int intSID = 0;
int intCategory = 0;
string strTask = "";
byte byteStatus = 0;
string strSQL = "SELECT TOP 1 ID,[SID],Category,Task,RunTime,[Status] FROM Fx_Task WHERE [Status] = 1 AND RunTime < CONVERT(Char(10),GetDate()+1,120) ORDER BY RunTime";
try
{
Console.WriteLine("==================== [计划任务] 开始 ================== \r\n");
DataRow dr = SqlHelper.ExecuteDataRow(SqlLibrary.GetFx_Main(), CommandType.Text, strSQL);
intID = Convert.ToInt32(dr["ID"]);
intSID = Convert.ToInt32(dr["SID"]);
intCategory = Convert.ToInt32(dr["Category"]);
strTask = Convert.ToString(dr["Task"]);
byteStatus = Convert.ToByte(dr["Status"]);
string[] arrTask = strTask.Split(new char[] { ' ' });
Console.WriteLine(Convert.ToDateTime(dr["RunTime"]) + "<" + DateTime.Now + "&&" + byteStatus);
if (Convert.ToDateTime(dr["RunTime"]) < DateTime.Now && byteStatus == 1)
{
Console.WriteLine(">>>>>>>>>进入计划任务判断<<<<<<<<");
SysConsole(intSID, arrTask[0].ToLower().ToString(), arrTask[1].ToLower().ToString());
SqlLibrary.Fx_UpdateTaskRuntime(intID);
Console.WriteLine("发送对像:" + intSID + " 命令:" + arrTask[0].ToString() + " 参数:" + arrTask[1].ToString() + " 任务编号:" + intID + "\r\n");
Console.WriteLine("==================== [计划任务] 结束 ================== \r\n");
}
}
catch
{
Console.WriteLine("---[没有计划任务要执行]--- \r\n");
Console.WriteLine("==================== [计划任务] 结束 ================== \r\n");
}
}
public static DataRow GetMainParameterRow()
{
return(SqlHelper.ExecuteDataRow(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "GetMainParameterRow"));
}
public static bool HasUserName(string strUserName)
{
SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("UserName", SqlDbType.VarChar) };
commandParameters[0].Value = strUserName;
return(Convert.ToBoolean(SqlHelper.ExecuteScalar(SqlLibrary.GetServer_Main(), CommandType.StoredProcedure, "HasUserName", commandParameters)));
}
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
int intType = 0;
int intUserID = 0;
int intConcernID = 0;
int intStatus = 0;
int intCount = 0;
intType = Convert.ToInt32(Classlibrary.GetRequest("Type", 0));
if (!intType.Equals(intType) || intType > 0)
{
switch (intType)
{
case 1: //添加关注
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
intConcernID = Convert.ToInt32(Classlibrary.GetRequest("ConcernID", 0));
intStatus = SqlLibrary.AddConcern(intUserID, intConcernID);
if (intStatus == 1)
{
sb.Append("{\"Status\":1}"); //添加成功
this.strContent = sb.ToString();
}
else if (intStatus == -1)
{
sb.Append("{\"Status\":-1}"); //添加失败，不是VIP
this.strContent = sb.ToString();
}
else
{
sb.Append("{\"Status\":0}"); //添加失败，关注已被添加
this.strContent = sb.ToString();
}
break;
case 2: //删除关注
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
intConcernID = Convert.ToInt32(Classlibrary.GetRequest("ConcernID", 0));
intStatus = SqlLibrary.DeleteConcern(intUserID, intConcernID);
if (intStatus == 1)
{
sb.Append("{\"Status\":1}"); //删除成功
this.strContent = sb.ToString();
}
else
{
sb.Append("{\"Status\":0}"); //删除失败，关注已被删除
this.strContent = sb.ToString();
}
break;
case 3: //统计关注数
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
intCount = SqlLibrary.CountConcern(intUserID);
sb.Append("{\"Count\":" + intCount + "}");
this.strContent = sb.ToString();
break;
case 4: //统计粉丝数
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
intCount = SqlLibrary.CountFans(intUserID);
sb.Append("{\"Count\":" + intCount + "}");
this.strContent = sb.ToString();
break;
}
}
}
static void Main(string[] args)
//static void Main()
{
string strMobileNo = "";
string strTimer = "";
string strURI = "";
string strMsg = "";
string strCmdId = "";
string strResult = "";
string strSystemNotify = "";
string strUserInfo = "";
string strSIDValue = "sid";
string strServerName = "";
string strServerStatus = "";
int intSID = 0;
Fetion fx = new Fetion();
DateTime dt = DateTime.Now;
switch (args[0].ToString())
{
case "evResult": //执行结果反馈
strMobileNo = args[1].ToString();
strCmdId = args[2].ToString();
strResult = fx.cmdResult(args[3]);
Console.WriteLine("================= [执行结果反馈] 开始 ================= \r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>> " + strMobileNo + " <<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("命令ID:" + strCmdId + "\r\n");
Console.WriteLine("命令结果:" + strResult + "\r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("================= [执行结果反馈] 退出 ================= \r\n");
break;
case "evNotify": //通用的系统通知，该插件把飞信服务器传递过来的原始数据转发给插件。
strMobileNo = args[1].ToString();
strSystemNotify = fx.sysNotify(args[2]);
Console.WriteLine("========= [传递机器人不识别的原始数据包] 开始 ========= \r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>> " + strMobileNo + " <<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("内容:" + strSystemNotify + "\r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("========= [传递机器人不识别的原始数据包] 退出 ========= \r\n");
break;
case "evBuddyInvite": //对方发起对话时（双击打开窗口时，一般此时可以发送机器人菜单）
strMobileNo = args[1].ToString();
strURI = fx.readSendUser(args[2]);
Console.WriteLine("=================== [窗口事件] 开始 =================== \r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>> " + strMobileNo + " <<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("用户SIP:" + strURI + "\r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("=================== [窗口事件] 退出 =================== \r\n");
break;
case "evBuddyData": //buddy资料传递
strMobileNo = args[1].ToString();
strUserInfo = fx.userInfo(args[2]);
intSID = Convert.ToInt32(fx.ReadXmlTextValue(strUserInfo, strSIDValue));
Console.WriteLine("=================== [资料传递] 开始 =================== \r\n");
if (intSID == 0)
{
Console.WriteLine("！！！！用户SID出错:" + intSID + "！！！！\r\n");
}
else
{
if (SqlLibrary.Fx_AddNewUser(intSID) == 1)
{
Console.WriteLine("！！！！添加新用户:" + intSID + "成功 ！！！！\r\n");
}
else
{
Console.WriteLine("！！！！此用户:" + intSID + "已添加 ！！！！\r\n");
}
}
Console.WriteLine(">>>>>>>>>>>>>>>>>>>> " + strMobileNo + " <<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("用户资料:" + strUserInfo + "\r\n");
Console.WriteLine("用户SID:" + intSID + "\r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("=================== [资料传递] 退出 =================== \r\n");
break;
case "evNewUserRequest": //有新的好友加入（为了突破人数限制，此时可以在保留有关数据后，删除该用户）
strMobileNo = args[1].ToString();
strURI = fx.readSendUser(args[2]);
Console.WriteLine("================ [有新的好友加入] 开始 ================ \r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>> " + strMobileNo + " <<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("用户SIP:" + strURI + "\r\n");
Console.WriteLine(">>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<< \r\n");
Console.WriteLine("================ [有新的好友加入] 退出 ================ \r\n");
break;
case "evMessage": //消息
strMobileNo = args[1].ToString(); //手机号
strURI = fx.readSendUser(args[2]); //读取用户SPI号
strMsg = fx.readSMSContent(args[3]); //读取用户短消息
Console.WriteLine("====================== [消息] 开始 ==================== \r\n");
Console.WriteLine("手机号:" + strMobileNo + "\r\n");
Console.WriteLine("用户SIP:" + strURI + "\r\n");
Console.WriteLine("用户消息:" + strMsg + "\r\n");
Fetion.SaveMessage(strURI, strMsg);
Console.WriteLine("====================== [消息] 退出 ==================== \r\n");
break;
case "evTimer": //10秒钟激活一次
strMobileNo = args[1].ToString(); //手机号
strTimer = args[2].ToString(); //运行至今的秒数
Console.WriteLine("==================== [计时器] 开始 ==================== \r\n");
Console.WriteLine("手机号:" + strMobileNo + " 运行时间:" + strTimer + " 秒\r\n");
Console.WriteLine("==================== [计时器] 退出 ==================== \r\n");
Fetion.SendMessage();
Fetion.RunTask();
break;
case "evSysMessage": //系统消息
strMobileNo = args[1].ToString(); //手机号
strTimer = fx.sysMessage(args[2]); //系统消息内容
Console.WriteLine("=================== [系统消息] 开始 =================== \r\n");
Console.WriteLine("手机号:" + strMobileNo + "\r\n");
Console.WriteLine("系统消息:" + strTimer + "\r\n");
Console.WriteLine("=================== [系统消息] 退出 =================== \r\n");
break;
case "evServerError": //服务器预警调用
strServerName = args[1].ToString(); //服务器名称
strServerStatus = args[2].ToString(); //服务器状态
SqlLibrary.Fx_AddServerRec(strServerName, strServerStatus);
//接收服务器预警信息的飞信号码
Module.AddServerEW("660271316", strServerName, strServerStatus); //韩志伟移动
Thread.Sleep(2000);
Module.AddServerEW("432525523", strServerName, strServerStatus); //宋永凯移动
Console.WriteLine("================== [服务器预警] 开始 ================== \r\n");
Console.WriteLine("服务器名称:" + strServerName + " 服务器状态:" + strServerStatus + "\r\n");
Console.WriteLine("预警时间:" + dt + "\r\n");
Console.WriteLine("================== [服务器预警] 退出 ================== \r\n");
break;
default:
Console.WriteLine("NotEventCase");
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int intType = 0;
string strUserName = null;
string strPassword = null;
StringBuilder sb = new StringBuilder();
intType = Convert.ToInt32(Classlibrary.GetRequest("Type", 0));
if (!intType.Equals(intType) || intType > 0)
{
switch (intType)
{
case 1: //用户登录验证
strUserName = Server.HtmlDecode(Classlibrary.GetRequest("UserName", 1).ToString());
strPassword = Server.HtmlDecode(Classlibrary.GetRequest("Password", 1).ToString());
DataRow dr = SqlLibrary.LoginAuth(strUserName, strPassword);
if (dr != null)
{
sb.Append("{\"UserID\":" + (int)dr["UserID"] + ",\"NickName\":\"" + (string)dr["NickName"] + "\",\"Sex\":\"" + (bool)dr["Sex"] + "\",\"LockTime\":" + (int)dr["LockTime"] + ",\"Status\":\"" + (bool)dr["Status"] + "\",\"Birthday\":\"" + (DateTime)dr["Birthday"] + "\",\"Province\":\"" + (string)dr["Province"] + "\",\"City\":\"" + (string)dr["City"] + "\",\"Tinyurl\":\"" + (string)dr["Tinyurl"] + "\",\"Headurl\":\"" + (string)dr["Headurl"] + "\",\"LastActiveTime\":\"" + (DateTime)dr["LastActiveTime"] + "\",\"QQ\":\"" + (string)dr["QQ"] + "\",\"VIP\":\"" + (bool)dr["VIP"] + "\"}");
SqlLibrary.SendQQMsg("182536608", "用户：" + (string)dr["NickName"] + " 登录");
this.strContent = sb.ToString();
}
else
{
this.strContent = "{\"UserID\":0}";
}
break;
case 2:
int intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 2));
bool blVIP = SqlLibrary.CheckVIP(intUserID);
if (blVIP)
{
this.strContent = "{\"VIP\":1}";
}
else
{
this.strContent = "{\"VIP\":0}";
}
break;
case 3:
strUserName = Server.HtmlDecode(Classlibrary.GetRequest("UserName", 1).ToString());
strPassword = Server.HtmlDecode(Classlibrary.GetRequest("Password", 1).ToString());
intType = SqlLibrary.CheckUser(strUserName, strPassword);
this.strContent = "{\"Status\":" + intType + "}";
break;
case 4:
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 2));
long longTime = SqlLibrary.ReadOnlineTime(intUserID);
this.strContent = "{\"OnlineTime\":" + longTime + "}";
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
StringBuilder sb = new StringBuilder();
int intType = 0;
int intStatus = 0;
intType = Convert.ToInt32(Classlibrary.GetRequest("Type", 0));
if (!intType.Equals(intType) || intType > 0)
{
switch (intType)
{
case 1: //修改密码
//@UserID int,
//@UserName varchar(50),
//@Password varchar(50),
//@NewPassword varchar(50)
int intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
string strUserName = Classlibrary.GetRequest("UserName", 1).ToString();
string strPassword = Classlibrary.GetRequest("Password", 1).ToString();
string strNewPassword = Classlibrary.GetRequest("NewPassword", 1).ToString();
intStatus = SqlLibrary.ModifyPassword(intUserID, strUserName, strPassword, strNewPassword);
if (intStatus == 1)
{
sb.Append("{\"Status\":1}"); //修改成功
this.strContent = sb.ToString();
}
else
{
sb.Append("{\"Status\":0}"); //修改失败
this.strContent = sb.ToString();
}
break;
case 2: //修改用户信息
//@UserID int,
//@UserName varchar(50),
//@Password varchar(50),
//@BirthDay DateTime,
//@Province varchar(20),
//@City varchar(20),
//@QQ varchar(15)
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
strUserName = Classlibrary.GetRequest("UserName", 1).ToString();
strPassword = Classlibrary.GetRequest("Password", 1).ToString();
DateTime dtBirthDay = Convert.ToDateTime(Classlibrary.GetRequest("BirthDay", 1));
string strProvince = Classlibrary.GetRequest("Province", 1).ToString();
string strCity = Classlibrary.GetRequest("City", 1).ToString();
string strQQ = Classlibrary.GetRequest("QQ", 1).ToString();
intStatus = SqlLibrary.ModifyUserInfo(intUserID, strUserName, strPassword, dtBirthDay, strProvince, strCity, strQQ);
if (intStatus == 1)
{
sb.Append("{\"Status\":1}"); //修改成功
this.strContent = sb.ToString();
}
else
{
sb.Append("{\"Status\":0}"); //修改失败
this.strContent = sb.ToString();
}
break;
case 3: //更新拍摄状态
//@UserID int,
//@UserName varchar(50),
//@Password varchar(50),
//@ShootStatus bit
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
strUserName = Classlibrary.GetRequest("UserName", 1).ToString();
strPassword = Classlibrary.GetRequest("Password", 1).ToString();
bool blShootStatus = Convert.ToBoolean(Classlibrary.GetRequest("AutoShoot", 1).ToString());
intStatus = SqlLibrary.ModifyShootStatus(intUserID, strUserName, strPassword, blShootStatus);
if (intStatus == 1)
{
sb.Append("{\"Status\":1}"); //修改成功
this.strContent = sb.ToString();
}
else
{
sb.Append("{\"Status\":0}"); //修改失败
this.strContent = sb.ToString();
}
break;
case 4: //更新拍摄状态
//@UserID int,
//@UserName varchar(50),
//@Password varchar(50)
intUserID = Convert.ToInt32(Classlibrary.GetRequest("UserID", 0));
strUserName = Classlibrary.GetRequest("UserName", 1).ToString();
strPassword = Classlibrary.GetRequest("Password", 1).ToString();
intStatus = SqlLibrary.UpdateOnlineTime(intUserID, strUserName, strPassword);
if (intStatus == 1)
{
sb.Append("{\"Status\":1}"); //修改成功
this.strContent = sb.ToString();
}
else
{
sb.Append("{\"Status\":0}"); //修改失败
this.strContent = sb.ToString();
}
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int intNewMsg = 0;
int intUserID = 0;
int intSendID = 0;
int intType = 0;
int intID = 0;
string strSender = null;
string strContent = null;
StringBuilder sb = new StringBuilder();
intType = Convert.ToInt32(Request.QueryString["Type"].ToString().Trim());
if (!intType.Equals(intType) || intType > 0)
{
switch (intType)
{
case 1: //查询是否有新消息
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
intNewMsg = SqlLibrary.CheckNewMessage(intUserID);
if (intNewMsg > 0)
{
this.strContent = "{\"NewMsg\":" + intNewMsg + "}"; //"<script type='text/javascript'>NewMessage(" + intNewMsg + ");</script>";
}
else
{
this.strContent = "{\"NewMsg\":" + intNewMsg + "}";
}
break;
case 2: //发送新消息
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
intSendID = Convert.ToInt32(Request.QueryString["SendID"].ToString().Trim());
strSender = Server.UrlDecode(Request.QueryString["Sender"].ToString().Trim());
strContent = Server.UrlDecode(Request.QueryString["Content"].ToString().Trim());
DataRow dr_1 = SqlLibrary.SendMessage(intUserID, intSendID, strSender, strContent);
intType = (int)dr_1["Type"];
int intCDTIME = 10 - (int)dr_1["CDTIME"];
if (intType == 1)
{
this.strContent = "{\"Status\":1}"; //"<script type='text/javascript'>alert('新消息发送成功');</script>";
}
else
{
this.strContent = "{\"Status\":0,\"CDTime\":" + intCDTIME + "}"; //"<script type='text/javascript'>alert('新消息发送失败');</script>";
}
break;
case 3: //显示收件箱内容
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
DataTable dt = SqlLibrary.ShowMessageBox(intUserID);
if (dt != null)
{
sb.Append("{\"Count\":" + dt.Rows.Count + ",\"MessageBox\":[");
foreach (DataRow dr in dt.Rows)
{
sb.Append("{\"id\":" + (int)dr["ID"] + ",\"SendID\":" + (int)dr["SendID"] + ",\"Sender\":\"" + (string)dr["Sender"] + "\",\"Content\":\"" + (string)dr["Content"] + "\",\"Status\":\"" + (bool)dr["Status"] + "\",\"SendTime\":\"" + (DateTime)dr["SendTime"] + "\"},");
}
sb.Append("]}");
this.strContent = sb.ToString().Replace(",]}", "]}");
}
else
{
this.strContent = "{\"Count\":0}";
}
break;
case 4: //标记读取消息
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
intID = Convert.ToInt32(Request.QueryString["ID"].ToString().Trim());
intType = SqlLibrary.ReadMessage(intUserID, intID);
if (intType == 1)
{
this.strContent = "{\"Status\":1}"; //;"<script type='text/javascript'></script>";
}
else
{
this.strContent = "{\"Status\":0}"; //;"<script type='text/javascript'></script>";
}
break;
case 5: //标记删除消息
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
intID = Convert.ToInt32(Request.QueryString["ID"].ToString().Trim());
intType = SqlLibrary.DeleteMessage(intUserID, intID);
if (intType == 1)
{
this.strContent = "{\"Status\":1}"; //;"<script type='text/javascript'></script>";
}
else
{
this.strContent = "{\"Status\":0}"; //;"<script type='text/javascript'></script>";
}
break;
case 6: //显示发件人图片和基本信息
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
DataRow dr_a = SqlLibrary.ReadUserInfoAndImg(intUserID);
if (dr_a != null)
{
sb.Append("{\"UserID\":" + (int)dr_a["UserID"] + ",\"NickName\":\"" + (string)dr_a["NickName"] + "\",\"Sex\":\"" + (bool)dr_a["Sex"] + "\",\"LockTime\":" + (int)dr_a["LockTime"] + ",\"Status\":\"" + (bool)dr_a["Status"] + "\",\"Birthday\":\"" + (DateTime)dr_a["Birthday"] + "\",\"Province\":\"" + (string)dr_a["Province"] + "\",\"City\":\"" + (string)dr_a["City"] + "\",\"Tinyurl\":\"" + (string)dr_a["Tinyurl"] + "\",\"Headurl\":\"" + (string)dr_a["Headurl"] + "\",\"LastActiveTime\":\"" + (DateTime)dr_a["LastActiveTime"] + "\",\"BMP\":\"" + (string)dr_a["BMP"] + "\"}");
this.strContent = sb.ToString();
}
break;
case 7: //意见反馈
intUserID = Convert.ToInt32(Request.QueryString["UserID"].ToString().Trim());
strContent = Server.UrlDecode(Request.QueryString["Content"].ToString().Trim());
intType = SqlLibrary.SendPropose(intUserID, strContent);
if (intType == 1)
{
try
{
SqlLibrary.SendQQMsg("178454109", strContent);
}
catch
{
}
this.strContent = "{\"Status\":1}"; //提交成功
}
else
{
this.strContent = "{\"Status\":0}"; //提交失败
}
break;
}
}
}
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)
{
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)
{
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;
}
}
}
