예제 #1
0
        protected override void ShowPage()
        {
            announceinfo = Announcements.GetAnnouncement(announceid);

            if (announceinfo == null)
            {
                AddErrLine("无该公告信息!");
                return;
            }

            pagetitle = announceinfo.Title;
            UpdateMetaInfo(announceinfo.Title, config.Seodescription + Utils.CutString(Utils.RemoveHtml(announceinfo.Message), 0, 60), "");

            AddLinkCss(rooturl + "templates/" + templatepath + "/css/channels.css");

            string loadscript = "\r\n " + "jQuery(document).ready(function() {";
            if (templateid == 1)
            {
                loadscript += "\r\n " + "jQuery(\"input[type=text],textarea\").each(function(){";
                loadscript += "\r\n " + "  jQuery(this).blur(function(){jQuery(this).attr(\"class\",\"input5_soout\");});";
                loadscript += "\r\n " + "  jQuery(this).focus(function(){jQuery(this).attr(\"class\",\"input5_soon\");});";
                loadscript += "\r\n " + "});";
            }
            loadscript += "\r\n " + "});\r\n";
            AddfootScript(loadscript);

            activelist = Activities.GetActivityByIds(announceinfo.Relateactive);

            if (activelist.Length > 0)
            {
                curactiveid = TypeConverter.ObjectToInt(activelist[0]["id"], 0);
                curactivetitle = activelist[0]["atitle"].ToString();
            }
        }
        private void UpdateAnnounceInfo_Click(object sender, EventArgs e)
        {
            #region 更新公告相关信息

            if (this.CheckCookie())
            {
                AnnouncementInfo announcementInfo = new AnnouncementInfo();
                announcementInfo.Id = SASRequest.GetInt("id", 0);
                announcementInfo.Poster = poster.Text.Trim();
                announcementInfo.Title = title.Text.Trim();
                announcementInfo.Displayorder = TypeConverter.StrToInt(displayorder.Text);
                announcementInfo.Starttime = Convert.ToDateTime(starttime.Text);
                announcementInfo.Endtime = Convert.ToDateTime(endtime.Text);
                announcementInfo.Message = message.Text.Trim();
                announcementInfo.Relateactive = SASRequest.GetString("TargetFID");
                Announcements.UpdateAnnouncement(announcementInfo);
                //移除公告缓存
                SAS.Cache.SASCache.GetCacheService().RemoveObject("/SAS/AnnouncementList");
                SAS.Cache.SASCache.GetCacheService().RemoveObject("/SAS/SimplifiedAnnouncementList");

                //记录日志
                AdminVistLogs.InsertLog(this.userid, this.username, this.usergroupid, this.grouptitle, this.ip, "更新公告", "更新公告,标题为:" + title.Text);
                base.RegisterStartupScript("PAGE", "window.location.href='global_announcegrid.aspx';");
            }
            #endregion
        }
예제 #3
0
        /// <summary>
        /// 添加公告
        /// </summary>
        /// <param name="username">用户名</param>
        /// <param name="userId">用户id</param>
        /// <param name="subject">公告主题</param>
        /// <param name="displayOrder">排序序号</param>
        /// <param name="startDateTime">起始时间</param>
        /// <param name="endDateTime">结束时间</param>
        /// <param name="message">公告内容</param>
        /// <param name="relateactive">相关活动</param>
        public static void CreateAnnouncement(string username, int userid, string subject, int displayorder, string starttime, string endtime, string message, string relateactive)
        {
            AnnouncementInfo announcementInfo = new AnnouncementInfo();
            announcementInfo.Title = subject;
            announcementInfo.Poster = username;
            announcementInfo.Posterid = userid;
            announcementInfo.Displayorder = displayorder;
            DateTime dt;
            DateTime.TryParse(starttime, out dt);
            announcementInfo.Starttime = dt;
            DateTime.TryParse(endtime, out dt);
            announcementInfo.Endtime = dt;
            announcementInfo.Message = message;
            announcementInfo.Relateactive = relateactive;

            Data.DataProvider.Announcements.CreateAnnouncement(announcementInfo);
        }
예제 #4
0
 /// <summary>
 /// 更新公告
 /// </summary>
 /// <param name="aId">公告id</param>
 /// <param name="username">用户名</param>
 /// <param name="subject">公告主题</param>
 /// <param name="displayOrder">排序序号</param>
 /// <param name="startDateTime">起始时间</param>
 /// <param name="endDateTime">结束时间</param>
 /// <param name="message">公告内容</param>
 public static void UpdateAnnouncement(AnnouncementInfo announcementInfo)
 {
     if (announcementInfo.Id > 0)
         Data.DataProvider.Announcements.UpdateAnnouncement(announcementInfo);
 }
