/// <summary>
        /// 判断身份证号码是否已经存在
        /// </summary>
        /// <param name="studentIdNo"></param>
        /// <returns></returns>
        public bool IsIdNoExisten(string studentIdNo)
        {
            string sql = "select count(1) from Students where StudentIdNo='{0}'";

            sql = string.Format(sql, studentIdNo);
            int count = Convert.ToInt32(SQLHelper.GetSingalResulrt(sql));

            //if (count == 1)
            //{
            //    return true;
            //}
            //else
            //{
            //    return false;
            //}

            return(count == 1 ? true:false);
        }