/// <summary> /// 根据公告类型、同业中心ID获取指定条数公告 /// </summary> /// <param name="top">指定条数</param> /// <param name="typ">公告类型</param> /// <param name="clusterId">同业中心ID</param> /// <returns>公告信息列表实体</returns> public IList <EyouSoft.Model.MQStructure.IMSuperClusterNews> GetSuperClusterNews(int top, EyouSoft.Model.MQStructure.Type typ, int clusterId) { // 公告信息实体列表 IList <EyouSoft.Model.MQStructure.IMSuperClusterNews> lst = new List <EyouSoft.Model.MQStructure.IMSuperClusterNews>(); // SQL编辑器 var strSql = new StringBuilder(); strSql.Append(" SELECT TOP(@TOP)"); strSql.Append(" ID"); // 公告ID strSql.Append(" ,Title"); // 标题 strSql.Append(" FROM"); strSql.Append(" tbl_SuperClusterNews"); strSql.Append(" WHERE"); strSql.AppendFormat(" (SELECT i.items FROM dbo.fn_Split(Centres ,',') AS i WHERE i.items = '{0}') > 0 AND Category = {1}", clusterId, (int)typ); strSql.Append(" ORDER BY"); strSql.Append(" Num ASC,OperateTime DESC"); DbCommand cmd = this._database.GetSqlStringCommand(strSql.ToString()); // SQL执行 this._database.AddInParameter(cmd, "@TOP", DbType.Int32, top); // 公告ID using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._database)) { while (dr.Read()) { var model = new EyouSoft.Model.MQStructure.IMSuperClusterNews { // 公告ID Id = dr.GetInt32(dr.GetOrdinal("ID")), // 标题 Title = dr.GetString(dr.GetOrdinal("Title")), }; // 公告信息实体 lst.Add(model); } } // 返回公告信息实体 return(lst); }
/// <summary> /// 根据公告类型、同业中心ID获取指定条数公告 /// </summary> /// <param name="top">指定条数</param> /// <param name="typ">公告类型</param> /// <param name="clusterId">同业中心ID</param> /// <returns>公告信息列表实体</returns> public IList <EyouSoft.Model.MQStructure.IMSuperClusterNews> GetSuperClusterNews(int top, EyouSoft.Model.MQStructure.Type typ, int clusterId) { if (top != 0 && clusterId != 0) { return(this.dal.GetSuperClusterNews(top, typ, clusterId)); } else { return(null); } }
/// <summary> /// 根据同业中心ID获取公告信息列表 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="recordCount">总记录数</param> /// <param name="centerId">同业中心ID</param> /// <param name="type">公告类型</param> /// <returns>公告信息列表</returns> public IList <Model.MQStructure.IMSuperClusterNews> GetList(int pageSize, int pageIndex, ref int recordCount, int centerId, EyouSoft.Model.MQStructure.Type type) { // 公告信息实体列表 IList <EyouSoft.Model.MQStructure.IMSuperClusterNews> lst = new List <EyouSoft.Model.MQStructure.IMSuperClusterNews>(); using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount , "tbl_SuperClusterNews", "ID", "ID,Category,Num,Title,Centres,NewsContent,Operater,OperateTime" , centerId != 0 ? string.Format("(SELECT COUNT(i.items) FROM dbo.fn_Split(Centres ,',') AS i WHERE i.items = '{0}') > 0 AND Category = {1}", centerId, (int)type) : string.Format("Category = {0}", (int)type) , "Num ASC,OperateTime DESC")) { while (dr.Read()) { // 公告信息实体 var model = new EyouSoft.Model.MQStructure.IMSuperClusterNews { // 公告ID Id = dr.GetInt32(dr.GetOrdinal("ID")), // 公告类型 Category = (Model.MQStructure.Type)dr.GetByte(dr.GetOrdinal("Category")), // 序号 Num = dr.GetInt32(dr.GetOrdinal("Num")), // 标题 Title = dr.GetString(dr.GetOrdinal("Title")), // 【,】隔开同业中心ID Centres = dr.IsDBNull(dr.GetOrdinal("Centres")) ? string.Empty : dr.GetString(dr.GetOrdinal("Centres")), // 正文 NewsContent = dr.GetString(dr.GetOrdinal("NewsContent")), // 发布人 Operater = dr.GetString(dr.GetOrdinal("Operater")), // 发布时间 OperateTime = dr.GetDateTime(dr.GetOrdinal("OperateTime")) }; // 追加到信息列表实体 lst.Add(model); } } // 返回公告信息列表实体 return(lst); }
/// <summary> /// 根据同业中心ID获取公告信息列表 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="recordCount">总记录数</param> /// <param name="centerId">同业中心ID</param> /// <param name="type">公告类型</param> /// <returns>公告信息列表</returns> public IList <Model.MQStructure.IMSuperClusterNews> GetList(int pageSize, int pageIndex, ref int recordCount, int centerId, EyouSoft.Model.MQStructure.Type type) { return(this.dal.GetList(pageSize, pageIndex, ref recordCount, centerId, type)); }