public AncestorResult Query <T>(IModel objectModel) where T : class, IModel, new()
{
var isSuccess = false;
var sqlString = string.Empty;
var returnResult = new AncestorResult();
var parameters = new List <OracleParameter>();
var dataTable = new DataTable();
try
{
SqlString.Clear();
// 2015-08-31
//sqlString = QueryStringGenerator(objectModel, parameters);
var tableName = objectModel.GetType().Name;
SqlString.Append("SELECT " + tableName + ".*, ROWID FROM " + tableName);
var sqlWhereCondition = ParseWhereCondition(objectModel, parameters);
SqlString.Append(sqlWhereCondition);
isSuccess = DB.Query(SqlString.ToString(), parameters, ref dataTable);
returnResult.Message = DB.ErrorMessage;
returnResult.DataList = dataTable.ToList <T>();
}
catch (Exception exception)
{
returnResult.Message = exception.ToString();
isSuccess = false;
}
returnResult.IsSuccess = isSuccess;
return(returnResult);
}
public void Clear_Test()
{
var query = new SqlString("Hello");
query.Clear();
Assert.AreEqual(String.Empty, query);
}