//修改
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            if (txtGradeCheckItemName.Text.Trim().Length == 0)
            {
                Javascript.GoHistory(-1, "请输入成绩审核单项名称!", Page);
            }
            else
            {
                DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck();
                StudentsGradeCheck model = new StudentsGradeCheck();
                model.gradeCheckItemName = txtGradeCheckItemName.Text.Trim();
                model.gradeCheckItemDefaultValue = txtGradeCheckItemDefaultValue.Text.Trim();
                model.displayOrder = int.Parse(txtDisplayOrder.Text.Trim());

                List<string> items = new List<string>();
                for (int i = 0; i < ddlTermYears.Items.Count; i++)
                {
                    ListItem _item = ddlTermYears.Items[i];
                    if (_item.Selected)
                    {
                        items.Add(_item.Value);
                    }
                }

                model.termYears = string.Join(",", items).Trim();

                try
                {

                    dalOperationAboutGradeCheck.AddGradeCheckItems(model);//修改
                    Javascript.RefreshParentWindow("添加成绩审核单项成功!", "/Administrator/StudentManager.aspx?fragment=5", Page);
                }
                catch (Exception ex)
                {
                    MongoDBLog.LogRecord(ex);
                    Javascript.GoHistory(-1, "添加成绩审核单项失败,请检查格式是否有误!", Page);
                }

            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int AddGradeCheckItems(StudentsGradeCheck model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into usta_StudentsGradeCheck(");
            strSql.Append("gradeCheckItemName,gradeCheckItemDefaultValue,displayOrder,termYears)");
            strSql.Append(" values (");
            strSql.Append("@gradeCheckItemName,@gradeCheckItemDefaultValue,@displayOrder,@termYears);");
            SqlParameter[] parameters = {
                    new SqlParameter("@gradeCheckItemName", SqlDbType.NChar,50),
                    new SqlParameter("@gradeCheckItemDefaultValue", SqlDbType.NChar,50),
                    new SqlParameter("@displayOrder", SqlDbType.Int,4),
                    new SqlParameter("@termYears", SqlDbType.NVarChar,200)};
            parameters[0].Value = model.gradeCheckItemName;
            parameters[1].Value = model.gradeCheckItemDefaultValue;
            parameters[2].Value = model.displayOrder;
            parameters[3].Value = model.termYears;

            return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
        }
        //修改
        protected void btnUpdate_Click(object sender, EventArgs e)
        {
            DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck();
            string _name = txtGradeCheckItemName.Text.Trim();
            if (dalOperationAboutGradeCheck.CheckIsExistGradeCheckItemName(_name, gradeCheckId).Tables[0].Rows.Count > 0)
            {
                Javascript.GoHistory(-1, "已经存在此名称的规则,请更换规则名或者在已有规则上修改所应用的学年即可!", Page);
                return;
            }

            if (txtGradeCheckItemName.Text.Trim().Length == 0)
            {
                Javascript.GoHistory(-1, "请输入成绩审核单项名称!", Page);
            }
            else
            {
                StudentsGradeCheck model = new StudentsGradeCheck();
                model.gradeCheckItemName = txtGradeCheckItemName.Text.Trim();
                model.gradeCheckItemDefaultValue = txtGradeCheckItemDefaultValue.Text.Trim();
                model.gradeCheckId = gradeCheckId;
                model.displayOrder = int.Parse(txtDisplayOrder.Text.Trim());

                List<string> items = new List<string>();
                for (int i = 0; i < ddlTermYears.Items.Count; i++)
                {
                    ListItem _item = ddlTermYears.Items[i];
                    if (_item.Selected)
                    {
                        items.Add(_item.Value);
                    }
                }

                model.termYears = string.Join(",", items).Trim();

                try
                {
                    dalOperationAboutGradeCheck.UpdateGradeCheckItemById(model);//修改
                    Javascript.RefreshParentWindow("修改成绩审核单项成功!", "/Administrator/StudentManager.aspx?fragment=5", Page);
                }
                catch (Exception ex)
                {
                    MongoDBLog.LogRecord(ex);
                    Javascript.GoHistory(-1, "修改失败,请检查格式是否有误!", Page);
                }

            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public int UpdateGradeCheckItemById(StudentsGradeCheck model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update usta_StudentsGradeCheck set ");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]");
            strSql.Append(" where [email protected]");
            SqlParameter[] parameters = {
                    new SqlParameter("@gradeCheckItemName", SqlDbType.NChar,50),
                    new SqlParameter("@gradeCheckItemDefaultValue", SqlDbType.NChar,50),
                    new SqlParameter("@gradeCheckId", SqlDbType.Int,4),
                    new SqlParameter("@displayOrder", SqlDbType.Int,4),
                    new SqlParameter("@termYears", SqlDbType.NVarChar,200)};
            parameters[0].Value = model.gradeCheckItemName;
            parameters[1].Value = model.gradeCheckItemDefaultValue;
            parameters[2].Value = model.gradeCheckId;
            parameters[3].Value = model.displayOrder;
            parameters[4].Value = model.termYears;

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