public T select <T>(string sql) where T : new() { Dictionary <int, string> columns = GetColumnsBySql(sql); string data = null; try { transport.Open(); client.execute(sql); data = client.fetchOne(); transport.Close(); } catch (Exception ex) { transport.Close(); Console.WriteLine(ex.Message); LogService.LogService.Instance.Logger(ex.Message, "hive"); } T result = ClassReflection.Get <T>(columns, data, ','); return(result); }
public List <T> SelectList <T>(string sql) where T : new() { Dictionary <int, string> columns = GetColumnsBySql(sql); List <string> result = null; try { transport.Open(); client.execute(sql); result = client.fetchAll(); transport.Close(); } catch (Exception ex) { transport.Close(); Console.WriteLine(ex.Message); LogService.LogService.Instance.Logger(ex.Message, "hive"); } List <T> list = ClassReflection.GetList <T>(columns, result, ','); return(list); }