internal static List<LEDParaEntity> GetAllLEDParam()
{
List<LEDParaEntity> paramList = new List<LEDParaEntity>();
DbConnection dbConnection = null;
string strSQL = "select GPSCode,Height,Width,ColorType from gps_LEDSetting";
try
{
DataTable table = new DataTable();
dbConnection = GetConnection(EnumDBOperationType.GlobalDB);
if (dbConnection == null)
return paramList;
if (dbConnection.State != ConnectionState.Open)
dbConnection.Open();
DbCommand command = dbConnection.CreateCommand();
command.CommandText = strSQL;
DbDataReader reader = command.ExecuteReader();
table.Load(reader);
reader.Close();
foreach (DataRow row in table.Rows)
{
LEDParaEntity entity = new LEDParaEntity();
entity.GPSCode = row["GPSCode"].ToString();
entity.Height = TryParseUshort(row["Height"].ToString());
entity.Width = TryParseUshort(row["Width"].ToString());
entity.ColorType = row["ColorType"].ToString() == "1" ? LEDColorType.Homochromy : LEDColorType.DualColour;
paramList.Add(entity);
}
table.Dispose();
reader.Dispose();
return paramList;
}
catch (Exception ex)
{
Loggers.LogInfo("GPSDataHelper.GetAllLEDParam:" + ex);
return paramList;
}
finally
{
CloseDBConnection(dbConnection);
}
}
/// <summary>
/// 获取LED参数设置
/// </summary>
/// <returns></returns>
public List<LEDParaEntity> GetAllLEDParam()
{
List<LEDParaEntity> paramList = new List<LEDParaEntity>();
DbConnection dbConnection = null;
string strSQL = "select GPSCode,Height,Width,ColorType from gps_LEDSetting";
try
{
using (dbConnection = GetConnection(_DefaultConnectionString))
{
DataTable table = new DataTable();
DbCommand command = dbConnection.CreateCommand();
command.CommandText = strSQL;
DbDataReader reader = command.ExecuteReader();
table.Load(reader);
reader.Close();
foreach (DataRow row in table.Rows)
{
LEDParaEntity entity = new LEDParaEntity();
entity.GPSCode = row["GPSCode"].ToString();
entity.Height = TryParseUshort(row["Height"].ToString());
entity.Width = TryParseUshort(row["Width"].ToString());
entity.ColorType = row["ColorType"].ToString() == "1" ? LEDColorType.Homochromy : LEDColorType.DualColour;
paramList.Add(entity);
}
table.Dispose();
reader.Dispose();
}
}
catch (Exception ex)
{
Logger.Warn("GetAllLEDParam:" + ex.Message);
}
return paramList;
}