public io.Data.Return<System.Data.DataTable> Run(string where, string orderBy, string join, int top)
{
if (_dataTable != null)
_dataTable.Dispose();
_dataTable = new System.Data.DataTable();
try
{
using (System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(_connectionString))
{
using (System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sqlString(where, orderBy, join, top), cn))
{
da.SelectCommand.CommandTimeout = 0;
da.Fill(_dataTable);
}
cn.Close();
}
_result = new io.Data.Return<System.Data.DataTable>(io.Constants.SUCCESS,"","", _dataTable);
}
catch (System.Exception e)
{
_result = new io.Data.Return<System.Data.DataTable>(io.Constants.FAILURE, e.Message, "", null);
}
return _result;
}
protected void Dispose(bool disposing)
{
if (!_disposedValue)
{
if (disposing)
{
if (_dataTable != null) _dataTable.Dispose();
_dataTable = null;
_result = null;
}
_viewName = "";
_sql = "";
}
_disposedValue = true;
}
