?using System;
using System.Data;
using System.Collections;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using TQMS.BusinessLogicLayer;


 namespace TQMS.BusinessLogicLayer
{
    /// <summary>
/// Common 的摘要說明
/// </summary>
/// 
    public class Common
    {
	    public Common()
	    {
		    //
		    // TODO: 在此處添加構造函數邏輯
		    //
	    }


        /// <summary>
        /// 綁定科目下拉列表框
        /// </summary>
        public static int BindDdlCourse(DropDownList ddlCourse)
        {
           int count =CourseItems(ddlCourse );
           if (count > 0)
           {
               ddlCourse.Items[0].Selected = true;
               }
           return count;

        }

        public static int  BindDdlCourse(DropDownList ddlCourse,int  courseID)
        {
            
           int count= CourseItems(ddlCourse);
            if (count >0 )
            {
                ddlCourse.Items.FindByValue(Convert.ToString(courseID)).Selected = true;
            }
            return count;
            
        }
        /// <summary>
        /// 根據科目編號綁定章節信息到下拉列表框
        /// </summary>
        /// <param name="ddlChapter">下拉列表框</param>
        /// <param name="courseID">科目編號</param>
        public static int BindChapter(DropDownList ddlChapter, int courseID)
        {
            int count =ChapterItems(ddlChapter, courseID);
            if (count  > 0)
            {
                ddlChapter.Items[0].Selected = true;
            }
            return count;
        }
        public static int  BindChapter(DropDownList ddlChapter, int courseID,int chapterID)
        {
            int count = ChapterItems(ddlChapter, courseID);
            if (count > 0)
            {
                ddlChapter.Items.FindByValue(chapterID.ToString()).Selected = true;
            }
            return count;
        }

        /// <summary>
        /// 綁定題型
        /// </summary>
        public static  void BindDdlType(DropDownList ddlType)
        {
            TypeItems(ddlType);
           
        }
        public static  void BindDdlType(DropDownList ddlType,string selectValue)
        {
            TypeItems(ddlType);
            if (ddlType.Items.FindByValue(selectValue) != null)
            {
                ddlType.Items[0].Selected = false;
                ddlType.Items.FindByValue(selectValue).Selected = true;
     
            }
            
       }

       /// <summary>
       /// 綁定難度
       /// </summary>
        public static void BindDdlDifficult(DropDownList ddlDifficult)
       {
           DifficultItems(ddlDifficult);

        }

        public static void BindDdlDifficult(DropDownList ddlDifficult,string difficultLevel)
        {
            DifficultItems(ddlDifficult);
            ddlDifficult.Items[0].Selected = false;
            ddlDifficult.Items.FindByValue(difficultLevel).Selected = true;
        }

     
      

        #region  各種下拉列表的項目
        /// <summary>
        /// 綁定科目的下拉列表
        /// </summary>
        /// <param name="ddlCourse"></param>
        ///<returns>科目下拉列表的數目，若為空，則返回0</returns>
        private static int  CourseItems(DropDownList ddlCourse)
        {
            DataTable dt = Course.QueryCourse(new Hashtable());//查詢科目的所有信息
            if (dt.Rows.Count > 0)
            {
                ListItem li = new ListItem();
                foreach (DataRow dr in dt.Rows)
                {
                    li = new ListItem(dr["TQ_CourseName"].ToString(), dr["TQ_CourseID"].ToString());
                    ddlCourse.Items.Add(li);
                }

                
                return ddlCourse.Items.Count;

            }
            else
                return 0;
           
        }

        /// <summary>
        /// 綁定章節的下拉列表
        /// </summary>
        /// <param name="ddlChapter">要綁定到的下拉列表</param>
        /// <param name="courseID">與下列表相關的課程編號</param>
        /// <returns>章節下拉列表的數目，如果為空，則返回0</returns>

        private static int ChapterItems(DropDownList ddlChapter,int courseID)
        {
            DataTable dt = Chapter.QueryChapter(courseID);
            if (dt.Rows.Count > 0)
            {
                ListItem li;
                foreach (DataRow dr in dt.Rows)
                {
                    li = new ListItem(dr["TQ_ChapterName"].ToString(), dr["TQ_ChapterID"].ToString());
                    ddlChapter.Items.Add(li);
                }
               
                return ddlChapter.Items.Count;
            }
            else
                return 0;
           
        }
        

        //題型的各項
        private static void TypeItems(DropDownList ddlType)
        {
            ddlType.Items.Add(new ListItem("選擇題", "1"));
            ddlType.Items.Add(new ListItem("填空題", "5"));
            ddlType.Items.Add(new ListItem("是非題", "10"));
            ddlType.Items.Add(new ListItem("名詞解釋題", "15"));
            ddlType.Items.Add(new ListItem("簡答題", "20"));
            ddlType.Items.Add(new ListItem("計算題", "25"));
            ddlType.Items.Add(new ListItem("論述題", "30"));
            ddlType.Items.Add(new ListItem("作文題", "35"));
            ddlType.Items[0].Selected = true;
        }

        //試題類型的反向顯示
        /// <summary>
        /// 將數據庫中試題類型的數值數據在綁定到lab控件時，進行轉換
        /// </summary>
        /// <param name="lbl">要綁定的控件label標簽</param>
        public static  void showType(Label lbl)
        {
            int n = int.Parse(lbl.Text.ToString());
            switch (n)
            {
                case 1:
                    lbl.Text = "選擇題";
                    break;
                case 5:
                    lbl.Text = "真空題";
                    break;
                case 10:
                    lbl.Text = "是非題";
                    break;
                case 15:
                    lbl.Text = "名詞解釋";
                    break;
                case 20:
                    lbl.Text = "簡答題";
                    break;
                case 25:
                    lbl.Text = "計算題";
                    break;
                case 30:
                    lbl.Text = "論述題";
                    break;
                case 35:
                    lbl.Text = "作文題";
                    break;
                default:
                    lbl.Text = "未知";
                    break;
            }
        }

        //難度的各項
        private static void DifficultItems(DropDownList ddlDifficult)
        {
            ddlDifficult.Items.Add(new ListItem("簡單", "1"));
            ddlDifficult.Items.Add(new ListItem("一般", "2"));
            ddlDifficult.Items.Add(new ListItem("中等", "3"));
            ddlDifficult.Items.Add(new ListItem("難", "4"));
            ddlDifficult.Items.Add(new ListItem("較難", "5"));
            
            ddlDifficult.Items[0].Selected = true;
        }

        //試題難度的反向顯示
        /// <summary>
        /// 將數據庫中難度的數值數據在綁定到lab控件時，進行轉換
        /// </summary>
        /// <param name="lbl"></param>

         public static  void  showDifficulty(Label lbl)
        {
            int n = int.Parse(lbl.Text.ToString());
            switch (n)
            {
                case 1:
                    lbl.Text = "簡單";
                    break;
                case 2:
                    lbl.Text = "一般";
                    break;
                case 3:
                    lbl.Text = "中等";
                    break;
                case 4:
                    lbl.Text = "難";
                    break;
                case 5:
                    lbl.Text = "較難";
                    break;
                default:
                    break;
            }
        }

        #endregion
    }
}