public IList<Core.Business.TopicExtend> GetAllTopicExtend() { IList<Core.Business.TopicExtend> topicExtendlist = new List<Core.Business.TopicExtend>(); SqlServerUtility sql = new SqlServerUtility(connectionString); SqlDataReader reader = sql.ExecuteSPReader("USP_TopicExtend_SelectAll"); if(reader != null) { while(reader.Read()) { Core.Business.TopicExtend topicExtend = new Core.Business.TopicExtend(); if (!reader.IsDBNull(0)) topicExtend.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) topicExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) topicExtend.InstanceId = reader.GetString(2); if (!reader.IsDBNull(3)) topicExtend.Type = reader.GetString(3); topicExtend.MarkOld(); topicExtendlist.Add(topicExtend); } reader.Close(); } return topicExtendlist; }
public int GetTopicesNumByInstanceAndType(string strType, string strInstanceId,int level) { int count = 0; SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Type", SqlDbType.NVarChar, strType); sql.AddParameter("@InstanceId", SqlDbType.NVarChar, strInstanceId); if (level != -1) { sql.AddParameter("@Level", SqlDbType.NVarChar, level); } SqlDataReader reader = sql.ExecuteSPReader("USP_TopicExtend_GetTopicCount_By_InstanceId_And_Type"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TopicExtend topicExtend = new Core.Business.TopicExtend(); if (!reader.IsDBNull(0)) count = reader.GetInt32(0); reader.Close(); return count; } else { if (reader != null && !reader.IsClosed) reader.Close(); return 0; } }
public Core.Business.TopicExtend Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("USP_TopicExtend_Select_By_Id"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.TopicExtend topicExtend = new Core.Business.TopicExtend(); if (!reader.IsDBNull(0)) topicExtend.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) topicExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) topicExtend.InstanceId = reader.GetString(2); if (!reader.IsDBNull(3)) topicExtend.Type = reader.GetString(3); reader.Close(); return topicExtend; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }