common.cs

一个多用户在线题库管理系统,可以实现各类试题的添加和管理

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
    }
}