using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI;
using System.Data;
using System.Web.UI.WebControls;
using StudentManager.DALFactory;
using StudentManager.SQLServer;
using StudentManager.Model;
using StudentManager.IDAL;
using StudentManager.Common;

namespace StudentManager.BLL
{
    /// <summary>
    /// 課程業(yè)務邏輯層務層
    /// 創(chuàng)建者:余洪
    /// 時間:2008-5
    /// </summary>
    public class Course
    {
        #region 使用反射工廠多態(tài)實例化課程接口
        /// <summary>
        /// 使用反射工廠多態(tài)實例化課程接口
        /// </summary>
        private ICourse course = DataAccess.CreateCourse();
        #endregion

        #region 添加學院開課課程
        public void AddCourse(CourseInf courseInf,Label lblMessage)
        {
            int result= course.AddCourse(courseInf);
            switch (result)
            {
                case   1: lblMessage.Text = "添加課程成功!";
                    break;
                case  -1: lblMessage.Text = "課程號重復,請換其他課程號 ";
                    break;
                case   0: lblMessage.Text="添加課程失敗!";
                    break;
            }
        }
        #endregion

        #region 添加專業(yè)選課
        public void AddChooseCourse(CourseInf courseInf, Label lblMessage)
        {
            int result = course.AddChooseCourse(courseInf);
            switch (result)
            {
                case 1: lblMessage.Text = "添加選課課程成功!";
                    break;
                case -1: lblMessage.Text = "該學院已經設置了修該課程";
                    break;
                case -2: lblMessage.Text = "同一時間上課教室沖突";
                    break;
                case -3: lblMessage.Text = "該老師在該時間要上其他課程";
                    break;
                case 0: lblMessage.Text = "添加選課課程失敗!";
                    break;
            }
        }
        #endregion

        #region 綁定課程類型列表
        public void BindCourseType(DropDownList ddlCourseType)
        {
            ddlCourseType.DataSource = course.GetCourseTypeList();
            ddlCourseType.DataValueField = "ct_type";
            ddlCourseType.DataTextField = "ct_type";
            ddlCourseType.DataBind();
        }
        #endregion

        #region 梆定開課信息
        public void BindCourses(string dp_id,GridView gvCourse)
        {
            gvCourse.DataSource = course.GetCourses(dp_id);
            gvCourse.DataBind();
        }
        #endregion

        #region 綁定課程到下拉列表
        public void BindCoursList(DropDownList ddlCourseList)
        {
            ddlCourseList.DataSource = course.GetCourseList();
            ddlCourseList.DataTextField = "cb_name";
            ddlCourseList.DataValueField = "cb_id";
            ddlCourseList.DataBind();
        }
        #endregion

        #region 綁定上課教室到下拉列表
        public void BindCRList(DropDownList ddlCRList)
        {
            ddlCRList.DataSource = course.GetCRList();
            ddlCRList.DataTextField = "cr_id";
            ddlCRList.DataValueField = "cr_id";
            ddlCRList.DataBind();
        }
        #endregion

        #region 綁定上課教師到下拉列表
        public void BindTeacherList(string dp_id,DropDownList ddlTeacherList)
        {
            ddlTeacherList.DataSource = course.GetTeacherList(dp_id);
            ddlTeacherList.DataTextField = "te_name";
            ddlTeacherList.DataValueField = "te_id";
            ddlTeacherList.DataBind();
        }
        #endregion

        #region 在選課頁面綁定學生信息
        public void BindStudentInf(string st_Id,Label lblMessage,ref string dp_id,ref string sp_id)
        {
            lblMessage.Text =course.GetStudentInf(st_Id, ref dp_id,ref sp_id);
        }
        #endregion

        #region 綁定選課課程列表
        public void BindClassChooseTb(string dp_Id, string sp_Id, string pc_Year, int pc_Term, GridView gvChooseCourse)
        {
            gvChooseCourse.DataSource = course.GetChooseClassTb(dp_Id, sp_Id, pc_Year, pc_Term);
            gvChooseCourse.DataBind();
        }
        #endregion

