/// <summary>
/// 获取区域列表
/// </summary>
/// <param name="gameId"></param>
/// <returns></returns>
public List<RemotingInterface.AreaInfo> GetAreaList(int gameId)
{
SqlConnection sqlConn = new SqlConnection(Common.strConn);
if (sqlConn.State == ConnectionState.Closed)
sqlConn.Open();
try
{
if (gameId == 0)
return null;
SqlCommand sqlCmd = new SqlCommand("SELECT * FROM [Area] where GameId=" + gameId + " ORDER BY AreaID", sqlConn);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
List<RemotingInterface.AreaInfo> listArea = new List<RemotingInterface.AreaInfo>();
RemotingInterface.AreaInfo areaInfo = new RemotingInterface.AreaInfo();
areaInfo.Clear();
while (sqlReader.Read())
{
areaInfo.AreaId = Convert.ToInt32(sqlReader["AreaId"]);
areaInfo.AreaName = sqlReader["AreaName"].ToString();
areaInfo.AreaRegDateStart = Convert.ToDateTime(sqlReader["AreaRegDateStart"]);
areaInfo.AreaRegDateEnd = Convert.ToDateTime(sqlReader["AreaRegDateEnd"]);
areaInfo.AreaDateStart = Convert.ToDateTime(sqlReader["AreaDateStart"]);
areaInfo.AreaDateEnd = Convert.ToDateTime(sqlReader["AreaDateEnd"]);
areaInfo.AreaState = Convert.ToByte(sqlReader["AreaState"]);
areaInfo.CreateDate = Convert.ToDateTime(sqlReader["CreateDate"]);
areaInfo.AreaDescription = sqlReader["AreaDescription"].ToString();
if (listArea.Contains(areaInfo))
listArea[areaInfo.AreaId] = areaInfo;
else
listArea.Add(areaInfo);
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": Load the Area list : GameId = " + gameId + "\t AreaId = " + areaInfo.AreaId + " \t AreaName = " + areaInfo.AreaName);
}
return listArea;
}
catch (Exception ex)
{
Loger.Debug(ex.ToString());
return null;
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
sqlConn.Close();
}
}
/// <summary>
/// 获取区域列表
/// </summary>
/// <param name="gameId"></param>
/// <returns></returns>
public List <RemotingInterface.AreaInfo> GetAreaList(int gameId)
{
SqlConnection sqlConn = new SqlConnection(Common.strConn);
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
try
{
if (gameId == 0)
{
return(null);
}
SqlCommand sqlCmd = new SqlCommand("SELECT * FROM [Area] where GameId=" + gameId + " ORDER BY AreaID", sqlConn);
SqlDataReader sqlReader = sqlCmd.ExecuteReader();
List <RemotingInterface.AreaInfo> listArea = new List <RemotingInterface.AreaInfo>();
RemotingInterface.AreaInfo areaInfo = new RemotingInterface.AreaInfo();
areaInfo.Clear();
while (sqlReader.Read())
{
areaInfo.AreaId = Convert.ToInt32(sqlReader["AreaId"]);
areaInfo.AreaName = sqlReader["AreaName"].ToString();
areaInfo.AreaRegDateStart = Convert.ToDateTime(sqlReader["AreaRegDateStart"]);
areaInfo.AreaRegDateEnd = Convert.ToDateTime(sqlReader["AreaRegDateEnd"]);
areaInfo.AreaDateStart = Convert.ToDateTime(sqlReader["AreaDateStart"]);
areaInfo.AreaDateEnd = Convert.ToDateTime(sqlReader["AreaDateEnd"]);
areaInfo.AreaState = Convert.ToByte(sqlReader["AreaState"]);
areaInfo.CreateDate = Convert.ToDateTime(sqlReader["CreateDate"]);
areaInfo.AreaDescription = sqlReader["AreaDescription"].ToString();
if (listArea.Contains(areaInfo))
{
listArea[areaInfo.AreaId] = areaInfo;
}
else
{
listArea.Add(areaInfo);
}
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + ": Load the Area list : GameId = " + gameId + "\t AreaId = " + areaInfo.AreaId + " \t AreaName = " + areaInfo.AreaName);
}
return(listArea);
}
catch (Exception ex)
{
Loger.Debug(ex.ToString());
return(null);
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
{
sqlConn.Close();
}
}
}