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 void GetSearchDenouncingsCondition(SqlQuery query, DenouncingFilter filter)
{
StringBuilder condition = new StringBuilder();
if (filter.Type != DenouncingType.All)
{
condition.Append(" AND Type = @Type");
query.CreateParameter <int>("@Type", (int)filter.Type, SqlDbType.TinyInt);
}
if (filter.ReportState != null && filter.ReportState.Value != 2)
{
condition.Append(" AND IsIgnore = @IsIgnore");
bool isIgnore = false;
if (filter.ReportState.Value == 1)
{
isIgnore = true;
}
else
{
isIgnore = false;
}
query.CreateParameter <bool>("@IsIgnore", isIgnore, SqlDbType.Bit);
}
if (filter.BeginDate != null)
{
condition.Append(" AND CreateDate >= @BeginDate");
query.CreateParameter <DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime);
}
if (filter.EndDate != null)
{
condition.Append(" AND CreateDate <= @EndDate");
query.CreateParameter <DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime);
}
if (condition.Length != 0)
{
condition = condition.Remove(0, 5);
}
query.Pager.Condition = condition.ToString();
}
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 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 void GetSearchDenouncingsCondition(SqlQuery query, DenouncingFilter filter)
{
StringBuilder condition = new StringBuilder();
if (filter.Type != DenouncingType.All)
{
condition.Append(" AND Type = @Type");
query.CreateParameter<int>("@Type", (int)filter.Type, SqlDbType.TinyInt);
}
if (filter.ReportState != null && filter.ReportState.Value != 2)
{
condition.Append(" AND IsIgnore = @IsIgnore");
bool isIgnore = false;
if (filter.ReportState.Value == 1)
isIgnore = true;
else
isIgnore = false;
query.CreateParameter<bool>("@IsIgnore", isIgnore, SqlDbType.Bit);
}
if (filter.BeginDate != null)
{
condition.Append(" AND CreateDate >= @BeginDate");
query.CreateParameter<DateTime>("@BeginDate", filter.BeginDate.Value, SqlDbType.DateTime);
}
if (filter.EndDate != null)
{
condition.Append(" AND CreateDate <= @EndDate");
query.CreateParameter<DateTime>("@EndDate", filter.EndDate.Value, SqlDbType.DateTime);
}
if (condition.Length != 0)
condition = condition.Remove(0, 5);
query.Pager.Condition = condition.ToString();
}
public abstract DenouncingCollection GetDenouncingWithReply(DenouncingFilter filter, int pageNumber);
public abstract DenouncingCollection GetDenouncingBySearch(DenouncingFilter filter, int pageNumber);
protected void Page_Load(object sender, EventArgs e)
{
if (_Request.IsClick("btn_delete"))
{
string[] denouncingIDs = _Request.Get("denouncingIDs", Method.Post, string.Empty).Split(',');
if (denouncingIDs[0] != string.Empty)
{
int[] ids = ParseIntArray(denouncingIDs);
DenouncingBO.Instance.DeleteDenouncings(MyUserID, ids);
}
string filter = _Request.Get("filter");
if (filter != null)
{
BbsRouter.JumpToCurrentUrl(true, "filter=" + HttpUtility.UrlEncode(filter));
}
//BbsRouter.JumpToUrl(BbsRouter.GetCurrentUrlScheme().ToString(false, false), "filter=" + HttpUtility.UrlEncode(filter));
else
{
BbsRouter.JumpToCurrentUrl(true);
}
//BbsRouter.JumpToUrl(BbsRouter.GetCurrentUrlScheme().ToString(false, false), "");
}
else if (_Request.IsClick("btn_ignore"))
{
string[] denouncingIDs = _Request.Get("denouncingIDs", Method.Post, string.Empty).Split(',');
if (denouncingIDs[0] != string.Empty)
{
int[] ids = ParseIntArray(denouncingIDs);
DenouncingBO.Instance.DeleteDenouncings(MyUserID, ids);
//DenouncingBO.Instance.IgnoreDenouncings(MyUserID, ids);
}
string filter = _Request.Get("filter");
if (filter != null)
{
BbsRouter.JumpToCurrentUrl(true, "filter=" + HttpUtility.UrlEncode(filter));
}
//BbsRouter.JumpToUrl(BbsRouter.GetCurrentUrlScheme().ToString(false, false), "filter=" + HttpUtility.UrlEncode(filter));
else
{
BbsRouter.JumpToCurrentUrl(true);
}
//BbsRouter.JumpToUrl(BbsRouter.GetCurrentUrlScheme().ToString(false, false), "");
}
else if (_Request.IsClick("btn_deleteboth"))
{
string[] denouncingIDs = _Request.Get("denouncingIDs", Method.Post, string.Empty).Split(',');
if (denouncingIDs[0] != string.Empty)
{
int[] ids = ParseIntArray(denouncingIDs);
for (int i = 0; i < denouncingIDs.Length; i++)
{
DenouncingBO.Instance.DeleteDenouncingWithData(MyUserID, ids[i]);
}
}
string filter = _Request.Get("filter");
if (filter != null)
{
BbsRouter.JumpToCurrentUrl(true, "filter=" + HttpUtility.UrlEncode(filter));
}
else
{
BbsRouter.JumpToCurrentUrl(true);
}
}
else if (_Request.IsClick("searchreport"))
{
DenouncingFilter filter = DenouncingFilter.GetFromForm();
filter.Apply("filter", "page");
}
else if (_Request.Get("delete") != null)
{
int?denouncingID = _Request.Get <int>("delete");
if (denouncingID != null)
{
DenouncingBO.Instance.DeleteDenouncingWithData(MyUserID, denouncingID.Value);
string filter = _Request.Get("filter");
if (filter != null)
{
BbsRouter.JumpToCurrentUrl(true, "filter=" + HttpUtility.UrlEncode(filter));
}
else
{
BbsRouter.JumpToCurrentUrl(true);
}
}
}
else if (_Request.Get("delete2") != null)
{
int?denouncingID = _Request.Get <int>("delete2");
if (denouncingID != null)
{
DenouncingBO.Instance.DeleteDenouncings(MyUserID, new int[] { denouncingID.Value });
string filter = _Request.Get("filter");
if (filter != null)
{
BbsRouter.JumpToCurrentUrl(true, "filter=" + HttpUtility.UrlEncode(filter));
}
else
{
BbsRouter.JumpToCurrentUrl(true);
}
}
}
else if (_Request.Get("ignore") != null)
{
int?denouncingID = _Request.Get <int>("ignore");
if (denouncingID != null)
{
DenouncingBO.Instance.DeleteDenouncings(MyUserID, new int[] { denouncingID.Value });
//DenouncingBO.Instance.IgnoreDenouncing(MyUserID, denouncingID.Value);
string filter = _Request.Get("filter");
if (filter != null)
{
BbsRouter.JumpToCurrentUrl(true, "filter=" + HttpUtility.UrlEncode(filter));
}
else
{
BbsRouter.JumpToCurrentUrl(true);
}
}
}
m_Filter = DenouncingFilter.GetFromFilter("filter");
int page = _Request.Get <int>("page", 1);
string view = _Request.Get("view");
if (m_Filter.IsNull && view != null)
{
switch (view)
{
case "blog":
m_DenouncingList = DenouncingBO.Instance.GetDenouncingWithArticle(m_Filter, page);
break;
case "photo":
m_DenouncingList = DenouncingBO.Instance.GetDenouncingWithPhoto(m_Filter, page);
break;
case "share":
m_DenouncingList = DenouncingBO.Instance.GetDenouncingWithShare(m_Filter, page);
break;
case "user":
m_DenouncingList = DenouncingBO.Instance.GetDenouncingWithUser(m_Filter, page);
break;
case "topic":
m_DenouncingList = DenouncingBO.Instance.GetDenouncingWithTopic(m_Filter, page);
break;
case "reply":
m_DenouncingList = DenouncingBO.Instance.GetDenouncingWithReply(m_Filter, page);
break;
}
//ShowError("缺少必要的页面参数");
//return;
}
else
{
m_DenouncingList = DenouncingBO.Instance.GetDenouncingBySearch(m_Filter, page);
}
if (m_DenouncingList != null)
{
m_DenouncingTotalCount = m_DenouncingList.TotalRecords;
foreach (Denouncing denouncing in m_DenouncingList)
{
if (denouncing.Type == DenouncingType.Topic)
{
denouncing.TargetTopic = Threads.GetValue(denouncing.TargetID);
}
else if (denouncing.Type == DenouncingType.Reply)
{
denouncing.TargetReply = Posts.GetValue(denouncing.TargetID);
}
UserBO.Instance.WaitForFillSimpleUsers <DenouncingContent>(denouncing.ContentList);
}
UserBO.Instance.WaitForFillSimpleUsers <Denouncing>(m_DenouncingList);
}
}
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);
}
}