        #region 選課
        public void ChooseCourse(string st_Id, int pc_Id, string LearnYear, int LearnTerm, string te_id)
        {
            int result=course.ChooseCourse(st_Id, pc_Id, LearnYear, LearnTerm,te_id);
            switch (result)
            {
                case 1: JScript.AlertAndRedirect("選課成功!", "ChooseCourse.aspx");
                    break;
                case -2: JScript.AlertAndRedirect("已經選了該課程了!", "ChooseCourse.aspx");
                    break;
                case -1: JScript.AlertAndRedirect("超出人數(shù)限制了!", "ChooseCourse.aspx");
                    break;
                case 0: JScript.AlertAndRedirect("選課失敗!", "ChooseCourse.aspx");
                    break;
            }
        }
        #endregion

        #region 退選課
        public void NotChooseCourse(string st_Id, int pc_Id, string LearnYear, int LearnTerm)
        {
            int result = course.NotChooseCourse(st_Id, pc_Id, LearnYear, LearnTerm);
            switch (result)
            {
                case 1: JScript.AlertAndRedirect("退選成功!", "ChooseCourse.aspx");
                    break;
                case -1: JScript.AlertAndRedirect("退選失敗!", "ChooseCourse.aspx");
                    break;
            }
        }
        #endregion

        #region 獲取選課結果表
        public void GetChooseCourseTable(string st_Id, string pc_Year, int pc_Term,GridView gvChooseTable)
        {
            gvChooseTable.DataSource= course.GetChooseCourseTable(st_Id, pc_Year, pc_Term);
            gvChooseTable.DataBind();
        }
        #endregion

        #region 獲取培養(yǎng)計劃表
        public void GetPlanCourseTable(string st_Id,GridView gvPlanCourse)
        {
            gvPlanCourse.DataSource = course.GetPlanCourseTable(st_Id);
            gvPlanCourse.DataBind();
        }
        #endregion

        #region 獲取成績表
        public void GetScoreTable(string st_Id, string pc_Year, int pc_Term, GridView gvScoreTable)
        {        
            gvScoreTable.DataSource = course.QueryScore(st_Id, pc_Year,pc_Term);
            gvScoreTable.DataBind();
        }
        #endregion

        #region 查詢教師授課表
        public void  TecherTeachCourses(string te_Id,GridView gvTeachCourses)
        {
            gvTeachCourses.DataSource = course.TecherTeachCourses(te_Id);
            gvTeachCourses.DataBind();
        }
        #endregion

        #region 獲取選課學生列表
        public void ChooseStudentTb(string pc_Id,GridView gvStudents)
        {
            gvStudents.DataSource = course.ChooseStudentTb(pc_Id);
            gvStudents.DataBind();
        }
        #endregion

        #region 獲取選課學生列表
        public void ChooseStudentTb(string pc_Id, GridView gvStudents,ref DataTable dt)
        {
            dt = course.ChooseStudentTb(pc_Id);
            gvStudents.DataSource = course.ChooseStudentTb(pc_Id);
            gvStudents.DataBind();
        }
        #endregion

        #region 綁定對應課程選課學生列表
        public void  BindStForUpdateScore(string cb_Id, string learn_Year, int learn_Term,GridView gv_StudentForUpdateScore)
        {
            gv_StudentForUpdateScore.DataSource = course.GetStForUpdateScore(cb_Id, learn_Year, learn_Term);
            gv_StudentForUpdateScore.DataBind();
        }
        #endregion

        #region 獲取教師上課列表
        public void  GetCourseList(string te_ID,GridView  gvList)
        {
            gvList.DataSource = course.GetCourseList(te_ID);
            gvList.DataBind();
        }
        #endregion

        #region 錄入成績
        public string UpdateScore(GridView gv,string te_id)
        {
            string notSucessStList = string.Empty;
            foreach(GridViewRow gvr in gv.Rows)
            {
                if (course.UpdateScore(gvr.Cells[0].Text, gvr.Cells[1].Text.ToString(), Convert.ToSingle(gvr.Cells[2].Text.ToString()),te_id) == 0)
                {
                    notSucessStList = "yes";
                }
            }
            return notSucessStList;
        }
        #endregion

    }
}