public static List <ObjectFour> ServerSelByGID(int iGameID) { Database dbDCenter = DatabaseFactory.CreateDatabase(sConnRead); DbCommand dcServer = dbDCenter.GetStoredProcCommand("Server_AllSelByGID"); dbDCenter.AddInParameter(dcServer, "@gameid", DbType.String, iGameID); IDataReader drServer = dbDCenter.ExecuteReader(dcServer); List <ObjectFour> dServerObject = new List <ObjectFour>(); while (drServer.Read()) { ObjectFour otObject = new ObjectFour(); otObject.first = drServer["serverid"].ToString(); otObject.second = drServer["abbre"].ToString(); otObject.third = drServer["servername"].ToString(); otObject.Fourth = drServer["begintime"].ToString(); dServerObject.Add(otObject); } drServer.Close(); drServer.Dispose(); return(dServerObject); }
public static List <ObjectFour> ServerStartAtTime(DateTime dtBegin, DateTime dtEnd) { Database dbDCenter = DatabaseFactory.CreateDatabase(sConnRead); DbCommand dcServer = dbDCenter.GetStoredProcCommand("Server_StartAtTime"); dbDCenter.AddInParameter(dcServer, "@begintime", DbType.DateTime, dtBegin); dbDCenter.AddInParameter(dcServer, "@endtime", DbType.DateTime, dtEnd); IDataReader drServer = dbDCenter.ExecuteReader(dcServer); List <ObjectFour> dServerObject = new List <ObjectFour>(); while (drServer.Read()) { ObjectFour otObject = new ObjectFour(); otObject.first = drServer["serverid"].ToString(); otObject.second = drServer["abbre"].ToString(); otObject.third = drServer["gamename"].ToString(); otObject.Fourth = drServer["begintime"].ToString(); dServerObject.Add(otObject); } drServer.Close(); drServer.Dispose(); return(dServerObject); }