public IList<Core.Business.MiniBlog> GetAllMiniBlog()
{
IList<Core.Business.MiniBlog> miniBloglist = new List<Core.Business.MiniBlog>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_MiniBlog_Select_All");
if (reader != null)
{
while (reader.Read())
{
Core.Business.MiniBlog miniBlog = new Core.Business.MiniBlog();
if (!reader.IsDBNull(0)) miniBlog.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) miniBlog.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) miniBlog.IP = reader.GetString(2);
if (!reader.IsDBNull(3)) miniBlog.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) miniBlog.DatePublish = reader.GetDateTime(4);
miniBlog.MarkOld();
miniBloglist.Add(miniBlog);
}
reader.Close();
}
return miniBloglist;
}
// ��һ��ʹ��
public IList<CY.UME.Core.Business.MiniBlog> GetAllMiniBlogsById(string accountIds, string Id, string Contents, string BeginTime, string EndTime, Core.PagingInfo pageInfo)
{
IList<Core.Business.MiniBlog> miniBlogList = new List<Core.Business.MiniBlog>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
#region ����
string tables = "MiniBlog";
string pK = "Id";
string sort = "Id Desc";
int pageNum = pageInfo.CurrentPage - 1;
int pageSize = pageInfo.PageSize;
string fields = "[Id], [AccountId],[IP],[Content],[DatePublish]";
string filter = "1=1";
StringBuilder strFilter = new StringBuilder();
// �û�ID
if (accountIds.Length >= 1)
{
strFilter.Append(" AND [AccountId] IN (" + accountIds + ") ");
}
if (Contents.Length >= 1)
{
strFilter.Append(" AND [Content] LIKE '%" + Contents + "%' ");
}
if (Id != "" && Id.Length >= 1)
{
strFilter.Append(" AND [Id] in (" + Id + ")");
}
if (BeginTime.Length >= 1 && EndTime.Length >= 1)
{
strFilter.Append(" AND [DatePublish] BETWEEN '" + BeginTime + "' AND '" + EndTime + "' ");
}
filter += strFilter.ToString();
string group = String.Empty;
#endregion
sql.AddParameter("@Tables", SqlDbType.VarChar, tables);
sql.AddParameter("@PK", SqlDbType.VarChar, pK);
sql.AddParameter("@Sort", SqlDbType.VarChar, sort);
sql.AddParameter("@PageNumber", SqlDbType.Int, pageNum);
sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);
sql.AddParameter("@Fields", SqlDbType.VarChar, fields);
sql.AddParameter("@Filter", SqlDbType.VarChar, filter);
sql.AddParameter("@Group", SqlDbType.VarChar, group);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.MiniBlog miniBlog = new Core.Business.MiniBlog();
if (!reader.IsDBNull(0)) miniBlog.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) miniBlog.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) miniBlog.IP = reader.GetString(2);
if (!reader.IsDBNull(3)) miniBlog.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) miniBlog.DatePublish = reader.GetDateTime(4);
miniBlog.MarkOld();
miniBlogList.Add(miniBlog);
}
reader.Close();
}
return miniBlogList;
}
public Core.Business.MiniBlog Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSPReader("USP_MiniBlog_Select_By_Id");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.MiniBlog miniBlog = new Core.Business.MiniBlog();
if (!reader.IsDBNull(0)) miniBlog.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) miniBlog.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) miniBlog.IP = reader.GetString(2);
if (!reader.IsDBNull(3)) miniBlog.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) miniBlog.DatePublish = reader.GetDateTime(4);
reader.Close();
return miniBlog;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<CY.UME.Core.Business.MiniBlog> GetTopMiniBlogByAccountId(long accountId, int num)
{
IList<Core.Business.MiniBlog> miniBloglist = new List<Core.Business.MiniBlog>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@AccountId", SqlDbType.BigInt, accountId);
sql.AddParameter("@Num", SqlDbType.BigInt, num);
SqlDataReader reader = sql.ExecuteSPReader("USP_MiniBlog_Select_Top_By_AccountId");
if (reader != null)
{
while (reader.Read())
{
Core.Business.MiniBlog miniBlog = new Core.Business.MiniBlog();
if (!reader.IsDBNull(0)) miniBlog.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) miniBlog.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) miniBlog.IP = reader.GetString(2);
if (!reader.IsDBNull(3)) miniBlog.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) miniBlog.DatePublish = reader.GetDateTime(4);
miniBlog.MarkOld();
miniBloglist.Add(miniBlog);
}
reader.Close();
}
return miniBloglist;
}
public IList<CY.UME.Core.Business.MiniBlog> GetMiniBlogByAccountIdAndPages(long accountId, CY.UME.Core.PagingInfo pageInfo)
{
IList<Core.Business.MiniBlog> miniBlogList = new List<Core.Business.MiniBlog>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
#region ����
string tables = "MiniBlog";
string pK = "Id";
string sort = "Id Desc";
int pageNum = pageInfo.CurrentPage;
int pageSize = pageInfo.PageSize;
string fields = "[Id], [AccountId],[IP],[Content],[DatePublish]";
string filter = "1=1";
StringBuilder strFilter = new StringBuilder();
if (accountId != 0)
{
strFilter.Append(" and [AccountId] =" + accountId.ToString());
}
filter += strFilter.ToString();
string group = String.Empty;
#endregion
sql.AddParameter("@Tables", SqlDbType.VarChar, tables);
sql.AddParameter("@PK", SqlDbType.VarChar, pK);
sql.AddParameter("@Sort", SqlDbType.VarChar, sort);
sql.AddParameter("@PageNumber", SqlDbType.Int, pageNum);
sql.AddParameter("@PageSize", SqlDbType.Int, pageSize);
sql.AddParameter("@Fields", SqlDbType.VarChar, fields);
sql.AddParameter("@Filter", SqlDbType.VarChar, filter);
sql.AddParameter("@Group", SqlDbType.VarChar, group);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.MiniBlog miniBlog = new Core.Business.MiniBlog();
if (!reader.IsDBNull(0)) miniBlog.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) miniBlog.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) miniBlog.IP = reader.GetString(2);
if (!reader.IsDBNull(3)) miniBlog.Content = reader.GetString(3);
if (!reader.IsDBNull(4)) miniBlog.DatePublish = reader.GetDateTime(4);
miniBlog.MarkOld();
miniBlogList.Add(miniBlog);
}
reader.Close();
}
return miniBlogList;
}
