internal void Build(IBaseBO bo, IQueryFormat qformat, IQueryAdds adds, QueryTypes query_type, ConnectionTypes conn_type)
{
try
{
string queryText = string.Empty;
queryText = qformat.Format;
queryText = queryText ?? string.Empty;
string table_name = string.Empty;
string columns = string.Empty;
string vals = string.Empty;
table_name = GetTableName(bo, adds);
columns = GetColumns(bo, adds, query_type, conn_type);
vals = GetVals(bo, adds, query_type, conn_type);
queryText = queryText.Replace("#TABLE_NAME#", table_name);
queryText = queryText.Replace("#COLUMNS#", columns);
queryText = queryText.Replace("#VALS#", vals);
query.Text = queryText;
List <DbParameter> parameters = GetParameters(bo, adds, query_type);
query.Parameters = parameters;
}
catch (Exception e)
{
throw;
}
}
protected IQueryFormat GetEngine(IDbCommand actual)
{
if (engine == null)
{
engine = new QueryEngineFactory().GetFormat(actual);
}
return(engine);
}
internal static IQuery Build(IBaseBO bo, IQueryFormat qformat, IQueryAdds adds, QueryTypes query_type, ConnectionTypes conn_type)
{
IQuery q = null;
try
{
q = new Query();
string query = string.Empty;
query = qformat.Format;
query = query ?? string.Empty;
string table_name = "";
string columns = "";
string vals = "";
Hashmap h = null;
table_name = GetTableName(bo, adds);
columns = GetColumns(bo, adds, query_type, conn_type);
vals = GetVals(bo, adds, query_type, conn_type);
h = GetParameters(bo, adds, query_type);
query = query.Replace("#TABLE_NAME#", table_name);
query = query.Replace("#COLUMNS#", columns);
query = query.Replace("#VALS#", vals);
q.Text = query;
q.Parameters = h;
}
catch (Exception)
{
throw;
}
return(q);
}
protected IQueryFormat GetEngine(IDbCommand actual)
{
if (engine == null)
engine = new QueryEngineFactory().GetFormat(actual);
return engine;
}
