家教信息管理系统毕业论文设计(ASP.NET)(4)

来源：56doc.com 资料编号：5D4532 资料等级：★★★★★ %E8%B5%84%E6%96%99%E7%BC%96%E5%8F%B7%EF%BC%9A5D4532

资料以网页介绍的为准,下载后不会有水印.资料仅供学习参考之用. 密保惠帮助

资料介绍

                new SqlParameter("@teacherInfo",tch.TeacherInfo)
            };
            int res = sqlhelper.ExecuteNonQuery(cmdText, paras, CommandType.StoredProcedure);
            if (res > 0)
            {
                flag = true;
            }
            return flag;
        }
        #endregion
5.2.3搜索功能的代码
#region 按课程搜索教员
        /// <summary>
        /// 按课程搜索教员
        /// </summary>
        /// <returns></returns>
        public DataTable SelectCourseTeacher(string txt)
        {
            DataTable dt = new DataTable();
            string cmdText = "teacher_SelectByC";
            SqlParameter[] paras = new SqlParameter[]{
                new SqlParameter ("@teacherCourse",txt)
            };
            dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 按地点搜索教员
        /// <summary>
        /// 按地点搜索教员
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAddressTeacher(string txt)
        {
            DataTable dt = new DataTable();
            string cmdText = "teacher_SelectByA";
            SqlParameter[] paras = new SqlParameter[]{
                new SqlParameter ("@teacherAddress",txt)
            };
            dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure);
            return dt;
        }
        #endregion

        #region 按价格搜索教员
        /// <summary>
        /// 按价格搜索教员
        /// </summary>
        /// <returns></returns>
        public DataTable SelectPriceTeacher(string txt)
        {
            DataTable dt = new DataTable();
            string cmdText = "teacher_SelectByP";
            SqlParameter[] paras = new SqlParameter[]{
                new SqlParameter ("@price",txt)
            };
            dt = sqlhelper.ExecuteQuery(cmdText, paras, CommandType.StoredProcedure);
            return dt;