using System;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.Security;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using StudentManager.IDAL;
using StudentManager.Common;
using StudentManager.DALFactory;

namespace StudentManager.BLL
{
    /// <summary>
    /// 公共信息實體業務層
    /// 創建者:余洪
    /// 時間:2008-3
    /// </summary>
    public  class Common
    {
        #region 反射創建公共信息實體
        private ICommon common = DataAccess.CreateCommon();
        #endregion

        #region 獲取用戶基本歡迎信息
        /// <summary>
        /// 獲取用戶基本歡迎信息
        /// </summary>
        /// <param name="u_Id">用戶ID</param>
        /// <returns>用戶名</returns>
        public string GetUseWelInf(string u_Id)
        {
            string table = HttpContext.Current.Session["role"].ToString();
            return u_Id+" "+common.GetUserWelInf(u_Id,table)+" ";

        }
        #endregion

        #region 綁定學歷列表到下拉列表框
        public void BindLearnList(DropDownList ddlLearnList)
        {
            ddlLearnList.DataSource = common.GetLearnList();
            ddlLearnList.DataTextField = "lg_name";
            ddlLearnList.DataValueField = "lg_name";
            ddlLearnList.DataBind();
        }
        #endregion

        #region 綁定教師職稱到下拉列表框
        public void BindZhiChengList(DropDownList ddlZhiChengList)
        {
            ddlZhiChengList.DataSource = common.GetZhiChengList();
            ddlZhiChengList.DataTextField = "zc_name";
            ddlZhiChengList.DataValueField = "zc_name";
            ddlZhiChengList.DataBind();
        }
        #endregion

        #region 綁定政治面貌列表
        public void BindZZList(DropDownList ddlZZList)
        {
            ddlZZList.DataSource = common.GetZZList();
            ddlZZList.DataTextField = "zf_name";
            ddlZZList.DataValueField = "zf_id";
            ddlZZList.DataBind();
        }
        #endregion

        #region 獲取民族列表
        public void BindMZList(DropDownList ddlMZList)
        {
            ddlMZList.DataSource = common.GetMZList();
            ddlMZList.DataTextField = "mz_name";
            ddlMZList.DataValueField = "mz_name";
            ddlMZList.DataBind();
        }
        #endregion 

        #region 綁定省列表
        public void BindProvinceList(DropDownList ddlProvinceList)
        {
            ddlProvinceList.DataSource = common.GetProvinceList();
            ddlProvinceList.DataTextField = "pr_name";
            ddlProvinceList.DataValueField = "pr_name";
            ddlProvinceList.DataBind();
        }
        #endregion

        #region 綁定城市列表
        public void BindeCityList(string province, DropDownList ddlCityList)
        {
            ddlCityList.DataSource = common.GetCityList(province);
            ddlCityList.DataTextField = "ci_name";
            ddlCityList.DataValueField = "ci_name";
            ddlCityList.DataBind();
        }
        #endregion

        #region 綁定專業信息到下拉列表
        public void BindSpecialityListForDDl(DropDownList ddlSpeciality)
        {
            ddlSpeciality.DataSource = common.GetSpecialityListForBind();
            ddlSpeciality.DataTextField = "sp_name";
            ddlSpeciality.DataValueField = "sp_id";
            ddlSpeciality.DataBind();
        }
        #endregion
    }
}