public DenouncingCollection GetDenouncingWithReply(DenouncingFilter filter, int pageNumber)
{
if (pageNumber < 1)
pageNumber = 1;
DenouncingCollection result = DenouncingDao.Instance.GetDenouncingWithReply(filter, pageNumber);
return result;
}
public DenouncingCollection GetDenouncingBySearch(DenouncingFilter filter, int pageNumber)
{
if (pageNumber < 1)
pageNumber = 1;
DenouncingCollection reports = DenouncingDao.Instance.GetDenouncingBySearch(filter, pageNumber);
return reports;
}
public override DenouncingCollection GetDenouncingWithReply(DenouncingFilter filter, int pageNumber)
{
using (SqlSession db = new SqlSession())
{
DenouncingCollection denouncings = null;
using (SqlQuery query = db.CreateQuery())
{
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = filter.PageSize;
query.Pager.TableName = "bx_Denouncings";
query.Pager.SortField = "DenouncingID";
query.Pager.IsDesc = filter.IsDesc;
query.Pager.SelectCount = true;
filter.Type = DenouncingType.Reply;
GetSearchDenouncingsCondition(query, filter);
using (XSqlDataReader reader = query.ExecuteReader())
{
denouncings = new DenouncingCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
{
denouncings.TotalRecords = reader.Get <int>(0);
}
}
}
}
FillDenouncingContents(denouncings, db);
if (denouncings.Count > 0)
{
int[] targetIDs = GetTargetIDs(denouncings);
PostCollectionV5 posts = PostBOV5.Instance.GetPosts(targetIDs);
for (int i = 0; i < denouncings.Count; i++)
{
for (int j = 0; j < posts.Count; j++)
{
if (denouncings[i].TargetID == posts[j].ThreadID)
{
denouncings[i].TargetReply = posts[j];
break;
}
}
}
}
return(denouncings);
}
}
private int[] GetTargetIDs(DenouncingCollection denouncings)
{
int[] ids = new int[denouncings.Count];
for (int i = 0; i < ids.Length; i++)
{
ids[i] = denouncings[i].TargetID;
}
return(ids);
}
public override DenouncingCollection GetDenouncingWithUser(DenouncingFilter filter, int pageNumber)
{
using (SqlSession db = new SqlSession())
{
DenouncingCollection denouncings = null;
using (SqlQuery query = db.CreateQuery())
{
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = filter.PageSize;
query.Pager.TableName = "bx_Denouncings";
query.Pager.SortField = "DenouncingID";
query.Pager.IsDesc = filter.IsDesc;
query.Pager.SelectCount = true;
filter.Type = DenouncingType.Space;
GetSearchDenouncingsCondition(query, filter);
using (XSqlDataReader reader = query.ExecuteReader())
{
denouncings = new DenouncingCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
{
denouncings.TotalRecords = reader.Get <int>(0);
}
}
}
}
FillDenouncingContents(denouncings, db);
if (denouncings.Count > 0)
{
UserBO.Instance.WaitForFillSimpleUsers <Denouncing>(denouncings);
}
return(denouncings);
}
}
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]);
}
}
public override DenouncingCollection GetDenouncingWithReply(DenouncingFilter filter, int pageNumber)
{
using (SqlSession db = new SqlSession())
{
DenouncingCollection denouncings = null;
using (SqlQuery query = db.CreateQuery())
{
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = filter.PageSize;
query.Pager.TableName = "bx_Denouncings";
query.Pager.SortField = "DenouncingID";
query.Pager.IsDesc = filter.IsDesc;
query.Pager.SelectCount = true;
filter.Type = DenouncingType.Reply;
GetSearchDenouncingsCondition(query, filter);
using (XSqlDataReader reader = query.ExecuteReader())
{
denouncings = new DenouncingCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
denouncings.TotalRecords = reader.Get<int>(0);
}
}
}
FillDenouncingContents(denouncings, db);
if (denouncings.Count > 0)
{
int[] targetIDs = GetTargetIDs(denouncings);
PostCollectionV5 posts = PostBOV5.Instance.GetPosts(targetIDs);
for (int i = 0; i < denouncings.Count; i++)
{
for (int j = 0; j < posts.Count; j++)
{
if (denouncings[i].TargetID == posts[j].ThreadID)
{
denouncings[i].TargetReply = posts[j];
break;
}
}
}
}
return denouncings;
}
}
public override DenouncingCollection GetDenouncingWithUser(DenouncingFilter filter, int pageNumber)
{
using (SqlSession db = new SqlSession())
{
DenouncingCollection denouncings = null;
using (SqlQuery query = db.CreateQuery())
{
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = filter.PageSize;
query.Pager.TableName = "bx_Denouncings";
query.Pager.SortField = "DenouncingID";
query.Pager.IsDesc = filter.IsDesc;
query.Pager.SelectCount = true;
filter.Type = DenouncingType.Space;
GetSearchDenouncingsCondition(query, filter);
using (XSqlDataReader reader = query.ExecuteReader())
{
denouncings = new DenouncingCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
denouncings.TotalRecords = reader.Get<int>(0);
}
}
}
FillDenouncingContents(denouncings, db);
if (denouncings.Count > 0)
{
UserBO.Instance.WaitForFillSimpleUsers<Denouncing>(denouncings);
}
return denouncings;
}
}
public override DenouncingCollection GetDenouncingWithShare(DenouncingFilter filter, int pageNumber)
{
using (SqlSession db = new SqlSession())
{
DenouncingCollection denouncings = null;
using (SqlQuery query = db.CreateQuery())
{
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = filter.PageSize;
query.Pager.TableName = "bx_Denouncings";
query.Pager.SortField = "DenouncingID";
query.Pager.IsDesc = filter.IsDesc;
query.Pager.SelectCount = true;
filter.Type = DenouncingType.Share;
GetSearchDenouncingsCondition(query, filter);
using (XSqlDataReader reader = query.ExecuteReader())
{
denouncings = new DenouncingCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
denouncings.TotalRecords = reader.Get<int>(0);
}
}
}
FillDenouncingContents(denouncings, db);
if (denouncings.Count > 0)
{
int[] targetIDs = GetTargetIDs(denouncings);
ShareCollection shares = null;
using (SqlQuery query = db.CreateQuery())
{
query.CommandText = "SELECT * FROM bx_SharesView WHERE ShareID IN (@IDs)";
query.CreateInParameter<int>("@IDs", targetIDs);
using (XSqlDataReader reader = query.ExecuteReader())
{
shares = new ShareCollection(reader);
}
}
ShareBO.Instance.ProcessKeyword(shares, ProcessKeywordMode.FillOriginalText);
for (int i = 0; i < denouncings.Count; i++)
{
for (int j = 0; j < shares.Count; j++)
{
if (denouncings[i].TargetID == shares[j].ShareID)
{
denouncings[i].TargetShare = shares[j];
break;
}
}
}
}
return denouncings;
}
}
private int[] GetTargetIDs(DenouncingCollection denouncings)
{
int[] ids = new int[denouncings.Count];
for (int i = 0; i < ids.Length; i++ )
{
ids[i] = denouncings[i].TargetID;
}
return ids;
}
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]);
}
}
public override DenouncingCollection GetDenouncingWithShare(DenouncingFilter filter, int pageNumber)
{
using (SqlSession db = new SqlSession())
{
DenouncingCollection denouncings = null;
using (SqlQuery query = db.CreateQuery())
{
query.Pager.PageNumber = pageNumber;
query.Pager.PageSize = filter.PageSize;
query.Pager.TableName = "bx_Denouncings";
query.Pager.SortField = "DenouncingID";
query.Pager.IsDesc = filter.IsDesc;
query.Pager.SelectCount = true;
filter.Type = DenouncingType.Share;
GetSearchDenouncingsCondition(query, filter);
using (XSqlDataReader reader = query.ExecuteReader())
{
denouncings = new DenouncingCollection(reader);
if (reader.NextResult())
{
while (reader.Read())
{
denouncings.TotalRecords = reader.Get <int>(0);
}
}
}
}
FillDenouncingContents(denouncings, db);
if (denouncings.Count > 0)
{
int[] targetIDs = GetTargetIDs(denouncings);
ShareCollection shares = null;
using (SqlQuery query = db.CreateQuery())
{
query.CommandText = "SELECT * FROM bx_SharesView WHERE ShareID IN (@IDs)";
query.CreateInParameter <int>("@IDs", targetIDs);
using (XSqlDataReader reader = query.ExecuteReader())
{
shares = new ShareCollection(reader);
}
}
ShareBO.Instance.ProcessKeyword(shares, ProcessKeywordMode.FillOriginalText);
for (int i = 0; i < denouncings.Count; i++)
{
for (int j = 0; j < shares.Count; j++)
{
if (denouncings[i].TargetID == shares[j].ShareID)
{
denouncings[i].TargetShare = shares[j];
break;
}
}
}
}
return(denouncings);
}
}
