/// <summary>
/// 修改公告信息
/// </summary>
/// <param name="model">公告信息实体</param>
/// <returns>True：成功 False：失败</returns>
public bool Upd(EyouSoft.Model.MQStructure.IMSuperClusterNews model)
{
var strSql = new StringBuilder(); // SQL编辑器
strSql.Append(" UPDATE");
strSql.Append(" tbl_SuperClusterNews");
strSql.Append(" SET");
strSql.Append(" Category = @Category"); // 公告类型
strSql.Append(" ,Num = @Num"); // 序号
strSql.Append(" ,Title = @Title"); // 标题
strSql.Append(" ,Centres = STUFF((SELECT ',' + A.items FROM (SELECT i.items FROM dbo.fn_Split(@Centres ,',') AS i WHERE i.items IN (SELECT id FROM tbl_SuperCluster)) AS A FOR XML PATH('')) , 1 , 1 , '')"); // 同业中心ID
strSql.Append(" ,NewsContent = @NewsContent"); // 正文
strSql.Append(" ,Operater = @Operater"); // 发布人
strSql.Append(" ,OperateTime = @OperateTime"); // 发布时间
strSql.Append(" ,IssueTime = GETDATE()");
strSql.Append(" WHERE");
strSql.Append(" ID = @ID"); // 公告ID
DbCommand dc = this._database.GetSqlStringCommand(strSql.ToString());
this._database.AddInParameter(dc, "ID", DbType.Int32, model.Id);
this._database.AddInParameter(dc, "Category", DbType.Byte, (int)model.Category);
this._database.AddInParameter(dc, "Num", DbType.Int32, model.Num);
this._database.AddInParameter(dc, "Title", DbType.String, model.Title);
this._database.AddInParameter(dc, "Centres", DbType.String, model.Centres);
this._database.AddInParameter(dc, "NewsContent", DbType.String, model.NewsContent);
this._database.AddInParameter(dc, "Operater", DbType.String, model.Operater);
this._database.AddInParameter(dc, "OperateTime", DbType.DateTime, model.OperateTime);
return(DbHelper.ExecuteSql(dc, this._database) > 0 ? true : false);
}
//批量设置序号
protected void btnSave_Click(object sender, EventArgs e)
{
IList <EyouSoft.Model.MQStructure.IMSuperClusterNews> list = new List <EyouSoft.Model.MQStructure.IMSuperClusterNews>();
EyouSoft.Model.MQStructure.IMSuperClusterNews model = null;
for (int i = 0; i < Utils.GetFormValues("chkId").Length; i++)
{
for (int j = 0; j < Utils.GetFormValues("sort").Length; j++)
{
if (Utils.GetInt(Utils.GetFormValues("chkId")[i]) == Utils.GetInt(Utils.GetFormValues("hidid")[j]))
{
model = new EyouSoft.Model.MQStructure.IMSuperClusterNews()
{
Num = Utils.GetInt(Utils.GetFormValues("sort")[j]),
Id = Utils.GetInt(Utils.GetFormValues("chkId")[i])
};
list.Add(model);
break;
}
}
}
if (list.Count > 0)
{
EyouSoft.BLL.MQStructure.IMSuperClusterNews.CreateInstance().SetNums(list);
}
Bind();
}
/// <summary>
/// 根据公告ID获取公告信息
/// </summary>
/// <param name="id">公告ID</param>
/// <returns>公告信息实体</returns>
public EyouSoft.Model.MQStructure.IMSuperClusterNews GetModel(int id)
{
var model = new EyouSoft.Model.MQStructure.IMSuperClusterNews(); // 公告信息实体
var strSql = new StringBuilder(); // SQL编辑器
strSql.Append(" SELECT");
strSql.Append(" Category"); // 公告类型
strSql.Append(" ,Num"); // 序号
strSql.Append(" ,Title"); // 标题
strSql.Append(" ,Centres"); // 同业中心ID
strSql.Append(" ,NewsContent"); // 正文
strSql.Append(" ,Operater"); // 发布人
strSql.Append(" ,OperateTime"); // 发布时间
strSql.Append(" FROM");
strSql.Append(" tbl_SuperClusterNews");
strSql.Append(" WHERE");
strSql.Append(" ID = @ID");
DbCommand cmd = this._database.GetSqlStringCommand(strSql.ToString()); // SQL执行
this._database.AddInParameter(cmd, "@ID", DbType.Int32, id); // 公告ID
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._database))
{
while (dr.Read())
{
// 公告类型
model.Category = (Model.MQStructure.Type)dr.GetByte(dr.GetOrdinal("Category"));
// 序号
model.Num = dr.GetInt32(dr.GetOrdinal("Num"));
// 标题
model.Title = dr.GetString(dr.GetOrdinal("Title"));
// 【，】隔开同业中心ID
model.Centres = dr.GetString(dr.GetOrdinal("Centres"));
// 正文
model.NewsContent = dr.GetString(dr.GetOrdinal("NewsContent"));
// 发布人
model.Operater = dr.GetString(dr.GetOrdinal("Operater"));
// 发布时间
model.OperateTime = dr.GetDateTime(dr.GetOrdinal("OperateTime"));
}
}
// 返回公告信息实体
return(model);
}
/// <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);
}
protected void Page_Load(object sender, EventArgs e)
{
int ID = EyouSoft.Common.Utils.GetInt(EyouSoft.Common.Utils.GetQueryStringValue("ID"));
if (!ID.Equals(0))
{
EyouSoft.Model.MQStructure.IMSuperClusterNews model = EyouSoft.BLL.MQStructure.IMSuperClusterNews.CreateInstance().GetModel(ID);
if (model != null)
{
Class = model.Category.ToString();
this.Page.Title = Class;
lblTitle.Text = model.Title;
lblDate.Text = model.OperateTime.ToString();
content.InnerHtml = model.NewsContent;
}
}
}
/// <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);
}
private void Bind()
{
BindNoticeTo();
int id = Utils.GetInt(Utils.GetQueryStringValue("id"));
if (id != 0)
{
EyouSoft.Model.MQStructure.IMSuperClusterNews model = EyouSoft.BLL.MQStructure.IMSuperClusterNews.CreateInstance().GetModel(id);
if (model != null)
{
//标题
txtTitle.Text = model.Title;
//公告对象
foreach (var item in model.Centres.Split(','))
{
if (item != "")
{
chkNoticeList.Items.FindByValue(item).Selected = true;
}
}
//序号
txtSort.Value = model.Num.ToString();
//公告正文
FCK_PlanTicketContent.Value = model.NewsContent;
//修改时间
txtDate.Text = model.OperateTime.ToString();
//发布人就是当前操作人???
txtOper.Text = MasterUserInfo.ContactName;
}
}
else
{
//修改时间
txtDate.Text = DateTime.Now.ToString();
//发布人就是当前操作人???
txtOper.Text = MasterUserInfo.ContactName;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
//公告编号
int id = Utils.GetInt(Utils.GetQueryStringValue("id"));
//类型(公告0,广播1)
string NoticeClass = Utils.GetQueryStringValue("NoticeClass");
//公告对象
string TongyeCenterID = string.Empty;
EyouSoft.Model.MQStructure.IMSuperClusterNews model = new EyouSoft.Model.MQStructure.IMSuperClusterNews();
if (NoticeClass == "0")
{
model.Category = EyouSoft.Model.MQStructure.Type.公告;
}
else if (NoticeClass == "1")
{
model.Category = EyouSoft.Model.MQStructure.Type.广播;
}
foreach (ListItem item in chkNoticeList.Items)
{
if (item.Selected)
{
TongyeCenterID += item.Value + ",";
}
}
if (string.IsNullOrEmpty(TongyeCenterID))
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "alert('请选择公告对象!')");
return;
}
else
{
TongyeCenterID = TongyeCenterID.Trim(',');
}
if (string.IsNullOrEmpty(FCK_PlanTicketContent.Value))
{
EyouSoft.Common.Function.MessageBox.ResponseScript(this, "alert('请输入正文!')");
return;
}
model.Num = Utils.GetInt(txtSort.Value);
model.Centres = TongyeCenterID;
model.NewsContent = FCK_PlanTicketContent.Value;
model.Operater = MasterUserInfo.ContactName;
model.Title = txtTitle.Text;
model.OperateTime = Utils.GetDateTime(txtDate.Text, DateTime.Now);
if (id == 0)
{
if (EyouSoft.BLL.MQStructure.IMSuperClusterNews.CreateInstance().Add(model))
{
Utils.ShowAndRedirect("添加成功", "TongyeNotice.aspx?NoticeClass=" + NoticeClass);
}
else
{
Utils.ShowAndRedirect("添加失败", "TongyeNotice.aspx?NoticeClass=" + NoticeClass);
}
}
else
{
model.Id = id;
if (EyouSoft.BLL.MQStructure.IMSuperClusterNews.CreateInstance().Upd(model))
{
Utils.ShowAndRedirect("修改成功", "TongyeNotice.aspx?NoticeClass=" + NoticeClass);
}
else
{
Utils.ShowAndRedirect("修改成功", "TongyeNotice.aspx?NoticeClass=" + NoticeClass);
}
}
}
