/// <summary>
/// 获得EntityList类型数据
/// </summary>
/// <typeparam name="T">数据模型</typeparam>
/// <param name="strTableName">表名</param>
/// <param name="strWhere">过滤条件</param>
/// <returns>成功返回ListT,失败返回null</returns>
public static List <T> GetEntityList <T>(string strTableName, string strWhere) where T : class, new()
{
try
{
List <T> listT = new List <T>();
SQLiteHelper sqlHelper = new SQLiteHelper();
sqlHelper.SQLiteConnectionString(strSQLiteConn);
sqlHelper.Open();
if (string.IsNullOrEmpty(strWhere))
{
listT = DataProcessing.ConvertToList <T>(sqlHelper.GetDataTable(string.Format("SELECT * FROM {0}", strTableName)));
}
else
{
listT = DataProcessing.ConvertToList <T>(sqlHelper.GetDataTable(string.Format("SELECT * FROM {0} WHERE {1}", strTableName, strWhere)));
}
sqlHelper.Close();
return(listT);
}
catch (Exception ex)
{
TXTHelper.Logs(ex.ToString());
return(null);
}
}