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