protected void btnAdd_Click(object sender, EventArgs e)
        {
            DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck();
            string dtime = DateTime.Now.ToString();

            using (TransactionScope scope = new TransactionScope())
            {
                try
                {
                    foreach (Control ctlTable in PlaceHolder1.Controls)
                    {
                        foreach (Control ctlTableRow in ctlTable.Controls)
                        {
                            foreach (Control ctlTableCell in ctlTableRow.Controls)
                            {
                                foreach (Control ctl in ctlTableCell.Controls)
                                {
                                    if (ctl.GetType().ToString().Trim() == "System.Web.UI.WebControls.TextBox")
                                    {
                                        StudentsGradeCheckDetail model = new StudentsGradeCheckDetail();
                                        model.studentNo = studentNo;
                                        model.updateTime = Convert.ToDateTime(dtime);
                                        model.gradeCheckDetailValue = ((TextBox)ctl).Text.Trim();
                                        model.gradeCheckId = int.Parse(ctl.ID.Split("_".ToCharArray())[1]);
                                        dal.AddGradeCheckDetailByStudentNo(model);
                                    }
                                }
                            }
                        }
                    }

                    StudentsGradeCheckConfirm model1 = new StudentsGradeCheckConfirm { studentNo = studentNo, updateTime = Convert.ToDateTime(dtime), isAccord = int.Parse(ddlIsAccord.SelectedValue), remark = remark.Text.Trim() };
                    dal.AddStudentGradeCheckConfirm(model1);
                    scope.Complete();
                    Javascript.RefreshParentWindow("添加成绩审核记录成功!", "/Administrator/StudentManager.aspx?fragment=7&studentNo=" + studentNo, Page);
                }
                catch (Exception ex)
                {
                    MongoDBLog.LogRecord(ex);
                    Javascript.GoHistory(-1, "添加成绩审核记录失败!", Page);
                }
                finally
                {
                    dal.conn.Close();
                }
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int AddGradeCheckDetailByStudentNo(StudentsGradeCheckDetail model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into usta_StudentsGradeCheckDetail(");
            strSql.Append("gradeCheckId,gradeCheckDetailValue,studentNo,updateTime)");
            strSql.Append(" values (");
            strSql.Append("@gradeCheckId,@gradeCheckDetailValue,@studentNo,@updateTime)");
            SqlParameter[] parameters = {
                    new SqlParameter("@gradeCheckId", SqlDbType.Int,4),
                    new SqlParameter("@gradeCheckDetailValue", SqlDbType.NVarChar,200),
                    new SqlParameter("@studentNo", SqlDbType.NChar,10),
                    new SqlParameter("@updateTime", SqlDbType.DateTime)};
            parameters[0].Value = model.gradeCheckId;
            parameters[1].Value = model.gradeCheckDetailValue;
            parameters[2].Value = model.studentNo;
            parameters[3].Value = model.updateTime;

            return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateGradeCheckDetailByStudentNo(StudentsGradeCheckDetail model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update usta_StudentsGradeCheckDetail set ");
            strSql.Append("gradeCheckDetailValue=@gradeCheckDetailValue");
            strSql.Append(" where studentNo=@studentNo AND updateTime=@updateTime AND gradeCheckId=@gradeCheckId");
            SqlParameter[] parameters = {
                    new SqlParameter("@gradeCheckDetailValue", SqlDbType.NVarChar,200),
                    new SqlParameter("@studentNo", SqlDbType.NChar,10),
                    new SqlParameter("@updateTime", SqlDbType.DateTime),
                    new SqlParameter("@gradeCheckId", SqlDbType.Int,4)};
            parameters[0].Value = model.gradeCheckDetailValue;
            parameters[1].Value = model.studentNo;
            parameters[2].Value = model.updateTime;
            parameters[3].Value = model.gradeCheckId;

            return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
        }