/// <summary>
        /// 根据电话区号获取指定属性
        /// </summary>
        /// <param name="PhoneAreaCode"></param>
        /// <param name="PropertyName"></param>
        /// <param name="PhoneAreaDataObj"></param>
        /// <returns></returns>
        public string GetPropertyByPhoneAreaCode(string PhoneAreaCode, string PropertyName, object PhoneAreaDataObj)
        {
            string propertyValue = "";

            PhoneAreaData phoneareaData = (PhoneAreaData)PhoneAreaDataObj;

            if (phoneareaData == null)
            {
                return(propertyValue);
            }
            if (phoneareaData.Tables[PhoneAreaData.TableName].Rows.Count == 0)
            {
                return(propertyValue);
            }

            foreach (DataRow row in phoneareaData.Tables[PhoneAreaData.TableName].Rows)
            {
                if (PhoneAreaCode == Convert.ToString(row[PhoneAreaData.Field_PhoneAreaID]))
                {
                    propertyValue = Convert.ToString(row[PropertyName]);
                    break;
                }
            }

            return(propertyValue);
        }
        private object GetPhoneAreaData(string ProvinceID)
        {
            PhoneAreaData phoneareaData = new PhoneAreaData();
            DataSet       tmpData       = new DataSet();

            try
            {
                string Sql_GetPhoneArea =
                    "Select AreaID AreaID,  AreaName AreaName,ProvinceID ProvinceID " +
                    "From [dbo].[Area] where ProvinceID='" + ProvinceID + "'";


                SqlCommand cmd = new SqlCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = Sql_GetPhoneArea;

                // 获取数据
                tmpData = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);

                // 数据转换
                // DataSet --> PhoneAreaData
                int intTargetColumnCount = phoneareaData.Tables[PhoneAreaData.TableName].Columns.Count;
                foreach (DataRow row in tmpData.Tables[0].Rows)
                {
                    object[] newRow = new object[intTargetColumnCount];
                    for (int j = 0; j < intTargetColumnCount; j++)
                    {
                        newRow[j] = row[j];
                    }
                    phoneareaData.Tables[PhoneAreaData.TableName].Rows.Add(newRow);
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }

            return(phoneareaData);
        }
        private object GetPhoneAreaData()
        {
            PhoneAreaData phoneareaData = new PhoneAreaData();
            DataSet tmpData = new DataSet();

            try
            {
                string Sql_GetPhoneArea =
                        "Select AreaID AreaID,  AreaName AreaName,ProvinceID ProvinceID " +
                        "From [dbo].[Area]";

                SqlCommand cmd = new SqlCommand();
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = Sql_GetPhoneArea;

                // 获取数据
                tmpData = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);

                // 数据转换
                // DataSet --> PhoneAreaData
                int intTargetColumnCount = phoneareaData.Tables[PhoneAreaData.TableName].Columns.Count;
                foreach (DataRow row in tmpData.Tables[0].Rows)
                {
                    object[] newRow = new object[intTargetColumnCount];
                    for (int j = 0; j < intTargetColumnCount; j++)
                    {
                        newRow[j] = row[j];
                    }
                    phoneareaData.Tables[PhoneAreaData.TableName].Rows.Add(newRow);
                }
            }
            catch (Exception Ex)
            {
                throw Ex;
            }

            return phoneareaData;
        }