/// <summary>
/// ��ȡ���ظ��б�
/// </summary>
/// <param name="active"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<TopicReply> GetActiveTopicReplyList(Activities active, PagingInfo pageInfo)
{
List<Core.Business.TopicReply> topicReplylist = new List<Core.Business.TopicReply>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
string sorts = String.Empty;
string filter = String.Empty;
string fields = String.Empty;
if (active == null)
{
return topicReplylist;
}
sorts = "DateCreated desc";
filter = "[InstanceId] in (select [Id] from TopicExtend where InstanceId='" +active.Id + "' and [Type]='active')";
fields = "[Id],[DateCreated],[InstanceId],[AccountId],[AuthorId],[ReferedId],[Content],[IP]";
sql.AddParameter("@PageNumber", SqlDbType.Int, pageInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pageInfo.PageSize);
sql.AddParameter("@Tables", SqlDbType.NVarChar, "TopicReply");
sql.AddParameter("@PK", SqlDbType.NVarChar, "Id");
sql.AddParameter("@Sort", SqlDbType.NVarChar, sorts);
sql.AddParameter("@Fields", SqlDbType.NVarChar, fields);
sql.AddParameter("@Filter", SqlDbType.NVarChar, filter);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.TopicReply topicReply = new Core.Business.TopicReply();
if (!reader.IsDBNull(0)) topicReply.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) topicReply.DateCreated = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) topicReply.InstanceId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) topicReply.AccountId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) topicReply.AuthorId = reader.GetInt64(4);
if (!reader.IsDBNull(5)) topicReply.ReferedId = reader.GetInt64(5);
if (!reader.IsDBNull(6)) topicReply.Content = reader.GetString(6);
if (!reader.IsDBNull(7)) topicReply.IP = reader.GetString(7);
topicReply.MarkOld();
topicReplylist.Add(topicReply);
}
reader.Close();
}
return topicReplylist;
}
public IList<Core.Business.TopicReply> GetAllTopicReply()
{
IList<Core.Business.TopicReply> topicReplylist = new List<Core.Business.TopicReply>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_TopicReply_SelectAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.TopicReply topicReply = new Core.Business.TopicReply();
if (!reader.IsDBNull(0)) topicReply.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) topicReply.DateCreated = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) topicReply.InstanceId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) topicReply.AccountId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) topicReply.AuthorId = reader.GetInt64(4);
if (!reader.IsDBNull(5)) topicReply.ReferedId = reader.GetInt64(5);
if (!reader.IsDBNull(6)) topicReply.Content = reader.GetString(6);
if (!reader.IsDBNull(7)) topicReply.IP = reader.GetString(7);
topicReply.MarkOld();
topicReplylist.Add(topicReply);
}
reader.Close();
}
return topicReplylist;
}
public Core.Business.TopicReply Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSPReader("USP_TopicReply_Select_By_Id");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.TopicReply topicReply = new Core.Business.TopicReply();
if (!reader.IsDBNull(0)) topicReply.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) topicReply.DateCreated = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) topicReply.InstanceId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) topicReply.AccountId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) topicReply.AuthorId = reader.GetInt64(4);
if (!reader.IsDBNull(5)) topicReply.ReferedId = reader.GetInt64(5);
if (!reader.IsDBNull(6)) topicReply.Content = reader.GetString(6);
if (!reader.IsDBNull(7)) topicReply.IP = reader.GetString(7);
reader.Close();
return topicReply;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public List<TopicReply> SearchTopicReply(Activities active, string con, string title, string authorName, DateTime minDate, DateTime maxDate, PagingInfo pageInfo)
{
List<Core.Business.TopicReply> topicReplylist = new List<Core.Business.TopicReply>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
string sorts = String.Empty;
string filter = String.Empty;
string fields = String.Empty;
filter += "1=1";
if (active != null)
{
filter += " and [InstanceId] in (select [Id] from TopicExtend where InstanceId='" +active.Id+ "' and [Type]='active')";
}
if (con.Length > 0)
{
filter += " and [Content] like '%" + con + "%'";
}
if (title.Length > 0)
{
filter += " and [InstanceId] in (select [Id] from [Topic] where [Title] like '%" + title + "%')";
}
if (authorName.Length > 0)
{
filter += " and [AuthorId] in (select [Id] from [Account] where [Name] like '%" + authorName + "%')";
}
filter += " and [DateCreated] between '" + minDate.ToString() + "' and '" + maxDate.ToString() + "'";
sorts = "DateCreated desc";
fields = "[Id],[DateCreated],[InstanceId],[AccountId],[AuthorId],[ReferedId],[Content],[IP]";
sql.AddParameter("@PageNumber", SqlDbType.Int, pageInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pageInfo.PageSize);
sql.AddParameter("@Tables", SqlDbType.NVarChar, "TopicReply");
sql.AddParameter("@PK", SqlDbType.NVarChar, "Id");
sql.AddParameter("@Sort", SqlDbType.NVarChar, sorts);
sql.AddParameter("@Fields", SqlDbType.NVarChar, fields);
sql.AddParameter("@Filter", SqlDbType.NVarChar, filter);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.TopicReply topicReply = new Core.Business.TopicReply();
if (!reader.IsDBNull(0)) topicReply.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) topicReply.DateCreated = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) topicReply.InstanceId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) topicReply.AccountId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) topicReply.AuthorId = reader.GetInt64(4);
if (!reader.IsDBNull(5)) topicReply.ReferedId = reader.GetInt64(5);
if (!reader.IsDBNull(6)) topicReply.Content = reader.GetString(6);
if (!reader.IsDBNull(7)) topicReply.IP = reader.GetString(7);
topicReply.MarkOld();
topicReplylist.Add(topicReply);
}
reader.Close();
}
return topicReplylist;
}
public IList<CY.UME.Core.Business.TopicReply> GetReplyByTopicIdAndPagesDESC(Guid topicId, PagingInfo pageInfo)
{
IList<Core.Business.TopicReply> topicReplylist = new List<Core.Business.TopicReply>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
string sorts = String.Empty;
string filter = String.Empty;
string fields = String.Empty;
sorts = "Id";
filter = "Id IN(SELECT TOP (" + pageInfo.PageSize + ") [Id] FROM [TopicReply] WHERE [InstanceId] = '" + topicId.ToString() + "' ORDER BY [DateCreated])";
fields = "[Id],[DateCreated],[InstanceId],[AccountId],[AuthorId],[ReferedId],[Content],[IP]";
sql.AddParameter("@PageNumber", SqlDbType.Int, pageInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pageInfo.PageSize);
sql.AddParameter("@Tables", SqlDbType.NVarChar, "TopicReply");
sql.AddParameter("@PK", SqlDbType.NVarChar, "Id");
sql.AddParameter("@Sort", SqlDbType.NVarChar, sorts);
sql.AddParameter("@Fields", SqlDbType.NVarChar, fields);
sql.AddParameter("@Filter", SqlDbType.NVarChar, filter);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.TopicReply topicReply = new Core.Business.TopicReply();
if (!reader.IsDBNull(0)) topicReply.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) topicReply.DateCreated = reader.GetDateTime(1);
if (!reader.IsDBNull(2)) topicReply.InstanceId = reader.GetGuid(2);
if (!reader.IsDBNull(3)) topicReply.AccountId = reader.GetInt64(3);
if (!reader.IsDBNull(4)) topicReply.AuthorId = reader.GetInt64(4);
if (!reader.IsDBNull(5)) topicReply.ReferedId = reader.GetInt64(5);
if (!reader.IsDBNull(6)) topicReply.Content = reader.GetString(6);
if (!reader.IsDBNull(7)) topicReply.IP = reader.GetString(7);
topicReply.MarkOld();
topicReplylist.Add(topicReply);
}
reader.Close();
}
return topicReplylist;
}