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