public IList<Core.Business.SpaceCommentExtend> GetAllSpaceCommentExtend() { IList<Core.Business.SpaceCommentExtend> spaceCommentExtendlist = new List<Core.Business.SpaceCommentExtend>(); SqlServerUtility sql = new SqlServerUtility(connectionString); SqlDataReader reader = sql.ExecuteSPReader("USP_SpaceCommentExtend_SelectAll"); if(reader != null) { while(reader.Read()) { Core.Business.SpaceCommentExtend spaceCommentExtend = new Core.Business.SpaceCommentExtend(); if (!reader.IsDBNull(0)) spaceCommentExtend.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) spaceCommentExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) spaceCommentExtend.InstanceId = reader.GetString(2); if (!reader.IsDBNull(3)) spaceCommentExtend.Type = reader.GetString(3); spaceCommentExtend.MarkOld(); spaceCommentExtendlist.Add(spaceCommentExtend); } reader.Close(); } return spaceCommentExtendlist; }
public IList<CY.UME.Core.Business.SpaceCommentExtend> GetSpaceCommentExtendByInstanceIdAndType(string type, string instanceId, CY.UME.Core.PagingInfo pageInfo) { List<SpaceCommentExtend> comments = new List<SpaceCommentExtend>(); StringBuilder sbFilter = new StringBuilder(); sbFilter.Append("1=1"); if (type.Length > 0) { sbFilter.Append(" And [Type] = '"); sbFilter.Append(type); sbFilter.Append("'"); } if (instanceId.Length > 0) { sbFilter.Append(" And [InstanceId] = '"); sbFilter.Append(instanceId); sbFilter.Append("'"); } int pageSize = int.MaxValue; int pageNumber = 1; if (pageInfo != null) { pageSize = pageInfo.PageSize; pageNumber = pageInfo.CurrentPage; } SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Tables", SqlDbType.VarChar, "SpaceCommentExtend"); sql.AddParameter("@PK", SqlDbType.VarChar, "Id"); sql.AddParameter("@Fields", SqlDbType.VarChar, "[Id]"); sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString()); sql.AddParameter("@PageNumber", SqlDbType.Int, pageNumber); sql.AddParameter("@PageSize", SqlDbType.Int, pageSize); sql.AddParameter("@Sort", SqlDbType.VarChar, "Id desc"); SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount"); if (reader != null) { while (reader.Read()) { Core.Business.SpaceCommentExtend spaceCommentExtend = new Core.Business.SpaceCommentExtend(); long id = reader.GetInt64(0); spaceCommentExtend = Core.Business.SpaceCommentExtend.Load(id); spaceCommentExtend.MarkOld(); comments.Add(spaceCommentExtend); } reader.Close(); } return comments; }
public Core.Business.SpaceCommentExtend Select(Int64 id) { SqlServerUtility sql = new SqlServerUtility(connectionString); sql.AddParameter("@Id", SqlDbType.BigInt, id); SqlDataReader reader = sql.ExecuteSPReader("USP_SpaceCommentExtend_Select_By_Id"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.SpaceCommentExtend spaceCommentExtend = new Core.Business.SpaceCommentExtend(); if (!reader.IsDBNull(0)) spaceCommentExtend.Id = reader.GetInt64(0); if (!reader.IsDBNull(1)) spaceCommentExtend.AccountId = reader.GetInt64(1); if (!reader.IsDBNull(2)) spaceCommentExtend.InstanceId = reader.GetString(2); if (!reader.IsDBNull(3)) spaceCommentExtend.Type = reader.GetString(3); reader.Close(); return spaceCommentExtend; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }