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;
}