예제 #5
0
 /// <summary>
 /// 添加公告
 /// </summary>
 /// <param name="announcementInfo">公告对象</param>
 public int CreateAnnouncement(AnnouncementInfo announcementInfo)
 {
     DbParameter[] parms = {
                                 DbHelper.MakeInParam("@poster", (DbType)SqlDbType.NVarChar, 20, announcementInfo.Poster),
                                 DbHelper.MakeInParam("@posterid", (DbType)SqlDbType.Int, 4, announcementInfo.Posterid),
                                 DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 250, announcementInfo.Title),
                                 DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4, announcementInfo.Displayorder),
                                 DbHelper.MakeInParam("@starttime", (DbType)SqlDbType.DateTime, 8, announcementInfo.Starttime),
                                 DbHelper.MakeInParam("@endtime", (DbType)SqlDbType.DateTime, 8, announcementInfo.Endtime),
                                 DbHelper.MakeInParam("@message", (DbType)SqlDbType.NText, 0, announcementInfo.Message),
                                 DbHelper.MakeInParam("@relateactive",(DbType)SqlDbType.VarChar,2000,announcementInfo.Relateactive)
                             };
     string commandText = string.Format("INSERT INTO [{0}announcements] ([poster],[posterid],[title],[displayorder],[starttime],[endtime],[message],[relateactive]) VALUES(@poster, @posterid, @title, @displayorder, @starttime, @endtime, @message,@relateactive)", BaseConfigs.GetTablePrefix);
     return DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
 }
예제 #6
0
 /// <summary>
 /// 更新通告
 /// </summary>
 public int UpdateAnnouncement(AnnouncementInfo announcementInfo)
 {
     DbParameter[] parms = {
                                 DbHelper.MakeInParam("@id", (DbType)SqlDbType.Int, 4, announcementInfo.Id),
                                 DbHelper.MakeInParam("@poster", (DbType)SqlDbType.NVarChar, 20, announcementInfo.Poster),
                                 DbHelper.MakeInParam("@title", (DbType)SqlDbType.NVarChar, 250, announcementInfo.Title),
                                 DbHelper.MakeInParam("@displayorder", (DbType)SqlDbType.Int, 4, announcementInfo.Displayorder),
                                 DbHelper.MakeInParam("@starttime", (DbType)SqlDbType.DateTime, 8, announcementInfo.Starttime),
                                 DbHelper.MakeInParam("@endtime", (DbType)SqlDbType.DateTime, 8, announcementInfo.Endtime),
                                 DbHelper.MakeInParam("@message", (DbType)SqlDbType.NText, 0, announcementInfo.Message),
                                 DbHelper.MakeInParam("@relateactive",(DbType)SqlDbType.VarChar,2000,announcementInfo.Relateactive)
                             };
     string commandText = string.Format("UPDATE [{0}announcements] SET [displayorder]=@displayorder,[title]=@title, [poster]=@poster,[starttime]=@starttime,[endtime]=@endtime,[message]=@message,[relateactive]=@relateactive WHERE [id]=@id",
                                         BaseConfigs.GetTablePrefix);
     return DbHelper.ExecuteNonQuery(CommandType.Text, commandText, parms);
 }
예제 #7
0
 /// <summary>
 /// 添加公告
 /// </summary>
 /// <param name="announcementInfo">公告对象</param>
 public static void CreateAnnouncement(AnnouncementInfo announcementInfo)
 {
     DatabaseProvider.GetInstance().CreateAnnouncement(announcementInfo);
 }
예제 #8
0
 /// <summary>
 /// 装载实体对象
 /// </summary>
 /// <param name="reader"></param>
 /// <returns></returns>
 private static AnnouncementInfo LoadSingleAnnouncementInfo(IDataReader reader)
 {
     AnnouncementInfo announcementInfo = new AnnouncementInfo();
     announcementInfo.Id = TypeConverter.ObjectToInt(reader["id"]);
     announcementInfo.Poster = reader["poster"].ToString();
     announcementInfo.Posterid = TypeConverter.ObjectToInt(reader["posterid"]);
     announcementInfo.Title = reader["title"].ToString();
     announcementInfo.Displayorder = TypeConverter.ObjectToInt(reader["displayorder"]);
     announcementInfo.Starttime = Convert.ToDateTime(reader["starttime"].ToString());
     announcementInfo.Endtime = Convert.ToDateTime(reader["endtime"].ToString());
     announcementInfo.Message = reader["message"].ToString();
     announcementInfo.Relateactive = reader["relateactive"].ToString();
     return announcementInfo;
 }