public IList<Core.Business.Tag> GetAllTag() { IList<Core.Business.Tag> taglist = new List<Core.Business.Tag>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectTagsAll"); if (reader != null) { while (reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); tag.MarkOld(); taglist.Add(tag); } reader.Close(); } return taglist; }
public Tag GetTag(Guid contentId) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ContentId", SqlDbType.UniqueIdentifier, contentId); SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetTag); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); reader.Close(); tag.MarkOld(); return tag; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public Tag SelectTagsDynamic(string sqlwhere, string ordersql) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, sqlwhere); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, ordersql); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectTagsDynamic"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); tag.MarkOld(); reader.Close(); return tag; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IEnumerable<Tag> SelectTags(int tagType) { try { IList<Core.Business.Tag> taglist = new List<Core.Business.Tag>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@type", SqlDbType.Int, tagType); SqlDataReader reader = sql.ExecuteSqlReader(Sql_SelectTags); if (reader != null) { while (reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); tag.MarkOld(); taglist.Add(tag); } reader.Close(); } return taglist; } catch (Exception ex) { throw ex; } }
public List<Tag> SelectTagDynamic(string whereCondition, string orderExpression) { string Sql_TagsWhere = "Select * from [Tag] where "; if (string.IsNullOrEmpty(whereCondition)) { return GetAllTag().ToList(); } IList<Core.Business.Tag> taglist = new List<Core.Business.Tag>(); SqlServerUtility sql = new SqlServerUtility(); Sql_TagsWhere += whereCondition; if (!string.IsNullOrEmpty(orderExpression)) { ;//sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderExpression); } SqlDataReader reader = sql.ExecuteSqlReader(Sql_TagsWhere); if (reader != null) { while (reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); tag.MarkOld(); taglist.Add(tag); } reader.Close(); } return taglist.ToList(); }
public Core.Business.Tag Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ID", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectTag"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); reader.Close(); return tag; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IEnumerable<Tag> SearchTags(string name, int tagType) { if (string.IsNullOrEmpty(name)) { return this.GetAllTag(); } if (tagType == default(int)) { tagType = CY.Utility.Common.CodeInterface.TagType.Equip.Type; } IList<Core.Business.Tag> taglist = new List<Core.Business.Tag>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@type", SqlDbType.Int, tagType); SqlDataReader reader = sql.ExecuteSqlReader(string.Format(Sql_SearchTags, name)); if (reader != null && !reader.IsClosed) { while (reader.Read()) { Core.Business.Tag tag = new Core.Business.Tag(); if (!reader.IsDBNull(0)) tag.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) tag.ContentID = reader.GetGuid(1); if (!reader.IsDBNull(2)) tag.ContentType = reader.GetInt32(2); if (!reader.IsDBNull(3)) tag.TagName = reader.GetString(3); tag.MarkOld(); taglist.Add(tag); } reader.Close(); } return taglist; }