/// <summary>
        /// 根据Id修改四六级报名相关状态信息
        /// </summary>
        /// <param name="studentNo"></param>
        /// <param name="examPlace"></param>
        /// <param name="examType"></param>
        /// <param name="englishExamId"></param>
        /// <returns></returns>
        public int UpdateEnglishExamSignUpState(EnglishExam model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update usta_EnglishExam set ");
            strSql.Append("examCertificateState=@examCertificateState,");
            strSql.Append("examCertificateRemark=@examCertificateRemark,");
            strSql.Append("isPaid=@isPaid,");
            strSql.Append("isPaidRemark=@isPaidRemark,");
            strSql.Append("grade=@grade,");
            strSql.Append("gradeCertificateState=@gradeCertificateState,");
            strSql.Append("gradeCertificateRemark=@gradeCertificateRemark ");
            strSql.Append(" where englishExamId=@englishExamId");
            strSql.Append(" AND studentNo=@studentNo");
            strSql.Append(" AND englishExamNotifyId=@englishExamNotifyId;");
            SqlParameter[] parameters = {
                    new SqlParameter("@examCertificateState", SqlDbType.NChar,10),
                    new SqlParameter("@examCertificateRemark", SqlDbType.NChar,100),
                    new SqlParameter("@isPaid", SqlDbType.TinyInt,1),
                    new SqlParameter("@isPaidRemark", SqlDbType.NVarChar,100),
                    new SqlParameter("@grade", SqlDbType.NChar,10),
                    new SqlParameter("@gradeCertificateState", SqlDbType.NChar,10),
                    new SqlParameter("@gradeCertificateRemark", SqlDbType.NVarChar,100),
                    new SqlParameter("@englishExamId", SqlDbType.Int,4),
                    new SqlParameter("@studentNo", SqlDbType.NChar,10),
                    new SqlParameter("@englishExamNotifyId", SqlDbType.Int,4)};
            parameters[0].Value = model.examCertificateState;
            parameters[1].Value = model.examCertificateRemark;
            parameters[2].Value = model.isPaid;
            parameters[3].Value = model.isPaidRemark;
            parameters[4].Value = model.grade;
            parameters[5].Value = model.gradeCertificateState;
            parameters[6].Value = model.gradeCertificateRemark;
            parameters[7].Value = model.englishExamId;
            parameters[8].Value = model.studentNo;
            parameters[9].Value = model.englishExamNotifyId;

            return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters); ;
        }
        //修改
        protected void btnConfirm_Click(object sender, EventArgs e)
        {
            try
            {
                DalOperationAboutEnglishExam dalOperationAboutEnglishExam = new DalOperationAboutEnglishExam();

                EnglishExam model = new EnglishExam { studentNo = studentNo, englishExamId = englishExamId, englishExamNotifyId=englishExamNotifyId, examCertificateRemark=txtExamCertificateStateRemark.Text.Trim(), gradeCertificateRemark=txtGradeCertificateStateRemark.Text.Trim(), isPaidRemark=txtIsPaidRemark.Text.Trim(),
                     grade=txtGrade.Text.Trim(),
                     gradeCertificateState= ddlGradeCertificate.SelectedValue,
                     examCertificateState=ddlExamCertificate.SelectedValue,
                     isPaid = int.Parse(ddlIspaid.SelectedValue)
                 };
                dalOperationAboutEnglishExam.UpdateEnglishExamSignUpState(model);
                Javascript.RefreshParentWindow("修改报名相关状态信息成功!", "/Teacher/EnglishExamManage.aspx?fragment=1", Page);
            }
            catch (Exception ex)
            {
                MongoDBLog.LogRecord(ex);
                Javascript.GoHistory(-1, "修改报名相关状态信息失败,请检查格式是否有误!", Page);
            }
        }
        /// <summary>
        /// 根据学号和englishExamId查找相关的四六级报名信息
        /// </summary>
        /// <returns></returns>
        public EnglishExam GetEnglishExamSignUpInfoByStudentNo(string studentNo,int englishExamId)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 englishExamId,examCertificateState,examCertificateRemark,isPaid,studentNo,examPlace,examType,grade,gradeCertificateState,gradeCertificateRemark,englishExamNotifyId,englishExamSignUpConfirm from usta_EnglishExam ");
            strSql.Append(" where studentNo=@studentNo AND englishExamId=@englishExamId");
            SqlParameter[] parameters = {
                    new SqlParameter("@studentNo", SqlDbType.NChar,10),
                    new SqlParameter("@englishExamId", SqlDbType.Int,4)
            };
            parameters[0].Value = studentNo;
            parameters[1].Value = englishExamId;

            EnglishExam model = new EnglishExam();
            DataSet ds = SqlHelper.ExecuteDataset(conn,CommandType.Text,strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["englishExamId"] != null && ds.Tables[0].Rows[0]["englishExamId"].ToString().Trim() != "")
                {
                    model.englishExamId = int.Parse(ds.Tables[0].Rows[0]["englishExamId"].ToString().Trim());
                }
                if (ds.Tables[0].Rows[0]["examCertificateState"] != null && ds.Tables[0].Rows[0]["examCertificateState"].ToString().Trim() != "")
                {
                    model.examCertificateState = ds.Tables[0].Rows[0]["examCertificateState"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["examCertificateRemark"] != null && ds.Tables[0].Rows[0]["examCertificateRemark"].ToString().Trim() != "")
                {
                    model.examCertificateRemark = ds.Tables[0].Rows[0]["examCertificateRemark"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["isPaid"] != null && ds.Tables[0].Rows[0]["isPaid"].ToString().Trim() != "")
                {
                    model.isPaid = int.Parse(ds.Tables[0].Rows[0]["isPaid"].ToString().Trim());
                }
                if (ds.Tables[0].Rows[0]["studentNo"] != null && ds.Tables[0].Rows[0]["studentNo"].ToString().Trim() != "")
                {
                    model.studentNo = ds.Tables[0].Rows[0]["studentNo"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["examPlace"] != null && ds.Tables[0].Rows[0]["examPlace"].ToString().Trim() != "")
                {
                    model.examPlace = ds.Tables[0].Rows[0]["examPlace"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["examType"] != null && ds.Tables[0].Rows[0]["examType"].ToString().Trim() != "")
                {
                    model.examType = ds.Tables[0].Rows[0]["examType"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["grade"] != null && ds.Tables[0].Rows[0]["grade"].ToString().Trim() != "")
                {
                    model.grade = ds.Tables[0].Rows[0]["grade"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["gradeCertificateState"] != null && ds.Tables[0].Rows[0]["gradeCertificateState"].ToString().Trim() != "")
                {
                    model.gradeCertificateState = ds.Tables[0].Rows[0]["gradeCertificateState"].ToString().Trim();
                }
                if (ds.Tables[0].Rows[0]["gradeCertificateRemark"] != null && ds.Tables[0].Rows[0]["gradeCertificateRemark"].ToString().Trim() != "")
                {
                    model.gradeCertificateRemark = ds.Tables[0].Rows[0]["gradeCertificateRemark"].ToString().Trim();
                }
                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]["englishExamSignUpConfirm"] != null && ds.Tables[0].Rows[0]["englishExamSignUpConfirm"].ToString().Trim() != "")
                {
                    model.englishExamSignUpConfirm = int.Parse(ds.Tables[0].Rows[0]["englishExamSignUpConfirm"].ToString().Trim());
                }
                return model;
            }
            else
            {
                return null;
            }
        }