// 登入消息处理
public static bool login(string account, string password, string ip, string port)
{
try
{
string homeFolder = CommonStaticVariables.homePath + account;
string selectCmdStr = "SELECT * FROM tb_accounts WHERE account = '" + account + "' And password = '******'";
string updateCmdStr = "UPDATE tb_accounts SET ip = '" + ip + "', port = '" + port + "', status = '" + CommonStaticVariables.statusOnline + "', home = '" + homeFolder + "', lastTime = '" + DateTime.Now + "' WHERE account = '" + account + "' AND password = '******'";
if (SQLHandler.DrRead(selectCmdStr))
{
SQLHandler.OperateRecord(updateCmdStr);
if (!Directory.Exists(homeFolder))
{
FileSystemHandler.CreateDirectory(homeFolder, DateTime.Now);
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return(false);
}
}
// 注册消息处理
public static bool registration(string account, string password, string ip, string port)
{
try
{
string homeFolder = CommonStaticVariables.homePath + account;
string selectCmdStr = "SELECT account FROM tb_accounts WHERE account = '" + account + "'";
if (SQLHandler.DrRead(selectCmdStr))
{
return(false);
}
else
{
string insertCmdStr = "INSERT INTO tb_accounts (account, password, ip, port, status, home, registerTime) VALUES ( '" + account + "','" + password + "', '" + ip + "', '" + port + "', '" + CommonStaticVariables.statusOffline + "', '" + homeFolder + "', '" + DateTime.Now + "')";
SQLHandler.OperateRecord(insertCmdStr);
FileSystemHandler.CreateDirectory(homeFolder, DateTime.Now);
return(true);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return(false);
}
}