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