/// <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);
}
/// <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");
}
}
/// <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");
}
}