using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using StudentManager.IDAL;
using StudentManager.DBUtility;


namespace StudentManager.SQLServer
{
    /// <summary>
    /// 公共數據訪問
    /// 創建者:余洪
    /// 時間:2008-3
    /// </summary>
    public class Common:SqlServerBaseDb,ICommon
    {
        #region 存儲過程參數常量
        private const string UID="@Uid";
        private const string UTABLE="@Utable";
        private const string USERNAME = "@Username";
        private const string PROVINCE="@Province";
        #endregion

        #region  獲取用戶基本歡迎信息
        /// <summary>
        /// 獲取用戶基本歡迎信息
        /// </summary>
        /// <param name="u_Id">用戶ID</param>
        /// <param name="U_Table">用戶表</param>
        /// <returns>用戶名</returns>
        public string GetUserWelInf(string u_Id, string u_Table)
        {
            SqlParameter[] parms ={
                MakeInParm(UID,SqlDbType.VarChar,20,u_Id),
                MakeInParm(UTABLE,SqlDbType.VarChar,20,u_Table),
                MakOutParm(USERNAME,SqlDbType.VarChar,20)
            };
            
            try
            {
                ExecProc("GetUserWelcomeInf",parms);
                return parms[2].Value.ToString();
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region 獲取學歷列表
        public  DataTable GetLearnList()
        {
            try
            {
                return ExecProcDs("GetLearnList", null).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region 獲取教師職稱列表
        public DataTable GetZhiChengList()
        {
            try
            {
                return ExecProcDs("GetZhiChengList", null).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region 獲取政治面貌列表
        public DataTable GetZZList()
        {
            try
            {
                return ExecProcDs("GetZZList", null).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region 獲取民族列表
        public DataTable GetMZList()
        {
            try
            {
                return ExecProcDs("GetMZList", null).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion 

        #region 獲取省列表
        public DataTable GetProvinceList()
        {
            try
            {
                return ExecProcDs("GetProvinceList", null).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region 獲取市列表
        public DataTable GetCityList(string province)
        {
            SqlParameter[] parms ={
                MakeInParm(PROVINCE,SqlDbType.VarChar,10,province)
            };
            try
            {
                return ExecProcDs("GetCityList", parms).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion

        #region 綁定專業信息到下拉列表框
        public DataTable GetSpecialityListForBind()
        {
            try
            {
                return ExecProcDs("GetSpecialityListForBind", null).Tables[0];
            }
            catch
            {
                return null;
            }
        }
        #endregion


    }
}