public override void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler) { string sql = "SELECT * FROM Parts AS P NATURAL LEFT JOIN " + partType.name + "_attributes AS A WHERE P.Part_type_id = " + partType.typeId; Execute(sql, delegate(DataTable result) { PartCollection parts = new PartCollection(result); if (partsHandler != null) { partsHandler(parts); } }, errorHandler); }
public override void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler) { SqlCommandBuilder bld = new SqlCommandBuilder(); SqlCommand cmd = new SqlCommand(); string tableNameEscaped = bld.QuoteIdentifier(partType.name); cmd.CommandType = System.Data.CommandType.Text; #if DEBUG cmd.CommandText = string.Format("SELECT TOP 4 * FROM {0} ORDER BY [Part Number] ASC", tableNameEscaped); #else cmd.CommandText = string.Format("SELECT * FROM {0} ORDER BY [Part Number] ASC", tableNameEscaped); #endif Execute(cmd, delegate(DataTable result) { result.Columns["Part Number"].ColumnName = "Part_num"; //result.Columns.Remove("Part Type"); PartCollection parts = new PartCollection(result); if (partsHandler != null) { partsHandler(parts); } }, errorHandler); }
public abstract void GetParts(PartType partType, PartsHandler partsHandler, ErrorHandler errorHandler);