Exemple #1
0
        /// <summary>
        /// 删除学生信息
        /// </summary>
        /// <param name="category">下拉列表传值</param>
        /// <param name="keyWord">查询关键字</param>
        /// <param name="pageIndex">每页索引数</param>
        /// <returns></returns>
        public ActionResult DeleteStu(string category, string keyWord, int pageIndex = 1)
        {
            string     id      = Request.QueryString["id"];//获取学生id
            StuManager manager = new StuManager();

            manager.DeleteStuById(id);         //调用删除学生方法
            List <Stu> stu = new List <Stu>(); //定义学生列表对象

            //判断查询关键字是否为空
            if (!String.IsNullOrEmpty(category))
            {
                StuQuery cate = (StuQuery)Enum.Parse(typeof(StuQuery), category);
                stu = new StuManager().GetStu(cate, keyWord);
            }
            else
            {
                stu = new StuManager().GetStu();
            }
            //定义一个pagedList对象
            PagedList <Stu> pagedStus = new PagedList <Stu>(stu, pageIndex, pageSize);

            //提供教师查询方式的下拉框
            //调用查询方式
            SetDropDownList(category);
            ViewData["keyWord"] = keyWord;
            return(View("StuList", pagedStus));
        }
Exemple #2
0
        public List <Stu> GetStu(StuQuery category, string keyWord)
        {
            List <Stu> list = new List <Stu>();
            //category.CompareTo(StuQueryCategories.书名)
            string sql = "SELECT * FROM Stu where  ";

            if (String.Compare(category.ToString(), "学号", true) == 0)
            {
                sql = sql + " StuID LIKE '%" + keyWord + "%'";
            }
            else if (String.Compare(category.ToString(), "姓名", true) == 0)
            {
                sql = sql + " StuName LIKE '%" + keyWord + "%'";
            }
            else if (String.Compare(category.ToString(), "年级", true) == 0)
            {
                sql = sql + " StuGrade LIKE '%" + keyWord + "%'";
            }
            else if (String.Compare(category.ToString(), "班级", true) == 0)
            {
                sql = sql + " StuClass LIKE '%" + keyWord + "%'";
            }
            //DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, "sp_QueryStus", category, keyWord);
            DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, sql);

            if (ds.Tables.Count > 0)
            {
                DataTable dt = ds.Tables[0];
                foreach (DataRow row in dt.Rows)
                {
                    Stu stu = new Stu();
                    stu.StuID    = (int)row["StuID"];
                    stu.StuName  = (string)row["StuName"];
                    stu.StuClass = (int)row["StuClass"];
                    stu.StuGrade = row["StuGrade"] != DBNull.Value ? (int)row["StuGrade"] : 0;
                    stu.StuTel   = (string)row["StuTel"];
                    list.Add(stu);
                }
            }
            return(list);
        }
Exemple #3
0
        /// <summary>
        /// 学生列表
        /// </summary>
        /// <param name="category"></param>
        /// <param name="keyWord"></param>
        /// <param name="pageIndex"></param>
        /// <returns></returns>
        public ActionResult StuList(string category, string keyWord, int pageIndex = 1)
        {
            List <Stu> stu = new List <Stu>();//定义学生列表对象

            //判断查询关键字是否为空
            if (!String.IsNullOrEmpty(category))
            {
                StuQuery cate = (StuQuery)Enum.Parse(typeof(StuQuery), category);
                stu = new StuManager().GetStu(cate, keyWord);
            }
            else
            {
                stu = new StuManager().GetStu();
            }
            //定义一个PagedList对象
            PagedList <Stu> pagedStus = new PagedList <Stu>(stu, pageIndex, pageSize);

            //提供学生查询方式的下拉框书籍
            //
            SetDropDownList(category);

            ViewData["keyWord"] = keyWord;
            return(View("StuList", pagedStus));
        }
Exemple #4
0
 public List <Stu> GetStu(StuQuery category, string keyWord)
 {
     return(new StuService().GetStu(category, keyWord));
 }