public Info[] GetInfos()
{
string sql = "select name from info";
DataTable dt = SQLiteHelper.ExecuteDataTable(sql);
List <Info> _infos = new DbTableConvertor <Info>().ConvertToList(dt);
Info[] infos = new Info[_infos.Count];
int i = 0;
foreach (var info in _infos)
{
infos[i] = info;
i++;
}
return(infos);
}
/// <summary>
/// 查找测线基本信息
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public Info FindLineInfo(string name)
{
try
{
string sql = "select name,site,distance from Info where name = '" + name + "'";
DataTable dt = SQLiteHelper.ExecuteDataTable(sql);
if (dt.Rows.Count == 0)
{
return(null);
}
List <Info> _infos = new DbTableConvertor <Info>().ConvertToList(dt);
return(_infos[0]);
}
catch (Exception ex)
{
Log4netHelper.Error(ex);
return(null);
}
}
