private void FillDenouncingContents(DenouncingCollection denouncings, SqlSession db)
{
if (denouncings.Count == 0)
{
return;
}
DenouncingContentCollection contents = null;
using (SqlQuery query = db.CreateQuery())
{
query.CommandText = "SELECT * FROM bx_DenouncingContents WHERE DenouncingID IN (@DenouncingIDs) ORDER BY [DenouncingID]";
query.CreateInParameter <int>("@DenouncingIDs", denouncings.GetDenouncingIDs());
using (XSqlDataReader reader = query.ExecuteReader())
{
contents = new DenouncingContentCollection(reader);
}
}
db.Connection.Close();
Denouncing denouncing = null;
int lastDenouncingID = -1;
for (int i = 0; i < contents.Count; i++)
{
int denouncingID = contents[i].DenouncingID;
if (denouncingID != lastDenouncingID)
{
denouncing = denouncings.GetValue(denouncingID);
lastDenouncingID = denouncingID;
}
denouncing.ContentList.Add(contents[i]);
}
}
private void FillDenouncingContents(DenouncingCollection denouncings, SqlSession db)
{
if (denouncings.Count == 0)
return;
DenouncingContentCollection contents = null;
using (SqlQuery query = db.CreateQuery())
{
query.CommandText = "SELECT * FROM bx_DenouncingContents WHERE DenouncingID IN (@DenouncingIDs) ORDER BY [DenouncingID]";
query.CreateInParameter<int>("@DenouncingIDs", denouncings.GetDenouncingIDs());
using (XSqlDataReader reader = query.ExecuteReader())
{
contents = new DenouncingContentCollection(reader);
}
}
db.Connection.Close();
Denouncing denouncing = null;
int lastDenouncingID = -1;
for (int i = 0; i < contents.Count; i++)
{
int denouncingID = contents[i].DenouncingID;
if (denouncingID != lastDenouncingID)
{
denouncing = denouncings.GetValue(denouncingID);
lastDenouncingID = denouncingID;
}
denouncing.ContentList.Add(contents[i]);
}
}
