private void SetAttachmentParams(SqlQuery query, AttachmentCollection attachments, IEnumerable<int> historyAttachmentIDs)
{
query.CreateParameter("@AttachmentIds", attachments.BuildIds(), SqlDbType.VarChar, 8000);
query.CreateParameter("@AttachmentFileNames", attachments.BuildFileNames(), SqlDbType.NText);
query.CreateParameter("@AttachmentFileIds", attachments.BuildFileIds(), SqlDbType.Text);
query.CreateParameter("@AttachmentFileSizes", attachments.BuildFileSizes(), SqlDbType.VarChar, 8000);
query.CreateParameter("@AttachmentPrices", attachments.BuildPrices(), SqlDbType.VarChar, 8000);
query.CreateParameter("@AttachmentFileExtNames", attachments.BuildFileExtNames(), SqlDbType.NText);
query.CreateParameter("@HistoryAttachmentIDs", StringUtil.Join(historyAttachmentIDs), SqlDbType.VarChar, 500);
}
