public IList<Core.Business.NewsContent> GetAllHotContent() { IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); string sqlstr = "SELECT TOP 10 * FROM [dbo].[NewsContent] WHERE ([Status]=2 or [Status]=5) ORDER BY [Traffic] DESC,[index] Desc,PublishTime Desc,SortTime Desc"; SqlDataReader reader = sql.ExecuteSqlReader(sqlstr); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; }
public IEnumerable<NewsContent> SelectNewsByStatusNModule(Guid moduleid, int status) { string strSql = "select * from NewsContent where Status=@status and ModuleID=@moduleid order by [index] Desc,PublishTime Desc,SortTime Desc"; IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@status", SqlDbType.Int, status); sql.AddParameter("@moduleid", SqlDbType.UniqueIdentifier, moduleid); SqlDataReader reader = sql.ExecuteSqlReader(strSql); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; }
public Core.Business.NewsContent Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@ID", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsContent"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); reader.Close(); return newsContent; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IEnumerable<NewsContent> SearchUnPaged(NewsSearchJson json) { try { if (json == null) { throw new ArgumentNullException("json for search is null "); } IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); if (!string.IsNullOrEmpty(json.Title)) { sql.AddParameter("@title", SqlDbType.NVarChar, json.Title); } if (json.PublishStartTime != null && json.PublishStartTime.Value > DateTime.MinValue) { sql.AddParameter("@publishstartdate", SqlDbType.DateTime, json.PublishStartTime.Value); } if (json.PublishEndTime != null && json.PublishEndTime.Value > DateTime.MinValue) { sql.AddParameter("@publishenddate", SqlDbType.DateTime, json.PublishEndTime.Value); } if (json.CheckStartTime != null && json.CheckStartTime.Value > DateTime.MinValue) { sql.AddParameter("@checkstartdate", SqlDbType.DateTime, json.CheckStartTime.Value); } if (json.CheckEndTime != null && json.CheckEndTime.Value > DateTime.MinValue) { sql.AddParameter("@checkenddate", SqlDbType.DateTime, json.CheckEndTime.Value); } if (!string.IsNullOrEmpty(json.Tag)) { sql.AddParameter("@tag", SqlDbType.NVarChar, json.Tag); } if (!string.IsNullOrEmpty(json.Source)) { sql.AddParameter("@source", SqlDbType.NVarChar, json.Source); } if (!string.IsNullOrEmpty(json.Author)) { sql.AddParameter("@author", SqlDbType.NVarChar, json.Author); } if (!string.IsNullOrEmpty(json.Checker)) { sql.AddParameter("@checker", SqlDbType.NVarChar, json.Checker); } if (json.StartTraffic != null && json.StartTraffic >= 0) { sql.AddParameter("@starttraffic", SqlDbType.Int, json.StartTraffic.Value); } if (json.EndTraffic != null && json.EndTraffic >= 0) { sql.AddParameter("@endtraffic", SqlDbType.Int, json.EndTraffic.Value); } if (json.Module != null && json.Module.Value != Guid.Empty) { sql.AddParameter("@moduleid", SqlDbType.UniqueIdentifier, json.Module.Value); } if (json.Unit != null && json.Unit.Value != Guid.Empty) { sql.AddParameter("@unit", SqlDbType.UniqueIdentifier, json.Unit.Value); } if (json.IsCenter != null) { sql.AddParameter("@center", SqlDbType.Int, json.IsCenter.Value); } SqlDataReader reader = sql.ExecuteSPReader("usp_SearchNewUpPaged"); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); if (!reader.IsDBNull(15)) newsContent.ModuleName = reader.GetString(15); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; } catch (Exception ex) { throw ex; } }
public IEnumerable<NewsContent> SearchNewest(Guid module, int size) { IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@module", SqlDbType.UniqueIdentifier, module); sql.AddParameter("@size", SqlDbType.Int, size); SqlDataReader reader = sql.ExecuteSqlReader(sql_newest); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; }
public IList<Core.Business.NewsContent> GetAllLawRepositoryByPage(string sqlwhere, int pagenumber, int pagesize) { IList<Core.Business.NewsContent> lawRepositorylist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); int lowband = (pagenumber - 1) * pagesize; int highband = pagenumber * pagesize + 1; sql.AddParameter("@lowband", SqlDbType.Int, lowband); sql.AddParameter("@highband", SqlDbType.Int, highband); SqlDataReader reader = sql.ExecuteSqlReader(string.Format(Sql_ContentPaged, sqlwhere)); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); lawRepositorylist.Add(newsContent); } reader.Close(); } return lawRepositorylist; //return lawRepositorylist.OrderBy(item => item.Index).Reverse().OrderBy(item => item.PublishTime).Reverse().OrderBy(item => item.SortTime).Reverse().ToList(); }
public IList<NewsContent> GetTopNewsContentDynamic(string topNCondition, string whereCondition, string orderByExpression) { if (string.IsNullOrEmpty(whereCondition)) { return this.GetAllNewsContent(); } IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@TopNCondition", SqlDbType.NVarChar, topNCondition); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, whereCondition); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderByExpression); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsContentsDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; }
public IList<NewsContent> GetSqlWhereASC(string sqlwhere) { IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); StringBuilder sbOrderExpression = new StringBuilder(); sbOrderExpression.Append(string.Format("[index] Desc,PublishTime ASC,SortTime Desc")); sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, sqlwhere); sql.AddParameter("@TopNCondition", SqlDbType.NVarChar, string.Empty); sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, sbOrderExpression.ToString()); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsContentsDynamic"); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; }
public NewsContent GetEnrollSingleTon(NewsModule moduleAdmission) { IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@moduleid", SqlDbType.UniqueIdentifier, moduleAdmission.Id); SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetEnrollSingleTon); Core.Business.NewsContent newsContent = null; if (reader != null && !reader.IsClosed && reader.Read()) { newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); if (!reader.IsDBNull(15)) newsContent.ImgUrl = reader.GetString(15); newsContent.MarkOld(); reader.Close(); } return newsContent; }
public IList<Core.Business.NewsContent> GetAllNewsContent() { IList<Core.Business.NewsContent> newsContentlist = new List<Core.Business.NewsContent>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectNewsContentsAll"); if (reader != null) { while (reader.Read()) { Core.Business.NewsContent newsContent = new Core.Business.NewsContent(); if (!reader.IsDBNull(0)) newsContent.Id = reader.GetGuid(0); if (!reader.IsDBNull(1)) newsContent.ModuleID = reader.GetGuid(1); if (!reader.IsDBNull(2)) newsContent.Title = reader.GetString(2); if (!reader.IsDBNull(3)) newsContent.Content = reader.GetString(3); if (!reader.IsDBNull(4)) newsContent.PublishTime = reader.GetDateTime(4); if (!reader.IsDBNull(5)) newsContent.Tag = reader.GetInt32(5); if (!reader.IsDBNull(6)) newsContent.Annex = reader.GetInt32(6); if (!reader.IsDBNull(7)) newsContent.Status = reader.GetInt32(7); if (!reader.IsDBNull(8)) newsContent.Source = reader.GetString(8); if (!reader.IsDBNull(9)) newsContent.Author = reader.GetString(9); if (!reader.IsDBNull(10)) newsContent.Checker = reader.GetString(10); if (!reader.IsDBNull(11)) newsContent.CheckTime = reader.GetDateTime(11); if (!reader.IsDBNull(12)) newsContent.Index = reader.GetInt32(12); if (!reader.IsDBNull(13)) newsContent.Traffic = reader.GetInt64(13); if (!reader.IsDBNull(14)) newsContent.SortTime = reader.GetDateTime(14); newsContent.MarkOld(); newsContentlist.Add(newsContent); } reader.Close(); } return newsContentlist; }