/// <summary>
        /// Láy trạng thái theo mã
        /// Thu Hà 1/6/2011
        /// </summary>
        /// <param name="matrangthai"></param>
        /// <returns></returns>
        public static TrangThai LayTrangThaiTheoMa(int matrangthai)
        {
            TrangThai trangThai = new TrangThai();
            try
            {
                List<SqlParameter> lstParams = new List<SqlParameter>();
                lstParams.Add(new SqlParameter("@matrangthai", matrangthai));

                DataTable dt = new DataTable();
                dt = SqlDataAccessHelper.ExecuteQuery("spLayTrangThaiTheoMa", lstParams);

                if (dt.Rows.Count > 0)
                {
                    DataRow dtRow = dt.Rows[0];

                    trangThai.MaTrangThai = int.Parse(dtRow["MaTrangThai"].ToString());
                    trangThai.TenTrangThai = dtRow["TrangThai"].ToString();

                }
            }
            catch (Exception e)
            {
                trangThai = new TrangThai();
                throw e;
            }
            return trangThai;
        }
        /// <summary>
        /// Lấy ds trạng thái
        /// Thu Ha
        /// 1/6/2011
        /// </summary>
        /// <returns></returns>
        public static List<TrangThai> LayDSTrangThai()
        {
            List<TrangThai> lstTrangThai = new List<TrangThai>();
            try
            {

                DataTable dt = new DataTable();
                dt = SqlDataAccessHelper.ExecuteQuery("spLayDSTrangThai");

                foreach( DataRow dtRow in dt.Rows)
                {
                    TrangThai trangThai = new TrangThai();
                    trangThai.MaTrangThai = int.Parse(dtRow["MaTrangThai"].ToString());
                    trangThai.TenTrangThai = dtRow["TrangThai"].ToString();
                    lstTrangThai.Add(trangThai);
                }
            }
            catch (Exception e)
            {
                lstTrangThai = new List<TrangThai>();
                throw e;
            }
            return lstTrangThai;
        }