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