public SignalProp getCurSigProp()
{
SignalProp prop = null;
String sql = " SELECT s.lampId, s.signalName, s.type, s.state, c.state as specState, direction, dir_to, s.ip FROM cursignal c LEFT JOIN signal s ON c.lampId=s.lampId AND c.type=1 ";
MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(sql, myConn);
System.Data.Common.DbDataReader reader = cmd.ExecuteReader();
try
{
if (reader.Read())
{
prop = new SignalProp();
prop.SignalID = reader.GetString(0).ToUpper();
prop.SignalName = DBStringToNormal(reader.GetString(1));
prop.Type = reader.IsDBNull(2)? (byte)0 : (byte)reader.GetInt16(2);
prop.State = reader.GetString(3);
prop.SpecState = reader.IsDBNull(4) ? (byte)0 : (byte)reader.GetInt16(4);
prop.DirFrom = reader.IsDBNull(5) ? (byte)0 : (byte)reader.GetInt16(5);
prop.DirTo = reader.IsDBNull(6) ? (byte)0 : (byte)reader.GetInt16(6);
prop.Ip = reader.GetString(7);
}
reader.Close();
}
catch (Exception e)
{
reader.Close();
Trace.TraceError("get cur signal prop " + e.StackTrace);
}
return(prop);
}
public List <SandboxGame> GetWaitGameSandBox()
{
List <SandboxGame> gameinfo = new List <SandboxGame>();
string sql = $"Select * FROM sandbox_game_session WHERE status='wait'";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
SandboxGame sb = new SandboxGame();
sb.id = reader.GetInt16(0);
sb.datetime = reader.GetInt16(1);
UserGroup ug = new UserGroup();
ug.users
}
}
}
return(gameinfo);
}
public User GetUserSourceInfo(int user_id)
{
User us = new User();
string sql = $"SELECT users.id, users.name, sources.id, upload_time FROM users,sources WHERE sources.user_id=users.id AND users.id={user_id} AND used=1 AND sources.status='ok'";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
us.id = reader.GetInt16(0);
us.name = reader.GetString(1);
us.compiledAndUsedSourceId = reader.GetInt16(3);
us.last_upload_time = reader.GetInt16(4);
}
}
}
return(us);
}
public UserGroup GetUsersInGroup(int group_id)
{
UserGroup ug = new UserGroup();
string sql = $"Select group_id, user_id FROM users_group WHERE group_id={group_id}";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
ug.group_id = reader.GetInt16(0);
dbUser us = new dbUser();
us.id = reader.GetInt16(1);
ug.users.Add(us);
}
}
}
for (int i = 0; i < ug.users.Count; i++)
{
ug.users[i] = GetUserSourceInfo(ug.users[i].id);
}
return(ug);
}
public List <dbUser> GetOnlyUsers(int group_id)
{
List <dbUser> users = new List <dbUser>();
string sql = $"SELECT users.id FROM users, users_group WHERE users_group.group_id={group_id} AND users_group.user_id = users.id AND users.is_bot=1";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
dbUser us = new dbUser();
us.id = reader.GetInt16(0);
users.Add(us);
}
}
}
return(users);
}
public List <Game> GetWaitGame(string type)
{
List <Game> games_list = new List <Game>();
string sql = $"SELECT * FROM {type} WHERE status='wait'";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Game sb = new Game();
sb.id = reader.GetInt16(0);
sb.datetime = reader.GetInt32(1);
UserGroup ug = new UserGroup();
ug.group_id = reader.GetInt16(2);
sb.usergroup = ug;
sb.status = reader.GetString(3);
if (type == "sandbox")
{
dbUser us = new dbUser();
us.id = reader.GetInt16(4);
sb.creator = us;
}
games_list.Add(sb);
}
}
}
for (int i = 0; i < games_list.Count; i++)
{
games_list[i].usergroup = GetUsersInGroup(games_list[i].usergroup.group_id);
games_list[i].creator = GetUserSourceInfo(games_list[i].creator.id);
}
return(games_list);
}
public void GetWaitSourcesId(out int id, out int user_id)
{
id = -1;
user_id = -1;
string sql = "Select id,user_id FROM sources WHERE status='wait' LIMIT 1";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
id = reader.GetInt16(0);
user_id = reader.GetInt16(1);
}
}
}
public int GetWaitCount()
{
string sql = "Select COUNT(id) FROM sources WHERE status='wait'";
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = sql;
int count = 0;
using (System.Data.Common.DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
count = reader.GetInt16(0);
}
}
return(count);
}
/// <summary>
/// Gets an int16 column.
/// </summary>
/// <param name="reader"></param>
/// <param name="ordinal">The column number</param>
/// <returns></returns>
public static Int16?GetNInt16(this System.Data.Common.DbDataReader reader, int ordinal)
{
return(reader.IsDBNull(ordinal) ? (Int16?)null : reader.GetInt16(ordinal));
}
/// <summary>
/// Gets an int16 column. Slower then GetOrdinal + GetInt16
/// </summary>
/// <param name="reader"></param>
/// <param name="name"></param>
/// <returns></returns>
public static Int16?GetNInt16(this System.Data.Common.DbDataReader reader, string name)
{
int ordinal = reader.GetOrdinal(name);
return(reader.IsDBNull(ordinal) ? (Int16?)null : reader.GetInt16(ordinal));
}
