/// <summary> /// 获取所有资讯类别列表 /// </summary> /// <param name="Category"></param> /// <returns></returns> public virtual IList <EyouSoft.Model.NewsStructure.NewsType> GetList(EyouSoft.Model.NewsStructure.NewsCategory?Category) { IList <EyouSoft.Model.NewsStructure.NewsType> list = new List <EyouSoft.Model.NewsStructure.NewsType>(); StringBuilder strSql = new StringBuilder(SQL_NewsType_GetAll); if (Category.HasValue) { strSql.AppendFormat(" and Category={0} ", (int)Category.Value); } DbCommand dc = this._db.GetSqlStringCommand(strSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { while (dr.Read()) { EyouSoft.Model.NewsStructure.NewsType model = new EyouSoft.Model.NewsStructure.NewsType(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.ClassName = dr.IsDBNull(dr.GetOrdinal("ClassName")) ? string.Empty : dr[dr.GetOrdinal("ClassName")].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("Category"))) { model.Category = (EyouSoft.Model.NewsStructure.NewsCategory) int.Parse(dr[dr.GetOrdinal("Category")].ToString()); } model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.IsSystem = dr[dr.GetOrdinal("IsSystem")].ToString() == "1" ? true : false; list.Add(model); model = null; } } return(list); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns>true:成功 false:失败</returns> public bool Update(EyouSoft.Model.NewsStructure.NewsType model) { if (model == null) { return(false); } return(dal.Update(model)); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns>true:成功 false:失败</returns> public virtual bool Update(EyouSoft.Model.NewsStructure.NewsType model) { DbCommand dc = this._db.GetSqlStringCommand(SQL_NewsType_Update); this._db.AddInParameter(dc, "ClassName", DbType.String, model.ClassName); this._db.AddInParameter(dc, "OperatorId", DbType.Int32, model.OperatorId); this._db.AddInParameter(dc, "Id", DbType.Int32, model.Id); return(DbHelper.ExecuteSql(dc, this._db) > 0 ? true : false); }
/// <summary> /// 添加/编辑同业学堂类别 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSchoolAdd_Click(object sender, EventArgs e) { string cateName = txtSchoolName.Text.Replace(" ", ""); try { bool result = false; newsTypeModel = new EyouSoft.Model.NewsStructure.NewsType() { ClassName = cateName, Category = EyouSoft.Model.NewsStructure.NewsCategory.业学堂, OperatorId = base.MasterUserInfo.ID }; if (btnSchoolAdd.CommandName.Equals("Add")) //添加操作 { if (newsTypeBLL.SchoolExists(cateName, 0)) //检测类别是否存在 { MessageBox.Show(this, "该同业学堂类别已经存在,请重新输入!!!"); return; } result = newsTypeBLL.Add(newsTypeModel); } else if (btnSchoolAdd.CommandName.Equals("Edit")) { int ID; result = int.TryParse(Request.QueryString["id"], out ID); if (result) { if (newsTypeBLL.SchoolExists(cateName, ID)) //检测类别是否存在 { MessageBox.Show(this, "该同业学堂类别已经存在,请重新输入!!!"); return; } newsTypeModel.Id = ID; result = newsTypeBLL.Update(newsTypeModel); } } if (result) { MessageBox.ShowAndRedirect(this, "同业学堂类别操作成功", "Category.aspx"); } else { MessageBox.Show(this, "操作失败"); } } catch (Exception) { MessageBox.Show(this, "操作失败"); } }
//初始化页面信息 public void Initialize() { //获取热点资讯排行 EyouSoft.IBLL.NewsStructure.INewsBll bll_News = EyouSoft.BLL.NewsStructure.NewsBll.CreateInstance(); IList <EyouSoft.Model.NewsStructure.WebSiteNews> HotList = bll_News.GetHotNews(10); StringBuilder strHot = new StringBuilder(); if (HotList != null && HotList.Count > 0) { foreach (EyouSoft.Model.NewsStructure.WebSiteNews item in HotList) { if (item.GotoUrl.Length > 0) {//含有跳转的 strHot.AppendFormat("<li><a href='{0}' title='{3}' target=\"_blank\" style='{2}'>{1}</a></li>", item.GotoUrl, EyouSoft.Common.Utils.GetText2(item.AfficheTitle, 16, true), "color:" + item.TitleColor, item.AfficheTitle); } else {//不含跳转 strHot.AppendFormat("<li><a href='{0}' title='{3}' target=\"_blank\" style='{2}'>{1}</a></li>", EyouSoft.Common.URLREWRITE.Infomation.GetNewsDetailUrl(item.AfficheClass, item.Id), EyouSoft.Common.Utils.GetText2(item.AfficheTitle, 16, true), "color:" + item.TitleColor, item.AfficheTitle); } } } else { strHot.Append("<li>暂无资讯排行信息</li>"); } HotLists = strHot.ToString(); //获取资讯信息类别 EyouSoft.IBLL.NewsStructure.INewsType BLL_NewsType = EyouSoft.BLL.NewsStructure.NewsType.CreateInstance(); IList <EyouSoft.Model.NewsStructure.NewsType> InfoTypeList = BLL_NewsType.GetInformationType(); EyouSoft.Model.NewsStructure.NewsType only = InfoTypeList.Where(p => p.ClassName == "行业新闻").FirstOrDefault(); //获取最新行业新闻 IList <EyouSoft.Model.NewsStructure.WebSiteNews> Trades = bll_News.GetListByNewType(6, only.Id); this.news.DataSource = Trades; this.news.DataBind(); bll_News = null; //获取供求信息 EyouSoft.IBLL.CommunityStructure.IExchangeList Bchange = EyouSoft.BLL.CommunityStructure.ExchangeList.CreateInstance(); IList <EyouSoft.Model.CommunityStructure.ExchangeList> excList = Bchange.GetTopList(6); this.star.DataSource = excList; this.DataBind(); //获取最新线路 EyouSoft.IBLL.NewTourStructure.IRoute Btour = EyouSoft.BLL.NewTourStructure.BRoute.CreateInstance(); IList <EyouSoft.Model.NewTourStructure.MRoute> TourList = Btour.GetNewRouteList(6); StringBuilder NewRoute = new StringBuilder(); if (TourList != null) { foreach (EyouSoft.Model.NewTourStructure.MRoute item in TourList) { NewRoute.Append(string.Format("<li><a title='{0}' target='_blank' href='{1}'>{2}</a></li>", item.RouteName, EyouSoft.Common.URLREWRITE.Tour.GetTourToUrl(item.Id, CityId), Utils.GetText2(item.RouteName, 16, true))); } } RouteList = NewRoute.ToString(); Btour = null; //获取旅游企业 EyouSoft.IBLL.CompanyStructure.ICompanyInfo Bcompany = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance(); IList <EyouSoft.Model.CompanyStructure.MLatestRegCompanyInfo> ComList = Bcompany.GetTopNumNewCompanys(9, true); this.company.DataSource = ComList; this.company.DataBind(); Bcompany = null; }