/// <summary> /// 获取活动列表 /// </summary> /// <returns></returns> public List <RemotingInterface.PlayInfo> GetPlayList() { SqlConnection sqlConn = new SqlConnection(Common.strConn); if (sqlConn.State == ConnectionState.Closed) { sqlConn.Open(); } try { SqlCommand sqlCmd = new SqlCommand("SELECT * FROM [Play] ORDER BY PlayID", sqlConn); SqlDataReader sqlReader = sqlCmd.ExecuteReader(); List <RemotingInterface.PlayInfo> listPlay = new List <RemotingInterface.PlayInfo>(); RemotingInterface.PlayInfo playInfo = new RemotingInterface.PlayInfo(); playInfo.Clear(); while (sqlReader.Read()) { playInfo.PlayId = Convert.ToInt32(sqlReader["PlayId"]); playInfo.PlayName = sqlReader["PlayName"].ToString(); playInfo.PlayState = Convert.ToByte(sqlReader["PlayState"]); playInfo.Description = sqlReader["Description"].ToString(); listPlay.Add(playInfo); Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": Load the play list : PlayId = " + playInfo.PlayId + "\t PlayName = " + playInfo.PlayName); } return(listPlay); } catch (Exception ex) { Loger.Debug(ex.ToString()); return(null); } finally { if (sqlConn.State != ConnectionState.Closed) { sqlConn.Close(); } } }
/// <summary> /// 获取活动列表 /// </summary> /// <returns></returns> public List<RemotingInterface.PlayInfo> GetPlayList() { SqlConnection sqlConn = new SqlConnection(Common.strConn); if (sqlConn.State == ConnectionState.Closed) sqlConn.Open(); try { SqlCommand sqlCmd = new SqlCommand("SELECT * FROM [Play] ORDER BY PlayID", sqlConn); SqlDataReader sqlReader = sqlCmd.ExecuteReader(); List<RemotingInterface.PlayInfo> listPlay = new List<RemotingInterface.PlayInfo>(); RemotingInterface.PlayInfo playInfo = new RemotingInterface.PlayInfo(); playInfo.Clear(); while (sqlReader.Read()) { playInfo.PlayId = Convert.ToInt32(sqlReader["PlayId"]); playInfo.PlayName = sqlReader["PlayName"].ToString(); playInfo.PlayState = Convert.ToByte(sqlReader["PlayState"]); playInfo.Description = sqlReader["Description"].ToString(); listPlay.Add(playInfo); Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": Load the play list : PlayId = " + playInfo.PlayId + "\t PlayName = " + playInfo.PlayName); } return listPlay; } catch (Exception ex) { Loger.Debug(ex.ToString()); return null; } finally { if (sqlConn.State != ConnectionState.Closed) sqlConn.Close(); } }