public WebSiteBll()
{
bidPlacardDal = new BidPlacardDal();
newsDal = new NewsDal();
newsTypeDal = new Dal.NewsTypeDal();
webIntentionDal = new WebIntentionDal();
webUserDal = new WebUserDal();
bidDal = new BidDal();
organizationDal = new OrganizationDal();
}
/// <summary>
/// 搜索新闻
/// </summary>
/// <param name="title">标题</param>
/// <param name="status">是否发布</param>
/// <param name="type">新闻类型</param>
/// <returns></returns>
public static DataTable getNews(string title, int status, int type)
{
string sql = "select News.*,NewsType.TypeName from News,NewsType where News.Title like '%" + title + "%' and News.NewsTypeId=NewsType.NewsTypeId";
if (status != 2)
{
sql += " and News.IsShow=" + status;
}
if (type != 0)
{
sql += " and News.NewsTypeId=" + type;
}
sql += " order by CreateTime desc";
return(NewsDal.getNews(sql));
}
//查询最新的5条杂谈的新闻
public static DataTable zatanTop5()
{
return(NewsDal.zatanTop5());
}
//查询最新的5条乱斗的新闻
public static DataTable luandouTop5()
{
return(NewsDal.luandouTop5());
}
/// <summary>
/// 修改 置顶
/// </summary>
/// <param name="newsId"></param>
/// <param name="isTop">是否置顶</param>
/// <returns></returns>
public static int UpdateTop(int newsId, int isTop)
{
return(NewsDal.UpdateTop(newsId, isTop));
}
//修改新闻内容
public static int Updatenews(News news)
{
return(NewsDal.Updatenews(news));
}
//添加新闻
public static int Addnews(News news)
{
return(NewsDal.Addnews(news));
}
//根据id查询所阅读的新闻内容
public static SqlDataReader read(int newsid)
{
return(NewsDal.read(newsid));
}
/// <summary>
/// 删除新闻
/// </summary>
/// <param name="newsId"></param>
/// <returns></returns>
public static int DeleteNews(int newsId)
{
return(NewsDal.DeleteNews(newsId));
}
/// <summary>
/// 查询下一条新闻
/// </summary>
/// <param name="newsId"></param>
/// <param name="newsTypeId"></param>
/// <returns></returns>
public static List <News> GetNews_next(int newsId, int newsTypeId)
{
string sql = "select top 1 * from News where IsShow=1 and NewsId<" + newsId + " and NewsTypeId=" + newsTypeId + " order by NewsId desc";
return(NewsDal.GetNews(sql));
}
/// <summary>
/// 根据新闻类型查询（按置顶、时间排序）
/// </summary>
/// <param name="newsTypeId"></param>
/// <returns></returns>
public static DataTable getNewsbytypeId(int newsTypeId)
{
string sql = "select * from News where IsShow=1 and NewsTypeId=" + newsTypeId + " order by IsTop,CreateTime desc";
return(NewsDal.getNews(sql));
}
/// <summary>
/// 查询除置顶以外的其他新闻
/// </summary>
/// <returns></returns>
public static DataTable getNews_else(int newsId, int newsTypeId)
{
string sql = "select * from News where IsShow=1 and NewsTypeId=" + newsTypeId + " and NewsId<>" + newsId + " order by CreateTime desc";
return(NewsDal.getNews(sql));
}
/// <summary>
/// 查询首页显示的 新店开张资讯
/// </summary>
/// <returns></returns>
public static List <News> GetIndexNews_Brand(string typeName)
{
string sql = "select top 6 * from News where IndexShow=1 and IsShow=1 and NewsTypeId=(select NewsTypeId from NewsType where TypeName='" + typeName + "') order by CreateTime desc";
return(NewsDal.GetNews(sql));
}
/// <summary>
/// 查询首页显示的6条新闻
/// </summary>
/// <returns></returns>
public static List <News> GetIndexNews(string typeName)
{
string sql = "select top 6 * from News where IndexShow=1 and IsShow=1 order by CreateTime desc";
return(NewsDal.GetNews(sql));
}
/// <summary>
/// 修改 首页显示
/// </summary>
/// <param name="newsId"></param>
/// <param name="indexShow">首页显示</param>
/// <returns></returns>
public static int UpdateIndex(int newsId, int indexShow)
{
return(NewsDal.UpdateIndex(newsId, indexShow));
}
//查询最新的5条版本更新的新闻
public static DataTable banbenTop5()
{
return(NewsDal.banbenTop5());
}
//查询最新的5条卡组更新的新闻
public static DataTable kazuTop5()
{
return(NewsDal.kazuTop5());
}
/// <summary>
/// 查询所有的新闻（datatable）
/// </summary>
/// <returns></returns>
public static DataTable getAllNews()
{
string sql = "select News.*,NewsType.TypeName from News,NewsType where News.NewsTypeId=NewsType.NewsTypeId order by CreateTime desc";
return(NewsDal.getNews(sql));
}
//查询所有新闻
public static DataTable all()
{
return(NewsDal.all());
}
/// <summary>
/// 查询新闻
/// </summary>
/// <param name="newsId">新闻ID</param>
/// <returns></returns>
public static List <News> GetNewsbyId(int newsId)
{
string sql = "select * from News where NewsId=" + newsId;
return(NewsDal.GetNews(sql));
}
//根据id删除所阅读的新闻内容
public static int delete(int newsid)
{
return(NewsDal.delete(newsid));
}
/// <summary>
/// 修改新闻状态
/// </summary>
/// <param name="newsId"></param>
/// <param name="isShow">是否显示</param>
/// <returns></returns>
public static int UpdateStatus(int newsId, int isShow)
{
return(NewsDal.UpdateStatus(newsId, isShow));
}
public UnitOfWork(ApplicationDbContext _dbContext)
{
this.dbContext = _dbContext;
_newsDal = new NewsDal(dbContext);
_categoryDal = new CategoryDal(dbContext);
}
public NewsBl()
{
this.dal = new NewsDal();
}
