/// <summary> /// 运营后台分页获取列表 /// </summary> /// <param name="siteId">分站ID >0时返回该分站下的下广告 =0时返回全部</param> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码数</param> /// <param name="recordeCount">总记录数</param> /// <returns></returns> public virtual IList <EyouSoft.Model.SystemStructure.SysIndexAdv> GetList(int siteId, int pageSize, int pageIndex, ref int recordeCount) { IList <EyouSoft.Model.SystemStructure.SysIndexAdv> list = new List <EyouSoft.Model.SystemStructure.SysIndexAdv>(); string tableName = "tbl_SysIndexAdv"; string fields = "ID,SiteId,ImgPath,LinkAdress,ImgRemark,SortId,IssueTime"; string primaryKey = "ID"; string orderByString = " SortId DESC,IssueTime DESC "; string strWhere = string.Empty; if (siteId > 0) { strWhere = string.Format("siteid={0}", siteId); } using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordeCount, tableName, primaryKey, fields, strWhere, orderByString)) { while (dr.Read()) { EyouSoft.Model.SystemStructure.SysIndexAdv model = new EyouSoft.Model.SystemStructure.SysIndexAdv(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.SiteId = dr.GetInt32(dr.GetOrdinal("SiteId")); model.SortId = dr.GetInt32(dr.GetOrdinal("SortId")); model.ImgPath = dr.GetString(dr.GetOrdinal("ImgPath")); model.LinkAdress = dr.GetString(dr.GetOrdinal("LinkAdress")); model.ImgRemark = dr.GetString(dr.GetOrdinal("ImgRemark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); list.Add(model); model = null; } } return(list); }
/// <summary> /// 修改 /// </summary> /// <param name="model">首页广告实体</param> /// <returns>false:失败 true:成功</returns> public bool Update(EyouSoft.Model.SystemStructure.SysIndexAdv model) { if (model == null) { return(false); } return(dal.Update(model)); }
/// <summary> /// 添加 /// </summary> /// <returns>false:失败 true:成功</returns> public virtual bool Add(EyouSoft.Model.SystemStructure.SysIndexAdv model) { DbCommand dc = this._database.GetSqlStringCommand(SQL_SysIndexAdv_ADD); this._database.AddInParameter(dc, "AdvType", DbType.Int16, model.AdvType); this._database.AddInParameter(dc, "SiteId", DbType.Int32, model.SiteId); this._database.AddInParameter(dc, "ImgPath", DbType.String, model.ImgPath); this._database.AddInParameter(dc, "LinkAdress", DbType.String, model.LinkAdress); this._database.AddInParameter(dc, "ImgRemark", DbType.String, model.ImgRemark); return(DbHelper.ExecuteSql(dc, this._database) > 0?true:false); }
/// <summary> /// 获取指定条数的前台轮换广告列表 /// </summary> /// <param name="siteId">分站ID >0时返回该分站下的轮换广告信息 =0时返回全部</param> /// <param name="topnumber">指定返回条数 >0时返回指定条数记录 =0返回全部</param> /// <returns></returns> public virtual IList <EyouSoft.Model.SystemStructure.SysIndexAdv> GetTopList(int siteId, int topnumber) { IList <EyouSoft.Model.SystemStructure.SysIndexAdv> list = new List <EyouSoft.Model.SystemStructure.SysIndexAdv>(); EyouSoft.Model.SystemStructure.SysIndexAdv model = null; #region 格式化查询语句 StringBuilder strSql = new StringBuilder(); if (topnumber > 0) { strSql.AppendFormat(SQL_SysIndexAdv_SELECTTOPINFO, string.Format("top {0} ", topnumber)); } else { strSql.AppendFormat(SQL_SysIndexAdv_SELECTTOPINFO, string.Empty); } if (siteId > 0) { strSql.AppendFormat(" where SiteId={0}", siteId); } strSql.Append(" order by sortId desc,issuetime desc"); #endregion DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { while (dr.Read()) { model = new EyouSoft.Model.SystemStructure.SysIndexAdv(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.AdvType = dr.GetInt32(dr.GetOrdinal("AdvType")); model.ImgPath = dr.GetString(dr.GetOrdinal("ImgPath")); model.LinkAdress = dr.GetString(dr.GetOrdinal("LinkAdress")); model.ImgRemark = dr.GetString(dr.GetOrdinal("ImgRemark")); list.Add(model); model = null; } } return(list); }
/// <summary> /// 获取轮换广告实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public virtual EyouSoft.Model.SystemStructure.SysIndexAdv GetModel(int id) { EyouSoft.Model.SystemStructure.SysIndexAdv model = null; DbCommand dc = this._database.GetSqlStringCommand(SQL_SysIndexAdv_GETMODEL); this._database.AddInParameter(dc, "ID", DbType.Int32, id); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._database)) { if (dr.Read()) { model = new EyouSoft.Model.SystemStructure.SysIndexAdv(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.AdvType = dr.GetInt16(dr.GetOrdinal("AdvType")); model.SiteId = dr.GetInt32(dr.GetOrdinal("SiteId")); model.SortId = dr.GetInt32(dr.GetOrdinal("SortId")); model.ImgPath = dr.GetString(dr.GetOrdinal("ImgPath")); model.LinkAdress = dr.GetString(dr.GetOrdinal("LinkAdress")); model.ImgRemark = dr.GetString(dr.GetOrdinal("ImgRemark")); } } return(model); }