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; }