protected void AppendCopyToList(T transmittal)
{
StringBuilder builder = new StringBuilder(100);
builder.Append(string.Format("SELECT * FROM {0}CopyList",
this.EntityName));
builder.Append(string.Format(" WHERE {0} = '{1}';",
this.KeyFieldName,
transmittal.Key));
using (IDataReader reader = this.ExecuteReader(builder.ToString()))
{
while (reader.Read())
{
transmittal.CopyToList.Add(TransmittalFactory.BuildCopyTo(
transmittal.ProjectKey, reader));
}
}
}
protected void AppendRoutingItems(T transmittal)
{
StringBuilder builder = new StringBuilder(100);
builder.Append(string.Format("SELECT * FROM {0}RoutingItem tri ", this.EntityName));
builder.Append(" INNER JOIN RoutingItem ri ON");
builder.Append(" tri.RoutingItemID = ri.RoutingItemID");
builder.Append(" INNER JOIN Discipline d ON");
builder.Append(" ri.DisciplineID = d.DisciplineID");
builder.Append(string.Format(" WHERE tri.{0} = '{1}';",
this.KeyFieldName, transmittal.Key));
using (IDataReader reader = this.ExecuteReader(builder.ToString()))
{
while (reader.Read())
{
transmittal.RoutingItems.Add(TransmittalFactory.BuildRoutingItem(
transmittal.ProjectKey, reader));
}
}
}