public IList<Core.Business.MiniBlogExtend> GetAllMiniBlogExtend()
{
IList<Core.Business.MiniBlogExtend> miniBlogExtendlist = new List<Core.Business.MiniBlogExtend>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_MiniBlogExtend_SelectAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.MiniBlogExtend miniBlogExtend = new Core.Business.MiniBlogExtend();
long Id = 0;
if (!reader.IsDBNull(0)) Id = reader.GetInt64(0);
miniBlogExtend = CY.UME.Core.Business.MiniBlogExtend.Load(Id);
miniBlogExtend.MarkOld();
miniBlogExtendlist.Add(miniBlogExtend);
}
reader.Close();
}
return miniBlogExtendlist;
}
public IList<CY.UME.Core.Business.MiniBlogExtend> GetMiniBlogByPagesAndActId(string activityId, CY.UME.Core.PagingInfo pageInfo)
{
IList<Core.Business.MiniBlogExtend> miniBlogExtendlist = new List<Core.Business.MiniBlogExtend>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
#region ����
string tables = "MiniBlogExtend";
string pK = "Id";
string sort = "Id Desc";
int pageNum = pageInfo.CurrentPage;
int pageSize = pageInfo.PageSize;
string fields = "[Id], [AccountId],[ActivityId],[IsPhoneSended],[IsMsgReceived],[ReferedId],[ReferedName],[TransferedNum],[ImgPath],[ReferedAuthorId],[Video]";
string filter = "[ActivityId]='" + activityId + "'";
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.MiniBlogExtend miniBlogExtend = new Core.Business.MiniBlogExtend();
long Id = 0;
if (!reader.IsDBNull(0)) Id = reader.GetInt64(0);
miniBlogExtend = CY.UME.Core.Business.MiniBlogExtend.Load(Id);
miniBlogExtend.MarkOld();
miniBlogExtendlist.Add(miniBlogExtend);
}
reader.Close();
}
return miniBlogExtendlist;
}
public Core.Business.MiniBlogExtend Select(Int64 id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSPReader("USP_MiniBlogExtend_Select_By_Id");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.MiniBlogExtend miniBlogExtend = new Core.Business.MiniBlogExtend();
if (!reader.IsDBNull(0)) miniBlogExtend.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) miniBlogExtend.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) miniBlogExtend.ActivityId = reader.GetString(2);
if (!reader.IsDBNull(3)) miniBlogExtend.IsPhoneSended = reader.GetBoolean(3);
if (!reader.IsDBNull(4)) miniBlogExtend.IsMsgReceived = reader.GetBoolean(4);
if (!reader.IsDBNull(5)) miniBlogExtend.ReferedId = reader.GetInt64(5);
if (!reader.IsDBNull(6)) miniBlogExtend.ReferedName = reader.GetString(6);
if (!reader.IsDBNull(7)) miniBlogExtend.TransferedNum = reader.GetInt32(7);
if (!reader.IsDBNull(8)) miniBlogExtend.ImgPath = reader.GetString(8);
if (!reader.IsDBNull(9)) miniBlogExtend.ReferedAuthorId = reader.GetInt64(9);
if (!reader.IsDBNull(10)) miniBlogExtend.Video = reader.GetString(10);
reader.Close();
return miniBlogExtend;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
