//修改
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            if (txtTitle.Text.Trim().Length == 0 || this.Textarea1.Value.Trim().Length == 0)
            {
                Javascript.GoHistory(-1, "标题和内容不能为空,请输入!", Page);
            }
            else
            {
                DalOperationAboutEnglishExam dalOperationAboutEnglishExam = new DalOperationAboutEnglishExam();
                EnglishExamNotify notify = new EnglishExamNotify();
                notify.englishExamNotifyId = englishExamNotifyInfoId;

                notify.englishExamNotifyTitle = txtTitle.Text.Trim();
                notify.englishExamNotifyContent = this.Textarea1.Value.Trim();
                notify.attachmentIds = hidAttachmentId.Value;
                notify.deadLineTime = Convert.ToDateTime(datepicker.Value);
                notify.updateTime = DateTime.Now;
                notify.locale = ddlLocale.SelectedValue;

                try
                {

                    dalOperationAboutEnglishExam.UpdateEnglishExamNotifyById(notify);//修改
                    Javascript.RefreshParentWindow("修改成功!", "/Administrator/EnglishExamManage.aspx?page="+pageIndex, Page);
                }
                catch (Exception ex)
                {
                    MongoDBLog.LogRecord(ex);
                    Javascript.GoHistory(-1, "修改失败,请检查格式是否有误!", Page);
                }

            }
        }
        /// <summary>
        /// 发布四六级通知
        /// </summary>
        /// <returns></returns>
        public int AddEnglishExamNotify(EnglishExamNotify englishExamNotify)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into usta_EnglishExamNotify(");
            strSql.Append("englishExamNotifyTitle,englishExamNotifyContent,attachmentIds,deadLineTime,locale)");
            strSql.Append(" values (");
            strSql.Append("@englishExamNotifyTitle,@englishExamNotifyContent,@attachmentIds,@deadLineTime,@locale);");
            SqlParameter[] parameters = {
                    new SqlParameter("@englishExamNotifyTitle", SqlDbType.NChar,50),
                    new SqlParameter("@englishExamNotifyContent", SqlDbType.NText),
                    new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
                    new SqlParameter("@deadLineTime", SqlDbType.DateTime),
                    new SqlParameter("@locale", SqlDbType.NVarChar,20)};
            parameters[0].Value = englishExamNotify.englishExamNotifyTitle;
            parameters[1].Value = englishExamNotify.englishExamNotifyContent;
            parameters[2].Value = englishExamNotify.attachmentIds;
            parameters[3].Value = englishExamNotify.deadLineTime;
            parameters[4].Value = englishExamNotify.locale;

            return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
        }
        /// <summary>
        /// 根据Id修改四六级通知
        /// </summary>
        /// <returns></returns>
        public int UpdateEnglishExamNotifyById(EnglishExamNotify englishExamNotify)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update usta_EnglishExamNotify set ");
            strSql.Append("englishExamNotifyTitle=@englishExamNotifyTitle,");
            strSql.Append("englishExamNotifyContent=@englishExamNotifyContent,");
            strSql.Append("attachmentIds=@attachmentIds,");
            strSql.Append("deadLineTime=@deadLineTime,");
            strSql.Append("locale=@locale");
            strSql.Append(" where englishExamNotifyId=@englishExamNotifyId");
            SqlParameter[] parameters = {
                    new SqlParameter("@englishExamNotifyTitle", SqlDbType.NChar,50),
                    new SqlParameter("@englishExamNotifyContent", SqlDbType.NText),
                    new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
                    new SqlParameter("@updateTime", SqlDbType.DateTime),
                    new SqlParameter("@deadLineTime", SqlDbType.DateTime),
                    new SqlParameter("@englishExamNotifyId", SqlDbType.Int,4),
                    new SqlParameter("@locale", SqlDbType.NVarChar,20)};
            parameters[0].Value = englishExamNotify.englishExamNotifyTitle;
            parameters[1].Value = englishExamNotify.englishExamNotifyContent;
            parameters[2].Value = englishExamNotify.attachmentIds;
            parameters[3].Value = englishExamNotify.updateTime;
            parameters[4].Value = englishExamNotify.deadLineTime;
            parameters[5].Value = englishExamNotify.englishExamNotifyId;
            parameters[6].Value = englishExamNotify.locale;

            return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
        }
        /// <summary>
        /// 获取指定Id的四六级通知数据
        /// </summary>
        /// <returns></returns>
        public EnglishExamNotify GetEnglishExamNotifyById(int englishExamNotifyId)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 englishExamNotifyId,englishExamNotifyTitle,englishExamNotifyContent,deadLineTime,attachmentIds,updateTime,locale from usta_EnglishExamNotify ");
            strSql.Append(" where englishExamNotifyId=@englishExamNotifyId");
            SqlParameter[] parameters = {
                    new SqlParameter("@englishExamNotifyId", SqlDbType.Int,4)
            };
            parameters[0].Value = englishExamNotifyId;

            EnglishExamNotify model = new EnglishExamNotify();
            DataSet ds = SqlHelper.ExecuteDataset(conn, CommandType.Text, strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["englishExamNotifyId"] != null && ds.Tables[0].Rows[0]["englishExamNotifyId"].ToString().Trim() != "")
                {
                    model.englishExamNotifyId = int.Parse(ds.Tables[0].Rows[0]["englishExamNotifyId"].ToString().Trim());
                }
                if (ds.Tables[0].Rows[0]["englishExamNotifyTitle"] != null && ds.Tables[0].Rows[0]["englishExamNotifyTitle"].ToString().Trim() != "")
                {
                    model.englishExamNotifyTitle = ds.Tables[0].Rows[0]["englishExamNotifyTitle"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["englishExamNotifyContent"] != null && ds.Tables[0].Rows[0]["englishExamNotifyContent"].ToString().Trim() != "")
                {
                    model.englishExamNotifyContent = ds.Tables[0].Rows[0]["englishExamNotifyContent"].ToString().Trim();
                }
                model.attachmentIds = ds.Tables[0].Rows[0]["attachmentIds"].ToString();
                if (ds.Tables[0].Rows[0]["updateTime"] != null && ds.Tables[0].Rows[0]["updateTime"].ToString().Trim() != "")
                {
                    model.updateTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["updateTime"].ToString().Trim());
                }
                if (ds.Tables[0].Rows[0]["deadLineTime"] != null && ds.Tables[0].Rows[0]["deadLineTime"].ToString().Trim() != "")
                {
                    model.deadLineTime = Convert.ToDateTime(ds.Tables[0].Rows[0]["deadLineTime"].ToString().Trim());
                }

                model.locale = string.Empty;

                if (ds.Tables[0].Rows[0]["locale"] != null && ds.Tables[0].Rows[0]["locale"].ToString().Trim() != "")
                {
                    model.locale = ds.Tables[0].Rows[0]["locale"].ToString().Trim();
                }
                return model;
            }
            else
            {
                return null;
            }
        }
        //第1个标签:结束
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            if (txtTitle.Text.Trim().Length == 0 || Textarea1.Value.Trim().Length == 0)
            {
                Javascript.GoHistory(-1, "标题和内容不能为空,请输入!", Page);
                Javascript.ExcuteJavascriptCode("delBeforeUnloadEvent();", Page);
            }
            else
            {
                DalOperationAboutEnglishExam dalOperationAboutEnglishExam = new DalOperationAboutEnglishExam();
                EnglishExamNotify englishExamNotify = new EnglishExamNotify();
                englishExamNotify.englishExamNotifyTitle = txtTitle.Text.Trim();
                englishExamNotify.englishExamNotifyContent = Textarea1.Value.Trim();
                englishExamNotify.deadLineTime = Convert.ToDateTime(datepicker.Value.Trim());
                englishExamNotify.locale = ddlLocale.SelectedValue;

                //以下提交附件的判断与相关操作
                if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
                {
                    englishExamNotify.attachmentIds = hidAttachmentId.Value;//保存了附件并且返回了attachmentId(自增长类型主键)
                }

                try
                {
                    dalOperationAboutEnglishExam.AddEnglishExamNotify(englishExamNotify);//保存通知
                    Javascript.ExcuteJavascriptCode("delBeforeUnloadEvent();", Page);
                    Javascript.AlertAndRedirect("添加成功!", "/Administrator/EnglishExamManage.aspx?fragment=1", Page);
                }
                catch (Exception ex)
                {
                    MongoDBLog.LogRecord(ex);
                    Javascript.ExcuteJavascriptCode("delBeforeUnloadEvent();", Page);
                    Javascript.GoHistory(-1, "添加失败,请检查格式是否有误!", Page);
                }

            }
        }