//添加一条课程信息
        protected void Save_Click(object sender, EventArgs e)
        {
            CourseModel Course_Model = new CourseModel();
            Bap_Course Bap_Course = new Bap_Course();

            Bap_Course.Course_Name = Course_Name_Edit.Text;
            Bap_Course.Staff_num = Staff_num_Edit.Text;
            Bap_Course.Teacher_Name = Teacher_Name_Edit.Text;
            Bap_Course.Department = Department_Edit.Text;
            Bap_Course.Hours = Hours_Edit.Text;
            Bap_Course.Class_Time = Class_Time_Edit.SelectedValue;
            Bap_Course.Class_Week = Class_Week_Edit.SelectedValue;
            Bap_Course.Total_Week = Total_Week_Edit1.Text + "-" + Total_Week_Edit2.Text + "周";
            Bap_Course.Is_Week = Is_Week_Edit.SelectedValue; ;
            Bap_Course.Class_Addr = Class_Addr_Edit.Text;
            Bap_Course.Classes = Classes_Edit.Text;

            bool is_Success = Course_Model.Add(Bap_Course);
            if (is_Success)
            {
                Response.Redirect("List.aspx");
            }
            else
            {
                SaveInfo.Text = "修改失败...";
            }
        }
    //添加一条课程信息
    public bool Add(Bap_Course Bap_Course)
    {
        DatabaseAccess database = new DatabaseAccess();

        String sql = String.Format(@"insert into Bap_Course(Course_Name,Staff_num,Teacher_Name,Department,Hours,Class_Time,Class_Week,Total_Week,Is_Week,Class_Addr,Classes) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')",
              Bap_Course.Course_Name, Bap_Course.Staff_num, Bap_Course.Teacher_Name, Bap_Course.Department, Bap_Course.Hours,
              Bap_Course.Class_Time, Bap_Course.Class_Week, Bap_Course.Total_Week, Bap_Course.Is_Week, Bap_Course.Class_Addr, Bap_Course.Classes);

        return database.executeUpdate(sql);
    }
 //获得个人课表
 public List<Bap_Course> getCourse(String name, String value)
 {
     List<Bap_Course> list = new List<Bap_Course>();
     DatabaseAccess database = new DatabaseAccess();
     string sql = "select * from Bap_Course where " + name + " = '" + value + "'";
     try
     {
         SqlDataReader result = database.executeQuery(sql);
         while (result.Read())
         {
             Bap_Course course = new Bap_Course();
             course.Id = result["Id"].ToString();
             course.Course_Name = result.GetString(1);
             course.Staff_num = result.GetString(2);
             course.Teacher_Name = result.GetString(3);
             course.Department = result.GetString(4);
             course.Hours = result["Hours"].ToString();
             course.Class_Time = result.GetString(6);
             course.Class_Week = result.GetString(7);
             course.Total_Week = result.GetString(8);
             course.Is_Week = result.GetString(9);
             course.Class_Addr = result.GetString(10);
             course.Classes = result.GetString(11);
             list.Add(course);
         }
     }
     catch (Exception e)
     {
         throw new Exception(e.Message);
     }
     finally
     {
         database.close();
     }
     return list;
 }
        protected void queding_Click(object sender, EventArgs e)
        {
            int iii = 0;
            string filename = Session["filename"].ToString();
            //获取Execle文件名  DateTime日期函数
            // Label2.Text = filename;
            //Server.MapPath 获得虚拟服务器相对路径
            string savePath = Server.MapPath(("~\\DaoRu\\files\\") + filename);
            //SaveAs 将上传的文件内容保存在服务器上

            //调用自定义方法
            DataSet ds = new ExcelDateSet().ExcelDs(savePath);
            //定义一个DataRow数组
            DataRow[] dr = ds.Tables[0].Select();
            int rowsnum = ds.Tables[0].Rows.Count;

               // Response.Write("<table width='1380px;' style=' border : yellow 2px solid;'>");
            //存放拆分之后的所有课表
            LinkedList<LinkedList<String>> lastlist = new LinkedList<LinkedList<String>>();
            //LinkedList<Object> lastlist = new LinkedList<Object>();
            //读取execl表中的每一行,放在一个list中
            for (int i = 0; i < dr.Length; i++)
            {
                LinkedList<String> List = new LinkedList<String>();

                List.AddFirst(dr[i][0].ToString());
                List.AddLast(dr[i][1].ToString());
                List.AddLast(dr[i][2].ToString());
                List.AddLast(dr[i][3].ToString());
                List.AddLast(dr[i][4].ToString());
                List.AddLast(dr[i][5].ToString());
                List.AddLast(dr[i][6].ToString());
                List.AddLast(dr[i][7].ToString());

                //调用自己写方法,将execl表中的数据划分好。返回的数据是一个list中包含的list成员的链表
                LinkedList<LinkedList<String>> templist = new ExcelDateSet().ListCutter(List);
                //将返回的list放在最后的集合中
                foreach (LinkedList<String> obj in templist)
                {
                    lastlist.AddLast(obj);
                }

                foreach (LinkedList<String> linklist in lastlist)
                {

                    int j = 0;

                    String[] tempstr = new String[20];
                    foreach (String str in linklist)
                    {
                        tempstr[j++] = str;

                    }

                    Bap_Course classbean = new Bap_Course();

                    classbean.Course_Name = tempstr[0];
                    classbean.Staff_num = tempstr[1];
                    classbean.Teacher_Name = tempstr[2];
                    classbean.Department = tempstr[3];
                    classbean.Hours = tempstr[4];
                    classbean.Class_Addr = tempstr[5];
                    classbean.Classes = tempstr[6];
                    // classbean.Class_Time = tempstr[7];
                    classbean.Class_Time = tempstr[8];
                    classbean.Class_Week = tempstr[9];
                    // classbean.Startweek = tempstr[10];
                    classbean.Total_Week = tempstr[11];
                    classbean.Is_Week = tempstr[12];

                    //try中的操作是将课程安排写到数据库中,暂时没有完成。
                    try
                    {
                       // DataBase db = new DataBase();
                        String insertstr = @"insert into Bap_Course(Course_Name ,Staff_num,Teacher_Name,Department,Hours,Class_Addr,Classes,Class_Time,Class_Week,Total_Week,Is_Week)
                                                values ('" + classbean.Course_Name + "','" + classbean.Staff_num + "','" + classbean.Teacher_Name + "','" + classbean.Department + "','" + classbean.Hours + "','" + classbean.Class_Addr + "','" + classbean.Classes + "','" + classbean.Class_Time + "','" + classbean.Class_Week + "','" + classbean.Total_Week + "','" + classbean.Is_Week + "' ) ";
                        //Boolean b = db.DateExecuteSQL(insertstr);
                        if (DbHelperSQL.ExecuteSql(insertstr)>0)
                        {
                            iii++;
                        }
                    }
                    catch (Exception ex)       //捕捉异常
                    {
                        Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
                    }

                }
                Response.Write("<script>alert('" + iii + "条数据导入成功!');</script>");
                trselet.Visible = true;
                queding.Visible = false;
                fanhui.Visible = false;
                Session["filename"] = "";
                //Response.Redirect("~/DaoRu/Default.aspx");
                Response.Write("<script>document.location=document.location;</script>");
                //数据的拆分,写入数据库工作完成。

            }
        }
 //获取查询结果
 public List<Bap_Course> Search(String name, String value, int page, int size)
 {
     List<Bap_Course> list = new List<Bap_Course>();
     DatabaseAccess database = new DatabaseAccess();
        // String sql = "select * from Bap_Course where 1=1";
     String sql = "select top(" + size + ") * from Bap_Course where id not in(select top(" + (page - 1) * size + ") id from Bap_Course where 1=1)";
     if(name!="")
     {
     sql +=" and Teacher_Name like '%"+name +"%'";
     }
     if (value  != "")
     {
         sql += " and Staff_num like '%" + value + "%'";
     }
        // String sql = "select * from Bap_Course where " + name + " like '" + value + "%'";
     try
     {
         SqlDataReader result = database.executeQuery(sql);
         while (result.Read())
         {
             Bap_Course course = new Bap_Course();
             course.Id = result["Id"].ToString();
             course.Course_Name = result.GetString(1);
             course.Staff_num = result.GetString(2);
             course.Teacher_Name = result.GetString(3);
             course.Department = result.GetString(4);
             course.Hours = result["Hours"].ToString();
             course.Class_Time = result.GetString(6);
             course.Class_Week = result.GetString(7);
             course.Total_Week = result.GetString(8);
             course.Is_Week = result.GetString(9);
             course.Class_Addr = result.GetString(10);
             course.Classes = result.GetString(11);
             list.Add(course);
         }
     }
     catch (Exception e)
     {
         throw new Exception(e.Message);
     }
     finally
     {
         database.close();
     }
     return list;
 }
    //根据ID保存修改后的课程信息
    public bool SaveById(Bap_Course Bap_Course)
    {
        DatabaseAccess database = new DatabaseAccess();

        String sql = String.Format(@"update Bap_Course set
                        Course_Name='{0}',
                        Staff_num='{1}',
                        Teacher_Name='{2}',
                        Department='{3}',
                        Hours='{4}',
                        Class_Time='{5}',
                        Class_Week='{6}',
                        Total_Week='{7}',
                        Is_Week='{8}',
                        Class_Addr='{9}',
                        Classes='{10}' where id='" + Convert.ToInt32(Bap_Course.Id) + "'",
                                                   Bap_Course.Course_Name,
                                                   Bap_Course.Staff_num,
                                                   Bap_Course.Teacher_Name,
                                                    Bap_Course.Department,
                                                    Bap_Course.Hours,
                                                    Bap_Course.Class_Time,
                                                     Bap_Course.Class_Week,
                                                     Bap_Course.Total_Week,
                                                     Bap_Course.Is_Week,
                                                     Bap_Course.Class_Addr,
                                                     Bap_Course.Classes);

        return database.executeUpdate(sql);
    }
 //根据ID获得某一条信息
 public Bap_Course getOne(string id)
 {
     Bap_Course Bap_Course = new Bap_Course();
     DatabaseAccess database = new DatabaseAccess();
     string sql = "select * from Bap_Course where id = " + Int32.Parse(id);
     try
     {
         SqlDataReader result = database.executeQuery(sql);
         while (result.Read())
         {
             // Bap_Course.Id = result["Id"].ToString();
             Bap_Course.Course_Name = result["Course_Name"].ToString();
             Bap_Course.Staff_num = result["Staff_num"].ToString();
             Bap_Course.Teacher_Name = result["Teacher_Name"].ToString();
             Bap_Course.Department = result["Department"].ToString();
             Bap_Course.Hours = result["Hours"].ToString();
             Bap_Course.Class_Time = result["Class_Time"].ToString();
             Bap_Course.Class_Week = result["Class_Week"].ToString();
             Bap_Course.Total_Week = result["Total_Week"].ToString();
             Bap_Course.Is_Week = result["Is_Week"].ToString();
             Bap_Course.Class_Addr = result["Class_Addr"].ToString();
             Bap_Course.Classes = result["Classes"].ToString();
         }
     }
     catch (Exception e)
     {
         throw new Exception(e.Message);
     }
     finally
     {
         database.close();
     }
     return Bap_Course;
 }